GL_JE_HEADERS_GT
This table is used for internal processing only.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_JE_HEADERS_GT_PK |
JOURNAL_KEY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GROUP_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| JOURNAL_KEY | VARCHAR2 | 500 | Yes | Oracle internal use only. | |
| BATCH_KEY | VARCHAR2 | 500 | Yes | Oracle internal use only. | |
| JE_HEADER_ID | NUMBER | 18 | Oracle internal use only. | ||
| JOURNAL_NAME | VARCHAR2 | 100 | Yes | Oracle internal use only. | |
| BATCH_NAME | VARCHAR2 | 100 | Oracle internal use only. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
| EFFECTIVE_DATE | DATE | Yes | Oracle internal use only. | ||
| LEDGER_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Oracle internal use only. | ||
| JE_CATEGORY | VARCHAR2 | 25 | Yes | Oracle internal use only. | |
| ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
| ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Oracle internal use only. | ||
| DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_DATE | DATE | Oracle internal use only. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 25 | Oracle internal use only. | ||
| CURRENCY_CONVERSION_DATE | DATE | Oracle internal use only. | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Oracle internal use only. | |||
| TOTAL_ENTERED_DR | NUMBER | Oracle internal use only. | |||
| TOTAL_ENTERED_CR | NUMBER | Oracle internal use only. | |||
| TOTAL_ACCOUNTED_DR | NUMBER | Oracle internal use only. | |||
| TOTAL_ACCOUNTED_CR | NUMBER | Oracle internal use only. | |||
| FUNDS_RESERVED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| NEEDS_APPROVAL_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
| STATUS_CODE | VARCHAR2 | 100 | Oracle internal use only. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
| ACCOUNTED_PERIOD_TYPE | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
| BAL_SEG_COLUMN_NAME | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| MGT_SEG_COLUMN_NAME | VARCHAR2 | 30 | Oracle internal use only. | ||
| BAL_SEG_VALUE_OPTION_CODE | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
| ENABLE_RECONCILIATION_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
| ENABLE_BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
| SPLIT_BY_LEGAL_ENTITY_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
| LEDGER_CURRENCY_MAU | NUMBER | Yes | Oracle internal use only. | ||
| PROCESSING_DATE | TIMESTAMP | Oracle internal use only. | |||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| BATCH_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_JE_HEADERS_GT_U1 | Unique | JOURNAL_KEY |