executeBillQuery{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FMATERIALID | FMATERIALID | string | FMATERIALID | Required | 111 |
| 2 | FNumber | FNumber | string | FNumber | Required | 111 |
| 3 | FName | FName | string | FName | Required | 111 |
| 4 | FSpecification | FSpecification | string | FSpecification | Optional | 111 |
| 5 | FOldNumber | FOldNumber | string | FOldNumber | Optional | 111 |
| 6 | FBARCODE | FBARCODE | string | FBARCODE | Optional | 111 |
| 7 | FDescription | FDescription | string | FDescription | Optional | 111 |
| 8 | FMaterialGroup_FNumber | FMaterialGroup_FNumber | string | FMaterialGroup.FNumber | Optional | 111 |
| 9 | FErpClsID | FErpClsID | string | FErpClsID | Optional | 111 |
| 10 | FDocumentStatus | FDocumentStatus | string | FDocumentStatus | Optional | 111 |
| 11 | FForbidStatus | FForbidStatus | string | FForbidStatus | Optional | 111 |
| 12 | FBaseUnitId_FNumber | FBaseUnitId_FNumber | string | FBaseUnitId.FNumber | Required | 111 |
| 13 | FCreateOrgId_FNumber | FCreateOrgId_FNumber | string | FCreateOrgId.FNumber | Required | 111 |
| 14 | FUseOrgId_FNumber | FUseOrgId_FNumber | string | FUseOrgId.FNumber | Required | 111 |
| 15 | FIsInventory | FIsInventory | string | FIsInventory | Required | 111 |
| 16 | FIsSale | FIsSale | string | FIsSale | Required | 111 |
| 17 | FIsAsset | FIsAsset | string | FIsAsset | Required | 111 |
| 18 | FIsSubContract | FIsSubContract | string | FIsSubContract | Required | 111 |
| 19 | FIsProduce | FIsProduce | string | FIsProduce | Required | 111 |
| 20 | FIsPurchase | FIsPurchase | string | FIsPurchase | Required | 111 |
| 21 | FStockId_FNumber | FStockId_FNumber | string | FStockId.FNumber | Optional | 111 |
| 22 | FPurchaseOrgId_FNumber | FPurchaseOrgId_FNumber | string | FPurchaseOrgId.FNumber | Optional | 111 |
| 23 | FPurchaseOrgId_FName | FPurchaseOrgId_FName | string | FPurchaseOrgId.FName | Optional | 111 |
| 24 | FIsBatchManage | FIsBatchManage | string | FIsBatchManage | Optional | 111 |
| 25 | FIsKFPeriod | FIsKFPeriod | string | FIsKFPeriod | Optional | 111 |
| 26 | FIsSNManage | FIsSNManage | string | FIsSNManage | Optional | 111 |
| 27 | FSafeStock | FSafeStock | string | FSafeStock | Optional | 111 |
| 28 | FCategoryID | FCategoryID | string | FCategoryID | Required | 111 |
| 29 | FExpPeriod | FExpPeriod | string | FExpPeriod | Optional | 111 |
| 30 | FOrderQty | FOrderQty | string | FOrderQty | Optional | 111 |
| 31 | FMinQty | FMinQty | string | FMinQty | Optional | 111 |
| 32 | FMaxQty | FMaxQty | string | FMaxQty | Optional | 111 |
| 33 | FDefaultVendor_FNumber | FDefaultVendor_FNumber | string | FDefaultVendor.FNumber | Optional | 111 |
| 34 | FMaxPOQty | FMaxPOQty | string | FMaxPOQty | Optional | 111 |
| 35 | FMinPOQty | FMinPOQty | string | FMinPOQty | Optional | 111 |
| 36 | FIncreaseQty | FIncreaseQty | string | FIncreaseQty | Optional | 111 |
| 37 | FFixLeadTime | FFixLeadTime | string | FFixLeadTime | Optional | 111 |
| 38 | FVarLeadTime | FVarLeadTime | string | FVarLeadTime | Optional | 111 |
| 39 | FPlanBatchSplitQty | FPlanBatchSplitQty | string | FPlanBatchSplitQty | Optional | 111 |
| 40 | FProduceBillType_FNumber | FProduceBillType_FNumber | string | FProduceBillType.FNumber | Optional | 111 |
| 41 | FPOBillTypeId_FNumber | FPOBillTypeId_FNumber | string | FPOBillTypeId.FNumber | Optional | 111 |
| 42 | FSubBillType_FNumber | FSubBillType_FNumber | string | FSubBillType.FNumber | Optional | 111 |
| 43 | FGROSSWEIGHT | FGROSSWEIGHT | string | FGROSSWEIGHT | Optional | 111 |
| 44 | FNETWEIGHT | FNETWEIGHT | string | FNETWEIGHT | Optional | 111 |
| 45 | FWEIGHTUNITID_FNumber | FWEIGHTUNITID_FNumber | string | FWEIGHTUNITID.FNumber | Optional | 111 |
| 46 | FLENGTH | FLENGTH | string | FLENGTH | Optional | 111 |
| 47 | FWIDTH | FWIDTH | string | FWIDTH | Optional | 111 |
| 48 | FHEIGHT | FHEIGHT | string | FHEIGHT | Optional | 111 |
| 49 | FVOLUME | FVOLUME | string | FVOLUME | Optional | 111 |
| 50 | FWARRANTY | FWARRANTY | string | FWARRANTY | Optional | 111 |
| 51 | FSalePrice_CMK | FSalePrice_CMK | string | FSalePrice_CMK | Optional | 111 |
| 52 | FVIPPrice_CMK | FVIPPrice_CMK | string | FVIPPrice_CMK | Optional | 111 |
| 53 | FPurPrice_CMK | FPurPrice_CMK | string | FPurPrice_CMK | Optional | 111 |
| 54 | FComBrandId_CMK_FNumber | FComBrandId_CMK_FNumber | string | FComBrandId_CMK.FNumber | Optional | 111 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | FMATERIALID | FMATERIALID | string | 1 | Required | 111 |
| 2 | FNumber | FNumber | string | 1 | Required | 111 |
| 3 | FName | FName | string | 1 | Required | 111 |
| 4 | FSpecification | FSpecification | string | 1 | Optional | 111 |
| 5 | FOldNumber | FOldNumber | string | 1 | Optional | 111 |
| 6 | FBARCODE | FBARCODE | string | 1 | Optional | 111 |
| 7 | FDescription | FDescription | string | 1 | Optional | 111 |
| 8 | FMaterialGroup_FNumber | FMaterialGroup_FNumber | string | 1 | Optional | 111 |
| 9 | FErpClsID | FErpClsID | string | 1 | Optional | 111 |
| 10 | FDocumentStatus | FDocumentStatus | string | 1 | Optional | 111 |
| 11 | FForbidStatus | FForbidStatus | string | 1 | Optional | 111 |
| 12 | FBaseUnitId_FNumber | FBaseUnitId_FNumber | string | 1 | Required | 111 |
| 13 | FCreateOrgId_FNumber | FCreateOrgId_FNumber | string | 1 | Required | 111 |
| 14 | FUseOrgId_FNumber | FUseOrgId_FNumber | string | 1 | Required | 111 |
| 15 | FIsInventory | FIsInventory | string | 1 | Required | 111 |
| 16 | FIsSale | FIsSale | string | 1 | Required | 111 |
| 17 | FIsAsset | FIsAsset | string | 1 | Required | 111 |
| 18 | FIsSubContract | FIsSubContract | string | 1 | Required | 111 |
| 19 | FIsProduce | FIsProduce | string | 1 | Required | 111 |
| 20 | FIsPurchase | FIsPurchase | string | 1 | Required | 111 |
| 21 | FStockId_FNumber | FStockId_FNumber | string | 1 | Optional | 111 |
| 22 | FPurchaseOrgId_FNumber | FPurchaseOrgId_FNumber | string | 1 | Optional | 111 |
| 23 | FPurchaseOrgId_FName | FPurchaseOrgId_FName | string | 1 | Optional | 111 |
| 24 | FIsBatchManage | FIsBatchManage | string | 1 | Optional | 111 |
| 25 | FIsKFPeriod | FIsKFPeriod | string | 1 | Optional | 111 |
| 26 | FIsSNManage | FIsSNManage | string | 1 | Optional | 111 |
| 27 | FSafeStock | FSafeStock | string | 1 | Optional | 111 |
| 28 | FCategoryID | FCategoryID | string | 1 | Required | 111 |
| 29 | FExpPeriod | FExpPeriod | string | 1 | Optional | 111 |
| 30 | FOrderQty | FOrderQty | string | 1 | Optional | 111 |
| 31 | FMinQty | FMinQty | string | 1 | Optional | 111 |
| 32 | FMaxQty | FMaxQty | string | 1 | Optional | 111 |
| 33 | FDefaultVendor_FNumber | FDefaultVendor_FNumber | string | 1 | Optional | 111 |
| 34 | FMaxPOQty | FMaxPOQty | string | 1 | Optional | 111 |
| 35 | FMinPOQty | FMinPOQty | string | 1 | Optional | 111 |
| 36 | FIncreaseQty | FIncreaseQty | string | 1 | Optional | 111 |
| 37 | FFixLeadTime | FFixLeadTime | string | 1 | Optional | 111 |
| 38 | FVarLeadTime | FVarLeadTime | string | 1 | Optional | 111 |
| 39 | FPlanBatchSplitQty | FPlanBatchSplitQty | string | 1 | Optional | 111 |
| 40 | FProduceBillType_FNumber | FProduceBillType_FNumber | string | 1 | Optional | 111 |
| 41 | FPOBillTypeId_FNumber | FPOBillTypeId_FNumber | string | 1 | Optional | 111 |
| 42 | FSubBillType_FNumber | FSubBillType_FNumber | string | 1 | Optional | 111 |
| 43 | FGROSSWEIGHT | FGROSSWEIGHT | string | 1 | Optional | 111 |
| 44 | FNETWEIGHT | FNETWEIGHT | string | 1 | Optional | 111 |
| 45 | FWEIGHTUNITID_FNumber | FWEIGHTUNITID_FNumber | string | 1 | Optional | 111 |
| 46 | FLENGTH | FLENGTH | string | 1 | Optional | 111 |
| 47 | FWIDTH | FWIDTH | string | 1 | Optional | 111 |
| 48 | FHEIGHT | FHEIGHT | string | 1 | Optional | 111 |
| 49 | FVOLUME | FVOLUME | string | 1 | Optional | 111 |
| 50 | FWARRANTY | FWARRANTY | string | 1 | Optional | 111 |
| 51 | FSalePrice_CMK | FSalePrice_CMK | string | 1 | Optional | 111 |
| 52 | FVIPPrice_CMK | FVIPPrice_CMK | string | 1 | Optional | 111 |
| 53 | FPurPrice_CMK | FPurPrice_CMK | string | 1 | Optional | 111 |
| 54 | FComBrandId_CMK_FNumber | FComBrandId_CMK_FNumber | 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.