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: AP.AP_PAYMENT_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, ORGANIZATION_NAME ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, PAYMENT_NUMBER PAYMENT_NUMBER, PAYMENT_TYPE PAYMENT_TYPE, PAYMENT_DOC_SEQ_NAME PAYMENT_DOC_SEQ_NAME, PAYMENT_DOC_SEQ_VALUE PAYMENT_DOC_SEQ_VALUE, PAYMENT_DATE PAYMENT_DATE, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, ORIG_PAYMENT_AMOUNT ORIG_PAYMENT_AMOUNT, ORIG_PAYMENT_BASE_AMOUNT ORIG_PAYMENT_BASE_AMOUNT, PAYMENT_AMOUNT PAYMENT_AMOUNT, PAYMENT_BASE_AMOUNT PAYMENT_BASE_AMOUNT, PAYMENT_EXCHANGE_RATE PAYMENT_EXCHANGE_RATE, PAYMENT_EXCHANGE_DATE PAYMENT_EXCHANGE_DATE, PAYMENT_EXCHANGE_TYPE PAYMENT_EXCHANGE_TYPE, PAYMENT_CLEARED_DATE PAYMENT_CLEARED_DATE, PAYMENT_CLEARED_AMOUNT PAYMENT_CLEARED_AMOUNT, PAYMENT_CLEARED_BASE_AMOUNT PAYMENT_CLEARED_BASE_AMOUNT, PAYMENT_CLEARED_EXC_RATE PAYMENT_CLEARED_EXC_RATE, PAYMENT_CLEARED_EXC_DATE PAYMENT_CLEARED_EXC_DATE, PAYMENT_CLEARED_EXC_TYPE PAYMENT_CLEARED_EXC_TYPE, PAYMENT_FUTURE_PAY_DUE_DATE PAYMENT_FUTURE_PAY_DUE_DATE, PAYMENT_VOID_FLAG PAYMENT_VOID_FLAG, PAYMENT_PAY_METHOD PAYMENT_PAY_METHOD, PAYMENT_DOC_NAME PAYMENT_DOC_NAME, PAYMENT_DISBURSEMENT_TYPE PAYMENT_DISBURSEMENT_TYPE, PAYMENT_STATUS PAYMENT_STATUS, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_NAME_ALT SUPPLIER_NAME_ALT, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, SUPPLIER_SITE_CODE_ALT SUPPLIER_SITE_CODE_ALT, SUPPLIER_ADDRESS_LINE1 SUPPLIER_ADDRESS_LINE1, SUPPLIER_ADDRESS_LINE2 SUPPLIER_ADDRESS_LINE2, SUPPLIER_ADDRESS_LINE3 SUPPLIER_ADDRESS_LINE3, SUPPLIER_ADDRESS_ALT SUPPLIER_ADDRESS_ALT, SUPPLIER_CITY SUPPLIER_CITY, SUPPLIER_STATE SUPPLIER_STATE, SUPPLIER_PROVINCE SUPPLIER_PROVINCE, SUPPLIER_POSTAL_CODE SUPPLIER_POSTAL_CODE, SUPPLIER_COUNTRY SUPPLIER_COUNTRY, SUPPLIER_TERRITORY SUPPLIER_TERRITORY, INT_BANK_NAME INT_BANK_NAME, INT_BANK_NAME_ALT INT_BANK_NAME_ALT, INT_BANK_NUMBER INT_BANK_NUMBER, INT_BANK_BRANCH_NAME INT_BANK_BRANCH_NAME, INT_BANK_BRANCH_NAME_ALT INT_BANK_BRANCH_NAME_ALT, INT_BANK_NUM#1 INT_BANK_NUM, INT_BANK_ACCOUNT_NAME INT_BANK_ACCOUNT_NAME, INT_BANK_ACCOUNT_NAME_ALT INT_BANK_ACCOUNT_NAME_ALT, INT_BANK_ACCOUNT_NUM INT_BANK_ACCOUNT_NUM, INT_BANK_CURRENCY_CODE INT_BANK_CURRENCY_CODE, INV_PAY_AMOUNT INV_PAY_AMOUNT, INV_PAY_BASE_AMOUNT INV_PAY_BASE_AMOUNT, INV_PAY_DISCOUNT_TAKEN INV_PAY_DISCOUNT_TAKEN, INVOICE_NUM INVOICE_NUM, INVOICE_DATE INVOICE_DATE, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, INVOICE_AMOUNT INVOICE_AMOUNT, INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT, INVOICE_DESCRIPTION INVOICE_DESCRIPTION from "AP"."AP_PAYMENT_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
, ORGANIZATION_NAME ORGANIZATION_NAME
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, PAYMENT_NUMBER PAYMENT_NUMBER
, PAYMENT_TYPE PAYMENT_TYPE
, PAYMENT_DOC_SEQ_NAME PAYMENT_DOC_SEQ_NAME
, PAYMENT_DOC_SEQ_VALUE PAYMENT_DOC_SEQ_VALUE
, PAYMENT_DATE PAYMENT_DATE
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, ORIG_PAYMENT_AMOUNT ORIG_PAYMENT_AMOUNT
, ORIG_PAYMENT_BASE_AMOUNT ORIG_PAYMENT_BASE_AMOUNT
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, PAYMENT_BASE_AMOUNT PAYMENT_BASE_AMOUNT
, PAYMENT_EXCHANGE_RATE PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_DATE PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_TYPE PAYMENT_EXCHANGE_TYPE
, PAYMENT_CLEARED_DATE PAYMENT_CLEARED_DATE
, PAYMENT_CLEARED_AMOUNT PAYMENT_CLEARED_AMOUNT
, PAYMENT_CLEARED_BASE_AMOUNT PAYMENT_CLEARED_BASE_AMOUNT
, PAYMENT_CLEARED_EXC_RATE PAYMENT_CLEARED_EXC_RATE
, PAYMENT_CLEARED_EXC_DATE PAYMENT_CLEARED_EXC_DATE
, PAYMENT_CLEARED_EXC_TYPE PAYMENT_CLEARED_EXC_TYPE
, PAYMENT_FUTURE_PAY_DUE_DATE PAYMENT_FUTURE_PAY_DUE_DATE
, PAYMENT_VOID_FLAG PAYMENT_VOID_FLAG
, PAYMENT_PAY_METHOD PAYMENT_PAY_METHOD
, PAYMENT_DOC_NAME PAYMENT_DOC_NAME
, PAYMENT_DISBURSEMENT_TYPE PAYMENT_DISBURSEMENT_TYPE
, PAYMENT_STATUS PAYMENT_STATUS
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_NAME_ALT SUPPLIER_NAME_ALT
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, SUPPLIER_SITE_CODE_ALT SUPPLIER_SITE_CODE_ALT
, SUPPLIER_ADDRESS_LINE1 SUPPLIER_ADDRESS_LINE1
, SUPPLIER_ADDRESS_LINE2 SUPPLIER_ADDRESS_LINE2
, SUPPLIER_ADDRESS_LINE3 SUPPLIER_ADDRESS_LINE3
, SUPPLIER_ADDRESS_ALT SUPPLIER_ADDRESS_ALT
, SUPPLIER_CITY SUPPLIER_CITY
, SUPPLIER_STATE SUPPLIER_STATE
, SUPPLIER_PROVINCE SUPPLIER_PROVINCE
, SUPPLIER_POSTAL_CODE SUPPLIER_POSTAL_CODE
, SUPPLIER_COUNTRY SUPPLIER_COUNTRY
, SUPPLIER_TERRITORY SUPPLIER_TERRITORY
, INT_BANK_NAME INT_BANK_NAME
, INT_BANK_NAME_ALT INT_BANK_NAME_ALT
, INT_BANK_NUMBER INT_BANK_NUMBER
, INT_BANK_BRANCH_NAME INT_BANK_BRANCH_NAME
, INT_BANK_BRANCH_NAME_ALT INT_BANK_BRANCH_NAME_ALT
, INT_BANK_NUM#1 INT_BANK_NUM
, INT_BANK_ACCOUNT_NAME INT_BANK_ACCOUNT_NAME
, INT_BANK_ACCOUNT_NAME_ALT INT_BANK_ACCOUNT_NAME_ALT
, INT_BANK_ACCOUNT_NUM INT_BANK_ACCOUNT_NUM
, INT_BANK_CURRENCY_CODE INT_BANK_CURRENCY_CODE
, INV_PAY_AMOUNT INV_PAY_AMOUNT
, INV_PAY_BASE_AMOUNT INV_PAY_BASE_AMOUNT
, INV_PAY_DISCOUNT_TAKEN INV_PAY_DISCOUNT_TAKEN
, INVOICE_NUM INVOICE_NUM
, INVOICE_DATE INVOICE_DATE
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, INVOICE_AMOUNT INVOICE_AMOUNT
, INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT
, INVOICE_DESCRIPTION INVOICE_DESCRIPTION
FROM "AP"."AP_PAYMENT_REP_ITF"