MySQL和金蝶云星空单据接口对接

对接系统：金蝶云星空

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

集成系统:MySQL

mysql是一个关系数据库管理系统（RDBMS），所谓的关系型数据库，是建立在关系模型基础上的数据库，借助于集合代数等数学概念和方法来处理数据库中的数据。

配置集成方案

异构系统具有非常丰富的业务流程、复杂的系统架构和服务接口。在很多情况下，这两个系统都是分别独立部署和运行的，各自拥有不同的技术栈和编程模型，甚至两者在系统平台、技术平台和编程语言上是完全异构的。那么对接就需要根据接口配置对应的规则，例如取数就要根据查询接口获取金蝶云星空的数据，并且根据对应的条件进行取数，目标系统就必须根据目标系统的格式，以及获取的数据进行加工处理后进行写入到MySQL中。轻易云集成平台的可视化配置轻松实现。

金蝶云星空接口明细

接口：ExecuteBillQuery
接口名称：逐个单据查询
接口方法：POST

请求参数

字段名称类型描述 Limit最大行数string金蝶的查询分页参数 StartRow开始行索引string金蝶的查询分页参数 TopRowCount返回总行数int金蝶的查询分页参数 FilterString过滤条件string示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>= FieldKeys需查询的字段key集合array金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber FormId业务对象表单Idstring必须填写金蝶的表单ID如😛UR_PurchaseOrder

响应参数

