Qeasy Cloud
Get Started

金蝶云星空 应付单查询V4.0 API

Type
QUERY
Effect
QUERY
API Version
1.0
Adapter
\Adapter\K3Cloud\K3CloudQueryAdapter
Auth Mode
OTHER
Updated At
2023-11-09

应付单查询V4.0

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

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1FID实体主键stringFIDRequired实体主键
2FBillNo单据编号stringFBillNoRequired单据编号
3FDOCUMENTSTATUS单据状态stringFDOCUMENTSTATUSRequired单据状态 暂存:Z 创建:A 审核中:B 已审核:C 重新审核:D
4FDATE业务日期stringFDATERequired业务日期
5FSETTLEORGID_FNumber结算组织stringFSETTLEORGID.FNumberRequired结算组织
6FCURRENCYID_FNumber币别stringFCURRENCYID.FNumberOptional币别
7FBillTypeID_FNumber单据类型stringFBillTypeID.FNumberRequired单据类型:1.标准应付单:YFD01_SYS 2.标准应付单:YFD02_SYS 3.资产调拨应付:YFD03_SYS 4.转销应付单:YFD04_SYS
8FAPPROVEDATE审核日期stringFAPPROVEDATEOptional审核日期
9FALLAMOUNTFOR价税合计stringFALLAMOUNTFOROptional价税合计
10FENDDATE_H到期日stringFENDDATE_HOptional到期日
11FPayConditon付款条件stringFPayConditonOptional付款条件
12FSUPPLIERID_FNumber供应商stringFSUPPLIERID.FNumberOptional供应商
13FPURCHASEORGID采购组织stringFPURCHASEORGIDOptional采购组织
14FBUSINESSTYPE业务类型stringFBUSINESSTYPEOptional业务类型 ZC-资产采购 FY-费用采购 CG-普通采购
15FSourceBillType源单类型stringFSourceBillTypeOptional源单类型
16FPAYORGID_FNumber付款组织stringFPAYORGID.FNumberOptional付款组织
17FAP_Remark备注stringFAP_RemarkOptional备注
18FMATERIALID_FNumber物料编码stringFMATERIALID.FNumberOptional物料编码
19FMaterialName物料名称stringFMaterialNameOptional物料名称
20FModel规格型号stringFModelOptional规格型号
21FMaterialType物料类别stringFMaterialTypeOptional物料类别
22FPrice单价stringFPriceOptional单价
23FTaxPrice含税单价stringFTaxPriceOptional含税单价
24FPriceQty计价数量stringFPriceQtyOptional计价数量
25FEntryTaxRate税率stringFEntryTaxRateOptional税率
26FTAXAMOUNTFOR_D税额stringFTAXAMOUNTFOR_DOptional税额
27FALLAMOUNTFOR_D价税合计stringFALLAMOUNTFOR_DOptional价税合计
28FComment备注stringFCommentOptional备注
29FBASICUNITID基本单位stringFBASICUNITIDOptional基本单位
30FSOURCETYPE源单类型stringFSOURCETYPEOptional源单类型
31FSourceBillNo源单编号stringFSourceBillNoOptional源单编号
32FIsFree是否赠品stringFIsFreeOptional是否赠品
33FSettleTypeID_FNumber结算方式stringFSettleTypeID.FNumberOptional结算方式
34FPAYAMOUNTFOR应付金额floatFPAYAMOUNTFOROptional应付金额

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1FID实体主键string—Optional实体主键
2FBillNo单据编号string—Optional单据编号
3FDOCUMENTSTATUS单据状态string—Optional单据状态 暂存:Z 创建:A 审核中:B 已审核:C 重新审核:D
4FDATE业务日期datetime—Optional业务日期
5FSETTLEORGID_FNumber结算组织string—Optional结算组织
6FCURRENCYID_FNumber币别string—Optional币别
7FBillTypeID_FNumber单据类型string—Optional单据类型:1.标准应付单:YFD01_SYS 2.标准应付单:YFD02_SYS 3.资产调拨应付:YFD03_SYS 4.转销应付单:YFD04_SYS
8FAPPROVEDATE审核日期datetime—Optional审核日期
9FALLAMOUNTFOR价税合计string—Optional价税合计
10FENDDATE_H到期日datetime—Optional到期日
11FPayConditon付款条件string—Optional付款条件
12FSUPPLIERID_FNumber供应商string—Optional供应商
13FPURCHASEORGID采购组织string—Optional采购组织
14FBUSINESSTYPE业务类型string—Optional业务类型 ZC-资产采购 FY-费用采购 CG-普通采购
15FSourceBillType源单类型string—Optional源单类型
16FPAYORGID_FNumber付款组织string—Optional付款组织
17FAP_Remark备注string—Optional备注
18FMATERIALID_FNumber物料编码string—Optional物料编码
19FMaterialName物料名称string—Optional物料名称
20FModel规格型号string—Optional规格型号
21FMaterialType物料类别string—Optional物料类别
22FPrice单价float—Optional单价
23FTaxPrice含税单价float—Optional含税单价
24FPriceQty计价数量float—Optional计价数量
25FEntryTaxRate税率(%)string—Optional税率(%)
26FTAXAMOUNTFOR_D税额float—Optional税额
27FALLAMOUNTFOR_D价税合计float—Optional价税合计
28FComment备注string—Optional备注
29FBASICUNITID基本单位string—Optional基本单位
30FSOURCETYPE源单类型string—Optional源单类型
31FSourceBillNo源单编号string—Optional源单编号
32FIsFree是否赠品string—Optional是否赠品
33FSettleTypeID_FNumber结算方式string—Optional结算方式
34FPAYAMOUNTFOR应付金额float—Optional应付金额

The 应付单查询V4.0 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.