仓库便捷管理成品表

,序号月份条码明细日期品名型号规格单位入库数库位待料天数呆料天数备注,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.0JA000000016323.0,17.0JA000000017323.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.0JA000000059322.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,序号品名型号规格入库数量每月入库数量,1.02.03.07.09.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,序号品名型号规格出库数量每月出库数量,1.02.03.07.09.0,1.0KPF-A26.0,2.020.0,3.0KPF-B,28.0,KPF-C,23.013.0,7.0KPF-D,28.0,9.0,序号品名型号规格单位原库存入库数量出库数量现库存备注,1.0KPF-A80.026.082.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,日期型号规格入库计划实际入库入库差异计划出库实际出库出库差异备注,15.0-1.0,-2.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