源系统平台:道一云
源系统接口: 获取报销信息列表qwcgi/api/reimApiCtl/getReimList.do
目标系统平台: 畅捷通T+
目标系统接口: 凭证创建/tplus/api/v2/doc/Create
源平台元数据配置:
{
"id": "reimNo",
"api": "qwcgi/api/reimApiCtl/getReimList.do",
"type": "QUERY",
"method": "POST",
"number": "reimNo",
"idCheck": true,
"request": [
{
"type": "string",
"field": "startTime",
"label": "开始时间",
"value": "{{LAST_SYNC_TIME|datetime}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "endTime",
"label": "结束时间",
"value": "{{CURRENT_TIME|datetime}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "currentPage",
"label": "查询页码",
"value": "1",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "pageSize",
"label": "分页大小",
"value": "100",
"describe": "默认为100,并且不超过1000",
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "actualMoney",
"label": "实付金额",
"value": null,
"describe": "实付金额",
"is_required": false
},
{
"type": "string",
"field": "payableMoney",
"label": "应付金额",
"value": null,
"describe": "应付金额",
"is_required": false
},
{
"type": "string",
"field": "verificationMoney",
"label": "核销金额",
"value": null,
"describe": "核销金额",
"is_required": false
},
{
"type": "string",
"field": "auditInfo",
"label": "审批信息",
"value": null,
"describe": "审批信息",
"is_required": false
},
{
"type": "string",
"field": "closePersonName",
"label": "最后审批人",
"value": null,
"describe": "最后审批人",
"is_required": false
},
{
"type": "string",
"field": "closeTime",
"label": "最后审批时间",
"value": null,
"describe": "最后审批时间",
"is_required": false
},
{
"type": "string",
"field": "createTime",
"label": "创建日期",
"value": null,
"describe": "创建日期",
"is_required": false
},
{
"type": "string",
"field": "departmentName",
"label": "创建人部门名称",
"value": null,
"describe": "创建人部门名称",
"is_required": false
},
{
"type": "string",
"field": "detailCount",
"label": "明细数量",
"value": null,
"describe": "明细数量",
"is_required": false
},
{
"type": "string",
"field": "creator",
"label": "创建人id",
"value": null,
"describe": "创建人id",
"is_required": false
},
{
"type": "string",
"field": "personName",
"label": "创建人名称",
"value": null,
"describe": "创建人名称",
"is_required": false
},
{
"type": "string",
"field": "reimNo",
"label": "报销单编号",
"value": null,
"describe": "报销单编号",
"is_required": false
},
{
"type": "string",
"field": "state",
"label": "state",
"value": null,
"describe": "1:审批中,2:已取消,3:已退审,4:已审批,5:转账中,6:已转账,7:转账失败",
"is_required": false
},
{
"type": "string",
"field": "statusDesc",
"label": "审批状态",
"value": null,
"describe": "审批状态(审批中,已取消,退审,已审批,转账中,已转账,转账失败)",
"is_required": false
},
{
"type": "string",
"field": "title",
"label": "报销单标题",
"value": null,
"describe": "报销单标题",
"is_required": false
},
{
"type": "string",
"field": "totalMoney",
"label": "报销总金额",
"value": null,
"describe": "报销总金额",
"is_required": false
},
{
"type": "string",
"field": "wxUserId",
"label": "创建人账号",
"value": null,
"describe": "创建人账号",
"is_required": false
},
{
"type": "string",
"field": "globalRemark",
"label": "全局备注",
"value": null,
"describe": "全局备注",
"is_required": false
},
{
"type": "string",
"field": "fieldList",
"label": "fieldList",
"value": null,
"describe": "itemKey:字段key itemName:字段名称 itemType:字段类型",
"is_required": false
},
{
"type": "string",
"field": "itemMap",
"label": "全局自定义字段值json字符",
"value": null,
"describe": "全局自定义字段值json字符",
"is_required": false
},
{
"type": "array",
"field": "detailList",
"label": "明细数据",
"children": [
{
"type": "string",
"field": "mediaList",
"label": "附件集合",
"value": null,
"parent": "detailList",
"describe": "附件集合",
"is_required": false
},
{
"type": "string",
"field": "imgPathList",
"label": "图片地址集合",
"value": null,
"parent": "detailList",
"describe": "图片地址集合",
"is_required": false
},
{
"type": "string",
"field": "time",
"label": "产生日期-开始",
"value": null,
"parent": "detailList",
"describe": "产生日期-开始",
"is_required": false
},
{
"type": "string",
"field": "endTimes",
"label": "产生日期-结束",
"value": null,
"parent": "detailList",
"describe": "产生日期-结束",
"is_required": false
},
{
"type": "string",
"field": "money",
"label": "报销金额",
"value": null,
"parent": "detailList",
"describe": "报销金额",
"is_required": false
},
{
"type": "string",
"field": "projId",
"label": "成本中心id",
"value": null,
"parent": "detailList",
"describe": "成本中心id",
"is_required": false
},
{
"type": "string",
"field": "projName",
"label": "成本中心名称",
"value": null,
"parent": "detailList",
"describe": "成本中心名称",
"is_required": false
},
{
"type": "string",
"field": "subjId",
"label": "科目id",
"value": null,
"parent": "detailList",
"describe": "科目id",
"is_required": false
},
{
"type": "string",
"field": "subjFullName",
"label": "所属科目",
"value": null,
"parent": "detailList",
"describe": "所属科目(多级科目以“|”分隔)",
"is_required": false
},
{
"type": "string",
"field": "subjCode",
"label": "科目编码",
"value": null,
"parent": "detailList",
"describe": "科目编码",
"is_required": false
},
{
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"parent": "detailList",
"describe": "备注",
"is_required": false
},
{
"type": "string",
"field": "invoices",
"label": "发票集合",
"value": null,
"parent": "detailList",
"describe": "发票集合",
"is_required": false
},
{
"type": "string",
"field": "type",
"label": "识别的发票类型",
"value": null,
"parent": "detailList",
"describe": "识别的发票类型",
"is_required": false
},
{
"type": "string",
"field": "invoiceCode",
"label": "发票代码",
"value": null,
"parent": "detailList",
"describe": "发票代码",
"is_required": false
},
{
"type": "string",
"field": "invoiceNumber",
"label": "发票号码",
"value": null,
"parent": "detailList",
"describe": "发票号码",
"is_required": false
},
{
"type": "string",
"field": "date",
"label": "发票日期",
"value": null,
"parent": "detailList",
"describe": "发票日期",
"is_required": false
},
{
"type": "string",
"field": "checkCode",
"label": "校验码",
"value": null,
"parent": "detailList",
"describe": "校验码",
"is_required": false
},
{
"type": "string",
"field": "total",
"label": "发票-总金额",
"value": null,
"parent": "detailList",
"describe": "发票-总金额",
"is_required": false
},
{
"type": "string",
"field": "tax",
"label": "发票-税额",
"value": null,
"parent": "detailList",
"describe": "发票-税额",
"is_required": false
},
{
"type": "string",
"field": "pretaxAmount",
"label": "发票-税前金额",
"value": null,
"parent": "detailList",
"describe": "发票-税前金额",
"is_required": false
},
{
"type": "string",
"field": "reimCustomFieldDataList",
"label": "明细自定义字段",
"value": null,
"parent": "detailList",
"describe": "明细自定义字段",
"is_required": false
},
{
"type": "string",
"field": "customName",
"label": "字段名称",
"value": null,
"parent": "detailList",
"describe": "字段名称",
"is_required": false
},
{
"type": "string",
"field": "value",
"label": "自定义字段值",
"value": null,
"parent": "detailList",
"describe": "自定义字段值",
"is_required": false
}
],
"describe": "明细数据",
"is_required": false
}
],
"condition": [
[]
],
"otherRequest": [
{
"type": "string",
"field": "dataKey",
"label": "数据包Key",
"value": "data",
"describe": null,
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "/tplus/api/v2/doc/Create",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "ExternalCode",
"label": "外部编码",
"value": "{{reimNo}}",
"describe": "字符串长度<50",
"is_required": true
},
{
"type": "string",
"field": "DocType",
"label": "凭证字",
"value": "记",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "VoucherDate",
"label": "制单日期",
"value": "{{closeTime}}",
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "Entrys",
"label": "Entrys",
"value": "detailList",
"children": [
{
"type": "object",
"field": "borrow-1",
"label": "借方-1",
"parent": "Entrys",
"children": [
{
"type": "string",
"field": "Summary-1",
"label": "借方摘要",
"value": "{{projName}}{{personName}}报{{endTimes}}{{subjFullName}}",
"parent": "borrow-1",
"describe": "字符串长度<200",
"is_required": true
},
{
"type": "string",
"field": "Account-1",
"label": "借方科目档案",
"value": "_function case when '{{detailList.projName}}' in ('总经办','人资行政部','财务部','商品部','项目服务部','兰州直营管理部','客服部','设计部','兰州配送中心','公司','信息部','市场部','线上运营部') then '66020702' else '66010702' end",
"parent": "borrow-1",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": "必须是末级科目",
"is_required": true
},
{
"type": "string",
"field": "ExchangeRate-1",
"label": "借方汇率",
"value": "1",
"parent": "borrow-1",
"describe": "科目启用外币核算必输,否则默认1",
"is_required": false
},
{
"type": "string",
"field": "Currency-1",
"label": "借方货币",
"value": "RMB",
"parent": "borrow-1",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": "举例:Currency: { Code: \"RMB\" }",
"is_required": true
},
{
"type": "string",
"field": "AmountDr-1",
"label": "借方本币",
"value": "_function sum({{detailList.invoices.0.amount}}-{{detailList.invoices.0.taxAmount}})",
"parent": "borrow-1",
"describe": null,
"is_required": true
},
{
"type": "array",
"field": "AuxInfos-1",
"label": "借方辅助核算项",
"parent": "borrow-1",
"children": [
{
"type": "string",
"field": "AuxAccDepartment-1",
"label": "部门",
"value": "{{detailList.projName}}",
"parent": "AuxInfos-1",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"mapping": "6296db63d96ce154e16af8ce",
"describe": null,
"is_required": false,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "AuxAccPerson-1",
"label": "个人(员工)",
"value": "_findCollection find Code from 3076d602-dbb1-3431-8977-b7558b1414d1 where Name={{personName}}",
"parent": "AuxInfos-1",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccCustomer-1",
"label": "客户(往来单位)",
"value": null,
"parent": "AuxInfos-1",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccProject-1",
"label": "项目",
"value": null,
"parent": "AuxInfos-1",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccInventory-1",
"label": "存货",
"value": null,
"parent": "AuxInfos-1",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "borrow-3",
"label": "借方-3",
"parent": "Entrys",
"children": [
{
"type": "string",
"field": "Summary-3",
"label": "借方摘要",
"value": "{{projName}}{{personName}}报{{endTimes}}{{subjFullName}}{{detailList.invoices.0.invoiceName}}",
"parent": "borrow-3",
"describe": "字符串长度<200",
"is_required": true
},
{
"type": "string",
"field": "Account-3",
"label": "借方科目档案",
"value": "_function case when '{{detailList.invoices.0.invoiceName}}'='增值税专用发票百分之6' then '2221010104' when '{{detailList.invoices.0.invoiceName}}'='增值税专用发票百分之5' then '2221010103' when '{{detailList.invoices.0.invoiceName}}'='增值税专用发票百分之3' then '2221010102' when '{{detailList.invoices.0.invoiceName}}'=10 then '2221010105' when '{{detailList.invoices.0.invoiceName}}'='增值税专用发票百分之13' then '2221010106' when '{{detailList.invoices.0.invoiceName}}'=16 then '2221010101' when '{{detailList.invoices.0.invoiceName}}'='增值税专用发票百分之9' then '2221010109' when '{{detailList.invoices.0.invoiceName}}'=13 then '2221010106' when '{{detailList.invoices.0.invoiceName}}'='增值税专用发票百分之1' then '2221010110' when '{{detailList.invoices.0.invoiceName}}'='长途汽车票' then '2221010107' when '{{detailList.invoices.0.invoiceName}}'='飞机票' then '2221010108' when '{{detailList.invoices.0.invoiceName}}'='火车票' then '2221010108' else '22210101' end",
"parent": "borrow-3",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": "必须是末级科目",
"is_required": true
},
{
"type": "string",
"field": "ExchangeRate-3",
"label": "借方汇率",
"value": "1",
"parent": "borrow-3",
"describe": "科目启用外币核算必输,否则默认1",
"is_required": false
},
{
"type": "string",
"field": "Currency-3",
"label": "借方货币",
"value": "RMB",
"parent": "borrow-3",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": "举例:Currency: { Code: \"RMB\" }",
"is_required": true
},
{
"type": "string",
"field": "AmountDr-3",
"label": "借方本币",
"value": "_function case when '{{detailList.invoices.0.taxAmount}}'=0 then '' else '{{detailList.invoices.0.taxAmount}}' end",
"parent": "borrow-3",
"describe": null,
"is_required": true
},
{
"type": "array",
"field": "AuxInfos-3",
"label": "借方辅助核算项",
"parent": "borrow-3",
"children": [
{
"type": "string",
"field": "AuxAccDepartment-3",
"label": "部门",
"value": "{{detailList.projName}}",
"parent": "AuxInfos-3",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"mapping": "6296db63d96ce154e16af8ce",
"describe": null,
"is_required": false,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "AuxAccPerson-3",
"label": "个人(员工)",
"value": "_findCollection find Code from 3076d602-dbb1-3431-8977-b7558b1414d1 where Name={{personName}}",
"parent": "AuxInfos-3",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccCustomer-3",
"label": "客户(往来单位)",
"value": null,
"parent": "AuxInfos-3",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccProject-3",
"label": "项目",
"value": null,
"parent": "AuxInfos-3",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccInventory-3",
"label": "存货",
"value": null,
"parent": "AuxInfos-3",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "loan-2",
"label": "贷方-2",
"parent": "Entrys",
"children": [
{
"type": "string",
"field": "Summary-2",
"label": "贷方摘要",
"value": "{{projName}}{{personName}}报{{endTimes}}{{subjFullName}}",
"parent": "loan-2",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "Account-2",
"label": "贷方科目档案",
"value": "_function case when '{{itemMap.fod416dede4ea74efa828be2b39507e93c}}' in ('未付') then '10020101' else '{{detailList.reimCustomFieldDataList_1_value}}' end",
"parent": "loan-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"mapping": "6296dd114cff8e22a468dcbc",
"describe": null,
"is_required": true,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "ExchangeRate-2",
"label": "贷方汇率",
"value": "1",
"parent": "loan-2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Currency-2",
"label": "贷方货币",
"value": "RMB",
"parent": "loan-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "AmountCr-2",
"label": "贷方本币",
"value": "{{verificationMoney}}",
"parent": "loan-2",
"describe": null,
"is_required": true
},
{
"type": "array",
"field": "AuxInfos-2",
"label": "贷方辅助核算项",
"parent": "loan-2",
"children": [
{
"type": "string",
"field": "AuxAccDepartment-2",
"label": "部门",
"value": "_function case when '{{itemMap.fod416dede4ea74efa828be2b39507e93c}}' in ('未付') then '' else '{{detailList.projName}}' end",
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"mapping": "6296db63d96ce154e16af8ce",
"describe": null,
"is_required": false,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "AuxAccPerson-2",
"label": "个人(员工)",
"value": "_function case when '{{itemMap.fod416dede4ea74efa828be2b39507e93c}}' in ('未付') then '' else _findCollection find Code from 3076d602-dbb1-3431-8977-b7558b1414d1 where Name={{personName}} _endFind end",
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccCustomer-2",
"label": "客户(往来单位)",
"value": null,
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccProject-2",
"label": "项目",
"value": null,
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccInventory-2",
"label": "存货",
"value": null,
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "loan-4",
"label": "贷方-4",
"parent": "Entrys",
"children": [
{
"type": "string",
"field": "Summary-4",
"label": "贷方摘要",
"value": "{{projName}}{{personName}}报{{endTimes}}{{subjFullName}}",
"parent": "loan-2",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "Account-4",
"label": "贷方科目档案",
"value": "_function case when '{{itemMap.fod416dede4ea74efa828be2b39507e93c}}' in ('未付') then '10020101' else '{{detailList.reimCustomFieldDataList_1_value}}' end",
"parent": "loan-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"mapping": "6296dd114cff8e22a468dcbc",
"describe": null,
"is_required": true,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "ExchangeRate-4",
"label": "贷方汇率",
"value": "1",
"parent": "loan-2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Currency-4",
"label": "贷方货币",
"value": "RMB",
"parent": "loan-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "AmountCr-4",
"label": "贷方本币",
"value": "_function sum({{detailList.money}}-{{verificationMoney}})",
"parent": "loan-2",
"describe": null,
"is_required": true
},
{
"type": "array",
"field": "AuxInfos-4",
"label": "贷方辅助核算项",
"parent": "loan-2",
"children": [
{
"type": "string",
"field": "AuxAccDepartment-4",
"label": "部门",
"value": "_function case when '{{itemMap.fod416dede4ea74efa828be2b39507e93c}}' in ('未付') then '' else '{{detailList.projName}}' end",
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"mapping": "6296db63d96ce154e16af8ce",
"describe": null,
"is_required": false,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "AuxAccPerson-4",
"label": "个人(员工)",
"value": "_function case when '{{itemMap.fod416dede4ea74efa828be2b39507e93c}}' in ('未付') then '' else '_findCollection find Code from 3076d602-dbb1-3431-8977-b7558b1414d1 where Name={{personName}} _endFind' end",
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccCustomer-4",
"label": "客户(往来单位)",
"value": null,
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccProject-4",
"label": "项目",
"value": null,
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "AuxAccInventory-4",
"label": "存货",
"value": null,
"parent": "AuxInfos-2",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": true
}
],
"response": [],
"otherRequest": [
{
"type": "string",
"field": "dataKey",
"label": "dataKey",
"value": "dto",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "accountStrategyId",
"label": "科目基础资料查询方案",
"value": "367ab75e-7355-3ae5-bb7a-35e6a5d934d3",
"describe": null,
"is_required": true
}
],
"otherResponse": []
}