executeBillQuery{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FID | FID | string | FID | Optional | 111 |
| 2 | FBillNo | FBillNo | string | FBillNo | Optional | 111 |
| 3 | FDOCUMENTSTATUS | FDOCUMENTSTATUS | string | FDOCUMENTSTATUS | Optional | 111 |
| 4 | FCREATORID | FCREATORID | string | FCREATORID | Optional | 111 |
| 5 | FAPPROVERID | FAPPROVERID | string | FAPPROVERID | Optional | 111 |
| 6 | FCREATEDATE | FCREATEDATE | string | FCREATEDATE | Optional | 111 |
| 7 | FSETTLEORGID | FSETTLEORGID | string | FSETTLEORGID | Required | 111 |
| 8 | FAPPROVEDATE | FAPPROVEDATE | string | FAPPROVEDATE | Optional | 111 |
| 9 | FPURCHASEORGID | FPURCHASEORGID | string | FPURCHASEORGID | Optional | 111 |
| 10 | FPAYAMOUNTFOR_H | FPAYAMOUNTFOR_H | string | FPAYAMOUNTFOR_H | Optional | 111 |
| 11 | FCURRENCYID | FCURRENCYID | string | FCURRENCYID | Optional | 111 |
| 12 | FDATE | FDATE | string | FDATE | Required | 111 |
| 13 | FMODIFYDATE | FMODIFYDATE | string | FMODIFYDATE | Optional | 111 |
| 14 | FMODIFIERID | FMODIFIERID | string | FMODIFIERID | Optional | 111 |
| 15 | FBILLTYPEID | FBILLTYPEID | string | FBILLTYPEID | Required | 111 |
| 16 | FPURCHASERID | FPURCHASERID | string | FPURCHASERID | Optional | 111 |
| 17 | FPURCHASEDEPTID | FPURCHASEDEPTID | string | FPURCHASEDEPTID | Optional | 111 |
| 18 | FAPPLYAMOUNTFOR_H | FAPPLYAMOUNTFOR_H | string | FAPPLYAMOUNTFOR_H | Optional | 111 |
| 19 | FACCOUNTSYSTEM | FACCOUNTSYSTEM | string | FACCOUNTSYSTEM | Optional | 111 |
| 20 | FCANCELLERID | FCANCELLERID | string | FCANCELLERID | Optional | 111 |
| 21 | FCANCELSTATUS | FCANCELSTATUS | string | FCANCELSTATUS | Required | 111 |
| 22 | FCANCELDATE | FCANCELDATE | string | FCANCELDATE | Optional | 111 |
| 23 | FCONTACTUNITTYPE | FCONTACTUNITTYPE | string | FCONTACTUNITTYPE | Required | 111 |
| 24 | FCONTACTUNIT | FCONTACTUNIT | string | FCONTACTUNIT | Required | 111 |
| 25 | FRECTUNITTYPE | FRECTUNITTYPE | string | FRECTUNITTYPE | Required | 111 |
| 26 | FRECTUNIT | FRECTUNIT | string | FRECTUNIT | Required | 111 |
| 27 | FBUSINESSTYPE | FBUSINESSTYPE | string | FBUSINESSTYPE | Optional | 111 |
| 28 | FDEPARTMENT | FDEPARTMENT | string | FDEPARTMENT | Optional | 111 |
| 29 | FPAYORGID | FPAYORGID | string | FPAYORGID | Required | 111 |
| 30 | FSALEORGID | FSALEORGID | string | FSALEORGID | Optional | 111 |
| 31 | FSALEDEPTID | FSALEDEPTID | string | FSALEDEPTID | Optional | 111 |
| 32 | FSALEERID | FSALEERID | string | FSALEERID | Optional | 111 |
| 33 | FMAINBOOKID | FMAINBOOKID | string | FMAINBOOKID | Optional | 111 |
| 34 | FEXCHANGERATE | FEXCHANGERATE | string | FEXCHANGERATE | Optional | 111 |
| 35 | FEXCHANGETYPE | FEXCHANGETYPE | string | FEXCHANGETYPE | Optional | 111 |
| 36 | FSOURCESYSTEM | FSOURCESYSTEM | string | FSOURCESYSTEM | Optional | 111 |
| 37 | FIsCredit | FIsCredit | string | FIsCredit | Optional | 111 |
| 38 | FBankActID | FBankActID | string | FBankActID | Optional | 111 |
| 39 | FAPPLYORGID | FAPPLYORGID | string | FAPPLYORGID | Required | 111 |
| 40 | FScanPoint | FScanPoint | string | FScanPoint | Optional | 111 |
| 41 | FCLOSESTATUS | FCLOSESTATUS | string | FCLOSESTATUS | Optional | 111 |
| 42 | FCLOSERID | FCLOSERID | string | FCLOSERID | Optional | 111 |
| 43 | FCLOSEDATE | FCLOSEDATE | string | FCLOSEDATE | Optional | 111 |
| 44 | FSETTLECUR | FSETTLECUR | string | FSETTLECUR | Required | 111 |
| 45 | FREALAPPLYAMOUNTFOR | FREALAPPLYAMOUNTFOR | string | FREALAPPLYAMOUNTFOR | Optional | 111 |
| 46 | FSETTLERATE | FSETTLERATE | string | FSETTLERATE | Optional | 111 |
| 47 | FAPPLYAMOUNT | FAPPLYAMOUNT | string | FAPPLYAMOUNT | Optional | 111 |
| 48 | FPURCHASERGROUPID | FPURCHASERGROUPID | string | FPURCHASERGROUPID | Optional | 111 |
| 49 | FSALEGROUPID | FSALEGROUPID | string | FSALEGROUPID | Optional | 111 |
| 50 | FIsBorrow | FIsBorrow | string | FIsBorrow | Optional | 111 |
| 51 | FISCARRYRATE | FISCARRYRATE | string | FISCARRYRATE | Optional | 111 |
| 52 | FMoreReceive | FMoreReceive | string | FMoreReceive | Optional | 111 |
| 53 | FPRESETBASE1 | FPRESETBASE1 | string | FPRESETBASE1 | Optional | 111 |
| 54 | FPRESETBASE2 | FPRESETBASE2 | string | FPRESETBASE2 | Optional | 111 |
| 55 | FPRESETASSISTANT1 | FPRESETASSISTANT1 | string | FPRESETASSISTANT1 | Optional | 111 |
| 56 | FPRESETASSISTANT2 | FPRESETASSISTANT2 | string | FPRESETASSISTANT2 | Optional | 111 |
| 57 | FPRESETTEXT1 | FPRESETTEXT1 | string | FPRESETTEXT1 | Optional | 111 |
| 58 | FPRESETTEXT2 | FPRESETTEXT2 | string | FPRESETTEXT2 | Optional | 111 |
| 59 | FPAYAPPLYENTRY_FEntryID | FPAYAPPLYENTRY_FEntryID | string | FPAYAPPLYENTRY_FEntryID | Optional | 111 |
| 60 | FSETTLETYPEID | FSETTLETYPEID | string | FSETTLETYPEID | Optional | 111 |
| 61 | FPAYAMOUNTFOR | FPAYAMOUNTFOR | string | FPAYAMOUNTFOR | Optional | 111 |
| 62 | FEACHBANKACCOUNT | FEACHBANKACCOUNT | string | FEACHBANKACCOUNT | Optional | 111 |
| 63 | FAPPLYAMOUNTFOR | FAPPLYAMOUNTFOR | string | FAPPLYAMOUNTFOR | Optional | 111 |
| 64 | FPAYPURPOSEID | FPAYPURPOSEID | string | FPAYPURPOSEID | Required | 111 |
| 65 | FARPURPOSEID | FARPURPOSEID | string | FARPURPOSEID | Optional | 111 |
| 66 | FSOURCETYPE | FSOURCETYPE | string | FSOURCETYPE | Optional | 111 |
| 67 | FSRCBILLNO | FSRCBILLNO | string | FSRCBILLNO | Optional | 111 |
| 68 | FENDDATE | FENDDATE | string | FENDDATE | Required | 111 |
| 69 | FEXPECTPAYDATE | FEXPECTPAYDATE | string | FEXPECTPAYDATE | Required | 111 |
| 70 | FEACHCCOUNTNAME | FEACHCCOUNTNAME | string | FEACHCCOUNTNAME | Optional | 111 |
| 71 | FEACHBANKNAME | FEACHBANKNAME | string | FEACHBANKNAME | Optional | 111 |
| 72 | FCOMMENT | FCOMMENT | string | FCOMMENT | Optional | 111 |
| 73 | FSRCROWID | FSRCROWID | string | FSRCROWID | Optional | 111 |
| 74 | FRELATEPAYAMOUNT | FRELATEPAYAMOUNT | string | FRELATEPAYAMOUNT | Optional | 111 |
| 75 | FRELATEREFUNDAMOUNT | FRELATEREFUNDAMOUNT | string | FRELATEREFUNDAMOUNT | Optional | 111 |
| 76 | FCOSTID | FCOSTID | string | FCOSTID | Required | 111 |
| 77 | FApplyPclAmount | FApplyPclAmount | string | FApplyPclAmount | Optional | 111 |
| 78 | FApplyInstAmount | FApplyInstAmount | string | FApplyInstAmount | Optional | 111 |
| 79 | FWritePclAmount | FWritePclAmount | string | FWritePclAmount | Optional | 111 |
| 80 | FDescription | FDescription | string | FDescription | Optional | 111 |
| 81 | FMATERIALID | FMATERIALID | string | FMATERIALID | Optional | 111 |
| 82 | FMATERIALNAME | FMATERIALNAME | string | FMATERIALNAME | Optional | 111 |
| 83 | FPURCHASEORDERNO | FPURCHASEORDERNO | string | FPURCHASEORDERNO | Optional | 111 |
| 84 | FMATERIALSEQ | FMATERIALSEQ | string | FMATERIALSEQ | Optional | 111 |
| 85 | FORDERENTRYID | FORDERENTRYID | string | FORDERENTRYID | Optional | 111 |
| 86 | FPRICE | FPRICE | string | FPRICE | Optional | 111 |
| 87 | FQTY | FQTY | string | FQTY | Optional | 111 |
| 88 | FPRICEUNITID | FPRICEUNITID | string | FPRICEUNITID | Optional | 111 |
| 89 | FRELATEPAYQTY | FRELATEPAYQTY | string | FRELATEPAYQTY | Optional | 111 |
| 90 | FUnpaidAmount | FUnpaidAmount | string | FUnpaidAmount | Optional | 111 |
| 91 | FSwiftCode | FSwiftCode | string | FSwiftCode | Optional | 111 |
| 92 | FTAXAMOUNT | FTAXAMOUNT | string | FTAXAMOUNT | Optional | 111 |
| 93 | FBankDetail | FBankDetail | string | FBankDetail | Optional | 111 |
| 94 | FEXPENSEDEPTID | FEXPENSEDEPTID | string | FEXPENSEDEPTID | Optional | 111 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FID | FID | string | 1 | Optional | 111 |
| 2 | FBillNo | FBillNo | string | 1 | Optional | 111 |
| 3 | FDOCUMENTSTATUS | FDOCUMENTSTATUS | string | 1 | Optional | 111 |
| 4 | FCREATORID | FCREATORID | string | 1 | Optional | 111 |
| 5 | FAPPROVERID | FAPPROVERID | string | 1 | Optional | 111 |
| 6 | FCREATEDATE | FCREATEDATE | string | 1 | Optional | 111 |
| 7 | FSETTLEORGID | FSETTLEORGID | string | 1 | Required | 111 |
| 8 | FAPPROVEDATE | FAPPROVEDATE | string | 1 | Optional | 111 |
| 9 | FPURCHASEORGID | FPURCHASEORGID | string | 1 | Optional | 111 |
| 10 | FPAYAMOUNTFOR_H | FPAYAMOUNTFOR_H | string | 1 | Optional | 111 |
| 11 | FCURRENCYID | FCURRENCYID | string | 1 | Optional | 111 |
| 12 | FDATE | FDATE | string | 1 | Required | 111 |
| 13 | FMODIFYDATE | FMODIFYDATE | string | 1 | Optional | 111 |
| 14 | FMODIFIERID | FMODIFIERID | string | 1 | Optional | 111 |
| 15 | FBILLTYPEID | FBILLTYPEID | string | 1 | Required | 111 |
| 16 | FPURCHASERID | FPURCHASERID | string | 1 | Optional | 111 |
| 17 | FPURCHASEDEPTID | FPURCHASEDEPTID | string | 1 | Optional | 111 |
| 18 | FAPPLYAMOUNTFOR_H | FAPPLYAMOUNTFOR_H | string | 1 | Optional | 111 |
| 19 | FACCOUNTSYSTEM | FACCOUNTSYSTEM | string | 1 | Optional | 111 |
| 20 | FCANCELLERID | FCANCELLERID | string | 1 | Optional | 111 |
| 21 | FCANCELSTATUS | FCANCELSTATUS | string | 1 | Required | 111 |
| 22 | FCANCELDATE | FCANCELDATE | string | 1 | Optional | 111 |
| 23 | FCONTACTUNITTYPE | FCONTACTUNITTYPE | string | 1 | Required | 111 |
| 24 | FCONTACTUNIT | FCONTACTUNIT | string | 1 | Required | 111 |
| 25 | FRECTUNITTYPE | FRECTUNITTYPE | string | 1 | Required | 111 |
| 26 | FRECTUNIT | FRECTUNIT | string | 1 | Required | 111 |
| 27 | FBUSINESSTYPE | FBUSINESSTYPE | string | 1 | Optional | 111 |
| 28 | FDEPARTMENT | FDEPARTMENT | string | 1 | Optional | 111 |
| 29 | FPAYORGID | FPAYORGID | string | 1 | Required | 111 |
| 30 | FSALEORGID | FSALEORGID | string | 1 | Optional | 111 |
| 31 | FSALEDEPTID | FSALEDEPTID | string | 1 | Optional | 111 |
| 32 | FSALEERID | FSALEERID | string | 1 | Optional | 111 |
| 33 | FMAINBOOKID | FMAINBOOKID | string | 1 | Optional | 111 |
| 34 | FEXCHANGERATE | FEXCHANGERATE | string | 1 | Optional | 111 |
| 35 | FEXCHANGETYPE | FEXCHANGETYPE | string | 1 | Optional | 111 |
| 36 | FSOURCESYSTEM | FSOURCESYSTEM | string | 1 | Optional | 111 |
| 37 | FIsCredit | FIsCredit | string | 1 | Optional | 111 |
| 38 | FBankActID | FBankActID | string | 1 | Optional | 111 |
| 39 | FAPPLYORGID | FAPPLYORGID | string | 1 | Required | 111 |
| 40 | FScanPoint | FScanPoint | string | 1 | Optional | 111 |
| 41 | FCLOSESTATUS | FCLOSESTATUS | string | 1 | Optional | 111 |
| 42 | FCLOSERID | FCLOSERID | string | 1 | Optional | 111 |
| 43 | FCLOSEDATE | FCLOSEDATE | string | 1 | Optional | 111 |
| 44 | FSETTLECUR | FSETTLECUR | string | 1 | Required | 111 |
| 45 | FREALAPPLYAMOUNTFOR | FREALAPPLYAMOUNTFOR | string | 1 | Optional | 111 |
| 46 | FSETTLERATE | FSETTLERATE | string | 1 | Optional | 111 |
| 47 | FAPPLYAMOUNT | FAPPLYAMOUNT | string | 1 | Optional | 111 |
| 48 | FPURCHASERGROUPID | FPURCHASERGROUPID | string | 1 | Optional | 111 |
| 49 | FSALEGROUPID | FSALEGROUPID | string | 1 | Optional | 111 |
| 50 | FIsBorrow | FIsBorrow | string | 1 | Optional | 111 |
| 51 | FISCARRYRATE | FISCARRYRATE | string | 1 | Optional | 111 |
| 52 | FMoreReceive | FMoreReceive | string | 1 | Optional | 111 |
| 53 | FPRESETBASE1 | FPRESETBASE1 | string | 1 | Optional | 111 |
| 54 | FPRESETBASE2 | FPRESETBASE2 | string | 1 | Optional | 111 |
| 55 | FPRESETASSISTANT1 | FPRESETASSISTANT1 | string | 1 | Optional | 111 |
| 56 | FPRESETASSISTANT2 | FPRESETASSISTANT2 | string | 1 | Optional | 111 |
| 57 | FPRESETTEXT1 | FPRESETTEXT1 | string | 1 | Optional | 111 |
| 58 | FPRESETTEXT2 | FPRESETTEXT2 | string | 1 | Optional | 111 |
| 59 | FPAYAPPLYENTRY_FEntryID | FPAYAPPLYENTRY_FEntryID | string | 1 | Optional | 111 |
| 60 | FSETTLETYPEID | FSETTLETYPEID | string | 1 | Optional | 111 |
| 61 | FPAYAMOUNTFOR | FPAYAMOUNTFOR | string | 1 | Optional | 111 |
| 62 | FEACHBANKACCOUNT | FEACHBANKACCOUNT | string | 1 | Optional | 111 |
| 63 | FAPPLYAMOUNTFOR | FAPPLYAMOUNTFOR | string | 1 | Optional | 111 |
| 64 | FPAYPURPOSEID | FPAYPURPOSEID | string | 1 | Required | 111 |
| 65 | FARPURPOSEID | FARPURPOSEID | string | 1 | Optional | 111 |
| 66 | FSOURCETYPE | FSOURCETYPE | string | 1 | Optional | 111 |
| 67 | FSRCBILLNO | FSRCBILLNO | string | 1 | Optional | 111 |
| 68 | FENDDATE | FENDDATE | string | 1 | Required | 111 |
| 69 | FEXPECTPAYDATE | FEXPECTPAYDATE | string | 1 | Required | 111 |
| 70 | FEACHCCOUNTNAME | FEACHCCOUNTNAME | string | 1 | Optional | 111 |
| 71 | FEACHBANKNAME | FEACHBANKNAME | string | 1 | Optional | 111 |
| 72 | FCOMMENT | FCOMMENT | string | 1 | Optional | 111 |
| 73 | FSRCROWID | FSRCROWID | string | 1 | Optional | 111 |
| 74 | FRELATEPAYAMOUNT | FRELATEPAYAMOUNT | string | 1 | Optional | 111 |
| 75 | FRELATEREFUNDAMOUNT | FRELATEREFUNDAMOUNT | string | 1 | Optional | 111 |
| 76 | FCOSTID | FCOSTID | string | 1 | Required | 111 |
| 77 | FApplyPclAmount | FApplyPclAmount | string | 1 | Optional | 111 |
| 78 | FApplyInstAmount | FApplyInstAmount | string | 1 | Optional | 111 |
| 79 | FWritePclAmount | FWritePclAmount | string | 1 | Optional | 111 |
| 80 | FDescription | FDescription | string | 1 | Optional | 111 |
| 81 | FMATERIALID | FMATERIALID | string | 1 | Optional | 111 |
| 82 | FMATERIALNAME | FMATERIALNAME | string | 1 | Optional | 111 |
| 83 | FPURCHASEORDERNO | FPURCHASEORDERNO | string | 1 | Optional | 111 |
| 84 | FMATERIALSEQ | FMATERIALSEQ | string | 1 | Optional | 111 |
| 85 | FORDERENTRYID | FORDERENTRYID | string | 1 | Optional | 111 |
| 86 | FPRICE | FPRICE | string | 1 | Optional | 111 |
| 87 | FQTY | FQTY | string | 1 | Optional | 111 |
| 88 | FPRICEUNITID | FPRICEUNITID | string | 1 | Optional | 111 |
| 89 | FRELATEPAYQTY | FRELATEPAYQTY | string | 1 | Optional | 111 |
| 90 | FUnpaidAmount | FUnpaidAmount | string | 1 | Optional | 111 |
| 91 | FSwiftCode | FSwiftCode | string | 1 | Optional | 111 |
| 92 | FTAXAMOUNT | FTAXAMOUNT | string | 1 | Optional | 111 |
| 93 | FBankDetail | FBankDetail | string | 1 | Optional | 111 |
| 94 | FEXPENSEDEPTID | FEXPENSEDEPTID | 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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.