{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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":"Sheet1","index":0,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,5,0,7],[39,0,39,2],[68,0,68,2],[23,0,23,2],[23,5,23,7]]}
["客户组表 dbo.tb_ErpCustomerGroup",{"$nulls":4},"联系人"]
["字段名","字段类型","字段说明",null,null,"字段名","字段类型","字段说明"]
["ID","int"]
["OrderNumber","nvarchar(50)","订单号 老客户时订单号为空"]
["CustomerGroupID","nvarchar(50)","客户组ID编号"]
["GroupType","int","客户组类型 0 为其它客户/订单客户 1 为老客户  2 为意向客户"]
["CustomerType","int","客户类型  0 为婚纱订单客户  1 为儿童订单客户 2 写真订单客户 3 为服务套系 4 为其它订单客户 "]
["CustomerStatus","nvarchar(50)","客户状态 正常(成交) 意向 溜单 流失"]
["LossReason","nvarchar(50)","客户流失或溜单原因"]
["DegreeOfIntent","nvarchar(50)","意向程度"]
["CustomerSource","nvarchar(50)","客户来源 自定义客户来源编号"]
["IntroducerCustomerID","varchar(100)","介绍人CustomerID  如果为老客户转介绍来的客户时填写介绍人ID"]
["Remark","nvarchar(4000)","备注说明"]
["CreatePersonID","varchar(50)","本组客户录入人ID"]
["BelongsPersonID","varchar(50)","本组客户所属人的ID  (隶属于谁的客户)"]
["ISIntentionCustomer","int","0为非意客户，1为录入意向客户，2为订单意向客户"]
["ReminderTime","datetime","提醒时间"]
["CreateDatetime","datetime","创建时间"]
["UpdateDatetime","datetime","修改时间"]
[]
[]
[]
[]
["客户组成员表 dbo.tb_ErpCustomerGroupMembers",{"$nulls":4},"联系人"]
["字段名","字段类型","字段说明",null,null,"字段名","字段类型","字段说明"]
["ID","int"]
["CustomerGroupID","varchar(50)","客户关系组ID编号"]
["CustomerID","varchar(50)","客户人员表中的客户编号ID"]
["Master","int","是否为主联系人 1 为主联系人 "]
["ProtagonistCustomer","int","是否为摄影主角 1 为摄影主角 表示在本次订单中要参与拍摄的客户"]
["RelatedPersonID","varchar(50)","相关人ID 儿童版订单客户时为宝贝ID   其其订单客户时为主联系人ID"]
["Relation","nvarchar(50)","与相关人的关系  如 本人、情吕、夫妻、父子、母子、父女、母女、兄弟、姐妹、亲人和朋友等"]
["IsOrder","int","是否已成功下单  1 为已成功下单  0 为下单未成功"]
["IsOrderNumber","varchar(100)","已订单号 如果 IsOrder 为 1 填入订单号"]
[]
[]
[]
[]
[]
["客户人员信息表"]
["字段名","字段类型","字段说明"]
["ID","int"]
["Cus_CustomerNumber","nvarchar","客户编号(第一位O、L、Y、R开头，加录入者编号，加1、2、3、4、5序号)"]
["Cus_Name","nvarchar","客户姓名"]
["Cus_Sex","int","客户性别 0:男,1:女"]
["Cus_IdentityCardID","nvarchar","身份证号"]
["Cus_Birthday","datetime","客户生日"]
["Cus_BirthdayLunar","bit","生日历类0:公历 1:农历"]
["Cus_QQ","nvarchar","客户QQ"]
["Cus_MicroSignal","nvarchar","微信号"]
["Cus_Telephone","nvarchar","客户电话"]
["Cus_FixedPhone","nvarchar","客户固定电话"]
["Cus_Region","nvarchar","客户所在地区"]
["Cus_Address","nvarchar","客户地址"]
["Cus_WorkUnit","nvarchar","客户工作单位"]
["Cus_BabyWeight","nvarchar","宝贝体重"]
["Cus_BornHospital","nvarchar","宝贝出生医院"]
["Cus_Zodiac","nvarchar","生肖 "]
["Cus_DayForMarriage","datetime","客户婚期"]
["Cus_DayForMarriageLunar","bit","婚期历类0:公历 1:农历"]
["Cus_CustomerSource","nvarchar","客户来源"]
["Cus_Remark","nvarchar","备注"]
["Cus_EntryClerk","nvarchar","资料录入员"]
["Cus_CreateDatetime","datetime","创建时间"]
["Cus_UpdateDatetime","datetime","修改时间"]
["Cus_CustomizeNumber","nvarchar","客户自定义编号"]
[]
[]
["客户跟踪记录表"]
["字段名","字段类型","字段说明"]
["ID","int"]
["CustomerGroupID","varchar(50)","跟踪的客户组ID编号"]
["CustomerID","varchar(50)","本次联系的客户人员表中的客户编号ID"]
["TraceWay","nvarchar(50)","本次跟踪方式  面谈、坐机电话、手机通话、邮件、短信、QQ、微信、网络留言、其它通信"]
["TraceType","nvarchar(50)","本次跟踪类型  流程按排、业务咨询、满意度调查、意向跟踪、溜单追回、关系维护、活动推广"]
["SpecificMatters","nvarchar(4000)","本次沟通具体事项  如：按排拍摄时间、按排选片时间和打结婚纪念日电话等"]
["TraceDetailedly","nvarchar(max)","本次沟通细节记录  如果客户返馈的信息 短信内容 QQ聊天记录等"]
["CallRecording","nvarchar(500)","如果是电话(一搬指通过来电精灵通话)沟通的通话录音文件路径"]
["Remark","nvarchar(4000)","少于4000字的备注说明 本次跟踪的特殊说明"]
["TraceDateTime","DateTime","本次跟踪时间（为与客户沟通的开始时间）"]
["TraceTimeLength","int","本次路踪时长(为与客户沟通所用时间 单位为分钟)  如：15  (分钟)"]
["TracePersonID","varchar(50)","本次跟踪人员ID(如门市)"]
["CreateDateTime","DateTime","记录录入时间"]
["UpdateDateTime","DateTime","记录修改时间"]

{"sheet":"Sheet2","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"客户名称","客户性别","客户年龄","地区","婚期","客户电话","主联系人","联系人性别","联系人电话","联系人微信号","联系人QQ","主联系人会员卡号"]
["婚纱客户","张三/小美","男/女","25(岁)/21(岁)",null,null,"13669511419/13669511417","张三","男",13669511419]
[null,"小丽","女",22,null,null,null,"小丽","女",13669511417]
[]
["儿童客户","小小明/","男/男","50(天)",null,null,null,"李四","男",13669855478]
["写真客户","王五","男",20,null,null,null,"王五","男",15847856695]
[]
[]
[null,"？/张三","男/男","1岁"]

{"sheet":"Sheet3","index":2,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,2],[18,0,18,2]]}
[]
["短信模板设置表"]
["字段名","字段类型","字段说明"]
["ID","int"]
["SendChannel","int","信息发送通道 0 为短信通道发送 1 为微信通道发送"]
["type","int","短信模板类型   0 样板短信  1 事件短信  "]
["Category","int","短信模板类别   0 儿童摄影客户   1 为其它摄影客户(如婚纱客户、写真客户、积分和财务短信等)"]
["SendEvent","int","短信发送事件   人工发送、客人订单后X分钟、订单件齐后X分钟发送取件通知、拍照预约后X分钟、拍照完成后X分钟、客人选片完成后X分钟、客人看样(看设计)后X分钟、客人取件后X分钟、当积分接近X*80%分时、当积分达到或超过X分时、转介绍积后X分钟发送短信给介绍人、发放会员卡后X分钟发会员短信、积分兑换后X分钟发提醒短信、现金卡消费后X分钟后发提醒短信、现金卡充值后X分钟后发提醒短信、客人生日前X天、客人婚礼前X天、结婚纪念日前X天、宝宝生日前X天、宝宝X天成长跟踪短信、宝宝X岁成长跟踪短信、员工生日前X天、员工迟到X次、员工早退X次、员工旷工X天、 每天X点X分发送财务短信到X手机、 每月X日X时发送短信给X对象、每年月X日X时发送短信到X对象、定时X年X月X时发送短信到X对象"]
["SendEventValue","nvarchar(50)","事件值 如：X分钟的分钟数 或积分 X的积分分值  X天  X岁 X日期/时间 "]
["ReceiveObjects","varchar(8000)","短信接收对象  AllC 所有客户 AllE所有员工  或 X手机号(最多500个手机号)"]
["Title","nvarchar(200)","短信模板标题"]
["SMSContent","nvarchar(500)","短信模板内容 (建义不要超过270个字符长度)"]
["IsEnabled","int","是否启用模板 0 为禁用  1 为启用 "]
["CreateDatetime","datetime","创建时间"]
["UpdateDatetime","datetime","修改时间"]
[]
[]
[]
["短信发送记录表"]
["字段名","字段类型","字段说明"]
["ID","int"]
["SendChannel","int","信息发送通道 0 为短信通道发送 1 为微信通道发送"]
["SMSType","int","短信类型 0 为人工短信  1 流程短信  2 事件短信  "]
["SendEvent","int","短信事件"]
["SMSGenerateIdentity","nvarchar(50)","短信生成标识 （生成短信记录时的唯一标识） 避免短信成复生成"]
["SMSSendIdentity","nvarchar(50)","短信发送后获取服务器返回的发送短信唯一标识(用于查询短信发送情况) 短信记录在服务器上只保存1个月"]
["RecipientNumber","nvarchar(4000)","接收人手机号码，多个时用“,”号分隔"]
["Content","nvarchar(500)","短信内容"]
["StartSendDatetime","datetime","短信预设开始发送时间"]
["SendSumCount","int","短信发送条数"]
["Status","int","发送状态  -1 为发送失败 0 为等待发送 1 为发送成功 2 为发送中 3 为超时短信"]
["SendLogs","nvarchar(max)","发送日志"]
["SendReport","nvarchar(800)","发送报告"]
["CreateDatetime","datetime","短信生成时间"]
["SendDatetime","datetime","短信发送时间 短信实际发送时间"]