{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[14,3,14,4],[15,3,15,4],[16,5,16,7]]}
["采购 -> 入库 -> 出库"]
[]
["仓库表 (warehouse)","id / warehouse_id","warehouse_type","warehouse_name","create_time","update_time"]
[null,null,"仓库类型 (枚举)(不可编辑)","仓库名称"]
[null,null,"1“normal”（正常）类型表示库存中的物品处于良好状态，没有任何问题或缺陷。"]
[null,null,"2“reservation”（预订）类型表示物品已经被预订，未来将被出库分配给特定的客户或订单。"]
[null,null,"3“defective”（有缺陷）类型表示该物品在库存中有一些问题或缺陷，无法按照正常的标准出售或使用。"]
[null,null,"4“missing”（丢失）类型表示物品在库存中丢失或无法找到。这可能是因为错误的记录、货物被盗或其他原因导致的物品的缺失。"]
[]
[null,"关联","Shelf Qty(shelf_qty)","SKU(sku_count)","Stock(stock_count)","Stock(stock_amount)","Stock Day (stock_day)"]
[null,null,"货位数量统计","商品数量统计","库存数量统计","库存金额统计","库存天数(待定)"]
[]
[]
[]
["仓库货位表 (warehouse_shelf)","id / warehouse_shelf_id","Shelf Type (shelf_type)","warehouse_id (显示warehouse_name)",null,"shelf_floor","shelf_row","shelf_cloumn","create_time","update_time"]
["(仓库不可更改)",null,"仓库货位类型 (枚举)","关联显示仓库名称 (wh_id 不可编辑)",null,"货位_楼层","货位_列","货位_行"]
["批量添加货架位 (上传 Excel)",null,"1 Sellable Shelf（可销售货架）：用于存放可销售的商品，或符合销售标准的物品。",null,null,"合并成一个字段 Location (示例值：F1-R1-C2)"]
[null,null,"2 Unsellable Shelf（不可销售货架）：用于存放不符合销售标准或者无法销售的商品，如过期商品、有损坏的物品等。"]
[]
[null,"关联","status"]
[null,null,"货架位状态 (计算)","SKU(sku_count)","Stock(stock_count)","Stock(stock_price_count)"]
[null,null,"Empty: SKU = 0；​Stored: SKU ≥ 1；​Clearable: SKU ≥ 1 and Stock=0","商品规格数量统计","库存数量统计","库存金额统计"]
[null,null,null,"(以商品ID为单位，统计其下所有规格的数量)"]
[]
[]
["仓库货位与商品关系表 (warehouse_shelf_good_relation)","id","warehouse_shelf_id","good_id","is_priority"]
["(只有绑定与解绑，不可编辑)",null,"仓库货位ID","商品ID","是否设置为优先货位"]
[]
[]
[]
["仓库操作记录表 (warehouse_operation_record)","id","warehouse_id","warehouse_shelf_id","good_id","reason","operation_type","stock","operator","notes","create_time","update_time"]
["(不可删除，不可编辑)",null,"仓库ID","仓库货位ID","商品ID","原因 (枚举)","操作类型 (枚举)","操作数量","经办人","备注","操作时间"]
[{"$nulls":5},"入库：","1入库 2出库"]
[{"$nulls":5},"1采购进货；2退货入库；3赠品入库；4转移入库"]
[{"$nulls":5},"出库：",null,"出库不可超过库存"]
[{"$nulls":5},"1销售出库；2报废出库；3赠品出库；3转移出库"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}