IBY_TRANSACTION_ERRORS

Details

Schema: FUSION
Object owner: IBY
Object type: TABLE

Columns

Name
TRANSACTION_ERROR_IDNUMBER18YesThe table is used in payments processing. Oracle internal use only TRANSACTION_TYPEVARCHAR230YesOracle internal use only TRANSACTION_IDNUMBER18YesOracle internal use only ERROR_CODEVARCHAR230YesOracle internal use only ERROR_DATEDATEYesOracle internal use only ORIGINATOR_CODEVARCHAR280Oracle internal use only ORIGINATOR_MESSAGEVARCHAR21024Oracle internal use only ERROR_STATUSVARCHAR230YesOracle internal use only OVERRIDE_ALLOWED_ON_ERROR_FLAGVARCHAR21Oracle internal use only DO_NOT_APPLY_ERROR_FLAGVARCHAR21Oracle internal use only CREATED_BYVARCHAR264YesWho column: indicates the user who created the row. CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row. LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row. LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row. OBJECT_VERSION_NUMBERNUMBER9YesUsed to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row. CALLING_APP_IDNUMBER18YesOracle internal use only PAY_PROC_TRXN_TYPE_CODEVARCHAR2100YesOracle internal use only CALLING_APP_DOC_UNIQUE_REF1VARCHAR2100YesOracle internal use only CALLING_APP_DOC_UNIQUE_REF2VARCHAR2100Oracle internal use only CALLING_APP_DOC_UNIQUE_REF3VARCHAR2100Oracle internal use only CALLING_APP_DOC_UNIQUE_REF4VARCHAR2100Oracle internal use only CALLING_APP_DOC_UNIQUE_REF5VARCHAR2100Oracle internal use only ERROR_TYPEVARCHAR230Oracle internal use only ERROR_MESSAGEVARCHAR2255Oracle internal use only VALIDATION_SET_CODEVARCHAR230Oracle internal use only PASS_DATEDATEOracle internal use only OVERRIDE_JUSTIFICATIONVARCHAR2255Oracle internal use only OVERRIDE_DATEDATEOracle internal use only STATUS_ORIGINATOR_IDVARCHAR2100Oracle internal use only STATUS_ORIGINATOR_ID_TYPEVARCHAR230Oracle internal use only STATUS_ORIGINATOR_NAMEVARCHAR2240Oracle internal use only

Name

TRANSACTION_ERROR_IDNUMBER18YesThe table is used in payments processing. Oracle internal use only

TRANSACTION_TYPEVARCHAR230YesOracle internal use only

TRANSACTION_IDNUMBER18YesOracle internal use only

ERROR_CODEVARCHAR230YesOracle internal use only

ERROR_DATEDATEYesOracle internal use only

ORIGINATOR_CODEVARCHAR280Oracle internal use only

ORIGINATOR_MESSAGEVARCHAR21024Oracle internal use only

ERROR_STATUSVARCHAR230YesOracle internal use only

OVERRIDE_ALLOWED_ON_ERROR_FLAGVARCHAR21Oracle internal use only

DO_NOT_APPLY_ERROR_FLAGVARCHAR21Oracle internal use only

CREATED_BYVARCHAR264YesWho column: indicates the user who created the row.

CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row.

LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row.

LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row.

OBJECT_VERSION_NUMBERNUMBER9YesUsed to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row.

CALLING_APP_IDNUMBER18YesOracle internal use only

PAY_PROC_TRXN_TYPE_CODEVARCHAR2100YesOracle internal use only

CALLING_APP_DOC_UNIQUE_REF1VARCHAR2100YesOracle internal use only

CALLING_APP_DOC_UNIQUE_REF2VARCHAR2100Oracle internal use only

CALLING_APP_DOC_UNIQUE_REF3VARCHAR2100Oracle internal use only

CALLING_APP_DOC_UNIQUE_REF4VARCHAR2100Oracle internal use only

CALLING_APP_DOC_UNIQUE_REF5VARCHAR2100Oracle internal use only

ERROR_TYPEVARCHAR230Oracle internal use only

ERROR_MESSAGEVARCHAR2255Oracle internal use only

VALIDATION_SET_CODEVARCHAR230Oracle internal use only

PASS_DATEDATEOracle internal use only

OVERRIDE_JUSTIFICATIONVARCHAR2255Oracle internal use only

OVERRIDE_DATEDATEOracle internal use only

STATUS_ORIGINATOR_IDVARCHAR2100Oracle internal use only

STATUS_ORIGINATOR_ID_TYPEVARCHAR230Oracle internal use only

STATUS_ORIGINATOR_NAMEVARCHAR2240Oracle internal use only