轻易云
注册体验

金蝶云星空对接打通小满OKKICRM销售订单查询接口与推送产品到小满产品库接口

1 条评论

金蝶云星空对接打通小满OKKICRM销售订单查询接口与推送产品到小满产品库接口

用友U8集成

接通系统：金蝶云星空

金蝶K/3Cloud在总结百万家客户管理最佳实践的基础上，提供了标准的管理模式；通过标准的业务架构：多会计准则、多币别、多地点、多组织、多税制应用框架等，有效支持企业的运营管理；K/3Cloud提供了标准的业务建模：35种标准ERP领域模型、1046种模型元素、21243种模型元素属性组合，288个业务服务构件，让企业及伙伴可快速构建出行业化及个性化的应用。

目标系统:小满OKKICRM

小满科技成立于2013年，是阿里巴巴集团战略投资的高新技术企业。小满科技以“人工智能+大数据”为核心驱动力，为外贸企业提供智能CRM解决方案。公司旗下的产品OKKICRM聚焦海外客户管理与销售管理，已累计服务客户数万家，用户超10万

多系统对接方案配置

使用轻易云系统数据集成平台对应的模块：数据集成方案。然后选择开始创建数据集成方案。在方案配置表单中选择对应的源业务系统：金蝶云星空，然后选择对应的连接器。选择对应的销售订单查询作为数据对接来源。然后再通过写入目标平台配置目标系统为小满OKKICRM,并且选择对应连接器（关于小满OKKICRM的接口如何配置可以在轻易云数据集成社区论坛中找到相关信息,选择好对应的推送产品到小满产品库接口作为数据写入动作，既可以完成第一步的数据对接配置。
用友数据打通
T+数据对接
ERP与电商数据对接

金蝶云星空接口明细

  • API：executeBillQuery
  • NAME：销售订单查询
  • METHOD：POST

请求参数

