| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBusiness Planning |
1 | UPB_IA_IMPLIST | Planning Applications: Object Lists of Planning Applications | 2 | SUBCL | Subgrouping Within a Grouping | nvarchar | 2 | 0 | | |
TOPBusiness Planning and Simulation |
2 | UPB_IA_SUBCL | Planning Applications: Subclass | 2 | SUBCL | Subgrouping Within a Grouping | nvarchar | 2 | 0 | | |
3 | UPB_IA_SUBCLT | Planning Applications: Subclass - Text Table | 3 | SUBCL | Subgrouping Within a Grouping | nvarchar | 2 | 0 | | |
4 | UPB_MAIN_PROFILE | Planning Profiles of Planning Applications | 3 | SUBCL | Subgrouping Within a Grouping | nvarchar | 2 | 0 | | |
TOPClaims Management |
5 | ICLINDRESA | Claim-Independent Reserve - Case Reserve - Assignment | 5 | SUBCL | Subclaim | nvarchar | 3 | 0 | | |
6 | ICLRESERVE | Case Reserve | 4 | SUBCL | Subclaim | nvarchar | 3 | 0 | | |
7 | ICSRESERVE | Case Reserve | 4 | SUBCL | Subclaim | nvarchar | 3 | 0 | | |
TOPCollaboration Folders |
8 | CXM_ESIH | EasySPEC Inheritance Hierarchy | 3 | SUBCL | UUID in X form (binary) | varbinary | 16 | 0 | | |
TOPData Collection |
9 | TKCHH | SAP-EIS: Hierarchy header | 3 | SUBCL | Subgroup by application class | nvarchar | 2 | 0 | | |
10 | TKCHHT | SAP-EIS: Texts for hierarchy header | 4 | SUBCL | Subgroup by application class | nvarchar | 2 | 0 | | |
11 | TKCHN | SAP-EIS Hierarchy nodes | 3 | SUBCL | Subgroup by application class | nvarchar | 2 | 0 | | |
12 | TKCHNT | SAP-EIS: Hierarchy node texts | 4 | SUBCL | Subgroup by application class | nvarchar | 2 | 0 | | |
13 | TKCHW | SAP-EIS: Hierarchy data | 3 | SUBCL | Subgroup by application class | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
14 | TNP01 | IS-H: Patient Classes | 4 | SUBCL | IS-H SG: Patient Subsidy Class | nvarchar | 3 | 0 | | |
TOPSpain |
15 | T5E22 | Assignment between payroll and pension key/subkey | 6 | SUBCL | Subkey for form 345 for pensions | nvarchar | 2 | 0 | | |