| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGroup Hierarchy |
1 | BUT_HIER_NODE | Business Partner Hierarchy Group | 4 | TREE_GUID | GUID of Hierarchy Tree | varbinary | 16 | 0 | | |
2 | BUT_HIER_NODE_BP | Business Partner Hierarchy Group - Bus. Partner Assignment | 8 | TREE_GUID | GUID of Hierarchy Tree | varbinary | 16 | 0 | | |
3 | BUT_HIER_NODE_D | Business Partner Hierarchy Group - Description | 6 | TREE_GUID | GUID of Hierarchy Tree | varbinary | 16 | 0 | | |
4 | BUT_HIER_NODE_DU | Business Partner Hierarchy Group - Description | 6 | TREE_GUID | GUID of Hierarchy Tree | varbinary | 16 | 0 | | |
5 | BUT_HIER_STRUCT | Business Partner Hierarchy Group - Hierarchy Relationship | 7 | TREE_GUID | GUID of Hierarchy Tree | varbinary | 16 | 0 | | |
6 | BUT_HIER_TREE | Business Partner Group Hierarchy | 2 | TREE_GUID | GUID of Hierarchy Tree | varbinary | 16 | 0 | | |
7 | BUT_HIER_TREE_D | Business Partner Group Hierarchy - Description | 3 | TREE_GUID | GUID of Hierarchy Tree | varbinary | 16 | 0 | | |
TOPLogistics - General |
8 | CRMC_CO_HIER | CRM-CO Interface: Hierarchy Node Table | 4 | TREE_GUID | UUID in X form (binary) | varbinary | 16 | 0 | | |
9 | CRMC_CO_HTREE_D | Description for Hierarchy Trees Created | 4 | TREE_GUID | UUID in X form (binary) | varbinary | 16 | 0 | | |