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.

[Home] [Help]

VIEW: AR.AR_BR_STATUS_REP_ITF#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, 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, STATUS STATUS, STATUS_DATE STATUS_DATE, TRANSACTION_NUMBER TRANSACTION_NUMBER, DOCUMENT_NUMBER DOCUMENT_NUMBER, DOCUMENT_SEQUENCE_NAME DOCUMENT_SEQUENCE_NAME, CURRENCY CURRENCY, MAGNETIC_FORMAT_CODE MAGNETIC_FORMAT_CODE, ENTERED_AMOUNT ENTERED_AMOUNT, FUNCTIONAL_AMOUNT FUNCTIONAL_AMOUNT, BALANCE_DUE BALANCE_DUE, FUNCTIONAL_BALANCE_DUE FUNCTIONAL_BALANCE_DUE, ASSIGNED_ENTERED_AMOUNT ASSIGNED_ENTERED_AMOUNT, ASSIGNED_FUNCTIONAL_AMOUNT ASSIGNED_FUNCTIONAL_AMOUNT, DRAWEE_NAME DRAWEE_NAME, DRAWEE_NUMBER DRAWEE_NUMBER, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE, DRAWEE_VAT_REG_NUMBER DRAWEE_VAT_REG_NUMBER, DRAWEE_CITY DRAWEE_CITY, DRAWEE_STATE DRAWEE_STATE, DRAWEE_COUNTRY DRAWEE_COUNTRY, DRAWEE_POSTAL_CODE DRAWEE_POSTAL_CODE, DRAWEE_CLASS DRAWEE_CLASS, DRAWEE_CATEGORY DRAWEE_CATEGORY, DRAWEE_LOCATION DRAWEE_LOCATION, ISSUE_DATE ISSUE_DATE, CREATION_GL_DATE CREATION_GL_DATE, STATUS_GL_DATE STATUS_GL_DATE, MATURITY_DATE MATURITY_DATE, ORIGINAL_MATURITY_DATE ORIGINAL_MATURITY_DATE, ISSUED_BY_DRAWEE ISSUED_BY_DRAWEE, SIGNED_BY_DRAWEE SIGNED_BY_DRAWEE, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_BATCH_SOURCE TRANSACTION_BATCH_SOURCE, REMIT_BANK_NAME REMIT_BANK_NAME, REMIT_BANK_NUMBER REMIT_BANK_NUMBER, REMIT_BRANCH_NAME REMIT_BRANCH_NAME, REMIT_BRANCH_NUMBER REMIT_BRANCH_NUMBER, REMIT_BANK_ACC_NAME REMIT_BANK_ACC_NAME, REMIT_BANK_ACC_NUMBER REMIT_BANK_ACC_NUMBER, REMIT_BRANCH_CITY REMIT_BRANCH_CITY, REMIT_BRANCH_STATE REMIT_BRANCH_STATE, REMIT_BRANCH_COUNTRY REMIT_BRANCH_COUNTRY, REMIT_BRANCH_POSTAL_CODE REMIT_BRANCH_POSTAL_CODE, REMIT_BRANCH_ADDRESS1 REMIT_BRANCH_ADDRESS1, REMIT_BRANCH_ADDRESS2 REMIT_BRANCH_ADDRESS2, REMIT_BRANCH_ADDRESS3 REMIT_BRANCH_ADDRESS3, REMIT_BANK_ALLOW_OVERRIDE REMIT_BANK_ALLOW_OVERRIDE, REMIT_BANK_ACC_CHECK_DIGITS REMIT_BANK_ACC_CHECK_DIGITS, REMIT_BANK_ACC_CURR REMIT_BANK_ACC_CURR, DRAWEE_BANK_NAME DRAWEE_BANK_NAME, DRAWEE_BANK_NUMBER DRAWEE_BANK_NUMBER, DRAWEE_BRANCH_NAME DRAWEE_BRANCH_NAME, DRAWEE_BRANCH_NUMBER DRAWEE_BRANCH_NUMBER, DRAWEE_BANK_ACC_NAME DRAWEE_BANK_ACC_NAME, DRAWEE_BANK_ACC_NUMBER DRAWEE_BANK_ACC_NUMBER, DRAWEE_BRANCH_CITY DRAWEE_BRANCH_CITY, DRAWEE_BRANCH_STATE DRAWEE_BRANCH_STATE, DRAWEE_BRANCH_COUNTRY DRAWEE_BRANCH_COUNTRY, DRAWEE_BRANCH_POSTAL_CODE DRAWEE_BRANCH_POSTAL_CODE, DRAWEE_BRANCH_ADDRESS1 DRAWEE_BRANCH_ADDRESS1, DRAWEE_BRANCH_ADDRESS2 DRAWEE_BRANCH_ADDRESS2, DRAWEE_BRANCH_ADDRESS3 DRAWEE_BRANCH_ADDRESS3, DRAWEE_BANK_ACC_CHECK_DIGITS DRAWEE_BANK_ACC_CHECK_DIGITS, DRAWEE_BANK_ACC_CURR DRAWEE_BANK_ACC_CURR, UNPAID_DATE UNPAID_DATE, ACCEPTANCE_DATE ACCEPTANCE_DATE, COMMENTS COMMENTS, DAYS_LATE DAYS_LATE, REMITTANCE_BATCH_NAME REMITTANCE_BATCH_NAME, REMITTANCE_METHOD REMITTANCE_METHOD, WITH_RECOURSE WITH_RECOURSE, LAST_PRINTED_DATE LAST_PRINTED_DATE, UNPAID_RECEIPT_REVERSAL_REASON UNPAID_RECEIPT_REVERSAL_REASON, RISK_ELIMINATION_DAYS RISK_ELIMINATION_DAYS, REMITTANCE_DATE REMITTANCE_DATE, REMITTANCE_PAYMENT_METHOD REMITTANCE_PAYMENT_METHOD, CREATION_BATCH_NAME CREATION_BATCH_NAME, DRAWEE_ADDRESS1 DRAWEE_ADDRESS1, DRAWEE_ADDRESS2 DRAWEE_ADDRESS2, DRAWEE_ADDRESS3 DRAWEE_ADDRESS3, DRAWEE_CONTACT DRAWEE_CONTACT, SPECIAL_INSTRUCTIONS SPECIAL_INSTRUCTIONS, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANIZATION_NAME ORGANIZATION_NAME from "AR"."AR_BR_STATUS_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, 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
, STATUS STATUS
, STATUS_DATE STATUS_DATE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, DOCUMENT_SEQUENCE_NAME DOCUMENT_SEQUENCE_NAME
, CURRENCY CURRENCY
, MAGNETIC_FORMAT_CODE MAGNETIC_FORMAT_CODE
, ENTERED_AMOUNT ENTERED_AMOUNT
, FUNCTIONAL_AMOUNT FUNCTIONAL_AMOUNT
, BALANCE_DUE BALANCE_DUE
, FUNCTIONAL_BALANCE_DUE FUNCTIONAL_BALANCE_DUE
, ASSIGNED_ENTERED_AMOUNT ASSIGNED_ENTERED_AMOUNT
, ASSIGNED_FUNCTIONAL_AMOUNT ASSIGNED_FUNCTIONAL_AMOUNT
, DRAWEE_NAME DRAWEE_NAME
, DRAWEE_NUMBER DRAWEE_NUMBER
, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
, DRAWEE_VAT_REG_NUMBER DRAWEE_VAT_REG_NUMBER
, DRAWEE_CITY DRAWEE_CITY
, DRAWEE_STATE DRAWEE_STATE
, DRAWEE_COUNTRY DRAWEE_COUNTRY
, DRAWEE_POSTAL_CODE DRAWEE_POSTAL_CODE
, DRAWEE_CLASS DRAWEE_CLASS
, DRAWEE_CATEGORY DRAWEE_CATEGORY
, DRAWEE_LOCATION DRAWEE_LOCATION
, ISSUE_DATE ISSUE_DATE
, CREATION_GL_DATE CREATION_GL_DATE
, STATUS_GL_DATE STATUS_GL_DATE
, MATURITY_DATE MATURITY_DATE
, ORIGINAL_MATURITY_DATE ORIGINAL_MATURITY_DATE
, ISSUED_BY_DRAWEE ISSUED_BY_DRAWEE
, SIGNED_BY_DRAWEE SIGNED_BY_DRAWEE
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_BATCH_SOURCE TRANSACTION_BATCH_SOURCE
, REMIT_BANK_NAME REMIT_BANK_NAME
, REMIT_BANK_NUMBER REMIT_BANK_NUMBER
, REMIT_BRANCH_NAME REMIT_BRANCH_NAME
, REMIT_BRANCH_NUMBER REMIT_BRANCH_NUMBER
, REMIT_BANK_ACC_NAME REMIT_BANK_ACC_NAME
, REMIT_BANK_ACC_NUMBER REMIT_BANK_ACC_NUMBER
, REMIT_BRANCH_CITY REMIT_BRANCH_CITY
, REMIT_BRANCH_STATE REMIT_BRANCH_STATE
, REMIT_BRANCH_COUNTRY REMIT_BRANCH_COUNTRY
, REMIT_BRANCH_POSTAL_CODE REMIT_BRANCH_POSTAL_CODE
, REMIT_BRANCH_ADDRESS1 REMIT_BRANCH_ADDRESS1
, REMIT_BRANCH_ADDRESS2 REMIT_BRANCH_ADDRESS2
, REMIT_BRANCH_ADDRESS3 REMIT_BRANCH_ADDRESS3
, REMIT_BANK_ALLOW_OVERRIDE REMIT_BANK_ALLOW_OVERRIDE
, REMIT_BANK_ACC_CHECK_DIGITS REMIT_BANK_ACC_CHECK_DIGITS
, REMIT_BANK_ACC_CURR REMIT_BANK_ACC_CURR
, DRAWEE_BANK_NAME DRAWEE_BANK_NAME
, DRAWEE_BANK_NUMBER DRAWEE_BANK_NUMBER
, DRAWEE_BRANCH_NAME DRAWEE_BRANCH_NAME
, DRAWEE_BRANCH_NUMBER DRAWEE_BRANCH_NUMBER
, DRAWEE_BANK_ACC_NAME DRAWEE_BANK_ACC_NAME
, DRAWEE_BANK_ACC_NUMBER DRAWEE_BANK_ACC_NUMBER
, DRAWEE_BRANCH_CITY DRAWEE_BRANCH_CITY
, DRAWEE_BRANCH_STATE DRAWEE_BRANCH_STATE
, DRAWEE_BRANCH_COUNTRY DRAWEE_BRANCH_COUNTRY
, DRAWEE_BRANCH_POSTAL_CODE DRAWEE_BRANCH_POSTAL_CODE
, DRAWEE_BRANCH_ADDRESS1 DRAWEE_BRANCH_ADDRESS1
, DRAWEE_BRANCH_ADDRESS2 DRAWEE_BRANCH_ADDRESS2
, DRAWEE_BRANCH_ADDRESS3 DRAWEE_BRANCH_ADDRESS3
, DRAWEE_BANK_ACC_CHECK_DIGITS DRAWEE_BANK_ACC_CHECK_DIGITS
, DRAWEE_BANK_ACC_CURR DRAWEE_BANK_ACC_CURR
, UNPAID_DATE UNPAID_DATE
, ACCEPTANCE_DATE ACCEPTANCE_DATE
, COMMENTS COMMENTS
, DAYS_LATE DAYS_LATE
, REMITTANCE_BATCH_NAME REMITTANCE_BATCH_NAME
, REMITTANCE_METHOD REMITTANCE_METHOD
, WITH_RECOURSE WITH_RECOURSE
, LAST_PRINTED_DATE LAST_PRINTED_DATE
, UNPAID_RECEIPT_REVERSAL_REASON UNPAID_RECEIPT_REVERSAL_REASON
, RISK_ELIMINATION_DAYS RISK_ELIMINATION_DAYS
, REMITTANCE_DATE REMITTANCE_DATE
, REMITTANCE_PAYMENT_METHOD REMITTANCE_PAYMENT_METHOD
, CREATION_BATCH_NAME CREATION_BATCH_NAME
, DRAWEE_ADDRESS1 DRAWEE_ADDRESS1
, DRAWEE_ADDRESS2 DRAWEE_ADDRESS2
, DRAWEE_ADDRESS3 DRAWEE_ADDRESS3
, DRAWEE_CONTACT DRAWEE_CONTACT
, SPECIAL_INSTRUCTIONS SPECIAL_INSTRUCTIONS
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
FROM "AR"."AR_BR_STATUS_REP_ITF"