和小青GPT助理聊天吧
小青是一位基于大语言预训练模型的超级智能AI，熟悉轻易云产品并能为您提供多种数据集成方案和技术支持。您在使用轻易云产品时遇到问题或有关技术咨询，小青都将为您提供专业、即时、高效的帮助和建议。与小青智能对话，您可享受同人类互动一样的使用体验，全面了解最新产品更新、功能特性及相关技术资讯，进一步提升您在数据集成领域的实力。小青是您友好、智能、便捷的助手，与她互动让您的数据集成之路轻松愉快。
扫码关注公众号即可开始聊天
-
联系我们 13760755942
-
EMail vincent067@outlook.com
-
地址 广东省广州市番禺区长华创意谷1-31号
从易快报到金蝶云星空通过接口集成数据
从易快报到金蝶云星空通过接口集成数据
来源系统:易快报
易快报为企业提供移动报销,预算费控,台账管理,报表分析,电子发票验真查重,全流程费控等一站式解决方案.全方位满足企业的报销费控需求,以连接为核心,促进企业降低成本、提升效率.
对接目标系统:金蝶云星空
金蝶K/3Cloud（金蝶云星空）是移动互联网时代的新型ERP，是基于WEB2.0与云技术的新时代企业管理服务平台。金蝶K/3Cloud围绕着“生态、人人、体验”，旨在帮助企业打造面向新时代的生态互联与协同平台，围绕生态中的每个角色，提供随手可得的云服务，最终实现敏捷协同，智慧运营的企业运营新境界。整个产品采用SOA架构，完全基于BOS平台组建而成，业务架构上贯穿流程驱动与角色驱动思想，结合中国管理模式与中国管理实践积累，精细化支持企业财务管理、供应链管理、生产管理、供应链协同管理、人力资源管理等核心应用。技术架构上该产品采用平台化构建，支持跨数据库应用，支持本地部署、私有云部署与公有云部署三种部署方式，同时还在公有云上开放中国第一款基于ERP的协同开发云平台。任何一家使用金蝶K/3Cloud产品的企业，其拥有的是包含金蝶在内的众多基于同一个平台提供服务的IT服务伙伴。
接口方案配置
系统对接前期需要通过调研公司的业务，规划出最便捷，效率最高的整体流程。通过流程我们需要建立对应的方案来吧这些流程一一的落地，轻易云集成平台开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。只需要根据指引设定好对应的参数即可启动使用。设定好源平台：易快报的接口参数设置，以及设定好目标平台：金蝶云星空的映射，即可启动方案进行测试
易快报接口明细
- 调用接口：/api/openapi/v1/docSequences
- 接口名称：获取指定状态单据列表(包含已删除单据)
- 方法：POST
请求参数
| 字段 | 字段名称 | 类型 | 配置值 |
|---|---|---|---|
| fields | 需要过滤掉的字段 | object | |
| fields.docData | 单据数据 | object | |
| fields.docData.logs | 审批日志 | string | |
| fields.docData.flowPlan | 审批流信息 | string | |
| fields.type | 单据类型 | string | expense |
| fields.index | 分页查询的起始索引序号 | string | 1651334400000 |
| fields.count | 查询数据条数 | string | 10 |
| fields.state | 单据状态 | string | PAID |
响应参数
| 字段 | 字段名称 | 类型 | 配置值 |
|---|---|---|---|
| type | type | string | |
| id | id | string | |
| corporationId | corporationId | string | |
| ownerId | ownerId | string | |
| dataType | dataType | string | |
| remark | remark | string | |
| title | title | string | |
| updateTime | updateTime | string | |
| specificationId | specificationId | string | |
| owner | owner | object | |
| owner.id | id | string | |
| owner.name | name | string | |
| owner.departments | departments | string | |
| owner.code | code | string | |
| owner.department | department | object | |
| owner.department.id | id | string | |
| owner.department.name | name | string | |
| owner.department.code | code | string | |
| owner.department.code | code | string | |
| owner.department.userProps | userProps | object | |
| owner.department.userProps.payeeId | payeeId | string | |
| owner.department.userProps.description | description | string | |
| owner.department.userProps.submitterId | submitterId | string | |
| owner.department.userProps.companyRealPay | companyRealPay | string | |
| owner.department.userProps.specificationId | specificationId | string | |
| owner.department.userProps.expenseDepartment | expenseDepartment | string | |
| owner.department.userProps.companyRealPay_rate | companyRealPay_rate | string | |
| owner.department.userProps.companyRealPay_budget | companyRealPay_budget | string | |
| owner.department.userProps.companyRealPay_foreign | companyRealPay_foreign | string | |
| owner.department.userProps.companyRealPay_budgetRate | companyRealPay_budgetRate | string | |
| owner.department.userProps.companyRealPay_budgetUnit | companyRealPay_budgetUnit | string | |
| owner.department.userProps.companyRealPay_budgetScale | companyRealPay_budgetScale | string | |
| owner.department.userProps.companyRealPay_foreignUnit | companyRealPay_foreignUnit | string | |
| owner.department.userProps.companyRealPay_budgetSymbol | companyRealPay_budgetSymbol | string | |
| owner.department.userProps.companyRealPay_standardUnit | companyRealPay_standardUnit | string | |
| owner.department.userProps.companyRealPay_budgetNumCode | companyRealPay_budgetNumCode | string | |
| owner.department.userProps.companyRealPay_budgetStrCode | companyRealPay_budgetStrCode | string | |
| owner.department.userProps.companyRealPay_foreignSymbol | companyRealPay_foreignSymbol | string | |
| owner.department.userProps.companyRealPay_foreignNumCode | companyRealPay_foreignNumCode | string | |
| owner.department.userProps.companyRealPay_foreignStrCode | companyRealPay_foreignStrCode | string | |
| owner.department.userProps.companyRealPay_standardSymbol | companyRealPay_standardSymbol | string | |
| owner.department.userProps.companyRealPay_standardNumCode | companyRealPay_standardNumCode | string | |
| owner.department.userProps.companyRealPay_standardStrCode | companyRealPay_standardStrCode | string | |
| owner.department.userProps.state | state | string | |
| owner.department.userProps.project | project | string | |
| owner.department.userProps.logs | logs | string | |
| owner.department.userProps.flowPlan | flowPlan | string | |
| owner.department.userProps.sumAmount | sumAmount | string | |
| owner.department.userProps.writeOffAmount | writeOffAmount | string | |
| owner.department.userProps.expenseDate | expenseDate | string | |
| owner.department.userProps.details | details | array | |
| owner.department.userProps.details.amount | amount | string | |
| owner.department.userProps.details.amount_standardStrCode | amount_standardStrCode | string | |
| owner.department.userProps.details.amount_standardNumCode | amount_standardNumCode | string | |
| owner.department.userProps.details.amount_standardSymbol | amount_standardSymbol | string | |
| owner.department.userProps.details.amount_standardUnit | amount_standardUnit | string | |
| owner.department.userProps.details.amount_rate | amount_rate | string | |
| owner.department.userProps.details.amount_foreignStrCode | amount_foreignStrCode | string | |
| owner.department.userProps.details.amount_foreignNumCode | amount_foreignNumCode | string | |
| owner.department.userProps.details.amount_foreign | amount_foreign | string | |
| owner.department.userProps.details.amount_foreignSymbol | amount_foreignSymbol | string | |
| owner.department.userProps.details.amount_foreignUnit | amount_foreignUnit | string | |
| owner.department.userProps.details.date | date | string | |
| owner.department.userProps.details.remark | remark | string | |
| owner.department.userProps.details.feeTypeId | feeTypeId | string | |
| owner.department.userProps.details.userProps | userProps | string | |
| owner.department.userProps.details.invoiceCount | invoiceCount | string | |
| owner.department.userProps.details.taxAmount | taxAmount | string | |
| owner.department.userProps.details.noTaxAmount | noTaxAmount | string | |
| owner.department.userProps.details.invoices | invoices | string | |
| owner.department.userProps.details.invoiceFormType | invoiceFormType | string | |
| owner.department.userProps.details.payeeInfo | payeeInfo | string | |
| owner.department.userProps.details.writtenOffRecords | writtenOffRecords | object | |
| owner.department.userProps.details.submitTime | submitTime | string | |
| owner.department.userProps.details.payeeInfo | payeeInfo | object | |
| owner.department.userProps.details.payeeInfo.sort | sort | string | |
| owner.department.userProps.details.payeeInfo.name | name | string | |
| owner.department.userProps.details.payeeInfo.cardNo | cardNo | string | |
| owner.department.userProps.details.payeeInfo.bank | bank | string | |
| owner.department.userProps.details.payeeInfo.branch | branch | string | |
| owner.department.userProps.details.payeeInfo.type | type | string | |
| owner.department.userProps.details.payeeInfo.province | province | string | |
| owner.department.userProps.details.payeeInfo.city | city | string | |
| owner.department.userProps.details.payeeInfo.certificateType | certificateType | string | |
| owner.department.userProps.details.payeeInfo.certificateNo | certificateNo | string | |
| owner.department.userProps.details.payeeInfo.bankLinkNo | bankLinkNo | string | |
| owner.department.userProps.details.payeeInfo.bankName | bankName | string | |
| owner.department.userProps.details.payeeInfo.swiftCode | swiftCode | string | |
| owner.department.userProps.details.payeeInfo.bankCode | bankCode | string | |
| owner.department.userProps.details.payeeInfo.branchCode | branchCode | string | |
| owner.department.userProps.details.payeeInfo.remark | remark | string | |
| owner.department.userProps.details.payeeInfo.id | id | string | |
| owner.department.userProps.details.payeeInfo.payorId | payorId | string | |
| owner.department.userProps.details.payeeInfo.paymentChannel | paymentChannel | string | |
| owner.department.userProps.details.payeeInfo.paymentAccountId | paymentAccountId | string | |
| owner.department.userProps.details.payeeInfo.payTime | payTime | string | |
| owner.department.userProps.details.payeeInfo.multiplePayeesMode | multiplePayeesMode | string | |
| owner.department.userProps.details.payeeInfo.channelTradeNo | channelTradeNo | string | |
| owner.department.userProps.details.payeeInfo.payPlan | payPlan | string | |
| owner.department.userProps.details.payeeInfo.receiptState | receiptState | string | |
| owner.department.userProps.details.payeeInfo.paymentAccount | paymentAccount | string |
金蝶云星空接口明细
- API：batchSave
- NAME：付款单新增
- METHOD：POST
请求参数
| 接口字段 | 名称 | 预设值 |
|---|---|---|
| FBillNo | 单据编号 | function case when '{{details_userProps_u归属组织code}}'='' then '{{code}}{{userProps_u归属组织code}}' else '{{code}}{{details_userProps_u归属组织code}}' end |
| FCURRENCYID | 币别 | PRE001 |
| FDATE | 业务日期 | _function FROM_UNIXTIME( ( {{payTime}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' ) |
| FBillTypeID | 单据类型 | kxzfd |
| FCONTACTUNITTYPE | 往来单位类型 | BD_Department |
| FCONTACTUNIT | 往来单位 | findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department_name}} |
| FRECTUNITTYPE | 收款单位类型 | BD_Department |
| FRECTUNIT | 收款单位 | _findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department_name}} |
| FSETTLEORGID | 结算组织 | function case when '{{details_userProps_u归属组织code}}'>0 then '{{details_userProps_u归属组织code}}' else '{{userProps_u归属组织code}}' end |
| FDepartment | 部门 | _findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where name={{department_name}} |
| FPAYORGID | 付款组织 | function case when '{{FPAYORGID}}'>0 then '{{FPAYORGID}}' when '{{details_userProps_u归属组织code}}' in ('') then '{{userProps_u归属组织code}}' else '{{details_userProps_u归属组织code}}' end |
| FPAYAMOUNTFOR | 付款金额 | _function sum({{sumAmount}}-{{writeOffAmount}}) |
| FEXCHANGETYPE | 汇率类型 | HLTX01_SYS |
| FSETTLECUR | 结算币别 | PRE001 |
| FREMARK | 备注 | {{remark}} |
| FPAYBILLENTRY | 付款单明细 | details |
| FPAYBILLENTRY.FSETTLETYPEID | 结算方式 | function case when '{{paymentAccountId}}' in ('') then 'JSFS01_SYS' else 'JSFS04_SYS' end |
| FPAYBILLENTRY.FPAYTOTALAMOUNTFOR | 付款金额 | {{details_amount}} |
| FPAYBILLENTRY.FPURPOSEID | 收付款用途 | SFKYT10_SYS |
| FPAYBILLENTRY.FACCOUNTID | 我方银行账号 | {{paymentAccount_accountNo}} |
| FPAYBILLENTRY.FCOMMENT | 备注 | {{details_remark}} |
| FPAYBILLENTRY.FCOSTID | 费用项目 | _findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details_feeTypeId}} |
| FPAYBILLENTRY.FEXPENSEDEPTID_E | 费用承担部门 | findCollection find code from 19c94f4e-612d-3b26-8952-edf9168371d5 where id={{details_userProps_expenseDepartment}} |
| FPAYBILLENTRY.F_wk_KH | 客户 | {{details_userProps_u_客户code}} |
| FPAYBILLENTRY.FINNERACCOUNTID | 内部账号 | _function case when '{{details_userProps_u归属组织code}}' in ('') then '{{userProps_u归属组织code}}' else '{{details_userProps_u归属组织code}}' end |
| FPAYBILLENTRY.F_wk_bxje1 | 报销金额 | {{sumAmount}} |
| FPAYBILLENTRY.F_wk_hxje | 核销金额 | {{writeOffAmount}} |
| FPAYBILLENTRY.F_wk_YG | 员工 | function case when '{{userProps_u原借款人code}}'='' then '{{userProps_u实际报销人code}}' else '{{userProps_u原借款人_code}}' end |
| FPAYBILLENTRY.FormId | 业务对象表单Id | AP_PAYBILL |
| FPAYBILLENTRY.Operation | 执行的操作 | BatchSave |
| FPAYBILLENTRY.IsAutoSubmitAndAudit | 提交并审核 | false |
| FPAYBILLENTRY.IsVerifyBaseDataField | 验证基础资料 | false |
系统数据集成价值
通过无代码的数据集成与数据建模的智能数据管道技术，帮助企业将所有应用程序、数据库、事件和文件等数据信息提取到数据仓库中，并快速将分散的数据转化为数据集、API、自动化流程等开箱即用的数据服务。配置接口的模式对接易快报和金蝶云星空，使得单据无缝互通。打造企业内部数据一体化，让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通，同时支持供应链数据分析流程自动化，结果推送，推进相关供应链问题优化。及时打通供应链孤岛，实现数据驱动供应链协同，进一步提升企业竞争力。
热门文章
| 2024-01-02 08:27:43 | |
| 2023-12-25 10:05:21 | |
| 2023-12-22 08:32:41 | |
| 2023-12-16 03:13:20 | |
| 2023-12-07 10:53:18 |
黄宏棵 13286997615
数据集成顾问 数据集成顾问 阿里巴巴市场专业小满OKKI对接指导咨询师,了解企业市场营销、客户关系管理、供应链优化等多方面的需求，并基于小满OKKI的工具和功能，为客户提供个性化的对接指导服务。
何海波 18175716035
数据集成顾问 轻易云的技术专家，拥有丰富的数据集成规划经验。他能够为客户提供专业、全面的数据集成规划方案，熟练掌握多种集成技术和工具，帮助企业在数据集成领域得到长远发展。
卢剑航 13760755942
数据集成专家 拥有十多年丰富的经验，擅长ERP、MES、数据中台、营销云中台等集成。他能够根据客户需求，为其提供一站式集成解决方案，帮助企业快速实现各类系统数据集成服务。