| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 12: 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.
UDC 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 |