全程云>开发者平台> JSON-格式对象

JSON-格式对象

个人通讯录List(Contact)对象
[{ "id": "整型编号", "user_id": "用户编号", "group_id": "分组id(1:默认分组,106:客户,107:供应商)", "position_id": "职位编号", "login_name": "登录帐号", "name": "中文名", "name_en": "英文名", "sex": "性别(0:女,1:男)", "office_tel": "办公电话", "mobile": "手机", "fax": "传真", "mail": "邮件", "home_address": "家庭住址", "home_tel": "家里电话", "post_code": "邮编", "signature": "签名", "head_img": "头像,例如:../Settings/headImg/girl.gif", "remark": "备注", "position_list": [{ "id": "职位编号", "name": "职位名称" }] }]

邮件List(InternalMail)对象
[{ "id": "整型编号", "mailId": "邮件编号", "title": "主题", "sender_id": "发送人编号", "sender_name": "发送姓名", "send_date": "发送时间,精确到豪秒。如:2012-12-19 16:11:05.323", "status": "状态,1:未读,2:已读", "content": "邮件内容", "FK_CustId": "客户编号", "sCustName": "客户名称", "attach_list": "附件(参考上传文件List(Attach)对象)", "rowNum": "行号" }]

邮件InternalMail对象
{ "id": "整型编号", "mailId": "邮件编号", "title": "主题", "sender_id": "发送人编号", "sender_name": "发送姓名", "send_date": "发送时间,精确到豪秒。如:2012-12-19 16:11:05.323", "status": "状态,1:未读,2:已读", "content": "邮件内容", "FK_CustId": "客户编号", "sCustName": "客户名称", "attach_list": "附件(参考上传文件List(Attach)对象)", "rowNum": "行号" }

邮件回复List(InternalEmailReply)对象
[{ "id": "整型编号", "mail_id": "邮件编号", "reply_person_id": "回复人编号", "reply_person_name": "回复人姓名", "reply_date": "回复时间:0001-01-01 00:00:00", "content": "回复内容" }]

邮件InternalMail_Email对象
{ "id": "整型编号", "title": "主题", "sender_id": "接收人id", "sender_name": "接收人名字", "sRecipientCCID": "密送人id", "sRecipientCC": "密送人名字", "sRecipientBCCID": "抄送人id", "sRecipientBCC": "抄送人名字", "send_date": "发送时间:0001-01-01 00:00:00", "status": "状态,1:未读,2:已读", "content": "邮件内容", "attach_list":"附件(参考上传文件List(Attach)对象)", "mailId": "邮件编号", "Inboxs": "收件箱数据", "FK_CustId": "客户编号", "sCustName": "客户名称", "rowNum": "行号" }

邮件List(InternalMail_Email)对象
[{ "id": "整型编号", "title": "主题", "sender_id": "接收人id", "sender_name": "接收人名字", "sRecipientCCID": "密送人id", "sRecipientCC": "密送人名字", "sRecipientBCCID": "抄送人id", "sRecipientBCC": "抄送人名字", "send_date": "发送时间:0001-01-01 00:00:00", "status": "状态,1:未读,2:已读", "content": "邮件内容", "attach_list":"附件(参考上传文件List(Attach)对象)", "mailId": "邮件编号", "Inboxs": "收件箱数据", "FK_CustId": "客户编号", "sCustName": "客户名称", "rowNum": "行号" }]

消息List(Dialog)对象
[{ "id": "消息整型编号", "sender_id": "发送人ID", "sender_name": "发送人姓名", "send_date": "发送时间:0001-01-01 00:00:00", "recv_id": "接收人ID", "recv_name": "接收人姓名", "recv_date": "接收时间:0001-01-01 00:00:00", "guest": "", "content": "消息内容", "attach_list": "附件(参考上传文件List(Attach)对象)" }]

在线用户Online对象
{ "id": "用户ID", "name": "用户姓名", "sex": "用户性别(0:女,1:男)", "online": "0:所有,1:在线", "status_id": "状态 Unknown = 0,Online= 1,Welcome = 2,Away= 3,Busy= 4,Mute= 5,Invisible = 6,Offline = 7" }

系统消息List(SystemMessage)对象
[{ "id": "系统消息编号", "send_date": "发送时间:格式0001-01-01 00:00:00", "recv_id": "接收人ID", "recv_name": "接收人姓名", "recv_date": "接收时间:格式0001-01-01 00:00:00", "content": "消息内容" }]

消息数量List(MessageCount)对象
[{ "user_id": "用户ID", "count": "消息数量", "guest": "" }]

在线用户List(Online)对象
[{ "id": "用户ID", "name": "用户姓名", "sex": "用户性别(0:女,1:男)", "online": "0:所有,1:在线", "status_id": "状态 Unknown = 0,Online= 1,Welcome = 2,Away= 3,Busy= 4,Mute= 5,Invisible = 6,Offline = 7" }]

聊天List(Chator)对象
[{ "id": "用户ID", "name": "用户姓名", "sex": "用户性别(0:女,1:男)", "online": "0:所有,1:在线", "status_id": "状态 Unknown = 0,Online= 1,Welcome = 2,Away= 3,Busy= 4,Mute= 5,Invisible = 6,Offline = 7" }]

便签List(OA_Note_T_Note)对象
[{ "PK_ID": "整型编号", "FK_UserID": "用户ID", "Content": "便签内容", "CDate": "创建时间:格式0001-01-01 00:00:00", "LastModifyDate": "最后修改时间:0001-01-01 00:00:00" }]

待办事务List(PendingFlow)对象
[{ "doc_id": "流程文档ID", "name": "流程名称", "title": "标题", "send_date": "发起流程时间,格式0001-01-01 00:00:00", "step_id": "步骤ID", "step_name": "步骤名称", "user_name": 流程申请人, "url": "表单url,例如:/OM/Assets/AssetsLiquidateForm.aspx?id=6&actiontype=3", "mod_code": "流程表单的编码", "mod_type_id": "是否自定义,0:自定义;1:非自定义", "flow_id": "流程ID", "emp_id": "流程申请人ID", "status_id": "流程文档状态 0,未处理状态;1、处理中状态;2、处理完成状态;4、撤销", "doc_value": "", "bReaded": "是否已读,1:未读;1:已读" }]

用户信息Contact对象
{ "id": "整型编号", "user_id": "用户编号", "group_id": "分组id(1:默认分组,106:客户,107:供应商)", "position_id": "职位编号", "login_name": "登录帐号", "name": "中文名", "name_en": "英文名", "sex": "性别(0:女,1:男)", "office_tel": "办公电话", "mobile": "手机", "fax": "传真", "mail": "邮件", "home_address": "家庭住址", "home_tel": "家里电话", "post_code": "邮编", "signature": "签名", "head_img": "头像,例如:../Settings/headImg/girl.gif", "remark": "备注", "position_list": [{ "id": "职位编号", "name": "职位名称" }] }

公告List(Placard)对象
[{ "id": "公告整型编号", "sender_id": "发送人ID", "sender_name": "发送人姓名", "title": "主题", "content": "公告内容", "readed": "状态,true:已读;false:未读", "send_date": "0001-01-01 00:00:00", "pic": "图片,例如:../Upfiles/Placard/22d48c6e-60a4-429f-9c45-20ad86a8b3c1.jpg", "attachList": "附件(参考上传文件List(Attach)对象)", "isPutTop": "是否置顶,0:不置顶;1:置顶", "topDays": "置顶天数" }]

公告Placard对象
{ "id": "公告整型编号", "sender_id": "发送人ID", "sender_name": "发送人姓名", "title": "主题", "content": "公告内容", "readed": "状态,true:已读;false:未读", "send_date": "0001-01-01 00:00:00", "pic": "图片,例如:../Upfiles/Placard/22d48c6e-60a4-429f-9c45-20ad86a8b3c1.jpg", "attachList": "附件(参考上传文件List(Attach)对象)", "isPutTop": "是否置顶,0:不置顶;1:置顶", "topDays": "置顶天数" }