接口字段字段名称预设值描述 FSaleOrderEntry_FEntryIDFSaleOrderEntry_FEntryIDFSaleOrderEntry_FEntryID FIDFIDFID FBillNo单据编号FBillNo FDocumentStatus单据状态FDocumentStatus FSaleOrgId_FNumber销售组织FSaleOrgId.FNumber FDate日期FDate FCustId_FNumber客户FCustId.FNumber FCustId_FName客户FCustId.FName FSaleDeptId_Fnumber销售部门编码FSaleDeptId.Fnumber FSaleGroupId销售组FSaleGroupId FSalerId_FNumber销售员编码FSalerId.FNumber FReceiveId收货方FReceiveId FSettleId结算方FSettleId FSettleAddress结算方地址FSettleAddress FChargeId付款方FChargeId FCreatorId创建人FCreatorId FCreateDate创建日期FCreateDate FModifierId最后修改人FModifierId FModifyDate最后修改日期FModifyDate FApproverId审核人FApproverId FApproveDate审核日期FApproveDate FCloseStatus关闭状态FCloseStatus FCloserId关闭人FCloserId FCloseDate关闭日期FCloseDate FCancelStatus作废状态FCancelStatus FCancellerId作废人FCancellerId FCancelDate作废日期FCancelDate FExchangeRateFExchangeRateFExchangeRate FChangerId变更人FChangerId FChangeDate变更日期FChangeDate FChangeReason变更原因FChangeReason FBillTypeID_Fnumber单据类型FBillTypeID.Fnumber FBusinessType业务类型FBusinessType FHeadDeliveryWay交货方式FHeadDeliveryWay FReceiveAddress收货方地址FReceiveAddress FHEADLOCID_FADDRESS交货地点FHEADLOCID.FADDRESS FHEADLOCID_FTCONTACT交货地点FHEADLOCID.FContact FHEADLOCID_FTEL交货地点FHEADLOCID.FTEL FReceiveContact收货方联系人FReceiveContact FNote备注FNote FSignStatus签收状态FSignStatus FManualClose是否手工关闭FManualClose FSOFrom订单来源FSOFrom FMaterialId_Fnumber物料编码FMaterialId.Fnumber FMaterialName物料名称FMaterialName FMaterialModel规格型号FMaterialModel FMaterialType物料类别FMaterialType FUnitID_Fnumber销售单位FUnitID.Fnumber FPrice单价FPrice FTaxPrice含税单价FTaxPrice FBomIdBOM版本FBomId FPriceUnitId计价单位FPriceUnitId FPriceUnitQty计价数量FPriceUnitQty FPriceCoefficient价格系数FPriceCoefficient FDiscountRate折扣率%FDiscountRate FDiscount折扣额FDiscount FEntryTaxRate税率%FEntryTaxRate FEntryTaxAmount税额FEntryTaxAmount FAllAmount价税合计FAllAmount FTaxNetPrice净价FTaxNetPrice FBaseUnitQty销售基本数量FBaseUnitQty FDeliveryControl控制发货数量FDeliveryControl FDeliveryMaxQty发货上限FDeliveryMaxQty FDeliveryMinQty发货下限FDeliveryMinQty FTransportLeadTime1运输提前期FTransportLeadTime1 FBefDisAllAmt折前价税合计FBefDisAllAmt FBefDisAmt折前金额FBefDisAmt FTaxAmount_LC税额（本位币）FTaxAmount_LC FAmount_LC金额（本位币）FAmount_LC FAllAmount_LC价税合计（本位币）FAllAmount_LC FMrpCloseStatus业务关闭FMrpCloseStatus FMrpFreezeStatus业务冻结FMrpFreezeStatus FFreezerId冻结人FFreezerId FFreezeDate冻结日期FFreezeDate FMrpTerminateStatus业务终止FMrpTerminateStatus FTerminaterId终止人FTerminaterId FTerminateDate终止日期FTerminateDate FBaseDeliJoinQty（代码有用）关联发货通知数量（销售基本）FBaseDeliJoinQty FRemainOutQty剩余未出数量（销售）FRemainOutQty FBaseInvoiceJoinQty关联开票数量（基本）(作废)FBaseInvoiceJoinQty FInvoiceJoinQty关联开票数量(作废)FInvoiceJoinQty FBasePurJoinQty关联采购/生产数量（销售基本）FBasePurJoinQty FPurJoinQty关联采购/生产数量FPurJoinQty FReceiptOrgId收款组织FReceiptOrgId FSettleOrgIds结算组织FSettleOrgIds FAmount金额FAmount FEntryNote备注FEntryNote FQty销售数量FQty FLimitDownPrice最低限价FLimitDownPrice FSysPrice系统定价FSysPrice FStockOrgId库存组织FStockOrgId FBaseUnitId基本单位FBaseUnitId FChangeFlag变更标志FChangeFlag FMapId客户物料编码FMapId FOwnerTypeId货主类型FOwnerTypeId FOwnerId货主FOwnerId FIsFree是否赠品FIsFree FLOCKQTY锁库/预留数量(库存单位)FLOCKQTY FLOCKFLAG锁库/预留标识FLOCKFLAG FProduceDate生产日期FProduceDate FExpiryDate有效期至FExpiryDate FExpUnit保质期单位FExpUnit FExpPeriod保质期FExpPeriod FMaterialIsProduce物料允许生产属性FMaterialIsProduce FTaxCombination税组合FTaxCombination FLot批号FLot FMapName客户物料名称FMapName FAuxPropId辅助属性FAuxPropId FReturnType退补类型FReturnType FDeliveryDate要货日期FDeliveryDate FSrcType源单类型FSrcType FSrcBillNo源单编号FSrcBillNo FBaseDeliveryMaxQty发货上限（基本）FBaseDeliveryMaxQty FBaseDeliveryMinQty发货下限（基本）FBaseDeliveryMinQty FOEMInStockJoinQty关联受托材料入库套数FOEMInStockJoinQty FBaseOEMInStockJoinQty关联受托材料入库套数(库存基本)FBaseOEMInStockJoinQty FBaseARJoinQty关联应收数量（计价基本）FBaseARJoinQty FIsReturn物料允许退货属性FIsReturn FBFLowId业务流程FBFLowId FIsInventory物料允许库存属性FIsInventory FARJOINAMOUNT关联应收金额FARJOINAMOUNT FBaseRemainOutQty剩余未出数量（销售基本）FBaseRemainOutQty FMaterialIsSubContract物料允许委外属性FMaterialIsSubContract FCanOutQty可出数量（销售）FCanOutQty FBaseCanOutQty可出数量（销售基本）FBaseCanOutQty FCanReturnQty可退数量（销售）FCanReturnQty FBaseCanReturnQty可退数量（销售基本）FBaseCanReturnQty FMtoNo计划跟踪号FMtoNo FPriority需求优先级FPriority FReserveType预留类型FReserveType FMinPlanDeliveryDate计划交货日期FMinPlanDeliveryDate FDeliveryStatus发货状态FDeliveryStatus FOldQty原数量FOldQty FPromotionMatchType促销匹配类型FPromotionMatchType FPriceListEntry行价目表FPriceListEntry FSupplyOrgId供应组织FSupplyOrgId FNetOrderEntryId供应商协同平台订单分录IDFNetOrderEntryId FPriceBaseQty计价基本数量FPriceBaseQty FSetPriceUnitID定价单位FSetPriceUnitID FStockUnitID库存单位FStockUnitID FStockQty库存数量FStockQty FStockBaseQty库存基本数量FStockBaseQty FStockBaseCanOutQty可出数量（库存基本）FStockBaseCanOutQty FStockBaseCanReturnQty可退数量（库存基本）FStockBaseCanReturnQty FStockBaseARJoinQty关联应收数量（库存基本）FStockBaseARJoinQty FStockBasePurJoinQty关联采购/生产数量（库存基本）FStockBasePurJoinQty FSalBaseNum源单基本分子FSalBaseNum FStockBaseDen库存基本分母FStockBaseDen FSRCBIZUNITID携带主单位FSRCBIZUNITID FPurBaseQty采购基本数量FPurBaseQty FPurUnitID采购单位FPurUnitID FPurQty采购数量FPurQty FSalBaseARJoinQty关联应收数量（销售基本）FSalBaseARJoinQty FOUTLMTUNIT超发控制单位类型FOUTLMTUNIT FOutLmtUnitID超发控制单位FOutLmtUnitID FCONSIGNSETTQTY寄售结算数量FCONSIGNSETTQTY FCONSIGNSETTBASEQTY寄售结算数量（销售基本）FCONSIGNSETTBASEQTY FLeftQty待锁库/待预留数量(库存单位)FLeftQty FRowType产品类型FRowType FParentMatId父项产品FParentMatId FRowId行标识FRowId FParentRowId父行标识FParentRowId FInStockPrice最新采购入库价FInStockPrice FSOStockId_FNumber明细仓库FSOStockId.FNumber FSOStockLocalId仓位FSOStockLocalId FPurPriceUnitId采购计价单位FPurPriceUnitId FISMRP已计划运算FISMRP FBarcode零售条形码FBarcode FBranchId发货门店FBranchId FRetailSaleProm是否零售促销FRetailSaleProm FBASEFINARQTY先开票数量（计价基本）FBASEFINARQTY FSALBASEFINARQTY先开票数量（销售基本）FSALBASEFINARQTY FEntryDiscountList行折扣表FEntryDiscountList FPriceDiscount单价折扣FPriceDiscount FSettleCurrIdFSettleCurrIdFSettleCurrId.Fnumber FSPMENTRYID促销政策IDFSPMENTRYID FSPMANDRPMCONTENT促销内容FSPMANDRPMCONTENT FBillAllAmount整单价税合计FBillAllAmount FLINKMAN收货人姓名FLINKMAN FLINKPHONE联系电话FLINKPHONE F_hesh_Discount产品折扣额F_hesh_Discount FSalerId_FName销售员名称FSalerId.FName FSaleDeptId_FName销售部门名称FSaleDeptId.FName Limit最大行数{{PAGINATION_PAGE_SIZE}}金蝶的查询分页参数 StartRow开始行索引{{PAGINATION_START_ROW}}金蝶的查询分页参数 TopRowCount返回总行数金蝶的查询分页参数 FilterString过滤条件FBillTypeID.Fnumber='XSDD01_SYS' and FModifyDate>='{{LAST_SYNC_TIME datetime}}' and (FSaleOrgId.FNumber='100' or FSaleOrgId.FNumber='103')示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>= FieldKeys需查询的字段key集合金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber FormId业务对象表单IdSAL_SaleOrder必须填写金蝶的表单ID如😛UR_PurchaseOrder

