| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T536A | Addresses | 3 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
2 | T703 | Incentive Wages: Operation Features | 4 | VARGU | Variable key in T703 | nvarchar | 18 | 0 | | |
TOPBenefits |
3 | T74HE | Benefit payment model assignment | 4 | VARGU | Variable key from feature | nvarchar | 4 | 0 | | |
TOPCompensation Management |
4 | T510R | Pay Scale Reclassification | 8 | VARGU | Variable Key for Table T510R (Pay Scale Reclassification) | nvarchar | 3 | 0 | | |
5 | T510_PSRCL | Pay scale reclassification | 8 | VARGU | Variable Key for Table T510R (Pay Scale Reclassification) | nvarchar | 3 | 0 | | |
TOPHong Kong |
6 | T7HK1C | Tax grouping for report | 6 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
TOPPayroll |
7 | T5T1K | Health insurance institutions | 25 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
8 | T5T1L | Bank accounts of authorities (tax,insurance) | 20 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
9 | T5TPS1L | Bank accounts of authorities (tax,insurance) | 22 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
10 | T7RO10 | Insurance institutions | 6 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
11 | T7RO20 | Tax institutions | 7 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
12 | T7RO536A | Company information | 2 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
13 | T7ROG1 | EE register - ER history | 4 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
14 | T7ROG2 | EE register - EE history | 7 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
15 | T7ROG3 | EE register - EE history | 7 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
16 | T7ROG5 | EE register - ER history | 4 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
17 | T7ROG6 | EE register - EE history | 8 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
18 | T7ROG7 | EE register - Contract History | 8 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
19 | T7SK1L | Bank accounts of authorities (tax,insurance) | 23 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
20 | T549B | Company Features | 3 | VARGU | Variable key for T549B | nvarchar | 18 | 0 | | |
21 | T549C | Decision Trees for Features (Customers) | 4 | VARGU | Variable key for T549B | nvarchar | 18 | 0 | | |
22 | T549V | Recurr. Pymts/Deds: Default Values for Payment Model | 3 | VARGU | Variable key from feature | nvarchar | 4 | 0 | | |
TOPPersonnel Management |
23 | PA0564 | HR Master Record: Infotype 0564 | 25 | VARGU | Statistical unit | nvarchar | 8 | 0 | | |
24 | T7HR01P | Personnel Area/Subarea Groupings for Croatia | 5 | VARGU | Statistical unit | nvarchar | 8 | 0 | | |
TOPPublic Sector |
25 | PA0230 | Personnel Master Data Infotype 0230/View 0008 PSG | 37 | VARGU | Variable Key for Table T510R (Pay Scale Reclassification) | nvarchar | 3 | 0 | | |
26 | T5APBS06 | Pay scale reclassification | 8 | VARGU | Type of Pay Scale | nvarchar | 3 | 0 | | |
27 | T5APBS09 | Variable SI Percentages for Public Sector | 6 | VARGU | Variable Key for T5APBS09 | nvarchar | 3 | 0 | | |
28 | T5D7LN | Next Pay Scale Group for Higher/Lower Grouping | 7 | VARGU | Variable Key for Table T510R (Pay Scale Reclassification) | nvarchar | 3 | 0 | | |
29 | T5DPBS1F | Variable Key for Step Increase | 2 | VARGU | Variable Key for Table T510R (Pay Scale Reclassification) | nvarchar | 3 | 0 | | |
30 | T5DPBS1FT | Variable Key for Step Increase (Texts) | 3 | VARGU | Variable Key for Table T510R (Pay Scale Reclassification) | nvarchar | 3 | 0 | | |
31 | T5DPBS1G | Validity of Variable Key for Each Pay Scale Group | 7 | VARGU | Variable Key for Table T510R (Pay Scale Reclassification) | nvarchar | 3 | 0 | | |
TOPSouth Africa |
32 | T5W1H | Medical Aid Payment model Assignment | 4 | VARGU | Variable key from feature | nvarchar | 4 | 0 | | |
33 | T5W66 | SARS Interface : PAYE Reference Number Attributes | 6 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |
34 | T5W71 | UIF interface : Reference number attributes | 5 | VARGU | Layout rule for address type | nvarchar | 8 | 0 | | |