GL_JE_BATCHES_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_BATCHES_GT_PK |
BATCH_KEY |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
GROUP_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
BATCH_KEY | VARCHAR2 | 500 | Yes | Oracle internal use only. | |
JE_BATCH_ID | NUMBER | 18 | Oracle internal use only. | ||
BATCH_NAME | VARCHAR2 | 100 | Yes | Oracle internal use only. | |
ORIGINAL_BATCH_NAME | VARCHAR2 | 100 | Yes | Oracle internal use only. | |
DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
PERIOD_NAME | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
EFFECTIVE_DATE | DATE | Yes | Oracle internal use only. | ||
ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
FUNDS_RESERVED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
NEEDS_APPROVAL_FLAG | VARCHAR2 | 1 | Yes | Oracle internal use only. | |
ENABLE_BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Yes | 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. | |
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. | |||
PROCESSING_DATE | TIMESTAMP | Oracle internal use only. | |||
PARTITION_GROUP_CODE | VARCHAR2 | 15 | Oracle internal use only. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
GL_JE_BATCHES_GT_U1 | Unique | BATCH_KEY |