kingdee_query_material_cost_usage
Query production material cost usage by production order or material. Retrieve consumed quantity, cost price, and total cost in JSON format.
Instructions
查询生产材料耗用成本(CB_MaterialCostQuery)。
常用 filter_string:
指定生产订单: "FMoBillNo='MO000001'"
指定物料: "FMaterialId.FNumber='MAT001'"
推荐 field_keys: FMoBillNo,FMaterialId.FNumber,FMaterialId.FName,FConsumeQty,FCostPrice,FCostAmt
Returns: str: JSON 格式的材料耗用成本列表
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"params": "<params>"
},
"name": "kingdee_query_material_cost_usage"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |