| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/AANLC | Asset-value fields, like anlc, for areas 11,12... | 8 | ZUCOD | Sub-classification of asset acquisitions | nvarchar | 4 | 0 | | |
2 | /ATL/AANLCP | Periodic Asset-value fields, like anlc, for all areas | 9 | ZUCOD | Sub-classification of asset acquisitions | nvarchar | 4 | 0 | | |
TOPBasic Functions |
3 | ANEA | Asset Line Items for Proportional Values | 9 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | | |
4 | ANEP | Asset Line Items | 9 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | | |
5 | ANLC | Asset Value Fields | 8 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | | |
6 | ANLP | Asset Periodic Values | 10 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
7 | TXW_S_ANEA | Retrieve ANEA from archive | 19 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | | |
8 | TXW_S_ANEP | Retrieve ANEP from archive | 28 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | | |
TOPHandling of Inflation |
9 | J_1AAOLDTA | Inflation Adjustment AA - Historic transact. period Balances | 8 | ZUCOD | Sub-classification of asset acquisitions(currently not used) | nvarchar | 4 | 0 | | |