eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: IBY.IBY_DEBIT_AUTHORIZATIONS#

Source

View Text - Preformatted


select DEBIT_AUTHORIZATION_ID DEBIT_AUTHORIZATION_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EXTERNAL_BANK_ACCOUNT_USE_ID EXTERNAL_BANK_ACCOUNT_USE_ID, AUTHORIZATION_REFERENCE_NUMBER AUTHORIZATION_REFERENCE_NUMBER, INITIAL_DEBIT_AUTHORIZATION_ID INITIAL_DEBIT_AUTHORIZATION_ID, AUTHORIZATION_REVISION_NUMBER AUTHORIZATION_REVISION_NUMBER, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, AMENDMENT_REASON_CODE AMENDMENT_REASON_CODE, AUTH_SIGN_DATE AUTH_SIGN_DATE, AUTH_CANCEL_DATE AUTH_CANCEL_DATE, DEBIT_AUTH_METHOD DEBIT_AUTH_METHOD, PRE_NOTIFICATION_REQUIRED_FLAG PRE_NOTIFICATION_REQUIRED_FLAG, CREDITOR_LEGAL_ENTITY_ID CREDITOR_LEGAL_ENTITY_ID, CREDITOR_LE_NAME CREDITOR_LE_NAME, CREDITOR_IDENTIFIER CREDITOR_IDENTIFIER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DEBIT_AUTH_BEGIN DEBIT_AUTH_BEGIN, DEBIT_AUTH_END DEBIT_AUTH_END, CURR_REC_INDI CURR_REC_INDI, DEBIT_AUTH_FLAG DEBIT_AUTH_FLAG, DEBIT_AUTH_REFERENCE DEBIT_AUTH_REFERENCE, CUST_ADDR_ID CUST_ADDR_ID, CUST_IDENTIFICATION_CODE CUST_IDENTIFICATION_CODE, MANDATE_FILE MANDATE_FILE from "IBY"."IBY_DEBIT_AUTHORIZATIONS"

View Text - HTML Formatted

SELECT DEBIT_AUTHORIZATION_ID DEBIT_AUTHORIZATION_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, EXTERNAL_BANK_ACCOUNT_USE_ID EXTERNAL_BANK_ACCOUNT_USE_ID
, AUTHORIZATION_REFERENCE_NUMBER AUTHORIZATION_REFERENCE_NUMBER
, INITIAL_DEBIT_AUTHORIZATION_ID INITIAL_DEBIT_AUTHORIZATION_ID
, AUTHORIZATION_REVISION_NUMBER AUTHORIZATION_REVISION_NUMBER
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, AMENDMENT_REASON_CODE AMENDMENT_REASON_CODE
, AUTH_SIGN_DATE AUTH_SIGN_DATE
, AUTH_CANCEL_DATE AUTH_CANCEL_DATE
, DEBIT_AUTH_METHOD DEBIT_AUTH_METHOD
, PRE_NOTIFICATION_REQUIRED_FLAG PRE_NOTIFICATION_REQUIRED_FLAG
, CREDITOR_LEGAL_ENTITY_ID CREDITOR_LEGAL_ENTITY_ID
, CREDITOR_LE_NAME CREDITOR_LE_NAME
, CREDITOR_IDENTIFIER CREDITOR_IDENTIFIER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DEBIT_AUTH_BEGIN DEBIT_AUTH_BEGIN
, DEBIT_AUTH_END DEBIT_AUTH_END
, CURR_REC_INDI CURR_REC_INDI
, DEBIT_AUTH_FLAG DEBIT_AUTH_FLAG
, DEBIT_AUTH_REFERENCE DEBIT_AUTH_REFERENCE
, CUST_ADDR_ID CUST_ADDR_ID
, CUST_IDENTIFICATION_CODE CUST_IDENTIFICATION_CODE
, MANDATE_FILE MANDATE_FILE
FROM "IBY"."IBY_DEBIT_AUTHORIZATIONS"