kingdee_describe_table
Retrieve complete table structure including column names, data types, nullable status, and default values. Essential for SQL writing and data modeling in Kingdee ERP.
Instructions
查看指定表的完整结构(列名、类型、可空、默认值)。
适用场景:
知道表名,想了解完整字段列表
写 SQL 或做数据建模前,查看表结构
确认 Kingdee API 返回的字段在数据库里的实际类型
已知金蝶常用表名前缀:
t_PUR_:采购相关(t_PUR_PurchaseOrder 采购订单)
t_SAL_:销售相关(t_SAL_SaleOrder 销售订单)
t_STK_:库存相关(t_STK_InStock 入库单)
t_BD_:基础资料(t_BD_Material 物料、t_BD_Supplier 供应商)
Returns: str: 表结构详情
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_describe_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |