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 |