| 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 | | |