Qeasy Cloud
Get Started

金蝶云星空 收款单查询_v1 API

Type
WebAPI
Effect
QUERY
API Version
0.1
Adapter
\Adapter\K3Cloud\K3CloudQueryAdapter
Auth Mode
OTHER
Updated At
2022-03-29

收款单查询_v1

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

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1FIDFIDstringFIDOptional111
2FBillNoFBillNostringFBillNoOptional111
3FDOCUMENTSTATUSFDOCUMENTSTATUSstringFDOCUMENTSTATUSOptional111
4FCreatorIdFCreatorIdstringFCreatorIdOptional111
5FAPPROVERIDFAPPROVERIDstringFAPPROVERIDOptional111
6FCreateDateFCreateDatestringFCreateDateOptional111
7FSETTLEORGIDFSETTLEORGIDstringFSETTLEORGID.FNumberOptional111
8FApproveDateFApproveDatestringFApproveDateOptional111
9FSALEORGIDFSALEORGIDstringFSALEORGID.FNumberOptional111
10FEXCHANGETYPEFEXCHANGETYPEstringFEXCHANGETYPEOptional111
11FRECEIVEAMOUNTFOR_HFRECEIVEAMOUNTFOR_HstringFRECEIVEAMOUNTFOR_HOptional111
12FMAINBOOKCURIDFMAINBOOKCURIDstringFMAINBOOKCURIDOptional111
13FRECEIVEAMOUNT_HFRECEIVEAMOUNT_HstringFRECEIVEAMOUNT_HOptional111
14FCURRENCYIDFCURRENCYIDstringFCURRENCYID.FNumberOptional111
15FDATEFDATEstringFDATEOptional111
16FModifyDateFModifyDatestringFModifyDateOptional111
17FModifierIdFModifierIdstringFModifierIdOptional111
18FEXCHANGERATEFEXCHANGERATEstringFEXCHANGERATEOptional111
19FWRITTENOFFSTATUSFWRITTENOFFSTATUSstringFWRITTENOFFSTATUSOptional111
20FSALEERIDFSALEERIDstringFSALEERID.FNumberOptional111
21FSALEGROUPIDFSALEGROUPIDstringFSALEGROUPID.FNumberOptional111
22FSALEDEPTIDFSALEDEPTIDstringFSALEDEPTID.FNumberOptional111
23FBillTypeIDFBillTypeIDstringFBillTypeID.FNumberOptional111
24FREALRECAMOUNTFORFREALRECAMOUNTFORstringFREALRECAMOUNTFOROptional111
25FREALRECAMOUNT_HFREALRECAMOUNT_HstringFREALRECAMOUNT_HOptional111
26FACCOUNTSYSTEMFACCOUNTSYSTEMstringFACCOUNTSYSTEMOptional111
27FCancelDateFCancelDatestringFCancelDateOptional111
28FCancelStatusFCancelStatusstringFCancelStatusOptional111
29FCancellerIdFCancellerIdstringFCancellerIdOptional111
30FCONTACTUNITTYPEFCONTACTUNITTYPEstringFCONTACTUNITTYPEOptional111
31FCONTACTUNITFCONTACTUNITstringFCONTACTUNIT.FNumberOptional111
32FPAYUNITTYPEFPAYUNITTYPEstringFPAYUNITTYPEOptional111
33FPAYUNITFPAYUNITstringFPAYUNIT.FNumberOptional111
34FBUSINESSTYPEFBUSINESSTYPEstringFBUSINESSTYPEOptional111
35FCreditCheckResultFCreditCheckResultstringFCreditCheckResultOptional111
36FISINITFISINITstringFISINITOptional111
37FDepartmentFDepartmentstringFDepartmentOptional111
38FPAYORGIDFPAYORGIDstringFPAYORGID.FNumberOptional111
39FIsSameOrgFIsSameOrgstringFIsSameOrgOptional111
40FSOURCESYSTEMFSOURCESYSTEMstringFSOURCESYSTEMOptional111
41FCASHSALEFCASHSALEstringFCASHSALEOptional111
42FSETTLECURFSETTLECURstringFSETTLECUROptional111
43FSETTLERATEFSETTLERATEstringFSETTLERATEOptional111
44FRECAMOUNTFORFRECAMOUNTFORstringFRECAMOUNTFOROptional111
45FRECAMOUNTFRECAMOUNTstringFRECAMOUNTOptional111
46FISB2CFISB2CstringFISB2COptional111
47FWBSETTLENOFWBSETTLENOstringFWBSETTLENOOptional111
48FIsWriteOffFIsWriteOffstringFIsWriteOffOptional111
49FMatchMethodIDFMatchMethodIDstringFMatchMethodIDOptional111
50FScanPointFScanPointstringFScanPointOptional111
51FKDPAYNOFKDPAYNOstringFKDPAYNOOptional111
52FREMARKFREMARKstringFREMARKOptional111
53FTHIRDBILLNOFTHIRDBILLNOstringFTHIRDBILLNOOptional111
54FSETTLEMAINBOOKIDFSETTLEMAINBOOKIDstringFSETTLEMAINBOOKIDOptional111
55FSETTLEEXCHANGETYPEFSETTLEEXCHANGETYPEstringFSETTLEEXCHANGETYPEOptional111
56FOUTCONTACTIDFOUTCONTACTIDstringFOUTCONTACTIDOptional111
57FOUTCONTACTTYPEFOUTCONTACTTYPEstringFOUTCONTACTTYPEOptional111
58FGYACCOUNTWATERIDFGYACCOUNTWATERIDstringFGYACCOUNTWATERIDOptional111
59FISCARRYRATEFISCARRYRATEstringFISCARRYRATEOptional111
60FPRESETBASE1FPRESETBASE1stringFPRESETBASE1Optional111
61FPRESETBASE2FPRESETBASE2stringFPRESETBASE2Optional111
62FPRESETASSISTANT1FPRESETASSISTANT1stringFPRESETASSISTANT1Optional111
63FPRESETASSISTANT2FPRESETASSISTANT2stringFPRESETASSISTANT2Optional111
64FPRESETTEXT1FPRESETTEXT1stringFPRESETTEXT1Optional111
65FPRESETTEXT2FPRESETTEXT2stringFPRESETTEXT2Optional111
66FISFROMSALORDERFISFROMSALORDERstringFISFROMSALORDEROptional111
67FVirIsSameAcctOrgFVirIsSameAcctOrgstringFVirIsSameAcctOrgOptional111
68FSETTLETYPEIDFSETTLETYPEIDstringFSETTLETYPEIDOptional111
69FSETTLERECAMOUNTFORFSETTLERECAMOUNTFORstringFSETTLERECAMOUNTFOROptional111
70FSETTLEDISTAMOUNTFORFSETTLEDISTAMOUNTFORstringFSETTLEDISTAMOUNTFOROptional111
71FRECTOTALAMOUNTFORFRECTOTALAMOUNTFORstringFRECTOTALAMOUNTFOROptional111
72FSETTLERECAMOUNTFSETTLERECAMOUNTstringFSETTLERECAMOUNTOptional111
73FSETTLEDISTAMOUNTFSETTLEDISTAMOUNTstringFSETTLEDISTAMOUNTOptional111
74FRECTOTALAMOUNTFRECTOTALAMOUNTstringFRECTOTALAMOUNTOptional111
75FWRITTENOFFSTATUS_DFWRITTENOFFSTATUS_DstringFWRITTENOFFSTATUS_DOptional111
76FWRITTENOFFAMOUNTFOR_DFWRITTENOFFAMOUNTFOR_DstringFWRITTENOFFAMOUNTFOR_DOptional111
77FCOMMENTFCOMMENTstringFCOMMENTOptional111
78FOPPOSITEBANKACCOUNTFOPPOSITEBANKACCOUNTstringFOPPOSITEBANKACCOUNTOptional111
79FOPPOSITECCOUNTNAMEFOPPOSITECCOUNTNAMEstringFOPPOSITECCOUNTNAMEOptional111
80FRECEIVEITEMFRECEIVEITEMstringFRECEIVEITEMOptional111
81FHANDLINGCHARGEFORFHANDLINGCHARGEFORstringFHANDLINGCHARGEFOROptional111
82FHANDLINGCHARGEFHANDLINGCHARGEstringFHANDLINGCHARGEOptional111
83FREALRECAMOUNTFOR_DFREALRECAMOUNTFOR_DstringFREALRECAMOUNTFOR_DOptional111
84FREALRECAMOUNT_DFREALRECAMOUNT_DstringFREALRECAMOUNT_DOptional111
85FASSTOTALAMOUNTFORFASSTOTALAMOUNTFORstringFASSTOTALAMOUNTFOROptional111
86FRECEIVEITEMTYPEFRECEIVEITEMTYPEstringFRECEIVEITEMTYPEOptional111
87FSaleOrderIDFSaleOrderIDstringFSaleOrderIDOptional111
88FACCOUNTIDFACCOUNTIDstringFACCOUNTID.FNumberOptional111
89FOVERUNDERAMOUNTFORFOVERUNDERAMOUNTFORstringFOVERUNDERAMOUNTFOROptional111
90FOPPOSITEBANKNAMEFOPPOSITEBANKNAMEstringFOPPOSITEBANKNAMEOptional111
91FSETTLENOFSETTLENOstringFSETTLENOOptional111
92FBLENDFBLENDstringFBLENDOptional111
93FPURPOSEIDFPURPOSEIDstringFPURPOSEID.FNumberOptional111
94FOVERUNDERAMOUNTFOVERUNDERAMOUNTstringFOVERUNDERAMOUNTOptional111
95FINNERACCOUNTIDFINNERACCOUNTIDstringFINNERACCOUNTIDOptional111
96FINNERACCOUNTNAMEFINNERACCOUNTNAMEstringFINNERACCOUNTNAMEOptional111
97FReFundAmountFReFundAmountstringFReFundAmountOptional111
98FCashAccountFCashAccountstringFCashAccountOptional111
99FRECAMOUNTFOR_EFRECAMOUNTFOR_EstringFRECAMOUNTFOR_EOptional111
100FRECAMOUNT_EFRECAMOUNT_EstringFRECAMOUNT_EOptional111
101FPOSTDATEFPOSTDATEstringFPOSTDATEOptional111
102FISPOSTFISPOSTstringFISPOSTOptional111
103FMATERIALIDFMATERIALIDstringFMATERIALID.FNumberOptional111
104FMATERIALNAMEFMATERIALNAMEstringFMATERIALNAMEOptional111
105FSALEORDERNOFSALEORDERNOstringFSALEORDERNOOptional111
106FMATERIALSEQFMATERIALSEQstringFMATERIALSEQOptional111
107FORDERENTRYIDFORDERENTRYIDstringFORDERENTRYIDOptional111
108FTOPAYMENTAMOUNTFORFTOPAYMENTAMOUNTFORstringFTOPAYMENTAMOUNTFOROptional111
109FWRITTENOFFAMOUNTFWRITTENOFFAMOUNTstringFWRITTENOFFAMOUNTOptional111
110FNOTVERIFICATEAMOUNTFNOTVERIFICATEAMOUNTstringFNOTVERIFICATEAMOUNTOptional111
111FPRICEUNITIDFPRICEUNITIDstringFPRICEUNITIDOptional111
112FPriceFPricestringFPriceOptional111
113FQtyFQtystringFQtyOptional111
114FCOSTIDFCOSTIDstringFCOSTID.FNumberOptional111
115FCOSTDEPARTMENTIDFCOSTDEPARTMENTIDstringFCOSTDEPARTMENTID.FNumberOptional111
116FCOSTNAMEFCOSTNAMEstringFCOSTNAMEOptional111
117FLinkRowIdFLinkRowIdstringFLinkRowIdOptional111
118FSALEORDERBaseFSALEORDERBasestringFSALEORDERBaseOptional111
119FRECEIVEBILLSRCENTRY_FEntryIDFRECEIVEBILLSRCENTRY_FEntryIDstringFRECEIVEBILLSRCENTRY_FEntryIDOptional111

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1FIDFIDstring1Optional111
2FBillNoFBillNostring1Optional111
3FDOCUMENTSTATUSFDOCUMENTSTATUSstring1Optional111
4FCreatorIdFCreatorIdstring1Optional111
5FAPPROVERIDFAPPROVERIDstring1Optional111
6FCreateDateFCreateDatestring1Optional111
7FSETTLEORGIDFSETTLEORGIDstring1Optional111
8FApproveDateFApproveDatestring1Optional111
9FSALEORGIDFSALEORGIDstring1Optional111
10FEXCHANGETYPEFEXCHANGETYPEstring1Optional111
11FRECEIVEAMOUNTFOR_HFRECEIVEAMOUNTFOR_Hstring1Optional111
12FMAINBOOKCURIDFMAINBOOKCURIDstring1Optional111
13FRECEIVEAMOUNT_HFRECEIVEAMOUNT_Hstring1Optional111
14FCURRENCYIDFCURRENCYIDstring1Optional111
15FDATEFDATEstring1Optional111
16FModifyDateFModifyDatestring1Optional111
17FModifierIdFModifierIdstring1Optional111
18FEXCHANGERATEFEXCHANGERATEstring1Optional111
19FWRITTENOFFSTATUSFWRITTENOFFSTATUSstring1Optional111
20FSALEERIDFSALEERIDstring1Optional111
21FSALEGROUPIDFSALEGROUPIDstring1Optional111
22FSALEDEPTIDFSALEDEPTIDstring1Optional111
23FBillTypeIDFBillTypeIDstring1Optional111
24FREALRECAMOUNTFORFREALRECAMOUNTFORstring1Optional111
25FREALRECAMOUNT_HFREALRECAMOUNT_Hstring1Optional111
26FACCOUNTSYSTEMFACCOUNTSYSTEMstring1Optional111
27FCancelDateFCancelDatestring1Optional111
28FCancelStatusFCancelStatusstring1Optional111
29FCancellerIdFCancellerIdstring1Optional111
30FCONTACTUNITTYPEFCONTACTUNITTYPEstring1Optional111
31FCONTACTUNITFCONTACTUNITstring1Optional111
32FPAYUNITTYPEFPAYUNITTYPEstring1Optional111
33FPAYUNITFPAYUNITstring1Optional111
34FBUSINESSTYPEFBUSINESSTYPEstring1Optional111
35FCreditCheckResultFCreditCheckResultstring1Optional111
36FISINITFISINITstring1Optional111
37FDepartmentFDepartmentstring1Optional111
38FPAYORGIDFPAYORGIDstring1Optional111
39FIsSameOrgFIsSameOrgstring1Optional111
40FSOURCESYSTEMFSOURCESYSTEMstring1Optional111
41FCASHSALEFCASHSALEstring1Optional111
42FSETTLECURFSETTLECURstring1Optional111
43FSETTLERATEFSETTLERATEstring1Optional111
44FRECAMOUNTFORFRECAMOUNTFORstring1Optional111
45FRECAMOUNTFRECAMOUNTstring1Optional111
46FISB2CFISB2Cstring1Optional111
47FWBSETTLENOFWBSETTLENOstring1Optional111
48FIsWriteOffFIsWriteOffstring1Optional111
49FMatchMethodIDFMatchMethodIDstring1Optional111
50FScanPointFScanPointstring1Optional111
51FKDPAYNOFKDPAYNOstring1Optional111
52FREMARKFREMARKstring1Optional111
53FTHIRDBILLNOFTHIRDBILLNOstring1Optional111
54FSETTLEMAINBOOKIDFSETTLEMAINBOOKIDstring1Optional111
55FSETTLEEXCHANGETYPEFSETTLEEXCHANGETYPEstring1Optional111
56FOUTCONTACTIDFOUTCONTACTIDstring1Optional111
57FOUTCONTACTTYPEFOUTCONTACTTYPEstring1Optional111
58FGYACCOUNTWATERIDFGYACCOUNTWATERIDstring1Optional111
59FISCARRYRATEFISCARRYRATEstring1Optional111
60FPRESETBASE1FPRESETBASE1string1Optional111
61FPRESETBASE2FPRESETBASE2string1Optional111
62FPRESETASSISTANT1FPRESETASSISTANT1string1Optional111
63FPRESETASSISTANT2FPRESETASSISTANT2string1Optional111
64FPRESETTEXT1FPRESETTEXT1string1Optional111
65FPRESETTEXT2FPRESETTEXT2string1Optional111
66FISFROMSALORDERFISFROMSALORDERstring1Optional111
67FVirIsSameAcctOrgFVirIsSameAcctOrgstring1Optional111
68FSETTLETYPEIDFSETTLETYPEIDstring1Optional111
69FSETTLERECAMOUNTFORFSETTLERECAMOUNTFORstring1Optional111
70FSETTLEDISTAMOUNTFORFSETTLEDISTAMOUNTFORstring1Optional111
71FRECTOTALAMOUNTFORFRECTOTALAMOUNTFORstring1Optional111
72FSETTLERECAMOUNTFSETTLERECAMOUNTstring1Optional111
73FSETTLEDISTAMOUNTFSETTLEDISTAMOUNTstring1Optional111
74FRECTOTALAMOUNTFRECTOTALAMOUNTstring1Optional111
75FWRITTENOFFSTATUS_DFWRITTENOFFSTATUS_Dstring1Optional111
76FWRITTENOFFAMOUNTFOR_DFWRITTENOFFAMOUNTFOR_Dstring1Optional111
77FCOMMENTFCOMMENTstring1Optional111
78FOPPOSITEBANKACCOUNTFOPPOSITEBANKACCOUNTstring1Optional111
79FOPPOSITECCOUNTNAMEFOPPOSITECCOUNTNAMEstring1Optional111
80FRECEIVEITEMFRECEIVEITEMstring1Optional111
81FHANDLINGCHARGEFORFHANDLINGCHARGEFORstring1Optional111
82FHANDLINGCHARGEFHANDLINGCHARGEstring1Optional111
83FREALRECAMOUNTFOR_DFREALRECAMOUNTFOR_Dstring1Optional111
84FREALRECAMOUNT_DFREALRECAMOUNT_Dstring1Optional111
85FASSTOTALAMOUNTFORFASSTOTALAMOUNTFORstring1Optional111
86FRECEIVEITEMTYPEFRECEIVEITEMTYPEstring1Optional111
87FSaleOrderIDFSaleOrderIDstring1Optional111
88FACCOUNTIDFACCOUNTIDstring1Optional111
89FOVERUNDERAMOUNTFORFOVERUNDERAMOUNTFORstring1Optional111
90FOPPOSITEBANKNAMEFOPPOSITEBANKNAMEstring1Optional111
91FSETTLENOFSETTLENOstring1Optional111
92FBLENDFBLENDstring1Optional111
93FPURPOSEIDFPURPOSEIDstring1Optional111
94FOVERUNDERAMOUNTFOVERUNDERAMOUNTstring1Optional111
95FINNERACCOUNTIDFINNERACCOUNTIDstring1Optional111
96FINNERACCOUNTNAMEFINNERACCOUNTNAMEstring1Optional111
97FReFundAmountFReFundAmountstring1Optional111
98FCashAccountFCashAccountstring1Optional111
99FRECAMOUNTFOR_EFRECAMOUNTFOR_Estring1Optional111
100FRECAMOUNT_EFRECAMOUNT_Estring1Optional111
101FPOSTDATEFPOSTDATEstring1Optional111
102FISPOSTFISPOSTstring1Optional111
103FMATERIALIDFMATERIALIDstring1Optional111
104FMATERIALNAMEFMATERIALNAMEstring1Optional111
105FSALEORDERNOFSALEORDERNOstring1Optional111
106FMATERIALSEQFMATERIALSEQstring1Optional111
107FORDERENTRYIDFORDERENTRYIDstring1Optional111
108FTOPAYMENTAMOUNTFORFTOPAYMENTAMOUNTFORstring1Optional111
109FWRITTENOFFAMOUNTFWRITTENOFFAMOUNTstring1Optional111
110FNOTVERIFICATEAMOUNTFNOTVERIFICATEAMOUNTstring1Optional111
111FPRICEUNITIDFPRICEUNITIDstring1Optional111
112FPriceFPricestring1Optional111
113FQtyFQtystring1Optional111
114FCOSTIDFCOSTIDstring1Optional111
115FCOSTDEPARTMENTIDFCOSTDEPARTMENTIDstring1Optional111
116FCOSTNAMEFCOSTNAMEstring1Optional111
117FLinkRowIdFLinkRowIdstring1Optional111
118FSALEORDERBaseFSALEORDERBasestring1Optional111
119FRECEIVEBILLSRCENTRY_FEntryIDFRECEIVEBILLSRCENTRY_FEntryIDstring1Optional111

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.