{"text_format":"2","workbook":"xlsx","n_sheets":21,"sheets":["IVR流程","话务管理","话务二级页面","工单管理","回访管理","客户管理","物料管理","知识库","报表管理","权限管理-部门管理","对接人列表","市场管理科界面","质量管理部界面","质量管理科界面","销售内勤界面","业务员微信界面","分公司经理界面","大区经理界面","高层界面","其他处理部门界面","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":1,"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":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,7],[1,0,1,5],[1,6,1,7],[2,3,2,5],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[6,6,6,7],[7,3,7,5],[7,6,7,7],[8,1,8,5],[9,4,9,5],[12,4,12,5],[13,1,13,7],[14,1,14,5],[17,0,17,5],[18,0,18,5],[19,0,19,5],[20,1,20,5],[21,1,21,5],[22,0,22,5],[22,6,22,7],[9,0,12,0],[15,0,16,0],[20,0,21,0],[10,6,11,6],[15,2,16,4],[9,1,12,3],[10,4,11,5],[3,3,4,5],[2,0,7,2],[5,3,6,5]]}
["步骤",{"$nulls":5},"流程"]
["电话接入",{"$nulls":5},"进入IVR系统"]
["播放对应品牌欢迎词:欢迎致电",null,null,"心连心客服中心",null,null,"4006632132心连心尿素---5595000尿素包装--5598585复合肥"]
[null,null,null,"农心公司客服中心",null,null,"4000140004手拉手---5713123"]
[{"$nulls":6},"4006515698沃利沃---5713719"]
[null,null,null,"新疆心连心客服中心",null,null,"4006009788新疆---0994-6158056外线--- 0994-6158036（备用）"]
[{"$nulls":6},"(需增加一个网关)"]
[null,null,null,"九江心连心客服中心",null,null,"0792-2333333九江 0792-2113010 (需增加一个网关)"]
["黑名单判定","是黑名单",{"$nulls":4},"对不起，您所拨打的电话正在通话中，请稍后重试","播放后记录并挂机"]
["非工作时间","非工作时间",null,null,"语音留言请按1",null,"请听到滴的一声后留言，按#号键结束","执行留言操作"]
[{"$nulls":4},"转值班电话请按2",null,"电话正在转接，请稍后","转值班电话操作"]
[{"$nulls":7},"值班电话转至当地值班电话"]
[{"$nulls":4},"结束请挂机",null,"感谢您的来电，再见","挂机"]
["正常工作时间"]
["指令操作","直接转人工",{"$nulls":4},"为保证服务质量，您的来电可能会被录音，电话正在接通稍候。"]
["排队等待","无坐席","坐席全忙，继续等待请按1，留言请按2，转值班电话请按3",null,null,"按3留言","请听到滴的一声后留言，按#号键结束","执行留言操作"]
[null,"坐席全忙",null,null,null,"按2值班电话","电话正在转接，请稍后","转值班电话操作"]
["等待坐席接听",{"$nulls":5},"/"]
["坐席接听，播报工号",{"$nulls":5},"您好，XXX号话务员为您服务","通话并录音"]
["通话完成，坐席挂机",{"$nulls":5},"/","坐席挂机"]
["满意度评价","进行满意度评价",{"$nulls":4},"为提高我们的服务质量，请您对我们的服务作出评价。满意请按1，一般请按2，不满意请按3。","按键评价"]
[null,"评价后结束",{"$nulls":4},"感谢您的评价，祝您生活愉快，再见。","评价后挂机"]
["流程结束",{"$nulls":5},"IVR结束"]