日程事务Schedule对象
{ "id": "日程事物整型编号", "title": "主题", "content": "内容", "start_date": "开始时间,精确到分。如:2013-05-05 10:25", "stop_date": "结束时间,精确到分。如:2013-05-05 10:25", "creator_id": "创建人ID", "creator_name": "创建人", "sReceiverName": "执行人,多个以逗号相隔" }

日程事务类型List(ScheduleType)对象
[{ "id": "日程事务类型整型编号", "name": "类型名称,例如:工作安排,客户资源分派、事物提醒..." }]

日程事务List(Schedule)对象
[{ "id": "日程事物整型编号", "title": "主题", "content": "内容", "start_date": "开始时间,精确到分。如:2013-05-05 10:25", "stop_date": "结束时间,精确到分。如:2013-05-05 10:25", "creator_id": "创建人ID", "creator_name": "创建人", "sReceiverName": "执行人,多个以逗号相隔" }]

处理意见List(Attitude)对象
[{ "id": "整型编号", "name": "处理意见内容,例如:同意,已阅、不同意...", "user_id": "创建人ID", "sort": "用于排序" }]

流程实例Doc对象
{ "id": "流程文档ID", "emp_id": "流程申请人ID", "flow_id": "流程ID", "status": "流程文档状态 0:未处理状态;1:处理中状态;2:处理完成状态;4:撤销", "attach_flag": "附件标志,无附件:false;有附件:true", "mod_code": "流程表单的编码", "title": "标题", "sub_title": "副标题", "content": "备注内容", "send_date": "流程发起时间,格式:0001-01-01 00:00:00", "check_date": "审批时间,格式:0001-01-01 00:00:00", "value": "表单值", "url": "表单url,例如:/BB/Common/WF/flow/fladdedit.aspx?docvalue=1157" }

流程步骤DocStep对象
{ "doc_step_id": "步骤整型id", "doc_id": "流程文档ID", "step_name": "步骤名称", "action_type_id": "节点类型,0:开始;1:结束;2:审批;3:条件判断/不通过;4:知会;5:存档;6:多选节点", "note": "批注", "is_edit": "可进行数据编辑,true:可以编辑;false:不可以编辑", "is_any": "0: 同意或否定,即流入下一步 1:票数决定,同意优先 2:票数决定,否定优先 3:一票否决,即流入下一步", "is_read": "可查看他人意见,true:可以;false:不可以", "is_all": false, "is_mobile": "手机提醒,true:提醒;false:不提醒", "is_ukey": "该步骤需要UKey,true:需要;false:不需要", "is_email": "是否发送邮件,true:发送;false:不发送", "assign": "处理人分派方式,例如:执行时选择,流程申请人,固定处理人", "assign_id": "处理人分派ID", "pre_sql": "执行后sql", "post_sql": "执行前sql", "flow_id": "流程ID", "flow_step_id": "流程步骤ID" }

流程步骤List(DocStep)对象
[{ "doc_step_id": "步骤整型id", "doc_id": "流程文档ID", "step_name": "步骤名称", "action_type_id": "节点类型,0:开始;1:结束;2:审批;3:条件判断/不通过;4:知会;5:存档;6:多选节点", "note": "批注", "is_edit": "可进行数据编辑,true:可以编辑;false:不可以编辑", "is_any": "0: 同意或否定,即流入下一步 1:票数决定,同意优先 2:票数决定,否定优先 3:一票否决,即流入下一步", "is_read": "可查看他人意见,true:可以;false:不可以", "is_all": false, "is_mobile": "手机提醒,true:提醒;false:不提醒", "is_ukey": "该步骤需要UKey,true:需要;false:不需要", "is_email": "是否发送邮件,true:发送;false:不发送", "assign": "处理人分派方式,例如:执行时选择,流程申请人,固定处理人", "assign_id": "处理人分派ID", "pre_sql": "执行后sql", "post_sql": "执行前sql", "flow_id": "流程ID", "flow_step_id": "流程步骤ID" }]

邮件MailInfo对象
{ "PK_ID": "整型编号(自增主键)", "iFromID": "发送人ID", "sRecipientID": "接收人id", "sRecipientCCID": "密送人id", "sRecipientBCCID": "抄送人id", "sSubject": "主题", "sRecipient": "接收人名字", "sRecipientCC": "密送人名字", "sRecipientBCC": "抄送人名字", "sContent": "邮件内容", "iFolder": "某某箱标识 1:收件箱 2:发件箱 3:草稿箱", "iStatus": "状态,1:未读,2:已读", "iHtml": "0:HTML 1:Text", "FK_PriorityID": "重要程度(1:一般,2:重要,3:紧急,16:非常重要)", "FK_AttValue": "附件标志(0:无,1:有)", "dCreateDate": "发送时间:2016-02-26 11:02:17", "iSize": "文件大小", "iMsgClew": "即时消息提示(1:是,0:否)", "iDataMgCite": "标识邮件已移动到个人文件夹( 0:否 1:是", "FK_CustId": "客户编号", "IsSendSMS": "是否发送短信(true:是;false:否)" }

自定义表单数据(键值对)
{ "Key(键)": "Value(值)" ... }

地区List(Area)对象
[{ "id": "地区整型编号", "name": "地区名称", "parent_id": "父级ID(0:国家,1:省、自治区、直辖市,省、自治区、直辖市等id)" , "code": "层级关系,例如中国:001,北京:001001", "sort": "排序字段", "is_default": "下拉框是否默认显示 true:默认;false:不默认" }]

地区Area对象
{ "id": "地区整型编号", "name": "地区名称", "parent_id": "父级ID(0:国家,1:省、自治区、直辖市,省、自治区、直辖市等id)" , "code": "层级关系,例如中国:001,北京:001001", "sort": "排序字段", "is_default": "下拉框是否默认显示 true:默认;false:不默认" }

地区List(Sys_T_Area)对象
[{ "PK_ID": "地区整型编号", "sName": "地区名称", "FK_ParID": "父级ID(0:国家,1:省、自治区、直辖市,省、自治区、直辖市等id)", "sCode": "层级关系,例如中国:001,北京:001001", "iSort": "排序字段", "pDefault": "下拉框是否默认显示 true:默认;false:不默认", "sName_EN": "地区名称" }]

上传文件List(Attach)对象
[{ "id": "文件整型编号", "guid": "guid:Guid.NewGuid().ToString()", "user_id": "上传人员编号", "source_name": "原文件名称", "target_name": "实际存放路径及文件名,例如:/Upfiles/1c490b2614de4cbea800bd0c52904356.docx", "content_type": "文件类型,例如:doc", "size": "文件大小,例如:557.50KB", "create_date": "创建时间,例如:0001-01-01 00:00:00", "path": "实际存放路径及文件名,例如:/Upfiles/1c490b2614de4cbea800bd0c52904356.docx" }]

上传文件Attach对象
{ "id": "文件整型编号", "guid": "guid:Guid.NewGuid().ToString()", "user_id": "上传人员编号", "source_name": "原文件名称", "target_name": "实际存放路径及文件名,例如:/Upfiles/1c490b2614de4cbea800bd0c52904356.docx", "content_type": "文件类型,例如:doc", "size": "文件大小,例如:557.50KB", "create_date": "创建时间,例如:0001-01-01 00:00:00", "path": "实际存放路径及文件名,例如:/Upfiles/1c490b2614de4cbea800bd0c52904356.docx" }

