| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP10: Financial Reporting |
| 1 | F1017 | Consolidation Specifications | 5 | CS | OTPA | Account Type Structure | String | UDC | 3 | 0 |
| 2 | F10430 | Multi-Site Consolidation - Account Structure | 1 | CF | OTPA | Account Type Structure | String | UDC | 3 | 0 |
| 3 | F10430A | Account Structure Definition | 1 | CG | OTPA | Account Type Structure | String | UDC | 3 | 0 |
| 4 | F10470 | Consolidation Specifications (OW) | 10 | CS | OTPA | Account Type Structure | String | UDC | 3 | 0 |
| 5 | F10UI001 | Account Structure Build Workfile | 2 | CF | OTPA | Account Type Structure | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / TS (Type of Structure) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Organizational | | N |
| 2 | BS | Balance Sheet for Multi-site | | N |
| 3 | COR | Corporate Competency Structure | | N |
| 4 | CS | Bank & Cash Rollup | | N |
| 5 | FIN | Financial Rollup | | |
| 6 | FUN | Functional Rollup | | |
| 7 | IS | Income Statement for Multi-sit | | N |
| 8 | OPS | Operations Rollup | | N |
| 9 | REP | Reporting | | |
