Qeasy Cloud
Get Started

金蝶云星空 委外领料查询_v1 API

Type
WebAPI
Effect
QUERY
API Version
0.1
Adapter
\Adapter\K3Cloud\K3CloudQueryAdapter
Auth Mode
OTHER
Updated At
2021-08-26

委外领料查询_v1

POSTexecuteBillQuery
Factory
{
  "operation": {
    "method": "none"
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1Fentity_FEntryIDFentity_FEntryIDstringFentity_FEntryIDOptionalFentity_FEntryID
2BillNoBillNostringBillNoOptional单据编号
3DocumentStatusDocumentStatusstringDocumentStatusOptional单据状态
4ApproverId_NameApproverId_NamestringApproverId.NameOptional审核人_名称
5ApproverId_NumberApproverId_NumberstringApproverId.NumberOptional审核人_编码
6ApproveDateApproveDatestringApproveDateOptional审核日期
7ModifierId_NameModifierId_NamestringModifierId.NameOptional修改人_名称
8ModifierId_NumberModifierId_NumberstringModifierId.NumberOptional修改人_编码
9CreateDateCreateDatestringCreateDateOptional创建日期
10CreatorId_NameCreatorId_NamestringCreatorId.NameOptional创建人_名称
11CreatorId_NumberCreatorId_NumberstringCreatorId.NumberOptional创建人_编码
12ModifyDateModifyDatestringModifyDateOptional修改日期
13CancelDateCancelDatestringCancelDateOptional作废日期
14CANCELER_NameCANCELER_NamestringCANCELER.NameOptional作废人_名称
15CANCELER_NumberCANCELER_NumberstringCANCELER.NumberOptional作废人_编码
16CancelStatusCancelStatusstringCancelStatusOptional作废状态
17DescriptionDescriptionstringDescriptionOptional备注
18BillTypeBillTypestringBillTypeOptional单据类型
19DateDatestringDateOptional日期
20SubOrgId_NameSubOrgId_NamestringSubOrgId.NameOptional委外组织_名称
21SubOrgId_NumberSubOrgId_NumberstringSubOrgId.NumberOptional委外组织_编码
22SupplierId_NameSupplierId_NamestringSupplierId.NameOptional供应商_名称
23SupplierId_NumberSupplierId_NumberstringSupplierId.NumberOptional供应商_编码
24OwnerTypeIdOwnerTypeIdstringOwnerTypeIdOptional货主类型
25OwnerIdOwnerIdstringOwnerIdOptional货主
26CurrId_NameCurrId_NamestringCurrId.NameOptional本位币_名称
27CurrId_NumberCurrId_NumberstringCurrId.NumberOptional本位币_编码
28StockOrgId_NameStockOrgId_NamestringStockOrgId.NameOptional发料组织_名称
29StockOrgId_NumberStockOrgId_NumberstringStockOrgId.NumberOptional发料组织_编码
30FTransferBizType_NameFTransferBizType_NamestringFTransferBizType.NameOptional跨组织业务类型_名称
31FTransferBizType_NumberFTransferBizType_NumberstringFTransferBizType.NumberOptional跨组织业务类型_编码
32FSTOCKERID_NameFSTOCKERID_NamestringFSTOCKERID.NameOptional仓管员_名称
33FSTOCKERID_NumberFSTOCKERID_NumberstringFSTOCKERID.NumberOptional仓管员_编码
34PickerId_NamePickerId_NamestringPickerId.NameOptional领料人_名称
35PickerId_NumberPickerId_NumberstringPickerId.NumberOptional领料人_编码
36IsCrossTradeIsCrossTradestringIsCrossTradeOptional跨法人交易
37VmiBusinessVmiBusinessstringVmiBusinessOptionalVMI业务
38SourceTypeSourceTypestringSourceTypeOptional倒冲来源
39IsOwnerTInclOrgIsOwnerTInclOrgstringIsOwnerTInclOrgOptional货主含组织
40InventoryDateInventoryDatestringInventoryDateOptional库存刷新日期
41MaterialId_NameMaterialId_NamestringMaterialId.NameOptional物料编码_名称
42MaterialId_NumberMaterialId_NumberstringMaterialId.NumberOptional物料编码_编码
43ProduceDateProduceDatestringProduceDateOptional生产日期
44ExpiryDateExpiryDatestringExpiryDateOptional有效期至
45BomId_NameBomId_NamestringBomId.NameOptionalBOM版本_名称
46BomId_NumberBomId_NumberstringBomId.NumberOptionalBOM版本_编码
47UnitID_NameUnitID_NamestringUnitID.NameOptional单位_名称
48UnitID_NumberUnitID_NumberstringUnitID.NumberOptional单位_编码
49AllowOverQtyAllowOverQtystringAllowOverQtyOptional可超发数量
50SelPrcdReturnQtySelPrcdReturnQtystringSelPrcdReturnQtyOptional退料选单数量
51KeeperTypeIdKeeperTypeIdstringKeeperTypeIdOptional保管者类型
52KeeperIdKeeperIdstringKeeperIdOptional保管者
53StockFlagStockFlagstringStockFlagOptional更新库存标志
54MTONOMTONOstringMTONOOptional计划跟踪号
55ProjectNOProjectNOstringProjectNOOptional项目编号
56StockStatusId_NameStockStatusId_NamestringStockStatusId.NameOptional库存状态_名称
57StockStatusId_NumberStockStatusId_NumberstringStockStatusId.NumberOptional库存状态_编码
58StockID_NameStockID_NamestringStockID.NameOptional仓库_名称
59StockID_NumberStockID_NumberstringStockID.NumberOptional仓库_编码
60OperIDOperIDstringOperIDOptional工序号
61ProcessID_NameProcessID_NamestringProcessID.NameOptional作业_名称
62ProcessID_NumberProcessID_NumberstringProcessID.NumberOptional作业_编码
63PricePricestringPriceOptional成本价
64AmountAmountstringAmountOptional总成本
65SrcBillTypeSrcBillTypestringSrcBillTypeOptional系统源单类型
66FSrcBillNoFSrcBillNostringFSrcBillNoOptional系统源单编号
67SrcInterIdSrcInterIdstringSrcInterIdOptional系统源单内码
68SrcEntryIdSrcEntryIdstringSrcEntryIdOptional系统源单分录内码
69SrcEntrySeqSrcEntrySeqstringSrcEntrySeqOptional系统源单行号
70SubReqIdSubReqIdstringSubReqIdOptional委外订单内码
71SubReqBillNoSubReqBillNostringSubReqBillNoOptional委外订单编号
72SubReqEntryIdSubReqEntryIdstringSubReqEntryIdOptional委外订单分录内码
73SubReqEntrySeqSubReqEntrySeqstringSubReqEntrySeqOptional委外订单行号
74PPbomBillNoPPbomBillNostringPPbomBillNoOptional委外用料清单编号
75PPbomEntryIdPPbomEntryIdstringPPbomEntryIdOptional委外用料清单分录内码
76BaseUnitId_NameBaseUnitId_NamestringBaseUnitId.NameOptional基本单位_名称
77BaseUnitId_NumberBaseUnitId_NumberstringBaseUnitId.NumberOptional基本单位_编码
78BaseAppQtyBaseAppQtystringBaseAppQtyOptional基本单位申请数量
79BaseActualQtyBaseActualQtystringBaseActualQtyOptional基本单位实发数量
80BaseAllowOverQtyBaseAllowOverQtystringBaseAllowOverQtyOptional基本单位可超发数量
81BaseSelPrcdReturnQtyBaseSelPrcdReturnQtystringBaseSelPrcdReturnQtyOptional基本单位退料选单数量
82StockUnitId_NameStockUnitId_NamestringStockUnitId.NameOptional库存单位_名称
83StockUnitId_NumberStockUnitId_NumberstringStockUnitId.NumberOptional库存单位_编码
84StockAppQtyStockAppQtystringStockAppQtyOptional库存单位申请数量
85StockAllowOverQtyStockAllowOverQtystringStockAllowOverQtyOptional库存单位可超发数量
86StockSelPrcdReturnQtyStockSelPrcdReturnQtystringStockSelPrcdReturnQtyOptional库存单位退料选单数量
87SecUnitId_NameSecUnitId_NamestringSecUnitId.NameOptional辅助单位_名称
88SecUnitId_NumberSecUnitId_NumberstringSecUnitId.NumberOptional辅助单位_编码
89SecActualQtySecActualQtystringSecActualQtyOptional辅助单位实发数量
90SecAllowOverQtySecAllowOverQtystringSecAllowOverQtyOptional辅助单位可超发数量
91SecSelPrcdReturnQtySecSelPrcdReturnQtystringSecSelPrcdReturnQtyOptional辅助单位退料选单数量
92AppQtyAppQtystringAppQtyOptional申请数量
93ActualQtyActualQtystringActualQtyOptional实发数量
94Lot_NameLot_NamestringLot.NameOptional批号_名称
95Lot_NumberLot_NumberstringLot.NumberOptional批号_编码
96ParentOwnerTypeIdParentOwnerTypeIdstringParentOwnerTypeIdOptional产品货主类型
97ParentOwnerIdParentOwnerIdstringParentOwnerIdOptional产品货主
98SRCBIZBILLTYPE_NameSRCBIZBILLTYPE_NamestringSRCBIZBILLTYPE.NameOptional业务源单类型_名称
99SRCBIZBILLTYPE_NumberSRCBIZBILLTYPE_NumberstringSRCBIZBILLTYPE.NumberOptional业务源单类型_编码
100SRCBIZBILLNOSRCBIZBILLNOstringSRCBIZBILLNOOptional业务源单编号
101SRCBIZINTERIDSRCBIZINTERIDstringSRCBIZINTERIDOptional业务源单内码
102SRCBIZENTRYIDSRCBIZENTRYIDstringSRCBIZENTRYIDOptional业务源单分录内码
103SRCBIZENTRYSEQSRCBIZENTRYSEQstringSRCBIZENTRYSEQOptional业务源单行号
104PickingStatusPickingStatusstringPickingStatusOptional拣货状态
105BFLowIdBFLowIdstringBFLowIdOptional业务流程
106ParentMaterialId_NameParentMaterialId_NamestringParentMaterialId.NameOptional产品编码_名称
107ParentMaterialId_NumberParentMaterialId_NumberstringParentMaterialId.NumberOptional产品编码_编码
108SNUnitID_NameSNUnitID_NamestringSNUnitID.NameOptional序列号单位_名称
109SNUnitID_NumberSNUnitID_NumberstringSNUnitID.NumberOptional序列号单位_编码
110SNQtySNQtystringSNQtyOptional序列号单位数量
111ReserveTypeReserveTypestringReserveTypeOptional预留类型
112SettleOrgId_NameSettleOrgId_NamestringSettleOrgId.NameOptional结算组织_名称
113SettleOrgId_NumberSettleOrgId_NumberstringSettleOrgId.NumberOptional结算组织_编码
114BaseStockActualQtyBaseStockActualQtystringBaseStockActualQtyOptional主库存基本单位实发数量
115StockActualQtyStockActualQtystringStockActualQtyOptional库存单位实发数量
116ConsomeConsomestringConsomeOptional消耗汇总
117PMBillNoPMBillNostringPMBillNoOptional备料单编号
118ReqSrcReqSrcstringReqSrcOptional需求来源
119ReqBillNoReqBillNostringReqBillNoOptional需求单据
120ReqBillIdReqBillIdstringReqBillIdOptional需求单据内码
121ReqEntrySeqReqEntrySeqstringReqEntrySeqOptional需求单据行号
122ReqEntryIdReqEntryIdstringReqEntryIdOptional需求单据分录内码
123POOrderBillNoPOOrderBillNostringPOOrderBillNoOptional采购订单
124POOrderSeqPOOrderSeqstringPOOrderSeqOptional采购订单行号
125GroupRowGroupRowstringGroupRowOptional组别
126TransRetFormIdTransRetFormIdstringTransRetFormIdOptional转出退料单标识
127TransRetBillNoTransRetBillNostringTransRetBillNoOptional转出退料单号
128TransRetIdTransRetIdstringTransRetIdOptional转出退料单内码
129TransRetEntryIdTransRetEntryIdstringTransRetEntryIdOptional转出退料单分录内码
130TransRetEntrySeqTransRetEntrySeqstringTransRetEntrySeqOptional转出退料单行号
131BaseInventoryQtyBaseInventoryQtystringBaseInventoryQtyOptional基本单位可用库存数量

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1Fentity_FEntryIDFentity_FEntryIDstring1OptionalFentity_FEntryID
2BillNoBillNostring1Optional单据编号
3DocumentStatusDocumentStatusstring1Optional单据状态
4ApproverId_NameApproverId_Namestring1Optional审核人_名称
5ApproverId_NumberApproverId_Numberstring1Optional审核人_编码
6ApproveDateApproveDatestring1Optional审核日期
7ModifierId_NameModifierId_Namestring1Optional修改人_名称
8ModifierId_NumberModifierId_Numberstring1Optional修改人_编码
9CreateDateCreateDatestring1Optional创建日期
10CreatorId_NameCreatorId_Namestring1Optional创建人_名称
11CreatorId_NumberCreatorId_Numberstring1Optional创建人_编码
12ModifyDateModifyDatestring1Optional修改日期
13CancelDateCancelDatestring1Optional作废日期
14CANCELER_NameCANCELER_Namestring1Optional作废人_名称
15CANCELER_NumberCANCELER_Numberstring1Optional作废人_编码
16CancelStatusCancelStatusstring1Optional作废状态
17DescriptionDescriptionstring1Optional备注
18BillTypeBillTypestring1Optional单据类型
19DateDatestring1Optional日期
20SubOrgId_NameSubOrgId_Namestring1Optional委外组织_名称
21SubOrgId_NumberSubOrgId_Numberstring1Optional委外组织_编码
22SupplierId_NameSupplierId_Namestring1Optional供应商_名称
23SupplierId_NumberSupplierId_Numberstring1Optional供应商_编码
24OwnerTypeIdOwnerTypeIdstring1Optional货主类型
25OwnerIdOwnerIdstring1Optional货主
26CurrId_NameCurrId_Namestring1Optional本位币_名称
27CurrId_NumberCurrId_Numberstring1Optional本位币_编码
28StockOrgId_NameStockOrgId_Namestring1Optional发料组织_名称
29StockOrgId_NumberStockOrgId_Numberstring1Optional发料组织_编码
30FTransferBizType_NameFTransferBizType_Namestring1Optional跨组织业务类型_名称
31FTransferBizType_NumberFTransferBizType_Numberstring1Optional跨组织业务类型_编码
32FSTOCKERID_NameFSTOCKERID_Namestring1Optional仓管员_名称
33FSTOCKERID_NumberFSTOCKERID_Numberstring1Optional仓管员_编码
34PickerId_NamePickerId_Namestring1Optional领料人_名称
35PickerId_NumberPickerId_Numberstring1Optional领料人_编码
36IsCrossTradeIsCrossTradestring1Optional跨法人交易
37VmiBusinessVmiBusinessstring1OptionalVMI业务
38SourceTypeSourceTypestring1Optional倒冲来源
39IsOwnerTInclOrgIsOwnerTInclOrgstring1Optional货主含组织
40InventoryDateInventoryDatestring1Optional库存刷新日期
41MaterialId_NameMaterialId_Namestring1Optional物料编码_名称
42MaterialId_NumberMaterialId_Numberstring1Optional物料编码_编码
43ProduceDateProduceDatestring1Optional生产日期
44ExpiryDateExpiryDatestring1Optional有效期至
45BomId_NameBomId_Namestring1OptionalBOM版本_名称
46BomId_NumberBomId_Numberstring1OptionalBOM版本_编码
47UnitID_NameUnitID_Namestring1Optional单位_名称
48UnitID_NumberUnitID_Numberstring1Optional单位_编码
49AllowOverQtyAllowOverQtystring1Optional可超发数量
50SelPrcdReturnQtySelPrcdReturnQtystring1Optional退料选单数量
51KeeperTypeIdKeeperTypeIdstring1Optional保管者类型
52KeeperIdKeeperIdstring1Optional保管者
53StockFlagStockFlagstring1Optional更新库存标志
54MTONOMTONOstring1Optional计划跟踪号
55ProjectNOProjectNOstring1Optional项目编号
56StockStatusId_NameStockStatusId_Namestring1Optional库存状态_名称
57StockStatusId_NumberStockStatusId_Numberstring1Optional库存状态_编码
58StockID_NameStockID_Namestring1Optional仓库_名称
59StockID_NumberStockID_Numberstring1Optional仓库_编码
60OperIDOperIDstring1Optional工序号
61ProcessID_NameProcessID_Namestring1Optional作业_名称
62ProcessID_NumberProcessID_Numberstring1Optional作业_编码
63PricePricestring1Optional成本价
64AmountAmountstring1Optional总成本
65SrcBillTypeSrcBillTypestring1Optional系统源单类型
66FSrcBillNoFSrcBillNostring1Optional系统源单编号
67SrcInterIdSrcInterIdstring1Optional系统源单内码
68SrcEntryIdSrcEntryIdstring1Optional系统源单分录内码
69SrcEntrySeqSrcEntrySeqstring1Optional系统源单行号
70SubReqIdSubReqIdstring1Optional委外订单内码
71SubReqBillNoSubReqBillNostring1Optional委外订单编号
72SubReqEntryIdSubReqEntryIdstring1Optional委外订单分录内码
73SubReqEntrySeqSubReqEntrySeqstring1Optional委外订单行号
74PPbomBillNoPPbomBillNostring1Optional委外用料清单编号
75PPbomEntryIdPPbomEntryIdstring1Optional委外用料清单分录内码
76BaseUnitId_NameBaseUnitId_Namestring1Optional基本单位_名称
77BaseUnitId_NumberBaseUnitId_Numberstring1Optional基本单位_编码
78BaseAppQtyBaseAppQtystring1Optional基本单位申请数量
79BaseActualQtyBaseActualQtystring1Optional基本单位实发数量
80BaseAllowOverQtyBaseAllowOverQtystring1Optional基本单位可超发数量
81BaseSelPrcdReturnQtyBaseSelPrcdReturnQtystring1Optional基本单位退料选单数量
82StockUnitId_NameStockUnitId_Namestring1Optional库存单位_名称
83StockUnitId_NumberStockUnitId_Numberstring1Optional库存单位_编码
84StockAppQtyStockAppQtystring1Optional库存单位申请数量
85StockAllowOverQtyStockAllowOverQtystring1Optional库存单位可超发数量
86StockSelPrcdReturnQtyStockSelPrcdReturnQtystring1Optional库存单位退料选单数量
87SecUnitId_NameSecUnitId_Namestring1Optional辅助单位_名称
88SecUnitId_NumberSecUnitId_Numberstring1Optional辅助单位_编码
89SecActualQtySecActualQtystring1Optional辅助单位实发数量
90SecAllowOverQtySecAllowOverQtystring1Optional辅助单位可超发数量
91SecSelPrcdReturnQtySecSelPrcdReturnQtystring1Optional辅助单位退料选单数量
92AppQtyAppQtystring1Optional申请数量
93ActualQtyActualQtystring1Optional实发数量
94Lot_NameLot_Namestring1Optional批号_名称
95Lot_NumberLot_Numberstring1Optional批号_编码
96ParentOwnerTypeIdParentOwnerTypeIdstring1Optional产品货主类型
97ParentOwnerIdParentOwnerIdstring1Optional产品货主
98SRCBIZBILLTYPE_NameSRCBIZBILLTYPE_Namestring1Optional业务源单类型_名称
99SRCBIZBILLTYPE_NumberSRCBIZBILLTYPE_Numberstring1Optional业务源单类型_编码
100SRCBIZBILLNOSRCBIZBILLNOstring1Optional业务源单编号
101SRCBIZINTERIDSRCBIZINTERIDstring1Optional业务源单内码
102SRCBIZENTRYIDSRCBIZENTRYIDstring1Optional业务源单分录内码
103SRCBIZENTRYSEQSRCBIZENTRYSEQstring1Optional业务源单行号
104PickingStatusPickingStatusstring1Optional拣货状态
105BFLowIdBFLowIdstring1Optional业务流程
106ParentMaterialId_NameParentMaterialId_Namestring1Optional产品编码_名称
107ParentMaterialId_NumberParentMaterialId_Numberstring1Optional产品编码_编码
108SNUnitID_NameSNUnitID_Namestring1Optional序列号单位_名称
109SNUnitID_NumberSNUnitID_Numberstring1Optional序列号单位_编码
110SNQtySNQtystring1Optional序列号单位数量
111ReserveTypeReserveTypestring1Optional预留类型
112SettleOrgId_NameSettleOrgId_Namestring1Optional结算组织_名称
113SettleOrgId_NumberSettleOrgId_Numberstring1Optional结算组织_编码
114BaseStockActualQtyBaseStockActualQtystring1Optional主库存基本单位实发数量
115StockActualQtyStockActualQtystring1Optional库存单位实发数量
116ConsomeConsomestring1Optional消耗汇总
117PMBillNoPMBillNostring1Optional备料单编号
118ReqSrcReqSrcstring1Optional需求来源
119ReqBillNoReqBillNostring1Optional需求单据
120ReqBillIdReqBillIdstring1Optional需求单据内码
121ReqEntrySeqReqEntrySeqstring1Optional需求单据行号
122ReqEntryIdReqEntryIdstring1Optional需求单据分录内码
123POOrderBillNoPOOrderBillNostring1Optional采购订单
124POOrderSeqPOOrderSeqstring1Optional采购订单行号
125GroupRowGroupRowstring1Optional组别
126TransRetFormIdTransRetFormIdstring1Optional转出退料单标识
127TransRetBillNoTransRetBillNostring1Optional转出退料单号
128TransRetIdTransRetIdstring1Optional转出退料单内码
129TransRetEntryIdTransRetEntryIdstring1Optional转出退料单分录内码
130TransRetEntrySeqTransRetEntrySeqstring1Optional转出退料单行号
131BaseInventoryQtyBaseInventoryQtystring1Optional基本单位可用库存数量

The 委外领料查询_v1 API (executeBillQuery) of 金蝶云星空 is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 金蝶云星空 version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.