金蝶云星空采购退料查询_v1 API

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

采购退料查询_v1

POSTexecuteBillQuery

Factory

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

Request Parameters

No.	Field	Name	Type	Default	Required	Description
1	FPURMRBENTRY_FEntryID	FPURMRBENTRY_FEntryID	string	FPURMRBENTRY_FEntryID	Optional	111
2	FID	FID	string	FID	Optional	111
3	FBillNo	FBillNo	string	FBillNo	Optional	111
4	FDocumentStatus	FDocumentStatus	string	FDocumentStatus	Optional	111
5	FStockOrgId_FNumber	FStockOrgId_FNumber	string	FStockOrgId.FNumber	Optional	111
6	FDate	FDate	string	FDate	Optional	111
7	FBillTypeID_FNumber	FBillTypeID_FNumber	string	FBillTypeID.FNumber	Optional	111
8	FTAKEDELIVERYNO	FTAKEDELIVERYNO	string	FTAKEDELIVERYNO	Optional	111
9	FSupplierID_FNumber	FSupplierID_FNumber	string	FSupplierID.FNumber	Optional	111
10	FDESCRIPTION	FDESCRIPTION	string	FDESCRIPTION	Optional	111
11	FCarrierID_FNumber	FCarrierID_FNumber	string	FCarrierID.FNumber	Optional	111
12	FDELIVERYNO	FDELIVERYNO	string	FDELIVERYNO	Optional	111
13	FPurchaseOrgId_FNumber	FPurchaseOrgId_FNumber	string	FPurchaseOrgId.FNumber	Optional	111
14	FMRTYPE	FMRTYPE	string	FMRTYPE	Optional	111
15	FMRMODE	FMRMODE	string	FMRMODE	Optional	111
16	FMRREASON	FMRREASON	string	FMRREASON	Optional	111
17	FREPLENISHMODE	FREPLENISHMODE	string	FREPLENISHMODE	Optional	111
18	FCreateDate	FCreateDate	string	FCreateDate	Optional	111
19	FModifyDate	FModifyDate	string	FModifyDate	Optional	111
20	FApproveDate	FApproveDate	string	FApproveDate	Optional	111
21	FCreatorId	FCreatorId	string	FCreatorId	Optional	111
22	FApproverId	FApproverId	string	FApproverId	Optional	111
23	FCancelerId	FCancelerId	string	FCancelerId	Optional	111
24	FCancelDate	FCancelDate	string	FCancelDate	Optional	111
25	FCARRYNO	FCARRYNO	string	FCARRYNO	Optional	111
26	FCancelStatus	FCancelStatus	string	FCancelStatus	Optional	111
27	FACCEPTORID_FNumber	FACCEPTORID_FNumber	string	FACCEPTORID.FNumber	Optional	111
28	FSettleId_FNumber	FSettleId_FNumber	string	FSettleId.FNumber	Optional	111
29	FBusinessType	FBusinessType	string	FBusinessType	Optional	111
30	FAcceptAddress	FAcceptAddress	string	FAcceptAddress	Optional	111
31	FCHARGEID_FNumber	FCHARGEID_FNumber	string	FCHARGEID.FNumber	Optional	111
32	FAPSTATUS	FAPSTATUS	string	FAPSTATUS	Optional	111
33	FTransferBizType	FTransferBizType	string	FTransferBizType	Optional	111
34	FCorrespondOrgId_FNumber	FCorrespondOrgId_FNumber	string	FCorrespondOrgId.FNumber	Optional	111
35	FSupplyOrderNo	FSupplyOrderNo	string	FSupplyOrderNo	Optional	111
36	FPayOrgId_FNumber	FPayOrgId_FNumber	string	FPayOrgId.FNumber	Optional	111
37	FSettleOrgId_FNumber	FSettleOrgId_FNumber	string	FSettleOrgId.FNumber	Optional	111
38	FSETTLETYPEID_FNumber	FSETTLETYPEID_FNumber	string	FSETTLETYPEID.FNumber	Optional	111
39	FPAYCONDITIONID_FNumber	FPAYCONDITIONID_FNumber	string	FPAYCONDITIONID.FNumber	Optional	111
40	FSettleCurrId_FNumber	FSettleCurrId_FNumber	string	FSettleCurrId.FNumber	Optional	111
41	FBILLTAXAMOUNT	FBILLTAXAMOUNT	string	FBILLTAXAMOUNT	Optional	111
42	FBILLCOSTAMOUNT	FBILLCOSTAMOUNT	string	FBILLCOSTAMOUNT	Optional	111
43	FBILLALLAMOUNT	FBILLALLAMOUNT	string	FBILLALLAMOUNT	Optional	111
44	FEXCHANGETYPEID_FNumber	FEXCHANGETYPEID_FNumber	string	FEXCHANGETYPEID.FNumber	Optional	111
45	FIsIncludedTax	FIsIncludedTax	string	FIsIncludedTax	Optional	111
46	FBillAmount	FBillAmount	string	FBillAmount	Optional	111
47	FISGENFORIOS	FISGENFORIOS	string	FISGENFORIOS	Optional	111
48	FSettleSupplierID_FNumber	FSettleSupplierID_FNumber	string	FSettleSupplierID.FNumber	Optional	111
49	FISPRICEEXCLUDETAX	FISPRICEEXCLUDETAX	string	FISPRICEEXCLUDETAX	Optional	111
50	FISINVOICEARLIER	FISINVOICEARLIER	string	FISINVOICEARLIER	Optional	111
51	FTHIRDSRCTYPE	FTHIRDSRCTYPE	string	FTHIRDSRCTYPE	Optional	111
52	FTHIRDBILLID	FTHIRDBILLID	string	FTHIRDBILLID	Optional	111
53	FTHIRDBILLNO	FTHIRDBILLNO	string	FTHIRDBILLNO	Optional	111
54	FMATERIALID_FNumber	FMATERIALID_FNumber	string	FMATERIALID.FNumber	Optional	111
55	FREPLENISHQTY	FREPLENISHQTY	string	FREPLENISHQTY	Optional	111
56	FKEAPAMTQTY	FKEAPAMTQTY	string	FKEAPAMTQTY	Optional	111
57	FSTOCKID_FNumber	FSTOCKID_FNumber	string	FSTOCKID.FNumber	Optional	111
58	FStockStatusId	FStockStatusId	string	FStockStatusId	Optional	111
59	FNOTE	FNOTE	string	FNOTE	Optional	111
60	FProduceDate	FProduceDate	string	FProduceDate	Optional	111
61	FEXPIRYDATE	FEXPIRYDATE	string	FEXPIRYDATE	Optional	111
62	FCONTRACTNO	FCONTRACTNO	string	FCONTRACTNO	Optional	111
63	FREQTRACENO	FREQTRACENO	string	FREQTRACENO	Optional	111
64	FORDERNO	FORDERNO	string	FORDERNO	Optional	111
65	FPRICEUNITQTY	FPRICEUNITQTY	string	FPRICEUNITQTY	Optional	111
66	FCostPrice	FCostPrice	string	FCostPrice	Optional	111
67	FTAXPRICE	FTAXPRICE	string	FTAXPRICE	Optional	111
68	FDISCOUNTRATE	FDISCOUNTRATE	string	FDISCOUNTRATE	Optional	111
69	FTAXNETPRICE	FTAXNETPRICE	string	FTAXNETPRICE	Optional	111
70	FENTRYCOSTAMOUNT	FENTRYCOSTAMOUNT	string	FENTRYCOSTAMOUNT	Optional	111
71	FENTRYTAXRATE	FENTRYTAXRATE	string	FENTRYTAXRATE	Optional	111
72	FENTRYTAXAMOUNT	FENTRYTAXAMOUNT	string	FENTRYTAXAMOUNT	Optional	111
73	FALLAMOUNT	FALLAMOUNT	string	FALLAMOUNT	Optional	111
74	FOWNERID_FNumber	FOWNERID_FNumber	string	FOWNERID.FNumber	Optional	111
75	FJOINQTY	FJOINQTY	string	FJOINQTY	Optional	111
76	FRMREALQTY	FRMREALQTY	string	FRMREALQTY	Optional	111
77	FRMMUSTQTY	FRMMUSTQTY	string	FRMMUSTQTY	Optional	111
78	FSTOCKLOCID	FSTOCKLOCID	string	FSTOCKLOCID	Optional	111
79	FSRCBillTypeId	FSRCBillTypeId	string	FSRCBillTypeId	Optional	111
80	FSRCBillNo	FSRCBillNo	string	FSRCBillNo	Optional	111
81	FLot	FLot	string	FLot	Optional	111
82	FPrice	FPrice	string	FPrice	Optional	111
83	FAmount	FAmount	string	FAmount	Optional	111
84	FDiscount	FDiscount	string	FDiscount	Optional	111
85	FBFLowId	FBFLowId	string	FBFLowId	Optional	111
86	FSRCSeq	FSRCSeq	string	FSRCSeq	Optional	111
87	FMtoNo	FMtoNo	string	FMtoNo	Optional	111
88	FIsStock	FIsStock	string	FIsStock	Optional	111
89	FGiveAway	FGiveAway	string	FGiveAway	Optional	111
90	FRowId	FRowId	string	FRowId	Optional	111
91	FParentRowId	FParentRowId	string	FParentRowId	Optional	111
92	FBarcode	FBarcode	string	FBarcode	Optional	111
93	FPRICEUNITID	FPRICEUNITID	string	FPRICEUNITID	Optional	111
94	FUnitID	FUnitID	string	FUnitID	Optional	111
95	FCarryUnitId	FCarryUnitId	string	FCarryUnitId	Optional	111
96	FCarryQty	FCarryQty	string	FCarryQty	Optional	111

