{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["01、理货基本信息数据项","02、装箱计划","03、申报入集拼申报区","04、准装申请 ","05、车辆过卡基本数据项","06、虚拟卡口生成数据项"],"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":"01、理货基本信息数据项","index":0,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,7],[12,0,12,7],[1,0,11,0],[1,1,7,1],[8,1,11,1]]}
[null,"理货数据展示-（数据来源入库明细和出库明细单）",{"$nulls":14},"备注"]
[1,"基础信息","所属仓库"]
[null,null,"货主名称"]
[null,null,"卸货车牌号","辽HK4446"]
[null,null,"总件数"]
[null,null,"总毛重"]
[null,null,"订单流水号"]
[null,null,"备注"]
[null,"订单商品明细","商品名称","商品编码","商品条码","包装方式","件数单位","订单件数","订单毛重（KG）","订单净重（KG）","入仓时间","托盘号","报关单号","核注清单号","电子账册号"]
[]
[]
[]
["因此设计接口需要理货出入库明细单都发送数据过来。"]

{"sheet":"02、装箱计划","index":1,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,7],[28,0,28,7],[1,0,27,0],[29,0,36,0],[7,1,27,1],[35,1,36,1]]}
[null,"2024.3.21装箱（车）计划表"]
[1,"航次号","2024032020436"]
[null,"车牌号","辽HK4446"]
[null,"模拟车位",4]
[null,"总件数"]
[null,"总毛重"]
[null,"主要货物品名","日用品"]
[null,"相关单证","单证类型","提运单","单证号码","72202024032020436A","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436B","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436C","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436D","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436E","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436F","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436G","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436H","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436I","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436J","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436K","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436L","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436M","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436N","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436O","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436P","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436Q","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436R","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436S","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436T","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","TF2024032020436","业务类型","跨境电商","货主名称","XXXX"]
[]
[2,"航次号"]
[null,"车牌号"]
[null,"模拟车位"]
[null,"总件数"]
[null,"总毛重"]
[null,"主要货物品名"]
[null,"相关单证","单证类型","提运单","单证号码",null,"业务类型","一般贸易"]

{"sheet":"03、申报入集拼申报区","index":2,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,7],[12,0,12,7],[1,0,11,0],[1,1,7,1],[8,1,11,1]]}
[null,"货物入集拼申报去申请",{"$nulls":14},"备注"]
[1,"基础信息","集拼区仓位"]
[null,null,"货主名称"]
[null,null,"运输工具号","辽HK4446"]
[null,null,"总件数"]
[null,null,"总毛重"]
[null,null,"订单流水号"]
[null,null,"备注"]
[null,"订单商品明细","商品名称","商品编码","商品条码","包装方式","件数单位","订单件数","订单毛重（KG）","订单净重（KG）","入仓时间","托盘号","报关单号","核注清单号","电子账册号"]
[]
[]
[]
["数据来源是理货数据和准装计划"]

{"sheet":"04、准装申请 ","index":3,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,7],[31,0,31,7],[1,0,30,0],[32,0,39,0],[10,1,30,1],[38,1,39,1],[7,8,8,8]]}
[null,"准装申请表",{"$nulls":6},"备注"]
[1,"航次号","2024032020436"]
[null,"运输工具号","辽HK4446"]
[null,"模拟车位",4]
[null,"总件数"]
[null,"总毛重"]
[null,"货柜箱号"]
[null,"空箱AI检测结果",{"$nulls":6},"AI检测结果可点击查看存证"]
[null,"货物存在AI检测结果"]
[null,"主要货物品名","日用品"]
[null,"相关单证","单证类型","提运单","单证号码","72202024032020436A","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436B","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436C","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436D","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436E","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436F","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436G","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436H","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436I","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436J","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436K","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436L","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436M","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436N","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436O","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436P","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436Q","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436R","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436S","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","72202024032020436T","业务类型","一般贸易","货主名称","XXXX"]
[null,null,"单证类型","提运单","单证号码","TF2024032020436","业务类型","跨境电商","货主名称","XXXX"]
[]
[2,"航次号"]
[null,"车牌号"]
[null,"模拟车位"]
[null,"总件数"]
[null,"总毛重"]
[null,"主要货物品名"]
[null,"相关单证","单证类型","提运单","单证号码",null,"业务类型","一般贸易"]

{"sheet":"05、车辆过卡基本数据项","index":4,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,8],[5,0,5,8],[1,0,4,0],[1,1,4,1]]}
[null,"车辆过卡基本数据项"]
[1,"车辆过卡基本数据项","场所名称","通道名称","进出标识","会话编号","车牌号","前箱号","后箱号","过卡重量","过卡时间","放行结果","放行提示","备注"]
[]
[]
[]
["卡3、虚拟卡口、内卡都需要传过卡记录过来"]

{"sheet":"06、虚拟卡口生成数据项","index":5,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,10],[5,0,5,10],[1,0,4,0],[1,1,4,1]]}
[null,"虚拟卡口基本数据项"]
[1,"虚拟卡口基本数据项","场所名称","通道名称","进出标识","会话编号","车牌号","IC卡号","电子车牌号","前箱号","后箱号","重量","过卡时间"]
[]
[]
[null,null,"AREA_ID","CHNL_NO","I_E_FLAG","SESSION_ID","VE_LICENSE_NO","IC_ID","RFID_No","CONTA_ID_F","CONTA_ID_B","GROSS_WT","OPERATE_TIME"]
["虚拟卡口-数据需要专门的标签定义"]