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 |