GL_POSTING_INTERIM
This is global temporary table. Posting and Open period programs uses this table.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CODE_COMBINATION_ID | NUMBER | 18 | This column is used in internal processing only | ||
PERIOD_NAME | VARCHAR2 | 15 | Yes | This column is used in internal processing only | |
LEDGER_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 | |
PERIOD_NET_DR | NUMBER | Yes | This column is used in internal processing only | ||
PERIOD_NET_CR | NUMBER | Yes | This column is used in internal processing only | ||
QUARTER_TO_DATE_DR | NUMBER | Yes | This column is used in internal processing only | ||
QUARTER_TO_DATE_CR | NUMBER | Yes | This column is used in internal processing only | ||
PROJECT_TO_DATE_DR | NUMBER | Yes | This column is used in internal processing only | ||
PROJECT_TO_DATE_CR | NUMBER | Yes | This column is used in internal processing only | ||
BEGIN_BALANCE_DR | NUMBER | Yes | This column is used in internal processing only | ||
BEGIN_BALANCE_CR | NUMBER | Yes | 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 | ||
PERIOD_TYPE | VARCHAR2 | 15 | This column is used in internal processing only | ||
ACCOUNT_TYPE | VARCHAR2 | 1 | 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 | ||
COLUMN1 | VARCHAR2 | 20 | This column is used in internal processing only | ||
ACTUAL_FLAG | VARCHAR2 | 1 | This column is used in internal processing only | ||
ENCUMBRANCE_TYPE_ID | NUMBER | 18 | This column is used in internal processing only | ||
BUDGET_VERSION_ID | NUMBER | 18 | This column is used in internal processing only | ||
TEMPLATE_ID | NUMBER | 18 | This column is used in internal processing only | ||
TRANSLATED_FLAG | VARCHAR2 | 1 | This column is used in internal processing only | ||
INCREMENTAL_FLAG | VARCHAR2 | 1 | This column is used in internal processing only | ||
PERIOD_NET_DR_BEQ | NUMBER | This column is used in internal processing only | |||
PERIOD_NET_CR_BEQ | NUMBER | This column is used in internal processing only | |||
QUARTER_TO_DATE_DR_BEQ | NUMBER | This column is used in internal processing only | |||
QUARTER_TO_DATE_CR_BEQ | NUMBER | This column is used in internal processing only | |||
BEGIN_BALANCE_DR_BEQ | NUMBER | This column is used in internal processing only | |||
BEGIN_BALANCE_CR_BEQ | NUMBER | This column is used in internal processing only | |||
PROJECT_TO_DATE_DR_BEQ | NUMBER | This column is used in internal processing only | |||
PROJECT_TO_DATE_CR_BEQ | NUMBER | This column is used in internal processing only | |||
SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
SEGMENT30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
PARTITION_GROUP_CODE | VARCHAR2 | 15 | Oracle internal use only. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
GL_POSTING_INTERIM_N1 | Non Unique | CODE_COMBINATION_ID, PERIOD_NAME, LEDGER_ID, CURRENCY_CODE |
GL_POSTING_INTERIM_N2 | Non Unique | TEMPLATE_ID |
GL_POSTING_INTERIM_N3 | Non Unique | BAL_SEG_VALUE_1, CURRENCY_CODE, LEDGER_ID |
GL_POSTING_INTERIM_N4 | Non Unique | BAL_SEG_VALUE_1, BAL_SEG_VALUE_2, BAL_SEG_VALUE_3 |