公司仓库管理系统表

,序号日期入库单编号供应商供应商编号商品名称商品编号规格单位数量单价金额经办人库位备注,1.043525.0R0000110000.0200000.0,2.043526.0R00002100.0100000.0,3.043527.0R00003供应商3G0003PET树脂膜P001100.0A003,4.043528.0R00004供应商4G0004原胶Y001250kg/桶桶B001,5.043529.0R000055000.0100000.0,6.043530.0R00006,7.043531.0R00007供应商3G0003PET树脂膜P00125000.0A003,8.043532.0R00008供应商4G0004原胶Y001250kg/桶桶25.025000.0B001,9.043533.0R0000910000.0,10.043534.0R0001020000.0,序号商品名称商品编号规格单位入库数量单价金额备注,1.0电池片D001片15500.020.0310000.0,2.0太阳能背板T001卷170.01000.0170000.0,3.0PET树脂膜P001卷150.0500.075000.0,4.0原胶Y001250kg/桶桶75.01000.075000.0,序号日期出库单编号商品名称商品编号规格单位出库数量单价金额领用人经办人备注,1.043529.05000.0100000.0,2.043530.050.050000.0,3.043531.0PET树脂膜P00150.0500.025000.0,4.043532.0原胶Y001250kg/桶桶30.030000.0,5.043533.04000.0,6.043534.080.0,7.043535.0PET树脂膜P00180.0500.040000.0,8.043536.0原胶Y001250kg/桶桶30.030000.0,9.043537.04000.0,10.043538.020000.0,序号商品名称商品编号规格单位出库数量单价金额备注,1.0电池片D001片13000.020.0260000.0,2.0太阳能背板T001卷150.01000.0150000.0,3.0PET树脂膜P001卷130.0500.065000.0,4.0原胶Y001250kg/桶桶60.01000.060000.0,5.0,6.0,7.0,8.0,9.0,10.0,序号商品名称商品编号规格单位原库存入库数量出库数量现库存单价金额库位备注,1.0电池片D001片2000.015500.013000.04500.020.090000.0A001,2.0太阳能背板T001卷59.0170.0150.079.01000.079000.0A002,3.0PET树脂膜P001卷50.0150.0130.070.0500.035000.0A003,4.0原胶Y001250kg/桶桶20.075.060.035.01000.035000.0B001,5.0,6.0,7.0,8.0,9.0,10.0,序号供应商商品名称商品编码规格采购金额占比备注,1.0供应商1电池片D001310000.00.492063492063,2.0供应商2太阳能背板T001170000.00.269841269841,3.0供应商3PET树脂膜P00175000.00.119047619048,4.0供应商4原胶Y001250kg/桶75000.00.119047619048,5.0,6.0,7.0,8.0,9.0,10.0,合计630000.0,序号商品名称商品编码规格型号消耗金额占比备注,1.0电池片D001260000.00.485981308411,2.0太阳能背板T001150000.00.280373831776,3.0PET树脂膜P00165000.00.121495327103,4.0原胶Y001250kg/桶60000.00.11214953271,5.0,6.0,7.0,8.0,9.0,10.0,合计535000.0,序号商品名称商品编码规格库存盘点数量差异备注,1.0电池片D0014500.04450.0-50.0,2.0太阳能背板T00179.079.0,3.0PET树脂膜P00170.070.0,4.0原胶Y001250kg/桶35.035.0,5.0,6.0,7.0,8.0,9.0,10.0,序号商品名称商品编码 规格库位数量,1.0电池片D001A0014000.0,2.0太阳能背板T001A00260.0,3.0PET树脂膜P001A00355.0,4.0原胶Y001250kg/桶B00120.0,5.0电池片D001A001450.0,6.0太阳能背板T001A00219.0,7.0PET树脂膜P001A003,8.0原胶Y001250kg/桶B001,9.0,10.0,11.0,12.0,13.0,14.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0