| 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... | 61 | AAFAV | Proportional cumulative unplanned depreciation | decimal | 13 | 2 | | |
2 | /ATL/AANLCP | Periodic Asset-value fields, like anlc, for all areas | 62 | AAFAV | Proportional cumulative unplanned depreciation | decimal | 13 | 2 | | |
TOPBasic Functions |
3 | ANEA | Asset Line Items for Proportional Values | 14 | AAFAV | Proportional cumulative unplanned depreciation | decimal | 13 | 2 | | |
4 | ANLC | Asset Value Fields | 61 | AAFAV | Proportional cumulative unplanned depreciation | decimal | 13 | 2 | | |
TOPData Retention Tool |
5 | TXW_S_ANEA | Retrieve ANEA from archive | 33 | AAFAV | Proportional cumulative unplanned depreciation | nvarchar | 16 | 0 | | |
TOPLocal Currency Changeover |
6 | EWUANLAVOR | EWU conversion: Table for marking assets before conversion | 32 | AAFAV | Val.adj. on accum. unplanned deprec. is positive/negative/0 | nvarchar | 1 | 0 | | |