成品仓管理系统表

,备注：使用扫码枪扫码数据自动上传,序号月份单号条码日期品名型号规格单位数量库位经办人待料日期呆料分析备注,SW000000001,SW000000002,SW000000003,4.0SW000000004,5.0SW000000005,SW000000006,7.0SW000000007,8.0SW00000000842341.0,9.0SW000000009,10.0SW000000010,11.0SW000000011,12.0SW000000012,13.0SW000000013,14.0SW000000014,15.0SW000000015,16.0SW00000001642341.0,17.0SW000000017,18.0SW000000018,19.0SW000000019,20.0SW000000020,21.0SW000000021,22.0SW000000022,23.0SW000000023,24.0SW000000024,25.0SW000000025,26.0SW000000026,27.0SW000000027,28.0SW000000028,29.0SW000000029,30.0SW000000030,31.0SW000000031,32.0SW000000032,33.0SW000000033,34.0SW000000034,35.0SW000000035,36.0SW000000036,37.0SW000000037,38.0SW000000038,39.0SW000000039,40.0SW000000040,41.0SW000000041,42.0SW000000042,43.0SW000000043,44.0SW000000044,45.0SW000000045,46.0SW000000046,47.0SW000000047,48.0SW000000048,49.0SW000000049,50.0SW000000050,51.0SW000000051,52.0SW000000052,53.0SW000000053,54.0SW000000054,55.0SW000000055,56.0SW000000056,57.0SW000000057,58.0SW000000058,59.0SW000000059,60.0SW000000060,61.0SW000000061,62.0SW000000062,63.0SW000000063,64.0SW000000064,65.0SW000000065,66.0SW000000066,67.0SW000000067,68.0SW000000068,69.0SW000000069,70.0SW000000070,71.0SW000000071,72.0SW000000072,73.0SW000000073,74.0SW000000074,75.0SW000000075,76.0SW000000076,77.0SW000000077,78.0SW000000078,79.0SW000000079,80.0SW000000080,81.0SW000000081,82.0SW000000082,83.0SW000000083,84.0SW000000084,85.0SW000000085,86.0SW000000086,87.0SW000000087,88.0SW000000088,89.0SW000000089,90.0SW000000090,91.0SW000000091,92.0SW000000092,93.0SW000000093,94.0SW000000094,95.0SW000000095,96.0SW000000096,97.0SW000000097,98.0SW000000098,99.0SW000000099,100.0SW000000100,101.0SW000000101,102.0SW000000102,103.0SW000000103,104.0SW000000104,105.0SW000000105,106.0SW000000106,107.0SW000000107,108.0SW000000108,109.0SW000000109,110.0SW000000110,111.0SW000000111,112.0SW000000112,113.0SW000000113,114.0SW000000114,115.0SW000000115,116.0SW000000116,117.0SW000000117,118.0SW000000118,119.0SW000000119,120.0SW000000120,121.0SW000000121,122.0SW000000122,123.0SW000000123,124.0SW000000124,125.0SW000000125,126.0SW000000126,127.0SW000000127,128.0SW000000128,129.0SW000000129,130.0SW000000130,131.0SW000000131,132.0SW000000132,133.0SW000000133,134.0SW000000134,135.0SW000000135,136.0SW000000136,137.0SW000000137,138.0SW000000138,139.0SW000000139,序号品名型号规格单位入库汇总（日、月）,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.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.04.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.06.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.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.08.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.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-A20.0,2.0KPF-A,KPF-B,4.0KPF-B18.0,KPF-C,6.0KPF-C24.0,KPF-D16.016.0,8.0KPF-D,备注：使用扫码枪扫码数据自动上传,序号月份单号条码日期品名型号规格单位数量库位经办人备注,SW000000001,SW000000002,3.0SW000000003,4.0SW000000004,5.0SW000000005,6.0SW000000006,7.0SW000000007,8.0SW000000009,9.0SW000000010,10.0SW000000011,11.0SW000000012,12.0SW000000013,13.0SW000000014,14.0SW000000015,15.0SW000000017,16.0SW000000018,17.0SW000000019,18.0SW000000020,19.0SW000000021,20.0SW000000022,21.0SW000000023,22.0SW000000024,23.0SW000000025,24.0SW000000026,25.0SW000000027,26.0SW000000028,27.0SW000000029,28.0SW000000030,29.0SW000000031,30.0SW000000032,31.0SW000000033,32.0SW000000034,33.0SW000000035,34.0SW000000036,35.0SW000000037,36.0SW000000038,37.0SW000000039,38.0SW000000040,39.0SW000000041,40.0SW000000042,41.0SW000000043,42.0SW000000044,43.0SW000000045,44.0SW000000046,45.0SW000000047,46.0SW000000048,47.0SW000000049,48.0SW000000050,49.0SW000000051,50.0SW000000052,51.0SW000000053,52.0SW000000054,53.0SW000000055,54.0SW000000056,55.0SW000000057,56.0SW000000058,57.0SW000000059,58.0SW000000060,59.0SW000000061,60.0SW000000062,61.0SW000000063,62.0SW000000064,63.0SW000000065,64.0SW000000066,65.0SW000000067,66.0SW000000068,67.0SW000000069,68.0SW000000070,69.0SW000000071,70.0SW000000072,71.0SW000000073,72.0SW000000074,73.0SW000000075,74.0SW000000076,75.0SW000000077,76.0SW000000078,77.0SW000000079,78.0SW000000080,79.0SW000000081,80.0SW000000082,81.0SW000000083,82.0SW000000084,83.0SW000000085,84.0SW000000086,85.0SW000000087,86.0SW000000088,87.0SW000000089,88.0SW000000090,89.0SW000000091,90.0SW000000092,91.0SW000000093,92.0SW000000094,93.0SW000000095,94.0SW000000096,95.0SW000000097,96.0SW000000098,97.0SW000000099,98.0SW000000100,99.0SW000000101,100.0SW000000102,101.0SW000000103,102.0SW000000104,103.0SW000000105,104.0SW000000106,105.0SW000000107,106.0SW000000108,107.0SW000000109,108.0SW000000110,109.0SW000000111,110.0SW000000112,111.0SW000000113,112.0SW000000114,113.0SW000000115,114.0SW000000116,115.0SW000000117,116.0SW000000118,117.0SW000000119,118.0SW000000120,119.0SW000000121,120.0SW000000122,121.0SW000000123,122.0SW000000124,123.0SW000000125,124.0SW000000126,125.0SW000000127,126.0SW000000128,127.0SW000000129,128.0SW000000130,129.0SW000000131,130.0SW000000132,131.0SW000000133,132.0SW000000134,133.0SW000000135,134.0SW000000136,135.0SW000000137,136.0SW000000138,137.0SW000000139,序号品名型号规格单位出库汇总（日、月）,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.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.04.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.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.08.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.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.010.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-A10.019.0,2.0KPF-A13.0,KPF-B14.0,4.0KPF-B18.0,KPF-C14.0,KPF-C24.0,KPF-D16.016.0,8.0KPF-D,序号品名型号规格单位前库存入库数量出库数量现库存备注,1.0KPF-A25.0101.0,2.0KPF-A50.017.051.0,3.0KPF-B,4.0KPF-B18.018.0,5.0KPF-C,6.0KPF-C,7.0KPF-D,8.0KPF-D11.011.0,型号规格 日期,项目43466.043467.043468.043469.043470.043471.043472.043473.043474.0,KPF-A,5.0,KPF-B,KPF-C8.0,15.0,2.0,KPF-D20.0,16.0,16.0,11.0,11.0,序号区域库位品名型号规格单位可放置数量状态备注,1.0A区,成品A01-a优先出货,2.0A01-b已放2/3,3.0A02-a,4.0A02-b,5.0A03-a,6.0A03-b,7.0A04-a,8.0A04-b,9.0B区,客退品B01-a,B01-b,11.0B02-a,12.0B02-b,13.0B03-a,14.0B03-b,15.0B04-a,16.0B04-b,序号品名型号规格库位数量,（呆料天数＞50天）原因分析改善方案责任日期责任人状态备注,KPF-AA01-a人员未按先进先出作业转移物料，优先出货43617.0无畏Open,2.0KPF-AA01-b人员未按先进先出作业转移物料，优先出货43617.0无畏Open,3.0KPF-BA02-a,4.0KPF-BA02-b,5.0KPF-CA03-a,6.0KPF-CA03-b,7.0KPF-DA04-a,8.0KPF-DA04-b