| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ORS/USERMAP | Optura User Mapping Object | 3 | USER_STATUS | User Mapping Object Status | nvarchar | 1 | 0 | | |
2 | /SAPF15/ELKOHKR1 | F15 ELKO Daten aus HKR 1 | 38 | USER_STATUS | | nvarchar | 1 | 0 | | |
3 | /SAPF15/ELKOHKR2 | F15 ELKO Daten aus HKR 2 Satzart 2 + HKR 6 | 47 | USER_STATUS | | nvarchar | 1 | 0 | | |
4 | /SAPF15/ELKOHKR4 | F15 ELKO Daten aus HKR 4 | 29 | USER_STATUS | | nvarchar | 1 | 0 | | |
5 | /SAPF15/ELKOHKR5 | F15 ELKO Daten aus HKR 5 | 33 | USER_STATUS | | nvarchar | 1 | 0 | | |
6 | /SAPF15/ELKOHKRZ | F15 ELKO Daten aus HKR 2 Satzart 3 | 22 | USER_STATUS | | nvarchar | 1 | 0 | | |
7 | /SAPF15/ELKOZM_V | F15 Daten aus ZÜV 101, alte Versionen | 29 | USER_STATUS | | nvarchar | 1 | 0 | | |
8 | /SAPF15/ELKOZUV1 | F15 ELKO Daten aus ZÜV 100 | 28 | USER_STATUS | | nvarchar | 1 | 0 | | |
9 | /SAPF15/ELKOZUV2 | F15 ELKO Daten aus ZÜV 200 | 25 | USER_STATUS | | nvarchar | 1 | 0 | | |
10 | /SAPF15/ELKOZUV5 | F15 ELKO Daten aus ZÜV 500 | 24 | USER_STATUS | | nvarchar | 1 | 0 | | |
11 | /SAPF15/ELKOZUV6 | F15 ELKO Daten aus ZÜV 600 | 22 | USER_STATUS | | nvarchar | 1 | 0 | | |
12 | /SAPF15/ELKOZUV9 | F15 ELKO Daten aus ZÜV 900 | 18 | USER_STATUS | | nvarchar | 1 | 0 | | |
13 | /SAPF15/ELKOZUVM | F15 Daten aus ZÜV 101 | 28 | USER_STATUS | | nvarchar | 1 | 0 | | |
14 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 181 | USER_STATUS | Display lines for user status | nvarchar | 40 | 0 | | |
15 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 112 | USER_STATUS | Display lines for user status | nvarchar | 40 | 0 | | |
16 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 175 | USER_STATUS | Display lines for user status | nvarchar | 40 | 0 | | |
17 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 115 | USER_STATUS | Display lines for user status | nvarchar | 40 | 0 | | |
TOPBasis Components |
18 | /XFT/INV_C4 | Possible User Status | 2 | USER_STATUS | User status | nvarchar | 10 | 0 | | |
19 | /XFT/INV_Q | Invoice receipt queue: Header | 120 | USER_STATUS | User status | nvarchar | 10 | 0 | | |
20 | /XFT/INV_Q_S | Invoice receipt queue: Header | 120 | USER_STATUS | User status | nvarchar | 10 | 0 | | |
TOPEvaluations |
21 | DPR_DASHBOARD | Dashboard Data for Project | 16 | USER_STATUS | User Status for an Object | ntext | 1073741823 | 0 | | |
TOPMaster Data |
22 | GMFGC_1 | Obsolete - do not use | 4 | USER_STATUS | User-Defined State | nvarchar | 5 | 0 | | |
23 | GMFGC_USER | Field group criteria (Grants) system+user status | 5 | USER_STATUS | User-Defined State | nvarchar | 5 | 0 | | |
24 | GMGR | Grant Master | 45 | USER_STATUS | User Status | nvarchar | 5 | 0 | | |
25 | GMSMVALUETYPE | Value type control by grant type and status | 4 | USER_STATUS | User-Defined State | nvarchar | 5 | 0 | | |
26 | GMSTATNET | Grants Management Status Network | 5 | USER_STATUS | User-Defined State | nvarchar | 5 | 0 | | |
27 | GMSTATNETHISTORY | Historical status information Sponsored Programs Mgmt | 5 | USER_STATUS | User-Defined State | nvarchar | 5 | 0 | | |
28 | GMWFGRANTM | GM Workflow Grant Master | 6 | USER_STATUS | User Status | nvarchar | 5 | 0 | | |
TOPRecipe |
29 | RCPC_SPEC_USTATE | Customizing User Status | 5 | USER_STATUS | User Status | nvarchar | 5 | 0 | | |
TOPWork Clearance Management |
30 | WCCP | WCM: WCM Object <-> Approvals | 17 | USER_STATUS | Controlled User Status for Issuing Approval | nvarchar | 5 | 0 | | |