| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP12: Fixed Assets |
1 | F12003 | Default Depreciation Constants | 7 | FF | ITAC | Depreciation Information | Character | UDC | 1 | 0 |
2 | F1202 | Asset Account Balances File | 37 | FL | ITAC | Depreciation Information | Character | UDC | 1 | 0 |
3 | F1202P | Asset Account Balances Purge Table | 37 | FL | ITAC | Depreciation Information | Character | UDC | 1 | 0 |
4 | F12851 | Depreciation Rules | 4 | LU | ITAC | Depreciation Information | Character | UDC | 1 | 0 |
5 | F12851D | Demo Depreciation Rules | 4 | LU | ITAC | Depreciation Information | Character | UDC | 1 | 0 |
6 | F12852 | Annual Depreciation Rules | 3 | LV | ITAC | Depreciation Information | Character | UDC | 1 | 0 |
7 | F12852D | Demo Annual Depreciation Rules | 3 | LV | ITAC | Depreciation Information | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 12 / AC (Apportionment Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | First Day of First Month | | Y |
2 | 0 | No ITC Taken | | Y |
3 | 1 | Three Year Method (3 1/3 %) | | Y |
4 | 2 | Five Year Method (6 2/3%) | | Y |
5 | 3 | Seven Year Method (10%) | | Y |
6 | 4 | ACRS W/Basis Reduction -10%ITC | | Y |
7 | 5 | ACRS W/O Basis Reduction | | Y |
8 | A | Actual Depreciation Start | | Y |
9 | F | First-half/2nd-half convention | | Y |
10 | G | German Half Year Method | | Y |
11 | H | Half-Year | | Y |
12 | M | Mid-Month Convention | | Y |
13 | N | 1st Day of Next Period | | Y |
14 | P | Middle of Period | | Y |
15 | Q | Mid-Quarter Convention | | Y |
16 | R | 1st Day of Next Year | | Y |
17 | S | 1st Actual/2nd Period Start | | Y |
18 | U | Mid-Quarter Non-Calendar Date | | Y |
19 | W | Whole year Convention | | Y |
20 | Y | Mid-Year Convention | | Y |