轻易云
注册体验

金蝶云星空与小满OKKICRM对接集成销售订单查询连通回款单数据更新(金蝶销售订单(审核后变更)对接小满销售订单(覆盖)-P)

1 条评论

金蝶云星空与小满OKKICRM对接集成销售订单查询连通回款单数据更新(金蝶销售订单(审核后变更)对接小满销售订单(覆盖)-P)

接口数据集成

对接源平台:金蝶云星空

金蝶K/3Cloud结合当今先进管理理论和数十万家国内客户最佳应用实践,面向事业部制、多地点、多工厂等运营协同与管控型企业及集团公司,提供一个通用的ERP服务平台。K/3Cloud支持的协同应用包括但不限于:集中/分散销售、集中/分散采购、B2B电商管理、B2C电商中心、供应商协同、多工厂计划、跨工厂领料、跨工厂加工、工厂间调拨、内部交易及结算、集团财务管理、阿米巴经营等。

目标系统:小满OKKICRM

小满科技一直以“人工智能+大数据”为核心驱动力,并融入多年深耕CRM行业的经验,为外贸客户提供多场景的解决方案。凭借卓越的服务水准,小满科技先后斩获“年度最佳外贸SaaS服务商”、“2019杰出品牌形象奖”、“2020最佳企业服务平台”、“2020影响未来的产品GREAT100”、“2020最具商业价值品牌等诸多大奖,并于2020年8月获得阿里巴巴D轮融资,行业领先地位不断夯实。

数据接口配置方案

数据集成平台对应的配置金蝶云星空与小满OKKICRM的对接只要三步就能完成两个系统之间的数据对接。第一步根据金蝶云星空的接口参数要求记录在轻易云集成平台。第二步配置金蝶云星空与小满OKKICRM之间的字段对应关系(更多方案可借鉴轻易云数据集成社区论坛中找到相关方案信息)第三步完成方案的检查参数设置:传递时间、重试次数、是否启动、前置条件等上线运行。
用友接口集成

金蝶云星空接口明细

  • 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 FVersionNo版本号FVersionNo Limit最大行数{{PAGINATION_PAGE_SIZE}}金蝶的查询分页参数 StartRow开始行索引{{PAGINATION_START_ROW}}金蝶的查询分页参数 TopRowCount返回总行数金蝶的查询分页参数 FilterString过滤条件FBillTypeID.Fnumber='XSDD01_SYS' and FChangeDate>='{{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 FVersionNo版本号FVersionNo 物流费渠道物料费用 Q1返利渠道第一季度返利费用 Q2返利渠道第二季度返利费用 Q3返利渠道第三季度返利费用 Q4返利渠道第四季度返利费用 售后费渠道客户售后费用 年度返利渠道年度返利费用 前返前返 出样补贴渠道客户出样品补贴

小满OKKICRM接口明细

  • API:/v1/invoices/order/push
  • NAME:回款单数据更新
  • METHOD:POST

请求参数

