| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHFNDC_REGL_CR | Regulatory Lists - Country and Region | 2 | REGLIST | Regulatory List | nvarchar | 21 | 0 | | |
2 | EHFNDC_SREG | Regulatory lists for declarable substances (PRC) | 2 | REGLIST | Regulatory/Customer List | nvarchar | 21 | 0 | | |
3 | EHPRCC_CHECK | Compliance requirement check | 5 | REGLIST | Regulatory/Customer List | nvarchar | 21 | 0 | | |
4 | EHPRCC_EXM_MAP | Exemption mapping table for migration (old to new exemption) | 2 | REGLIST | Regulatory List | nvarchar | 21 | 0 | | |
5 | EHPRCD_ADRD | CP: expanded data for business partner | 5 | REGLIST | Regulatory/Customer List | nvarchar | 21 | 0 | | |
6 | EHPRCD_COD_PSND | PSN Declaration | 9 | REGLIST | Regulation in PSN | nvarchar | 32 | 0 | | |
7 | EHPRCD_PCR_COMPL | Compliance Check Result | 10 | REGLIST | Regulatory/Customer List | nvarchar | 21 | 0 | | |
8 | EHPRCD_PSI_COMM | Communication Definition Settings | 20 | REGLIST | Regulatory/Customer List | nvarchar | 21 | 0 | | |
TOPEnvironment, Health and Safety |
9 | /TDAG/CPC_CHECK | CP: Substance regulation | 5 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
10 | /TDAG/CPC_SREG | CP: Substance regulation | 2 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
11 | /TDAG/CPC_SREGD | CP: Language Dependent Identifiers of Substance Regulation | 2 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
12 | /TDAG/CPC_SREGEX | Exemptions | 2 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
13 | /TDAG/CPT_ADRD | CP: expanded data for business partner | 5 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
14 | /TDAG/CPT_DECSUB | CP: Declarable Substances | 16 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
15 | /TDAG/CPT_EXEMLI | CP: Exemption Limits | 4 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
16 | /TDAG/CPT_TASKH | Header data for tasks | 9 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
17 | /TDAG/CPT_TASKHA | CP: Kopfdaten für Aufgaben / Archiv | 9 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
18 | /TDAG/CPT_TRCKH | Obsolete - CP: Tracker - Kopfdaten | 10 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |
19 | /TDAG/CPT_TRCKHA | Obsolete - CP: Tracker - Kopfdaten / Archiv | 10 | REGLIST | Regulatory/Customer List | nvarchar | 20 | 0 | | |