| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 00: Foundation Environment | ||||||||||
| 1 | F0008 | Date Fiscal Patterns | 1 | CD | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 2 | F0008B | Date Fiscal Patterns - 52 Period Accounting | 1 | CD | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 3 | F0010 | Company Constants | 22 | CC | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 4 | F15019 | Billing Frequency Master | 17 | NL | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 12: Fixed Assets | ||||||||||
| 5 | F12851 | Depreciation Rules | 11 | LU | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 6 | F12851D | Demo Depreciation Rules | 11 | LU | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 16: Profit Management (EPS) | ||||||||||
| 7 | F1603 | Cost Analyzer View Structure | 16 | CV | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 36: Forecasting | ||||||||||
| 8 | F3470 | Demand Spreading Template | 18 | DS | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 83: Management Reporting - FASTR | ||||||||||
| 9 | F83110 | Column Headings | 1 | CH | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| 10 | F83110B | 52 Period Column Headings | 1 | CH | DTPN | Fiscal Date Pattern | Character | UDC | 1 | 0 |
| H79: CS - Forecasting | ||||||||||
| 11 | F831101 | FASTR Column Headings Language Status | 1 | LS | DTPN | Fiscal Date Pattern | 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 H00 / DP (DTPN) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | A | User defined date pattern | N | |
| 2 | B | User defined date pattern | N | |
| 3 | C | User defined date pattern | N | |
| 4 | D | User defined date pattern | N | |
| 5 | E | User defined date pattern | N | |
| 6 | F | User defined date pattern | N | |
| 7 | G | User defined date pattern | N | |
| 8 | H | User defined date pattern | N | |
| 9 | I | User defined date pattern | N | |
| 10 | J | User defined date pattern | N | |
| 11 | K | User defined date pattern | N | |
| 12 | L | User defined date pattern | N | |
| 13 | M | User defined date pattern | N | |
| 14 | N | User defined date pattern | N | |
| 15 | R | User defined date pattern | N | |
| 16 | S | 12 periods, Jan 1 - Dec 31 | N |