字段名称类型描述 BillNo单据编号string DocumentStatus单据状态string SaleOrgId_Id销售组织Idstring SaleOrgId_Name销售组织_名称string SaleOrgId_Number销售组织编码string Date日期string StockOrgId_Id发货组织_Idstring StockOrgId_Name发货组织名称string StockOrgId_Number发货组织_编码string CustomerID_Id客户Idstring CustomerID_Name客户_名称string CustomerID_Number客户编码string DeliveryDeptID_Id发货部门_Idstring DeliveryDeptID_Name发货部门名称string DeliveryDeptID_Number发货部门_编码string SaleDeptID_Id销售部门Idstring SaleDeptID_Name销售部门_名称string SaleDeptID_Number销售部门编码string StockerGroupID_Id库存组_Idstring StockerGroupID_Name库存组名称string StockerGroupID_Number库存组_编码string StockerID_Id仓管员Idstring StockerID_Name仓管员_名称string StockerID_Number仓管员编码string SalesGroupID_Id销售组_Idstring SalesGroupID_Name销售组名称string SalesGroupID_Number销售组_编码string SalesManID_Id销售员Idstring SalesManID_Name销售员_名称string SalesManID_Number销售员编码string CarrierID_Id承运商_Idstring CarrierID_Name承运商名称string CarrierID_Number承运商_编码string CarriageNO运输单号string ReceiverID_Id收货方Idstring ReceiverID_Name收货方_名称string ReceiverID_Number收货方编码string SettleID_Id结算方_Idstring SettleID_Name结算方名称string SettleID_Number结算方_编码string PayerID_Id付款方Idstring PayerID_Name付款方_名称string PayerID_Number付款方编码string FCreateDate创建日期string FModifierId_Id最后修改人_Idstring FModifierId_Name最后修改人名称string FModifierId_Number最后修改人_编码string FModifyDate最后修改日期string FCreatorId_Id创建人Idstring FCreatorId_Name创建人_名称string FCreatorId_Number创建人编码string ApproverID_Id审核人_Idstring ApproverID_Name审核人名称string ApproverID_Number审核人_编码string ApproveDate审核日期string CancelStatus作废状态string CancellerID_Id作废人Idstring CancellerID_Name作废人_名称string CancellerID_Number作废人编码string CancelDate作废日期string BillTypeID单据类型string OwnerTypeIdHead货主类型string OwnerIdHead货主string BussinessType业务类型string ReceiveAddress收货方地址string HeadLocationId_Id交货地点_Idstring HeadLocationId_Name交货地点名称string HeadLocationId_Number交货地点_编码string CreditCheckResult信用检查结果string TransferBizType_Id跨组织业务类型Idstring TransferBizType_Name跨组织业务类型_名称string TransferBizType_Number跨组织业务类型编码string CorrespondOrgId_Id对应组织_Idstring CorrespondOrgId_Name对应组织名称string CorrespondOrgId_Number对应组织_编码string ReceiverContactID_Id收货方联系人Idstring ReceiverContactID_Name收货方联系人_名称string ReceiverContactID_Number收货方联系人编码string IsInterLegalPerson组织间结算跨法人标识string FGenFromPOS_CMK零售单日结生成string FLinkPhone联系电话string FLinkMan收货人姓名string FBranchId_Id销售门店_Idstring FBranchId_Name销售门店名称string FBranchId_Number销售门店_编码string PlanRecAddress交货明细执行地址(后台用)string IsTotalServiceOrCost整单服务或费用string Note备注string DisassemblyFlag拆单新单标识string FSHOPNUMBER网店编码string FGYDATE管易发货日期string FSALECHANNEL销售渠道string LogisticsNos物流单号string F_lyzx_Base_Id收货中心Idstring F_lyzx_Base_Name收货中心_名称string F_lyzx_Base_Number收货中心编码string SAL_OUTSTOCKFIN财务信息object SAL_OUTSTOCKFIN.SettleOrgID_Id结算组织_Idstring SAL_OUTSTOCKFIN.SettleOrgID_Name结算组织名称string SAL_OUTSTOCKFIN.SettleOrgID_Number结算组织_编码string SAL_OUTSTOCKFIN.LocalCurrID_Id本位币Idstring SAL_OUTSTOCKFIN.LocalCurrID_Name本位币_名称string SAL_OUTSTOCKFIN.LocalCurrID_Number本位币编码string SAL_OUTSTOCKFIN.ExchangeTypeID_Id汇率类型_Idstring SAL_OUTSTOCKFIN.ExchangeTypeID_Name汇率类型名称string SAL_OUTSTOCKFIN.ExchangeTypeID_Number汇率类型_编码string SAL_OUTSTOCKFIN.ExchangeRate汇率string SAL_OUTSTOCKFIN.SettleCurrID_Id结算币别Idstring SAL_OUTSTOCKFIN.SettleCurrID_Name结算币别_名称string SAL_OUTSTOCKFIN.SettleCurrID_Number结算币别编码string SAL_OUTSTOCKFIN.SettleTypeID_Id结算方式_Idstring SAL_OUTSTOCKFIN.SettleTypeID_Name结算方式名称string SAL_OUTSTOCKFIN.SettleTypeID_Number结算方式_编码string SAL_OUTSTOCKFIN.BilCostlAmount总成本(暂未使用)string SAL_OUTSTOCKFIN.BillCostAmount_LC总成本(本位币)(暂未使用)string SAL_OUTSTOCKFIN.ReceiptConditionID_Id收款条件Idstring SAL_OUTSTOCKFIN.ReceiptConditionID_Name收款条件_名称string SAL_OUTSTOCKFIN.ReceiptConditionID_Number收款条件编码string SAL_OUTSTOCKFIN.BillAmount_LC金额（本位币）string SAL_OUTSTOCKFIN.BillAllAmount_LC价税合计（本位币）string SAL_OUTSTOCKFIN.BillTaxAmount_LC税额（本位币）string SAL_OUTSTOCKFIN.PriceListId_Id价目表_Idstring SAL_OUTSTOCKFIN.PriceListId_Name价目表名称string SAL_OUTSTOCKFIN.PriceListId_Number价目表_编码string SAL_OUTSTOCKFIN.BillTaxAmount税额string SAL_OUTSTOCKFIN.BillAllAmount价税合计string SAL_OUTSTOCKFIN.BillAmount金额string SAL_OUTSTOCKFIN.IsIncludedTax是否含税string SAL_OUTSTOCKFIN.ISGENFORIOS跨组织结算生成string SAL_OUTSTOCKFIN.SETTLECustomerID_Id结算组织客户Idstring SAL_OUTSTOCKFIN.SETTLECustomerID_Name结算组织客户_名称string SAL_OUTSTOCKFIN.SETTLECustomerID_Number结算组织客户编码string SAL_OUTSTOCKFIN.OwnerSupplierID_Id货主供应商_Idstring SAL_OUTSTOCKFIN.OwnerSupplierID_Name货主供应商名称string SAL_OUTSTOCKFIN.OwnerSupplierID_Number货主供应商_编码string SAL_OUTSTOCKFIN.DiscountListId_Id折扣表Idstring SAL_OUTSTOCKFIN.DiscountListId_Name折扣表_名称string SAL_OUTSTOCKFIN.DiscountListId_Number折扣表编码string SAL_OUTSTOCKFIN.CreChkDays工作流信用超标天数string SAL_OUTSTOCKFIN.CreChkStatus工作流信用检查状态string SAL_OUTSTOCKFIN.CreChkAmount工作流信用超标金额string SAL_OUTSTOCKFIN.CrePreBatAndMonStatus审批流信用压批月结检查string SAL_OUTSTOCKFIN.CrePreBatchOver信用压批超标string SAL_OUTSTOCKFIN.CreMonControlOver信用月结超标string SAL_OUTSTOCKFIN.IsPriceExcludeTax价外税string SAL_OUTSTOCKFIN.FThirdBillNo第三方单据编号string SAL_OUTSTOCKFIN.FThirdBillId第三方单据平台单号string SAL_OUTSTOCKFIN.FThirdSrcType第三方系统来源string SAL_OUTSTOCKFIN.CreChkOverAmount工作流信用逾期超标额度string SAL_OUTSTOCKFIN.FBuyerNick会员名称string SAL_OUTSTOCKFIN.FReceiverName收货人string SAL_OUTSTOCKFIN.FReceiverMobile收货人手机string SAL_OUTSTOCKFIN.FReceiverCountry收货人国家string SAL_OUTSTOCKFIN.FReceiverState收货人省份string SAL_OUTSTOCKFIN.FReceiverCity收货人城市string SAL_OUTSTOCKFIN.FReceiverDistrict收货人地区string SAL_OUTSTOCKFIN.FReceiverAddress收货人地址string SAL_OUTSTOCKFIN.FReceiverPhone收货人电话string SAL_OUTSTOCKFIN.ReceivaDate应收单业务日期string SAL_OUTSTOCKFIN.FVIPCODE会员编码string SAL_OUTSTOCKFIN.AllDisCount整单折扣额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY明细信息array SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CustMatID_Id客户物料编码_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CustMatID_Name客户物料编码名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CustMatID_Number客户物料编码_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MaterialID_Id物料编码Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MaterialID_Name物料编码_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MaterialID_Number物料编码编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.UnitID_Id库存单位_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.UnitID_Name库存单位名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.UnitID_Number库存单位_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MustQty应发数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.RealQty实发数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockID_Id仓库Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockID_Name仓库_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockID_Number仓库编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockStatusID_Id库存状态_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockStatusID_Name库存状态名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockStatusID_Number库存状态_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.OwnerTypeID货主类型string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.OwnerID货主string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.KeeperTypeID保管者类型string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.KeeperID保管者string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Note备注string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BomID_IdBOM版本Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BomID_NameBOM版本_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BomID_NumberBOM版本编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseUnitQty库存基本数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AuxUnitID_Id库存辅单位_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AuxUnitID_Name库存辅单位名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AuxUnitID_Number库存辅单位_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AuxUnitQty库存辅单位数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CostPrice成本价（本位币）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CostAmount总成本string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CostAmount_LC总成本(本位币)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ReturnQty关联退货数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SumRetNoticeQty累计退货通知数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SumRetStockQty累计退货数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.InvoicedQty累计开票数量(作废)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SumInvoicedQty累计应收数量（销售）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SumInvoicedAMT累计开票金额(作废)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SumReceivedAMT累计收款金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseReturnQty关联退货数量(基本单位)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseInvoicedQty关联开票数量(基本单位)(作废)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockFlag库存更新标识string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SoorDerno订单单号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseSumRetNoticeQty累计退货通知数量(销售基本)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SrcType源单类型string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseSumRetstockQty累计退货数量(基本单位)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ProduceDate生产日期string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ExpiryDate有效期至string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.JoinedQty勾稽数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.UnJoinQty未勾稽数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.JoinedAmount勾稽金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.UnJoinAmount未勾稽金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FullyJoined完全勾稽string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.JoinStatus行勾稽状态string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Lot_Id批号Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Lot_Name批号_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Lot_Number批号编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.IsFree是否赠品string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseSumInvoicedQty累计开票数量(计价基本)(作废)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseMustQty基本单位应发数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseUnitID_Id基本单位_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseUnitID_Name基本单位名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseUnitID_Number基本单位_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ArrivalStatus到货确认string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ArrivalConfirmor_Id到货确认人Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ArrivalConfirmor_Name到货确认人_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ArrivalConfirmor_Number到货确认人编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ValidateDate检验日期string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ValidateStatus检验确认string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ValidateConfirmor_Id检验确认人_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ValidateConfirmor_Name检验确认人名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ValidateConfirmor_Number检验确认人_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceUnitId_Id计价单位Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceUnitId_Name计价单位_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceUnitId_Number计价单位编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceUnitQty计价数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Price单价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxPrice含税单价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxCombination_Id税组合_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxCombination_Name税组合名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxCombination_Number税组合_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxRate税率%string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceCoefficient价格系数string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SysPrice系统定价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.LimitDownPrice最低限价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BefDisAmt折前金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BefDisAllAmt折前价税合计string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.DiscountRate折扣率%string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Discount折扣额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Amount金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.Amount_LC金额（本位币）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxAmount税额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxAmount_LC税额（本位币）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AllAmount价税合计string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AllAmount_LC价税合计（本位币）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TaxNetPrice净价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FBaseARJoinQty关联应收数量（计价基本）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ArrivalDate到货日期string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FBFLowId业务流程string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BASEARQTY累计应收数量（销售基本）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ARJOINAMOUNT关联应收金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ARAMOUNT累计应收金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SalCostPrice销售成本价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SrcBillNo源单编号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ActQty实收数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseJoinInStockQty关联入库数量(基本单位)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.JoinInStockQty关联入库数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SNUnitID_Id序列号单位Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SNUnitID_Name序列号单位_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SNUnitID_Number序列号单位编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SNQty序列号单位数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MTONO计划跟踪号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ProjectNo项目编号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.RefuseQty拒收数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.RepairQty补货数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.IsRepair是否补货string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SECJOININSTOCKQTY关联入库数量（辅单位）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SECRETURNQTY关联退货数量（辅单位）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.IsConsumeSum消耗汇总string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ARJoinQty关联应收数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.OUTCONTROL控制出库数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ExtAuxUnitId_Id辅单位_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ExtAuxUnitId_Name辅单位名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ExtAuxUnitId_Number辅单位_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ExtAuxUnitQty实发数量(辅单位)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FBarcode零售条形码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FProPrice门店供货价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FProAmount供货金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FRetailSaleProm是否零售促销string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SalUnitId_Id销售单位Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SalUnitId_Name销售单位_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SalUnitId_Number销售单位编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SALUNITQTY销售数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SALBASEQTY销售基本数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PRICEBASEQTY计价基本数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.QualifyType质量类型string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SalBaseNum销售基本分子string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockBaseDen库存基本分母string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockBaseReturnQty关联退货数量（库存基本）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockBaseSumRetStockQty累计退货数量（库存基本）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockBaseARJoinQty关联应收数量（库存基本）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SRCBIZUNITID_Id携带的主业务单位_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SRCBIZUNITID_Name携带的主业务单位名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SRCBIZUNITID_Number携带的主业务单位_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.IsCreateProDoc是否生成产品档案string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.EOwnerSupplierId_Id明细货主供应商Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.EOwnerSupplierId_Name明细货主供应商_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.EOwnerSupplierId_Number明细货主供应商编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.IsOverLegalOrg组织间结算跨法人标识string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ESettleCustomerId_Id明细结算组织客户_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ESettleCustomerId_Name明细结算组织客户名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ESettleCustomerId_Number明细结算组织客户_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SalBaseARJoinQty关联应收数量（销售基本）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PURBASEJOININSTOCKQTY关联入库数量（采购基本）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceListEntry_Id行价目表Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceListEntry_Name行价目表_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceListEntry_Number行价目表编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ARNOTJOINQTY未关联应收数量（计价单位）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.QmEntryID库存请检单EntryIDstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ConvertEntryID库存状态转换单ENTRYIDstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.B2CORDERDETAILIDB2C订单明细Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SOEntryId销售订单EntryIdstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ReserveEntryId预留锁库EntryIdstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.RowType产品类型string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ParentMatId_Id父项产品_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ParentMatId_Name父项产品名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ParentMatId_Number父项产品_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.RowId行标识string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ParentRowId父行标识string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SignQty签收数量string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ThirdEntryId管易订单单号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CheckDelivery发货检验string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FETHIRDBILLID第三方单据IDstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FETHIRDBILLNO第三方单据编号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FGYFINSTATUS管易是否到账string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.FGYFINDate管易到账时间string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceDiscount单价折扣string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.TailDiffFlag尾差处理标识string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.WRITEOFFPRICEBASEQTY冲销数量(计价基本)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.WRITEOFFSALEBASEQTY冲销数量(销售基本)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.WRITEOFFSTOCKBASEQTY冲销数量(库存基本)string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.WRITEOFFAMOUNT冲销金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SettleBySon按子项结算string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BOMEntryIdBOM分录内码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AllAmountExceptDisCount价税合计（折前）string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.F_lyzx_Text客户订单号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.F_lyzx_Price订单纸面单价string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.F_lyzx_Integer已报关string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.F_lyzx_Text1订单项次string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.F_lyzx_Text2阶段string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.F_lyzx_Text3专案string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.F_lyzx_Text4图号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX税务明细array SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.TaxRateId_Id税率名称Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.TaxRateId_Name税率名称_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.TaxRateId_Number税率名称编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.TaxRate税率%string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.TaxAmount税额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.CostPercent计入成本比例%string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.CostAmount计入成本金额string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.VAT增值税string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SellerWithholding卖方代扣代缴string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.BuyerWithholding买方代扣代缴string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial序列号子单据体array SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.SerialNo序列号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.SerialId_Id序列号_Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.SerialId_Name序列号名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.SerialId_Number序列号_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.SerialNote备注string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.PushReturnNotice下推退货通知标识string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace物流跟踪明细array SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.LogComId_Id物流公司Idstring SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.LogComId_Name物流公司_名称string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.LogComId_Number物流公司_编码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.CarryBillNo物流单号string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.TraceStatus物流状态string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.DelTime发货时间string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.PhoneNumber寄件人手机号码string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.From起始地点string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.To终止地点string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.ReceiptTime签收时间string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.OutStockTraceDetail物流详细信息array SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.OutStockTraceDetail.TraceTime时间string SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SAL_OUTSTOCKENTRYTAX.SAL_OutStockSerial.OutStockTrace.OutStockTraceDetail.TraceDetail物流详情string

