| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RM_MVAC | Payroll Structure MVAC: Leave Handling (DK) | 7 | UTYPE | Leave type, duplicate of SUPTYPE DK | nvarchar | 4 | 0 | | |
| 2 | YIT_R1ACC | IDA: Reference Table ACC | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 3 | YIT_R1ASS | IDA: Reference Table ASS | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 4 | YIT_R1BNK | IDA: Reference Table BNK | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 5 | YIT_R1BOM | IDA: Reference Table BOM | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 6 | YIT_R1CAT | IDA: Reference Table CAT | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 7 | YIT_R1COE | IDA: Reference Table COE | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 8 | YIT_R1COS | IDA: Reference Table COS | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 9 | YIT_R1CRE | IDA: Reference Table CRE | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 10 | YIT_R1DEB | IDA: Reference Table DEB | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 11 | YIT_R1DOC | IDA: Reference Table DOC | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 12 | YIT_R1EQU | IDA: Reference Table EQU | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 13 | YIT_R1IPR | IDA: Reference Table IPR | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 14 | YIT_R1MAT | IDA: Reference Table MAT | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 15 | YIT_R1MPL | IDA: Reference table MPL | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 16 | YIT_R1NET | IDA: Reference table NET | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 17 | YIT_R1OBJ | IDA: Reference table OBJ | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 18 | YIT_R1ORD | IDA: Reference table ORD | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 19 | YIT_R1PER | IDA: Reference table PER | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 20 | YIT_R1PRC | IDA: Reference Table COS | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 21 | YIT_R1PRO | IDA: Reference table PRO | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 22 | YIT_R1ROU | IDA: Reference table ROU | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 23 | YIT_R1STN | IDA: Reference table STN | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 24 | YIT_R1STP | IDA: Reference table STP | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 25 | YIT_R1TPL | IDA: Reference Table TPL | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 26 | YIT_R1WOR | IDA: Reference Table WOR | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 27 | YIT_R1__1 | IDA: Reference Table __1 Org. Units | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 28 | YIT_R1__2 | IDA: Reference Table __2 Application Customizing | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 29 | YIT_RDOCU | IDA: Reference Table Documents | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 30 | YIT_REF | IDA: Assignment Table - General | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 31 | YIT_REFMAT | IDA: Assignment Table MAT | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 32 | YIT_ROLE | Areas of responsibility | 1 | UTYPE | Usage type IDES Infobase | nvarchar | 2 | 0 | | |
| 33 | YIT_ROLET | Roles | 2 | UTYPE | Usage type IDES Infobase | nvarchar | 2 | 0 | | |
| 34 | YIT_RTCODE | IDA: Reference Table for Transaction Codes | 1 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 35 | YIT_STATU | IDA: Status | 2 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 36 | YIT_USERDATA | IDA: User Data | 3 | UTYPE | IDA type of use | nvarchar | 1 | 0 | | |
| 37 | YIT_USETYPE | Infobase usage types | 1 | UTYPE | Usage type IDES Infobase | nvarchar | 2 | 0 | | |
| 38 | YIT_USETYPEL | Infobase usage types | 2 | UTYPE | Usage type IDES Infobase | nvarchar | 2 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 39 | DFKKCMUSER | Additional User for Collections Management | 3 | UTYPE | User Types for Collections Management | nvarchar | 1 | 0 | | |
| TOPDefense Forces and Public Security |
| 40 | PA0800 | Personal Master Record Infotype 0800 | 30 | UTYPE | Usage Type | nvarchar | 1 | 0 | | |
| TOPDenmark |
| 41 | PA0074 | HR Master Record: Infotype 0074 (Leave Processing - DK) | 63 | UTYPE | Leave type, duplicate of SUPTYPE DK | nvarchar | 4 | 0 | | |
| 42 | T5M6P | Default Values for Leave Accumulation | 44 | UTYPE | Leave type, duplicate of SUPTYPE DK | nvarchar | 4 | 0 | | |
| 43 | T5V3C | Types of Vacation Allowance Calculation Units (DK/N) | 3 | UTYPE | Type of Entitlement to Vacation Allowance (DK/N) | nvarchar | 2 | 0 | | |
| 44 | T5V3D | Texts for T5V3C (DK/N) | 3 | UTYPE | Type of Entitlement to Vacation Allowance (DK/N) | nvarchar | 2 | 0 | | |
| TOPLogbook |
| 45 | DIACL_LETYP_T | Log Entry Type table | 4 | UTYPE | Log Entry Usage Type | nvarchar | 1 | 0 | | |
| 46 | DIACL_LOG_ENTRY | Logbook: log entry | 20 | UTYPE | Log Entry Usage Type | nvarchar | 1 | 0 | | |
