executeBillQuery{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FBillEntry_FEntryID | FEntryID | string | FBillEntry_FEntryID | Required | FEntryID |
| 2 | FID | 实体主键 | string | FID | Required | 实体主键 |
| 3 | FBillNo | 单据编号 | string | FBillNo | Required | 单据编号 |
| 4 | FDocumentStatus | 单据状态 | string | FDocumentStatus | Required | 单据状态 |
| 5 | FStockOrgId_FNumber | 调入库存组织 | string | FStockOrgId.FNumber | Required | 调入库存组织 |
| 6 | FDate | 日期 | string | FDate | Required | 日期 |
| 7 | FBillTypeID_FNumber | 单据类型 | string | FBillTypeID.FNumber | Required | 单据类型 |
| 8 | FTransferBizType | 调拨类型 | string | FTransferBizType | Required | 调拨类型 |
| 9 | FStockOutOrgId_FNumber | 调出库存组织 | string | FStockOutOrgId.FNumber | Required | 调出库存组织 |
| 10 | FTransferDirect | 调拨方向 | string | FTransferDirect | Required | 调拨方向 |
| 11 | FNote | 备注 | string | FNote | Required | 备注 |
| 12 | FBizType | 业务类型 | string | FBizType | Required | 业务类型 |
| 13 | FSaleOrgId_FNumber | 销售组织 | string | FSaleOrgId.FNumber | Required | 销售组织 |
| 14 | FSettleOrgId_FNumber | 结算组织 | string | FSettleOrgId.FNumber | Required | 结算组织 |
| 15 | FCustID_FNumber | 对应客户 | string | FCustID.FNumber | Required | 对应客户 |
| 16 | FSUPPLIERID_FNumber | 对应供应商 | string | FSUPPLIERID.FNumber | Required | 对应供应商 |
| 17 | FThirdSrcId | 第三方源单内码 | string | FThirdSrcId | Required | 第三方源单内码 |
| 18 | FThirdSrcBillNo | 第三方源单编码 | string | FThirdSrcBillNo | Required | 第三方源单编码 |
| 19 | FThirdSystem | 第三方系统 | string | FThirdSystem | Required | 第三方系统 |
| 20 | FMaterialId_FNumber | 物料编码 | string | FMaterialId.FNumber | Required | 物料编码 |
| 21 | FLot | 调出批号 | string | FLot.fnumber | Required | 调出批号 |
| 22 | FSrcStockId_FNumber | 调出仓库 | string | FSrcStockId.FNumber | Required | 调出仓库 |
| 23 | FSrcStockLocId | 调出仓位 | string | FSrcStockLocId | Required | 调出仓位 |
| 24 | FDestStockId_FNumber | 调入仓库 | string | FDestStockId.FNumber | Required | 调入仓库 |
| 25 | FDestStockLocId | 调入仓位 | string | FDestStockLocId | Required | 调入仓位 |
| 26 | FQty | 调拨数量 | string | FQty | Required | 调拨数量 |
| 27 | FPrice | 成本价 | string | FPrice | Required | 成本价 |
| 28 | FAmount | 总成本 | string | FAmount | Required | 总成本 |
| 29 | FBomId | BOM版本 | string | FBomId | Required | BOM版本 |
| 30 | FProduceDate | 生产日期 | string | FProduceDate | Required | 生产日期 |
| 31 | FExpiryDate | 有效期至 | string | FExpiryDate | Required | 有效期至 |
| 32 | FMtoNo | 计划跟踪号 | string | FMtoNo | Required | 计划跟踪号 |
| 33 | FSrcStockStatusId | 调出库存状态 | string | FSrcStockStatusId | Required | 调出库存状态 |
| 34 | FDestStockStatusId | 调入库存状态 | string | FDestStockStatusId | Required | 调入库存状态 |
| 35 | FOwnerId_FNumber | 调入货主 | string | FOwnerId.FNumber | Required | 调入货主 |
| 36 | FOwnerOutId_FNumber | 调出货主 | string | FOwnerOutId.FNumber | Required | 调出货主 |
| 37 | FSrcBillTypeId | 源单类型 | string | FSrcBillTypeId | Required | 源单类型 |
| 38 | FSrcSeq | 源单行号 | string | FSrcSeq | Required | 源单行号 |
| 39 | FOrderNo | 订单编号 | string | FOrderNo | Required | 订单编号 |
| 40 | FNoteEntry | 备注 | string | FNoteEntry | Required | 备注 |
| 41 | FSrcBillNo | 源单编号 | string | FSrcBillNo | Required | 源单编号 |
| 42 | FBFLowId | 业务流程 | string | FBFLowId | Required | 业务流程 |
| 43 | FConsignPrice | 单价 | string | FConsignPrice | Required | 单价 |
| 44 | FTaxPrice | 含税单价 | string | FTaxPrice | Required | 含税单价 |
| 45 | FTaxRate | 税率% | string | FTaxRate | Required | 税率% |
| 46 | FDestLot | 调入批号 | string | FDestLot.fnumber | Required | 调入批号 |
| 47 | FQmEntryId | 库存请检单EntryId | string | FQmEntryId | Required | 库存请检单EntryId |
| 48 | FConvertEntryId | 库存状态转换EntryId | string | FConvertEntryId | Required | 库存状态转换EntryId |
| 49 | FSOEntryId | 销售订单EntryId | string | FSOEntryId | Required | 销售订单EntryId |
| 50 | FThirdSrcEntryId | 第三方源单分录编码 | string | FThirdSrcEntryId | Required | 第三方源单分录编码 |
| 51 | FISFREE | 赠品 | string | FISFREE | Required | 赠品 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FBillEntry_FEntryID | FEntryID | string | FBillEntry_FEntryID | Required | FEntryID |
| 2 | FID | 实体主键 | string | FID | Required | 实体主键 |
| 3 | FBillNo | 单据编号 | string | FBillNo | Required | 单据编号 |
| 4 | FDocumentStatus | 单据状态 | string | FDocumentStatus | Required | 单据状态 |
| 5 | FStockOrgId_FNumber | 调入库存组织 | string | FStockOrgId.FNumber | Required | 调入库存组织 |
| 6 | FDate | 日期 | datetime | FDate | Required | 日期 |
| 7 | FBillTypeID_FNumber | 单据类型 | string | FBillTypeID.FNumber | Required | 标准直接调拨单:ZJDB01_SYS 寄售直接调拨单:ZJDB02_SYS 委外直接调拨单:ZJDB03_SYS 分销直接调拨单:ZJDB04_SYS VMI直接调拨单:ZJDB05_SYS 不对接标准直接调拨单:ZJDB06_SYS |
| 8 | FTransferBizType | 调拨类型 | string | FTransferBizType | Required | 跨组织VMI:OverOrgPurVMI 跨组织委外领料:OverOrgSubPick 跨组织生产入库:OverOrgPrdIn 跨组织销售:OverOrgSale 组织内调拨:InnerOrgTransfer 跨组织调拨:OverOrgTransfer 跨组织采购:OverOrgPurchase 跨组织其他出库:OverOrgMisDelivery 跨组织生产退库:OverOrgPrdOut 跨组织生产领料:OverOrgPick |
| 9 | FStockOutOrgId_FNumber | 调出库存组织 | string | FStockOutOrgId.FNumber | Required | 调出库存组织 |
| 10 | FTransferDirect | 调拨方向 | string | FTransferDirect | Required | 普通:GENERAL 退货:RETURN |
| 11 | FNote | 备注 | string | FNote | Required | 备注 |
| 12 | FBizType | 业务类型 | string | FBizType | Required | 业务类型 |
| 13 | FSaleOrgId_FNumber | 销售组织 | string | FSaleOrgId.FNumber | Required | 销售组织 |
| 14 | FSettleOrgId_FNumber | 结算组织 | string | FSettleOrgId.FNumber | Required | 结算组织 |
| 15 | FCustID_FNumber | 对应客户 | string | FCustID.FNumber | Required | 对应客户 |
| 16 | FSUPPLIERID_FNumber | 对应供应商 | string | FSUPPLIERID.FNumber | Required | 对应供应商 |
| 17 | FThirdSrcId | 第三方源单内码 | string | FThirdSrcId | Required | 第三方源单内码 |
| 18 | FThirdSrcBillNo | 第三方源单编码 | string | FThirdSrcBillNo | Required | 第三方源单编码 |
| 19 | FThirdSystem | 第三方系统 | string | FThirdSystem | Required | 第三方系统 |
| 20 | FMaterialId_FNumber | 物料编码 | string | FMaterialId.FNumber | Required | 物料编码 |
| 21 | FLot | 调出批号 | string | FLot.fnumber | Required | 调出批号 |
| 22 | FSrcStockId_FNumber | 调出仓库 | string | FSrcStockId.FNumber | Required | 调出仓库 |
| 23 | FSrcStockLocId | 调出仓位 | string | FSrcStockLocId | Required | 调出仓位 |
| 24 | FDestStockId_FNumber | 调入仓库 | string | FDestStockId.FNumber | Required | 调入仓库 |
| 25 | FDestStockLocId | 调入仓位 | string | FDestStockLocId | Required | 调入仓位 |
| 26 | FQty | 调拨数量 | float | FQty | Required | 调拨数量 |
| 27 | FPrice | 成本价 | float | FPrice | Required | 成本价 |
| 28 | FAmount | 总成本 | float | FAmount | Required | 总成本 |
| 29 | FBomId | BOM版本 | string | FBomId | Required | BOM版本 |
| 30 | FProduceDate | 生产日期 | string | FProduceDate | Required | 生产日期 |
| 31 | FExpiryDate | 有效期至 | string | FExpiryDate | Required | 有效期至 |
| 32 | FMtoNo | 计划跟踪号 | string | FMtoNo | Required | 计划跟踪号 |
| 33 | FSrcStockStatusId | 调出库存状态 | string | FSrcStockStatusId | Required | 调出库存状态 |
| 34 | FDestStockStatusId | 调入库存状态 | string | FDestStockStatusId | Required | 调入库存状态 |
| 35 | FOwnerId_FNumber | 调入货主 | string | FOwnerId.FNumber | Required | 调入货主 |
| 36 | FOwnerOutId_FNumber | 调出货主 | string | FOwnerOutId.FNumber | Required | 调出货主 |
| 37 | FSrcBillTypeId | 源单类型 | string | FSrcBillTypeId | Required | 源单类型 |
| 38 | FSrcSeq | 源单行号 | string | FSrcSeq | Required | 源单行号 |
| 39 | FOrderNo | 订单编号 | string | FOrderNo | Required | 订单编号 |
| 40 | FNoteEntry | 备注 | string | FNoteEntry | Required | 备注 |
| 41 | FSrcBillNo | 源单编号 | string | FSrcBillNo | Required | 源单编号 |
| 42 | FBFLowId | 业务流程 | string | FBFLowId | Required | 业务流程 |
| 43 | FConsignPrice | 单价 | float | FConsignPrice | Required | 单价 |
| 44 | FTaxPrice | 含税单价 | float | FTaxPrice | Required | 含税单价 |
| 45 | FTaxRate | 税率% | string | FTaxRate | Required | 税率% |
| 46 | FDestLot | 调入批号 | string | FDestLot.fnumber | Required | 调入批号 |
| 47 | FQmEntryId | 库存请检单EntryId | string | FQmEntryId | Required | 库存请检单EntryId |
| 48 | FConvertEntryId | 库存状态转换EntryId | string | FConvertEntryId | Required | 库存状态转换EntryId |
| 49 | FSOEntryId | 销售订单EntryId | string | FSOEntryId | Required | 销售订单EntryId |
| 50 | FThirdSrcEntryId | 第三方源单分录编码 | string | FThirdSrcEntryId | Required | 第三方源单分录编码 |
| 51 | FISFREE | 赠品 | string | FISFREE | Required | 赠品 |
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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.