响应参数

接口字段字段名称预设值描述 FSaleOrderEntry_FEntryIDFSaleOrderEntry_FEntryIDFSaleOrderEntry_FEntryID FIDFIDFID FBillNo单据编号FBillNo FDocumentStatus单据状态FDocumentStatus FSaleOrgId_FNumber销售组织FSaleOrgId.FNumber FDate日期FDate FCustId_FNumber客户FCustId.FNumber FCustId_FName客户FCustId.FName FSaleDeptId_Fnumber销售部门编码FSaleDeptId.Fnumber FSaleGroupId销售组FSaleGroupId FSalerId_FNumber销售员编码FSalerId.FNumber FReceiveId收货方FReceiveId FSettleId结算方FSettleId FSettleAddress结算方地址FSettleAddress FChargeId付款方FChargeId FCreatorId创建人FCreatorId FCreateDate创建日期FCreateDate FModifierId最后修改人FModifierId FModifyDate最后修改日期FModifyDate FApproverId审核人FApproverId FApproveDate审核日期FApproveDate FCloseStatus关闭状态FCloseStatus FCloserId关闭人FCloserId FCloseDate关闭日期FCloseDate FCancelStatus作废状态FCancelStatus FCancellerId作废人FCancellerId FCancelDate作废日期FCancelDate FExchangeRateFExchangeRateFExchangeRate FChangerId变更人FChangerId FChangeDate变更日期FChangeDate FChangeReason变更原因FChangeReason FBillTypeID_Fnumber单据类型FBillTypeID.Fnumber FBusinessType业务类型FBusinessType FHeadDeliveryWay交货方式FHeadDeliveryWay FReceiveAddress收货方地址FReceiveAddress FHEADLOCID_FADDRESS交货地点FHEADLOCID.FADDRESS FHEADLOCID_FTCONTACT交货地点FHEADLOCID.FContact FHEADLOCID_FTEL交货地点FHEADLOCID.FTEL FReceiveContact收货方联系人FReceiveContact FNote备注FNote FSignStatus签收状态FSignStatus FManualClose是否手工关闭FManualClose FSOFrom订单来源FSOFrom FMaterialId_Fnumber物料编码FMaterialId.Fnumber FMaterialName物料名称FMaterialName FMaterialModel规格型号FMaterialModel FMaterialType物料类别FMaterialType FUnitID_Fnumber销售单位FUnitID.Fnumber FPrice单价FPrice FTaxPrice含税单价FTaxPrice FBomIdBOM版本FBomId FPriceUnitId计价单位FPriceUnitId FPriceUnitQty计价数量FPriceUnitQty FPriceCoefficient价格系数FPriceCoefficient FDiscountRate折扣率%FDiscountRate FDiscount折扣额FDiscount FEntryTaxRate税率%FEntryTaxRate FEntryTaxAmount税额FEntryTaxAmount FAllAmount价税合计FAllAmount FTaxNetPrice净价FTaxNetPrice FBaseUnitQty销售基本数量FBaseUnitQty FDeliveryControl控制发货数量FDeliveryControl FDeliveryMaxQty发货上限FDeliveryMaxQty FDeliveryMinQty发货下限FDeliveryMinQty FTransportLeadTime1运输提前期FTransportLeadTime1 FBefDisAllAmt折前价税合计FBefDisAllAmt FBefDisAmt折前金额FBefDisAmt FTaxAmount_LC税额（本位币）FTaxAmount_LC FAmount_LC金额（本位币）FAmount_LC FAllAmount_LC价税合计（本位币）FAllAmount_LC FMrpCloseStatus业务关闭FMrpCloseStatus FMrpFreezeStatus业务冻结FMrpFreezeStatus FFreezerId冻结人FFreezerId FFreezeDate冻结日期FFreezeDate FMrpTerminateStatus业务终止FMrpTerminateStatus FTerminaterId终止人FTerminaterId FTerminateDate终止日期FTerminateDate FBaseDeliJoinQty（代码有用）关联发货通知数量（销售基本）FBaseDeliJoinQty FRemainOutQty剩余未出数量（销售）FRemainOutQty FBaseInvoiceJoinQty关联开票数量（基本）(作废)FBaseInvoiceJoinQty FInvoiceJoinQty关联开票数量(作废)FInvoiceJoinQty FBasePurJoinQty关联采购/生产数量（销售基本）FBasePurJoinQty FPurJoinQty关联采购/生产数量FPurJoinQty FReceiptOrgId收款组织FReceiptOrgId FSettleOrgIds结算组织FSettleOrgIds FAmount金额FAmount FEntryNote备注FEntryNote FQty销售数量FQty FLimitDownPrice最低限价FLimitDownPrice FSysPrice系统定价FSysPrice FStockOrgId库存组织FStockOrgId FBaseUnitId基本单位FBaseUnitId FChangeFlag变更标志FChangeFlag FMapId客户物料编码FMapId FOwnerTypeId货主类型FOwnerTypeId FOwnerId货主FOwnerId FIsFree是否赠品FIsFree FLOCKQTY锁库/预留数量(库存单位)FLOCKQTY FLOCKFLAG锁库/预留标识FLOCKFLAG FProduceDate生产日期FProduceDate FExpiryDate有效期至FExpiryDate FExpUnit保质期单位FExpUnit FExpPeriod保质期FExpPeriod FMaterialIsProduce物料允许生产属性FMaterialIsProduce FTaxCombination税组合FTaxCombination FLot批号FLot FMapName客户物料名称FMapName FAuxPropId辅助属性FAuxPropId FReturnType退补类型FReturnType FDeliveryDate要货日期FDeliveryDate FSrcType源单类型FSrcType FSrcBillNo源单编号FSrcBillNo FBaseDeliveryMaxQty发货上限（基本）FBaseDeliveryMaxQty FBaseDeliveryMinQty发货下限（基本）FBaseDeliveryMinQty FOEMInStockJoinQty关联受托材料入库套数FOEMInStockJoinQty FBaseOEMInStockJoinQty关联受托材料入库套数(库存基本)FBaseOEMInStockJoinQty FBaseARJoinQty关联应收数量（计价基本）FBaseARJoinQty FIsReturn物料允许退货属性FIsReturn FBFLowId业务流程FBFLowId FIsInventory物料允许库存属性FIsInventory FARJOINAMOUNT关联应收金额FARJOINAMOUNT FBaseRemainOutQty剩余未出数量（销售基本）FBaseRemainOutQty FMaterialIsSubContract物料允许委外属性FMaterialIsSubContract FCanOutQty可出数量（销售）FCanOutQty FBaseCanOutQty可出数量（销售基本）FBaseCanOutQty FCanReturnQty可退数量（销售）FCanReturnQty FBaseCanReturnQty可退数量（销售基本）FBaseCanReturnQty FMtoNo计划跟踪号FMtoNo FPriority需求优先级FPriority FReserveType预留类型FReserveType FMinPlanDeliveryDate计划交货日期FMinPlanDeliveryDate FDeliveryStatus发货状态FDeliveryStatus FOldQty原数量FOldQty FPromotionMatchType促销匹配类型FPromotionMatchType FPriceListEntry行价目表FPriceListEntry FSupplyOrgId供应组织FSupplyOrgId FNetOrderEntryId供应商协同平台订单分录IDFNetOrderEntryId FPriceBaseQty计价基本数量FPriceBaseQty FSetPriceUnitID定价单位FSetPriceUnitID FStockUnitID库存单位FStockUnitID FStockQty库存数量FStockQty FStockBaseQty库存基本数量FStockBaseQty FStockBaseCanOutQty可出数量（库存基本）FStockBaseCanOutQty FStockBaseCanReturnQty可退数量（库存基本）FStockBaseCanReturnQty FStockBaseARJoinQty关联应收数量（库存基本）FStockBaseARJoinQty FStockBasePurJoinQty关联采购/生产数量（库存基本）FStockBasePurJoinQty FSalBaseNum源单基本分子FSalBaseNum FStockBaseDen库存基本分母FStockBaseDen FSRCBIZUNITID携带主单位FSRCBIZUNITID FPurBaseQty采购基本数量FPurBaseQty FPurUnitID采购单位FPurUnitID FPurQty采购数量FPurQty FSalBaseARJoinQty关联应收数量（销售基本）FSalBaseARJoinQty FOUTLMTUNIT超发控制单位类型FOUTLMTUNIT FOutLmtUnitID超发控制单位FOutLmtUnitID FCONSIGNSETTQTY寄售结算数量FCONSIGNSETTQTY FCONSIGNSETTBASEQTY寄售结算数量（销售基本）FCONSIGNSETTBASEQTY FLeftQty待锁库/待预留数量(库存单位)FLeftQty FRowType产品类型FRowType FParentMatId父项产品FParentMatId FRowId行标识FRowId FParentRowId父行标识FParentRowId FInStockPrice最新采购入库价FInStockPrice FSOStockId_FNumber明细仓库FSOStockId.FNumber FSOStockLocalId仓位FSOStockLocalId FPurPriceUnitId采购计价单位FPurPriceUnitId FISMRP已计划运算FISMRP FBarcode零售条形码FBarcode FBranchId发货门店FBranchId FRetailSaleProm是否零售促销FRetailSaleProm FBASEFINARQTY先开票数量（计价基本）FBASEFINARQTY FSALBASEFINARQTY先开票数量（销售基本）FSALBASEFINARQTY FEntryDiscountList行折扣表FEntryDiscountList FPriceDiscount单价折扣FPriceDiscount FSettleCurrIdFSettleCurrIdFSettleCurrId.Fnumber FSPMENTRYID促销政策IDFSPMENTRYID FSPMANDRPMCONTENT促销内容FSPMANDRPMCONTENT FBillAllAmount整单价税合计FBillAllAmount FLINKMAN收货人姓名FLINKMAN FLINKPHONE联系电话FLINKPHONE F_hesh_Discount产品折扣额F_hesh_Discount FSalerId_FName销售员名称FSalerId.FName FSaleDeptId_FName销售部门名称FSaleDeptId.FName 物流费渠道物料费用 Q1返利渠道第一季度返利费用 Q2返利渠道第二季度返利费用 Q3返利渠道第三季度返利费用 Q4返利渠道第四季度返利费用 售后费渠道客户售后费用 年前返利渠道年度返利费用 前返前返 出样补贴渠道客户出样品补贴

