| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP10: Financial Reporting |
| 1 | F1001 | Multi-Site Consolidation Transfer File Header | 10 | GP | CNAM | Consolidation Name | String | UDC | 3 | 0 |
| 2 | F1001Z1 | Unedited MSC Interoperability Header Table | 20 | IA | CNAM | Consolidation Name | String | UDC | 3 | 0 |
| 3 | F1017 | Consolidation Specifications | 1 | CS | CNAM | Consolidation Name | String | UDC | 3 | 0 |
| 4 | F10470 | Consolidation Specifications (OW) | 1 | CS | CNAM | Consolidation Name | String | UDC | 3 | 0 |
| 5 | F10471 | Elimination Rules (OW) | 1 | ER | CNAM | Consolidation Name | 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 | | |
