| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPE-Recruiting |
1 | HRP5106 | DB Table for Infotype 5106 | 25 | RESPONSIBILITY | Personnel Responsibility | nvarchar | 1 | 0 | | |
TOPLogistics Basic Data |
2 | WRF_CMMD_CDT1 | Category | 19 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
3 | WRF_CMMD_CDT2 | Subcategory | 19 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
4 | WRF_CMMD_CDT3 | Segment | 19 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
5 | WRF_CMMD_CDT4 | Subsegment | 19 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
6 | WRF_CMMD_CDT5 | Sub-Subsegment | 19 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
7 | WRF_CMMD_CDT6 | Product Group | 19 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
8 | WRF_CMMD_CDT7 | Brand | 19 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
9 | WRF_MATGRP_MD1 | Hierarchy Level 1 - Time-Dependent | 24 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
10 | WRF_MATGRP_MD10 | Hierarchy Level 10 - Time-Dependent | 33 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
11 | WRF_MATGRP_MD2 | Hierarchy Level 2 - Time-Dependent | 25 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
12 | WRF_MATGRP_MD3 | Hierarchy Level 3 - Time-Dependent | 26 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
13 | WRF_MATGRP_MD4 | Hierarchy Level 4 - Time-Dependent | 27 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
14 | WRF_MATGRP_MD5 | Hierarchy Level 5 - Time-Dependent | 28 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
15 | WRF_MATGRP_MD6 | Hierarchy Level 6 - Time-Dependent | 29 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
16 | WRF_MATGRP_MD7 | Hierarchy Level 7 - Time-Dependent | 30 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
17 | WRF_MATGRP_MD8 | Hierarchy Level 8 - Time-Dependent | 31 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
18 | WRF_MATGRP_MD9 | Hierarchy Level 9 - Time-Dependent | 32 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
19 | WRF_MATGRP_STRUC | Category Structure | 14 | RESPONSIBILITY | Responsibility | nvarchar | 20 | 0 | | |
TOPMaster Data |
20 | GMGRRESPONSIBLE | Objects responsible for the grant | 3 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |
21 | GMRESPEVENTS | Grant responsibility events | 2 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |
22 | GMRESPTYPE | Responsibility types - Sponsored programs management | 2 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |
23 | GMRESPTYPET | Responsible type text | 3 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |
24 | GMSPRESPONSIBLE | Objects responsible for the sponsored program | 3 | RESPONSIBILITY | Type of Responsibility within the Sponsored Program | nvarchar | 4 | 0 | | |
25 | GMSPRESPTYP | Responsibility Defaults for Sponsor | 3 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |
26 | GMWFAVC | GM Workflow AVC | 2 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |
27 | GMWFBUDGET | GM Workflow Grant Master | 2 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |
28 | GMWFGRANTM | GM Workflow Grant Master | 2 | RESPONSIBILITY | Type of Responsibility Within the Grant | nvarchar | 4 | 0 | | |