| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7AEPBS14 | Salary Components | 4 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
2 | T7AEPBS14T | Salary Component Text | 4 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
3 | T7AEPBS16 | Eligibility of Salary Components | 5 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
4 | T7QAW7A | Salary Components | 3 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
5 | T7QAW7AT | Salary Component Text | 4 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
6 | T7QAW7C | Eligibility of Salary Components | 4 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
7 | T7SAPBS14 | Salary Components | 3 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
8 | T7SAPBS14T | Salary Component Text | 4 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
9 | T7SAPBS16 | Eligibility of Salary Components | 4 | SCOMP | Salary Component | nvarchar | 4 | 0 | | |
10 | YIT_SAP | Application Components | 1 | SCOMP | Application component | nvarchar | 6 | 0 | | |
11 | YIT_SAPT | IDA: SAP Core Components | 1 | SCOMP | Application component | nvarchar | 6 | 0 | | |
TOPBasic Functions |
12 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 29 | SCOMP | Company | nvarchar | 6 | 0 | | |
13 | FILCP | FI-LC: Plan line items for object table | 29 | SCOMP | Company | nvarchar | 6 | 0 | | |
14 | FILCT | FI-LC: Global totals table with 2 object tables | 28 | SCOMP | Company | nvarchar | 6 | 0 | | |
15 | GGREFA | Example for Global FI-SL Line Items (Actual) | 21 | SCOMP | Sender global company | nvarchar | 6 | 0 | | |
16 | GGREFP | Example for Global FI-SL Line Items (Plan) | 21 | SCOMP | Sender global company | nvarchar | 6 | 0 | | |
17 | GGREFT | Example for Global FI-SL Summary Table | 20 | SCOMP | Sender global company | nvarchar | 6 | 0 | | |
18 | GLPO2 | Plan Line Items for Object Table Global | 29 | SCOMP | Company | nvarchar | 6 | 0 | | |
19 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 29 | SCOMP | Company | nvarchar | 6 | 0 | | |
20 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 26 | SCOMP | Company | nvarchar | 6 | 0 | | |
TOPPension fund Netherlands |
21 | T5NH5 | Werkgeversdata van de aan het pensioenfonds verbonden deeln. | 9 | SCOMP | Status van de organisatie | nvarchar | 2 | 0 | | |
22 | T5NH9 | Status organisatie van werkgevers | 3 | SCOMP | Status van de organisatie | nvarchar | 2 | 0 | | |
23 | T5NH9T | Omschrijving status organisatie van werkgevers | 4 | SCOMP | Status van de organisatie | nvarchar | 2 | 0 | | |
TOPSouth Africa |
24 | T5W7A | Salary components | 3 | SCOMP | Salary component | nvarchar | 4 | 0 | | |
25 | T5W7AT | Salary component text | 4 | SCOMP | Salary component | nvarchar | 4 | 0 | | |
26 | T5W7C | Eligibility of salary components | 4 | SCOMP | Salary component | nvarchar | 4 | 0 | | |
27 | T5W7E | Salary packaging categories | 3 | SCOMP | Salary component | nvarchar | 4 | 0 | | |
28 | T5W7ET | Salary packaging Categories | 4 | SCOMP | Salary component | nvarchar | 4 | 0 | | |
29 | T5W7G | Salary packaging: package variant data | 5 | SCOMP | Salary component | nvarchar | 4 | 0 | | |
30 | T5W7H | Salary packaging: Categories of salary components | 3 | SCOMP | Salary component | nvarchar | 4 | 0 | | |
31 | T5W7HT | Salary packaging: Text table Categories | 4 | SCOMP | Salary component | nvarchar | 4 | 0 | | |