Taxonomy Account
The taxonomy dimension only stores taxonomy versions with status Active. Taxonomy versions that are closed are removed from the dimension. Therefore, the deleted attribute is not supported.
This table shows the tables from which fields are retrieved for the dimension:
Table | Description |
---|---|
tfgld170 | Taxonomies |
tfgld171 | Taxonomy Accounts |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Account Type | tfgld171.acty |
Account Type Filter | tfgld171.acty |
Account Type Sort | tfgld171.acty |
Company | Logical Company of tfgld171 |
Dual Accounting Indicator | tfgld170.duac |
Dual Accounting Indicator Filter | tfgld170.duac |
Dual Accounting Indicator Sort | tfgld170.duac |
Print Sequence | tfgld171.pseq |
Sublevel | tfgld171.subl |
Taxonomy | tfgld171.taxo |
Taxonomy - Version | tfgld171.taxo + ‘-‘ + tfgld171.vers |
Taxonomy Account | tfgld171.acid |
Taxonomy Account Desc | tfgld171.desc |
Taxonomy Account Hierarchy Level | Indicates the level in the hierarchy, 1 is top level. |
Taxonomy Account ID Desc | tfgld171.acid + tfgld171.desc |
Taxonomy Account Level01 till Taxonomy Account Level 15 | tfgld171.paci |
Taxonomy Account Level01 Desc till Taxonomy Account Level15 Desc | tfgld171.desc |
Taxonomy Account Level01 ID Desc till Taxonomy Account Level15 ID Desc | tfgld171.paci + tfgld171.desc |
Taxonomy Desc | tfgld170.desc |
Taxonomy Status | tfgld171.stat |
Taxonomy Status Filter | tfgld171.stat |
Taxonomy Status Sort | tfgld171.stat |
Unassigned Account | tfgld171.unas |
Unassigned Account Filter | tfgld171.unas |
Unassigned Account Sort | tfgld171.unas |
Unknown | 1 for null records, else 0 |
Version | tfgld171.vers |
Customer Defined Fields | Standard list of fields |