| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLogistics - General |
1 | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | 2 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
TOPTariffs, Duties and Permits |
2 | OIH01 | Excise Duty Rates Table | 5 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
3 | OIH01A | Excise Duty Rates Table | 8 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
4 | OIH07 | TDP allowed combinations of ED Group and Handling Type | 5 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
5 | OIH07A | TDP allowed combinations of ED Group and Handling Type | 8 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
6 | OIH08 | Default values for external procurement functions | 5 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
7 | OIH08A | Default values for external procurement functions | 8 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
8 | OIH10 | License Requirements Tab | 4 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
9 | OIH10A | License Requirements Tab | 7 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
10 | OIH11 | Defaults for ext. sales functions | 5 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
11 | OIH11A | Defaults for ext. sales functions | 8 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
12 | OIH14 | Tax rate revaluation - obsolete | 24 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
13 | OIH25 | TDP additional checks for purchasing | 3 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
14 | OIH26 | License Requirements Tab | 5 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
15 | OIH26A | License Requirements Tab | 8 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
16 | OIH27 | TDP additional checks for sales | 3 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
17 | OIH5T | Handling type description | 3 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |
18 | OIHLHT | Licence allowed handling types | 4 | HANTYP | Excise Duty Handling Type | nvarchar | 2 | 0 | | |