金蝶云星空采购订单查询_v1 API

Platform: 金蝶云星空
Type: WebAPI
Effect: QUERY
API Version: 0.1
Adapter: \Adapter\K3Cloud\K3CloudQueryAdapter
Auth Mode: OTHER
Updated At: 2021-01-10

采购订单查询_v1

POSTexecuteBillQuery

Factory

{
  "operation": {
    "method": "none"
  }
}

Request Parameters

No.	Field	Name	Type	Default	Required	Description
1	FPOOrderEntry_FEntryId	FPOOrderEntry_FEntryId	string	FPOOrderEntry_FEntryId	Required	111
2	FBillNo	FBillNo	string	FBillNo	Required	单据编号
3	FSourceBillNo	FSourceBillNo	string	FSourceBillNo	Optional	源单编号
4	FBillTypeID_FNumber	FBillTypeID_FNumber	string	FBillTypeID.FNumber	Required	单据类型
5	FBusinessType	FBusinessType	string	FBusinessType	Optional	下拉列表
6	FSupplierId_FNumber	FSupplierId_FNumber	string	FSupplierId.FNumber	Optional	基础资料
7	FSettleModeId_FNumber	FSettleModeId_FNumber	string	FSettleModeId.FNumber	Optional	基础资料
8	FPayConditionId_FNumber	FPayConditionId_FNumber	string	FPayConditionId.FNumber	Optional	基础资料
9	FDate	FDate	string	FDate	Optional	日期
10	FDocumentStatus	FDocumentStatus	string	FDocumentStatus	Optional	单据状态
11	FPreMatchAmountFor	FPreMatchAmountFor	string	FPreMatchAmountFor	Optional	金额
12	FPayAdvanceBillId_FNumber	FPayAdvanceBillId_FNumber	string	FPayAdvanceBillId.FNumber	Optional	基础资料
13	FPurchaseOrgId_FNumber	FPurchaseOrgId_FNumber	string	FPurchaseOrgId.FNumber	Optional	组织
14	FPurchaseDeptId_FNumber	FPurchaseDeptId_FNumber	string	FPurchaseDeptId.FNumber	Optional	基础资料
15	FPurchaserGroupId_FNumber	FPurchaserGroupId_FNumber	string	FPurchaserGroupId.FNumber	Optional	基础资料
16	FPurchaserId_FNumber	FPurchaserId_FNumber	string	FPurchaserId.FNumber	Optional	基础资料
17	FProviderId_FNumber	FProviderId_FNumber	string	FProviderId.FNumber	Optional	基础资料
18	FSettleId_FNumber	FSettleId_FNumber	string	FSettleId.FNumber	Optional	基础资料
19	FChargeId_FNumber	FChargeId_FNumber	string	FChargeId.FNumber	Optional	基础资料
20	FCorrespondOrgId_FNumber	FCorrespondOrgId_FNumber	string	FCorrespondOrgId.FNumber	Optional	组织
21	FAssignSupplierId_FNumber	FAssignSupplierId_FNumber	string	FAssignSupplierId.FNumber	Optional	基础资料
22	FMaterialId_FNumber	FMaterialId_FNumber	string	FMaterialId.FNumber	Optional	基础资料
23	FBarcode	FBarcode	string	FBarcode	Optional	文本
24	FQty	FQty	string	FQty	Optional	数量
25	FDeliveryDate	FDeliveryDate	string	FDeliveryDate	Optional	长日期
26	FLocation	FLocation	string	FLocation	Optional	多行文本
27	FLocationAddress	FLocationAddress	string	FLocationAddress	Optional	多行文本
28	FPrice	FPrice	string	FPrice	Optional	单价
29	FTaxPrice	FTaxPrice	string	FTaxPrice	Optional	单价
30	FEntryDiscountRate	FEntryDiscountRate	string	FEntryDiscountRate	Optional	小数
31	FEntryDiscount	FEntryDiscount	string	FEntryDiscount	Optional	折扣额
32	FEntryTaxRate	FEntryTaxRate	string	FEntryTaxRate	Optional	小数
33	FEntryTaxAmount	FEntryTaxAmount	string	FEntryTaxAmount	Optional	金额
34	FAllAmount	FAllAmount	string	FAllAmount	Optional	金额
35	FEntryAmount	FEntryAmount	string	FEntryAmount	Optional	金额
36	FRequireOrgId_FNumber	FRequireOrgId_FNumber	string	FRequireOrgId.FNumber	Optional	组织
37	FRequireDeptId_FNumber	FRequireDeptId_FNumber	string	FRequireDeptId.FNumber	Optional	基础资料
38	FRequireStaffId_FNumber	FRequireStaffId_FNumber	string	FRequireStaffId.FNumber	Optional	基础资料
39	FReceiveOrgId_FNumber	FReceiveOrgId_FNumber	string	FReceiveOrgId.FNumber	Optional	组织
40	FBranchId_FNumber	FBranchId_FNumber	string	FBranchId.FNumber	Optional	基础资料
41	FReceiveDeptId_FNumber	FReceiveDeptId_FNumber	string	FReceiveDeptId.FNumber	Optional	基础资料
42	FEntrySettleOrgId_FNumber	FEntrySettleOrgId_FNumber	string	FEntrySettleOrgId.FNumber	Optional	组织
43	FGiveAway	FGiveAway	string	FGiveAway	Optional	复选框
44	FEntryNote	FEntryNote	string	FEntryNote	Optional	多行文本
45	FSupMatId	FSupMatId	string	FSupMatId	Optional	文本
46	FSupMatName	FSupMatName	string	FSupMatName	Optional	文本
47	FLot	FLot	string	FLot	Optional	批次
48	FSupplierLot	FSupplierLot	string	FSupplierLot	Optional	文本
49	FReceiveQty	FReceiveQty	string	FReceiveQty	Optional	数量
50	FRemainReceiveQty	FRemainReceiveQty	string	FRemainReceiveQty	Optional	数量
51	FStockInQty	FStockInQty	string	FStockInQty	Optional	数量
52	FRemainStockINQty	FRemainStockINQty	string	FRemainStockINQty	Optional	数量
53	FMrbQty	FMrbQty	string	FMrbQty	Optional	数量
54	FCHECKRETQTY	FCHECKRETQTY	string	FCHECKRETQTY	Optional	数量
55	FSTOCKRETQTY	FSTOCKRETQTY	string	FSTOCKRETQTY	Optional	数量
56	FConsumeSumQty	FConsumeSumQty	string	FConsumeSumQty	Optional	数量
57	FSrcBillTypeId	FSrcBillTypeId	string	FSrcBillTypeId	Optional	源单类型
58	FSrcBillNo	FSrcBillNo	string	FSrcBillNo	Optional	源单编号
59	FReqTraceNo	FReqTraceNo	string	FReqTraceNo	Optional	文本
60	FMtoNo	FMtoNo	string	FMtoNo	Optional	文本
61	FDEMANDTYPE	FDEMANDTYPE	string	FDEMANDTYPE	Optional	下拉列表
62	FDEMANDBILLNO	FDEMANDBILLNO	string	FDEMANDBILLNO	Optional	文本
63	FDEMANDBILLENTRYSEQ	FDEMANDBILLENTRYSEQ	string	FDEMANDBILLENTRYSEQ	Optional	整数
64	FDEMANDBILLENTRYID	FDEMANDBILLENTRYID	string	FDEMANDBILLENTRYID	Optional	整数
65	FID	FID	string	1	Optional	111