客户端版本VersionInfo对象
{ "VersionNumber": "版本号(年份+月份,例如:201601)", "Description": "描述", "PackageUrl": "包url,例如:http://24om.com/update.aspx", "PackageName": "包名称:om.zip", "PackageSize": "包大小,例如:113344,单位kb", "IsSilent": false, "UpdateAt": "更新时间,精确到秒。如:2013-05-05 10:25:30" }

错误日志List(ErrorLog)对象
[{ "id": "整型编号", "title": "标题", "content": "错误信息", "url": "错误链接,例如:/OM/ibp/ProductInfo.aspx", "form": "错误的表单数据", "creator": "创建人ID", "datetime": "创建时间" }]

系统事件日志List(Sys_T_Event_Log)对象
[{ "PK_ID": "日志整型编号", "EventCode": "日志代码,例如:OM.HR.Organization.BatchUpdate.AfterUpdate", "EventData": "日志数据json格式,例如:{ "method": "gsp.api.ldapEmployeeLock", "username": "2015.07", "isLocked": "1" }", "EventResult": "日志结果json格式,例如:{"code": 403,"msg": null}", "Sys_Date": "时间:0001-01-01 00:00:00" }]

字典表List(BaseType)对象
[{ "id": "整型编号", "code": "分类标识代码,例如:ClientSign", "name": "名称", "value": "代码" }]

联系历史记录List(ContactHistory)对象
[{ "id": "整型编号"0, "customer_id": "客户ID", "customer_name": "客户名称", "route_id": "联系方式ID", "route_name": "联系方式(1:电话2:信函3:邮件4:上门)", "type_id": "联系类别ID", "type_name": "联系类别(1:销售联系2:客户关怀3:售后回访4:投诉回访5:服务支持6:维修维护7:实施培训)", "link_man_id": "客户联系人ID", "link_man_name": "客户联系人", "my_link_man_id": "公司联系人ID", "my_link_man_name": "公司联系人", "title": "主题", "content": "联系纪要", "time": "联系时间:0001-01-01 00:00:00", "next_link_man_id": "下次联系人ID", "next_link_man_name": "下次联系人", "link_man_result": "联系结果" }]

联系历史记录ContactHistory对象
{ "id": "整型编号"0, "customer_id": "客户ID", "customer_name": "客户名称", "route_id": "联系方式ID", "route_name": "联系方式(1:电话2:信函3:邮件4:上门)", "type_id": "联系类别ID", "type_name": "联系类别(1:销售联系2:客户关怀3:售后回访4:投诉回访5:服务支持6:维修维护7:实施培训)", "link_man_id": "客户联系人ID", "link_man_name": "客户联系人", "my_link_man_id": "公司联系人ID", "my_link_man_name": "公司联系人", "title": "主题", "content": "联系纪要", "time": "联系时间:0001-01-01 00:00:00", "next_link_man_id": "下次联系人ID", "next_link_man_name": "下次联系人", "link_man_result": "联系结果" }

客户联系计划List(CustomerContactPlan)对象
[{ "id": "整型编号", "customer_id": "客户ID", "customer_name": "客户名称", "link_man_id": "客户联系人ID", "link_man_name": "客户联系人", "type_id": "联系类别ID", "type_name": "联系类别(1:销售联系2:客户关怀3:售后回访4:投诉回访5:服务支持6:维修维护7:实施培训)", "route_id": "联系方式ID", "route_name": "联系方式(1:电话2:信函3:邮件4:上门)", "title": "主题", "content": "联系纪要", "time": "联系时间:0001-01-01 00:00:00", "LinkManInfo": "客户联系人(参考客户联系人CustomerLinkMan对象)", "history_id": "联系记录ID" }]

客户联系计划CustomerContactPlan对象
{ "id": "整型编号", "customer_id": "客户ID", "customer_name": "客户名称", "link_man_id": "客户联系人ID", "link_man_name": "客户联系人", "type_id": "联系类别ID", "type_name": "联系类别(1:销售联系2:客户关怀3:售后回访4:投诉回访5:服务支持6:维修维护7:实施培训)", "route_id": "联系方式ID", "route_name": "联系方式(1:电话2:信函3:邮件4:上门)", "title": "主题", "content": "联系纪要", "time": "联系时间:0001-01-01 00:00:00", "LinkManInfo": "客户联系人(参考客户联系人CustomerLinkMan对象)", "history_id": "联系记录ID" }

客户List(Customer)对象
[{ "id": "整型编号", "sign_id": "客户标识ID,1:企业客户,2:个人客户", "sign_name": "客户标识名称,1:企业,2:个人", "name": "客户名称", "is_public": "所属客户:false:私有,true:公共", "parent_type_id": "一级客户类型ID,Scode字段来判断客户类型是有几级", "type_id": "二级客户类型ID,Scode字段来判断客户类型是有几级", "type_name": "客户类型,一级客户类型返回一级客户类型;二级客户类型返回一级加二级类型,例如:潜在客户-重点意向", "area_province_id": "省级,地区的Scode字段来判断当前地区是有几级,前6个长度为省级,前9字符个为市级,前12字符为区级", "area_city_id": "市级,地区的Scode字段来判断当前地区是有几级,前6个长度为省级,前9字符个为市级,前12字符为区级", "area_area_id": "区级,地区的Scode字段来判断当前地区是有几级,前6个长度为省级,前9字符个为市级,前12字符为区级", "area_id": "地区ID", "area_name": "地区名称,地区有几级就几级连接,例如:中国-广东省-广州市-天河区", "addr": "地址", "zip_code": "邮政编码", "tel": "总机电话", "fax": "传真号码", "website": "网址", "last_contact_time": "最后联系时间,格式:0001-01-01 00:00:00", "link_mans": "客户联系人(参考客户联系人List(CustomerLinkMan)对象)" }]

客户Customer对象
{ "id": "整型编号", "sign_id": "客户标识ID,1:企业客户,2:个人客户", "sign_name": "客户标识名称,1:企业,2:个人", "name": "客户名称", "is_public": "所属客户:false:私有,true:公共", "parent_type_id": "一级客户类型ID,Scode字段来判断客户类型是有几级", "type_id": "二级客户类型ID,Scode字段来判断客户类型是有几级", "type_name": "客户类型,一级客户类型返回一级客户类型;二级客户类型返回一级加二级类型,例如:潜在客户-重点意向", "area_province_id": "省级,地区的Scode字段来判断当前地区是有几级,前6个长度为省级,前9字符个为市级,前12字符为区级", "area_city_id": "市级,地区的Scode字段来判断当前地区是有几级,前6个长度为省级,前9字符个为市级,前12字符为区级", "area_area_id": "区级,地区的Scode字段来判断当前地区是有几级,前6个长度为省级,前9字符个为市级,前12字符为区级", "area_id": "地区ID", "area_name": "地区名称,地区有几级就几级连接,例如:中国-广东省-广州市-天河区", "addr": "地址", "zip_code": "邮政编码", "tel": "总机电话", "fax": "传真号码", "website": "网址", "last_contact_time": "最后联系时间,格式:0001-01-01 00:00:00", "link_mans": "客户联系人(参考客户联系人List(CustomerLinkMan)对象)" }

客户类型List(CRM_Cust_T_CustKind)对象
[{ "PK_ID": "整型编号", "sName": "类型名称", "FK_ParID": "上级ID,例如:0表示一级,一级id)", "sCode": "层级", "iSort": "排序", "bDefault": "是否默认,true:是;false:否", "bSystem": "是否系统项,true:是;false:否" }]

客户类型List(CustomerType)对象
[{ "id": "整型编号", "name": "类型名称", "parent_id": "上级ID,例如:0表示一级,一级id)", "code": "层级", "sort": "排序", "is_default": "是否默认,true:是;false:否" }]

