{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["IVR流程","话务管理","工单管理","话务二级页面","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"IVR流程","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"话务管理","index":1,"n_rows":111,"n_cols":11,"rows_kept":111,"cut":false,"hidden":false,"merged":[[1,2,13,2],[1,1,101,1],[4,3,4,5],[5,3,5,5],[7,10,10,10],[34,4,34,5],[35,4,35,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[29,4,29,5],[30,4,30,5],[32,4,32,5],[7,8,10,8],[33,4,33,5],[0,3,0,5],[6,3,6,5],[7,3,11,4],[12,3,13,4],[59,4,59,5],[37,4,37,5],[45,4,45,5],[46,4,55,4],[57,4,58,4],[14,3,35,3],[36,3,62,3],[1,3,1,5],[2,3,2,5],[3,3,3,5],[22,4,23,4],[17,8,23,8],[69,4,69,5],[68,4,68,5],[63,3,69,3],[25,4,26,4],[27,4,28,4],[56,4,56,5],[63,4,64,4],[60,4,61,4],[97,4,98,4],[70,3,98,3],[14,2,98,2],[1,0,101,0],[24,4,24,9],[65,4,66,4],[67,4,67,5],[38,4,38,5],[39,4,44,4],[15,4,16,4],[89,4,89,5],[91,4,92,4],[71,4,71,5],[72,4,77,4],[78,4,78,5],[79,4,88,4]]}
["序号","模块","子模块","字段名称",null,null,"输出来源","录入至","展现方式","必填项","备注"]
[1,"来电弹屏","客\n户\n基\n本\n信\n息","客户姓名",null,null,"NC表J列-法人","NC表J列-法人","手动输入","√"]
[2,null,null,"电话",null,null,"NC表K列-电话1","NC表K列-电话1","手动输入","√"]
[3,null,null,"公司名称",null,null,"NC表D列-客户名称","NC表D列-客户名称","手动输入","√"]
[4,null,null,"性别",{"$nulls":4},"点选式","√"]
[5,null,null,"来电时间",{"$nulls":4},"自动获取"]
[6,null,null,"一键黑名单",{"$nulls":4},"参照三元"]
[7,null,null,"客\n户\n地\n址",null,"省","NC表L列-地址详址","NC表L列-地址详址","下拉式","√"]
[8,{"$nulls":4},"市",null,"需新增列-市",null,"√"]
[9,{"$nulls":4},"县",null,"需新增列-县",null,"√"]
[10,{"$nulls":4},"乡",null,"需新增列-乡",null,"√"]
[11,{"$nulls":4},"村",null,"需新增列-村","手动输入","√"]
[12,null,null,"渠道类型",null,"总经销\n二级商（含二级页面）\n种田大户（提示：50亩以上）（含二级页面）\n农户（提示：50亩以下）\n化工客户\n公司员工","NC表H列-渠道类型","NC表H列-渠道类型","下拉式","√","2个二级页面"]
[13,{"$nulls":4},"其他","NC表H列-渠道类型","NC表H列-渠道类型","手动输入"]
[14,null,"手制工单","公共字段","工单来源","电话、微信、官网",null,null,"下拉式/待定"]
[15,null,null,null,"工单类型","咨询及需求、投诉、抽检",null,null,"点选式","√"]
[16,{"$nulls":4},"其他",null,null,"手动输入"]
[17,null,null,null,"渠道类型",null,"NC表H列-渠道类型",null,"1、左侧保存后自动显示，左侧不填默认不能输入\n2、客户档案中原有资料直接显示","√"]
[18,null,null,null,"客户姓名",null,"NC表J列-法人",null,null,"√"]
[19,null,null,null,"电话",null,"NC表K列-电话1",null,null,"√"]
[20,null,null,null,"公司名称",null,"NC表D列-客户名称",null,null,"√"]
[21,null,null,null,"性别",{"$nulls":4},"√"]
[{"$nulls":4},"客户地址","省","NC表L列-地址详址","NC表L列-地址详址",null,"√"]
[22,{"$nulls":4},"市、县、乡、村","各占一列","市、县、乡、村各占一列",null,"√"]
[23,null,null,null,"独立字段展示区"]
[27,null,null,null,"事发地","省、市、县、乡",null,null,"下拉式","√","加入中国省市县乡列表"]
[28,{"$nulls":4},"村",null,null,"手动输入","√"]
[29,null,null,null,"销售基地","新乡、新疆、九江、东北",null,null,"下拉式","√"]
[30,{"$nulls":4},"其他",null,null,"手动输入","√"]
[31,null,null,null,"问题描述",null,null,null,"手动输入","√"]
[32,null,null,null,"附件上传",null,null,null,"参考以往"]
[33,null,null,null,"处理方式","当即办理、电话转接、网络转办",null,null,"点选式","√"]
[34,null,null,null,"接收部门",null,null,null,"下拉式","√"]
[35,null,null,null,"接收人",null,null,null,"下拉式","√"]
[36,null,null,null,"创建",null,null,null,"按钮","√"]
[37,null,null,null,"清空",null,null,null,"按钮"]
[38,null,null,"投诉类工单单独字段","问题类别","详见 4.质量投诉问题分类表",null,null,"三级连选","√","详见 4.质量投诉问题分类表"]
[39,null,null,null,"生产批次号",null,null,null,"手动输入",null,"1、括号下提示:贴牌、或者无法获取填写“无”\n2、定死15位数字字母组组合\n3、编码规则见图 6.生产批次号编码规则"]
[40,null,null,null,"客户编码",null,null,null,"手动输入",null,"定死位数为10位数字"]
[41,null,null,null,"带出以下信息","大区","NC表A列-大区","NC表A列-大区","自动带出"]
[42,{"$nulls":4},"分公司","NC表B列-分公司","NC表B列-分公司","自动带出"]
[43,{"$nulls":4},"客户名称","NC表D列-分公司","NC表D列-分公司","自动带出"]
[44,{"$nulls":4},"业务员","NC表E列-业务员1","NC表E列-业务员1","自动带出"]
[45,{"$nulls":4},"电话","NC表F列-电话1","NC表F列-电话1","自动带出"]
[46,{"$nulls":4},"经营品牌","NC表M列-经营品牌","NC表M列-经营品牌","自动带出",null,"此项需调节算法"]
[47,null,null,null,"物料编码",null,"物料档案表-B列物料编码",null,"手动输入",null,"位数定死为11位数字"]
[48,null,null,null,"带出以下信息","物料名称","物料档案表-A列物料名称",null,"自动带出"]
[49,{"$nulls":4},"型号","物料档案表-C列型号",null,"自动带出"]
[50,{"$nulls":4},"规格","物料档案表-D列规格",null,"自动带出"]
[51,{"$nulls":4},"一级分类","物料档案表-E列一级分类",null,"自动带出"]
[52,{"$nulls":4},"二级分类","物料档案表-F列二级分类",null,"自动带出"]
[53,{"$nulls":4},"三级分类","物料档案表-G列三级分类",null,"自动带出"]
[54,{"$nulls":4},"品牌","物料档案表-H列品牌",null,"自动带出"]
[55,{"$nulls":4},"复合肥肥效","物料档案表-I列复合肥肥效",null,"自动带出"]
[56,{"$nulls":4},"产品线","物料档案表-J列产品线",null,"自动带出"]
[57,{"$nulls":4},"工艺","物料档案表-K列工艺",null,"自动带出"]
[58,null,null,null,"配方",null,null,null,"手动输入","√"]
[59,null,null,null,"产品种类","化肥、化工",null,null,"下拉式","√"]
[60,{"$nulls":4},"其他",null,null,"手动输入","√"]
[61,null,null,null,"问题数量（吨）",null,null,null,"手动输入","√"]
[62,null,null,null,"品牌","心连心、手拉手、沃利沃、双心、贴牌",null,null,"下拉式","√"]
[63,{"$nulls":4},"其他",null,null,"手动输入","√"]
[64,null,null,null,"重要级别","轻微、一般、较大、重大",null,null,"下拉式","√"]
[65,null,null,"咨询及需求类工单单独字段","问题类别","产品、农化服务、测土配方、价格、包装、真伪、公司情况",null,null,"点选式","√"]
[66,{"$nulls":4},"其他",null,null,"手动输入"]
[{"$nulls":4},"产品名称","三聚氰胺、甲醇、液氨、二甲醚、糠醇",null,null,"下拉式"]
[{"$nulls":5},"其他",null,null,"手动输入"]
[{"$nulls":4},"问题数量",null,null,null,"手动输入",null,"单位：吨"]
[67,null,null,null,"大区",null,"NC表A列-大区","NC表A列-大区","手动输入","√","需再次确认展现方式"]
[68,null,null,null,"分公司",null,"NC表B列-分公司","NC表B列-分公司","手动输入","√","需再次确认展现方式"]
[69,null,null,"抽检类工单单独字段","问题类别","养分、标识、公关",null,null,"点选式","√"]
[70,null,null,null,"客户编码",null,null,null,"手动输入","√","定死位数为10位数字"]
[71,null,null,null,"带出以下信息","大区","NC表A列-大区","NC表A列-大区","自动带出","√"]
[72,{"$nulls":4},"分公司","NC表B列-分公司","NC表B列-分公司","自动带出","√"]
[73,{"$nulls":4},"客户名称","NC表D列-分公司","NC表D列-分公司","自动带出","√"]
[74,{"$nulls":4},"业务员","NC表E列-业务员1","NC表E列-业务员1","自动带出","√"]
[75,{"$nulls":4},"电话","NC表F列-电话1","NC表F列-电话1","自动带出","√"]
[76,{"$nulls":4},"经营品牌","NC表M列-经营品牌","NC表M列-经营品牌","自动带出","√","此项需调节算法"]
[77,null,null,null,"物料编码",null,"物料档案表-B列物料编码",null,"手动输入","√","位数定死为11位数字"]
[78,null,null,null,"带出以下信息","物料名称","物料档案表-A列物料名称",null,"自动带出","√"]
[79,{"$nulls":4},"型号","物料档案表-C列型号",null,"自动带出","√"]
[80,{"$nulls":4},"规格","物料档案表-D列规格",null,"自动带出","√"]
[81,{"$nulls":4},"一级分类","物料档案表-E列一级分类",null,"自动带出","√"]
[82,{"$nulls":4},"二级分类","物料档案表-F列二级分类",null,"自动带出","√"]
[83,{"$nulls":4},"三级分类","物料档案表-G列三级分类",null,"自动带出","√"]
[84,{"$nulls":4},"品牌","物料档案表-H列品牌",null,"自动带出","√"]
[85,{"$nulls":4},"复合肥肥效","物料档案表-I列复合肥肥效",null,"自动带出","√"]
[86,{"$nulls":4},"产品线","物料档案表-J列产品线",null,"自动带出","√"]
[87,{"$nulls":4},"工艺","物料档案表-K列工艺",null,"自动带出","√"]
[88,null,null,null,"抽检时间",null,null,null,"选择时间（年月日）","√"]
[89,null,null,null,"抽检级别","乡镇级、县级、市级、省级及以上、个人送检",null,null,"下拉式","√"]
[90,null,null,null,"抽检单位","市场监督、农业部、土肥站、工商、联合执法",null,null,"下拉式","√"]
[91,{"$nulls":4},"其他",null,null,"手动输入","√"]
[92,null,null,null,"化验单位",{"$nulls":4},"√"]
[93,null,null,null,"抽检吨数",{"$nulls":4},"√"]
[94,null,null,null,"抽检袋数",{"$nulls":4},"√"]
[95,null,null,null,"生产批次号",{"$nulls":4},"√","1、括号下提示:贴牌、或者无法获取填写“无”\n2、定死15位数字字母组组合\n3、编码规则见图 6.生产批次号编码规则"]
[96,null,null,null,"公关费用金额","单位元",null,null,"手动输入","√"]
[97,{"$nulls":4},"附件上传",null,null,"参考以往"]
[null,null,"通话记录",{"$nulls":5},"参照三元"]
[null,null,"历史工单",{"$nulls":5},"参照三元"]
[null,null,"知识库",{"$nulls":5},"参照三元"]
[2,"通话记录",{"$nulls":6},"参照三元"]
[3,"语音留言管理",{"$nulls":6},"参照三元"]
[4,"黑名单管理",{"$nulls":6},"参照三元"]
[5,"号码归属地",{"$nulls":6},"参照三元"]
[6,"值班电话管理",{"$nulls":6},"参照三元"]
[7,"工作日管理",{"$nulls":6},"参照三元"]
[8,"工作时间管理",{"$nulls":6},"参照绿地"]
[9,"坐席监控管理",{"$nulls":6},"参照三元"]
[10,"坐席组管理",{"$nulls":6},"参照三元"]

{"sheet":"工单管理","index":2,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,2,1,8],[0,2,0,3]]}
["序号","模块","字段名称",null,"描述","输出来源","录入至","展现方式","必填项","备注"]
[1,"手制工单","与来电弹屏一致"]
[null,"待指派工单","起止时间",{"$nulls":4},"参考三元"]
[null,null,"工单来源",{"$nulls":4},"下拉"]
[null,null,"工单类型",{"$nulls":4},"下拉"]
[null,null,"搜索框",null,"请输入工单编号、姓名、电话查询",null,null,"参考三元"]
[null,null,"工单表","工单编号",null,null,null,"参考三元"]
[null,null,null,"工单状态"]
[null,null,null,"工单来源"]
[null,null,null,"工单类型"]
[null,null,null,"问题类别"]
[null,null,null,"客户姓名"]
[null,null,null,"电话"]
[null,null,null,"公司名称"]
[null,null,null,"客户编码"]
[null,null,null,"性别"]
[null,null,null,"来电时间"]
[null,null,null,"客户地址"]
[null,null,null,"渠道类型"]
[null,null,null,"业务员"]
[null,null,null,"大区"]
[null,null,null,"分公司"]
[null,null,null,"销售基地"]
[null,null,null,"事发地"]
[null,null,null,"物料编码"]
[null,null,null,"经营品牌"]
[null,null,null,"生产批次号"]
[null,null,null,"配方"]
[null,null,null,"产品种类"]
[null,null,null,"问题数量"]
[null,null,null,"重要级别"]
[null,null,null,"抽检时间"]
[null,null,null,"抽检单位"]
[null,null,null,"化验单位"]
[null,null,null,"抽检吨数"]
[null,null,null,"抽检袋数"]
[null,null,null,"公关费用金额"]
[null,null,null,"问题描述"]
[null,null,null,"接收部门"]
[null,null,null,"接收人"]
[null,null,null,"处理人"]
[null,null,null,"创建人"]
{"$rows_empty":25}
[2,"待指派工单"]
[null,"已处理工单"]
[null,"已参与工单"]
[null,"超期工单"]
[null,"微信客户工单"]
[null,"综合查询"]

{"sheet":"话务二级页面","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,3,1],[11,1,11,2],[4,1,8,1],[13,5,16,5],[10,1,10,2],[9,1,9,2],[2,5,3,5],[4,5,7,5],[1,0,1,2],[2,0,9,0],[12,1,12,2],[13,1,17,1],[10,0,17,0]]}
[null,"二级页面"]
["字段名称",null,null,"输出来源","输入来源","方式"]
["二级商","是否经营心连心","是",null,null,"点选式"]
[null,null,"否"]
[null,"经营品牌","心连心",null,null,"下拉式"]
[null,null,"新洋丰"]
[null,null,"史丹利"]
[null,null,"金正大"]
[null,null,"其他",null,null,"手动输入"]
[null,"年销量（吨）"]
["种田大户","配方",null,null,null,"手动输入"]
[null,"种植作物",null,null,null,"？"]
[null,"种植面积（亩）",null,null,null,"手动输入"]
[null,"用肥品牌","心连心",null,null,"下拉式"]
[null,null,"新洋丰"]
[null,null,"史丹利"]
[null,null,"金正大"]
[null,null,"其他",null,null,"手动输入"]

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