DW_PARTY_SIC_CODE_TYPE_TL
Table to store the translations for SIC TYPE and SIC Code combinations.
Details
Module:
Key Columns
SIC_CODE_TYPE, SIC_CODE, LANGUAGE
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SIC_CODE_TYPE | VARCHAR2 | 128 | True | SIC Code Type | |||
| SIC_CODE | VARCHAR2 | 128 | True | SIC Code | |||
| LANGUAGE | VARCHAR2 | 64 | True | Translation language | |||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. Source Record Identifier It is a unique combination of CODE_TYPE, CODE | ||||
| NAME | VARCHAR2 | 128 | Business name or value of the code | ||||
| DESCRIPTION | VARCHAR2 | 256 | Description of the code |