半成品仓库便捷管理表

,序号品名供应商型号规格供应周期备注,1.0裕兴PY0001,2.0裕兴PY0002,3.0双星PS0001,4.0双星PS0002,5.0东方PD0001,6.0东方PD0002,7.0南洋PN0001,8.0南洋PN0002,9.0阿克玛FA0001,10.0阿克玛FA0002,11.0SKCFS0001,12.0SKCFS0002,13.0杭福FH0001,14.0杭福FH0002,序号月份条码明细日期品名型号规格单位入库数库位待料天数呆料天数备注,B000000001,B000000002,3.0B000000003,4.0B000000004,5.0B000000005,6.0B000000006,7.0B000000007,8.0B000000008,9.0B000000009,10.0B000000010,11.0B000000011,12.0B000000012,13.0B000000013,14.0B000000014,15.0B000000015324.0,16.0B000000016,17.0B000000017,18.0B000000018,19.0B000000019,20.0B000000020,21.0B000000021,22.0B000000022,23.0B000000023,24.0B000000024,25.0B000000025,26.0B000000026,27.0B000000027,28.0B000000028,29.0B000000029,30.0B000000030,31.0B000000031,32.0B000000032,33.0B000000033,34.0B000000034,35.0B000000035,36.0B000000036,37.0B000000037,38.0B000000038,39.0B000000039,40.0B000000040,41.0B000000041,42.0B000000042,43.0B000000043,44.0B000000044,45.0B000000045,46.0B000000046,47.0B000000047,48.0B000000048,49.0B000000049,50.0B000000050,51.0B000000051,52.0B000000052,53.0B000000053,54.0B000000054,55.0B000000055,56.0B000000056,57.0B000000057,58.0B000000058,59.0B000000059,60.0B000000060,61.0B000000061,62.0B000000062,63.0B000000063,64.0B000000064,65.0B000000065,66.0B000000066,67.0B000000067,68.0B000000068,69.0B000000069,70.0B000000070,71.0B000000071,72.0B000000072,73.0B000000073,74.0B000000074,75.0B000000075,76.0B000000076,77.0B000000077,78.0B000000078,79.0B000000079,80.0B000000080,81.0B000000081,82.0B000000082,83.0B000000083,84.0B000000084,85.0B000000085,86.0B000000086,87.0B000000087,88.0B000000088,89.0B000000089,90.0B000000090,91.0B000000091,92.0B000000092,93.0B000000093,94.0B000000094,95.0B000000095,96.0B000000096,97.0B000000097,98.0B000000098,99.0B000000099,100.0B000000100,101.0B000000101,102.0B000000102,103.0B000000103,104.0B000000104,105.0B000000105,106.0B000000106,107.0B000000107,108.0B000000108,109.0B000000109,110.0B000000110,111.0B000000111,112.0B000000112,113.0B000000113,114.0B000000114,115.0B000000115,116.0B000000116,117.0B000000117,118.0B000000118,119.0B000000119,120.0B000000120,121.0B000000121,122.0B000000122,123.0B000000123,124.0B000000124,125.0B000000125,126.0B000000126,127.0B000000127,128.0B000000128,129.0B000000129,130.0B000000130,131.0B000000131,132.0B000000132,133.0B000000133,134.0B000000134,135.0B000000135,136.0B000000136,137.0B000000137,138.0B000000138,139.0B000000139,140.0B000000140,141.0B000000141,142.0B000000142,143.0B000000143,144.0B000000144,145.0B000000145,146.0B000000146,147.0B000000147,148.0B000000148,149.0B000000149,150.0B000000150,151.0B000000151,152.0B000000152,153.0B000000153,154.0B000000154,155.0B000000155,156.0B000000156,157.0B000000157,158.0B000000158,159.0B000000159,160.0B000000160,161.0B000000161,162.0B000000162,163.0B000000163,164.0B000000164,165.0B000000165,166.0B000000166,167.0B000000167,168.0B000000168,169.0B000000169,170.0B000000170,171.0B000000171,172.0B000000172,173.0B000000173292.0,174.0B000000174,175.0B000000175,176.0B000000176,177.0B000000177,178.0B000000178,179.0B000000179,180.0B000000180,181.0B000000181,182.0B000000182,183.0B000000183,184.0B000000184,185.0B000000185,186.0B000000186,187.0B000000187,188.0B000000188,189.0B000000189,190.0B000000190,191.0B000000191,192.0B000000192,193.0B000000193,194.0B000000194,195.0B000000195,196.0B000000196,197.0B000000197,198.0B000000198,199.0B000000199,200.0B000000200,201.0B000000201,202.0B000000202,203.0B000000203,204.0B000000204,205.0B000000205,206.0B000000206,207.0B000000207,208.0B000000208,209.0B000000209,210.0B000000210,211.0B000000211,212.0B000000212,213.0B000000213,214.0B000000214,215.0B000000215,216.0B000000216,217.0B000000217,218.0B000000218,219.0B000000219,220.0B000000220,221.0B000000221,222.0B000000222,223.0B000000223,224.0B000000224,225.0B000000225,226.0B000000226,227.0B000000227,228.0B000000228,229.0B000000229,230.0B000000230,231.0B000000231,232.0B000000232,233.0B000000233,234.0B000000234,235.0B000000235,236.0B000000236,237.0B000000237,238.0B000000238291.0,239.0B000000239,240.0B000000240,序号品名型号规格入库数量每月入库数量,1.02.03.07.011.0,1.0PETPY000124.0,2.0PY000228.0,3.0PS000128.0,PS0002,PD0001,PD0002,7.0PN000140.0,PN0002,PVDFFA0001,FA0002,11.0FS0001,FS0002,13.0FH0001,FH000216.0,15.0,序号月份条码明细日期品名型号规格单位出库数库位领料人确认人备注,B000000001,B000000002,3.0B000000003,4.0B000000004,5.0B000000005,6.0B000000006,7.0B000000007,8.0B000000008,9.0B000000009,10.0B000000010,11.0B000000011,12.0B000000012,13.0B000000013,14.0B000000014,15.0B000000016,16.0B000000017,17.0B000000018,18.0B000000019,19.0B000000020,20.0B000000021,21.0B000000022,22.0B000000023,23.0B000000024,24.0B000000025,25.0B000000026,26.0B000000027,27.0B000000028,28.0B000000029,29.0B000000030,30.0B000000031,31.0B000000032,32.0B000000033,33.0B000000034,34.0B000000035,35.0B000000036,36.0B000000037,37.0B000000038,38.0B000000039,39.0B000000040,40.0B000000041,41.0B000000042,42.0B000000043,43.0B000000044,44.0B000000045,45.0B000000046,46.0B000000047,47.0B000000048,48.0B000000049,49.0B000000050,50.0B000000051,51.0B000000052,52.0B000000053,53.0B000000054,54.0B000000055,55.0B000000056,56.0B000000057,57.0B000000058,58.0B000000059,59.0B000000060,60.0B000000061,61.0B000000062,62.0B000000063,63.0B000000064,64.0B000000065,65.0B000000066,66.0B000000067,67.0B000000068,68.0B000000069,69.0B000000070,70.0B000000071,71.0B000000072,72.0B000000073,73.0B000000074,74.0B000000075,75.0B000000076,76.0B000000077,77.0B000000078,78.0B000000079,79.0B000000080,80.0B000000081,81.0B000000082,82.0B000000083,83.0B000000084,84.0B000000085,85.0B000000086,86.0B000000087,87.0B000000088,88.0B000000089,89.0B000000090,90.0B000000091,91.0B000000092,92.0B000000093,93.0B000000094,94.0B000000095,95.0B000000096,96.0B000000097,97.0B000000098,98.0B000000099,99.0B000000100,100.0B000000101,101.0B000000102,102.0B000000103,103.0B000000104,104.0B000000105,105.0B000000106,106.0B000000107,107.0B000000108,108.0B000000109,109.0B000000110,110.0B000000111,111.0B000000112,112.0B000000113,113.0B000000114,114.0B000000115,115.0B000000116,116.0B000000117,117.0B000000118,118.0B000000119,119.0B000000120,120.0B000000121,121.0B000000122,122.0B000000123,123.0B000000124,124.0B000000125,125.0B000000126,126.0B000000127,127.0B000000128,128.0B000000129,129.0B000000130,130.0B000000131,131.0B000000132,132.0B000000133,133.0B000000134,134.0B000000135,135.0B000000136,136.0B000000137,137.0B000000138,138.0B000000139,139.0B000000140,140.0B000000141,141.0B000000142,142.0B000000143,143.0B000000144,144.0B000000145,145.0B000000146,146.0B000000147,147.0B000000148,148.0B000000149,149.0B000000150,150.0B000000151,151.0B000000152,152.0B000000153,153.0B000000154,154.0B000000155,155.0B000000156,156.0B000000157,157.0B000000158,158.0B000000159,159.0B000000160,160.0B000000161,161.0B000000162,162.0B000000163,163.0B000000164,164.0B000000165,165.0B000000166,166.0B000000167,167.0B000000168,168.0B000000169,169.0B000000170,170.0B000000171,171.0B000000172,172.0B000000174,173.0B000000175,174.0B000000176,175.0B000000177,176.0B000000178,177.0B000000179,178.0B000000180,179.0B000000181,180.0B000000182,181.0B000000183,182.0B000000184,183.0B000000185,184.0B000000186,185.0B000000187,186.0B000000188,187.0B000000189,188.0B000000190,189.0B000000191,190.0B000000192,191.0B000000193,192.0B000000194,193.0B000000195,194.0B000000196,195.0B000000197,196.0B000000198,197.0B000000199,198.0B000000200,199.0B000000201,200.0B000000202,201.0B000000203,202.0B000000204,203.0B000000205,204.0B000000206,205.0B000000207,206.0B000000208,207.0B000000209,208.0B000000210,209.0B000000211,210.0B000000212,211.0B000000213,212.0B000000214,213.0B000000215,214.0B000000216,215.0B000000217,216.0B000000218,217.0B000000219,218.0B000000220,219.0B000000221,220.0B000000222,221.0B000000223,222.0B000000224,223.0B000000225,224.0B000000226,225.0B000000227,226.0B000000228,227.0B000000229,228.0B000000230,229.0B000000231,230.0B000000232,231.0B000000233,232.0B000000234,233.0B000000235,234.0B000000236,235.0B000000237,236.0B000000239,237.0B000000240,序号品名型号规格出库数量每月出库数量,1.02.03.07.011.0,1.0PETPY000124.0,2.0PY000227.013.0,3.0PS000128.0,PS000218.0,PD000118.0,PD0002,7.0PN000140.0,PN0002,PVDFFA0001,FA0002,11.0FS0001,FS0002,13.0FH000117.0,FH000216.0,15.0,序号品名型号规格单位原库存入库数量出库数量现库存备注,1.0PETPY000124.024.0,2.0PY000227.041.0当库存少于50时显示黄的提示,3.0PS0001,4.0PS0002,PD0001,PD0002当库存少于20时显示黄的提示,7.0PN0001,PN000220.020.0,9.0PVDFFA0001,FA0002,FS0001,FS00024.051.0,FH000117.051.0,FH000216.016.0,日期型号规格生产计划实际入库出库数量差异备注,PY000115.012.011.01.0,PY000212.0,PS0001,PS0002,PD0001,PD0002,PN0001,PN0002,FA0001,FA0002,FS0001,FS0002,FH0001,FH0002,PY00011.0-1.0,PY000213.0-13.0,PS0001-14.0,PS0002-9.0,PD0001,PD00024.04.0,PN000120.020.0,PN000210.010.0,FA0001,FA00025.05.0,FS0001,FS0002,FH0001-9.0,FH0002-8.0,序号品名型号规格单位呆料时间＞20天原因分析处理对策责任人完成期限状态备注,PETPY0001,2.0PY000243591.0,3.0PS0001,4.0PS0002,5.0PD0001,6.0PD0002,7.0PN0001,8.0PN0002,9.0PVDFFA0001,10.0FA0002,11.0FS0001,12.0FS000243590.0,13.0FH000143590.0,14.0FH0002,15.0