{"sheet":"话务管理","index":1,"n_rows":115,"n_cols":11,"rows_kept":115,"cut":false,"hidden":false,"merged":[[0,3,0,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[24,4,24,9],[29,4,29,5],[30,4,30,5],[32,4,32,5],[33,4,33,5],[36,4,36,5],[37,4,37,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[48,4,48,5],[49,4,49,5],[60,4,60,5],[63,4,63,5],[69,4,69,5],[70,4,70,5],[71,4,71,5],[73,4,73,5],[74,4,74,5],[81,4,81,5],[82,4,82,5],[93,4,93,5],[1,0,105,0],[1,1,105,1],[1,2,13,2],[14,2,102,2],[14,3,37,3],[38,3,64,3],[65,3,71,3],[72,3,102,3],[15,4,16,4],[22,4,23,4],[25,4,26,4],[27,4,28,4],[61,4,62,4],[65,4,66,4],[67,4,68,4],[95,4,96,4],[101,4,102,4],[7,8,10,8],[7,10,10,10],[17,10,23,10],[7,3,11,4],[12,3,13,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,"渠道类型","总经销、二级商、种田大户、农户、化工客户、公司员工","NC表H列-渠道类型",null,"下拉式","√","1、左侧保存后自动显示，左侧不填默认不能输入\n2、客户档案中原有资料直接显示"]
[18,null,null,null,"客户姓名",null,"NC表J列-法人",null,"手动输入","√"]
[19,null,null,null,"电话",null,"NC表K列-电话1",null,"手动输入","√"]
[20,null,null,null,"公司名称",null,"NC表D列-客户名称",null,"手动输入","√"]
[21,null,null,null,"性别",null,null,null,"手动输入","√"]
[{"$nulls":4},"客户地址","省","NC表L列-地址详址","NC表L列-地址详址","下拉式","√"]
[22,{"$nulls":4},"市、县、乡、村","各占一列","市、县、乡、村各占一列","下拉式","√"]
[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,"下拉式","√"]
[{"$nulls":4},"超时时限",null,null,null,"点选式"]
[{"$nulls":4},"短信提醒",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,"带出以下信息"]
[{"$nulls":4},"大区","字段见客户管理","NC表A列-大区","NC表A列-大区","下拉式","√"]
[42,null,null,null,"分公司","字段见客户管理","NC表B列-分公司","NC表B列-分公司","下拉式","√"]
[43,null,null,null,"公司名称",null,"NC表D列-客户名称","NC表D列-客户名称","手动输入","√"]
[44,null,null,null,"业务员",null,"NC表E列-业务员1","NC表E列-业务员1","手动输入","√"]
[45,null,null,null,"电话",null,"NC表F列-电话1","NC表F列-电话1","手动输入","√"]
[46,null,null,null,"产品","字段见客户管理","NC表o-v列","NC表N列-经营品牌","点选式（多选）","√"]
[47,null,null,null,"物料编码",null,"物料档案表-B列物料编码",null,"手动输入",null,"位数定死为11位数字"]
[{"$nulls":4},"带出以下信息"]
[48,null,null,null,"物料名称",null,"物料档案表-A列物料名称",null,"手动输入","√"]
[49,null,null,null,"型号",null,"物料档案表-C列型号",null,"手动输入","√"]
[50,null,null,null,"规格",null,"物料档案表-D列规格",null,"手动输入","√"]
[51,null,null,null,"一级分类","字段见物料管理","物料档案表-E列一级分类",null,"下拉式","√"]
[52,null,null,null,"二级分类","字段见物料管理","物料档案表-F列二级分类",null,"下拉式","√"]
[53,null,null,null,"三级分类","字段见物料管理","物料档案表-G列三级分类",null,"下拉式","√"]
[54,null,null,null,"品牌","心连心、手拉手、沃利沃、双心、空","物料档案表-H列品牌",null,"下拉式","√"]
[55,null,null,null,"复合肥肥效","高效二、普通、空","物料档案表-I列复合肥肥效",null,"点选","√"]
[56,null,null,null,"产品线","尿素、复合肥","物料档案表-J列产品线",null,"点选","√"]
[57,null,null,null,"工艺",null,"物料档案表-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,"手动输入","√"]
[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位数字"]
[{"$nulls":4},"带出以下信息"]
[71,null,null,null,"大区","字段见客户管理","NC表A列-大区","NC表A列-大区","下拉式","√"]
[72,null,null,null,"分公司","字段见客户管理","NC表B列-分公司","NC表B列-分公司","下拉式","√"]
[73,null,null,null,"公司名称",null,"NC表D列-客户名称","NC表D列-客户名称","手动输入","√"]
[74,null,null,null,"业务员",null,"NC表E列-业务员1","NC表E列-业务员1","手动输入","√"]
[75,null,null,null,"电话",null,"NC表F列-电话1","NC表F列-电话1","手动输入","√"]
[{"$nulls":4},"产品","字段见客户管理","NC表o-v列","NC表N列-经营品牌","点选式（多选）","√"]
[77,null,null,null,"物料编码",null,"物料档案表-B列物料编码",null,"手动输入","√","位数定死为11位数字"]
[{"$nulls":4},"带出以下信息"]
[78,null,null,null,"物料名称",null,"物料档案表-A列物料名称",null,"手动输入","√"]
[79,null,null,null,"型号",null,"物料档案表-C列型号",null,"手动输入","√"]
[80,null,null,null,"规格",null,"物料档案表-D列规格",null,"手动输入","√"]
[81,null,null,null,"一级分类","字段见物料管理","物料档案表-E列一级分类",null,"下拉式","√"]
[82,null,null,null,"二级分类","字段见物料管理","物料档案表-F列二级分类",null,"下拉式","√"]
[83,null,null,null,"三级分类","字段见物料管理","物料档案表-G列三级分类",null,"下拉式","√"]
[84,null,null,null,"品牌","心连心、手拉手、沃利沃、双心、空","物料档案表-H列品牌",null,"下拉式","√"]
[85,null,null,null,"复合肥肥效","高效二、普通、空","物料档案表-I列复合肥肥效",null,"点选","√"]
[86,null,null,null,"产品线","尿素、复合肥","物料档案表-J列产品线",null,"点选","√"]
[87,null,null,null,"工艺",null,"物料档案表-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":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[2,0,9,0],[10,0,17,0],[2,1,9,1],[10,1,17,1],[2,2,3,2],[4,2,8,2],[13,2,17,2],[2,4,3,4],[4,4,7,4],[13,4,16,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,"其他","手动输入"]

{"sheet":"工单管理","index":3,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,7],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[2,0,11,0],[12,0,19,0],[20,0,29,0],[30,0,35,0],[36,0,41,0],[42,0,48,0],[49,0,54,0],[2,1,11,1],[12,1,19,1],[20,1,29,1],[30,1,35,1],[36,1,41,1],[42,1,48,1],[49,1,54,1],[2,2,5,2],[7,2,11,2],[12,2,15,2],[17,2,19,2],[20,2,23,2],[25,2,29,2],[30,2,33,2],[36,2,39,2],[42,2,45,2],[47,2,48,2],[49,2,52,2],[8,3,11,3],[18,3,19,3],[26,3,29,3]]}
["序号","模块","字段信息",null,null,"描述","展现方式","必填项","备注"]
[1,"手制工单","与来电弹屏一致"]
[2,"待指派工单","筛选项","起止时间",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,"操作工单","修改","默认修改所有字段（系统字段除外）加保存按钮"]
[{"$nulls":4},"分配","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n处理内容：输入框\n接收部门：\n接收人：\n超时时限：\n短信提醒：\n确定（按钮）"]
[{"$nulls":4},"处理","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n处理内容：输入框\n处理状态：完结、未完结（点选）\n确定（按钮）"]
[{"$nulls":4},"删除","二次确认：确认删除当前记录？是、否（点选）","按钮"]
[3,"待接单工单","筛选项","起止时间",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,"操作工单","接单","二次确认：您确定要接单吗？","按钮"]
[{"$nulls":4},"退回","二次确认：您确定要退回当前工单吗？","按钮"]
[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,"操作工单","分配","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n处理内容：输入框\n点选：处理结果（已处理，未处理）若点选未处理，则弹出点选：未处理原因（资金、技术、人员、其他（若选其他，则手输））\n接收部门：\n接收人：\n超时时限：\n短信提醒：\n确定（按钮）","参照三元"]
[{"$nulls":4},"处理","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n处理内容：输入框\n点选：处理结果（已处理，未处理）若点选未处理，则弹出点选：未处理原因（资金、技术、人员、其他（若选其他，则手输））\n处理状态：完结、未完结（点选）\n确定（按钮）","参照三元"]
[{"$nulls":4},"异常退回","请输入异常退回原因：输入框\n确定、取消（按钮）","参照三元"]
[{"$nulls":4},"申请延期","点选：申请延期时限（1小时、8小时、24小时、其他手动输入）\n请输入申请延期原因：输入框\n确定、取消（按钮）"]
[5,"已处理工单","筛选项","起止时间",null,null,"参照三元"]
[null,null,null,"工单来源",null,null,"下拉"]
[null,null,null,"工单类型","工单类型",null,"下拉"]
[null,null,null,"搜索框","搜索框","请输入工单编号、姓名、电话查询","参照三元"]
[null,null,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,null,"报表","表头字段",null,"工单编号、工单状态、工单来源、工单类型丨△丨渠道类型、问题类别丨△丨客户编码、客户姓名、电话、性别、公司名称、来电时间、客户地址、重要级别丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、是否需要回访、回访人、回访完成时间、创建人、创建时间、操作工单","报表",null,"点击工单编号展示工单详情、处理记录、催办记录、评论记录、修改记录"]
[6,"已参与工单","筛选项","起止时间",null,null,"参照三元"]
[null,null,null,"工单来源",null,null,"下拉"]
[null,null,null,"工单类型","工单类型",null,"下拉"]
[null,null,null,"搜索框","搜索框","请输入工单编号、姓名、电话查询","参照三元"]
[null,null,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,null,"报表","表头字段",null,"工单编号、工单状态、工单来源、工单类型丨△丨渠道类型、问题类别丨△丨客户编码、客户姓名、电话、性别、公司名称、来电时间、客户地址、重要级别丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、是否需要回访、回访人、回访完成时间、创建人、创建时间、操作工单","报表",null,"点击工单编号展示工单详情、处理记录、催办记录、评论记录、修改记录"]
[7,"超期工单","筛选项","起止时间",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,"操作工单","催办","请输入催办内容：输入框"]
[8,"综合查询","筛选项","起止时间",null,null,"参照三元"]
[null,null,null,"工单来源",null,null,"下拉"]
[null,null,null,"工单类型","工单类型",null,"下拉"]
[null,null,null,"搜索框","搜索框","请输入工单编号、姓名、电话查询","参照三元"]
[null,null,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,null,"报表","表头字段",null,"工单编号、工单状态、工单来源、工单类型丨△丨渠道类型、问题类别丨△丨客户编码、客户姓名、电话、性别、公司名称、来电时间、客户地址、重要级别丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、是否需要回访、回访人、回访完成时间、创建人、创建时间、操作工单","报表",null,"点击工单编号展示工单详情、处理记录、催办记录、评论记录、修改记录"]

{"sheet":"回访管理","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[1,0,11,0],[12,0,21,0],[22,0,29,0],[30,0,36,0],[1,1,11,1],[12,1,21,1],[22,1,29,1],[30,1,36,1],[1,2,4,2],[7,2,11,2],[12,2,15,2],[18,2,21,2],[22,2,25,2],[28,2,29,2],[30,2,33,2],[8,3,11,3],[19,3,21,3]]}
["序号","模块","字段信息",null,null,"描述","展现方式","必填项","备注"]
[1,"待回访工单","筛选项","起止时间",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,"直接点击\n电话\n弹出回访信息","工单信息","字段待定"]
[{"$nulls":4},"呼叫结果",null,"参照绿地"]
[{"$nulls":4},"问卷信息","点选：处理结果（非常满意、满意、一般、不满意）\n点选：不满意原因（处理慢、服务差、其他）若选其他则手动输入"]
[{"$nulls":4},"是否完结","点选：完结工单、重新发起（若选完结工单，则工单流转至已完结工单和已回访工单）","按钮"]
[2,"已回访工单","筛选项","起止时间",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,"直接点击\n电话\n弹出回访信息","工单信息","字段同待回访工单，显示呼叫结果及满意度调查结果"]
[{"$nulls":4},"呼叫结果",null,"参照绿地"]
[{"$nulls":4},"问卷信息",null,"参照绿地"]
[3,"待完结工单","筛选项","起止时间",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,"操作工单","完结","是否完结工单","按钮"]
[4,"已完结工单\n（=已回访工单+完结工单）","筛选项","起止时间",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":"客户管理","index":5,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[15,0,15,5],[2,0,7,0],[8,0,11,0],[12,0,14,0],[2,1,7,1],[8,1,11,1],[12,1,14,1]]}
["序号","模块","字段","详情","展现方式","备注",{"$nulls":16},"备注"]
[1,"报表","报表全字段","大区、分公司、客户编码、客户名称、业务员1、电话1、客户性质、渠道类型、信用等级、法人、电话1、地址详址、经营品牌、产品、复合肥心连心、复合肥手拉手、复合肥沃利沃、复合肥双心、尿素心连心、尿素手拉手、尿素沃利沃、尿素双心、创建时间、备注、冻结标志、是否开户、上级客户编码、上级客户名称、助记码、开票银行名称、开票银行账号、纳税人登记号、市、县、乡、村、是否经营心连心、年销量、配方、种植作物、种植面积、用肥品牌\n\n其中大区、分公司、渠道类型、信用等级加入下拉筛选","报表","红色为NC表不具备项"]
[2,"搜索项","大区","分公司上级","下拉式"]
[null,null,"分公司","大区下一级","下拉式"]
[null,null,"省市县乡村","省市县乡下拉 村手输","下拉式"]
[null,null,"客户编码","固定10位纯数字","手输"]
[null,null,"客户姓名","对应-法人（可检索全局）","手输"]
[null,null,"电话","对应-电话1（可检索全局）","手输"]
[3,"报表上方操作","搜索",null,"按钮点击跳转"]
[null,null,"添加用户","全字段添加","参照三元"]
[null,null,"导入","全字段为模板导入","参照三元"]
[null,null,"批量删除","加入二级确认","参照三元"]
[4,"报表内操作","详情","只展现所有字段信息","点击按钮弹出二级页面"]
[null,null,"修改","全字段修改","参照三元"]
[null,null,"删除","加入二级确认","按钮"]
["分割线"]
[null,"NC表头字段","更改后","对应字段","展现方式","必填项"]
[1,"大区",null,"见大区、分公司分布表","下拉式","√"]
[2,"分公司",null,"见大区、分公司分布表","下拉式"]
[3,"客户编码",null,"10位数字","手输"]
[4,"客户名称","公司名称",null,"手输"]
[5,"业务员1","业务员",null,"手输"]
[6,"电话1","电话",null,"手输"]
[7,"客户性质",null,null,"手输"]
[8,"渠道类型",null,"总经销、二级商、种田大户、农户、化工客户、公司员工","下拉式"]
[9,"信用等级",null,"一星、二星、三星、四星、五星、空","下拉式"]
[10,"法人","法人",null,"手输"]
[11,"电话1","电话",null,"手输"]
[12,"地址详址","省","省分布表","下拉式"]
[13,"经营品牌",null,"心连心、手拉手、沃利沃、双心、空","点选"]
[14,"产品",null,"复合肥心连心、复合肥手拉手、复合肥沃利沃、复合肥双心、尿素心连心、尿素手拉手、尿素沃利沃、尿素双心","点选多选"]
[15,"复合肥心连心",null,null,"手输"]
[16,"复合肥手拉手",null,null,"手输"]
[17,"复合肥沃利沃",null,null,"手输"]
[18,"复合肥双心",null,null,"手输"]
[19,"尿素心连心",null,null,"手输"]
[20,"尿素手拉手",null,null,"手输"]
[21,"尿素沃利沃",null,null,"手输"]
[22,"尿素双心",null,null,"手输"]
[23,"创建时间",null,null,"手输"]
[24,"备注",null,null,"手输"]
[25,"冻结标志",null,"Y、N","点选"]
[26,"是否开户",null,"已开户、未开户","点选"]
[27,"上级客户编码",null,null,"手输"]
[28,"上级客户名称",null,null,"手输"]
[29,"助记码",null,null,"手输"]
[30,"开票银行名称",null,null,"手输"]
[31,"开票银行账号",null,null,"手输"]
[32,"纳税人登记号",null,null,"手输"]
[33,"无","市",null,"下拉式"]
[34,"无","县",null,"下拉式"]
[35,"无","乡",null,"下拉式"]
[36,"无","村",null,"手输"]
[37,"无","是否经营心连心","是、否","点选"]
[38,"无","年销量",null,"手输"]
[39,"无","配方",null,"手输"]
[40,"无","种植作物",null,"手输"]
[41,"无","种植面积",null,"手输"]
[42,"无","用肥品牌","心连心、新洋丰、史丹利、金正大、其他手输","下拉式"]

{"sheet":"物料管理","index":6,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,0,12,5],[2,0,4,0],[5,0,8,0],[9,0,11,0],[2,1,4,1],[5,1,8,1],[9,1,11,1]]}
["序号","模块","字段","详情","展现方式","备注",{"$nulls":16},"备注"]
[1,"字段","报表全字段","物料编码、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺\n其中：一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺均加入下拉筛选操作","报表"]
[2,"搜索项","物料编码","必须输入11位纯数字搜索","手动输入","11位纯数字"]
[null,null,"物品名称","在物品名称栏检索","手动输入"]
[null,null,"其他（预留）"]
[3,"报表上方操作","搜索",null,"按钮点击跳转"]
[null,null,"添加","全字段添加","参照三元"]
[null,null,"导入","全字段为模板导入","参照三元"]
[null,null,"批量删除","加入二级确认","参照三元","？是否是给超级管理员删除权限"]
[4,"报表内操作","详情","只展现所有字段信息","点击按钮弹出二级页面"]
[null,null,"修改","全字段修改","参照三元"]
[null,null,"删除","加入二级确认","按钮","仅超级管理员有删除权限"]
["分割线"]
["序号","物料表头字段",null,"对应字段","展现方式","必填项"]
[1,"物料编码",null,"11位纯数字","手工输入"]
[2,"物料名称",null,null,"手工输入"]
[3,"型号",null,null,"手工输入"]
[4,"规格",null,null,"手工输入"]
[5,"一级分类",null,null,"手工输入"]
[6,"二级分类",null,null,"手工输入"]
[7,"三级分类",null,null,"手工输入"]
[8,"品牌",null,"心连心、手拉手、沃利沃、双心、空","下拉式"]
[9,"复合肥肥效",null,"高效二、普通、空","点选"]
[10,"产品线",null,"尿素、复合肥","点选"]
[11,"工艺",null,null,"手动输入"]

{"sheet":"知识库","index":7,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,0,1,0],[2,0,7,0],[8,0,17,0],[18,0,27,0],[28,0,32,0],[33,0,39,0],[40,0,46,0],[2,1,7,1],[8,1,17,1],[18,1,27,1],[28,1,32,1],[33,1,39,1],[40,1,46,1]]}
["序号","目录树"]
[null,"部门","目录",null,"模板字段"]
[1,"客服中心","客户咨询100问",null,"字段"]
[null,null,"公司简介"]
[null,null,"业务员联系方式"]
[null,null,"客户档案"]
[null,null,"客服系统操作说明书"]
[null,null,"其他"]
[2,"市场管理科","产品、促销音视频"]
[null,null,"会议营销资料"]
[null,null,"防窜货管理规定、市场管控文件"]
[null,null,"质量投诉、抽检表格模板"]
[null,null,"公司证件（心连心、农心）"]
[null,null,"肥料标准"]
[null,null,"样板市场"]
[null,null,"旗舰店、主力店"]
[null,null,"墙体广告"]
[null,null,"检验报告"]
[2,"规划发展与营销策划中心","宣传广告片"]
[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,"大区开发课题"]
[4,"销售管理部","综合类"]
[null,null,"通知类"]
[null,null,"模板"]
[null,null,"公司证件、专利"]
[null,null,"文件类"]
[null,null,"公司荣誉"]
[null,null,"培训及宣传报道"]
[5,"农化服务科","肥效展示模板"]
[null,null,"农化知识宝典"]
[null,null,"科技知识宣传"]
[null,null,"示范田牌模板"]
[null,null,"示范对照小标签"]
[null,null,"示范村喷绘条幅等"]
[null,null,"观摩会条幅"]
[6,"农技处","测土"]
[7,"吉林公司"]
[8,"九江公司"]
[9,"新疆公司"]

{"sheet":"报表管理","index":8,"n_rows":13,"n_cols":46,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["化肥市场问题反馈明细表"]
["序号","年月日（按年、月、日等可选择）","基地（下拉框可选基地）","渠道类型（总经销、二级商、种田大户、公司员工、农户）","反馈类型（投诉、咨询及需求、抽检、其他）","数量（吨）","费用（元）","NC客户名称","市场/发生地","分公司","大区","业务员","产品（化肥 ）","品牌（心连心、手拉手、沃力沃、双心）","系列","配方","分类","规格","生产单位","问题类型","具体问题","反馈日期","提货日期","生产批次","超期时限","关闭工单",{"$nulls":6},"具体问题","反馈日期","提货日期","喷码信息","超期时限","问题数量","退换货数量","公司承担","大区承担费用","技术中心承担","物流公司承担","二分公司承担","四分公司承担","……承担"]
[null,"1、分区域、分渠道类别、分反馈类型、分产品、分品牌、分时间去分析市场反馈问题 的数量、金额及责任科室和处理情况，如2019年5月投诉结块问题有多少，分别是哪个基地、大区、分公司发生的，哪个科室责任关闭与否，并且有品牌、数量和费用"]
[]
["市场问题处理时效明细表"]
["序号","年月日（按年、月、日等可选择）","基地（下拉框可选基地）","责任科室","处理工单数量（及时、超时）","反馈类型","需求满足（已满足、未满足）","为满足原因（资金、技术、人员、其他）"]
[null,null,"    ",null,"及时：在要求时限内流转至下一节点"]
[{"$nulls":4},"超时：操作处理超过要求时限"]
["化工产品市场投诉汇总表"]
["序号","化工产品名称","客户单位","生产日期","反馈日期","产品名称","喷码","问题描述","处理方法"]
[null,"按产品分类表"]
[]
["话务报表按照模板全部都要，谢谢"]

{"sheet":"权限管理-部门管理","index":9,"n_rows":203,"n_cols":9,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
["集团","一级部门","二级部门","二级部门/大区","三级部门/分公司","人员","性别","职务","手机"]
["河南心连心化学工业集团股份有限公司","化工品销售部","出口贸易","大客户科"]
[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,"销售大区","豫东大区","连宿分公司"]
[{"$nulls":4},"徐州分公司"]
[{"$nulls":4},"商丘分公司"]
[{"$nulls":4},"淮北分公司"]
[{"$nulls":4},"阜阳分公司"]
[{"$nulls":4},"亳州分公司"]
[null,null,null,"豫南大区","信阳分公司"]
[{"$nulls":4},"漯河分公司"]
[{"$nulls":4},"周口北分公司"]
[{"$nulls":4},"周口南分公司"]
[{"$nulls":4},"驻马店北分公司"]
[{"$nulls":4},"驻马店南分公司"]
[null,null,null,"豫西大区","运城分公司"]
[{"$nulls":4},"许昌分公司"]
[{"$nulls":4},"南阳分公司"]
[{"$nulls":4},"洛阳分公司"]
[{"$nulls":4},"临汾分公司"]
[{"$nulls":4},"襄阳分公司"]
[null,null,null,"豫北大区","开封分公司"]
[{"$nulls":4},"直销分公司"]
[{"$nulls":4},"新乡分公司"]
[{"$nulls":4},"濮阳分公司"]
[{"$nulls":4},"焦作分公司"]
[{"$nulls":4},"安阳分公司"]
[null,null,null,"鲁西大区","聊泰分公司"]
[{"$nulls":4},"济宁分公司"]
[{"$nulls":4},"菏泽分公司"]
[{"$nulls":4},"德州分公司"]
[null,null,null,"冀南大区","石家庄分公司"]
[{"$nulls":4},"邢台分公司"]
[{"$nulls":4},"邯郸分公司"]
[{"$nulls":4},"保沧分公司"]
[null,null,null,"晋陕大区","晋北分公司"]
[{"$nulls":4},"晋南分公司"]
[{"$nulls":4},"陕北分公司"]
[{"$nulls":4},"陕南分公司"]
[null,null,null,"鲁东大区","临沂分公司"]
[{"$nulls":4},"青岛分公司"]
[{"$nulls":4},"潍坊分公司"]
[{"$nulls":4},"烟威分公司"]
[null,null,null,"西南大区","川北分公司"]
[{"$nulls":4},"川南分公司"]
[{"$nulls":4},"重庆分公司"]
[{"$nulls":4},"滇东分公司"]
[{"$nulls":4},"滇西分公司"]
[null,null,null,"两广大区","桂东分公司"]
[{"$nulls":4},"桂南分公司"]
[{"$nulls":4},"桂西分公司"]
[{"$nulls":4},"桂北分公司"]
[{"$nulls":4},"广东分公司"]
[{"$nulls":4},"海南分公司"]
[null,null,null,"沃利沃品牌业务部","豫东分公司"]
[{"$nulls":4},"沃利沃豫东分公司"]
[{"$nulls":4},"沃利沃豫南分公司"]
[{"$nulls":4},"沃利沃豫西分公司"]
[{"$nulls":4},"沃利沃冀南分公司"]
[{"$nulls":4},"沃利沃鲁西分公司"]
[{"$nulls":4},"沃利沃豫北分公司"]
[null,null,null,"吉林大区","通化分公司"]
[null,null,"综合部","综合管理科"]
[null,null,null,"采购科"]
[null,null,"生产管理部","工艺环保科"]
[null,null,null,"生产调度科"]
[null,null,null,"原料车间"]
[null,null,null,"质量管理科"]
[null,null,null,"一车间","1#线"]
[{"$nulls":4},"2#线"]
[{"$nulls":4},"3#线"]
[{"$nulls":4},"4#线"]
[null,null,null,"二车间","1#塔"]
[{"$nulls":4},"2#塔"]
[null,null,null,"三车间","三车间生产线"]
[null,null,null,"办公室"]
[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,"天欣煤矿","地测科"]
[{"$nulls":4},"生产技术队"]
[{"$nulls":4},"综合办"]
[{"$nulls":4},"安监科"]
[{"$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,"湖南大区","常德分公司"]
[{"$nulls":4},"湘南分公司"]
[{"$nulls":4},"湘北分公司"]
[{"$nulls":4},"湘西分公司"]
[null,null,null,"湖北大区","鄂东分公司"]
[{"$nulls":4},"鄂西分公司"]
[null,null,null,"江苏大区","苏中分公司"]
[{"$nulls":4},"苏南分公司"]
[null,null,null,"皖浙大区","皖中分公司"]
[{"$nulls":4},"浙北分公司"]
[{"$nulls":4},"皖西分公司"]
[{"$nulls":4},"皖南分公司"]
[{"$nulls":4},"浙南分公司"]
[null,null,null,"闽赣大区","抚州分公司"]
[{"$nulls":4},"赣州分公司"]
[{"$nulls":4},"福建分公司"]
[{"$nulls":4},"上饶分公司"]
[{"$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,"销售部","黑龙江大区","佳木斯分公司"]
[{"$nulls":4},"黑河分公司"]
[{"$nulls":4},"大庆分公司"]
[{"$nulls":4},"牡丹江分公司"]
[{"$nulls":4},"哈绥分公司"]
[null,null,null,"冀蒙大区","赤峰分公司"]
[{"$nulls":4},"唐山分公司"]
[{"$nulls":4},"蒙中分公司"]
[null,null,null,"辽宁大区","辽西分公司"]
[{"$nulls":4},"辽北分公司"]
[{"$nulls":4},"辽南分公司"]
[null,null,null,"吉林大区","通辽分公司"]
[{"$nulls":4},"通化分公司"]
[{"$nulls":4},"长春分公司"]
[{"$nulls":4},"吉西分公司"]
[null,"新疆黑色生态科技股份有限公司","综合部"]
[null,"河南心连心蓝色环保科技有限公司蓝色科技","生产部"]
[null,null,"综合管理部"]
[null,null,"加注站业务部"]
[null,"河南氢力能源有限公司","销售部"]
[null,null,"采购部"]
[null,null,"生产部"]
[null,null,"财务部"]
[null,null,"综合部"]
[null,"总经理办公室","高层"]
[null,null,"办公室"]

{"sheet":"对接人列表","index":10,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7],[20,1,20,6]]}
["心连心客户服务系统市场服务专员"]
["序号","部门","人员","联系方式","序号","部门","人员","联系方式"]
[1,"新乡质量","杜爱国","13673511064",19,"九江销售行为投诉","刘秀汉",17603739001]
[2,"新乡尿素质量","李波","13613906775",20,"九江营销、质量投诉","刘孝辉",13133662660]
[3,"新乡尿素质量","张邵申","13782525126",21,"九江营销、质量投诉","袁帅坤",13133669508]
[4,"新乡复合肥质量","朱晓杰",15893854874,22,"九江产品农化投诉需求","岳艳军",13155989031]
[5,"新乡铁运、装卸","吴玮玮","13462268080",23,"九江物流投诉需求","郭玉中",13133669958]
[6,"新乡产品","张锋",13937326542,24,"九江销售需求","张大伟",13133667008]
[7,"新乡品牌","张洁","15090370010",25,"新疆事业部","仝琳/王瑞娟","需确定解决问题的对应责任人","主价值链责任科室即可"]
[8,"新乡汽运","黄存志","15903099577",26,"吉林基地","张朝杰","需确定解决问题的对应责任人","主价值链责任科室即可"]
[9,"新乡市场","白有金","13839092802",27,"三胺","刘云成","15537376161"]
[10,"新乡贴牌","杜习波","13703730128",28,"甲醇/液氨","张兵","17603739008"]
[11,"新乡农化","马延东","17698228130",29,"二甲醚","李治果",17698233260]
[12,"新乡尿素政策","王延毅","17603739092",30,"车用尿素","史慧琳"]
[13,"新乡复合肥政策","张胜乐","17603738592",31,"氢力能源","李陆军","13462301856"]
[14,"新乡销售财务","关宁","18803732282",32,"黑色科技","段艳慧",15560116633]
[15,"新乡采购","范勤勇",null,33,"禾力能源","王明旺","15249729290"]
[16,"新乡技术测土","张书红","18637394794",34,"深冷气体","宋纪峰","13837312330"]
[17,"出口贸易","郑楠",null,35]
[18,"新业务","刘付灿","18638318968",36]
["职责","1、负责对应模块工作的业务处理、需求满足和及时反馈；\n2、负责对应模块知识库的建立与更新维护。"]

{"sheet":"市场管理科界面","index":11,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1]]}
["序号","模块","字段信息",null,"描述","展现方式","必填项","备注"]
[1,"筛选项","起止时间",null,null,"参照三元"]
[null,null,"工单来源",null,null,"下拉"]
[null,null,"工单类型",null,null,"下拉"]
[2,"搜索框",null,null,"请输入工单编号、姓名、电话查询","参照三元"]
[3,"搜索",null,null,"点击跳转，参照三元","按钮"]
[4,"待接单工单","同工单管理",null,"同工单管理","同工单管理"]
[5,"已接单工单","同工单管理",null,"同工单管理","同工单管理"]
[6,"待处理工单","操作工单","分配","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n点选：生产基地（新乡、新疆、九江、东北、贴牌、无法确定）\n投诉类、咨询类、需求类填写以下字段：\n自动获取：超出质保期限（算法：工单创建日期-生产日期，生产日期根据生产批次号获取，单位：月）\n点选：初审意见（退货、换货、补偿、自行处理）\n处理内容：输入框\n点选：处理结果（已处理，未处理）若点选未处理，则弹出点选：未处理原因（资金、技术、人员、其他（若选其他，则手输））\n抽检类填写以下字段：\n点选：抽检结果（视同合格、合格、不合格、复检后合格、未送检）\n手输：自检结果\n手输：对应审批工作流单号\n手输：确认返账金额（元）\n公共字段：\n接收部门：\n接收人：\n超时时限：\n短信提醒：1、您有一条新的工单，工单编号为：xxx，请尽快处理！（默认为接收人电话）2、抄送给业务员：您好！X月X日发起的XXX号投诉工单，质量管理部已处理，详情可通过微信端口/PC查看！）（业务员联系方式从客户编码所对应业务员联系方式获取，如果没有则不发送短信）\n确定（按钮）","按钮"]
[null,null,null,"处理","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n点选：生产基地（新乡、新疆、九江、东北、贴牌、无法确定）\n自动获取：超出质保期限（算法：工单创建日期-生产日期，生产日期根据生产批次号获取，单位：月）\n点选：初审意见（退货、换货、补偿、自行处理）\n短信提醒：抄送给业务员：您好！X月X日发起的XXX号投诉工单，质量管理部已处理，详情可通过微信端口/PC查看！）（业务员联系方式从客户编码所对应业务员联系方式获取，如果没有则不发送短信）\n处理内容：输入框\n点选：处理结果（已处理，未处理）若点选未处理，则弹出点选：未处理原因（资金、技术、人员、其他（若选其他，则手输））\n处理状态：完结、未完结（点选）\n确定（按钮）","按钮"]
[7,"已处理工单",null,null,"同工单管理，报表字段增加生产基地、超出质保期限、初审意见"]

{"sheet":"质量管理部界面","index":12,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1]]}
["序号","模块","字段信息",null,"描述","展现方式","必填项","备注"]
[1,"筛选项","起止时间",null,null,"参照三元"]
[null,null,"工单来源",null,null,"下拉"]
[null,null,"工单类型",null,null,"下拉"]
[2,"搜索框",null,null,"请输入工单编号、姓名、电话查询","参照三元"]
[3,"搜索",null,null,"点击跳转，参照三元","按钮"]
[4,"待接单工单","同工单管理",null,"同工单管理","同工单管理"]
[5,"已接单工单","同工单管理",null,"同工单管理","同工单管理"]
[6,"待处理工单","操作工单","分配","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n投诉类、咨询类、需求类字段：\n点选：质量事件等级（未遂、一般、较大、重大）\n手输：索赔金额（单位元，对应责任单位）\n点选：责任单位（需列出，可选多个）\n点选：审批意见（同意、不同意，若选择不同意，增加输入框输入补充内容）\n点选：补偿方式（实物、钱款【单位元】，若选择钱款，增加输入框输入补充内容）\n处理内容：输入框\n点选：处理结果（已处理，未处理）若点选未处理，则弹出点选：未处理原因（资金、技术、人员、其他（若选其他，则手输））\n下拉：对应责任单位（生产、研发、农化、物流、质量管理科，销售内勤）\n手输：确认实收数量（吨）\n手输：改进要求\n手输：对应审批工作流单号\n抽检类字段：\n点选：未备案、已备案\n公共字段：\n点选：是否建议回访（是，否）此项若选是，则流转到客服-待回访工单，若选否，则流转至客服待完结工单\n手输：索赔金额（单位：元）\n按钮：申请关闭工单\n接收部门：\n接收人：\n超时时限：\n短信提醒：1、您有一条新的工单，工单编号为：xxx，请尽快处理！（默认为接收人电话）2、抄送给业务员：您好！X月X日发起的XXX号投诉工单，质量管理部已处理，详情可通过微信端口/PC查看！）（业务员联系方式从客户编码所对应业务员联系方式获取，如果没有则不发送短信）\n确定（按钮）","按钮"]
[null,null,null,"处理","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n投诉类、咨询类、需求类字段：\n点选：质量事件等级（未遂、一般、较大、重大）\n手输：索赔金额（单位元，对应责任单位）\n点选：责任单位（需列出，可选多个）\n点选：审批意见（同意、不同意，若选择不同意，增加输入框输入补充内容）\n点选：补偿方式（实物、钱款【单位元】，若选择钱款，增加输入框输入补充内容）\n处理内容：输入框\n点选：处理结果（已处理，未处理）若点选未处理，则弹出点选：未处理原因（资金、技术、人员、其他（若选其他，则手输））\n下拉：对应责任单位（生产、研发、农化、物流、质量管理科，销售内勤）\n手输：确认实收数量（吨）\n手输：改进要求\n手输：对应审批工作流单号\n抽检类字段：\n点选：未备案、已备案\n公共字段：\n点选：是否建议回访（是，否）此项若选是，则流转到客服-待回访工单，若选否，则流转至客服待完结工单\n手输：索赔金额（单位：元）\n按钮：申请关闭工单\n短信提醒：抄送给业务员：您好！X月X日发起的XXX号投诉工单，质量管理部已处理，详情可通过微信端口/PC查看！）（业务员联系方式从客户编码所对应业务员联系方式获取，如果没有则不发送短信）\n确定（按钮）","按钮"]
[7,"已处理工单",null,null,"同工单管理，报表字段增加生产基地、超出质保期限、初审意见"]

{"sheet":"质量管理科界面","index":13,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1]]}
["序号","模块","字段信息",null,"描述","展现方式","必填项","备注"]
[1,"筛选项","起止时间",null,null,"参照三元"]
[null,null,"工单来源",null,null,"下拉"]
[null,null,"工单类型",null,null,"下拉"]
[2,"搜索框",null,null,"请输入工单编号、姓名、电话查询","参照三元"]
[3,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,"待接单工单",null,null,"同工单管理"]
[4,"待处理工单","操作工单","分配","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n手输：确认实收数量（吨）\n接收部门：\n接收人：\n超时时限：\n短信提醒：1、您有一条新的工单，工单编号为：xxx，请尽快处理！（默认为接收人电话）2、抄送给业务员：您于X月X日发起的XXX号工单，质量管理科已已返厂入库XX吨，请及时查看)（业务员联系方式从客户编码所对应业务员联系方式获取，如果没有则不发送短信）\n确定（按钮）","同工单管理"]
[null,"已处理工单"]

{"sheet":"销售内勤界面","index":14,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1]]}
["序号","模块","字段信息",null,"描述","展现方式","必填项","备注"]
[1,"筛选项","起止时间",null,null,"参照三元"]
[null,null,"工单来源",null,null,"下拉"]
[null,null,"工单类型",null,null,"下拉"]
[2,"搜索框",null,null,"请输入工单编号、姓名、电话查询","参照三元"]
[3,"搜索",null,null,"点击跳转，参照三元","按钮"]
[4,"待接单工单",null,null,"同工单管理"]
[5,"待处理工单","操作工单","处理","展示：工单编号、工单来源、工单类型、客户姓名、电话、问题描述\n手输：确认返账金额（元）\n短信提醒：抄送给业务员：您于X月X日发起的XXX号工单，销售内勤已确认返账金额x元，请及时查看)（业务员联系方式从客户编码所对应业务员联系方式获取，如果没有则不发送短信）\n确定（按钮）"]
[6,"已处理工单",null,null,"同工单管理"]
[7,"知识库",null,null,"同三元"]
[8,"系统管理",null,null,"同三元"]

