CE_RECON_HISTORY_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECON_HISTORY_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| TRX_DATE | DATE | Oracle internal use only. | |||
| TRX_BU_ID | NUMBER | 18 | Oracle internal use only. | ||
| NUM | NUMBER | 18 | Oracle internal use only. | ||
| RECON_GROUP_NUM | NUMBER | 18 | Oracle internal use only. | ||
| STATEMENT_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRANSACTION_SOURCE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TRANSACTION_ID | NUMBER | 18 | Oracle internal use only. | ||
| BALANCING_AMOUNT | NUMBER | Oracle internal use only. | |||
| ACCOUNTING_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| TRX_LINE_ID | NUMBER | 18 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CE_RECON_HISTORY_GT_N1 | Non Unique | NUM |
| CE_RECON_HISTORY_GT_N2 | Non Unique | STATEMENT_LINE_ID |
| CE_RECON_HISTORY_GT_N3 | Non Unique | TRANSACTION_ID, TRANSACTION_SOURCE |