金蝶云星空与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	业务对象表单Id	SAL_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_Id	BOM版本Id
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BomID_Name	BOM版本_名称
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BomID_Number	BOM版本编码
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.B2CORDERDETAILID	B2C订单明细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.BOMEntryId	BOM分录内码
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_item	SAL_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_order	INSERT 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_item	INSERT 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_provider	INSERT INTO ph_provider (id,code) values ( :id,:code)

系统对接总览

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