| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHPRCC_IMMAP | Mapping table | 8 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
TOPEnvironment, Health and Safety |
2 | /TDAG/CPC_EXMAP | CP: Export Mapping | 7 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
3 | /TDAG/CPC_IMMAP | Mapping table | 8 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
4 | /TDAG/CPC_REP005 | CP: Define attributes for element | 7 | IDCAT | Identification Category | nvarchar | 10 | 0 | | |
TOPProduct Safety |
5 | ESTOCC | EHS: OCC: Table for Saving Import Information | 8 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
6 | ESTRI | EHS: Identifier (Numbers, Names, Chemical Formulas) | 17 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
7 | TCG23 | EHS: Identification Type | 3 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
8 | TCG23OBJ | EHS: Identification Type - Specification Categ. Assignment | 3 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
9 | TCG24 | EHS: Language-Dependent Desc. for Identification Type | 4 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
10 | TCG28 | EHS: Definition of identification listings | 7 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
11 | TCGHITPOS | EHS: Set of hit items | 11 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
12 | TCGRULPOSIDCHG | EHS: Easy Expert Set of Rules, Ident. Changes | 6 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
13 | TCGTPLI | EHS: Inheritance Templates - Identifiers | 16 | IDCAT | Identification Type | nvarchar | 10 | 0 | | |
TOPReal Estate Management |
14 | TIVLICAG | ICI County Rate | 3 | IDCAT | Category ID | nvarchar | 4 | 0 | | |
15 | TIVLICAH | ICI County Rate | 3 | IDCAT | Category ID | nvarchar | 4 | 0 | | |
16 | TIVLICTG | ICI cadastral categories | 2 | IDCAT | Category ID | nvarchar | 4 | 0 | | |
17 | TIVLICTX | ICI cadastral categories texts | 3 | IDCAT | Category ID | nvarchar | 4 | 0 | | |
18 | VILIC | ICI Historical Data | 17 | IDCAT | Category ID | nvarchar | 4 | 0 | | |