Department
Query t_Department 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 |
| Level | Long | Mapping to field t_Item.FLevel |
| ParentNumber | String | Mapping to field t_Item.FNumber join with t_Item.FParentID |
| ParentName | String | Mapping to field t_Item.FName join with t_Item.FParentID |
| ParentUUID | String | Mapping to t_Item.UUID join with t_Item.FParentID |
| IsDetail | Boolean | Mapping to field t_Item.FDetail |
| ManagerNumber | String | Mapping to field t_SubMessage.FID join with t_Department.FManager |
| ManagerName | String | Mapping to field t_SubMessage.FName join with t_Department.FManager |
| ManagerUUID | String | Mapping to t_SubMessage.UUID join with t_Department.FManager |
| Phone | String | Mapping to field t_Department.FPhone |
| Fax | String | Mapping to field t_Department.FFax |
| PropertyNumber | String | Mapping to field t_SubMessage.FID join with t_Department.FDProperty |
| PropertyName | String | Mapping to field t_SubMessage.FName join with t_Department.FDProperty |
| PropertyUUID | String | Mapping to t_SubMessage.UUID join with t_Department.FDProperty |
| Note | String | Mapping to field t_Department.FNote |
| CostAccountNumber | String | Mapping to field t_Account.FNumber join with t_Department.FAcctID |
| CostAccountName | String | Mapping to field t_Account.FName join with t_Department.FAcctID |
| CostAccountUUID | String | Mapping to t_Account.UUID join with t_Department.FAcctID |
| CostAccountTypeNumber | String | Mapping to field t_SubMessage.FID join with t_Department.FCostAccountType |
| CostAccountTypeName | String | Mapping to field t_SubMessage.FName join with t_Department.FCostAccountType |
| CostAccountTypeUUID | String | Mapping to t_SubMessage.UUID join with t_Department.FCostAccountType |
| FOtherArAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_Department.FOtherArAcctID |
| FOtherArAcctIDName | String | Mapping to field t_Account.FName join with t_Department.FOtherArAcctID |
| FOtherArAcctIDUUID | String | Mapping to t_Account.UUID join with t_Department.FOtherArAcctID |
| FOtherAPAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_Department.FOtherAPAcctID |
| FOtherAPAcctIDName | String | Mapping to field t_Account.FName join with t_Department.FOtherAPAcctID |
| FOtherAPAcctIDUUID | String | Mapping to t_Account.UUID join with t_Department.FOtherAPAcctID |
| FPreApAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_Department.FPreApAcctID |
| FPreApAcctIDName | String | Mapping to field t_Account.FName join with t_Department.FPreApAcctID |
| FPreApAcctIDUUID | String | Mapping to t_Account.UUID join with t_Department.FPreApAcctID |
| FPreArAcctIDNumber | String | Mapping to field t_Account.FNumber join with t_Department.FPreArAcctID |
| FPreArAcctIDName | String | Mapping to field t_Account.FName join with t_Department.FPreArAcctID |
| FPreArAcctIDUUID | String | Mapping to t_Account.UUID join with t_Department.FPreArAcctID |