GL_PURGE_VALIDATION_GT
This table is for internal use only.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
GL_PURGE_VALIDATION_GT_PK |
LEDGER_ID, PERIOD_NAME |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LEDGER_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
PERIOD_NAME | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
LEDGER_NAME | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
EFFECTIVE_PERIOD_NUM | NUMBER | 18 | Yes | Oracle internal use only. | |
FIRST_EFFECTIVE_PERIOD_NUM | NUMBER | 18 | Yes | Oracle internal use only. | |
START_DATE | DATE | Yes | Oracle internal use only. | ||
END_DATE | DATE | Yes | Oracle internal use only. | ||
ROW_TYPE_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
SECONDARY_LEDGER_ID | NUMBER | 18 | Oracle internal use only. | ||
SECONDARY_LEDGER_NAME | VARCHAR2 | 30 | Oracle internal use only. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
GL_PURGE_VALIDATION_GT_N1 | Non Unique | LEDGER_ID, END_DATE, START_DATE |
GL_PURGE_VALIDATION_GT_U1 | Unique | LEDGER_ID, PERIOD_NAME |