| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDangerous Goods Management |
1 | CCDUTDGRELLKEY | DG: Dummy Table for Lock Obj. on Log. Key for CCDUTDGREL | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
2 | DGTEXCCHKMETH | Exceptions to Dangerous Goods Regulations: Check Methods | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
3 | TDG61 | DG: Regulations | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
4 | TDG63 | DG: Derivation of Regulations | 4 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
5 | TDG69 | DG: Define Checkbox Structure for Filling/Distribution | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
6 | TDG70 | DG: Checkbox Structure Description for Filling/Distribution | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
7 | TDG71 | DG: Define Checkbox Struct. for Filling/Distribution (Pack.) | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
8 | TDG72 | DG: Checkbox Structure Desc. for Filling/Distrib. (Packag.) | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
9 | TDG77 | DG: Priorities for Validity Areas per Regulation | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
10 | TDGD3 | DG: Assignment Regulation to Regulation Profile | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
11 | TDGD9 | DG: Specify Checkbox Struct. for Temp./One-Time Mat. Maint. | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
12 | THM083 | EHS: Hazard Inducer Types | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
13 | THM093 | DG: Segregation Rules for Mixed Loading Checks | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
14 | THM105 | DG: Decision Matrix for Enterpr.-Spec. Mixed Loading Groups | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
TOPEnvironment, Health and Safety |
15 | DGMSD | DG: Dangerous Goods Document Table DGMSD | 5 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
16 | DGTEXCCNTRIES | Exceptions to Dangerous Goods Regulations: Countries | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
17 | DGTEXCEPT | Exceptions to DG Regulations - Header Table | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
18 | DGTEXCTEXTS | Exceptions to DG Regulations: Texts and Documents | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
19 | DGTEXCUNNO | Exceptions to DG Regulations: UN Numbers | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
20 | THM071 | DG: Risk Potential | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
21 | THM072 | Risk Potential Description | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
22 | VEDG | DG: Supplement Table for DG Data (Handling Unit) | 4 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
TOPEnvironment, Health and Safety Master Data |
23 | CCDUTDGREL | Product Release | 17 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
24 | CCUNC111 | Stowage Categories | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
25 | CCUNC112 | Stowage Category Descriptions | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
26 | CCUNC115 | Instructions for Enclosure | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
27 | CCUNC116 | Descriptions for Instructions for Enclosure | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
28 | CCUNC117 | Regulatory Basis for Transport Restrictions | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
29 | CCUNC118 | Descriptions for Regulatory Basis for Transport Restrictions | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
30 | CCUNC121 | Packaging Codes (Enhanced Data Model) | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
31 | CCUNC122 | Packaging Code Descriptions | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
32 | DGTMD | DG: Dangerous Goods Master | 30 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
33 | TDG105 | Assign Transport Indicators to Dangerous Goods Regulation | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
34 | THM003 | DG: Specify Transport Type | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
35 | THM004 | DG: Short Description for Transport Type | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
36 | THM009 | Dangerous Goods Classes | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
37 | THM010 | DG: Description of Dangerous Goods Classes | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
38 | THM011 | Classification Code | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
39 | THM012 | Description for Classification Code | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
40 | THM017 | DG Danger Label | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
41 | THM018 | DG: Short Description for Danger Label | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
42 | THM031 | DG: Hazard Identification Numbers | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
43 | THM032 | DG: Short Description for Hazard Identification Number | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
44 | THM063 | DG: Dangerous Goods Regulation | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
45 | THM073 | DG: Packaging Code Specific to Dangerous Goods Regulations | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
46 | THM074 | Descr. for packaging code specific to DG regulations | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
47 | THM075 | DG: Packaging Regulation | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
48 | THM076 | DG: Packaging Regulation Description | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
49 | THM091 | DG: Dynamic Key | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
50 | THM092 | DG: Description of Dynamic Key | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
51 | THM097 | DG: Mixed Loading Rules | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
52 | THM098 | DG: Description of Mixed Loading Rules | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
53 | THM099 | DG: Segregation | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
54 | THM100 | DG: Description of Segregation | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
55 | THM101 | DG: Regulation-Dependent Mixed Loading Groups | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
56 | THM102 | DG: Description of Regulation-Dependent Mixed Loading Groups | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
57 | THM157 | DG: Profiles for Dangerous Goods User-Defined Texts | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
58 | THM158 | DG: Description of Profiles | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
TOPMaterials Management |
59 | /ISDFPS/VTTKDG | EHS: Supplement Table for Exceptions (DG Data, Transport) | 3 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
TOPProduct Safety |
60 | EST0F | EHS: Dangerous Goods Management - Transport Classification | 18 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |
61 | TCGR5 | EHS: Condition Schema for RGV Selection - Table 5 | 2 | LWDG | Dangerous Goods Regulation | nvarchar | 12 | 0 | | |