executeBillQuery{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FInStockEntry_FEntryId | FInStockEntry_FEntryId | string | FInStockEntry_FEntryId | Required | 111 |
| 2 | FID | FID | string | FID | Optional | 111 |
| 3 | FBillNo | FBillNo | string | FBillNo | Optional | 111 |
| 4 | FDocumentStatus | FDocumentStatus | string | FDocumentStatus | Optional | 111 |
| 5 | FStockOrgId_FNumber | FStockOrgId_FNumber | string | FStockOrgId.FNumber | Optional | 111 |
| 6 | FDate | FDate | string | FDate | Optional | 111 |
| 7 | FBillTypeID_FNumber | FBillTypeID_FNumber | string | FBillTypeID.FNumber | Optional | 111 |
| 8 | FOwnerTypeIdHead | FOwnerTypeIdHead | string | FOwnerTypeIdHead | Optional | 111 |
| 9 | FOwnerIdHead_FNumber | FOwnerIdHead_FNumber | string | FOwnerIdHead.FNumber | Optional | 111 |
| 10 | FDemandOrgId_FNumber | FDemandOrgId_FNumber | string | FDemandOrgId.FNumber | Optional | 111 |
| 11 | FPurchaseOrgId_FNumber | FPurchaseOrgId_FNumber | string | FPurchaseOrgId.FNumber | Optional | 111 |
| 12 | FSupplierId_FNumber | FSupplierId_FNumber | string | FSupplierId.FNumber | Optional | 111 |
| 13 | FStockerGroupId_FNumber | FStockerGroupId_FNumber | string | FStockerGroupId.FNumber | Optional | 111 |
| 14 | FStockDeptId_FNumber | FStockDeptId_FNumber | string | FStockDeptId.FNumber | Optional | 111 |
| 15 | FCreateDate | FCreateDate | string | FCreateDate | Optional | 111 |
| 16 | FCancelDate | FCancelDate | string | FCancelDate | Optional | 111 |
| 17 | FDeliveryBill | FDeliveryBill | string | FDeliveryBill | Optional | 111 |
| 18 | FTakeDeliveryBill | FTakeDeliveryBill | string | FTakeDeliveryBill | Optional | 111 |
| 19 | FApproveDate | FApproveDate | string | FApproveDate | Optional | 111 |
| 20 | FCancelStatus | FCancelStatus | string | FCancelStatus | Optional | 111 |
| 21 | FSupplyId_FNumber | FSupplyId_FNumber | string | FSupplyId.FNumber | Optional | 111 |
| 22 | FSettleId_FNumber | FSettleId_FNumber | string | FSettleId.FNumber | Optional | 111 |
| 23 | FChargeId_FNumber | FChargeId_FNumber | string | FChargeId.FNumber | Optional | 111 |
| 24 | FBusinessType | FBusinessType | string | FBusinessType | Optional | 111 |
| 25 | FSupplyAddress | FSupplyAddress | string | FSupplyAddress | Optional | 111 |
| 26 | FAPSTATUS | FAPSTATUS | string | FAPSTATUS | Optional | 111 |
| 27 | FTransferBizType | FTransferBizType | string | FTransferBizType | Optional | 111 |
| 28 | FDisassemblyFlag | FDisassemblyFlag | string | FDisassemblyFlag | Optional | 111 |
| 29 | FConfirmDate | FConfirmDate | string | FConfirmDate | Optional | 111 |
| 30 | FConfirmStatus | FConfirmStatus | string | FConfirmStatus | Optional | 111 |
| 31 | FSplitBillType | FSplitBillType | string | FSplitBillType | Optional | 111 |
| 32 | FPayOrgId_FNumber | FPayOrgId_FNumber | string | FPayOrgId.FNumber | Optional | 111 |
| 33 | FSettleOrgId_FNumber | FSettleOrgId_FNumber | string | FSettleOrgId.FNumber | Optional | 111 |
| 34 | FSettleCurrId_FNumber | FSettleCurrId_FNumber | string | FSettleCurrId.FNumber | Optional | 111 |
| 35 | FBillCost | FBillCost | string | FBillCost | Optional | 111 |
| 36 | FBillTaxAmount | FBillTaxAmount | string | FBillTaxAmount | Optional | 111 |
| 37 | FBillCostAmount | FBillCostAmount | string | FBillCostAmount | Optional | 111 |
| 38 | FBillAllAmount | FBillAllAmount | string | FBillAllAmount | Optional | 111 |
| 39 | FSettleTypeId | FSettleTypeId | string | FSettleTypeId | Optional | 111 |
| 40 | FExchangeRate | FExchangeRate | string | FExchangeRate | Optional | 111 |
| 41 | FLocalCurrId_FNumber | FLocalCurrId_FNumber | string | FLocalCurrId.FNumber | Optional | 111 |
| 42 | FBillAmount | FBillAmount | string | FBillAmount | Optional | 111 |
| 43 | FIsIncludedTax | FIsIncludedTax | string | FIsIncludedTax | Optional | 111 |
| 44 | FOwnerCustomerID_FNumber | FOwnerCustomerID_FNumber | string | FOwnerCustomerID.FNumber | Optional | 111 |
| 45 | FSettleSupplierID_FNumber | FSettleSupplierID_FNumber | string | FSettleSupplierID.FNumber | Optional | 111 |
| 46 | FISGENFORIOS | FISGENFORIOS | string | FISGENFORIOS | Optional | 111 |
| 47 | FISPRICEEXCLUDETAX | FISPRICEEXCLUDETAX | string | FISPRICEEXCLUDETAX | Optional | 111 |
| 48 | FISINVOICEARLIER | FISINVOICEARLIER | string | FISINVOICEARLIER | Optional | 111 |
| 49 | FMaterialId_FNumber | FMaterialId_FNumber | string | FMaterialId.FNumber | Optional | 111 |
| 50 | FStockId_FNumber | FStockId_FNumber | string | FStockId.FNumber | Optional | 111 |
| 51 | FProduceDate | FProduceDate | string | FProduceDate | Optional | 111 |
| 52 | FNote | FNote | string | FNote | Optional | 111 |
| 53 | FSupplierLot | FSupplierLot | string | FSupplierLot | Optional | 111 |
| 54 | FGrossWeight | FGrossWeight | string | FGrossWeight | Optional | 111 |
| 55 | FNetWeight | FNetWeight | string | FNetWeight | Optional | 111 |
| 56 | FContractlNo | FContractlNo | string | FContractlNo | Optional | 111 |
| 57 | FReqTraceNo | FReqTraceNo | string | FReqTraceNo | Optional | 111 |
| 58 | FMustQty | FMustQty | string | FMustQty | Optional | 111 |
| 59 | FRealQty | FRealQty | string | FRealQty | Optional | 111 |
| 60 | FSRCRowId | FSRCRowId | string | FSRCRowId | Optional | 111 |
| 61 | FExpiryDate | FExpiryDate | string | FExpiryDate | Optional | 111 |
| 62 | FIsFree | FIsFree | string | FIsFree | Optional | 111 |
| 63 | FStockStatusId | FStockStatusId | string | FStockStatusId | Optional | 111 |
| 64 | FBOMId | FBOMId | string | FBOMId | Optional | 111 |
| 65 | FTaxPrice | FTaxPrice | string | FTaxPrice | Optional | 111 |
| 66 | FCostPrice | FCostPrice | string | FCostPrice | Optional | 111 |
| 67 | FEntryTaxRate | FEntryTaxRate | string | FEntryTaxRate | Optional | 111 |
| 68 | FEntryTaxAmount | FEntryTaxAmount | string | FEntryTaxAmount | Optional | 111 |
| 69 | FDiscountRate | FDiscountRate | string | FDiscountRate | Optional | 111 |
| 70 | FPriceCoefficient | FPriceCoefficient | string | FPriceCoefficient | Optional | 111 |
| 71 | FPriceUnitQty | FPriceUnitQty | string | FPriceUnitQty | Optional | 111 |
| 72 | FTaxNetPrice | FTaxNetPrice | string | FTaxNetPrice | Optional | 111 |
| 73 | FEntryCostAmount | FEntryCostAmount | string | FEntryCostAmount | Optional | 111 |
| 74 | FAllAmount | FAllAmount | string | FAllAmount | Optional | 111 |
| 75 | FStockFlag | FStockFlag | string | FStockFlag | Optional | 111 |
| 76 | FPOOrderNo | FPOOrderNo | string | FPOOrderNo | Optional | 111 |
| 77 | FEXPUnit | FEXPUnit | string | FEXPUnit | Optional | 111 |
| 78 | FExpPeriod | FExpPeriod | string | FExpPeriod | Optional | 111 |
| 79 | FSRCBILLTYPEID | FSRCBILLTYPEID | string | FSRCBILLTYPEID | Optional | 111 |
| 80 | FSRCBillNo | FSRCBillNo | string | FSRCBillNo | Optional | 111 |
| 81 | FINVOICEDQTY | FINVOICEDQTY | string | FINVOICEDQTY | Optional | 111 |
| 82 | FBaseAPJoinQty | FBaseAPJoinQty | string | FBaseAPJoinQty | Optional | 111 |
| 83 | FReceiveStockFlag | FReceiveStockFlag | string | FReceiveStockFlag | Optional | 111 |
| 84 | FProcessFee | FProcessFee | string | FProcessFee | Optional | 111 |
| 85 | FMaterialCosts | FMaterialCosts | string | FMaterialCosts | Optional | 111 |
| 86 | FLot | FLot | string | FLot | Optional | 111 |
| 87 | FPrice | FPrice | string | FPrice | Optional | 111 |
| 88 | FAmount | FAmount | string | FAmount | Optional | 111 |
| 89 | FDiscount | FDiscount | string | FDiscount | Optional | 111 |
| 90 | FReturnJoinQty | FReturnJoinQty | string | FReturnJoinQty | Optional | 111 |
| 91 | FBFLowId | FBFLowId | string | FBFLowId | Optional | 111 |
| 92 | FGiveAway | FGiveAway | string | FGiveAway | Optional | 111 |
| 93 | FWWInType | FWWInType | string | FWWInType | Optional | 111 |
| 94 | FRowId | FRowId | string | FRowId | Optional | 111 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FInStockEntry_FEntryId | FInStockEntry_FEntryId | string | 1 | Required | 111 |
| 2 | FID | FID | string | 1 | Optional | 111 |
| 3 | FBillNo | FBillNo | string | 1 | Optional | 111 |
| 4 | FDocumentStatus | FDocumentStatus | string | 1 | Optional | 111 |
| 5 | FStockOrgId_FNumber | FStockOrgId_FNumber | string | 1 | Optional | 111 |
| 6 | FDate | FDate | string | 1 | Optional | 111 |
| 7 | FBillTypeID_FNumber | FBillTypeID_FNumber | string | 1 | Optional | 111 |
| 8 | FOwnerTypeIdHead | FOwnerTypeIdHead | string | 1 | Optional | 111 |
| 9 | FOwnerIdHead_FNumber | FOwnerIdHead_FNumber | string | 1 | Optional | 111 |
| 10 | FDemandOrgId_FNumber | FDemandOrgId_FNumber | string | 1 | Optional | 111 |
| 11 | FPurchaseOrgId_FNumber | FPurchaseOrgId_FNumber | string | 1 | Optional | 111 |
| 12 | FSupplierId_FNumber | FSupplierId_FNumber | string | 1 | Optional | 111 |
| 13 | FStockerGroupId_FNumber | FStockerGroupId_FNumber | string | 1 | Optional | 111 |
| 14 | FStockDeptId_FNumber | FStockDeptId_FNumber | string | 1 | Optional | 111 |
| 15 | FCreateDate | FCreateDate | string | 1 | Optional | 111 |
| 16 | FCancelDate | FCancelDate | string | 1 | Optional | 111 |
| 17 | FDeliveryBill | FDeliveryBill | string | 1 | Optional | 111 |
| 18 | FTakeDeliveryBill | FTakeDeliveryBill | string | 1 | Optional | 111 |
| 19 | FApproveDate | FApproveDate | string | 1 | Optional | 111 |
| 20 | FCancelStatus | FCancelStatus | string | 1 | Optional | 111 |
| 21 | FSupplyId_FNumber | FSupplyId_FNumber | string | 1 | Optional | 111 |
| 22 | FSettleId_FNumber | FSettleId_FNumber | string | 1 | Optional | 111 |
| 23 | FChargeId_FNumber | FChargeId_FNumber | string | 1 | Optional | 111 |
| 24 | FBusinessType | FBusinessType | string | 1 | Optional | 111 |
| 25 | FSupplyAddress | FSupplyAddress | string | 1 | Optional | 111 |
| 26 | FAPSTATUS | FAPSTATUS | string | 1 | Optional | 111 |
| 27 | FTransferBizType | FTransferBizType | string | 1 | Optional | 111 |
| 28 | FDisassemblyFlag | FDisassemblyFlag | string | 1 | Optional | 111 |
| 29 | FConfirmDate | FConfirmDate | string | 1 | Optional | 111 |
| 30 | FConfirmStatus | FConfirmStatus | string | 1 | Optional | 111 |
| 31 | FSplitBillType | FSplitBillType | string | 1 | Optional | 111 |
| 32 | FPayOrgId_FNumber | FPayOrgId_FNumber | string | 1 | Optional | 111 |
| 33 | FSettleOrgId_FNumber | FSettleOrgId_FNumber | string | 1 | Optional | 111 |
| 34 | FSettleCurrId_FNumber | FSettleCurrId_FNumber | string | 1 | Optional | 111 |
| 35 | FBillCost | FBillCost | string | 1 | Optional | 111 |
| 36 | FBillTaxAmount | FBillTaxAmount | string | 1 | Optional | 111 |
| 37 | FBillCostAmount | FBillCostAmount | string | 1 | Optional | 111 |
| 38 | FBillAllAmount | FBillAllAmount | string | 1 | Optional | 111 |
| 39 | FSettleTypeId | FSettleTypeId | string | 1 | Optional | 111 |
| 40 | FExchangeRate | FExchangeRate | string | 1 | Optional | 111 |
| 41 | FLocalCurrId_FNumber | FLocalCurrId_FNumber | string | 1 | Optional | 111 |
| 42 | FBillAmount | FBillAmount | string | 1 | Optional | 111 |
| 43 | FIsIncludedTax | FIsIncludedTax | string | 1 | Optional | 111 |
| 44 | FOwnerCustomerID_FNumber | FOwnerCustomerID_FNumber | string | 1 | Optional | 111 |
| 45 | FSettleSupplierID_FNumber | FSettleSupplierID_FNumber | string | 1 | Optional | 111 |
| 46 | FISGENFORIOS | FISGENFORIOS | string | 1 | Optional | 111 |
| 47 | FISPRICEEXCLUDETAX | FISPRICEEXCLUDETAX | string | 1 | Optional | 111 |
| 48 | FISINVOICEARLIER | FISINVOICEARLIER | string | 1 | Optional | 111 |
| 49 | FMaterialId_FNumber | FMaterialId_FNumber | string | 1 | Optional | 111 |
| 50 | FStockId_FNumber | FStockId_FNumber | string | 1 | Optional | 111 |
| 51 | FProduceDate | FProduceDate | string | 1 | Optional | 111 |
| 52 | FNote | FNote | string | 1 | Optional | 111 |
| 53 | FSupplierLot | FSupplierLot | string | 1 | Optional | 111 |
| 54 | FGrossWeight | FGrossWeight | string | 1 | Optional | 111 |
| 55 | FNetWeight | FNetWeight | string | 1 | Optional | 111 |
| 56 | FContractlNo | FContractlNo | string | 1 | Optional | 111 |
| 57 | FReqTraceNo | FReqTraceNo | string | 1 | Optional | 111 |
| 58 | FMustQty | FMustQty | string | 1 | Optional | 111 |
| 59 | FRealQty | FRealQty | string | 1 | Optional | 111 |
| 60 | FSRCRowId | FSRCRowId | string | 1 | Optional | 111 |
| 61 | FExpiryDate | FExpiryDate | string | 1 | Optional | 111 |
| 62 | FIsFree | FIsFree | string | 1 | Optional | 111 |
| 63 | FStockStatusId | FStockStatusId | string | 1 | Optional | 111 |
| 64 | FBOMId | FBOMId | string | 1 | Optional | 111 |
| 65 | FTaxPrice | FTaxPrice | string | 1 | Optional | 111 |
| 66 | FCostPrice | FCostPrice | string | 1 | Optional | 111 |
| 67 | FEntryTaxRate | FEntryTaxRate | string | 1 | Optional | 111 |
| 68 | FEntryTaxAmount | FEntryTaxAmount | string | 1 | Optional | 111 |
| 69 | FDiscountRate | FDiscountRate | string | 1 | Optional | 111 |
| 70 | FPriceCoefficient | FPriceCoefficient | string | 1 | Optional | 111 |
| 71 | FPriceUnitQty | FPriceUnitQty | string | 1 | Optional | 111 |
| 72 | FTaxNetPrice | FTaxNetPrice | string | 1 | Optional | 111 |
| 73 | FEntryCostAmount | FEntryCostAmount | string | 1 | Optional | 111 |
| 74 | FAllAmount | FAllAmount | string | 1 | Optional | 111 |
| 75 | FStockFlag | FStockFlag | string | 1 | Optional | 111 |
| 76 | FPOOrderNo | FPOOrderNo | string | 1 | Optional | 111 |
| 77 | FEXPUnit | FEXPUnit | string | 1 | Optional | 111 |
| 78 | FExpPeriod | FExpPeriod | string | 1 | Optional | 111 |
| 79 | FSRCBILLTYPEID | FSRCBILLTYPEID | string | 1 | Optional | 111 |
| 80 | FSRCBillNo | FSRCBillNo | string | 1 | Optional | 111 |
| 81 | FINVOICEDQTY | FINVOICEDQTY | string | 1 | Optional | 111 |
| 82 | FBaseAPJoinQty | FBaseAPJoinQty | string | 1 | Optional | 111 |
| 83 | FReceiveStockFlag | FReceiveStockFlag | string | 1 | Optional | 111 |
| 84 | FProcessFee | FProcessFee | string | 1 | Optional | 111 |
| 85 | FMaterialCosts | FMaterialCosts | string | 1 | Optional | 111 |
| 86 | FLot | FLot | string | 1 | Optional | 111 |
| 87 | FPrice | FPrice | string | 1 | Optional | 111 |
| 88 | FAmount | FAmount | string | 1 | Optional | 111 |
| 89 | FDiscount | FDiscount | string | 1 | Optional | 111 |
| 90 | FReturnJoinQty | FReturnJoinQty | string | 1 | Optional | 111 |
| 91 | FBFLowId | FBFLowId | string | 1 | Optional | 111 |
| 92 | FGiveAway | FGiveAway | string | 1 | Optional | 111 |
| 93 | FWWInType | FWWInType | string | 1 | Optional | 111 |
| 94 | FRowId | FRowId | 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.