{"sheet":"业务员微信界面","index":15,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,7,0],[2,1,7,1],[2,2,4,2]]}
["序号","模块","字段信息",null,"描述","展现方式","必填项","备注"]
[1,"创建工单",null,null,"设置页面按钮+号，点击触发手制工单（同PC话务员）"]
[2,"已参与工单列表","筛选项","起止时间",null,"同工单管理","参照三元"]
[null,null,null,"工单来源",null,"同工单管理","下拉"]
[null,null,null,"工单类型",null,"同工单管理","下拉"]
[null,null,"搜索框",null,null,"同工单管理","参照三元"]
[null,null,"搜索",null,null,"同工单管理","按钮"]
[null,null,"报表",null,"工单编号、工单状态、工单来源、工单类型丨△丨渠道类型、问题类别丨△丨客户编码、客户姓名、电话、性别、公司名称、来电时间、客户地址、重要级别丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、是否需要回访、回访人、回访完成时间、创建人、创建时间、操作工单"]

{"sheet":"分公司经理界面","index":16,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[8,3,8,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[1,0,10,0],[11,0,16,0],[11,1,16,1],[1,2,4,2],[8,2,10,2],[11,2,14,2],[9,3,10,3]]}
["序号","模块","字段信息",null,null,"描述","展现方式","必填项","备注"]
[1,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,"操作工单","审批","二次确认：您确定要审批吗？（确认审批后开始工单计时，超过24小时记录此条未审批记录，默认流转至下一级审批领导）","按钮"]
[{"$nulls":4},"审批页面","点选：审批（同意上报、驳回修订、强制结案）选择强制结案不再往领导流转\n输入框：处理意见\n接收部门：（只显示对应上级部门）可固定\n接收人：（只显示对应上级大区经理）可固定\n超时时限：\n短信提醒：\n确定（按钮）"]
[2,"已审批工单","筛选项","起止时间",null,null,"参照三元"]
[null,null,null,"工单来源",null,null,"下拉"]
[null,null,null,"工单类型","工单类型",null,"下拉"]
[null,null,null,"搜索框","搜索框","请输入工单编号、姓名、电话查询","参照三元"]
[null,null,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,null,"报表","表头字段",null,"工单编号、工单状态、工单来源、工单类型丨△丨渠道类型、问题类别丨△丨客户编码、客户姓名、电话、性别、公司名称、来电时间、客户地址、重要级别丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、审批意见、领导审批意见、是否需要回访、回访人、回访完成时间、创建人、创建时间","报表",null,"点击工单编号展示工单详情、处理记录、催办记录、评论记录、修改记录"]