接口字段字段名称预设值描述 order_no订单号{{FBillNo}} name订单名称销售订单-变更{{FVersionNo}} company_id客户IDmongoQuery 994c52b4-b37a-3b1d-a88b-1ecae9d2bfce findField=content.company_id where= {"content.name":{"$eq":"{{FCustId_FName}}"}} customer_id客户联系人ID currency货币_function case when'{{FSettleCurrId}}' ='PRE001' then 'CNY' else 'USD' end users业绩归属人 users.user_id用户idfindCollection find user_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.rate业绩占比100 users.product_list产品子列表details users.product_list.product_id产品ID_findCollection find product_id from b6fff4b7-68fb-3316-b03c-ae6633c3824c where product_no={{details.FMaterialId_Fnumber}} users.product_list.count产品数量{{details.FQty}} users.product_list.unit_price产品单价function ({{details.FAllAmount}}+{{details.FDiscount}})/{{details.FQty}} users.product_list.cost_amount产品金额_function sum({{details.FAllAmount}}+{{details.FDiscount}}) users.product_list.sku_id产品SKU ID users.product_list.物流费物流费{{details.物流费}} users.product_list.Q1返利Q1返利{{details.Q1返利}} users.product_list.Q2返利Q2返利{{details.Q2返利}} users.product_list.Q3返利Q3返利{{details.Q3返利}} users.product_list.Q4返利Q4返利{{details.Q4返利}} users.product_list.售后费售后费{{details.售后费}} users.product_list.年度返利年度返利{{details.年度返利}} users.product_list.前返前返{{details.前返}} users.product_list.出样补贴出样补贴{{details.出样补贴}} users.product_list.customer_name联系人名称{{contact_linkman}} users.product_list.customer_phone联系人电话{{contact_phone}} users.product_list.exchange_rate折现人民币汇率function {{FExchangeRate}} * (100) users.product_list.exchange_rate_usd汇率美元_function CASE LOCATE('USD','{{currencyid_number}}') WHEN 0 THEN '{{new_exchange_rate}}' ELSE '100' END users.product_list.remark备注{{remark}} users.product_list.account_date订单日期,YYYY-mm-dd{{billdate date}} users.product_list.cost_list费用列表 users.product_list.cost_list.cost_name费用名称{{物流费}} users.product_list.cost_list.percent_type计算规则0(加(+)绝对值、1加(+)占产品总金额百分比、2减(-)绝对值、3减(-)占产品总金额百分比) users.product_list.cost_list.percent_amount计算金额值,比如1%,那就是产品金额*1%{{物流费}} users.product_list.cost_list.cost金额,根据计算金额计算出来后的费用{{物流费}} users.product_list.cost_list.users_info业绩归属人信息列表 users.product_list.cost_list.users_info.user_id业绩归属人idfindCollection find user_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.product_list.cost_list.users_info.rate业绩占比100 users.product_list.cost_list.users_info.nickname业绩归属人昵称_findCollection find full_name from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.product_list.cost_list.users_info.handler_infohandler_info users.product_list.cost_list.users_info.handler_info.user_id业绩归属人idfindCollection find user_id from 7d2d5073-0558-377d-ac2b-280fc6a8a21b where full_name={{FSalerId_FName}} users.product_list.cost_list.users_info.handler_info.rate业绩占比100 users.product_list.cost_list.users_info.handler_info.nickname业绩归属人昵称{{FSalerId_FName}} users.product_list.cost_list.users_info.handler_info.departments业绩归属部门信息列表 users.product_list.cost_list.users_info.handler_info.departments.department_id业绩归属部门id_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业绩占比100 users.product_list.cost_list.users_info.handler_info.departments.name业绩归属部门名称{{FSaleDeptId_FName}} users.product_list.cost_list.users_info.handler_info.departments.handler处理人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.产品折扣费产品折扣费{{F_hesh_Discount}} users.product_list.cost_list.users_info.handler_info.departments.5094664372713金蝶标识状态已更新 users.product_list.cost_list.users_info.handler_info.departments.order_id订单ID_findCollection find order_id from 2ff05b19-ef15-3f03-8c2e-cdaef545bdf9 where order_no={{FBillNo}}

响应参数

接口字段字段名称预设值描述 primaryWritebackprimaryWriteback primaryWriteback.IdId{{data.order_id}} primaryWriteback.callBackStrategy回写方案 primaryWriteback.callBackStrategy.strategyId方案ID941a324d-aa39-3fcb-888b-2d9f6ce7df8f primaryWriteback.callBackStrategy.order_no单据号{{FBillNo}}

系统集成总览

从API服务总线层面解决企业烟囱式业务系统集成现状 相互连接企业各业务系统,实现流程端到端打通,复用已有的业务系统能力,让集成架构、服务关系更清晰 使用统一的API管理平台,对API进行显性化、可视化,使所有API服务成为企业的数字资产,提升API利用率,发挥业务系统价值,实现企业IT资产的可插拔、可复用、可组成。
金蝶云星空对接