{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["字典配置","编码规则配置","业务数据"],"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":"字典配置","index":0,"n_rows":68,"n_cols":4,"rows_kept":68,"cut":false,"hidden":false,"merged":[[62,1,62,2],[63,2,63,3],[64,1,64,3],[49,1,49,2],[50,1,50,2],[51,2,51,3],[52,1,52,3],[61,1,61,2],[37,1,37,2],[38,1,38,2],[39,2,39,3],[40,1,40,3],[6,1,6,3],[29,1,29,2],[30,2,30,3],[31,1,31,3],[3,1,3,2],[4,1,4,2],[5,2,5,3],[15,1,15,2],[28,1,28,2],[16,1,16,2],[17,2,17,3],[18,1,18,3]]}
[]
[]
[]
[null,"字典编码",null,"sys_autocode_parttype"]
[null,"字典名称",null,"自动编码规则组成类型"]
[null,"备注说明"]
[null,"字典项"]
[null,"序号","项值","项名称"]
[null,1,"INPUTCHAR","输入字符"]
[null,2,"NOWDATE","当前日期时间"]
[null,3,"FIXCHAR","固定字符"]
[null,4,"SERIALNO","流水号"]
[]
[]
[]
[null,"字典编码",null,"sys_autocode_cyclemethod"]
[null,"字典名称",null,"自动编码规则组成循环方式"]
[null,"备注说明"]
[null,"字典项"]
[null,"序号","项值","项名称"]
[null,1,"YEAR","按年"]
[null,2,"MONTH","按月"]
[null,3,"DAY","按天"]
[null,4,"HOUR","按小时"]
[null,5,"MINUTE","按分钟"]
[null,6,"OTHER","按传入字符变"]
[]
[]
[null,"字典编码",null,"mes_client_type"]
[null,"字典名称",null,"客户类型"]
[null,"备注说明"]
[null,"字典项"]
[null,"序号","项值","项名称"]
[null,1,"ENTERPRISE","企业客户"]
[null,2,"PERSON","个人客户"]
[]
[]
[null,"字典编码",null,"mes_vendor_level"]
[null,"字典名称",null,"供应商级别"]
[null,"备注说明"]
[null,"字典项"]
[null,"序号","项值","项名称"]
[null,1,"A","优质供应商"]
[null,2,"B","正常"]
[null,null,"C","重点关注"]
[null,null,"D","劣质供应商"]
[null,null,"E","黑名单"]
[]
[]
[null,"字典编码",null,"mes_order_status"]
[null,"字典名称",null,"单据状态【通用】"]
[null,"备注说明"]
[null,"字典项"]
[null,"序号","项值","项名称"]
[null,1,"PREPARE","草稿"]
[null,2,"CONFIRMED","已确认"]
[null,null,"APPROVING","审批中"]
[null,null,"APPROVED","已审批"]
[null,null,"FINISHED","已完成"]
[]
[]
[null,"字典编码",null,"mes_workorder_sourcetype"]
[null,"字典名称",null,"生产工单来源"]
[null,"备注说明"]
[null,"字典项"]
[null,"序号","项值","项名称"]
[null,1,"ORDER","草稿"]
[null,2,"STORE","已确认"]

{"sheet":"编码规则配置","index":1,"n_rows":125,"n_cols":7,"rows_kept":125,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[6,2,6,6],[7,1,7,6],[4,1,4,2],[5,1,5,2],[2,3,2,6],[3,3,3,6],[4,3,4,6],[5,3,5,6],[16,1,16,2],[16,3,16,6],[17,1,17,2],[17,3,17,6],[18,1,18,2],[18,3,18,6],[19,1,19,2],[19,3,19,6],[20,2,20,6],[21,1,21,6],[30,1,30,2],[30,3,30,6],[31,1,31,2],[31,3,31,6],[32,1,32,2],[32,3,32,6],[33,1,33,2],[33,3,33,6],[49,1,49,6],[34,2,34,6],[35,1,35,6],[44,1,44,2],[44,3,44,6],[45,1,45,2],[45,3,45,6],[46,1,46,2],[46,3,46,6],[47,1,47,2],[47,3,47,6],[48,2,48,6],[57,1,57,2],[57,3,57,6],[58,1,58,2],[58,3,58,6],[59,1,59,2],[59,3,59,6],[60,1,60,2],[60,3,60,6],[61,2,61,6],[62,1,62,6],[71,1,71,2],[71,3,71,6],[72,1,72,2],[72,3,72,6],[73,1,73,2],[73,3,73,6],[74,1,74,2],[74,3,74,6],[75,2,75,6],[76,1,76,6],[85,1,85,2],[85,3,85,6],[86,1,86,2],[86,3,86,6],[87,1,87,2],[87,3,87,6],[88,1,88,2],[88,3,88,6],[89,2,89,6],[90,1,90,6],[99,1,99,2],[99,3,99,6],[100,1,100,2],[100,3,100,6],[101,1,101,2],[101,3,101,6],[102,1,102,2],[102,3,102,6],[103,2,103,6],[104,1,104,6],[114,1,114,2],[114,3,114,6],[115,1,115,2],[115,3,115,6],[119,1,119,6],[116,1,116,2],[116,3,116,6],[117,1,117,2],[117,3,117,6],[118,2,118,6]]}
[]
[]
[null,"规则编码",null,"ITEM_CODE"]
[null,"规则名称",null,"物料编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[]
[null,"规则编码",null,"ITEM_TYPE_CODE"]
[null,"规则名称",null,"物料类型编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[]
[null,"规则编码",null,"CLIENT_CODE"]
[null,"规则名称",null,"客户编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[]
[null,"规则编码",null,"VENDOR_CODE"]
[null,"规则名称",null,"供应商编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[null,"规则编码",null,"WORKSHOP_CODE"]
[null,"规则名称",null,"车间编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[]
[null,"规则编码",null,"WAREHOUSE_CODE"]
[null,"规则名称",null,"仓库编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[]
[null,"规则编码",null,"LOCATION_CODE"]
[null,"规则名称",null,"库区编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[]
[null,"规则编码",null,"AREA_CODE"]
[null,"规则名称",null,"库位编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[]
[]
[null,"规则编码",null,"MACHINERY_TYPE_CODE"]
[null,"规则名称",null,"设备类型编码规则"]
[null,"最大长度",null,8]
[null,"是否补齐",null,"否"]
[null,"备注说明"]
[null,"规则组成"]
[null,"序号","组成编码","组成名称名称","分段类型","长度","其他参数"]
[null,1]
[null,2]
[null,3]
[null,4]

{"sheet":"业务数据","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"物料编码分类根节点"]
[null,"设备类型分类根节点"]
[null,"库存备货客户"]