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	业务对象表单Id	string	必须填写金蝶的表单ID如😛UR_PurchaseOrder

响应参数

字段	名称	类型
BillNo	单据编号	string
DocumentStatus	单据状态	string
SaleOrgId_Id	销售组织Id	string
SaleOrgId_Name	销售组织_名称	string
SaleOrgId_Number	销售组织编码	string
Date	日期	string
StockOrgId_Id	发货组织_Id	string
StockOrgId_Name	发货组织名称	string
StockOrgId_Number	发货组织_编码	string
CustomerID_Id	客户Id	string
CustomerID_Name	客户_名称	string
CustomerID_Number	客户编码	string
DeliveryDeptID_Id	发货部门_Id	string
DeliveryDeptID_Name	发货部门名称	string
DeliveryDeptID_Number	发货部门_编码	string
SaleDeptID_Id	销售部门Id	string
SaleDeptID_Name	销售部门_名称	string
SaleDeptID_Number	销售部门编码	string
StockerGroupID_Id	库存组_Id	string
StockerGroupID_Name	库存组名称	string
StockerGroupID_Number	库存组_编码	string
StockerID_Id	仓管员Id	string
StockerID_Name	仓管员_名称	string
StockerID_Number	仓管员编码	string
SalesGroupID_Id	销售组_Id	string
SalesGroupID_Name	销售组名称	string
SalesGroupID_Number	销售组_编码	string
SalesManID_Id	销售员Id	string
SalesManID_Name	销售员_名称	string
SalesManID_Number	销售员编码	string
CarrierID_Id	承运商_Id	string
CarrierID_Name	承运商名称	string
CarrierID_Number	承运商_编码	string
CarriageNO	运输单号	string
ReceiverID_Id	收货方Id	string
ReceiverID_Name	收货方_名称	string
ReceiverID_Number	收货方编码	string
SettleID_Id	结算方_Id	string
SettleID_Name	结算方名称	string
SettleID_Number	结算方_编码	string
PayerID_Id	付款方Id	string
PayerID_Name	付款方_名称	string
PayerID_Number	付款方编码	string
FCreateDate	创建日期	string
FModifierId_Id	最后修改人_Id	string
FModifierId_Name	最后修改人名称	string
FModifierId_Number	最后修改人_编码	string
FModifyDate	最后修改日期	string
FCreatorId_Id	创建人Id	string
FCreatorId_Name	创建人_名称	string
FCreatorId_Number	创建人编码	string
ApproverID_Id	审核人_Id	string
ApproverID_Name	审核人名称	string
ApproverID_Number	审核人_编码	string
ApproveDate	审核日期	string
CancelStatus	作废状态	string
CancellerID_Id	作废人Id	string
CancellerID_Name	作废人_名称	string
CancellerID_Number	作废人编码	string
CancelDate	作废日期	string
BillTypeID	单据类型	string
OwnerTypeIdHead	货主类型	string
OwnerIdHead	货主	string
BussinessType	业务类型	string
ReceiveAddress	收货方地址	string
HeadLocationId_Id	交货地点_Id	string
HeadLocationId_Name	交货地点名称	string
HeadLocationId_Number	交货地点_编码	string
CreditCheckResult	信用检查结果	string
TransferBizType_Id	跨组织业务类型Id	string
TransferBizType_Name	跨组织业务类型_名称	string
TransferBizType_Number	跨组织业务类型编码	string
CorrespondOrgId_Id	对应组织_Id	string
CorrespondOrgId_Name	对应组织名称	string
CorrespondOrgId_Number	对应组织_编码	string
ReceiverContactID_Id	收货方联系人Id	string
ReceiverContactID_Name	收货方联系人_名称	string
ReceiverContactID_Number	收货方联系人编码	string
IsInterLegalPerson	组织间结算跨法人标识	string
FGenFromPOS_CMK	零售单日结生成	string
FLinkPhone	联系电话	string
FLinkMan	收货人姓名	string
FBranchId_Id	销售门店_Id	string
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	收货中心Id	string
F_lyzx_Base_Name	收货中心_名称	string
F_lyzx_Base_Number	收货中心编码	string
SAL_OUTSTOCKFIN	财务信息	object
SAL_OUTSTOCKFIN.SettleOrgID_Id	结算组织_Id	string
SAL_OUTSTOCKFIN.SettleOrgID_Name	结算组织名称	string
SAL_OUTSTOCKFIN.SettleOrgID_Number	结算组织_编码	string
SAL_OUTSTOCKFIN.LocalCurrID_Id	本位币Id	string
SAL_OUTSTOCKFIN.LocalCurrID_Name	本位币_名称	string
SAL_OUTSTOCKFIN.LocalCurrID_Number	本位币编码	string
SAL_OUTSTOCKFIN.ExchangeTypeID_Id	汇率类型_Id	string
SAL_OUTSTOCKFIN.ExchangeTypeID_Name	汇率类型名称	string
SAL_OUTSTOCKFIN.ExchangeTypeID_Number	汇率类型_编码	string
SAL_OUTSTOCKFIN.ExchangeRate	汇率	string
SAL_OUTSTOCKFIN.SettleCurrID_Id	结算币别Id	string
SAL_OUTSTOCKFIN.SettleCurrID_Name	结算币别_名称	string
SAL_OUTSTOCKFIN.SettleCurrID_Number	结算币别编码	string
SAL_OUTSTOCKFIN.SettleTypeID_Id	结算方式_Id	string
SAL_OUTSTOCKFIN.SettleTypeID_Name	结算方式名称	string
SAL_OUTSTOCKFIN.SettleTypeID_Number	结算方式_编码	string
SAL_OUTSTOCKFIN.BilCostlAmount	总成本(暂未使用)	string
SAL_OUTSTOCKFIN.BillCostAmount_LC	总成本(本位币)(暂未使用)	string
SAL_OUTSTOCKFIN.ReceiptConditionID_Id	收款条件Id	string
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	价目表_Id	string
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	结算组织客户Id	string
SAL_OUTSTOCKFIN.SETTLECustomerID_Name	结算组织客户_名称	string
SAL_OUTSTOCKFIN.SETTLECustomerID_Number	结算组织客户编码	string
SAL_OUTSTOCKFIN.OwnerSupplierID_Id	货主供应商_Id	string
SAL_OUTSTOCKFIN.OwnerSupplierID_Name	货主供应商名称	string
SAL_OUTSTOCKFIN.OwnerSupplierID_Number	货主供应商_编码	string
SAL_OUTSTOCKFIN.DiscountListId_Id	折扣表Id	string
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	客户物料编码_Id	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CustMatID_Name	客户物料编码名称	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.CustMatID_Number	客户物料编码_编码	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MaterialID_Id	物料编码Id	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MaterialID_Name	物料编码_名称	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.MaterialID_Number	物料编码编码	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.UnitID_Id	库存单位_Id	string
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	仓库Id	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockID_Name	仓库_名称	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockID_Number	仓库编码	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.StockStatusID_Id	库存状态_Id	string
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_Id	BOM版本Id	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BomID_Name	BOM版本_名称	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BomID_Number	BOM版本编码	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.BaseUnitQty	库存基本数量	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.AuxUnitID_Id	库存辅单位_Id	string
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	批号Id	string
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	基本单位_Id	string
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	到货确认人Id	string
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	检验确认人_Id	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ValidateConfirmor_Name	检验确认人名称	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ValidateConfirmor_Number	检验确认人_编码	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.PriceUnitId_Id	计价单位Id	string
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	税组合_Id	string
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	序列号单位Id	string
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	辅单位_Id	string
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	销售单位Id	string
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	携带的主业务单位_Id	string
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	明细货主供应商Id	string
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	明细结算组织客户_Id	string
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	行价目表Id	string
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	库存请检单EntryID	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ConvertEntryID	库存状态转换单ENTRYID	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.B2CORDERDETAILID	B2C订单明细Id	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.SOEntryId	销售订单EntryId	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ReserveEntryId	预留锁库EntryId	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.RowType	产品类型	string
SAL_OUTSTOCKFIN.SAL_OUTSTOCKENTRY.ParentMatId_Id	父项产品_Id	string
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	第三方单据ID	string
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.BOMEntryId	BOM分录内码	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	税率名称Id	string
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	序列号_Id	string
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	物流公司Id	string
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_order	object
main_params.id	主键	string
main_params.code	单据编号	string
main_params.create_time	创建日期	string
main_params.provider_id	供应商id	string
main_params.extend_params_1	扩展表参数-sale_order_item	array
main_params.extend_params_1.id	主键	string
main_params.extend_params_1.sale_order_id	销售订单ID	string
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_provider	array
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_order	string
main_params.extend_params_1.extend_params_2.extend_sql_1	扩展SQL语句1-sale_order_item	string
main_params.extend_params_1.extend_params_2.extend_sql_2	扩展SQL语句2-ph_provider	string

数据对接效果

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