金蝶云星空退料申请查询_v1 API

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

退料申请查询_v1

POSTexecuteBillQuery

Factory

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

Request Parameters

No.	Field	Name	Type	Default	Required	Description
1	FBillNo	FBillNo	string	FBillNo	Optional	111
2	FEntity_FEntryID	FEntity_FEntryID	string	FEntity_FEntryID	Optional	111
3	FID	FID	string	FID	Optional	111
4	FDocumentStatus	FDocumentStatus	string	FDocumentStatus	Optional	111
5	FBillTypeID_Fnumber	FBillTypeID_Fnumber	string	FBillTypeID.Fnumber	Optional	111
6	FDate	FDate	string	FDate	Optional	111
7	FPURCHASEORGID_Fnumber	FPURCHASEORGID_Fnumber	string	FPURCHASEORGID.Fnumber	Optional	111
8	FAPPORGID_Fnumber	FAPPORGID_Fnumber	string	FAPPORGID.Fnumber	Optional	111
9	FAPPDEPTID_Fnumber	FAPPDEPTID_Fnumber	string	FAPPDEPTID.Fnumber	Optional	111
10	FRMLOC	FRMLOC	string	FRMLOC	Optional	111
11	FSUPPLIERID_Fnumber	FSUPPLIERID_Fnumber	string	FSUPPLIERID.Fnumber	Optional	111
12	FRMMODE	FRMMODE	string	FRMMODE	Optional	111
13	FREPLENISHMODE	FREPLENISHMODE	string	FREPLENISHMODE	Optional	111
14	FCreatorId	FCreatorId	string	FCreatorId	Optional	111
15	FCreateDate	FCreateDate	string	FCreateDate	Optional	111
16	FModifierId	FModifierId	string	FModifierId	Required	111
17	FModifyDate	FModifyDate	string	FModifyDate	Optional	111
18	FAPPROVERID	FAPPROVERID	string	FAPPROVERID	Optional	111
19	FAPPROVEDATE	FAPPROVEDATE	string	FAPPROVEDATE	Optional	111
20	FCANCELLERID	FCANCELLERID	string	FCANCELLERID	Optional	111
21	FCANCELDATE	FCANCELDATE	string	FCANCELDATE	Optional	111
22	FCANCELSTATUS	FCANCELSTATUS	string	FCANCELSTATUS	Optional	111
23	FBusinessType	FBusinessType	string	FBusinessType	Optional	111
24	FRemarks	FRemarks	string	FRemarks	Optional	111
25	FRMREASON	FRMREASON	string	FRMREASON	Optional	111
26	FRequireOrgId_Fnumber	FRequireOrgId_Fnumber	string	FRequireOrgId.Fnumber	Optional	111
27	FCorrespondOrgId_Fnumber	FCorrespondOrgId_Fnumber	string	FCorrespondOrgId.Fnumber	Optional	111
28	FConfirmerId	FConfirmerId	string	FConfirmerId	Optional	111
29	FConfirmDate	FConfirmDate	string	FConfirmDate	Optional	111
30	FConfirmStatus	FConfirmStatus	string	FConfirmStatus	Optional	111
31	FMATERIALID_Fnumber	FMATERIALID_Fnumber	string	FMATERIALID.Fnumber	Optional	111
32	FMaterialName	FMaterialName	string	FMaterialName	Optional	111
33	FUOM	FUOM	string	FUOM	Optional	111
34	FMaterialType	FMaterialType	string	FMaterialType	Optional	111
35	FMRAPPQTY	FMRAPPQTY	string	FMRAPPQTY	Optional	111
36	FREPLENISHQTY	FREPLENISHQTY	string	FREPLENISHQTY	Optional	111
37	FKEAPAMTQTY	FKEAPAMTQTY	string	FKEAPAMTQTY	Optional	111
38	FMRJOINQTY	FMRJOINQTY	string	FMRJOINQTY	Optional	111
39	FMRQTY	FMRQTY	string	FMRQTY	Optional	111
40	FNOTE_M	FNOTE_M	string	FNOTE_M	Optional	111
41	FBOMID	FBOMID	string	FBOMID	Optional	111
42	FPRICEQTY_F	FPRICEQTY_F	string	FPRICEQTY_F	Optional	111
43	FPRICE_F	FPRICE_F	string	FPRICE_F	Optional	111
44	FPRICECOEFFICIENT_F	FPRICECOEFFICIENT_F	string	FPRICECOEFFICIENT_F	Optional	111
45	FDISCOUNTRATE_F	FDISCOUNTRATE_F	string	FDISCOUNTRATE_F	Optional	111
46	FDISCOUNT_F	FDISCOUNT_F	string	FDISCOUNT_F	Optional	111
47	FTAXNETPRICE_F	FTAXNETPRICE_F	string	FTAXNETPRICE_F	Optional	111
48	FAMOUNT_F	FAMOUNT_F	string	FAMOUNT_F	Optional	111
49	FALLAMOUNT_F	FALLAMOUNT_F	string	FALLAMOUNT_F	Optional	111
50	FAPPROVEPRICE_F	FAPPROVEPRICE_F	string	FAPPROVEPRICE_F	Optional	111
51	FSRCSEQ	FSRCSEQ	string	FSRCSEQ	Optional	111
52	FCONTRACTNO	FCONTRACTNO	string	FCONTRACTNO	Optional	111
53	FORDERNO	FORDERNO	string	FORDERNO	Optional	111
54	FREQTRACENO	FREQTRACENO	string	FREQTRACENO	Optional	111
55	FBASEUNITQTY	FBASEUNITQTY	string	FBASEUNITQTY	Optional	111
56	FBASEUNITID	FBASEUNITID	string	FBASEUNITID	Optional	111
57	FUNITID	FUNITID	string	FUNITID	Optional	111
58	FPRICEUNITID_F	FPRICEUNITID_F	string	FPRICEUNITID_F	Optional	111
59	FBASEMRJOINQTY	FBASEMRJOINQTY	string	FBASEMRJOINQTY	Optional	111
60	FBASEMRQTY	FBASEMRQTY	string	FBASEMRQTY	Optional	111
61	FAUXPROPID	FAUXPROPID	string	FAUXPROPID	Optional	111
62	FSRCBILLNO	FSRCBILLNO	string	FSRCBILLNO	Optional	111
63	FSRCBILLTYPEID	FSRCBILLTYPEID	string	FSRCBILLTYPEID	Optional	111
64	FREPLENISHAMOUNT	FREPLENISHAMOUNT	string	FREPLENISHAMOUNT	Optional	111
65	FKEAPAMTAMOUNT	FKEAPAMTAMOUNT	string	FKEAPAMTAMOUNT	Optional	111
66	FLot	FLot	string	FLot	Optional	111
67	FRMREASON_M	FRMREASON_M	string	FRMREASON_M	Optional	111
68	FBFLowId	FBFLowId	string	FBFLowId	Optional	111
69	FMtoNo	FMtoNo	string	FMtoNo	Optional	111
70	FGiveAway	FGiveAway	string	FGiveAway	Optional	111
71	FPriceBaseQty	FPriceBaseQty	string	FPriceBaseQty	Optional	111
72	FPURUNITID	FPURUNITID	string	FPURUNITID	Optional	111
73	FPurQty	FPurQty	string	FPurQty	Optional	111
74	FPurBaseQty	FPurBaseQty	string	FPurBaseQty	Optional	111
75	FPURBASENUM	FPURBASENUM	string	FPURBASENUM	Optional	111
76	FSTOCKBASEDEN	FSTOCKBASEDEN	string	FSTOCKBASEDEN	Optional	111
77	FSRCBIZUNITID	FSRCBIZUNITID	string	FSRCBIZUNITID	Optional	111
78	FRETURNSTOCKJNBASEQTY	FRETURNSTOCKJNBASEQTY	string	FRETURNSTOCKJNBASEQTY	Optional	111
79	FEntryTaxRate	FEntryTaxRate	string	FEntryTaxRate	Optional	111
80	FENTRYPRICELISTID	FENTRYPRICELISTID	string	FENTRYPRICELISTID	Optional	111
81	FPOORDERENTRYID	FPOORDERENTRYID	string	FPOORDERENTRYID	Optional	111
82	FStockId_Fnumber	FStockId_Fnumber	string	FStockId.Fnumber	Optional	111
83	FISSYNTOTHIRD	FISSYNTOTHIRD	string	FISSYNTOTHIRD	Optional	111
84	FRowType	FRowType	string	FRowType	Optional	111
85	FPARENTMATID	FPARENTMATID	string	FPARENTMATID	Optional	111
86	FPriceDiscount	FPriceDiscount	string	FPriceDiscount	Optional	111
87	FSTOCKLOCID	FSTOCKLOCID	string	FSTOCKLOCID	Optional	111
88	FPriLstEntryId	FPriLstEntryId	string	FPriLstEntryId	Optional	111
89	FEntity_Link_FFlowId	FEntity_Link_FFlowId	string	FEntity_Link_FFlowId	Optional	111
90	FEntity_Link_FFlowLineId	FEntity_Link_FFlowLineId	string	FEntity_Link_FFlowLineId	Optional	111
91	FEntity_Link_FRuleId	FEntity_Link_FRuleId	string	FEntity_Link_FRuleId	Optional	111
92	FEntity_Link_FSTableId	FEntity_Link_FSTableId	string	FEntity_Link_FSTableId	Optional	111
93	FEntity_Link_FSTableName	FEntity_Link_FSTableName	string	FEntity_Link_FSTableName	Optional	111
94	FEntity_Link_FSBillId	FEntity_Link_FSBillId	string	FEntity_Link_FSBillId	Optional	111
95	FEntity_Link_FSId	FEntity_Link_FSId	string	FEntity_Link_FSId	Optional	111
96	FEntity_Link_FBASEUNITQTYOld	FEntity_Link_FBASEUNITQTYOld	string	FEntity_Link_FBASEUNITQTYOld	Optional	111
97	FEntity_Link_FBASEUNITQTY	FEntity_Link_FBASEUNITQTY	string	FEntity_Link_FBASEUNITQTY	Optional	111
98	FEntity_Link_FPurBaseQtyOld	FEntity_Link_FPurBaseQtyOld	string	FEntity_Link_FPurBaseQtyOld	Optional	111
99	FEntity_Link_FPurBaseQty	FEntity_Link_FPurBaseQty	string	FEntity_Link_FPurBaseQty	Optional	111
100	FEntity_Link_FLnkTrackerId	FEntity_Link_FLnkTrackerId	string	FEntity_Link_FLnkTrackerId	Optional	111
101	FEntity_Link_FLnkSState	FEntity_Link_FLnkSState	string	FEntity_Link_FLnkSState	Optional	111
102	FEntity_Link_FLnkAmount	FEntity_Link_FLnkAmount	string	FEntity_Link_FLnkAmount	Optional	111

