| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | SFTT_SN | Shift Notes: Master Data | 11 | REFOBJ | Object Type | nvarchar | 10 | 0 | | |
TOPBusiness Application Support |
2 | CNVOBJECTS | Conversion: Objects involved in selective conversion | 7 | REFOBJ | Conversion: Objects | nvarchar | 40 | 0 | | |
TOPConstruction Equipment Management |
3 | J_3GSTLPOS | Item Data for Equipment BOMs | 8 | REFOBJ | Key of configurable object | nvarchar | 50 | 0 | | |
TOPIndustrial Hygiene and Safety |
4 | CCIHT_ACH | EHS: Safety Measures - Header | 18 | REFOBJ | Reference Object | nvarchar | 3 | 0 | | |
5 | CCIHT_IHVA | EHS: Value Assignment Data Records for Classific. System | 17 | REFOBJ | Reference Object | nvarchar | 3 | 0 | | |
6 | CCIHT_IP | EHS: List of Persons Involved | 16 | REFOBJ | Reference Object | nvarchar | 3 | 0 | | |
7 | CCIHT_IPEVINJ | EHS: Injuries to Person Affected | 16 | REFOBJ | Reference Object | nvarchar | 3 | 0 | | |
8 | CCIHT_RC | EHS: Accident Causes (Root Causes) | 19 | REFOBJ | Reference Object | nvarchar | 3 | 0 | | |
TOPLoans Management |
9 | VDARLOBJ | Loan objects relationship table | 7 | REFOBJ | Reference object for jointly liable objects | nvarchar | 10 | 0 | | |
10 | VDHGRPF | Encumbrances on real estate table | 41 | REFOBJ | Collateral object number | nvarchar | 10 | 0 | | |
TOPMedia Product Sales and Distribution |
11 | JKSDQMSG | Quality Notification | 7 | REFOBJ | Object Type | nvarchar | 10 | 0 | | |
TOPOccupational Health |
12 | T7EHS00_SERVICE | Medical Service (Main Table) | 31 | REFOBJ | Reference Object | nvarchar | 3 | 0 | | |
TOPQuality Inspection |
13 | QAMVRMS | Insp. Specifications/Valuation for Multiple Specifications | 5 | REFOBJ | Reference to Object for Multiple Specification | nvarchar | 8 | 0 | | |
14 | QAOBJMS | Multiple Specifications - Objects | 3 | REFOBJ | Reference to Object for Multiple Specification | nvarchar | 8 | 0 | | |
15 | QASRMS | Confirmation Data for Multiple Specification Sample | 5 | REFOBJ | Reference to Object for Multiple Specification | nvarchar | 8 | 0 | | |
TOPWarranty Claim Processing |
16 | CWTY008 | Characteristics for Warranty | 2 | REFOBJ | Type of Warranty Object | nvarchar | 4 | 0 | | |
17 | CWTY009 | Reference Objects | 2 | REFOBJ | Type of Warranty Object | nvarchar | 4 | 0 | | |
TOPWork Clearance Management |
18 | WCAAP | WCM: Application | 66 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
19 | WCACN | WCM: (Temporary) Log (Tag/Test Tag) | 17 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
20 | WCACNQ | WCM: Log (Operational Tag) | 18 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
21 | WCAHE | WCM: Work Clearance Document (Header) | 67 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
22 | WCAIT | WCM: Work Clearance Document (Item) | 35 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
23 | WCAJ | WCM: Lineup | 22 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
24 | WCAK | WCM: Verification List (Header Data) | 8 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
25 | WCAME | WCM: (Temporary) Log of Operational Lists (Items) | 37 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
26 | WCAT | WCM: Templates | 3 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
27 | WCAW | WCM: Work Approval | 64 | REFOBJ | Template (Object Number) | nvarchar | 22 | 0 | | |
TOPWorkbench Utilities |
28 | SPAR_ASS | Parameter Storage: Assignment of Object to Parameter | 4 | REFOBJ | Name of Dictionary Type | nvarchar | 30 | 0 | | |
29 | SPAR_NTDB | Parameter Storage: Persistent Nametab Container | 2 | REFOBJ | Name of Dictionary Type | nvarchar | 30 | 0 | | |