金蝶云星空与小满OKKICRM对接集成销售订单查询打通回款单数据更新

对接系统：金蝶云星空

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

接入系统：小满OKKICRM

深圳市小满科技有限公司（简称：小满科技）成立于2013年3月，公司位于深圳市南山区高新园区，是一家国家级高新技术企业。公司旗下产品OKKICRM聚焦外贸客户管理与销售管理，帮助企业实现从线索到订单的全生命周期管理。

系统对接接口配置

集成方案是整个轻易云集成平台的核心，每一个集成方案代表一种业务的对接策略（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息），用户可以根据业务的不同新建多个不同规则的集成方案。比如：采购订单同步，线上销售出库同步，线下销售出库同步。一个集成方案必须要配置源系统：金蝶云星空，源系统 API：销售订单查询，目标系统：小满OKKICRM，目标系统 API回款单数据更新。在新增集成方案之前需要确定两个系统的连接器都已经配置完成。数据管道ETL：构建一体化的数据融合平台。高级数据转换：支持公式转换数据格式、支持脚本直接进行数据转换、支持可视化多维度数据处理。高性能实时处理：针对不同数据节点类型提供TB级吞吐量，秒级延迟的增量数据处理能力。自动将旧版web服务转变为基于云端微服务的API，统一接口输出标准。支持接口开放服务，实现内外部能力接入。

金蝶云星空接口明细

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') FieldKeys需查询的字段key集合 FormId业务对象表单IdSAL_SaleOrder

响应参数

接口字段名称预设值 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}}

系统数据对接

基于轻易云的连接器和数据服务能力，轻松实现供应链异构系统的“相互沟通”，通过数据应用自动化业务流程管理，全面管控供应链的每一环节。从要货、销售出库、退货入库、到盘点、调拨，无需人工参与，实时更新，自动化流转。通过快速连接金蝶云星空接口抽取数据后再自动分发到小满OKKICRM，解放生产力，自动生成数据、并分发推送到业务应用，数据传递时效性提升10倍以上。

金蝶云星空与小满OKKICRM对接集成销售订单查询打通回款单数据更新