executeBillQuery{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FBillTypeID_FNumber | FBillTypeID_FNumber | string | FBillTypeID.FNumber | Required | 单据类型 |
| 2 | FBillNo | FBillNo | string | FBillNo | Required | 单据编号 |
| 3 | FDate | FDate | string | FDate | Required | 日期 |
| 4 | FSaleOrgId_FNumber | FSaleOrgId_FNumber | string | FSaleOrgId.FNumber | Required | 组织 |
| 5 | FCustomerID_FNumber | FCustomerID_FNumber | string | FCustomerID.FNumber | Required | 基础资料 |
| 6 | FCarriageNO | FCarriageNO | string | FCarriageNO | Optional | 文本 |
| 7 | FStockOrgId_FNumber | FStockOrgId_FNumber | string | FStockOrgId.FNumber | Optional | 组织 |
| 8 | FLinkPhone | FLinkPhone | string | FLinkPhone | Optional | 文本 |
| 9 | FLinkMan | FLinkMan | string | FLinkMan | Optional | 文本 |
| 10 | FReceiveAddress | FReceiveAddress | string | FReceiveAddress | Optional | 文本 |
| 11 | FSettleTypeID_FNumber | FSettleTypeID_FNumber | string | FSettleTypeID.FNumber | Optional | 基础资料 |
| 12 | FReceiverAddress | FReceiverAddress | string | FReceiverAddress | Optional | 文本 |
| 13 | FReceiverMobile | FReceiverMobile | string | FReceiverMobile | Optional | 文本 |
| 14 | FReceiverCountry | FReceiverCountry | string | FReceiverCountry | Optional | 文本 |
| 15 | FReceiverState | FReceiverState | string | FReceiverState | Optional | 文本 |
| 16 | FReceiverCity | FReceiverCity | string | FReceiverCity | Optional | 文本 |
| 17 | FReceiverDistrict | FReceiverDistrict | string | FReceiverDistrict | Optional | 文本 |
| 18 | FReceiverPhone | FReceiverPhone | string | FReceiverPhone | Optional | 文本 |
| 19 | FSHOPNUMBER | FSHOPNUMBER | string | FSHOPNUMBER | Optional | 文本 |
| 20 | FSALECHANNEL | FSALECHANNEL | string | FSALECHANNEL | Optional | 文本 |
| 21 | FVIPCODE | FVIPCODE | string | FVIPCODE | Optional | 文本 |
| 22 | FCustMatID_FNumber | FCustMatID_FNumber | string | FCustMatID.FNumber | Optional | 基础资料 |
| 23 | FMaterialID_FNumber | FMaterialID_FNumber | string | FMaterialID.FNumber | Optional | 基础资料 |
| 24 | FBarcode | FBarcode | string | FBarcode | Optional | 文本 |
| 25 | FMustQty | FMustQty | string | FMustQty | Optional | 数量 |
| 26 | FRealQty | FRealQty | string | FRealQty | Optional | 数量 |
| 27 | FPrice | FPrice | string | FPrice | Optional | 单价 |
| 28 | FTaxPrice | FTaxPrice | string | FTaxPrice | Optional | 单价 |
| 29 | FIsFree | FIsFree | string | FIsFree | Optional | 复选框 |
| 30 | FLot | FLot | string | FLot | Optional | 批次 |
| 31 | FProduceDate | FProduceDate | string | FProduceDate | Optional | 日期 |
| 32 | FExpiryDate | FExpiryDate | string | FExpiryDate | Optional | 日期 |
| 33 | FEntryTaxRate | FEntryTaxRate | string | FEntryTaxRate | Optional | 小数 |
| 34 | FEntryTaxAmount | FEntryTaxAmount | string | FEntryTaxAmount | Optional | 金额 |
| 35 | FAmount | FAmount | string | FAmount | Optional | 金额 |
| 36 | FAllAmount | FAllAmount | string | FAllAmount | Optional | 金额 |
| 37 | FStockID_FNumber | FStockID_FNumber | string | FStockID.FNumber | Optional | 基础资料 |
| 38 | FStockStatusID_FNumber | FStockStatusID_FNumber | string | FStockStatusID.FNumber | Optional | 基础资料 |
| 39 | FMtoNo | FMtoNo | string | FMtoNo | Optional | 文本 |
| 40 | FEntrynote | FEntrynote | string | FEntrynote | Optional | 文本 |
| 41 | FSrcType | FSrcType | string | FSrcType | Optional | 源单类型 |
| 42 | FSrcBillNo | FSrcBillNo | string | FSrcBillNo | Optional | 源单编号 |
| 43 | FSoorDerno | FSoorDerno | string | FSoorDerno | Optional | 文本 |
| 44 | FDiscountRate | FDiscountRate | string | FDiscountRate | Optional | 小数 |
| 45 | FDiscount | FDiscount | string | FDiscount | Optional | 折扣额 |
| 46 | FPriceDiscount | FPriceDiscount | string | FPriceDiscount | Optional | 单价 |
| 47 | FSOEntryId | FSOEntryId | string | FSOEntryId | Optional | 整数 |
| 48 | FB2CORDERDETAILID | FB2CORDERDETAILID | string | FB2CORDERDETAILID | Optional | 整数 |
| 49 | FThirdEntryId | FThirdEntryId | string | FThirdEntryId | Optional | 文本 |
| 50 | FETHIRDBILLID | FETHIRDBILLID | string | FETHIRDBILLID | Optional | 文本 |
| 51 | FETHIRDBILLNO | FETHIRDBILLNO | string | FETHIRDBILLNO | Optional | 文本 |
| 52 | FGYFINDate | FGYFINDate | string | FGYFINDate | Optional | 长日期 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FBillTypeID_FNumber | FBillTypeID_FNumber | string | 1 | Required | 单据类型 |
| 2 | FBillNo | FBillNo | string | 1 | Required | 单据编号 |
| 3 | FDate | FDate | string | 1 | Required | 日期 |
| 4 | FSaleOrgId_FNumber | FSaleOrgId_FNumber | string | 1 | Required | 组织 |
| 5 | FCustomerID_FNumber | FCustomerID_FNumber | string | 1 | Required | 基础资料 |
| 6 | FBranchId_FNumber | FBranchId_FNumber | string | 1 | Optional | 基础资料 |
| 7 | FSaleDeptID_FNumber | FSaleDeptID_FNumber | string | 1 | Optional | 基础资料 |
| 8 | FHeadLocationId_FNumber | FHeadLocationId_FNumber | string | 1 | Optional | 基础资料 |
| 9 | FCorrespondOrgId_FNumber | FCorrespondOrgId_FNumber | string | 1 | Optional | 组织 |
| 10 | FCarrierID_FNumber | FCarrierID_FNumber | string | 1 | Optional | 基础资料 |
| 11 | FCarriageNO | FCarriageNO | string | 1 | Optional | 文本 |
| 12 | FSalesGroupID_FNumber | FSalesGroupID_FNumber | string | 1 | Optional | 基础资料 |
| 13 | FSalesManID_FNumber | FSalesManID_FNumber | string | 1 | Optional | 基础资料 |
| 14 | FThirdBillNo | FThirdBillNo | string | 1 | Optional | 文本 |
| 15 | FStockOrgId_FNumber | FStockOrgId_FNumber | string | 1 | Optional | 组织 |
| 16 | FDeliveryDeptID_FNumber | FDeliveryDeptID_FNumber | string | 1 | Optional | 基础资料 |
| 17 | FThirdBillId | FThirdBillId | string | 1 | Optional | 文本 |
| 18 | FLinkPhone | FLinkPhone | string | 1 | Optional | 文本 |
| 19 | FLinkMan | FLinkMan | string | 1 | Optional | 文本 |
| 20 | FThirdSrcType | FThirdSrcType | string | 1 | Optional | 下拉列表 |
| 21 | FStockerID_FNumber | FStockerID_FNumber | string | 1 | Optional | 基础资料 |
| 22 | FBussinessType | FBussinessType | string | 1 | Optional | 下拉列表 |
| 23 | FDocumentStatus | FDocumentStatus | string | 1 | Optional | 单据状态 |
| 24 | FNote | FNote | string | 1 | Optional | 多行文本 |
| 25 | FReceiverID_FNumber | FReceiverID_FNumber | string | 1 | Optional | 基础资料 |
| 26 | FReceiveAddress | FReceiveAddress | string | 1 | Optional | 文本 |
| 27 | FSettleID_FNumber | FSettleID_FNumber | string | 1 | Optional | 基础资料 |
| 28 | FReceiverContactID_FNumber | FReceiverContactID_FNumber | string | 1 | Optional | 基础资料 |
| 29 | FPayerID_FNumber | FPayerID_FNumber | string | 1 | Optional | 基础资料 |
| 30 | FSettleOrgID_FNumber | FSettleOrgID_FNumber | string | 1 | Optional | 组织 |
| 31 | FSettleTypeID_FNumber | FSettleTypeID_FNumber | string | 1 | Optional | 基础资料 |
| 32 | FReceiptConditionID_FNumber | FReceiptConditionID_FNumber | string | 1 | Optional | 基础资料 |
| 33 | FOwnerIdHead_FNumber | FOwnerIdHead_FNumber | string | 1 | Optional | 多类别基础资料 |
| 34 | FBuyerNick | FBuyerNick | string | 1 | Optional | 文本 |
| 35 | FReceiverAddress | FReceiverAddress | string | 1 | Optional | 文本 |
| 36 | FReceiverName | FReceiverName | string | 1 | Optional | 文本 |
| 37 | FReceiverMobile | FReceiverMobile | string | 1 | Optional | 文本 |
| 38 | FReceiverCountry | FReceiverCountry | string | 1 | Optional | 文本 |
| 39 | FReceiverState | FReceiverState | string | 1 | Optional | 文本 |
| 40 | FReceiverCity | FReceiverCity | string | 1 | Optional | 文本 |
| 41 | FReceiverDistrict | FReceiverDistrict | string | 1 | Optional | 文本 |
| 42 | FReceiverPhone | FReceiverPhone | string | 1 | Optional | 文本 |
| 43 | FSHOPNUMBER | FSHOPNUMBER | string | 1 | Optional | 文本 |
| 44 | FSALECHANNEL | FSALECHANNEL | string | 1 | Optional | 文本 |
| 45 | FVIPCODE | FVIPCODE | string | 1 | Optional | 文本 |
| 46 | FCustMatID_FNumber | FCustMatID_FNumber | string | 1 | Optional | 基础资料 |
| 47 | FMaterialID_FNumber | FMaterialID_FNumber | string | 1 | Optional | 基础资料 |
| 48 | FBarcode | FBarcode | string | 1 | Optional | 文本 |
| 49 | FMustQty | FMustQty | string | 1 | Optional | 数量 |
| 50 | FRealQty | FRealQty | string | 1 | Optional | 数量 |
| 51 | FPrice | FPrice | string | 1 | Optional | 单价 |
| 52 | FTaxPrice | FTaxPrice | string | 1 | Optional | 单价 |
| 53 | FIsFree | FIsFree | string | 1 | Optional | 复选框 |
| 54 | FLot | FLot | string | 1 | Optional | 批次 |
| 55 | FProduceDate | FProduceDate | string | 1 | Optional | 日期 |
| 56 | FExpiryDate | FExpiryDate | string | 1 | Optional | 日期 |
| 57 | FEntryTaxRate | FEntryTaxRate | string | 1 | Optional | 小数 |
| 58 | FEntryTaxAmount | FEntryTaxAmount | string | 1 | Optional | 金额 |
| 59 | FAmount | FAmount | string | 1 | Optional | 金额 |
| 60 | FAllAmount | FAllAmount | string | 1 | Optional | 金额 |
| 61 | FStockID_FNumber | FStockID_FNumber | string | 1 | Optional | 基础资料 |
| 62 | FStockStatusID_FNumber | FStockStatusID_FNumber | string | 1 | Optional | 基础资料 |
| 63 | FMtoNo | FMtoNo | string | 1 | Optional | 文本 |
| 64 | FEntrynote | FEntrynote | string | 1 | Optional | 文本 |
| 65 | FSrcType | FSrcType | string | 1 | Optional | 源单类型 |
| 66 | FSrcBillNo | FSrcBillNo | string | 1 | Optional | 源单编号 |
| 67 | FSoorDerno | FSoorDerno | string | 1 | Optional | 文本 |
| 68 | FDiscountRate | FDiscountRate | string | 1 | Optional | 小数 |
| 69 | FDiscount | FDiscount | string | 1 | Optional | 折扣额 |
| 70 | FPriceDiscount | FPriceDiscount | string | 1 | Optional | 单价 |
| 71 | FSOEntryId | FSOEntryId | string | 1 | Optional | 整数 |
| 72 | FB2CORDERDETAILID | FB2CORDERDETAILID | string | 1 | Optional | 整数 |
| 73 | FThirdEntryId | FThirdEntryId | string | 1 | Optional | 文本 |
| 74 | FETHIRDBILLID | FETHIRDBILLID | string | 1 | Optional | 文本 |
| 75 | FETHIRDBILLNO | FETHIRDBILLNO | string | 1 | Optional | 文本 |
| 76 | FGYFINDate | FGYFINDate | string | 1 | Optional | 长日期 |
| 77 | FReceiverName | FReceiverName | 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.