{"sheet":"大区经理界面","index":17,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[1,0,8,0],[9,0,14,0],[1,1,8,1],[9,1,14,1],[1,2,4,2],[6,2,8,2],[9,2,12,2],[7,3,8,3]]}
["序号","模块","字段信息",null,null,"描述","展现方式","必填项","备注"]
[1,"待审批工单","筛选项","起止时间",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,"操作工单","审批","二次确认：您确定要审批吗？（确认审批后开始工单计时，超过24小时记录此条未审批记录，默认流转至市场管理科）","按钮"]
[{"$nulls":4},"审批页面","点选：审批（同意上报、驳回修订、强制结案）选择强制结案不再往领导流转\n输入框：处理意见\n接收部门：固定为市场管理科\n接收人：默认为第一责任人\n超时时限：\n短信提醒：\n确定（按钮）"]
[2,"已审批工单","筛选项","起止时间",null,null,"参照三元"]
[null,null,null,"工单来源",null,null,"下拉"]
[null,null,null,"工单类型","工单类型",null,"下拉"]
[null,null,null,"搜索框","搜索框","请输入工单编号、姓名、电话查询","参照三元"]
[null,null,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,null,"报表","表头字段",null,"工单编号、工单状态、工单来源、工单类型丨△丨渠道类型、问题类别丨△丨客户编码、客户姓名、电话、性别、公司名称、来电时间、客户地址、重要级别丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、审批意见、是否需要回访、回访人、回访完成时间、创建人、创建时间","报表",null,"点击工单编号展示工单详情、处理记录、催办记录、评论记录、修改记录"]

