ZX_REV_TRX_HEADERS_GT

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

Details

• Schema: FUSION

• Object owner: ZX

• Object type: TABLE

Columns

Name

INTERNAL_ORGANIZATION_IDNUMBERYesOracle internal use only REVERSING_APPLN_IDNUMBERYesOracle internal use only REVERSING_ENTITY_CODEVARCHAR230YesOracle internal use only REVERSING_EVNT_CLS_CODEVARCHAR230YesOracle internal use only REVERSING_TRX_IDNUMBERYesOracle internal use only REVERSING_HDR_USER_KEY1VARCHAR2150Oracle internal use only REVERSING_HDR_USER_KEY2VARCHAR2150Oracle internal use only REVERSING_HDR_USER_KEY3VARCHAR2150Oracle internal use only REVERSING_HDR_USER_KEY4VARCHAR2150Oracle internal use only REVERSING_HDR_USER_KEY5VARCHAR2150Oracle internal use only REVERSING_HDR_USER_KEY6VARCHAR2150Oracle internal use only TRX_NUMBERVARCHAR2150Oracle internal use only TRX_DESCRIPTIONVARCHAR2240Oracle internal use only TRX_COMMUNICATED_DATEDATEOracle internal use only BATCH_SOURCE_SEQ_IDNUMBEROracle internal use only BATCH_SOURCE_NAMEVARCHAR2150Oracle internal use only DOC_SEQ_IDNUMBEROracle internal use only DOC_SEQ_NAMEVARCHAR2150Oracle internal use only DOC_SEQ_VALUEVARCHAR2240Oracle internal use only TRX_DUE_DATEDATEOracle internal use only TRX_TYPE_DESCRIPTIONVARCHAR2240Oracle internal use only DOCUMENT_SUB_TYPEVARCHAR2240Oracle internal use only SUPPLIER_TAX_INVOICE_NUMBERVARCHAR2150Oracle internal use only SUPPLIER_TAX_INVOICE_DATEDATEOracle internal use only SUPPLIER_EXCHANGE_RATENUMBEROracle internal use only TAX_INVOICE_DATEDATEOracle internal use only TAX_INVOICE_NUMBERVARCHAR2150Oracle internal use only LEGAL_ENTITY_IDNUMBERYesOracle internal use only

Indexes

Index	Uniqueness	Columns
ZX_REV_TRX_HEADERS_GT_U1	Unique	REVERSING_APPLN_ID, REVERSING_ENTITY_CODE, REVERSING_EVNT_CLS_CODE, REVERSING_TRX_ID