| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRP1643 | DB Table for Infotype 1643 | 24 | GNGRP | General Group | nvarchar | 1 | 0 | | |
2 | HRP5221 | DB Table for Infotype 5221 | 19 | GNGRP | General Group | nvarchar | 1 | 0 | | |
3 | T7AE29 | Emiratization Target | 6 | GNGRP | General Group | nvarchar | 1 | 0 | | |
4 | T7AEPBS03 | General Group | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
5 | T7AEPBS03T | General Group Text | 4 | GNGRP | General Group | nvarchar | 1 | 0 | | |
6 | T7AEPBS04 | Job Class Group | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
7 | T7AEPBS04T | Job Class Group Text | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
8 | T7AEPBS05 | Job Categories Series | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
9 | T7AEPBS05T | Job Categories Series Text | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
10 | T7AEPBS06 | Job Classification | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
11 | T7AEPBS20 | Job Speciality Rule | 5 | GNGRP | General Group | nvarchar | 1 | 0 | | |
12 | T7AEPBS32 | UAE PbS: Assign Promotion Type to Promotion Rule | 5 | GNGRP | General Group | nvarchar | 1 | 0 | | |
13 | T7AEPBS56 | Job classification based education details for UAE PBS | 2 | GNGRP | General Group | nvarchar | 1 | 0 | | |
14 | T7SAPBS03 | General Group | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
15 | T7SAPBS03T | General Group Text | 4 | GNGRP | General Group | nvarchar | 1 | 0 | | |
16 | T7SAPBS04 | Cluster | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
17 | T7SAPBS04T | Cluster Text | 4 | GNGRP | General Group | nvarchar | 1 | 0 | | |
18 | T7SAPBS05 | Job Categories Series | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
19 | T7SAPBS05T | Job Categories Series Text | 4 | GNGRP | General Group | nvarchar | 1 | 0 | | |
20 | T7SAPBS06 | Job Classification | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
21 | T7SAPBS20 | Job Speciality Rule | 5 | GNGRP | General Group | nvarchar | 1 | 0 | | |
22 | T7SAPBS20R | Job Speciality Rule | 7 | GNGRP | General Group | nvarchar | 1 | 0 | | |
23 | T7SAPBS34 | Assign Pay Scale to Job Classification | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
24 | T7SAPBS65 | Job Relational Education | 3 | GNGRP | General Group | nvarchar | 1 | 0 | | |
25 | T7SAPBS68 | General Group (Customer) | 3 | GNGRP | General Group (Customer) | nvarchar | 1 | 0 | | |
26 | T7SAPBS68T | General Group Text (Customer) | 4 | GNGRP | General Group (Customer) | nvarchar | 1 | 0 | | |
27 | T7SAPBS69 | Cluster (Customer) | 3 | GNGRP | General Group (Customer) | nvarchar | 1 | 0 | | |
28 | T7SAPBS69T | Cluster Text (Customer) | 4 | GNGRP | General Group (Customer) | nvarchar | 1 | 0 | | |
29 | T7SAPBS70 | Job Categories Series (Customer) | 3 | GNGRP | General Group (Customer) | nvarchar | 1 | 0 | | |
30 | T7SAPBS70T | Job Categories Series Text (Customer) | 4 | GNGRP | General Group (Customer) | nvarchar | 1 | 0 | | |
31 | T7SAPBS71 | Job Classification (Customer) | 3 | GNGRP | General Group (Customer) | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
32 | JDTPVA | IS-M/SD: Editions | 35 | GNGRP | Edition generation grouping | nvarchar | 6 | 0 | | |