GL_INTERFACE_GT
This table is used for internal processing only.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GROUP_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| BATCH_NAME | VARCHAR2 | 100 | Oracle internal use only. | ||
| JOURNAL_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. | ||
| REFERENCE_DATE | DATE | Oracle internal use only. | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 25 | Yes | Oracle internal use only. | |
| CURRENCY_CONVERSION_DATE | DATE | Yes | Oracle internal use only. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Yes | Oracle internal use only. | ||
| JGZZ_RECON_REF | VARCHAR2 | 240 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| LINE_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
| ENTERED_DR | NUMBER | Oracle internal use only. | |||
| ENTERED_CR | NUMBER | Oracle internal use only. | |||
| ACCOUNTED_DR | NUMBER | Oracle internal use only. | |||
| ACCOUNTED_CR | NUMBER | Oracle internal use only. | |||
| STATISTICAL_AMOUNT | NUMBER | Oracle internal use only. | |||
| FUNDS_RESERVED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| REFERENCE_1 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_2 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_3 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_4 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_5 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_6 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_7 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_8 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_9 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE_10 | VARCHAR2 | 240 | Oracle internal use only. | ||
| SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | Oracle internal use only. | |||
| SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Oracle internal use only. | |||
| GL_SL_LINK_TABLE | VARCHAR2 | 30 | Oracle internal use only. | ||
| GL_SL_LINK_ID | NUMBER | 18 | Oracle internal use only. | ||
| GROUP_LINE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| STATUS_CODE | VARCHAR2 | 100 | Oracle internal use only. | ||
| SUMMARY_LINE_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
| ACCOUNT_COMBINATION | VARCHAR2 | 800 | Oracle internal use only. | ||
| JE_BATCH_ID | NUMBER | 18 | Oracle internal use only. | ||
| JE_HEADER_ID | NUMBER | 18 | Oracle internal use only. | ||
| JE_LINE_NUM | NUMBER | 18 | Oracle internal use only. | ||
| ORIGINAL_CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| JGZZ_RECON_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | Oracle internal use only. | ||
| MANAGEMENT_SEGMENT_VALUE | VARCHAR2 | 25 | Oracle internal use only. | ||
| REPLACED_LEGAL_ENTITY_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| PROCESSING_DATE | TIMESTAMP | Oracle internal use only. | |||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| JOURNAL_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
| BATCH_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. |