GL_DAILY_POST_INT
This column is used in internal processing only
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LEDGER_ID | NUMBER | 18 | Yes | This column is used in internal processing only | |
CODE_COMBINATION_ID | NUMBER | 18 | Yes | This column is used in internal processing only | |
CURRENCY_CODE | VARCHAR2 | 15 | Yes | This column is used in internal processing only | |
CURRENCY_TYPE | VARCHAR2 | 1 | Yes | This column is used in internal processing only | |
ACTUAL_FLAG | VARCHAR2 | 1 | Yes | This column is used in internal processing only | |
PERIOD_NAME | VARCHAR2 | 15 | Yes | This column is used in internal processing only | |
PERIOD_START_DATE | DATE | Yes | This column is used in internal processing only | ||
PERIOD_END_DATE | DATE | Yes | This column is used in internal processing only | ||
QUARTER_START_DATE | DATE | Yes | This column is used in internal processing only | ||
YEAR_START_DATE | DATE | Yes | This column is used in internal processing only | ||
CONVERTED_FROM_CURRENCY | VARCHAR2 | 15 | This column is used in internal processing only | ||
BAL_SEG_VALUE_1 | VARCHAR2 | 25 | This column is used in internal processing only | ||
BAL_SEG_VALUE_2 | VARCHAR2 | 25 | This column is used in internal processing only | ||
BAL_SEG_VALUE_3 | VARCHAR2 | 25 | This column is used in internal processing only | ||
PERIOD_TYPE | VARCHAR2 | 15 | This column is used in internal processing only | ||
PERIOD_YEAR | NUMBER | 18 | This column is used in internal processing only | ||
PERIOD_NUM | NUMBER | 18 | This column is used in internal processing only | ||
TEMPLATE_ID | NUMBER | 18 | This column is used in internal processing only | ||
OPENING_PERIOD_AGGREGATE | NUMBER | This column is used in internal processing only | |||
OPENING_QUARTER_AGGREGATE | NUMBER | This column is used in internal processing only | |||
OPENING_YEAR_AGGREGATE | NUMBER | This column is used in internal processing only | |||
PERIOD_END_NET_INCOME | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE1 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE2 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE3 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE4 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE5 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE6 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE7 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE8 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE9 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE10 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE11 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE12 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE13 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE14 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE15 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE16 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE17 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE18 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE19 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE20 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE21 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE22 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE23 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE24 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE25 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE26 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE27 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE28 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE29 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE30 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE31 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE32 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE33 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE34 | NUMBER | This column is used in internal processing only | |||
PERIOD_AGGREGATE35 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY1 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY2 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY3 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY4 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY5 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY6 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY7 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY8 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY9 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY10 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY11 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY12 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY13 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY14 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY15 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY16 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY17 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY18 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY19 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY20 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY21 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY22 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY23 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY24 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY25 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY26 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY27 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY28 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY29 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY30 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY31 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY32 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY33 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY34 | NUMBER | This column is used in internal processing only | |||
END_OF_DAY35 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE1 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE2 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE3 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE4 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE5 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE6 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE7 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE8 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE9 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE10 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE11 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE12 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE13 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE14 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE15 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE16 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE17 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE18 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE19 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE20 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE21 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE22 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE23 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE24 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE25 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE26 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE27 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE28 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE29 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE30 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE31 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE32 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE33 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE34 | NUMBER | This column is used in internal processing only | |||
QUARTER_AGGREGATE35 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE1 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE2 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE3 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE4 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE5 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE6 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE7 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE8 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE9 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE10 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE11 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE12 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE13 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE14 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE15 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE16 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE17 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE18 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE19 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE20 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE21 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE22 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE23 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE24 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE25 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE26 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE27 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE28 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE29 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE30 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE31 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE32 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE33 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE34 | NUMBER | This column is used in internal processing only | |||
YEAR_AGGREGATE35 | NUMBER | This column is used in internal processing only | |||
INCOME_STATEMENT_AGGREGATE | NUMBER | Aggregate of the end balances of income statement accounts. | |||
ACCOUNT_TYPE | VARCHAR2 | 1 | Key flexfield combination type (Asset, Liability, etc). | ||
PARTITION_GROUP_CODE | VARCHAR2 | 15 | Oracle internal use only. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
GL_DAILY_POST_INT_N1 | Non Unique | CODE_COMBINATION_ID, PERIOD_NAME, CURRENCY_CODE |
GL_DAILY_POST_INT_N2 | Non Unique | TEMPLATE_ID |