DW_GL_CODE_COMBINATION_D

This table contains key flex field segments information for GL.

Details

Module:

Key Columns

CODE_COMBINATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CODE_COMBINATION_ID NUMBER 38 0 True Account key flexfield combination identifier.  
SOURCE_RECORD_ID VARCHAR2 64     Source record identifier. Value is same as the account key flexfield combination identifier.  
CHART_OF_ACCOUNTS_ID NUMBER 38 0   Chart of account identifier.  
ENABLED_FLAG VARCHAR2 16     Indicates that code combination is enabled.  
CONCAT_SEGMENTS VARCHAR2 2048     Concatenated segments.  
GL_BALANCING_SEGMENT VARCHAR2 32     Balancing segment.  
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64     Balancing segment value set code.  
COST_CENTER_SEGMENT VARCHAR2 32     Cost center segment.  
COST_CENTER_VALUESET_CODE VARCHAR2 64     Cost center value set code.  
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32     Natural account segment.  
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64     Natural account value set code.  
GL_SEGMENT1 VARCHAR2 32     Accounting segment 1.  
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code.  
GL_SEGMENT2 VARCHAR2 32     Accounting segment 2.  
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64     Accounting segment 2 value set code.  
GL_SEGMENT3 VARCHAR2 32     Accounting segment 3.  
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64     Accounting segment 3 value set code.  
GL_SEGMENT4 VARCHAR2 32     Accounting segment 4.  
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64     Accounting segment 4 value set code.  
GL_SEGMENT5 VARCHAR2 32     Accounting segment 5.  
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64     Accounting segment 5 value set code.  
GL_SEGMENT6 VARCHAR2 32     Accounting segment 6.  
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64     Accounting segment 6 value set code.  
GL_SEGMENT7 VARCHAR2 32     Accounting segment 7.  
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64     Accounting segment 7 value set code.  
GL_SEGMENT8 VARCHAR2 32     Accounting segment 8.  
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64     Accounting segment 8 value set code.  
GL_SEGMENT9 VARCHAR2 32     Accounting segment 9.  
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64     Accounting segment 9 value set code.  
GL_SEGMENT10 VARCHAR2 32     Accounting segment 10.  
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code.  
GL_SEGMENT11 VARCHAR2 32     Accounting segment 11.  
GL_SEGMENT11_VALUESET_CODE VARCHAR2 64     Accounting segment 11 value set code.  
GL_SEGMENT12 VARCHAR2 32     Accounting segment 12.  
GL_SEGMENT12_VALUESET_CODE VARCHAR2 64     Accounting segment 12 value set code.  
GL_SEGMENT13 VARCHAR2 32     Accounting segment 13.  
GL_SEGMENT13_VALUESET_CODE VARCHAR2 64     Accounting segment 13 value set code.  
GL_SEGMENT14 VARCHAR2 32     Accounting segment 14.  
GL_SEGMENT14_VALUESET_CODE VARCHAR2 64     Accounting segment 14 value set code.  
GL_SEGMENT15 VARCHAR2 32     Accounting segment 15.  
GL_SEGMENT15_VALUESET_CODE VARCHAR2 64     Accounting segment 15 value set code.  
GL_SEGMENT16 VARCHAR2 32     Accounting segment 16.  
GL_SEGMENT16_VALUESET_CODE VARCHAR2 64     Accounting segment 16 value set code.  
GL_SEGMENT17 VARCHAR2 32     Accounting segment 17.  
GL_SEGMENT17_VALUESET_CODE VARCHAR2 64     Accounting segment 17 value set code.  
GL_SEGMENT18 VARCHAR2 32     Accounting segment 18.  
GL_SEGMENT18_VALUESET_CODE VARCHAR2 64     Accounting segment 18 value set code.  
GL_SEGMENT19 VARCHAR2 32     Accounting segment 19.  
GL_SEGMENT19_VALUESET_CODE VARCHAR2 64     Accounting segment 19 value set code.  
GL_SEGMENT20 VARCHAR2 32     Accounting segment 20.  
GL_SEGMENT20_VALUESET_CODE VARCHAR2 64     Accounting segment 20 value set code.  
GL_SEGMENT21 VARCHAR2 32     Accounting segment 21.  
GL_SEGMENT21_VALUESET_CODE VARCHAR2 64     Accounting segment 21 value set code.  
GL_SEGMENT22 VARCHAR2 32     Accounting segment 22.  
GL_SEGMENT22_VALUESET_CODE VARCHAR2 64     Accounting segment 22 value set code.  
GL_SEGMENT23 VARCHAR2 32     Accounting segment 23.  
GL_SEGMENT23_VALUESET_CODE VARCHAR2 64     Accounting segment 23 value set code.  
GL_SEGMENT24 VARCHAR2 32     Accounting segment 24.  
GL_SEGMENT24_VALUESET_CODE VARCHAR2 64     Accounting segment 24 value set code.  
GL_SEGMENT25 VARCHAR2 32     Accounting segment 25.  
GL_SEGMENT25_VALUESET_CODE VARCHAR2 64     Accounting segment 25 value set code.  
GL_SEGMENT26 VARCHAR2 32     Accounting segment 26.  
GL_SEGMENT26_VALUESET_CODE VARCHAR2 64     Accounting segment 26 value set code.  
GL_SEGMENT27 VARCHAR2 32     Accounting segment 27.  
GL_SEGMENT27_VALUESET_CODE VARCHAR2 64     Accounting segment 27 value set code.  
GL_SEGMENT28 VARCHAR2 32     Accounting segment 28.  
GL_SEGMENT28_VALUESET_CODE VARCHAR2 64     Accounting segment 28 value set code.  
GL_SEGMENT29 VARCHAR2 32     Accounting segment 29.  
GL_SEGMENT29_VALUESET_CODE VARCHAR2 64     Accounting segment 29 value set code.  
GL_SEGMENT30 VARCHAR2 32     Accounting segment 30.  
GL_SEGMENT30_VALUESET_CODE VARCHAR2 64     Accounting segment 30 value set code.  
ACCOUNT_TYPE VARCHAR2 16     combination type (Asset, Liability, etc).