| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | TFK001U | User Reconciliation Groups | 3 | AGRUP | Reconciliation Group to which User Belongs | nvarchar | 3 | 0 | | |
TOPDenmark |
2 | T5MFD | Retrieval of Official Statistics for DA/DS and FA | 3 | AGRUP | HR-DK PBS key field PGROUP Denmark | nvarchar | 1 | 0 | | |
3 | T5MFH | Special Transfer Days for Wage Types | 3 | AGRUP | HR-DK PBS key field PGROUP Denmark | nvarchar | 1 | 0 | | |
4 | T5MFJ | Correct FA Absence Statistics | 3 | AGRUP | HR-DK PBS key field PGROUP Denmark | nvarchar | 1 | 0 | | |
5 | T5MP1 | General Messages for the PBS Remuneration Statement | 3 | AGRUP | HR-DK PBS key field PGROUP Denmark | nvarchar | 1 | 0 | | |
TOPMexico |
6 | T7MX17 | Breakdown groupers for the state tax basis | 2 | AGRUP | Grouper for the state tax basis breakdown | nvarchar | 2 | 0 | | |
7 | T7MX17T | Texts for breakdown groupers for the state tax basis | 3 | AGRUP | Grouper for the state tax basis breakdown | nvarchar | 2 | 0 | | |
8 | T7MX18 | Wage types for forming the state tax basis | 6 | AGRUP | Grouper for the state tax basis breakdown | nvarchar | 2 | 0 | | |
TOPSpain |
9 | T5E60 | Contract entity according to the company | 11 | AGRUP | Grouper identifier for contracts | nvarchar | 4 | 0 | | |
10 | T5E6B | Contract groupers | 2 | AGRUP | Grouper identifier for contracts | nvarchar | 4 | 0 | | |
11 | T5E6K | Contract grouper texts | 3 | AGRUP | Grouper identifier for contracts | nvarchar | 4 | 0 | | |