出入库自动管理系统表

出入库自动管理系统,入库单据录入出库单据录入库存信息,单一产品快速查询,品名品名1库位A101,入库数量3015.0库存1600.0,出库数量1515.0,备注：查询时需输入品名,入库单据录入,序号日期品名产品编号入库数量状态库位入库单号操作人备注,1.043467.01000.0H100011,2.043475.01001.0H100012,3.043511.01002.0H100013,4.043528.0品名4JQ0041003.0A104H100014,5.043532.0品名5JQ0051004.0A105H100015,6.043542.01005.0H100016,7.043557.01006.0H100017,8.043565.01007.0H100018,9.043580.0品名4JQ0041008.0A104H100019,10.043594.0品名5JQ0051009.0A105H100020,11.043620.01010.0H100021,12.043624.01011.0H100022,13.043631.01012.0入库中H100023,出库单据录入,序号日期品名产品编号出库数量状态库位出库单号操作人备注,1.043467.0500.0H100011,2.043475.0501.0H100012,3.043511.0502.0H100013,4.043528.0品名4JQ004503.0A104H100014,5.043532.0品名5JQ005504.0A105H100015,6.043542.0505.0H100016,7.043557.0506.0H100017,8.043565.0507.0H100018,9.043580.0品名4JQ004508.0A104H100019,10.043594.0品名5JQ005509.0A105H100020,11.043620.0510.0H100021,12.043624.0511.0H100022,13.043631.0512.0出库中H100023,库存信息,序号品名产品编号库位前库存入库数量出库数量现库存备注,1.0品名1JQ001A101100.03015.01515.01600.0,2.0品名2JQ002A102200.03018.01518.01700.0,3.0品名3JQ003A103150.03021.01521.01650.0,4.0品名4JQ004A104140.02011.01011.01140.0,5.0品名5JQ005A105150.02013.01013.01150.0,