仓库管理表

,序号月份条码明细日期品名型号规格单位入库数库位确认人待料天数呆料天数备注,JA000000001,JA000000002,3.0JA000000003,4.0JA000000004,5.0JA000000005,6.0JA000000006,7.0JA000000007,8.0JA000000008,9.0JA000000009,10.0JA000000010,11.0JA000000011,12.0JA000000012,13.0JA000000013,14.0JA000000014,15.0JA000000015,16.0JA000000016332.0,17.0JA000000017332.0,18.0JA000000018,19.0JA000000019,20.0JA000000020,21.0JA000000021,22.0JA000000022,23.0JA000000023,24.0JA000000024,25.0JA000000025,26.0JA000000026,27.0JA000000027,28.0JA000000028,29.0JA000000029,30.0JA000000030,31.0JA000000031,32.0JA000000032,33.0JA000000033,34.0JA000000034,35.0JA000000035,36.0JA000000036,37.0JA000000037,38.0JA000000038,39.0JA000000039,40.0JA000000040,41.0JA000000041,42.0JA000000042,43.0JA000000043,44.0JA000000044,45.0JA000000045,46.0JA000000046,47.0JA000000047,48.0JA000000048,49.0JA000000049,50.0JA000000050,51.0JA000000051,52.0JA000000052,53.0JA000000053,54.0JA000000054,55.0JA000000055,56.0JA000000056,57.0JA000000057,58.0JA000000058,59.0JA000000059331.0,60.0JA000000060,61.0JA000000061,62.0JA000000062,63.0JA000000063,64.0JA000000064,65.0JA000000065,66.0JA000000066,67.0JA000000067,68.0JA000000068,69.0JA000000069,70.0JA000000070,71.0JA000000071,72.0JA000000072,73.0JA000000073,74.0JA000000074,75.0JA000000075,76.0JA000000076,77.0JA000000077,78.0JA000000078,79.0JA000000079,80.0JA000000080,81.0JA000000081,82.0JA000000082,83.0JA000000083,84.0JA000000084,85.0JA000000085,86.0JA000000086,87.0JA000000087,88.0JA000000088,89.0JA000000089,90.0JA000000090,91.0JA000000091,92.0JA000000092,93.0JA000000093,94.0JA000000094,95.0JA000000095,96.0JA000000096,97.0JA000000097,98.0JA000000098,99.0JA000000099,100.0JA000000100,101.0JA000000101,102.0JA000000102,103.0JA000000103,104.0JA000000104,105.0JA000000105,106.0JA000000106,107.0JA000000107,108.0JA000000108,109.0JA000000109,110.0JA000000110,111.0JA000000111,112.0JA000000112,113.0JA000000113,114.0JA000000114,115.0JA000000115,116.0JA000000116,117.0JA000000117,118.0JA000000118,119.0JA000000119,120.0JA000000120,121.0JA000000121,122.0JA000000122,123.0JA000000123,124.0JA000000124,125.0JA000000125,126.0JA000000126,127.0JA000000127,128.0JA000000128,129.0JA000000129,130.0JA000000130,131.0JA000000131,132.0JA000000132,133.0JA000000133,134.0JA000000134,135.0JA000000135,136.0JA000000136,137.0JA000000137,138.0JA000000138,139.0JA000000139,140.0JA000000140,141.0JA000000141,142.0JA000000142,143.0JA000000143,144.0JA000000144,145.0JA000000145,146.0JA000000146,147.0JA000000147,148.0JA000000148,149.0JA000000149,150.0JA000000150,151.0JA000000151,152.0JA000000152,153.0JA000000153,154.0JA000000154,155.0JA000000155,156.0JA000000156,157.0JA000000157,158.0JA000000158,159.0JA000000159,160.0JA000000160,161.0JA000000161,序号品名型号规格入库数量入料汇总统计（按日、月）,43466.043467.043468.043469.043470.043471.043472.043473.043474.043475.043476.043477.043478.043479.043480.043481.043482.043483.043484.043485.043486.043487.043488.043489.043490.043491.043492.043493.043494.043495.043496.01.043497.043498.043499.043500.043501.043502.043503.043504.043505.043506.043507.043508.043509.043510.043511.043512.043513.043514.043515.043516.043517.043518.043519.043520.043521.043522.043523.043524.02.043525.043526.043527.043528.043529.043530.043531.043532.043533.043534.043535.043536.043537.043538.043539.043540.043541.043542.043543.043544.043545.043546.043547.043548.043549.043550.043551.043552.043553.043554.043555.03.043556.043557.043558.043559.043560.043561.043562.043563.043564.043565.043566.043567.043568.043569.043570.043571.043572.043573.043574.043575.043576.043577.043578.043579.043580.043581.043582.043583.043584.043585.043586.043587.043588.043589.043590.043591.043592.043593.043594.043595.043596.043597.043598.043599.043600.043601.043602.043603.043604.043605.043606.043607.043608.043609.043610.043611.043612.043613.043614.043615.043616.043617.043618.043619.043620.043621.043622.043623.043624.043625.043626.043627.043628.043629.043630.043631.043632.043633.043634.043635.043636.043637.043638.043639.043640.043641.043642.043643.043644.043645.043646.043647.043648.043649.043650.043651.043652.043653.043654.043655.043656.043657.043658.043659.043660.043661.043662.043663.043664.043665.043666.043667.043668.043669.043670.043671.043672.043673.043674.043675.043676.043677.07.043678.043679.043680.043681.043682.043683.043684.043685.043686.043687.043688.043689.043690.043691.043692.043693.043694.043695.043696.043697.043698.043699.043700.043701.043702.043703.043704.043705.043706.043707.043708.043709.043710.043711.043712.043713.043714.043715.043716.043717.043718.043719.043720.043721.043722.043723.043724.043725.043726.043727.043728.043729.043730.043731.043732.043733.043734.043735.043736.043737.043738.09.043739.043740.043741.043742.043743.043744.043745.043746.043747.043748.043749.043750.043751.043752.043753.043754.043755.043756.043757.043758.043759.043760.043761.043762.043763.043764.043765.043766.043767.043768.043769.043770.043771.043772.043773.043774.043775.043776.043777.043778.043779.043780.043781.043782.043783.043784.043785.043786.043787.043788.043789.043790.043791.043792.043793.043794.043795.043796.043797.043798.043799.043800.043801.043802.043803.043804.043805.043806.043807.043808.043809.043810.043811.043812.043813.043814.043815.043816.043817.043818.043819.043820.043821.043822.043823.043824.043825.043826.043827.043828.043829.043830.0,1.0KPF-A,2.020.0,3.0KPF-B,KPF-C,24.0,7.0KPF-D,9.0,序号月份条码明细日期品名型号规格单位出库数库位确认人备注,JA000000001,JA000000002,3.0JA000000003,4.0JA000000004,5.0JA000000005,6.0JA000000006,7.0JA000000007,8.0JA000000008,9.0JA000000009,10.0JA000000010,11.0JA000000011,12.0JA000000012,13.0JA000000013,14.0JA000000014,15.0JA000000015,16.0JA000000018,17.0JA000000019,18.0JA000000020,19.0JA000000021,20.0JA000000022,21.0JA000000023,22.0JA000000024,23.0JA000000025,24.0JA000000026,25.0JA000000027,26.0JA000000028,27.0JA000000029,28.0JA000000030,29.0JA000000031,30.0JA000000032,31.0JA000000033,32.0JA000000034,33.0JA000000035,34.0JA000000036,35.0JA000000037,36.0JA000000038,37.0JA000000039,38.0JA000000040,39.0JA000000041,40.0JA000000042,41.0JA000000043,42.0JA000000044,43.0JA000000045,44.0JA000000046,45.0JA000000047,46.0JA000000048,47.0JA000000049,48.0JA000000050,49.0JA000000051,50.0JA000000052,51.0JA000000053,52.0JA000000054,53.0JA000000055,54.0JA000000056,55.0JA000000057,56.0JA000000058,57.0JA000000060,58.0JA000000061,59.0JA000000062,60.0JA000000063,61.0JA000000064,62.0JA000000065,63.0JA000000066,64.0JA000000067,65.0JA000000068,66.0JA000000069,67.0JA000000070,68.0JA000000071,69.0JA000000072,70.0JA000000073,71.0JA000000074,72.0JA000000075,73.0JA000000076,74.0JA000000077,75.0JA000000078,76.0JA000000079,77.0JA000000080,78.0JA000000081,79.0JA000000082,80.0JA000000083,81.0JA000000084,82.0JA000000085,83.0JA000000086,84.0JA000000087,85.0JA000000088,86.0JA000000089,87.0JA000000090,88.0JA000000091,89.0JA000000092,90.0JA000000093,91.0JA000000094,92.0JA000000095,93.0JA000000096,94.0JA000000097,95.0JA000000098,96.0JA000000099,97.0JA000000100,98.0JA000000101,99.0JA000000102,100.0JA000000103,101.0JA000000104,102.0JA000000105,103.0JA000000106,104.0JA000000107,105.0JA000000108,106.0JA000000109,107.0JA000000110,108.0JA000000111,109.0JA000000112,110.0JA000000113,111.0JA000000114,112.0JA000000115,113.0JA000000116,114.0JA000000117,115.0JA000000118,116.0JA000000119,117.0JA000000120,118.0JA000000121,119.0JA000000122,120.0JA000000123,121.0JA000000124,122.0JA000000125,123.0JA000000126,124.0JA000000127,125.0JA000000128,126.0JA000000129,127.0JA000000130,128.0JA000000131,129.0JA000000132,130.0JA000000133,131.0JA000000134,132.0JA000000135,133.0JA000000136,134.0JA000000137,135.0JA000000138,136.0JA000000139,137.0JA000000140,138.0JA000000141,139.0JA000000142,140.0JA000000143,141.0JA000000144,142.0JA000000145,143.0JA000000146,144.0JA000000147,145.0JA000000148,146.0JA000000149,147.0JA000000150,148.0JA000000151,149.0JA000000152,150.0JA000000153,151.0JA000000154,152.0JA000000155,153.0JA000000156,154.0JA000000157,155.0JA000000158,156.0JA000000159,157.0JA000000160,158.0JA000000161,序号品名型号规格出库数量出库汇总统计（按日、月）,43466.043467.043468.043469.043470.043471.043472.043473.043474.043475.043476.043477.043478.043479.043480.043481.043482.043483.043484.043485.043486.043487.043488.043489.043490.043491.043492.043493.043494.043495.043496.01.043497.043498.043499.043500.043501.043502.043503.043504.043505.043506.043507.043508.043509.043510.043511.043512.043513.043514.043515.043516.043517.043518.043519.043520.043521.043522.043523.043524.02.043525.043526.043527.043528.043529.043530.043531.043532.043533.043534.043535.043536.043537.043538.043539.043540.043541.043542.043543.043544.043545.043546.043547.043548.043549.043550.043551.043552.043553.043554.043555.03.043556.043557.043558.043559.043560.043561.043562.043563.043564.043565.043566.043567.043568.043569.043570.043571.043572.043573.043574.043575.043576.043577.043578.043579.043580.043581.043582.043583.043584.043585.043586.043587.043588.043589.043590.043591.043592.043593.043594.043595.043596.043597.043598.043599.043600.043601.043602.043603.043604.043605.043606.043607.043608.043609.043610.043611.043612.043613.043614.043615.043616.043617.043618.043619.043620.043621.043622.043623.043624.043625.043626.043627.043628.043629.043630.043631.043632.043633.043634.043635.043636.043637.043638.043639.043640.043641.043642.043643.043644.043645.043646.043647.043648.043649.043650.043651.043652.043653.043654.043655.043656.043657.043658.043659.043660.043661.043662.043663.043664.043665.043666.043667.043668.043669.043670.043671.043672.043673.043674.043675.043676.043677.07.043678.043679.043680.043681.043682.043683.043684.043685.043686.043687.043688.043689.043690.043691.043692.043693.043694.043695.043696.043697.043698.043699.043700.043701.043702.043703.043704.043705.043706.043707.043708.043709.043710.043711.043712.043713.043714.043715.043716.043717.043718.043719.043720.043721.043722.043723.043724.043725.043726.043727.043728.043729.043730.043731.043732.043733.043734.043735.043736.043737.043738.09.043739.043740.043741.043742.043743.043744.043745.043746.043747.043748.043749.043750.043751.043752.043753.043754.043755.043756.043757.043758.043759.043760.043761.043762.043763.043764.043765.043766.043767.043768.043769.043770.043771.043772.043773.043774.043775.043776.043777.043778.043779.043780.043781.043782.043783.043784.043785.043786.043787.043788.043789.043790.043791.043792.043793.043794.043795.043796.043797.043798.043799.043800.043801.043802.043803.043804.043805.043806.043807.043808.043809.043810.043811.043812.043813.043814.043815.043816.043817.043818.043819.043820.043821.043822.043823.043824.043825.043826.043827.043828.043829.043830.0,1.0KPF-A26.0,2.020.0,3.0KPF-B,28.0,KPF-C,23.013.013.0,7.0KPF-D,28.0,9.0,序号品名型号规格单位原库存入库数量出库数量现库存备注,1.0KPF-A50.026.052.0当库存少于100时显示黄色提示,2.020.020.0,3.0KPF-B,4.0,5.0KPF-C12.012.0,6.024.023.0当库存少于30时显示黄色提示,7.0KPF-D,8.0,9.0,序号型号规格单位呆料时间＞20天原因分析处理对策责任人完成期限状态备注,1.0KPF-A2.0通道堵塞移动物料有限出货张三43590.0Close,2.0KPF-A,3.0KPF-B,4.0KPF-B,5.0KPF-C,6.0KPF-C1.0通道堵塞移动物料有限出货张三43590.0Ongoing未出货,7.0KPF-D,8.0KPF-D,9.0,10.0,11.0,12.0,13.0,14.0,15.0