Response Parameters

No.	Field	Name	Type	Default	Required	Description
1	FBillNo	FBillNo	string	1	Optional	111
2	FEntity_FEntryID	FEntity_FEntryID	string	1	Optional	111
3	FID	FID	string	1	Optional	111
4	FDocumentStatus	FDocumentStatus	string	1	Optional	111
5	FBillTypeID_Fnumber	FBillTypeID_Fnumber	string	1	Optional	111
6	FDate	FDate	string	1	Optional	111
7	FPURCHASEORGID_Fnumber	FPURCHASEORGID_Fnumber	string	1	Optional	111
8	FRMTYPE_Fnumber	FRMTYPE_Fnumber	string	1	Optional	111
9	FAPPORGID_Fnumber	FAPPORGID_Fnumber	string	1	Optional	111
10	FAPPDEPTID_Fnumber	FAPPDEPTID_Fnumber	string	1	Optional	111
11	FRMLOC	FRMLOC	string	1	Optional	111
12	FSUPPLIERID_Fnumber	FSUPPLIERID_Fnumber	string	1	Optional	111
13	FRMMODE	FRMMODE	string	1	Optional	111
14	FREPLENISHMODE	FREPLENISHMODE	string	1	Optional	111
15	FCreatorId	FCreatorId	string	1	Optional	111
16	FCreateDate	FCreateDate	string	1	Optional	111
17	FModifierId	FModifierId	string	1	Required	111
18	FModifyDate	FModifyDate	string	1	Optional	111
19	FAPPROVERID	FAPPROVERID	string	1	Optional	111
20	FAPPROVEDATE	FAPPROVEDATE	string	1	Optional	111
21	FCANCELLERID	FCANCELLERID	string	1	Optional	111
22	FCANCELDATE	FCANCELDATE	string	1	Optional	111
23	FCANCELSTATUS	FCANCELSTATUS	string	1	Optional	111
24	FBusinessType	FBusinessType	string	1	Optional	111
25	FRemarks	FRemarks	string	1	Optional	111
26	FRMREASON	FRMREASON	string	1	Optional	111
27	FRequireOrgId_Fnumber	FRequireOrgId_Fnumber	string	1	Optional	111
28	FCorrespondOrgId_Fnumber	FCorrespondOrgId_Fnumber	string	1	Optional	111
29	FConfirmerId	FConfirmerId	string	1	Optional	111
30	FConfirmDate	FConfirmDate	string	1	Optional	111
31	FConfirmStatus	FConfirmStatus	string	1	Optional	111
32	FMATERIALID_Fnumber	FMATERIALID_Fnumber	string	1	Optional	111
33	FMaterialName	FMaterialName	string	1	Optional	111
34	FUOM	FUOM	string	1	Optional	111
35	FMaterialType	FMaterialType	string	1	Optional	111
36	FMRAPPQTY	FMRAPPQTY	string	1	Optional	111
37	FREPLENISHQTY	FREPLENISHQTY	string	1	Optional	111
38	FKEAPAMTQTY	FKEAPAMTQTY	string	1	Optional	111
39	FMRJOINQTY	FMRJOINQTY	string	1	Optional	111
40	FMRQTY	FMRQTY	string	1	Optional	111
41	FNOTE_M	FNOTE_M	string	1	Optional	111
42	FBOMID	FBOMID	string	1	Optional	111
43	FPRICEQTY_F	FPRICEQTY_F	string	1	Optional	111
44	FPRICE_F	FPRICE_F	string	1	Optional	111
45	FPRICECOEFFICIENT_F	FPRICECOEFFICIENT_F	string	1	Optional	111
46	FDISCOUNTRATE_F	FDISCOUNTRATE_F	string	1	Optional	111
47	FDISCOUNT_F	FDISCOUNT_F	string	1	Optional	111
48	FTAXNETPRICE_F	FTAXNETPRICE_F	string	1	Optional	111
49	FAMOUNT_F	FAMOUNT_F	string	1	Optional	111
50	FALLAMOUNT_F	FALLAMOUNT_F	string	1	Optional	111
51	FAPPROVEPRICE_F	FAPPROVEPRICE_F	string	1	Optional	111
52	FSRCSEQ	FSRCSEQ	string	1	Optional	111
53	FCONTRACTNO	FCONTRACTNO	string	1	Optional	111
54	FORDERNO	FORDERNO	string	1	Optional	111
55	FREQTRACENO	FREQTRACENO	string	1	Optional	111
56	FBASEUNITQTY	FBASEUNITQTY	string	1	Optional	111
57	FBASEUNITID	FBASEUNITID	string	1	Optional	111
58	FUNITID	FUNITID	string	1	Optional	111
59	FPRICEUNITID_F	FPRICEUNITID_F	string	1	Optional	111
60	FBASEMRJOINQTY	FBASEMRJOINQTY	string	1	Optional	111
61	FBASEMRQTY	FBASEMRQTY	string	1	Optional	111
62	FAUXPROPID	FAUXPROPID	string	1	Optional	111
63	FSRCBILLNO	FSRCBILLNO	string	1	Optional	111
64	FSRCBILLTYPEID	FSRCBILLTYPEID	string	1	Optional	111
65	FREPLENISHAMOUNT	FREPLENISHAMOUNT	string	1	Optional	111
66	FKEAPAMTAMOUNT	FKEAPAMTAMOUNT	string	1	Optional	111
67	FLot	FLot	string	1	Optional	111
68	FRMREASON_M	FRMREASON_M	string	1	Optional	111
69	FBFLowId	FBFLowId	string	1	Optional	111
70	FMtoNo	FMtoNo	string	1	Optional	111
71	FGiveAway	FGiveAway	string	1	Optional	111
72	FPriceBaseQty	FPriceBaseQty	string	1	Optional	111
73	FPURUNITID	FPURUNITID	string	1	Optional	111
74	FPurQty	FPurQty	string	1	Optional	111
75	FPurBaseQty	FPurBaseQty	string	1	Optional	111
76	FPURBASENUM	FPURBASENUM	string	1	Optional	111
77	FSTOCKBASEDEN	FSTOCKBASEDEN	string	1	Optional	111
78	FSRCBIZUNITID	FSRCBIZUNITID	string	1	Optional	111
79	FRETURNSTOCKJNBASEQTY	FRETURNSTOCKJNBASEQTY	string	1	Optional	111
80	FEntryTaxRate	FEntryTaxRate	string	1	Optional	111
81	FENTRYPRICELISTID	FENTRYPRICELISTID	string	1	Optional	111
82	FPOORDERENTRYID	FPOORDERENTRYID	string	1	Optional	111
83	FStockId_Fnumber	FStockId_Fnumber	string	1	Optional	111
84	FISSYNTOTHIRD	FISSYNTOTHIRD	string	1	Optional	111
85	FRowType	FRowType	string	1	Optional	111
86	FPARENTMATID	FPARENTMATID	string	1	Optional	111
87	FPriceDiscount	FPriceDiscount	string	1	Optional	111
88	FSTOCKLOCID	FSTOCKLOCID	string	1	Optional	111
89	FPriLstEntryId	FPriLstEntryId	string	1	Optional	111
90	FEntity_Link_FFlowId	FEntity_Link_FFlowId	string	1	Optional	111
91	FEntity_Link_FFlowLineId	FEntity_Link_FFlowLineId	string	1	Optional	111
92	FEntity_Link_FRuleId	FEntity_Link_FRuleId	string	1	Optional	111
93	FEntity_Link_FSTableId	FEntity_Link_FSTableId	string	1	Optional	111
94	FEntity_Link_FSTableName	FEntity_Link_FSTableName	string	1	Optional	111
95	FEntity_Link_FSBillId	FEntity_Link_FSBillId	string	1	Optional	111
96	FEntity_Link_FSId	FEntity_Link_FSId	string	1	Optional	111
97	FEntity_Link_FBASEUNITQTYOld	FEntity_Link_FBASEUNITQTYOld	string	1	Optional	111
98	FEntity_Link_FBASEUNITQTY	FEntity_Link_FBASEUNITQTY	string	1	Optional	111
99	FEntity_Link_FPurBaseQtyOld	FEntity_Link_FPurBaseQtyOld	string	1	Optional	111
100	FEntity_Link_FPurBaseQty	FEntity_Link_FPurBaseQty	string	1	Optional	111
101	FEntity_Link_FLnkTrackerId	FEntity_Link_FLnkTrackerId	string	1	Optional	111
102	FEntity_Link_FLnkSState	FEntity_Link_FLnkSState	string	1	Optional	111
103	FEntity_Link_FLnkAmount	FEntity_Link_FLnkAmount	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.