ZX_TRANSACTIONS_GT

This is a temporary table which is used internally by Oracle.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

Columns

Name

APPLICATION_IDNUMBERYesOracle internal use only

ENTITY_CODEVARCHAR230YesOracle internal use only

EVENT_CLASS_CODEVARCHAR230YesOracle internal use only

EVENT_TYPE_CODEVARCHAR230YesOracle internal use only

TRX_IDNUMBERYesOracle internal use only

INTERNAL_ORGANIZATION_IDNUMBERYesOracle internal use only

HDR_TRX_USER_KEY1VARCHAR2150Oracle internal use only

HDR_TRX_USER_KEY2VARCHAR2150Oracle internal use only

HDR_TRX_USER_KEY3VARCHAR2150Oracle internal use only

HDR_TRX_USER_KEY4VARCHAR2150Oracle internal use only

HDR_TRX_USER_KEY5VARCHAR2150Oracle internal use only

HDR_TRX_USER_KEY6VARCHAR2150Oracle internal use only

FIRST_PTY_ORG_IDNUMBER18Oracle internal use only

TAX_EVENT_CLASS_CODEVARCHAR230Oracle internal use only

TAX_EVENT_TYPE_CODEVARCHAR230Oracle internal use only

DOC_EVENT_STATUSVARCHAR230Oracle internal use only

Indexes

Index Uniqueness Columns
ZX_TRANSACTIONS_GT_U1 Unique APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID