金蝶云星空与MySQL对接集成逐个单据查询打通EXECUTE语句

接入系统：金蝶云星空

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

接通系统：MySQL

MySQL是最流行的数据库之一，是一个免费开源的关系型数据库管理系统，但也不意味着该数据库是完全免费的。MySQL由瑞典MySQLAB公司开发，目前属于Oracle公司。MySQL适合中小型软件，被个人用户以及中小企业青睐。

系统对接接口配置

轻易云集成平台的对接是通过一个个对应的对接方案去形成两个系统对接的连线，所以对接方案的配置极其重要，方案可以选择一键复制，轻易云有海量的对接方案可支持一键复制，复制后直接启动使用（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息。或者可以通过手工配置，配置只要确认源平台：金蝶云星空的取数逻辑，例如什么时间取什么样的数据。即可完成配置，目标平台：MySQL，把获取的数据组装成目标系统需要的格式进行写入。

金蝶云星空接口明细

API：ExecuteBillQuery
NAME：逐个单据查询
METHOD：POST

请求参数

接口字段名称预设值 Limit最大行数{{PAGINATION_PAGE_SIZE}} StartRow开始行索引{{PAGINATION_START_ROW}} TopRowCount返回总行数 FilterString过滤条件 FieldKeys需查询的字段key集合 FormId业务对象表单IdSAL_OUTSTOCK

响应参数

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

MySQL接口明细

API：insert
NAME：EXECUTE语句
METHOD：POST

请求参数

接口字段名称预设值 main_params主表参数-sl_sale_order main_params.id主键{{Id}} main_params.code单据编号{{BillNo}} main_params.create_time创建日期{{Date date}} main_params.provider_id供应商id{{CustomerID_Id}} main_params.extend_params_1扩展表参数-sale_order_itemSAL_OUTSTOCKENTRY main_params.extend_params_1.id主键{{SAL_OUTSTOCKENTRY.Id}} main_params.extend_params_1.sale_order_id销售订单ID{{Id}} main_params.extend_params_1.number数量{{SAL_OUTSTOCKENTRY.RealQty}} main_params.extend_params_1.price价格{{SAL_OUTSTOCKENTRY.Price}} main_params.extend_params_1.product_code产品编码{{SAL_OUTSTOCKENTRY.MaterialID_Number}} main_params.extend_params_1.extend_params_2扩展表参数-ph_provider main_params.extend_params_1.extend_params_2.id主键{{CustomerID_Id}} main_params.extend_params_1.extend_params_2.code编码{{CustomerID_Number}} main_params.extend_params_1.extend_params_2.main_sql主SQL语句-sl_sale_orderINSERT INTO sl_sale_order (id,code,create_time,provider_id) values ( :id,:code,:create_time,:provider_id) main_params.extend_params_1.extend_params_2.extend_sql_1扩展SQL语句1-sale_order_itemINSERT INTO sale_order_item (id,sale_order_id,number,price,product_code) values ( :id,:sale_order_id,:number,:price,:product_code) main_params.extend_params_1.extend_params_2.extend_sql_2扩展SQL语句2-ph_providerINSERT INTO ph_provider (id,code) values ( :id,:code)

系统对接总览

通过无代码的数据集成与数据建模的智能数据管道技术，帮助企业将所有应用程序、数据库、事件和文件等数据信息提取到数据仓库中，并快速将分散的数据转化为数据集、API、自动化流程等开箱即用的数据服务。配置接口的模式对接金蝶云星空和MySQL，使得单据无缝互通。打造企业内部数据一体化，让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通，同时支持供应链数据分析流程自动化，结果推送，推进相关供应链问题优化。及时打通供应链孤岛，实现数据驱动供应链协同，进一步提升企业竞争力。

金蝶云星空与MySQL对接集成逐个单据查询打通EXECUTE语句