5d15dfc8d390b.xlsx

出出入入库库管管理理系系统统基基 础础 资资 料料入入 库库 明明 细细出出 库库 明明 细细库库 存存 盘盘 点点出出入入库库管管理理系系统统 商商品品基基础础资资料料序序号号物料编码货品类别物料名称型号/规格单位期初库存1 1编码1文具马克笔盒个102 2编码2文具本子箱本203 3编码3304 4编码4405 5编码5506 6编码6607 7编码7708 8编码8709 9编码9701010编码10701111编码11701212编码12701313编码13701414编码14701515编码15701616编码16701717编码17701818编码18701919编码19702020编码207021212222232324242525262627272828292930303131323233333434353536363737383839394040414142424343444445454646474748484949505051515252535354545555565657575858595960606161626263636464656566666767686869697070717172727373747475757676777778787979808081818282838384848585868687878888898990909191929293939494959596969797989899991001002019/6/282019/6/28 17:3317:33安全库存储存位置备 注100a1100a2100a3100a4100a5100b1100b2100b3100b4100b5100c1100c2100c3100c4100c5100d1100d2100d3100d4100d5 入入库库明明细细表表序序号号日日 期期供供货货商商生生产产批批号号采采购购订订单单单单据据号号码码货货品品编编码码货货品品类类别别货货品品名名称称1 12019/529单据1编编码码1 1文具马克笔2 22019/5/30单据2编编码码2 2文具本子3 34 45 56 67 78 89 9101011111212131314141515161617171818191920202019/6/282019/6/28 17:3317:33规规格格型型号号单单位位入入库库数数量量备备 注注盒个500500箱本600600 入入库库明明细细表表 出出库库明明细细表表序序号号日日 期期客客 户户合合同同编编号号单单据据号号码码货货品品编编码码货货品品类类别别1 12019/6/29客户1单据1编编码码1 1文具2 23 34 45 56 67 78 89 9101011111212131314141515161617171818191920202019/6/282019/6/28 17:3317:33货货品品名名称称规规格格型型号号单单位位出出库库数数量量备备 注注马克笔盒个5050 出出库库明明细细表表 库库存存盘盘点点表表序序号号货货品品编编码码货货品品类类别别货货品品名名称称规规格格型型号号单单位位上上月月结结存存本本月月进进仓仓本本月月出出仓仓1 1编码1文具马克笔盒个10102 2编码2文具本子箱本20203 3编码3000030304 4编码4000040405 5编码5000050506 6编码6000060607 7编码7000070708 8编码8000070709 9编码9000070701010编码10000070701111编码11000070701212编码12000070701313编码13000070701414编码14000070701515编码15000070701616编码16000070701717编码17000070701818编码18000070701919编码19000070702020编码20000070702019/6/282019/6/28 17:3317:33期期末末结结存存储储位位安安全全库库存存申申购购数数量量库库存存预预警警账账面面数数量量实实盘盘数数量量盈盈亏亏数数量量备备 注注1010a1a11001009090报警101020002000199019902020a2a21001008080报警3030a3a31001007070报警4040a4a41001006060报警5050a5a51001005050报警6060b1b11001004040报警7070b2b21001003030报警7070b3b31001003030报警7070b4b41001003030报警7070b5b51001003030报警7070c1c11001003030报警7070c2c21001003030报警7070c3c31001003030报警7070c4c41001003030报警7070c5c51001003030报警7070d1d11001003030报警7070d2d21001003030报警7070d3d31001003030报警7070d4d41001003030报警7070d5d51001003030报警 库库存存盘盘点点表表