ZX_TRX_LINE_VALUES_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| TRX_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| TRX_LINE_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| DETERMINING_FACTOR_CLASS_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| DETERMINING_FACTOR_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| DETERMINING_FACTOR_CQ_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_PARAMETER_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| ALPHANUMERIC_VALUE | VARCHAR2 | 1000 | Oracle internal use only. | ||
| NUMERIC_VALUE | NUMBER | Oracle internal use only. | |||
| DATE_VALUE | DATE | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_TRX_LINE_VALUES_GT_U1 | Unique | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, DETERMINING_FACTOR_CLASS_CODE, DETERMINING_FACTOR_CODE, DETERMINING_FACTOR_CQ_CODE |