MySQL接口明细

接口：insert
接口名称：EXECUTE语句
接口方法：POST

请求参数

字段名称类型描述 main_params主表参数-sl_sale_orderobject main_params.id主键string main_params.code单据编号string main_params.create_time创建日期string main_params.provider_id供应商idstring main_params.extend_params_1扩展表参数-sale_order_itemarray main_params.extend_params_1.id主键string main_params.extend_params_1.sale_order_id销售订单IDstring main_params.extend_params_1.number数量string main_params.extend_params_1.price价格string main_params.extend_params_1.product_code产品编码string main_params.extend_params_1.extend_params_2扩展表参数-ph_providerarray main_params.extend_params_1.extend_params_2.id主键string main_params.extend_params_1.extend_params_2.code编码string main_params.extend_params_1.extend_params_2.main_sql主SQL语句-sl_sale_orderstring main_params.extend_params_1.extend_params_2.extend_sql_1扩展SQL语句1-sale_order_itemstring main_params.extend_params_1.extend_params_2.extend_sql_2扩展SQL语句2-ph_providerstring

数据对接效果

将传统的统计分析转变为预测分析，从被动分析到主动分析，从非实时分析转变为实时分析，从结构化的数据变成多元化的数据。精准查询数据流同步状况，实时监管队列任务以及数据资产的有序管理。为业务赋能，降本增效，让企业能够更加合理的布局团队；结合业务需求实现与OA，CRM，WMS等系统之间的数据交流与同步，为企业定制自定义的数据管理方案，用技术拓展商业边界，为新业务、新部门提供成长空间。

MySQL和金蝶云星空单据接口对接