Response Parameters

No.	Field	Name	Type	Default	Required	Description
1	FPURMRBENTRY_FEntryID	FPURMRBENTRY_FEntryID	string	1	Optional	111
2	FID	FID	string	1	Optional	111
3	FBillNo	FBillNo	string	1	Optional	111
4	FDocumentStatus	FDocumentStatus	string	1	Optional	111
5	FStockOrgId_FNumber	FStockOrgId_FNumber	string	1	Optional	111
6	FDate	FDate	string	1	Optional	111
7	FBillTypeID_FNumber	FBillTypeID_FNumber	string	1	Optional	111
8	FTAKEDELIVERYNO	FTAKEDELIVERYNO	string	1	Optional	111
9	FSupplierID_FNumber	FSupplierID_FNumber	string	1	Optional	111
10	FDESCRIPTION	FDESCRIPTION	string	1	Optional	111
11	FCarrierID_FNumber	FCarrierID_FNumber	string	1	Optional	111
12	FDELIVERYNO	FDELIVERYNO	string	1	Optional	111
13	FPurchaseOrgId_FNumber	FPurchaseOrgId_FNumber	string	1	Optional	111
14	FMRTYPE	FMRTYPE	string	1	Optional	111
15	FMRMODE	FMRMODE	string	1	Optional	111
16	FMRREASON	FMRREASON	string	1	Optional	111
17	FREPLENISHMODE	FREPLENISHMODE	string	1	Optional	111
18	FCreateDate	FCreateDate	string	1	Optional	111
19	FModifyDate	FModifyDate	string	1	Optional	111
20	FApproveDate	FApproveDate	string	1	Optional	111
21	FCreatorId	FCreatorId	string	1	Optional	111
22	FApproverId	FApproverId	string	1	Optional	111
23	FCancelerId	FCancelerId	string	1	Optional	111
24	FCancelDate	FCancelDate	string	1	Optional	111
25	FCARRYNO	FCARRYNO	string	1	Optional	111
26	FCancelStatus	FCancelStatus	string	1	Optional	111
27	FACCEPTORID_FNumber	FACCEPTORID_FNumber	string	1	Optional	111
28	FSettleId_FNumber	FSettleId_FNumber	string	1	Optional	111
29	FBusinessType	FBusinessType	string	1	Optional	111
30	FAcceptAddress	FAcceptAddress	string	1	Optional	111
31	FCHARGEID_FNumber	FCHARGEID_FNumber	string	1	Optional	111
32	FAPSTATUS	FAPSTATUS	string	1	Optional	111
33	FTransferBizType	FTransferBizType	string	1	Optional	111
34	FCorrespondOrgId_FNumber	FCorrespondOrgId_FNumber	string	1	Optional	111
35	FSupplyOrderNo	FSupplyOrderNo	string	1	Optional	111
36	FPayOrgId_FNumber	FPayOrgId_FNumber	string	1	Optional	111
37	FSettleOrgId_FNumber	FSettleOrgId_FNumber	string	1	Optional	111
38	FSETTLETYPEID_FNumber	FSETTLETYPEID_FNumber	string	1	Optional	111
39	FPAYCONDITIONID_FNumber	FPAYCONDITIONID_FNumber	string	1	Optional	111
40	FSettleCurrId_FNumber	FSettleCurrId_FNumber	string	1	Optional	111
41	FBILLTAXAMOUNT	FBILLTAXAMOUNT	string	1	Optional	111
42	FBILLCOSTAMOUNT	FBILLCOSTAMOUNT	string	1	Optional	111
43	FBILLALLAMOUNT	FBILLALLAMOUNT	string	1	Optional	111
44	FEXCHANGETYPEID_FNumber	FEXCHANGETYPEID_FNumber	string	1	Optional	111
45	FIsIncludedTax	FIsIncludedTax	string	1	Optional	111
46	FBillAmount	FBillAmount	string	1	Optional	111
47	FISGENFORIOS	FISGENFORIOS	string	1	Optional	111
48	FSettleSupplierID_FNumber	FSettleSupplierID_FNumber	string	1	Optional	111
49	FISPRICEEXCLUDETAX	FISPRICEEXCLUDETAX	string	1	Optional	111
50	FISINVOICEARLIER	FISINVOICEARLIER	string	1	Optional	111
51	FTHIRDSRCTYPE	FTHIRDSRCTYPE	string	1	Optional	111
52	FTHIRDBILLID	FTHIRDBILLID	string	1	Optional	111
53	FTHIRDBILLNO	FTHIRDBILLNO	string	1	Optional	111
54	FMATERIALID_FNumber	FMATERIALID_FNumber	string	1	Optional	111
55	FREPLENISHQTY	FREPLENISHQTY	string	1	Optional	111
56	FKEAPAMTQTY	FKEAPAMTQTY	string	1	Optional	111
57	FSTOCKID_FNumber	FSTOCKID_FNumber	string	1	Optional	111
58	FStockStatusId	FStockStatusId	string	1	Optional	111
59	FNOTE	FNOTE	string	1	Optional	111
60	FProduceDate	FProduceDate	string	1	Optional	111
61	FEXPIRYDATE	FEXPIRYDATE	string	1	Optional	111
62	FCONTRACTNO	FCONTRACTNO	string	1	Optional	111
63	FREQTRACENO	FREQTRACENO	string	1	Optional	111
64	FORDERNO	FORDERNO	string	1	Optional	111
65	FPRICEUNITQTY	FPRICEUNITQTY	string	1	Optional	111
66	FCostPrice	FCostPrice	string	1	Optional	111
67	FTAXPRICE	FTAXPRICE	string	1	Optional	111
68	FDISCOUNTRATE	FDISCOUNTRATE	string	1	Optional	111
69	FTAXNETPRICE	FTAXNETPRICE	string	1	Optional	111
70	FENTRYCOSTAMOUNT	FENTRYCOSTAMOUNT	string	1	Optional	111
71	FENTRYTAXRATE	FENTRYTAXRATE	string	1	Optional	111
72	FENTRYTAXAMOUNT	FENTRYTAXAMOUNT	string	1	Optional	111
73	FALLAMOUNT	FALLAMOUNT	string	1	Optional	111
74	FOWNERID_FNumber	FOWNERID_FNumber	string	1	Optional	111
75	FJOINQTY	FJOINQTY	string	1	Optional	111
76	FRMREALQTY	FRMREALQTY	string	1	Optional	111
77	FRMMUSTQTY	FRMMUSTQTY	string	1	Optional	111
78	FSTOCKLOCID	FSTOCKLOCID	string	1	Optional	111
79	FSRCBillTypeId	FSRCBillTypeId	string	1	Optional	111
80	FSRCBillNo	FSRCBillNo	string	1	Optional	111
81	FLot	FLot	string	1	Optional	111
82	FPrice	FPrice	string	1	Optional	111
83	FAmount	FAmount	string	1	Optional	111
84	FDiscount	FDiscount	string	1	Optional	111
85	FBFLowId	FBFLowId	string	1	Optional	111
86	FSRCSeq	FSRCSeq	string	1	Optional	111
87	FMtoNo	FMtoNo	string	1	Optional	111
88	FIsStock	FIsStock	string	1	Optional	111
89	FGiveAway	FGiveAway	string	1	Optional	111
90	FRowId	FRowId	string	1	Optional	111
91	FParentRowId	FParentRowId	string	1	Optional	111
92	FBarcode	FBarcode	string	1	Optional	111
93	FPRICEUNITID	FPRICEUNITID	string	1	Optional	111
94	FUnitID	FUnitID	string	1	Optional	111
95	FCarryUnitId	FCarryUnitId	string	1	Optional	111
96	FCarryQty	FCarryQty	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.