| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDangerous Goods Management |
1 | TDG04 | DG: Short Description for Transport Type | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
2 | TDG10 | DG: Label for dangerous goods classes | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
3 | TDG12 | DG: Description for Classification Code | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
4 | TDG18 | DG: Description for danger label number | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
5 | TDG22 | DG: Description for user-defined texts | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
6 | TDG28 | Descriptions for hazard notes | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
7 | TDG32 | Text table for hazard identification numbers | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
8 | TDG34 | DG: Description for hazard-inducing substances | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
9 | TDG40 | DG: Description for processing status | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
10 | TDG42 | DG: Desc. DG indicator profiles for material master | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
11 | TDG48 | DG: Description for DG material-independent texts | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
12 | TDG66 | DG: Text Table for Mode of Transport Categories | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
13 | TDG68 | DG: Text table for UN number (new) | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
14 | TDG70 | DG: Checkbox Structure Description for Filling/Distribution | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
15 | TDG72 | DG: Checkbox Structure Desc. for Filling/Distrib. (Packag.) | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
16 | TDG98 | GG: Text Table for Approval Code Types | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
17 | TDGA6 | DG: Labels for dangerous goods check routines | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
18 | TDGB2 | DG: Description for dangerous goods check schema | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
19 | TDGD6 | DG: Description Indicator Category | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
20 | THM082 | EHS DGM: Description for Hazard Inducer Types | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
TOPEnvironment, Health and Safety |
21 | TDG96 | DG: Text Table for Level of Dangerous Goods Packaging | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
22 | TDGC6 | Text table for DG indicator profiles in the delivery header | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
23 | TDGD2 | DG: Description Regulation Profile | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
24 | THM072 | Risk Potential Description | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
TOPEnvironment, Health and Safety Master Data |
25 | TDG16 | DG: Label for water pollution class | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
26 | TDG30 | DG: Text table for printing labels | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
27 | TDG36 | DG: Description for VbF classes | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
28 | TDG38 | DG: Description for Storage Hazard Classes | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
29 | TDG74 | DG: Description of Identification Number Type | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
30 | THM004 | DG: Short Description for Transport Type | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
31 | THM010 | DG: Description of Dangerous Goods Classes | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
32 | THM012 | Description for Classification Code | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
33 | THM018 | DG: Short Description for Danger Label | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
34 | THM032 | DG: Short Description for Hazard Identification Number | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
35 | THM040 | DG: Short Description of Processing Status for DG Basic Data | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
36 | THM074 | Descr. for packaging code specific to DG regulations | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
37 | THM076 | DG: Packaging Regulation Description | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
38 | THM152 | DG: Mode-of-Transport Category | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
39 | THM158 | DG: Description of Profiles | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |
40 | THM160 | DG: Description Not Dangerous Goods Full/Empty Transport | 2 | DGSPRAS | Language Key | nvarchar | 1 | 0 | | |