DW_PARTY_SIC_CODE_TYPE_TL

Table to store the translations for SIC TYPE and SIC Code combinations.

Details

Module:

Key Columns

LANGUAGE, SIC_CODE_TYPE, SIC_CODE

Columns

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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.