{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["导入模板","车辆分类","模板使用说明"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"导入模板","index":0,"n_rows":2,"n_cols":11,"rows_kept":2}
["*车牌号码","*备注","*车辆分类","*组织路径","车主姓名","手机号","性别","身份证号","停车库名称","开始时间","结束时间"]
["皖A10110","其他","公务车/市公司公务用车","园区默认组织/市公司/安技部","吴光春",13855153156,"男","342623198802153441","安泰物流"]

{"sheet":"车辆分类","index":1,"n_rows":13,"n_cols":1,"rows_kept":13}
["车辆分类"]
["公务车/安泰物流公务用车"]
["公务车/中烟公司公务用车"]
["公务车/卷烟厂公务用车"]
["公务车/市公司公务用车"]
["私家车/安泰物流职工车辆"]
["私家车/市公司职工车辆"]
["私家车/相关方职工车辆"]
["私家车/市公司相关方职工车辆"]
["私家车/中烟公司职工车辆"]
["货运车/安泰物流货运车辆"]
["货运车/市公司货运车辆"]
["货运车/市公司邮政外包车辆"]

{"sheet":"模板使用说明","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"merged":[[0,0,0,4],[13,0,13,4]]}
["字段说明"]
["字段名称","类型","长度","允许空值","备注"]
["车牌号码","字符型",10,"否","车牌号只能输入汉字、字母、数字"]
["业务类型","单选","/","否","如果不填写，默认为其它\n用于系统业务场景使用，公务车主要用于公车申请的车辆；安泰物流车用于安泰自有物流车月台调度业务的车辆；剩余车辆请选择其它；"]
["车辆分类","单选","/","否","只能选择对应的车辆分类，不可随意录入；\n分类如需调整，请先在系统中录入；\n导出模板时，会自动带出系统中最新分类信息；"]
["组织路径","字符型",100,"是","1-50个字符，车辆关联的组织，需要从根组织开始/隔开组织名称；例如：安泰物流责任有限公司/安泰物流/综合管理科"]
["车主姓名","字符型",20,"是","1-20个字符，车辆导入时无需提供"]
["手机号","字符型",11,"是","11为数字，且需要以1开头；系统会通过手机号关联车主信息，如果车辆存在则自动更新为最新的车主信息；"]
["性别","字符型",1,"是","导出字段，录入时无需提供"]
["身份证号","字符型",40,"是","导出字段，录入时无需提供"]
["停车库名称","字符型",40,"是","导出字段，录入时无需提供"]
["开始时间","日期格式",10,"是","导出字段，录入时无需提供"]
["结束时间","日期格式",10,"是","导出字段，录入时无需提供"]
["特别说明：\n1、组织路径不对时，系统会报错，导入失败；\n2、车辆分类错误时，系统会报错，导入失败；\n3、车主手机号在系统不存在时，系统会报错，导入失败；\n4、车辆如果已经在系统中存在，系统会自动更新为表格中最新的数据；\n5、车辆导入后，如果业务类型是安泰公务车/安泰物流车，则自动下发长期权限；如果业务类型是其它，则关联车主的门禁有效期进行自动下发。如果没有车主，则不自动下发权限；"]