库存简易管理系统表

,序号日期入库单编号供应商供应商编号商品名称商品编号规格单位数量单价金额经办人库位备注,1.043525.0660012.0供应商1GYS001,2.043526.0660013.0供应商2GYS002800002.0250*500*200200.02400.0A002,3.043527.0660014.0供应商3GYS003800003.0500*500*6001500.0A003,4.043528.0660015.0供应商4GYS004橡胶手套800004.0L号盒20.02000.0A004,43529.0660016.0供应商5GYS005800005.01000*120060.06000.0A005,6.043530.0660017.0供应商6GYS006800006.01000*160070.07000.0A006,7.043531.0660018.0供应商7GYS007800007.01000*210090.09000.0A007,8.043532.0660019.0供应商8GYS008棉手套800008.0L号盒A008,9.043533.0660020.0供应商9GYS009标签800009.040*100卷18.01800.0A009,43534.0660021.0供应商10GYS010,11.043535.0660022.0供应商2GYS002800010.0250*320（铝）10000.0B001,43536.0660023.0供应商3GYS003800011.0100*500（铝）500.02500.0B002,13.043537.0660024.0供应商4GYS004,14.043538.0660025.0供应商5GYS005800002.0250*500*200200.02400.0A002,43539.0660026.0供应商6GYS006800003.0500*500*6001500.0A003,16.043540.0660027.0供应商7GYS007800010.0250*320（铝）10000.0B001,17.043541.0660028.0供应商8GYS008800011.0100*500（铝）500.02500.0B002,序号商品名称商品编号规格单位入库数量金额备注,1.0800001.0200*500*200300.03000.0,2.0800002.0250*500*200400.04800.0,3.0800003.0500*500*600200.03000.0,4.0橡胶手套800004.0L号盒2000.0,5.0800005.01000*12006000.0,6.0800006.01000*16007000.0,7.0800007.01000*21009000.0,8.0棉手套800008.0L号盒1000.0,9.0标签800009.040*100卷1800.0,10.0板材800010.0250*320（铝）包2000.020000.0,11.0板材800011.0100*500（铝）包1000.05000.0,序号日期出库单编号商品名称商品编号规格单位出库数量单价金额经办人备注,1.043539.0990001.0800001.0200*500*200,2.043540.0990002.0800002.0250*500*20012.0600.0,3.043541.0990003.0800003.0500*500*60015.0750.0,4.043542.0990004.0橡胶手套800004.0L号盒20.01000.0,5.043543.0990005.0800005.01000*120060.03000.0,6.043544.0990006.0800006.01000*160070.03500.0,7.043545.0990007.0800007.01000*210090.04500.0,8.043546.0990008.0棉手套800008.0L号盒,9.043547.0990009.0标签800009.040*100卷18.0900.0,43548.0990010.0板材800010.0250*320（铝）包5000.0,11.043549.0990011.0板材800011.0100*500（铝）包5.02500.0,序号商品名称商品编号规格单位出库数量金额备注,1.0800001.0200*500*200,2.0800002.0250*500*200600.0,3.0800003.0500*500*600750.0,4.0橡胶手套800004.0L号盒1000.0,5.0800005.01000*12003000.0,6.0800006.01000*16003500.0,7.0800007.01000*21004500.0,8.0棉手套800008.0L号盒,9.0标签800009.040*100卷900.0,10.0板材800010.0250*320（铝）包5000.0,11.0板材800011.0100*500（铝）包2500.0,序号商品名称商品编号规格单位前WIP入库数量出库数量现WIP库位备注,1.0800001.0200*500*200300.0350.0A001,2.0800002.0250*500*200400.0450.0A002,3.0800003.0500*500*600200.0250.0A003,4.0橡胶手套800004.0L号盒A004,5.0800005.01000*1200A005,6.0800006.01000*1600A006,7.0800007.01000*2100A007,8.0棉手套800008.0L号盒A008,9.0标签800009.040*100卷A009,10.0板材800010.0250*320（铝）包2000.0500.01600.0B001常备库存1000,11.0板材800011.0100*500（铝）包1000.0500.0600.0B002常备库存500