GL_CLEARING_ACCT_RECON_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| JE_BATCH_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| JE_HEADER_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| JE_LINE_NUM | NUMBER | 18 | Yes | Oracle internal use only. | |
| CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| BALANCING_SEGMENT | VARCHAR2 | 25 | Oracle internal use only. | ||
| NATURAL_ACCOUNT | VARCHAR2 | 25 | Oracle internal use only. | ||
| COST_CENTER | VARCHAR2 | 25 | Oracle internal use only. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Oracle internal use only. | ||
| CONCAT_SEGMENTS | VARCHAR2 | 4000 | Oracle internal use only. | ||
| BATCH_NAME | VARCHAR2 | 100 | Oracle internal use only. | ||
| JOURNAL_NAME | VARCHAR2 | 100 | Oracle internal use only. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Oracle internal use only. | ||
| EFFECTIVE_DATE | DATE | Oracle internal use only. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | 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. | |||
| RECON_REFERENCE | VARCHAR2 | 240 | Oracle internal use only. | ||
| RECON_STATUS | VARCHAR2 | 1 | Oracle internal use only. | ||
| RECON_ID | NUMBER | 18 | Oracle internal use only. | ||
| RECON_RULE_ID | NUMBER | 18 | Oracle internal use only. | ||
| RECON_DATE | DATE | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_CLEARING_ACCT_RECON_N1 | Non Unique | RECON_STATUS, RECON_REFERENCE, CODE_COMBINATION_ID |
| GL_CLEARING_ACCT_RECON_N2 | Non Unique | RECON_STATUS, RECON_REFERENCE, BALANCING_SEGMENT, NATURAL_ACCOUNT, COST_CENTER |