| 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... | 7 | ZUJHR | Asset acquisition year | nvarchar | 4 | 0 | | |
2 | /ATL/AANLCP | Periodic Asset-value fields, like anlc, for all areas | 8 | ZUJHR | Asset acquisition year | nvarchar | 4 | 0 | | |
TOPBasic Functions |
3 | ANEA | Asset Line Items for Proportional Values | 8 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | | |
4 | ANEP | Asset Line Items | 8 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | | |
5 | ANLA | Asset Master Record Segment | 18 | ZUJHR | Fiscal year in which first acquisition was posted | nvarchar | 4 | 0 | | |
6 | ANLC | Asset Value Fields | 7 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | | |
7 | ANLP | Asset Periodic Values | 9 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
8 | TXW_S_ANEA | Retrieve ANEA from archive | 18 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | | |
9 | TXW_S_ANEP | Retrieve ANEP from archive | 18 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | | |
TOPHandling of Inflation |
10 | J_1AAOLDTA | Inflation Adjustment AA - Historic transact. period Balances | 7 | ZUJHR | Asset acquisition year (currently not used) | nvarchar | 4 | 0 | | |