小满OKKICRM接口明细

  • 调用接口：/v1/invoices/order/push
  • 接口名称：推送产品到小满产品库
  • 方法：POST

请求参数

字段字段名称类型配置值 order_no订单号string{{FBillNo}} name订单名称string销售订单 company_id客户IDstringmongoQuery 994c52b4-b37a-3b1d-a88b-1ecae9d2bfce findField=content.company_id where= {"content.name":{"$eq":"{{FCustId_FName}}"}} customer_id客户联系人IDstring currency货币string_function case when'{{FSettleCurrId}}' ='PRE001' then 'CNY' else 'USD' end users业绩归属人array users.user_id用户idstringfindCollection find user_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.rate业绩占比string100 users.product_list产品子列表arraydetails users.product_list.product_id产品IDstring_findCollection find product_id from b6fff4b7-68fb-3316-b03c-ae6633c3824c where product_no={{details.FMaterialId_Fnumber}} users.product_list.count产品数量string{{details.FQty}} users.product_list.unit_price产品单价stringfunction ({{details.FAllAmount}}+{{details.FDiscount}})/{{details.FQty}} users.product_list.cost_amount产品金额string_function sum({{details.FAllAmount}}+{{details.FDiscount}}) users.product_list.sku_id产品SKU IDstring users.product_list.物流费物流费string{{details.物流费}} users.product_list.Q1返利Q1返利string{{details.Q1返利}} users.product_list.Q2返利Q2返利string{{details.Q2返利}} users.product_list.Q3返利Q3返利string{{details.Q3返利}} users.product_list.Q4返利Q4返利string{{details.Q4返利}} users.product_list.售后费售后费string{{details.售后费}} users.product_list.年度返利年度返利string{{details.年度返利}} users.product_list.前返前返string{{details.前返}} users.product_list.出样补贴出样补贴string{{{{details.出样补贴}} users.product_list.customer_name联系人名称string{{contact_linkman}} users.product_list.customer_phone联系人电话string{{contact_phone}} users.product_list.exchange_rate折现人民币汇率stringfunction {{FExchangeRate}} * (100) users.product_list.exchange_rate_usd汇率美元string_function CASE LOCATE('USD','{{currencyid_number}}') WHEN 0 THEN '{{new_exchange_rate}}' ELSE '100' END users.product_list.remark备注string{{remark}} users.product_list.account_date订单日期，YYYY-mm-ddstring{{billdate date}} users.product_list.cost_list费用列表array users.product_list.cost_list.cost_name费用名称string{{物流费}} users.product_list.cost_list.percent_type计算规则0（加（+）绝对值、1加（+）占产品总金额百分比、2减（-）绝对值、3减（-）占产品总金额百分比）string users.product_list.cost_list.percent_amount计算金额值，比如1%，那就是产品金额*1%string{{物流费}} users.product_list.cost_list.cost金额，根据计算金额计算出来后的费用string{{物流费}} users.product_list.cost_list.users_info业绩归属人信息列表array users.product_list.cost_list.users_info.user_id业绩归属人idstringfindCollection find user_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.product_list.cost_list.users_info.rate业绩占比string100 users.product_list.cost_list.users_info.nickname业绩归属人昵称string_findCollection find full_name from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.product_list.cost_list.users_info.handler_infohandler_infoarray users.product_list.cost_list.users_info.handler_info.user_id业绩归属人idstringfindCollection find user_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.product_list.cost_list.users_info.handler_info.rate业绩占比string100 users.product_list.cost_list.users_info.handler_info.nickname业绩归属人昵称string{{FSalerId_FName}} users.product_list.cost_list.users_info.handler_info.departments业绩归属部门信息列表array users.product_list.cost_list.users_info.handler_info.departments.department_id业绩归属部门idstring_findCollection find departments.0.department_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where departments.0.department_name={{FSaleDeptId_FName}} users.product_list.cost_list.users_info.handler_info.departments.rate业绩占比string100 users.product_list.cost_list.users_info.handler_info.departments.name业绩归属部门名称string{{FSaleDeptId_FName}} users.product_list.cost_list.users_info.handler_info.departments.handler处理人string_findCollection find user_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.product_list.cost_list.users_info.handler_info.departments.产品折扣费产品折扣费string{{F_hesh_Discount}} users.product_list.cost_list.users_info.handler_info.departments.5094664372713金蝶更新标识string未更新

响应参数

字段字段名称类型配置值 primaryWritebackprimaryWritebackobject primaryWriteback.IdIdstring{{data.order_id}} primaryWriteback.callBackStrategy回写方案object primaryWriteback.callBackStrategy.strategyId方案IDstring941a324d-aa39-3fcb-888b-2d9f6ce7df8f primaryWriteback.callBackStrategy.order_no单据号string{{FBillNo}}

数据对接效果

从API层面解决企业烟囱式业务系统集成现状,实现深度的业务流程拉通金蝶云星空到小满OKKICRM之间数据集成；通过API连接各业务系统，复用已有的业务系统能力，让集成架构、服务关系更清晰。使用统一的API管理平台，对API进行显性化、可视化，使所有API服务成为企业的数字资产，提升复用率和价值。全面管控企业的API资产，梳理现有业务系统的API。实现API文档的统一管理，建立API的上线、下线、监控的统一管理体系及标准规范。已链接和打通主流SaaS系统超过100+，快速对接各种API接口，实现云上云下的互联互通。将SaaS和本地业务系统联接起来，打破时间与空间界限，打通原有核心数据及SaaS应用，构建可平滑演进的企业IT架构。
用友ERP对接
企业微信与ERP对接
ERP打通OA

论坛热帖