轻易云
注册体验

金蝶云星空付款退款单查询_v1接口

所属平台
金蝶云星空
类型
WebAPI
作用
QUERY
接口版本
0.1
适配器
\Adapter\K3Cloud\K3CloudQueryAdapter
授权方式
OTHER
更新日期
2022-03-29

付款退款单查询_v1

POSTexecuteBillQuery
加工厂
{
  "operation": {
    "method": "none"
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1FAFTTAXTOTALAMOUNTFAFTTAXTOTALAMOUNTstringFAFTTAXTOTALAMOUNT可选应退金额
2FIDFIDstringFID可选实体主键
3FSRCSETTLETYPEIDFSRCSETTLETYPEIDstringFSRCSETTLETYPEID可选结算方式
4FBillNoFBillNostringFBillNo可选单据编号
5FDOCUMENTSTATUSFDOCUMENTSTATUSstringFDOCUMENTSTATUS必填单据状态
6FREALREFUNDAMOUNT_SFREALREFUNDAMOUNT_SstringFREALREFUNDAMOUNT_S可选本次退款金额
7FCreaterIdFCreaterIdstringFCreaterId可选创建人
8FSRCBILLIDFSRCBILLIDstringFSRCBILLID可选源单内码
9FSRCROWIDFSRCROWIDstringFSRCROWID可选源单行内码
10FCreateDateFCreateDatestringFCreateDate可选创建日期
11FSRCSEQFSRCSEQstringFSRCSEQ可选源单行号
12FSETTLEORGIDFSETTLEORGIDstringFSETTLEORGID.FNumber必填结算组织
13FApproveDateFApproveDatestringFApproveDate可选审核日期
14FPLANREFUNDAMOUNTFPLANREFUNDAMOUNTstringFPLANREFUNDAMOUNT可选计划退款金额
15FPURCHASEORGIDFPURCHASEORGIDstringFPURCHASEORGID.FNumber可选采购组织
16FSRCCURRENCYIDFSRCCURRENCYIDstringFSRCCURRENCYID.FNumber可选源单结算币别
17FSOURCETYPEFSOURCETYPEstringFSOURCETYPE可选源单类型
18FEXCHANGETYPEFEXCHANGETYPEstringFEXCHANGETYPE可选汇率类型
19FSRCBILLNOFSRCBILLNOstringFSRCBILLNO可选源单编号
20FMAINBOOKCURRIDFMAINBOOKCURRIDstringFMAINBOOKCURRID可选本位币
21FEXPIRYFEXPIRYstringFEXPIRY可选到期日
22FREFUNDTOTALAMOUNTFREFUNDTOTALAMOUNTstringFREFUNDTOTALAMOUNT可选应退金额本位币
23FPAYPURPOSEIDFPAYPURPOSEIDstringFPAYPURPOSEID.FNumber可选付款用途
24FDATEFDATEstringFDATE必填业务日期
25FSRCMATERIALIDFSRCMATERIALIDstringFSRCMATERIALID.FNumber可选物料编码
26FCURRENCYIDFCURRENCYIDstringFCURRENCYID.FNumber必填币别
27FModifyDateFModifyDatestringFModifyDate可选修改日期
28FSRCPURCHASEORDERNOFSRCPURCHASEORDERNOstringFSRCPURCHASEORDERNO可选采购订单号
29FModifierIdFModifierIdstringFModifierId可选修改人
30FEXCHANGERATEFEXCHANGERATEstringFEXCHANGERATE可选汇率
31FSRCMATERIALSEQFSRCMATERIALSEQstringFSRCMATERIALSEQ可选采购订单行号
32FWRITTENOFFSTATUSFWRITTENOFFSTATUSstringFWRITTENOFFSTATUS可选核销状态
33FSRCORDERENTRYIDFSRCORDERENTRYIDstringFSRCORDERENTRYID可选采购订单明细内码
34FSRCPRICEUNITIDFSRCPRICEUNITIDstringFSRCPRICEUNITID可选计价单位
35FBillTypeIDFBillTypeIDstringFBillTypeID.FNumber必填单据类型
36FSRCPRICEFSRCPRICEstringFSRCPRICE可选含税单价
37FREFUNDTOTALAMOUNTFORFREFUNDTOTALAMOUNTFORstringFREFUNDTOTALAMOUNTFOR可选表头-应退金额
38FPurchaserIdFPurchaserIdstringFPurchaserId可选采购员
39FSRCQTYFSRCQTYstringFSRCQTY可选数量
40FEXPENSEDEPTIDFEXPENSEDEPTIDstringFEXPENSEDEPTID.FNumber可选费用承担部门
41FPurchaserGroupIdFPurchaserGroupIdstringFPurchaserGroupId可选采购组
42FExpIDFExpIDstringFExpID可选费用项目
43FPurchaseDeptIdFPurchaseDeptIdstringFPurchaseDeptId可选采购部门
44FAPPROVERIDFAPPROVERIDstringFAPPROVERID可选审核人
45FTaxAmtFTaxAmtstringFTaxAmt可选税额
46FPREPAYORDERNOFPREPAYORDERNOstringFPREPAYORDERNO可选预付采购订单号
47FREALREFUNDAMOUNTFORFREALREFUNDAMOUNTFORstringFREALREFUNDAMOUNTFOR可选表头-实退金额
48FREALREFUNDAMOUNTMBFREALREFUNDAMOUNTMBstringFREALREFUNDAMOUNTMB可选本次退款金额本位币
49FREALREFUNDAMOUNTFREALREFUNDAMOUNTstringFREALREFUNDAMOUNT可选实退金额本位币
50FSETTLEAMOUNTFSETTLEAMOUNTstringFSETTLEAMOUNT可选结算金额
51FACCOUNTSYSTEMFACCOUNTSYSTEMstringFACCOUNTSYSTEM可选会计核算体系
52FCancellerIdFCancellerIdstringFCancellerId可选作废人
53FCancelStatusFCancelStatusstringFCancelStatus必填作废状态
54FCancelDateFCancelDatestringFCancelDate可选作废日期
55FCONTACTUNITTYPEFCONTACTUNITTYPEstringFCONTACTUNITTYPE必填往来单位类型
56FCONTACTUNITFCONTACTUNITstringFCONTACTUNIT.FNumber必填往来单位
57FPAYUNITTYPEFPAYUNITTYPEstringFPAYUNITTYPE必填付款单位类型
58FPAYUNITFPAYUNITstringFPAYUNIT.FNumber必填付款单位
59FSOURCESYSTEMFSOURCESYSTEMstringFSOURCESYSTEM可选来源系统
60FBUSINESSTYPEFBUSINESSTYPEstringFBUSINESSTYPE必填业务类型
61FISINITFISINITstringFISINIT可选是否期初单据
62FDepartmentFDepartmentstringFDepartment.FNumber可选部门
63FPAYORGIDFPAYORGIDstringFPAYORGID.FNumber必填付款组织
64FISSAMEORGFISSAMEORGstringFISSAMEORG可选是否相同组织
65FSETTLECURFSETTLECURstringFSETTLECUR必填结算币别
66FSETTLERATEFSETTLERATEstringFSETTLERATE可选结算汇率
67FREFUNDAMOUNTFOR_HFREFUNDAMOUNTFOR_HstringFREFUNDAMOUNTFOR_H可选退款金额
68FREFUNDAMOUNT_HFREFUNDAMOUNT_HstringFREFUNDAMOUNT_H可选表头-退款金额本位币
69FIsWriteOffFIsWriteOffstringFIsWriteOff可选是否转销
70FMatchMethodIDFMatchMethodIDstringFMatchMethodID可选核销方式
71FScanPointFScanPointstringFScanPoint可选扫描点
72FISFROMALLREFUNDFISFROMALLREFUNDstringFISFROMALLREFUND可选是否来源于整单退款
73FREMARKFREMARKstringFREMARK可选备注
74FSETTLEMAINBOOKIDFSETTLEMAINBOOKIDstringFSETTLEMAINBOOKID.FNumber必填结算本位币
75FSETTLEEXCHANGETYPEFSETTLEEXCHANGETYPEstringFSETTLEEXCHANGETYPE可选结算汇率类型
76FTHIRDBILLNOFTHIRDBILLNOstringFTHIRDBILLNO可选第三方单据编号
77FWBSETTLENOFWBSETTLENOstringFWBSETTLENO可选流水号
78FGYACCOUNTWATERIDFGYACCOUNTWATERIDstringFGYACCOUNTWATERID可选管易财务流水内码
79FISCARRYRATEFISCARRYRATEstringFISCARRYRATE可选是否下推携带汇率到结算汇率
80FGYSHOPNAMEFGYSHOPNAMEstringFGYSHOPNAME可选管易对应店铺
81FGYCUSTOMERIDFGYCUSTOMERIDstringFGYCUSTOMERID可选管易对应客户
82FPRESETBASE1FPRESETBASE1stringFPRESETBASE1可选预设基础资料字段1
83FPRESETBASE2FPRESETBASE2stringFPRESETBASE2可选预设基础资料字段2
84FPRESETASSISTANT1FPRESETASSISTANT1stringFPRESETASSISTANT1可选预设辅助资料字段1
85FPRESETASSISTANT2FPRESETASSISTANT2stringFPRESETASSISTANT2可选预设辅助资料字段2
86FPRESETTEXT1FPRESETTEXT1stringFPRESETTEXT1可选预设文本字段1
87FPRESETTEXT2FPRESETTEXT2stringFPRESETTEXT2可选预设文本字段2
88FSETTLETYPEIDFSETTLETYPEIDstringFSETTLETYPEID.FNumber可选结算方式
89FREFUNDAMOUNTFORFREFUNDAMOUNTFORstringFREFUNDAMOUNTFOR可选表体-应退金额
90FNOTEFNOTEstringFNOTE可选备注
91FWRITTENOFFSTATUS_DFWRITTENOFFSTATUS_DstringFWRITTENOFFSTATUS_D可选表体明细-核销状态
92FWRITTENOFFAMOUNTFOR_DFWRITTENOFFAMOUNTFOR_DstringFWRITTENOFFAMOUNTFOR_D可选表体明细-已核销金额
93FOPPOSITECCOUNTNAMEFOPPOSITECCOUNTNAMEstringFOPPOSITECCOUNTNAME可选对方账户名称
94FOPPOSITEBANKACCOUNTFOPPOSITEBANKACCOUNTstringFOPPOSITEBANKACCOUNT可选对方银行账号
95FREFUNDAMOUNTFREFUNDAMOUNTstringFREFUNDAMOUNT可选应退金额本位币
96FHANDLINGCHARGEFORFHANDLINGCHARGEFORstringFHANDLINGCHARGEFOR可选手续费
97FREALREFUNDAMOUNTFOR_DFREALREFUNDAMOUNTFOR_DstringFREALREFUNDAMOUNTFOR_D可选表体-实退金额
98FHANDLINGCHARGEFHANDLINGCHARGEstringFHANDLINGCHARGE可选手续费本位币
99FREALREFUNDAMOUNT_DFREALREFUNDAMOUNT_DstringFREALREFUNDAMOUNT_D可选实退金额本位币
100FACCOUNTIDFACCOUNTIDstringFACCOUNTID.FNumber可选我方银行账号
101FACCOUNTNAMEFACCOUNTNAMEstringFACCOUNTNAME可选我方账户名称
102FSETTLENOFSETTLENOstringFSETTLENO可选结算号
103FBLENDFBLENDstringFBLEND可选勾对
104FOPPOSITEBANKNAMEFOPPOSITEBANKNAMEstringFOPPOSITEBANKNAME可选对方开户行
105FPURPOSEIDFPURPOSEIDstringFPURPOSEID必填原付款用途
106FINNERACCOUNTIDFINNERACCOUNTIDstringFINNERACCOUNTID可选内部账号
107FINNERACCOUNTNAMEFINNERACCOUNTNAMEstringFINNERACCOUNTNAME可选内部账户名称
108FCOSTIDFCOSTIDstringFCOSTID.FNumber可选费用项目
109FCashAccountFCashAccountstringFCashAccount可选现金账号
110FREFUNDAMOUNTFOR_EFREFUNDAMOUNTFOR_EstringFREFUNDAMOUNTFOR_E可选退款金额
111FREFUNDAMOUNT_EFREFUNDAMOUNT_EstringFREFUNDAMOUNT_E可选退款金额本位币
112FPOSTDATEFPOSTDATEstringFPOSTDATE必填登账日期
113FISPOSTFISPOSTstringFISPOST可选是否登账
114FPURCHASEORDERNOFPURCHASEORDERNOstringFPURCHASEORDERNO可选采购订单号(预付订单号)
115FPURCHASEORDERIDFPURCHASEORDERIDstringFPURCHASEORDERID可选采购订单内码
116FMATERIALIDFMATERIALIDstringFMATERIALID.FNumber可选物料编码
117FMATERIALSEQFMATERIALSEQstringFMATERIALSEQ可选采购订单行号
118FORDERENTRYIDFORDERENTRYIDstringFORDERENTRYID可选采购订单明细内码
119FPURCHASEORDERNUMBERFPURCHASEORDERNUMBERstringFPURCHASEORDERNUMBER可选采购订单编号(按物料和订单收付)
120FPRICEUNITIDFPRICEUNITIDstringFPRICEUNITID可选计价单位
121FPRICEFPRICEstringFPRICE可选含税单价
122FQTYFQTYstringFQTY可选数量
123FWRITTENOFFAMOUNTFWRITTENOFFAMOUNTstringFWRITTENOFFAMOUNT可选已核销金额本位币
124FGYSALEORDERNOFGYSALEORDERNOstringFGYSALEORDERNO可选管易销售订单号
125FNOTVERIFICATEAMOUNTFNOTVERIFICATEAMOUNTstringFNOTVERIFICATEAMOUNT可选未核销金额
126FEXPENSEDEPTID_EFEXPENSEDEPTID_EstringFEXPENSEDEPTID_E可选费用承担部门
127FREFUNDBILLENTRY_FEntryIDFREFUNDBILLENTRY_FEntryIDstringFREFUNDBILLENTRY_FEntryID可选111

接口响应参数

序号字段名称类型默认值必填描述
1FAFTTAXTOTALAMOUNTFAFTTAXTOTALAMOUNTstring1可选应退金额
2FIDFIDstring1可选实体主键
3FSRCSETTLETYPEIDFSRCSETTLETYPEIDstring1可选结算方式
4FBillNoFBillNostring1可选单据编号
5FREALREFUNDAMOUNT_SFREALREFUNDAMOUNT_Sstring1可选本次退款金额
6FDOCUMENTSTATUSFDOCUMENTSTATUSstring1必填单据状态
7FSRCBILLIDFSRCBILLIDstring1可选源单内码
8FCreaterIdFCreaterIdstring1可选创建人
9FCreateDateFCreateDatestring1可选创建日期
10FSRCROWIDFSRCROWIDstring1可选源单行内码
11FSETTLEORGIDFSETTLEORGIDstring1必填结算组织
12FSRCSEQFSRCSEQstring1可选源单行号
13FPLANREFUNDAMOUNTFPLANREFUNDAMOUNTstring1可选计划退款金额
14FApproveDateFApproveDatestring1可选审核日期
15FPURCHASEORGIDFPURCHASEORGIDstring1可选采购组织
16FSRCCURRENCYIDFSRCCURRENCYIDstring1可选源单结算币别
17FEXCHANGETYPEFEXCHANGETYPEstring1可选汇率类型
18FSOURCETYPEFSOURCETYPEstring1可选源单类型
19FMAINBOOKCURRIDFMAINBOOKCURRIDstring1可选本位币
20FSRCBILLNOFSRCBILLNOstring1可选源单编号
21FREFUNDTOTALAMOUNTFREFUNDTOTALAMOUNTstring1可选应退金额本位币
22FEXPIRYFEXPIRYstring1可选到期日
23FDATEFDATEstring1必填业务日期
24FPAYPURPOSEIDFPAYPURPOSEIDstring1可选付款用途
25FSRCMATERIALIDFSRCMATERIALIDstring1可选物料编码
26FCURRENCYIDFCURRENCYIDstring1必填币别
27FModifyDateFModifyDatestring1可选修改日期
28FModifierIdFModifierIdstring1可选修改人
29FSRCPURCHASEORDERNOFSRCPURCHASEORDERNOstring1可选采购订单号
30FEXCHANGERATEFEXCHANGERATEstring1可选汇率
31FSRCMATERIALSEQFSRCMATERIALSEQstring1可选采购订单行号
32FWRITTENOFFSTATUSFWRITTENOFFSTATUSstring1可选核销状态
33FSRCORDERENTRYIDFSRCORDERENTRYIDstring1可选采购订单明细内码
34FBillTypeIDFBillTypeIDstring1必填单据类型
35FSRCPRICEUNITIDFSRCPRICEUNITIDstring1可选计价单位
36FSRCPRICEFSRCPRICEstring1可选含税单价
37FREFUNDTOTALAMOUNTFORFREFUNDTOTALAMOUNTFORstring1可选表头-应退金额
38FPurchaserIdFPurchaserIdstring1可选采购员
39FSRCQTYFSRCQTYstring1可选数量
40FPurchaserGroupIdFPurchaserGroupIdstring1可选采购组
41FEXPENSEDEPTIDFEXPENSEDEPTIDstring1可选费用承担部门
42FExpIDFExpIDstring1可选费用项目
43FPurchaseDeptIdFPurchaseDeptIdstring1可选采购部门
44FAPPROVERIDFAPPROVERIDstring1可选审核人
45FTaxAmtFTaxAmtstring1可选税额
46FPREPAYORDERNOFPREPAYORDERNOstring1可选预付采购订单号
47FREALREFUNDAMOUNTFORFREALREFUNDAMOUNTFORstring1可选表头-实退金额
48FREALREFUNDAMOUNTFREALREFUNDAMOUNTstring1可选实退金额本位币
49FREALREFUNDAMOUNTMBFREALREFUNDAMOUNTMBstring1可选本次退款金额本位币
50FSETTLEAMOUNTFSETTLEAMOUNTstring1可选结算金额
51FACCOUNTSYSTEMFACCOUNTSYSTEMstring1可选会计核算体系
52FCancellerIdFCancellerIdstring1可选作废人
53FCancelStatusFCancelStatusstring1必填作废状态
54FCancelDateFCancelDatestring1可选作废日期
55FCONTACTUNITTYPEFCONTACTUNITTYPEstring1必填往来单位类型
56FCONTACTUNITFCONTACTUNITstring1必填往来单位
57FPAYUNITTYPEFPAYUNITTYPEstring1必填付款单位类型
58FPAYUNITFPAYUNITstring1必填付款单位
59FSOURCESYSTEMFSOURCESYSTEMstring1可选来源系统
60FBUSINESSTYPEFBUSINESSTYPEstring1必填业务类型
61FISINITFISINITstring1可选是否期初单据
62FDepartmentFDepartmentstring1可选部门
63FPAYORGIDFPAYORGIDstring1必填付款组织
64FISSAMEORGFISSAMEORGstring1可选是否相同组织
65FSETTLECURFSETTLECURstring1必填结算币别
66FSETTLERATEFSETTLERATEstring1可选结算汇率
67FREFUNDAMOUNTFOR_HFREFUNDAMOUNTFOR_Hstring1可选退款金额
68FREFUNDAMOUNT_HFREFUNDAMOUNT_Hstring1可选表头-退款金额本位币
69FIsWriteOffFIsWriteOffstring1可选是否转销
70FMatchMethodIDFMatchMethodIDstring1可选核销方式
71FScanPointFScanPointstring1可选扫描点
72FISFROMALLREFUNDFISFROMALLREFUNDstring1可选是否来源于整单退款
73FREMARKFREMARKstring1可选备注
74FSETTLEMAINBOOKIDFSETTLEMAINBOOKIDstring1必填结算本位币
75FSETTLEEXCHANGETYPEFSETTLEEXCHANGETYPEstring1可选结算汇率类型
76FTHIRDBILLNOFTHIRDBILLNOstring1可选第三方单据编号
77FWBSETTLENOFWBSETTLENOstring1可选流水号
78FGYACCOUNTWATERIDFGYACCOUNTWATERIDstring1可选管易财务流水内码
79FISCARRYRATEFISCARRYRATEstring1可选是否下推携带汇率到结算汇率
80FGYSHOPNAMEFGYSHOPNAMEstring1可选管易对应店铺
81FGYCUSTOMERIDFGYCUSTOMERIDstring1可选管易对应客户
82FPRESETBASE1FPRESETBASE1string1可选预设基础资料字段1
83FPRESETBASE2FPRESETBASE2string1可选预设基础资料字段2
84FPRESETASSISTANT1FPRESETASSISTANT1string1可选预设辅助资料字段1
85FPRESETASSISTANT2FPRESETASSISTANT2string1可选预设辅助资料字段2
86FPRESETTEXT1FPRESETTEXT1string1可选预设文本字段1
87FPRESETTEXT2FPRESETTEXT2string1可选预设文本字段2
88FSETTLETYPEIDFSETTLETYPEIDstring1可选结算方式
89FREFUNDAMOUNTFORFREFUNDAMOUNTFORstring1可选表体-应退金额
90FNOTEFNOTEstring1可选备注
91FWRITTENOFFSTATUS_DFWRITTENOFFSTATUS_Dstring1可选表体明细-核销状态
92FWRITTENOFFAMOUNTFOR_DFWRITTENOFFAMOUNTFOR_Dstring1可选表体明细-已核销金额
93FOPPOSITECCOUNTNAMEFOPPOSITECCOUNTNAMEstring1可选对方账户名称
94FOPPOSITEBANKACCOUNTFOPPOSITEBANKACCOUNTstring1可选对方银行账号
95FREFUNDAMOUNTFREFUNDAMOUNTstring1可选应退金额本位币
96FHANDLINGCHARGEFORFHANDLINGCHARGEFORstring1可选手续费
97FREALREFUNDAMOUNTFOR_DFREALREFUNDAMOUNTFOR_Dstring1可选表体-实退金额
98FHANDLINGCHARGEFHANDLINGCHARGEstring1可选手续费本位币
99FREALREFUNDAMOUNT_DFREALREFUNDAMOUNT_Dstring1可选实退金额本位币
100FACCOUNTIDFACCOUNTIDstring1可选我方银行账号
101FACCOUNTNAMEFACCOUNTNAMEstring1可选我方账户名称
102FSETTLENOFSETTLENOstring1可选结算号
103FBLENDFBLENDstring1可选勾对
104FOPPOSITEBANKNAMEFOPPOSITEBANKNAMEstring1可选对方开户行
105FPURPOSEIDFPURPOSEIDstring1必填原付款用途
106FINNERACCOUNTIDFINNERACCOUNTIDstring1可选内部账号
107FINNERACCOUNTNAMEFINNERACCOUNTNAMEstring1可选内部账户名称
108FCOSTIDFCOSTIDstring1可选费用项目
109FCashAccountFCashAccountstring1可选现金账号
110FREFUNDAMOUNTFOR_EFREFUNDAMOUNTFOR_Estring1可选退款金额
111FREFUNDAMOUNT_EFREFUNDAMOUNT_Estring1可选退款金额本位币
112FPOSTDATEFPOSTDATEstring1必填登账日期
113FISPOSTFISPOSTstring1可选是否登账
114FPURCHASEORDERNOFPURCHASEORDERNOstring1可选采购订单号(预付订单号)
115FPURCHASEORDERIDFPURCHASEORDERIDstring1可选采购订单内码
116FMATERIALIDFMATERIALIDstring1可选物料编码
117FMATERIALSEQFMATERIALSEQstring1可选采购订单行号
118FORDERENTRYIDFORDERENTRYIDstring1可选采购订单明细内码
119FPURCHASEORDERNUMBERFPURCHASEORDERNUMBERstring1可选采购订单编号(按物料和订单收付)
120FPRICEUNITIDFPRICEUNITIDstring1可选计价单位
121FPRICEFPRICEstring1可选含税单价
122FQTYFQTYstring1可选数量
123FWRITTENOFFAMOUNTFWRITTENOFFAMOUNTstring1可选已核销金额本位币
124FGYSALEORDERNOFGYSALEORDERNOstring1可选管易销售订单号
125FNOTVERIFICATEAMOUNTFNOTVERIFICATEAMOUNTstring1可选未核销金额
126FEXPENSEDEPTID_EFEXPENSEDEPTID_Estring1可选费用承担部门
127FREFUNDBILLENTRY_FEntryIDFREFUNDBILLENTRY_FEntryIDstring1可选111

金蝶云星空的接口:付款退款单查询_v1(executeBillQuery),由轻易云数据集成平台 API 资产管理模块整理收纳,并随金蝶云星空版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。