| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T5AGR | Projection Rules (Income Report) | 9 | KONST | Payroll Parameter for Factor Determination | nvarchar | 5 | 0 | | |
2 | T5D1T | SI Assessment Threshold | 7 | KONST | Constant Name | nvarchar | 5 | 0 | | |
3 | T5FDSNCOTIS | DSN: contributions parameter setting | 21 | KONST | Target value | nvarchar | 50 | 0 | | |
4 | T5FDSNCOTIS2 | DSN: contributions parameter setting | 26 | KONST | Target value | nvarchar | 50 | 0 | | |
5 | T5NRE | Retirement Age (AOW Age) | 2 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
6 | T5W2V | South Africa - Form Names | 3 | KONST | Form constant | nvarchar | 5 | 0 | | |
7 | T703A | Incentive Wages: Replaced by T703H | 7 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPAustralia |
8 | T5QLK | Leave Liability Constants | 5 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPB2A Business to Administration |
9 | T50BK | HR-B2A: Constant Table | 5 | KONST | HR-B2A: Constant | nvarchar | 5 | 0 | | |
10 | T50BKT | HR-B2A: Text to Constant Table | 6 | KONST | HR-B2A: Constant | nvarchar | 5 | 0 | | |
11 | T50BS | HR-B2A: Client-independent constants table | 4 | KONST | HR-B2A: Constant | nvarchar | 5 | 0 | | |
TOPBasic Functions |
12 | T060K | FI constants | 2 | KONST | Name of FI constant | nvarchar | 10 | 0 | | |
13 | T060L | FI constant name | 3 | KONST | Name of FI constant | nvarchar | 10 | 0 | | |
14 | T060M | FI constant values | 6 | KONST | Name of FI constant | nvarchar | 10 | 0 | | |
TOPBrazil |
15 | T7BRAI | Inflation adjustment | 3 | KONST | Payroll parameter for amounts | nvarchar | 5 | 0 | | |
TOPCanada |
16 | T5KB1 | Definition of Business Number, Canada | 7 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
17 | T5KYS | No longer used | 13 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPClinical System |
18 | N2DGAIST | ISH*MED : Steuerung Schnittstelle Datenexport | 10 | KONST | IS-H*MED: Sabit deger | nvarchar | 20 | 0 | | |
TOPCompany Pension Scheme Germany |
19 | T5DC1 | Constants for Company Pension Scheme | 3 | KONST | Constant for Company Pension Scheme | nvarchar | 5 | 0 | | |
20 | T5DC2 | Texts for Constants for Company Pension Schemes | 4 | KONST | Constant for Company Pension Scheme | nvarchar | 5 | 0 | | |
21 | T5DCZ | Imputation Rules for Company Pension Scheme | 10 | KONST | Constant for Imputation | nvarchar | 5 | 0 | | |
TOPConstruction Industry |
22 | T5DBJ | Texts for Construction Pay Constants | 3 | KONST | Construction Pay Constant | nvarchar | 5 | 0 | | |
23 | T5DBK | Construction Pay Constants | 2 | KONST | Construction Pay Constant | nvarchar | 5 | 0 | | |
24 | T5DBP | Data for Year-End Bonus (Construction Industry) | 14 | KONST | Constant for Year-End Bonus | nvarchar | 5 | 0 | | |
TOPDenmark |
25 | T5M8X | Interface: PBS Constants as T511K Constants | 5 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
26 | T5MFB | FA Statistics: Values for Validation | 1 | KONST | Character Field Length = 10 | nvarchar | 10 | 0 | | |
TOPFrance |
27 | T5F1H | Change contribution calculation base | 14 | KONST | Constant from table T511K | nvarchar | 5 | 0 | | |
28 | T5F1K | Calc. bases for exempt. of costs for spec. contracts (FR) | 11 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPIndia |
29 | T7INR3 | Constants related to HRA code | 3 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
30 | T7INR5 | Text for statutory constants related to housing | 2 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPNon Profit Organizations |
31 | T7UNPAD_DSLC | Duty Station Home Leave Cycle | 4 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
32 | T7UNPAD_EG05 | NPO: EG Settings for Country | 4 | KONST | Country Key | nvarchar | 3 | 0 | | |
33 | T7UNPAD_EGAMT | NPO: EG Entitlements | 4 | KONST | Country Key | nvarchar | 3 | 0 | | |
TOPPayroll |
34 | T5H1V | Bérszámfejtési konstansok vállalatonként | 3 | KONST | Bérszámfejtési konstans | nvarchar | 5 | 0 | | |
35 | T5H1VT | Bérszámfejtési állandók megnevezése vállalatonként | 4 | KONST | Bérszámfejtési konstans | nvarchar | 5 | 0 | | |
36 | T5H2B | Year-end (tax) certificates elements | 11 | KONST | Constant name | nvarchar | 5 | 0 | | |
TOPPayroll General Parts |
37 | T510H | Payroll Parameters for Time Unit | 3 | KONST | Payroll parameter related to time unit | nvarchar | 5 | 0 | | |
38 | T511K | Payroll Parameters | 3 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
39 | T511P | International Payroll Constants | 3 | KONST | Payroll parameter for amounts | nvarchar | 5 | 0 | | |
40 | T511T | Designation of Payroll Constant Amounts | 4 | KONST | Payroll parameter for amounts | nvarchar | 5 | 0 | | |
41 | T512K | Text for Payroll Constants Regarding Time Units | 4 | KONST | Payroll parameter related to time unit | nvarchar | 5 | 0 | | |
42 | T512L | Payroll Constant Designations | 4 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPPersonnel Administration |
43 | T510B | Appraisal Constants | 8 | KONST | Valuation constant | decimal | 5 | 2 | | |
TOPPublic Sector |
44 | T5D7Q | Models for Control of Contribution | 10 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
45 | T5D7R | Models for Controlling Vacation Bonus | 8 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
46 | T5DPBS07 | Special and Non-Recurring Payments: Constants | 3 | KONST | Constant for Special and Non-Recurring Payments | nvarchar | 10 | 0 | | |
47 | T5DPBS08 | Spec. and Non-Rec. Payts, Fixed Amts for Each Pay Scale Grp | 4 | KONST | Constant for Special and Non-Recurring Payments | nvarchar | 10 | 0 | | |
48 | T5DPBS0E | Spec. and Non-Rec. Payments: Pay Scale-Dependent Percentages | 4 | KONST | Constant for Special and Non-Recurring Payments | nvarchar | 10 | 0 | | |
TOPReporting |
49 | P05_TTFM | Mapping: Tax Table - Function Module | 6 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPReuse Services for Country Development |
50 | T5DF4 | Control Statement Wage Types | 8 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPSouth Africa |
51 | T5W1K | Pension Funds and Medical Aid Schemes (RSA) | 23 | KONST | Gap Insurance Constant | nvarchar | 5 | 0 | | |
52 | T5W1N | Social insurance schemes | 10 | KONST | Gap Insurance Constant | nvarchar | 5 | 0 | | |
TOPSpain |
53 | T5E92 | Deduction groups for garnishments | 7 | KONST | Payroll parameter for amounts | nvarchar | 5 | 0 | | |
54 | T5EI3 | Employment tax control constants | 3 | KONST | Control constant | nvarchar | 6 | 0 | | |
55 | T5EI4 | Employment tax amount constants | 3 | KONST | Amount constant | nvarchar | 6 | 0 | | |
56 | T5EII | Employment tax control constant texts | 4 | KONST | Control constant | nvarchar | 6 | 0 | | |
57 | T5EIJ | Texts of unemployment tax amount constants | 4 | KONST | Amount constant | nvarchar | 6 | 0 | | |
TOPTime Tickets |
58 | T703H | Incentive Wages: Parameters for Premium Formulas | 7 | KONST | Payroll constant | nvarchar | 5 | 0 | | |
TOPTravel Expenses |
59 | T706_CONST | PA parameters: Travel Management | 3 | KONST | Payroll Constant | nvarchar | 5 | 0 | | |
60 | T706_CONSTTEXT | Names of Accounting Constants for Travel Expenses | 4 | KONST | Payroll Constant | nvarchar | 5 | 0 | | |