{"sheet":"高层界面","index":18,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[1,0,7,0],[8,0,13,0],[1,1,7,1],[8,1,13,1],[1,2,4,2],[6,2,7,2],[8,2,11,2]]}
["序号","模块","字段信息",null,null,"描述","展现方式","必填项","备注"]
[1,"待审批工单","筛选项","起止时间",null,null,"参照三元"]
[null,null,null,"工单来源",null,null,"下拉"]
[null,null,null,"工单类型","工单类型",null,"下拉"]
[null,null,null,"搜索框","搜索框","请输入工单编号、姓名、电话查询","参照三元"]
[null,null,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,null,"报表","表头字段",null,"工单编号、工单状态、工单来源、工单类型、渠道类型、问题类别、客户姓名、电话、性别、公司名称、来电时间、重要级别、丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、是否需要回访、回访人、回访完成时间、创建人、创建时间、操作工单","报表",null,"点击工单编号展示处理记录时间轴\n工单编号高亮提醒"]
[{"$nulls":4},"审批页面","输入框：处理意见\n接收部门：固定为质量管理部\n接收人：默认为第一责任人\n超时时限：\n短信提醒：\n确定（按钮）"]
[2,"已审批工单","筛选项","起止时间",null,null,"参照三元"]
[null,null,null,"工单来源",null,null,"下拉"]
[null,null,null,"工单类型","工单类型",null,"下拉"]
[null,null,null,"搜索框","搜索框","请输入工单编号、姓名、电话查询","参照三元"]
[null,null,"搜索",null,null,"点击跳转，参照三元","按钮"]
[null,null,"报表","表头字段",null,"工单编号、工单状态、工单来源、工单类型丨△丨渠道类型、问题类别丨△丨客户编码、客户姓名、电话、性别、公司名称、来电时间、客户地址、重要级别丨△丨事发地、大区、分公司、业务员、电话、产品、生产批次号、销售基地、产品名称、问题数量、处理方式丨△丨物料编码、带出以下信息、物料名称、型号、规格、一级分类、二级分类、三级分类、品牌、复合肥肥效、产品线、工艺、配方、产品种类丨△丨抽检时间、抽检级别、抽检单位、化验单位、抽检吨数、抽检袋数、生产批次号、公关费用金额、问题描述丨△丨接收部门、接收人、催办、超时提醒（剩余）、审批意见、是否需要回访、回访人、回访完成时间、创建人、创建时间","报表",null,"点击工单编号展示工单详情、处理记录、催办记录、评论记录、修改记录"]

