DW_FA_CAT_SEGMENT5_D_TL

This table contains translated information about category segment5

Details

Module: Assets

Key Columns

SEGMENT_CODE, SEGMENT_VALUESET_CODE, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SEGMENT_VALUESET_CODE VARCHAR2 64 True Category segment value set identifier.
SEGMENT_CODE VARCHAR2 256 True Category segment code.
LANGUAGE VARCHAR2 16 True Language code.
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of accounting segment value set identifier and Category segment code.
SEGMENT_ID VARCHAR2 512 Accouting segment identifier, Value is derived from a combination of accounting segment value set identifier and Category segment code.
SEGMENT_NAME VARCHAR2 256 GL Segment Value name
SEGMENT_DESCRIPTION VARCHAR2 256 GL Segment Value Description
SEGMENT_CODE_DESC VARCHAR2 999 Concatenated column of GL_SEGMENT_CODE and GL_SEGMENT_DESCRIPTION