联系人List(LinkMan)对象
[{ "PK_ID": "整型编号", "FK_CustID": "客户编号", "sCode": "", "sName": "姓名", "iSex": "性别(0女,1男)", "sHeadship": "职位", "sOfficeTel": "办公电话", "sOfficeFax": "传真号码", "sHomeTel": "家庭电话", "sHomeFax": "家庭传真", "sMobile": "手机", "sAddress": "地址", "sZip": "邮政编码", "sEmail": "电子邮件", "sOtherContact": "MSN(QQ)", "iClientRecognizeID": "认可程度ID", "iClientImportanceID": "重要程度ID", "iClientRoleID": "角色ID", "iClientRelationID": "关系ID", "iClientPowerID": "权限权力ID", "iClientAbilityID": "综合能力ID", "iClientAgeID": "年龄ID", "sClientBenefit": "利益诉求ID", "sClientCare": "关心重点ID", "sDemandItem": "负责的需求ID", "dBirthday": "出生日期,格式:1921-01-07", "iNationID": "民族ID", "iNativePlaceID": 0, "sHomeplace": "出生地", "sIDCard": "身份证号", "iAnimalSignID": "属相ID", "iConstellationID": "星座ID", "iWedlockID": "婚姻状况ID", "sChildren": "已婚有子", "iEduID": "学历ID", "iProfessionID": "专业ID", "iHealthID": "健康状况ID", "iBelieveInID": "信仰ID", "iBodyID": "体型ID", "iSmokeID": "吸烟ID,1:吸烟;2:不吸烟", "iAlcoholID": "喝酒ID,", "sLanguageID": "语音ID", "sLanguageOther": "其他语音", "iSurfaceStature": "身高", "fSurfaceAvoirdupois": "体重", "sSurfaceEye": "视力", "sSurfaceOther": "其他", "sHistory": "个人经历", "sMemo": "备注", "sManager": "联系对象", "iCreatorID": "创建人Id", "dCreateTime": "创建时间,例如:2016-02-17 18:43:26", "bMain": "是否主要联系人,true:是;false:否", "bDimission": "状态(false:在职,true:离职)", "dDimissionTime": "离职日期", "dLastContactTime": "最后联系时间", "LinkmanColumn1": "自定义字段1", "LinkmanColumn2": "自定义字段2", "LinkmanColumn3": "自定义字段3", "LinkmanColumn4": "自定义字段4, "LinkmanColumn5": "自定义字段5, "LinkmanColumn6": "自定义字段6, "LinkmanColumn7": "自定义字段7", "LinkmanColumn8": "自定义字段8", "LinkmanColumn9": "自定义字段9", "LinkmanColumn10": "自定义字段10", ... "LinkmanColumn50": "自定义字段50" }]

客户联系人List(CustomerLinkMan)对象
[{ "id": "整型编号", "customer_id": "客户Id", "name": "客户名称", "sex": "性别,0:女;1:男", "mobile": "手机号码", "tel": "办公电话", "email": "电子邮件", "sZip": "邮政编码", "sAddress": "地址", "sOfficeFax": "传真号码" }]

客户联系人CustomerLinkMan对象
{ "id": "整型编号", "customer_id": "客户Id", "name": "客户名称", "sex": "性别,0:女;1:男", "mobile": "手机号码", "tel": "办公电话", "email": "电子邮件", "sZip": "邮政编码", "sAddress": "地址", "sOfficeFax": "传真号码" }

销售退货单List(EjectInfo)对象
[{ "PK_ID": "整型编号(自增主键)", "sEjectNo": "退货单号", "dEjectDate": "退货日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:14", "FK_CustID": "客户id", "FK_StoreID": "仓库id", "sStroeName": "仓库名称", "iIsCheck": "是否已审核(0:未审核;1:已审核;2:已入库)", "FK_CheckID": "审核人id", "CheckName": "审核人", "dCheckDate": "审核日期:0001-01-01 00:00:00", "FK_OperatorID": "操作员id", "sMemo": "备注", "FK_CustName": "客户名称", "FK_OperatorName": "操作员", "sMemberNumber": "会员卡号", "sLinkMan": "联系人", "sRelationPhone": "联系电话", "sMail": "邮箱", "FK_GradeId": "会员类型ID", "sGradeName": "会员类型", "fTotalMoney": "合计", "iPayWay": "支付方式", "iBusiness": "业务人员id", "BusinessName": "业务人员", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-02-18 15:09:14", "FK_BillCategory": "票据类别", "TaxRate": "税率 格式:0.0", "Detail": "单据明细(参考销售退货单明细List(EjectInfoDtView)对象)", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }]

销售退货单明细List(EjectInfoDtView)对象
[{ "SNMgr": "管理模式0:无需SN管理 1:需SN管理 2:入库无需出库需SN管理", "PK_ID": "整型编号(自增主键)", "FK_EjectID": "退货单号(整型)", "FK_ProductID": "产品id", "fPrice": "价格:1.000000", "fNum": "数量:1.000000", "fAmount": "金额:1.000000", "sSerialNo": "SN", "FK_StoreID": "仓库id", "BatchNumber": "批次编号", "FK_Unit": "单位ID", "Unit": "单位(参考产品单位List(ProductUnit)对象)" }]

销售退货单EjectInfo对象
{ "PK_ID": "整型编号(自增主键)", "sEjectNo": "退货单号", "dEjectDate": "退货日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:14", "FK_CustID": "客户id", "FK_StoreID": "仓库id", "sStroeName": "仓库名称", "iIsCheck": "是否已审核(0:未审核;1:已审核;2:已入库)", "FK_CheckID": "审核人id", "CheckName": "审核人", "dCheckDate": "审核日期:0001-01-01 00:00:00", "FK_OperatorID": "操作员id", "sMemo": "备注", "FK_CustName": "客户名称", "FK_OperatorName": "操作员", "sMemberNumber": "会员卡号", "sLinkMan": "联系人", "sRelationPhone": "联系电话", "sMail": "邮箱", "FK_GradeId": "会员类型ID", "sGradeName": "会员类型", "fTotalMoney": "合计", "iPayWay": "支付方式", "iBusiness": "业务人员id", "BusinessName": "业务人员", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-02-18 15:09:14", "FK_BillCategory": "票据类别", "TaxRate": "税率 格式:0.0", "Detail": "单据明细(参考销售退货单明细List(EjectInfoDtView)对象)", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }

销售单List(OrderInfo)对象
[{ "PK_ID": "整型编号(自增主键)", "Detail": "单据明细(参考销售单明细List(OrderInfoDtView)对象)", "sCustName": "客户名称", "sMemberNumber": "客户卡号", "sLinkMan": "联系人", "sLinkManId": "联系人ID", "sRelationPhone": "联系电话", "sMail": "邮箱", "sOrderNo": "销售单号,例如:SD201509070001", "dOrderDate": "订单日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "FK_CustID": "客户id", "iIsCheck": "是否已审核(0:未审核;1:已审核;2:已入库)", "FK_CheckID": "审核人id", "CheckName": "审核人", "dCheckDate": "审核日期:0001-01-01 00:00:00", "FK_OperatorID": "操作员id", "sMemo": "备注", "dDeliveryDate": "送货日期", "sAddress": "地址", "FK_StoreID": "仓库id", "FK_GradeId": "会员类型ID(1:普通会员2:VIP会员3:高级VIP会员)", "sGradeName": "会员类型", "fDiscount": "折扣,格式:100.00", "fTotalMoney": "金额", "fDiscountTotalMoney": "折后金额", "fReceMoney": "退款金额", "IPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "dOutOrderDate": "出单日期:0001-01-01 00:00:00", "FK_ContractID": "合同id", "iBusiness": "业务人员id", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-02-18 15:09:14", "FK_BillCategory": "票据类别", "TaxRate": "税率 格式:0.0", "PrintCounter": "打印次数", "PurchaseAmount": "采购额=(产品各自的上次采购价*产品数量)累加所有产品", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }]

销售单OrderInfo对象
{ "PK_ID": "整型编号(自增主键)", "Detail": "单据明细(参考销售单明细List(OrderInfoDtView)对象)", "sCustName": "客户名称", "sMemberNumber": "客户卡号", "sLinkMan": "联系人", "sLinkManId": "联系人ID", "sRelationPhone": "联系电话", "sMail": "邮箱", "sOrderNo": "销售单号,例如:SD201509070001", "dOrderDate": "订单日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "FK_CustID": "客户id", "iIsCheck": "是否已审核(0:未审核;1:已审核;2:已入库)", "FK_CheckID": "审核人id", "CheckName": "审核人", "dCheckDate": "审核日期:0001-01-01 00:00:00", "FK_OperatorID": "操作员id", "sMemo": "备注", "dDeliveryDate": "送货日期", "sAddress": "地址", "FK_StoreID": "仓库id", "FK_GradeId": "会员类型ID(1:普通会员2:VIP会员3:高级VIP会员)", "sGradeName": "会员类型", "fDiscount": "折扣,格式:100.00", "fTotalMoney": "金额", "fDiscountTotalMoney": "折后金额", "fReceMoney": "退款金额", "IPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "dOutOrderDate": "出单日期:0001-01-01 00:00:00", "FK_ContractID": "合同id", "iBusiness": "业务人员id", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-02-18 15:09:14", "FK_BillCategory": "票据类别", "TaxRate": "税率 格式:0.0", "PrintCounter": "打印次数", "PurchaseAmount": "采购额=(产品各自的上次采购价*产品数量)累加所有产品", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }

销售单明细List(OrderInfoDtView)对象
[{ "sName": "产品名称", "sCode": "产品编码", "sStyle": "规格型号", "sUnit": "单位", "dProduceDate": "生产日期", "Unit": "单位(参考产品单位List(ProductUnit)对象)", "PK_ID": "整型编号(自增主键)", "FK_OrderID": "单号ID", "FK_ProductID": "产品编号", "fPrice": "价格:1.000000", "fNum": "数量:1.000000", "fDiscount": "折扣,格式:100.00", "cAmount": "金额:1.000000", "Remark": "备注", "FK_StoreID": "仓库编号", "fWaitNum": "待出库数量", "fWaitCheckNum": "待审核数量", "fOutNum": "已出数量", "fOrderNum": "采购数量", "FK_Unit": "单位ID", "FK_ObjectType": "选择类型", "FK_ObjectID": "选择类型ID" }]

出库单List(OutStore)对象
[{ "Detail": 单据明细(参考出库单明细List(OutStoreDetailView)对象), "PK_ID": "整型编号(自增主键)", "FK_StoreID": "仓库ID", "FK_CheckID": "审核人Id", "FK_OperatorID": "操作人ID", "FK_OutStoreType": "出库类型(1:销售单出库2:店铺直销出库单3:采购退货出库4:报废出库5:调拨出库...)", "FK_CustID": "客户ID", "sCustName": "客户名称", "iBusiness": "业务人员id", "sCustNameEx": "客户英文名", "sCustCard": "会员卡号", "sRecvMan": "收货人", "sLinkManId": "联系人ID", "sRecvAddr": "收货地址", "sLinkTel": "联系电话", "sPostNo": "邮编", "sGradeName": "会员类型", "FK_GradeID": "会员类型ID(1:普通会员2:VIP会员3:高级VIP会员)", "FK_OrderID": "关联单据Id", "sOutStoreNo": "单据号", "dOutStoreDate": "出库日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "dCheckedDate": "审核日期:0001-01-01 00:00:00", "sMemo": "备注", "iIsCheck": "是否审核(1已审核,0未审核)", "FK_RelationNo": "关联单据号", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-02-18 15:09:15", "fDiscount": "折扣", "fTotalMoney": "金额", "fDiscountTotalMoney": "折后金额", "iPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "iIsVoucher": "是否生成凭证(1生成)", "IsVoucher": "是否生成自动会计凭证true:是;false:否", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }]

出库单OutStore对象
[{ "Detail": 单据明细(参考出库单明细List(OutStoreDetailView)对象), "PK_ID": "整型编号(自增主键)", "FK_StoreID": "仓库ID", "FK_CheckID": "审核人Id", "FK_OperatorID": "操作人ID", "FK_OutStoreType": "出库类型(1:销售单出库2:店铺直销出库单3:采购退货出库4:报废出库5:调拨出库...)", "FK_CustID": "客户ID", "sCustName": "客户名称", "iBusiness": "业务人员id", "sCustNameEx": "客户英文名", "sCustCard": "会员卡号", "sRecvMan": "收货人", "sLinkManId": "联系人ID", "sRecvAddr": "收货地址", "sLinkTel": "联系电话", "sPostNo": "邮编", "sGradeName": "会员类型", "FK_GradeID": "会员类型ID(1:普通会员2:VIP会员3:高级VIP会员)", "FK_OrderID": "关联单据Id", "sOutStoreNo": "单据号", "dOutStoreDate": "出库日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "dCheckedDate": "审核日期:0001-01-01 00:00:00", "sMemo": "备注", "iIsCheck": "是否审核(1已审核,0未审核)", "FK_RelationNo": "关联单据号", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-02-18 15:09:15", "fDiscount": "折扣", "fTotalMoney": "金额", "fDiscountTotalMoney": "折后金额", "iPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "iIsVoucher": "是否生成凭证(1生成)", "IsVoucher": "是否生成自动会计凭证true:是;false:否", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }]

出库单明细List(OutStoreDetailView)对象
[{ "sName": "产品名称", "sCode": "产品编码", "sStyle": "规格型号", "sUnit": "单位", "fWaitNum": "待出库数量", "fWaitCheckNum": "待审核数量", "Unit": "单位(参考产品单位List(ProductUnit)对象)", "fOutNum": "已出数量", "fOrderNum": "采购数量", "fNum1": "数量", "SNMgr": "SN管理模式 (0:无需SN管理 1:需SN管理 2:入库无需出库需SN管理)", "isBatchManage": "批次号管理模式 (0:无需批次号管理 1:需批次号管理 )", "fStandardPurPrice": "标准采购价格", "fStandardSalePrice": "标准销售价格", "sPNO": "货号", "sTypeTree": "分类树形编码,例如:硬件产品->电脑类->CRM演示版4", "ProductPropertyName": "产品类型名称", "Stock": "库存数量", "ProductColumn1": "自定义字段1", "ProductColumn2": "自定义字段2", "ProductColumn3": "自定义字段3", ... "ProductColumn20": "自定义字段20", "PK_ID": "整型编号(自增主键)", "SN": "SN明细(参考出库单明细SN明细List(OutStoreDetailSN)对象)", "FK_OutStoreID": "出库单ID", "FK_ProductID": "产品ID", "fNum": "数量", "fPrice": "单价", "fAmount": "金额", "fDiscount": "折扣:100.0", "sMemo": "备注", "FK_StoreID": "仓库ID", "sSerialNo": "SN", "BatchNumber": "批次编号", "FK_Unit": "单位Id", "FK_Source": "来源单据明细对应ID" }]

出库单明细SN明细List(OutStoreDetailSN)对象
[{ "PK_ID": "整型编号(自增主键)", "FK_ProductID": "产品ID", "FK_OutStoreDtID": "出库单明细Id", "sSerialNo": "SN", "fNum": "数量", "dProduceDate": "生产日期:1900-01-01 00:00:00", "dServiceDate": "维护日期:1900-01-01 00:00:00", "FK_StoreID": "仓库ID", "FK_OutStoreID": "出库单Id", "FK_ClientID": "客户(博施)提出需求:能添加不关联单据的维修记录", "sLinkMan": "联系人", "sLinkTel": "联系电话", "noRelation": false, "BatchNumber": "批次编号" }]

产品List(Product)对象
[{ "PK_ID": "整型编号(自增主键)", "FK_TypeID": "产品类别ID", "sTypeTree": "分类树形编码,例如:硬件产品->电脑类->CRM演示版4", "CategoryName": "类别名称", "PartList": "组合构成(参考组合产品List(ProductPart)对象)", "sName": "产品名称", "sCode": "产品编码", "sStyle": "规格型号", "sUnit": "标准单位名称", "sPNO": "货号", "UnitName": "单位名称", "UnitList": "单位(参考产品单位List(ProductUnit)对象)", "sMemo": "备注", "fPurPrice": "标准采购价格", "fSalePrice": "标准销售价格", "iKeyMonitoring": "是否监控,true:是;false:否", "SNMgr": "SN管理模式 (0:无需SN管理 1:需SN管理 2:入库无需出库需SN管理)", "sType": "类型ID", "TypeName": "类型名称", "sService": "服务周期,1:按销售时间;2:按出库时间", "sServiceDateNum": "服务周期数", "sServiceDateType": "服务周期类型(1:日;2:周;3:月;4:年)", "sMaintanceType": "保养周期(1:按入库时间;2:按生产时间)", "iMainCycle": "保养周期数", "iMaintanceDateType": "服务周期类型(1:日;2:周;3:月;4:年)", "iTrashDateType": "报废周期类型(1:日;2:周;3:月;4:年)", "sTrashType": "报废周期(1:按入库时间;2:按生产时间)", "iTrashCycle": "报废周期数", "isBatchManage": "批次管理0:无需批次管理 1:需批次管理", "ProductColumn1": "自定义字段1", "ProductColumn2": "自定义字段2", "ProductColumn3": "自定义字段3", ... "ProductColumn50": "自定义字段50", "iCostingMethod": "成本计价方法,没有选择时会显示为null或0,选择后显示为1", "fCosting": "成本金额", "sTwoDimensionalCodeInfo": "二维码信息", "sProductWebsite": "二维码网站", "sInventoryAccount": "所属存货科目ID", "sInventoryAccountName": "所属存货科目名称,例如:Code-Name", "sCOSAccount": "销售成本科目ID", "sCOSAccountName": "销售成本科目名称,例如:Code-Name", "sSalesRevenueAccount": "销售收入科目ID,例如:5001", "sSalesRevenueAccountName": "销售收入科目,例如:Code-Name=5001-主营业务收入", "sVATAccount": "进项税科目", "sVATAccountName": "进项税科目名称,例如:Code-Name=2221.01.06-已交税金", "sOPTAccount": "销项税科目", "sOPTAccountName": "销项税科目名称,例如:Code-Name=2221.01.06-已交税金", "sPurPrice": "标准采购价格", "sSalePrice": "标准销售价格", "sSinceCode": "自编码", "sMnemonic": "助记词", "iSubtractTreasury": "核减库存方式(1:增减库存;0:不增减库存)", "sBarcode": "条码", "UpdateTime": "更新时间:2016-02-18 15:09:15" }]

组合产品List(ProductPart)对象
[{ "PK_ID": "整型编号(自增主键)", "FK_PartProductID": "组合明细产品ID", "FK_ProductID": "组合主产品ID", "Num": "组合明细产品数量", "Remark": "备注", "sName": "产品名称", "sCode": "产品编码", "sStyle": "规格型号", "UnitName": "单位名称", "FK_StandardUnitId": "单位ID", "fPurPrice": "标准采购价格", "fSalePrice": "标准销售价格", "sPurPrice": "标准采购价格小数位数格式化后的内容", "sSalePrice": "标准销售价格小数位数格式化后的内容", "Product":{Product对象} }]

产品单位List(ProductUnit)对象
[{ "PK_ID": "整型编号(自增主键)", "FK_ProductID": "产品ID", "sName": "单位名称", "iIsStandard": "是否标准单位(1:是;0:否)", "iChgValue": "换算关系,例如:1、10、20等比例换算", "sNode": "全称,例如格式:单位名称(* 换算关系)", "sSNColumnName": "sSerialNo字段名(SN)", "bSNMgr": "是否sn管理(true:是;false:否)", "fLong": "长(m)", "fWide": "宽(m)", "fHeight": "高(m)", "fWeight": "重量(kg)", "sRemark": "备注" }]

采购单List(ePurchase)对象
[{ "PK_ID": "整型编号(自增主键)", "sPurNo": "采购单号,例如:CD-201509020001", "dPurDate": "采购单日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "FK_StoreID": "仓库编号", "FK_SupplyID": "供应商编号", "sSupplyName": "供应商名称", "iIsCheck": "审核状态(0未审核;1、2待审核入库;3已入库)", "FK_CheckID": "审核人编号", "dCheckDate": "审核日期:0001-01-01 00:00:00", "sMemo": "备注", "FK_OperatorID": "操作人id", "dDeliveryDate": "送货日期:0001-01-01 00:00:00", "sAddress": "地址", "sLinkMan": "联系人", "sLinkPhone": "联系电话", "fPercent": "折扣", "fPercentMoney": "折后金额", "fTotalMoney": "采购单金额", "iPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "FK_ContractID": "合同编号", "iPurchase": "采购人员ID", "CreatorPerson": "操作员ID", "OperatorDate": "操作日期:2016-02-18 15:09:15", "FK_BillCategory": "票据类别", "TaxRate": "税率", "Detail": "明细(参考采购单明细List(ePurchaseDtView)对象)", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }]

采购单明细List(ePurchaseDtView)对象
[{ "sName": "产品名称", "sCode": "产品编码", "sStyle": "规格型号", "sUnit": "单位", "dProduceDate": "生产日期", "Unit": "单位(参考产品单位List(ProductUnit)对象)", "BatchNumber": "批次编号", "sSerialNo": "SN", "SNMgr": "SN管理模式 (0:无需SN管理 1:需SN管理 2:入库无需出库需SN管理)", "PK_ID": "整型编号(自增主键)", "FK_PurID": "采购单号", "FK_OrderID": "单号ID", "FK_ProductID": "产品编号", "fPrice": "价格:1.000000", "fNum": "数量:1.000000", "fWaitNum": "待入库数量", "fWaitCheckNum": "入库待审核数量", "cAmount": "金额", "sDtMemo": "备注", "fInNum": "已入数量", "fPurNum": "采购数量", "FK_Unit": "单位id", "FK_SupplyProductID": "供应商产品ID" }]

采购单ePurchase对象
{ "PK_ID": "整型编号(自增主键)", "sPurNo": "采购单号,例如:CD-201509020001", "dPurDate": "采购单日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "FK_StoreID": "仓库编号", "FK_SupplyID": "供应商编号", "sSupplyName": "供应商名称", "iIsCheck": "审核状态(0未审核;1、2待审核入库;3已入库)", "FK_CheckID": "审核人编号", "dCheckDate": "审核日期:0001-01-01 00:00:00", "sMemo": "备注", "FK_OperatorID": "操作人id", "dDeliveryDate": "送货日期:0001-01-01 00:00:00", "sAddress": "地址", "sLinkMan": "联系人", "sLinkPhone": "联系电话", "fPercent": "折扣", "fPercentMoney": "折后金额", "fTotalMoney": "采购单金额", "iPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "FK_ContractID": "合同编号", "iPurchase": "采购人员ID", "CreatorPerson": "操作员ID", "OperatorDate": "操作日期:2016-02-18 15:09:15", "FK_BillCategory": "票据类别", "TaxRate": "税率", "Detail": "明细(参考采购单明细List(ePurchaseDtView)对象)", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }

采购单退货单List(ePurBack)对象
[{ "PK_ID": "整型编号(自增主键)", "sBackNo": "退货单单号,例如:BK_201509250001", "FK_InStoreID": "入库仓库id", "dBackDate": "退货日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "FK_StoreID": "仓库id", "sStoreName": "仓库名称", "FK_CheckID": "审核人id", "dCheckDate": "审核日期:0001-01-01 00:00:00", "FK_OperatorID": "操作员id", "sMemo": "备注", "FK_SupplyID": "供应商id", "sSupplyName": "供应商", "iIsCheck": "是否已审核(0未审核;1已审待出库;2已出库)", "sLinkMan": "联系人", "sLinkPhone": "联系电话", "iPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "fPercent": "折扣", "fPercentMoney": "折后金额", "fTotalMoney": "合计金额", "iPurchase": "采购人员ID", "PurchaseName": "采购人员", "CreatorPerson": "操作员ID", "OperatorDate": "操作日期:2016-02-18 15:09:15", "FK_BillCategory": "票据类别", "TaxRate": "税率", "Detail": "明细(参考采购单退货单明细List(PurBackDtView)对象)", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }]

采购单退货单明细List(PurBackDtView)对象
[{ "SNMgr": "SN管理模式 (0:无需SN管理 1:需SN管理 2:入库无需出库需SN管理)", "PK_ID": "整型编号(自增主键)", "FK_BackID": "退货单id", "FK_StoreID": "仓库id", "FK_ProductID": "产品id", "fPrice": "价格:1.000000", "fNum": "数量:1.000000", "cAmount": "金额", "sSn": "SN", "Remark": "备注", "BatchNumber": "批次编号", "FK_Unit": "单位ID", "Unit": "单位(参考产品单位List(ProductUnit)对象)" }]

采购单退货单ePurBack对象
{ "PK_ID": "整型编号(自增主键)", "sBackNo": "退货单单号,例如:BK_201509250001", "FK_InStoreID": "入库仓库id", "dBackDate": "退货日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-02-18 15:09:15", "FK_StoreID": "仓库id", "sStoreName": "仓库名称", "FK_CheckID": "审核人id", "dCheckDate": "审核日期:0001-01-01 00:00:00", "FK_OperatorID": "操作员id", "sMemo": "备注", "FK_SupplyID": "供应商id", "sSupplyName": "供应商", "iIsCheck": "是否已审核(0未审核;1已审待出库;2已出库)", "sLinkMan": "联系人", "sLinkPhone": "联系电话", "iPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "fPercent": "折扣", "fPercentMoney": "折后金额", "fTotalMoney": "合计金额", "iPurchase": "采购人员ID", "PurchaseName": "采购人员", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-02-18 15:09:15", "FK_BillCategory": "票据类别", "TaxRate": "税率", "Detail": "明细(参考采购单退货单明细List(PurBackDtView)对象)", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }

入库单InStore对象
{ "Detail": "明细(参考入库单明细List(InStoreDetailView)对象)", "PK_ID": "整型编号(自增主键)", "FK_StoreID": "仓库id", "sStoreName": "仓库名称", "FK_CheckID": "审核人id", "dCheckedDate": "审核日期:0001-01-01 00:00:00", "FK_OperatorID": "操作员id", "sOperatorName": "操作员名称", "FK_InStoreType": "入库类型,采购入库 = 1,销售退货入库 = 2,调拨入库 = 4,其他入库 = 5,盘盈入库 = 6,采购直接入库 = 7,归还入库 = 20,产品组装单 = 201,产品拆分单 = 202,委外加工产品入库单=100", "FK_SupplyID": "供应商id", "sSupplyName": "供应商", "FK_OrderID": "采购订单ID", "sInStoreNo": "入库单号", "dInStoreDate": "入库日期:0001-01-01 00:00:00", "dCreateDate": "创建日期:2016-03-03 14:45:07", "fDiscount": "折扣", "fTotalMoney": "合计金额", "fDiscountTotalMoney": "折后金额", "iPayWay": "支付方式(1:一次性支付2:分期支付3:不产生支付单)", "iIsVoucher": "是否生成凭证(1生成)", "IsVoucher": "是否生成自动会计凭证true:是;false:否", "sMemo": "备注", "iIsCheck": "是否审核(0:待审核入库 1:已审核入库)", "FK_RelationNo": "相关单据号", "iPurchase": "采购人员", "CreatorPerson": "创建人ID", "OperatorDate": "操作日期:2016-03-03 14:45:07", "CustomColumn1": "自定义字段1", "CustomColumn2": "自定义字段2", "CustomColumn3": "自定义字段3", ... "CustomColumn20": "自定义字段20" }

入库单明细List(InStoreDetailView)对象
[{ "PK_ID": "自增长列", "FK_InStoreID": "入库仓ID", "FK_ProductID": "产品ID", "fPrice": "价格:1.000000", "fNum": "数量:1.000000", "cAmount": "金额", "fDiscount": "折扣", "sMemo": "备注", "FK_StoreID": "仓库编号", "dProduceDate": "生产日期:1900-01-01 00:00:00", "sSerialNo": "唯一码(SN)", "BatchNumber": "批次编号", "FK_Unit": "单位ID", "FK_Source": "来源单据明细对应ID" }]

用户档案基本信息Resume对象
{ "id": "guid", "user_id": "用户编号", "name": "姓名", "card_no": "证件号码", "origin": "籍贯", "archive_no": "档案编号", "account": "用户账号", "emp_id": "工号", "bank_no": "银行账号", "social_security_no": "社保号", "old_name": "曾用名", "sex": "性别(0:女;1:男)", "birthday": "生日", "age": "年龄", "home_place": 出生地, "folk": "民族", "register_place": "户籍", "register_place_property": "户籍性质", "marriage_satus": "婚姻状况", "identity": "员工身份", "nationality": "国籍", "card_type": "证件类型", "political_status": "政治面貌", "health_status": "健康状况", "height": "体重", "weight": "体重", "sight": "视力", "education": "教育", "degree": "学位", "major": "专业", "technical_title": "职称", "school": "学校", "job_date": "工作日期", "service_length": "工龄", "free_service_length": "空闲工龄", "home_addr1": "家庭地址1", "home_addr2": "家庭地址2", "post_code1": "邮编1", "post_code2": "邮编2", "home_tel": "家庭电话", "email": "电子邮件", "mobile": "手机", "other_contact": "其他联系方式", "emp_type": "员工类型", "position_level": "职称等级", "entry_date": "入职日期", "positive_date": "转正日期", "attach_list": "附件(参考上传文件List(Attach)对象)", "emp_status": "员工状态(0:在职1:离职2:退休)", "current_free_service_length": "本公司空闲工龄", "current_service_length": "本公司工作时间", "pos_list": "职位列表(参考职位列表List(Position)对象)" }

职位列表List(Position)对象
[{ "org_name": "机构", "dept_name": "部门", "pos_name": "职位", "working_time": "任职时间", "working_time_length": "任职时长", "pos_type": "职位类型" }]

用户薪资信息List(Salary)对象
[{ "id": "工资id", "title": "标题", "month": "薪资月份", "social_security_month": "社保月份", "set_name": "套帐名称", "date": "日期", "total": "合计", "remark": "备注", "detail": [{"name":"项目","value":"值"}], "issueDate": "发放时间", "RowNum": "行号" }]

职位IBP_T_Position对象
{ "PK_ID": "整型编号(自增主键)", "FK_OrganID": "机构ID", "FK_DeptID": "部门ID", "sName": "职位名称", "iOrder": "排序字段", "sDescription": "职位描述", "iJobCount": "编制人数", "JobSummary": "岗位职责", "sRequirement": "任职要求", "iIsmanager": "是否管理职位(1:是;0:否)", "BelongsToSystem": "所属体系", "NeedJobRotation": "需定期轮岗", "RotationTime": "轮岗区间", "NeedChat": "需定期交流", "ChatTime": "交流区间" "PosisionLevel": "职位级别", "sCode": "职位排序编码", "iParentID": "上级职位", "FK_SalaryCategory": "薪资层级" }

用户模块List(Model)对象
[{ "ID": "模块ID", "NameZhCN": "模块名称", "NameEn": "模块英文名", "Functions": "模块菜单(参考模块菜单List(Function)对象)" }]

模块菜单List(Function)对象
[{ "ID": "模块菜单ID", "NameZhCN": "模块菜单名称", "NameEn": "模块菜单英文名", "TargetUrl": "模块菜单URL", "ParentID": "上级模块菜单ID,顶级模块菜单默认0", "ModuleID": "模块ID", "Location": "排序ID" "sRemark": "备注", "Functions": "模块菜单(参考模块菜单List(Function)对象)" }]

模块菜单Menu对象
{ "id": "模块菜单ID", "type_id": "模块ID", "parent_id": "上级模块菜单ID,顶级模块菜单默认0", "name": "模块菜单名称", "img_s": "模块菜单小图标", "img_b": "模块菜单大图标", "code": "模块菜单层级编码,例如:001,001001", "url": "模块菜单URL" }

模块菜单List(Menu)对象
[{ "id": "模块菜单ID", "type_id": "模块ID", "parent_id": "上级模块菜单ID,顶级模块菜单默认0", "name": "模块菜单名称", "img_s": "模块菜单小图标", "img_b": "模块菜单大图标", "code": "模块菜单层级编码,例如:001,001001", "url": "模块菜单URL" }]

用户模块List(Model)对象
[{ "id": "模块ID", "name": "模块名称" }]

组织机构List(Organization)对象
[{ "id": "机构ID", "name": "机构简称" }]

组织机构List(OrganizationFull)对象
[{ "id": "机构ID", "name": "机构名称", "short_name": "机构简称", "address": "地址", "tel": "电话", "post_code": "邮政编码", "fax": "传真", "website": "网站", "department_list": null }]

产品IBP_T_Product对象
{ "PK_ID": "产品编号,例如:OA", "sProductName": "产品名称", "sVersion": "版本", "sLanguage": "语言设置,0为简体中文,1为English,2为繁体中文", "sProductKey": "序列号", "sLicense": "许可证", "sUsersCount": "授权用户数", "iUsersCountType": "1:授权用户数 2: 并发用户数 3:模块用户", "dInstallDate": "安装日期:0001-01-01 00:00:00", "dUpdateDate": "更新日期:0001-01-01 00:00:00", "APIKey": "APIKey" }

系统使用信息UsageInfo对象
{ "sn": "产品序列号", "attachSize": "附件占用空间", "dbSize": "数据+备份占用空间", "dbDataSize": "数据占用空间", "dbBackSize": "备份占用空间", "usersCount": 授权人数, "ver": "产品版本", "installDate": "产品安装时间:0001-01-01 00:00:00", "updateDate": "产品升级时间:0001-01-01 00:00:00" }

页面访问统计List(PageVisitInfo)对象
[{ "year": "年", "month": "月", "day": "日", "hour": "时", "pageId": "页面id", "clientTypeId": "客户端类型(0:OA网站;1:QT客户端;2:单页面应用WebApp;3:安卓客户端;4:苹果客户端;5:第三方应用;6:单点登陆;7:微信)", "count": "次数", "FK_UserId": "用户Id" }]

表数据统计List(TableCountInfo)对象
[{ "year": "年", "month": "月", "day": "日", "hour": "时", "moduleName": "模块", "tableName": "统计表名", "count": "次数" }]

登陆统计List(LoginInfo)对象
[{ "year": "年", "month": "月", "day": "日", "clientTypeId": "客户端类型(0:OA网站;1:QT客户端;2:单页面应用WebApp;3:安卓客户端;4:苹果客户端;5:第三方应用;6:单点登陆;7:微信)", "loginCount": "登录次数", "activeCount": "激活次数" }]

用户IBP_T_User对象
{ "PK_ID": "整型编号(自增主键)" "sLoginName": "登录帐号", "sPassWord": "密码", "sName": "姓名", "sNameEn": "英文名", "iSex": "性别(0女,1男)", "dCreatedDate": "创建日期:2016-02-23 15:23:18", "dToLockTime": "用户锁定时间:0001-01-01 00:00:00", "iLock": "锁定(0不锁,1锁定)", "iSuspend": "状态(0在职,1离职,2退休)", "iIsDel": "是否删除(0正常,1已删除)", "TrueDate": "有效期至:2900-01-01 00:00:00", "sEmp_ID": "员工编号", "NetSize": "内部邮件 & 文件夹大小", "MailSize": "电子邮件空间大小", "iAuthLogin": "Ukey(0未勾选,1已勾选)", "iIsRole": "是否已分配角色(0未分配,1已分配)" }

在线状态UserOnlineStaues对象
{ "status_id": "状态ID( Unknown = 0, Online= 1,Welcome = 2,Away= 3,Busy= 4,Mute= 5,Invisible = 6,Offline = 7)" }

职位IBP_T_UserHoldPost对象
{ "PK_ID": "整型编号(自增主键)", "FK_PostID": "职位ID", "FK_UserID": "用户ID", "bIsPro": "是否主要职位(true:是;false:否)", "CreateDate": "任职日期:0001-01-01 00:00:00", "Position": "职位信息(参考职位信息IBP_T_Position对象)" }

职位信息IBP_T_Position对象
{ "PK_ID": "整型编号(自增主键)", "FK_OrganID": "机构ID", "FK_DeptID": "部门ID", "sName": "职位名称", "iOrder": "排序字段", "sDescription": "职位描述", "iJobCount": "编制人数", "JobSummary": "岗位职责", "sRequirement": "任职要求", "iIsmanager": "是否管理职位(1:是;0:否)", "BelongsToSystem": "所属体系", "NeedJobRotation": "需定期轮岗", "RotationTime": "轮岗区间", "NeedChat": "需定期交流", "ChatTime": "交流区间" }

角色成员List(IBP_T_RoleMember)对象
[{ "PK_ID": "整型编号(自增主键)", "MemberType": "成员类型,默认0", "FK_MemberID": "成员编号(用户ID), "FK_RoleID": "角色编号", "Role": "角色(参考角色IBP_T_Role对象)" }]

角色IBP_T_Role对象
{ "PK_ID": "整型编号(自增主键)", "sName": "角色名称", "iRoleType": "角色类型(1:系统角色 2:用户角色)", "sRemark": "备注", "FK_OrganID": "组织机构ID", "sCode": "角色层次代码,例如:001、001001", "ParentID": "角色父类ID,默认0", "iOrder": "排序字段" }

List(SimpleObject)对象
[{ "id": "编号(组织机构ID、部门ID、职位ID、人员ID、体系ID、分组ID、角色机构ID)", "name": "名称(组织机构名称、部门名称、职位名称、人员名称、体系名称、分组名称、角色机构名称) }]

部门Department对象
{ "PK_ID": "整型编号(自增主键)", "sName": "部门名称", "iParentID": "上级部门ID", "ParentName": "上级部门名称", "sCode": "部门编码", "FK_OrganID": "所属机构", "sTel": "电话", "sFax": "传真", "sAddress": "地址", "sRemark": "备注", "sDuty": "部门职责", "sYearTarget": "年度目标", "sWorkPlan": "任务计划", "Column1": "自定义字段1", "Column2": "自定义字段2", "Column3": "自定义字段3", "Column4": "自定义字段4", "Column5": "自定义字段5", "Column6": "自定义字段6", "Column7": "自定义字段7", "Column8": "自定义字段8", "Column9": "自定义字段9", "Column10": "自定义字段10" }