Response Parameters

No.	Field	Name	Type	Default	Required	Description
1	FPOOrderEntry_FEntryId	FPOOrderEntry_FEntryId	string	1	Required	111
2	FBillNo	FBillNo	string	1	Required	单据编号
3	FSourceBillNo	FSourceBillNo	string	1	Optional	源单编号
4	FBillTypeID_FNumber	FBillTypeID_FNumber	string	1	Required	单据类型
5	FBusinessType	FBusinessType	string	1	Optional	下拉列表
6	FSupplierId_FNumber	FSupplierId_FNumber	string	1	Optional	基础资料
7	FSettleModeId_FNumber	FSettleModeId_FNumber	string	1	Optional	基础资料
8	FPayConditionId_FNumber	FPayConditionId_FNumber	string	1	Optional	基础资料
9	FDate	FDate	string	1	Optional	日期
10	FDocumentStatus	FDocumentStatus	string	1	Optional	单据状态
11	FPreMatchAmountFor	FPreMatchAmountFor	string	1	Optional	金额
12	FPayAdvanceBillId_FNumber	FPayAdvanceBillId_FNumber	string	1	Optional	基础资料
13	FPurchaseOrgId_FNumber	FPurchaseOrgId_FNumber	string	1	Optional	组织
14	FPurchaseDeptId_FNumber	FPurchaseDeptId_FNumber	string	1	Optional	基础资料
15	FPurchaserGroupId_FNumber	FPurchaserGroupId_FNumber	string	1	Optional	基础资料
16	FPurchaserId_FNumber	FPurchaserId_FNumber	string	1	Optional	基础资料
17	FProviderId_FNumber	FProviderId_FNumber	string	1	Optional	基础资料
18	FSettleId_FNumber	FSettleId_FNumber	string	1	Optional	基础资料
19	FChargeId_FNumber	FChargeId_FNumber	string	1	Optional	基础资料
20	FCorrespondOrgId_FNumber	FCorrespondOrgId_FNumber	string	1	Optional	组织
21	FAssignSupplierId_FNumber	FAssignSupplierId_FNumber	string	1	Optional	基础资料
22	FMaterialId_FNumber	FMaterialId_FNumber	string	1	Optional	基础资料
23	FBarcode	FBarcode	string	1	Optional	文本
24	FQty	FQty	string	1	Optional	数量
25	FDeliveryDate	FDeliveryDate	string	1	Optional	长日期
26	FLocation	FLocation	string	1	Optional	多行文本
27	FLocationAddress	FLocationAddress	string	1	Optional	多行文本
28	FPrice	FPrice	string	1	Optional	单价
29	FTaxPrice	FTaxPrice	string	1	Optional	单价
30	FEntryDiscountRate	FEntryDiscountRate	string	1	Optional	小数
31	FEntryDiscount	FEntryDiscount	string	1	Optional	折扣额
32	FEntryTaxRate	FEntryTaxRate	string	1	Optional	小数
33	FEntryTaxAmount	FEntryTaxAmount	string	1	Optional	金额
34	FAllAmount	FAllAmount	string	1	Optional	金额
35	FEntryAmount	FEntryAmount	string	1	Optional	金额
36	FRequireOrgId_FNumber	FRequireOrgId_FNumber	string	1	Optional	组织
37	FRequireDeptId_FNumber	FRequireDeptId_FNumber	string	1	Optional	基础资料
38	FRequireStaffId_FNumber	FRequireStaffId_FNumber	string	1	Optional	基础资料
39	FReceiveOrgId_FNumber	FReceiveOrgId_FNumber	string	1	Optional	组织
40	FBranchId_FNumber	FBranchId_FNumber	string	1	Optional	基础资料
41	FReceiveDeptId_FNumber	FReceiveDeptId_FNumber	string	1	Optional	基础资料
42	FEntrySettleOrgId_FNumber	FEntrySettleOrgId_FNumber	string	1	Optional	组织
43	FGiveAway	FGiveAway	string	1	Optional	复选框
44	FEntryNote	FEntryNote	string	1	Optional	多行文本
45	FSupMatId	FSupMatId	string	1	Optional	文本
46	FSupMatName	FSupMatName	string	1	Optional	文本
47	FLot	FLot	string	1	Optional	批次
48	FSupplierLot	FSupplierLot	string	1	Optional	文本
49	FReceiveQty	FReceiveQty	string	1	Optional	数量
50	FRemainReceiveQty	FRemainReceiveQty	string	1	Optional	数量
51	FStockInQty	FStockInQty	string	1	Optional	数量
52	FRemainStockINQty	FRemainStockINQty	string	1	Optional	数量
53	FMrbQty	FMrbQty	string	1	Optional	数量
54	FCHECKRETQTY	FCHECKRETQTY	string	1	Optional	数量
55	FSTOCKRETQTY	FSTOCKRETQTY	string	1	Optional	数量
56	FConsumeSumQty	FConsumeSumQty	string	1	Optional	数量
57	FSrcBillTypeId	FSrcBillTypeId	string	1	Optional	源单类型
58	FSrcBillNo	FSrcBillNo	string	1	Optional	源单编号
59	FReqTraceNo	FReqTraceNo	string	1	Optional	文本
60	FMtoNo	FMtoNo	string	1	Optional	文本
61	FDEMANDTYPE	FDEMANDTYPE	string	1	Optional	下拉列表
62	FDEMANDBILLNO	FDEMANDBILLNO	string	1	Optional	文本
63	FDEMANDBILLENTRYSEQ	FDEMANDBILLENTRYSEQ	string	1	Optional	整数
64	FDEMANDBILLENTRYID	FDEMANDBILLENTRYID	string	1	Optional	整数
65	FID	FID	string	1	Optional	111

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.