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 |