{"sheet":"其他处理部门界面","index":19,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,3,0],[8,0,9,0],[1,1,3,1],[8,1,9,1],[8,2,9,2]]}
["序号","模块","字段信息",null,"描述","展现方式","必填项","备注"]
[1,"筛选项","起止时间",null,"同工单管理","参照三元"]
[null,null,"工单来源",null,"同工单管理","下拉"]
[null,null,"工单类型",null,"同工单管理","下拉"]
[2,"搜索框",null,null,"同工单管理","参照三元"]
[3,"搜索",null,null,"同工单管理","按钮"]
[4,"待接单工单","同工单管理",null,"同工单管理","同工单管理"]
[5,"已接单工单","同工单管理",null,"同工单管理","同工单管理"]
[6,"待处理工单","操作工单","分配","同工单管理","按钮"]
[null,null,null,"处理","同工单管理","按钮"]
[7,"已处理工单",null,null,"同工单管理"]

{"sheet":"Sheet1","index":20,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[38,0,38,2],[18,0,31,0],[36,0,37,0],[18,1,26,1],[27,1,31,1],[17,3,18,3],[1,4,4,4],[8,4,16,4],[17,4,18,4],[19,4,25,4],[26,4,31,4],[32,4,35,4],[1,5,3,5],[8,5,16,5],[17,5,25,5],[26,5,31,5],[32,5,35,5],[1,6,3,6],[8,6,16,6],[17,6,25,6],[26,6,31,6],[32,6,35,6],[1,7,4,7],[8,7,16,7],[19,7,25,7],[27,7,31,7],[32,7,35,7],[8,0,17,1],[32,0,35,1]]}
["模块",null,null,"优先级","开发时长","测试时长","人数","备注"]
["权限管理",null,null,1,"/",1,1,"已有模块，无需开发，但需配合测试联调"]
["部门管理",null,null,1]
["角色管理",null,null,1]
["用户管理",null,null,1,null,1,2]
["客户管理",null,null,1,3,1,2,"作为来电和工单的基础"]
["物料管理",null,null,1,3,1,2,"作为工单的基础"]
["IVR流程",null,null,1,1,1,1,"话务优先的原则"]
["话务管理",null,"通话记录",1,"/",1,2,"支撑话务基础，无需开发，但需配合测试联调"]
[null,null,"语音留言管理",1]
[null,null,"黑名单管理",1]
[null,null,"号码归属地",1]
[null,null,"值班电话管理",1]
[null,null,"工作日管理",1]
[null,null,"工作时间管理",1]
[null,null,"坐席监控管理",1]
[null,null,"坐席组管理",1]
[null,null,"来电弹屏",1,5,3,2,"包含工单管理、客户管理、物料管理、知识库基础模块"]
["工单管理","PC工单","手制工单",{"$nulls":4},"包含客户管理、物料管理；可与来电弹屏同步开发"]
[null,null,"待指派工单",1,5,null,null,"来电弹屏和手工制单为基础，需测试调整流程，以及每个流程下的操作界面"]
[null,null,"待接单工单",1]
[null,null,"待处理工单",1]
[null,null,"已处理工单",1]
[null,null,"已参与工单",1]
[null,null,"超期工单",1]
[null,null,"综合查询",1]
[null,null,"微信工单",2,5,3,2,"建议二期，建议微信提交工单后，由客服进行审核，在此有审核操作"]
[null,"微信工单","微信建单",2,null,null,null,"建议二期"]
[null,null,"待指派工单",2]
[null,null,"待接单工单",2]
[null,null,"待处理工单",2]
[null,null,"已处理工单",2]
["回访管理",null,"待回访工单",1,3,1,2,"配合工单模块，操作回访和完结工单"]
[null,null,"已回访工单",1]
[null,null,"待完结工单",1]
[null,null,"已完结工单",1]
["知识库","PC端","/",1,2,1,2,"建议一期上，可配合来电弹屏"]
[null,"微信端","/",2,3,2,2,"建议二期"]
["合计",null,null,null,{"$f":"SUM(E2:E38)","v":30},{"$f":"SUM(F2:F38)","v":16},null,"整体开发完结需3-5个工作日进行整体测试调整"]