Previous | Next | Contents | Index | Navigation | Glossary | Library |
Note that the GL_CODE_COMBINATIONS table contains columns for the key flexfield, but it also contains many other columns. LAST_UPDATE_DATE and LAST_UPDATED_BY columns provide information for the Who feature. The ATTRIBUTEn and CONTEXT columns belong to a descriptive flexfield, and the SEGMENT_ ATTRIBUTEn columns belong to a special flexfield used by the Oracle Public Sector Financials products. These other columns all appear in your flexfield view because they are not columns used by the Accounting Flexfield directly.
Our example structure for the Accounting Flexfield contains segments for COMPANY, COST_CENTER, REGION, PRODUCT, ACCOUNT, and SUB_ACCOUNT, so those columns appear in the structure view.
SQL> DESCRIBE GL_CODE_COMBINATIONS Name Null? Type ------------------------------- -------- ---- CODE_COMBINATION_ID NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) CHART_OF_ACCOUNTS_ID NOT NULL NUMBER(15) DETAIL_POSTING_ALLOWED_FLAG NOT NULL VARCHAR2(1) DETAIL_BUDGETING_ALLOWED_FLAG NOT NULL VARCHAR2(1) ACCOUNT_TYPE NOT NULL VARCHAR2(1) ENABLED_FLAG NOT NULL VARCHAR2(1) SUMMARY_FLAG NOT NULL VARCHAR2(1) SEGMENT1 VARCHAR2(25) SEGMENT2 VARCHAR2(25) . . . . . . SEGMENT29 VARCHAR2(25) SEGMENT30 VARCHAR2(25) DESCRIPTION VARCHAR2(240) TEMPLATE_ID NUMBER(15) ALLOCATION_CREATE_FLAG VARCHAR2(1) START_DATE_ACTIVE DATE END_DATE_ACTIVE DATE ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) ATTRIBUTE6 VARCHAR2(150) ATTRIBUTE7 VARCHAR2(150) ATTRIBUTE8 VARCHAR2(150) ATTRIBUTE9 VARCHAR2(150) ATTRIBUTE10 VARCHAR2(150) CONTEXT VARCHAR2(150) SEGMENT_ATTRIBUTE1 VARCHAR2(60) SEGMENT_ATTRIBUTE2 VARCHAR2(60) . . . . . . SEGMENT_ATTRIBUTE41 VARCHAR2(60) SEGMENT_ATTRIBUTE42 VARCHAR2(60)
View Name: GL_CODE_COMBINATIONS_KFV
Name Null? Type ------------------------------- -------- ---- ALLOCATION_CREATE_FLAG VARCHAR2(1) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE10 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) ATTRIBUTE6 VARCHAR2(150) ATTRIBUTE7 VARCHAR2(150) ATTRIBUTE8 VARCHAR2(150) ATTRIBUTE9 VARCHAR2(150) CHART_OF_ACCOUNTS_ID NOT NULL NUMBER(22) CODE_COMBINATION_ID NOT NULL NUMBER(22) CONCATENATED_SEGMENTS VARCHAR2(155) PADDED_CONCATENATED_SEGMENTS VARCHAR2(155) CONTEXT VARCHAR2(150) DESCRIPTION VARCHAR2(240) DETAIL_BUDGETING_ALLOWED NOT NULL VARCHAR2(1) DETAIL_POSTING_ALLOWED NOT NULL VARCHAR2(1) ENABLED_FLAG NOT NULL VARCHAR2(1) END_DATE_ACTIVE DATE GL_ACCOUNT_TYPE NOT NULL VARCHAR2(1) LAST_UPDATED_BY NOT NULL NUMBER(22) LAST_UPDATE_DATE NOT NULL DATE ROW_ID ROWID SEGMENT_ATTRIBUTE1 VARCHAR2(60) SEGMENT_ATTRIBUTE2 VARCHAR2(60) . . . . . . SEGMENT_ATTRIBUTE41 VARCHAR2(60) SEGMENT_ATTRIBUTE42 VARCHAR2(60) START_DATE_ACTIVE DATE SUMMARY_FLAG NOT NULL VARCHAR2(1) TEMPLATE_ID NUMBER(22)
View Name: GL_AFF_STD_VIEW
Name Null? Type ------------------------------- -------- ---- ACCOUNT VARCHAR2(25) ALLOCATION_CREATE_FLAG VARCHAR2(1) ATTRIBUTE1 VARCHAR2(150) ATTRIBUTE10 VARCHAR2(150) ATTRIBUTE2 VARCHAR2(150) ATTRIBUTE3 VARCHAR2(150) ATTRIBUTE4 VARCHAR2(150) ATTRIBUTE5 VARCHAR2(150) ATTRIBUTE6 VARCHAR2(150) ATTRIBUTE7 VARCHAR2(150) ATTRIBUTE8 VARCHAR2(150) ATTRIBUTE9 VARCHAR2(150) CODE_COMBINATION_ID NOT NULL NUMBER(22) COMPANY VARCHAR2(25) CONTEXT VARCHAR2(150) COST_CENTER VARCHAR2(25) DESCRIPTION VARCHAR2(240) DETAIL_BUDGETING_ALLOWED NOT NULL VARCHAR2(1) DETAIL_POSTING_ALLOWED NOT NULL VARCHAR2(1) ENABLED_FLAG NOT NULL VARCHAR2(1) END_DATE_ACTIVE DATE GL_ACCOUNT_TYPE NOT NULL VARCHAR2(1) LAST_UPDATED_BY NOT NULL NUMBER(22) LAST_UPDATE_DATE NOT NULL DATE PRODUCT VARCHAR2(25) REGION VARCHAR2(25) ROW_ID ROWID SEGMENT_ATTRIBUTE1 VARCHAR2(60) SEGMENT_ATTRIBUTE2 VARCHAR2(60) . . . . . . SEGMENT_ATTRIBUTE41 VARCHAR2(60) SEGMENT_ATTRIBUTE42 VARCHAR2(60) START_DATE_ACTIVE DATE SUB_ACCOUNT VARCHAR2(25) SUMMARY_FLAG NOT NULL VARCHAR2(1) TEMPLATE_ID NUMBER(22)
Key Flexfield Concatenated Segment View
Using Flexfield Views to Write a Report
Oracle Reports 2.5 Flexfield Support API
Previous | Next | Contents | Index | Navigation | Glossary | Library |