kingdee_query_misc_movement_detail
Query miscellaneous movement details for stock in/out transactions, including other inbound and outbound records. Filter by date, material, or warehouse to retrieve specific data.
Instructions
查询杂项出入库明细表(STK_MiscMovementDetail)。
用于查看杂项出入库的明细数据,包括其他入库、其他出库等。
常用 filter_string:
指定日期范围: "FBillDate>='2024-01-01' and FBillDate<='2024-12-31'"
指定物料: "FMaterialId.FNumber='MAT001'"
指定仓库: "FStockId.FNumber='WH01'"
推荐 field_keys(默认已包含关键字段): FID,FBillNo,FBillDate,FDocumentStatus,FStockOrgId.FName, FMaterialId.FNumber,FMaterialId.FName,FUnitId.FName,FQty,FPrice,FAmount
Returns: str: JSON 格式的杂项出入库明细列表
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |