Stock
Query t_Stock in Kingdee.
Columns
| Name | Type | Description |
| UUID [KEY] | String | Mapping to field t_Item.UUID |
| Number | String | Mapping to field t_Item.FNumber |
| Name | String | Mapping to field t_Item.FName |
| ParentNumber | String | Mapping to field t_Item.FName join with t_Item.FParentID |
| ParentName | String | Mapping to field t_Item.FNumber join with t_Item.FParentID |
| ParentUUID | String | Mapping to field t_Item.UUID join with t_Item.FParentID |
| Level | Long | Mapping to field t_Item.FLevel |
| IsDetail | Boolean | Mapping to field t_Item.FDetail |
| StockAdminNumber | String | Mapping to field t_Item.FNumber join with t_Stock.FEmpID |
| StockAdminName | String | Mapping to field t_Item.FName join with t_Stock.FEmpID |
| StockAdminUUID | String | Mapping to t_Item.UUID join with t_Stock.FEmpID |
| Address | String | Mapping to field t_Stock.FAddress |
| Phone | String | Mapping to field t_Stock.FPhone |
| PropertyNumber | String | Mapping to field t_SubMessage.FID join with t_Stock.FProperty |
| PropertyName | String | Mapping to field t_SubMessage.FName join with t_Stock.FProperty |
| PropertyUUID | String | Mapping to t_SubMessage.UUID join with t_Stock.FProperty |
| TypeNumber | String | Mapping to field t_SubMessage.FID join with t_Stock.FTypeID |
| TypeName | String | Mapping to field t_SubMessage.FName join with t_Stock.FTypeID |
| TypeUUID | String | Mapping to t_SubMessage.UUID join with t_Stock.FTypeID |
| MRPAvail | Boolean | Mapping to field t_Stock.FMRPAvail |
| IsStockMgr | Boolean | Mapping to field t_Stock.FIsStockMgr |
| StockPlaceGroupNumber | String | Mapping to field t_StockPlaceGroup.FNumber join with t_Stock.FSPGroupID |
| StockPlaceGroupName | String | Mapping to field t_StockPlaceGroup.FName join with t_Stock.FSPGroupID |
| StockPlaceGroupUUID | String | Mapping to t_StockPlaceGroup.UUID join with t_Stock.FSPGroupID |