| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | J_3R_INV26_SET | Table Grouping of General Ledger Accounts | 4 | SECTN | Section types | nvarchar | 2 | 0 | | |
2 | P2RB_BEEVL | Payroll Results: Belgium table for Evaluation | 20 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
3 | P2RF_FMD | Payroll results: Master data | 10 | SECTN | Section (labor court elections) | nvarchar | 1 | 0 | | |
4 | T5BSDOG0 | SDoG: Historical and External Data | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
5 | T5BSDOGS | SDoG: Sections | 2 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
6 | T5BSDOGST | SDoG: Sections Text | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
7 | T5BSDOGSW | SDoG: Sections (SAP entries) | 1 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
8 | T5BSDOGSWT | SDoG: Sections Text (SAP entries) | 2 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
9 | T5F99FCD | Forms: Code list (by type) | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
10 | T5F99FCDT | Forms: Code Value List Text | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
11 | T5F99FE | Forms: Error code list | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
12 | T5F99FET | Forms: Error code list TEXT | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
13 | T5F99FMAP | Mapping table for declarations | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
14 | T5F99FMAPS | Mapping table for declarations (system table) | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
15 | T5F99FSC | Forms: Sections - Country Additional Data | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
16 | T5FDSNABCAT | Absence categories for DSN | 5 | SECTN | | nvarchar | 4 | 0 | | |
17 | T5FDSNCONDI | DSN: Definitions of conditions | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
18 | T5FDSNCOTIS | DSN: contributions parameter setting | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
19 | T5FDSNCOTIS2 | DSN: contributions parameter setting | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
20 | T5FDSNSECTN | DSN: references classes for section | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
21 | T5FDSNSECVI | DSN : Section to hide to end-user | 3 | SECTN | Section | nvarchar | 4 | 0 | | |
22 | T5FDSNTDCPSECTN | Assignment of DAQ section to parameter set | 1 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
23 | T5FDSN_GEN_SECTN | DSN: Generated sections | 5 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
24 | T5FITCORR | Corrections infotype, presetting table | 7 | SECTN | Section | nvarchar | 4 | 0 | | |
25 | T5FITCORRC | Corrections infotype, presetting table | 8 | SECTN | Section | nvarchar | 4 | 0 | | |
26 | T5ITF24BG | Module group table | 7 | SECTN | F24: Compensated tax payer's reference number section | nvarchar | 15 | 0 | | |
27 | T5ITUI_2 | User Data Table for Report / Legal Form | 4 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
28 | T7RU_STAT_VFLD | View Variant Fields | 5 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
29 | T7RU_STAT_VFLD_T | Names of View Variant Fields | 6 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
TOPBelgium |
30 | T5BX2 | Assign Description text to BELCOTAX form, BOW (Obsolete) | 10 | SECTN | Section | nvarchar | 4 | 0 | | |
31 | T5BX5 | Define sections to BELCOTAX forms (Obsolete) | 3 | SECTN | Section | nvarchar | 4 | 0 | | |
32 | T5BX5TXT | Description of BELCOTAX form section (Obsolete) | 4 | SECTN | Section | nvarchar | 4 | 0 | | |
33 | T5BX6 | Assign Description texts to BELCOTAX forms, BOW | 3 | SECTN | Section of BOW print form | nvarchar | 4 | 0 | | |
34 | T5BX8 | Define sections to BELCOTAX forms | 3 | SECTN | Section of BOW print form | nvarchar | 4 | 0 | | |
35 | T5BX8T | Description of BELCOTAX form section | 4 | SECTN | Section of BOW print form | nvarchar | 4 | 0 | | |
TOPFrance |
36 | PA0217 | Infotype 0217 (INSEE Code) | 29 | SECTN | Section (labor court elections) | nvarchar | 1 | 0 | | |
37 | T5F1BC | Contribution base nature type code mapping | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
38 | T5F1BD | Contribution basis type code by application | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
39 | T5F1BDT | Wage type text contribution basis type code | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
40 | T77TNMFR_FS | Forms: Sections | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
TOPItaly |
41 | PA3206 | HR Master Record: Infotype 3206 | 24 | SECTN | DMA Section | nvarchar | 4 | 0 | | |
42 | T5IT33 | Events and reasons | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
43 | T5IT34 | Events and reasons | 3 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
44 | T5ITDMA_1 | Fixed values for DMA DAQ fields | 5 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
45 | T5ITDMA_2 | Fund values for DAQ fields | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
46 | T5ITNP | Table for print contribution | 13 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
47 | T5ITUA | User Data Table of the Company for Report/ Legal Form | 6 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
48 | T5ITUB | Report: report field mapping - output boxes | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
49 | T5ITUD | Report: report and attribution fields | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
50 | T5ITUDT | Report: field texts | 4 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
51 | T5ITUDT_C | Report: field texts | 4 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
52 | T5ITUD_C | Report: report and attribution fields | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
53 | T5ITUG | Unified reporting: output generation | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
54 | T5ITUG_C | Unified reporting: output generation | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
55 | T5ITUI | User Data Table for Report / Legal Form | 4 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
56 | T5ITUP | Report: post-processing field step | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
57 | T5ITUP_C | Report: post-processing field step | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
58 | T5ITUS | Report: section | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
59 | T5ITUST | Report: section text | 4 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
60 | T5ITUS_C | Report: section | 3 | SECTN | Report: section/part | nvarchar | 10 | 0 | | |
61 | T5ITVR | definizione di variabili di UR per condizioni | 7 | SECTN | Report: sezione/parte | nvarchar | 10 | 0 | | |
TOPPayroll |
62 | T7UA_STAT_VAR | Variant Name of Statistical Report | 7 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
63 | T7UA_STAT_VFLD | View Variant Fields | 5 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
64 | T7UA_STAT_VFLD_T | Names of View Variant Fields | 6 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
TOPPension fund General Parts |
65 | T72T2 | HR-PF: TS Data Areas | 5 | SECTN | Data Area | nvarchar | 4 | 0 | | |
66 | T72T2T | HR-PF: TS Data Areas | 6 | SECTN | Data Area | nvarchar | 4 | 0 | | |
67 | T72T3 | HR-PF: TS Characteristics of Data Areas | 6 | SECTN | Data Area | nvarchar | 4 | 0 | | |
TOPReuse Services for Country Development |
68 | T5F99AD | Date Types by DAQ Application | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
69 | T5F99ADT | Infotype 0041 date mapping types text DAQ | 5 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
70 | T5F99DM | Mapping of Infotype 0041 Date Types for DAQ applications | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
71 | T5F99FD | Forms: Construct | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
72 | T5F99FS | Forms: Sections | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
73 | T5F99FST | Forms: Sections description | 5 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |
74 | T799BHRF02 | HRF Report sections | 4 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
75 | T799BHRF02C | HRF Report customer sections | 4 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
76 | T799BHRF02T | HRF Report sections texts | 5 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
77 | T799BHRF03 | HRF Report fields | 4 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
78 | T799BHRF03C | HRF Report customer fields | 4 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
79 | T799BHRF03T | HRF Report fields texts | 5 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
80 | T799BHRF04 | HRF Report output generation | 4 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
81 | T799BHRF04C | HRF Report customer output generation | 4 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
82 | T799BHRF06 | HRF Report Post Processing | 8 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
83 | T799BHRF06C | HRF Report Customer Post Processing | 8 | SECTN | Report: section/part | nvarchar | 30 | 0 | | |
TOPSpain |
84 | T5EF7 | DAQ fields definition extension | 4 | SECTN | Forms: Section | nvarchar | 4 | 0 | | |