| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDangerous Goods Management |
1 | TDG03 | DG: Specify Transport Type | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
2 | TDG04 | DG: Short Description for Transport Type | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
3 | TDG09 | DG: Define dangerous goods classes | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
4 | TDG10 | DG: Label for dangerous goods classes | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
5 | TDG11 | DG: Define Classification Code (Risk Potential) | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
6 | TDG12 | DG: Description for Classification Code | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
7 | TDG17 | DG: Define danger label | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
8 | TDG18 | DG: Description for danger label number | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
9 | TDG49 | DG: Permitted Primary Languages | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
10 | TDG51 | DG: Derivation of Secondary Language | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
11 | TDG61 | DG: Regulations | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
12 | TDG63 | DG: Derivation of Regulations | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
13 | TDG65 | DG: Dangerous goods mode of transport category (dummy) | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
14 | TDG66 | DG: Text Table for Mode of Transport Categories | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
15 | TDG67 | DG: Define UN numbers (new) | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
16 | TDG68 | DG: Text table for UN number (new) | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
TOPEnvironment, Health and Safety |
17 | DGMSD | DG: Dangerous Goods Document Table DGMSD | 7 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
18 | DGTMD_LKEY | DG: Dummy Table for Lock Object on Log. Key for DGTMD | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
TOPEnvironment, Health and Safety Master Data |
19 | DGTMD | DG: Dangerous Goods Master | 17 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
20 | TDG153 | EHS: Collective Mode-of-Transport Categories | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
21 | THM063 | DG: Dangerous Goods Regulation | 4 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
22 | THM151 | DG: Mode-of-Transport Category | 2 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |
23 | THM152 | DG: Mode-of-Transport Category | 3 | MOT | Dangerous Goods - Mode-of-Transport Category | nvarchar | 2 | 0 | | |