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: AP_XML_PAYMENTACCOUNTLEVEL_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AISC.CHECKRUN_NAME
, AISC.CHECKRUN_ID
, ABA.BANK_ACCOUNT_NUM
, ABA.BANK_ACCOUNT_TYPE
, ABA.CHECK_DIGITS
, ABA.CURRENCY_CODE
, ABA.BANK_ACCOUNT_NAME
, ABB.BANK_BRANCH_TYPE
, ABB.BANK_NUMBER
, ABB.BANK_NAME
, ABB.BANK_BRANCH_NAME
, ABB.BANK_NUM
, ABB.CONTACT_TITLE
, ABB.PHONE
, ABB.CITY
, ABB.STATE
, ABB.ZIP
, ABB.COUNTRY
, ABA.EFT_USER_NUMBER
, ABB.EFT_SWIFT_CODE
, ABB.CONTACT_FIRST_NAME||' '||ABB.CONTACT_LAST_NAME
, ABB.ADDRESS_LINE1||'
, '||ABB.ADDRESS_LINE2
FROM AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
, AP_BANK_BRANCHES ABB
WHERE AISC.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID

Columns

Name
BATCH_NAME
BATCH_ID
BANK_ACCOUNT_NUM
BANK_ACCOUNT_TYPE
ACCOUNT_KEY
ACCOUNT_CURRENCY
ACCOUNT_NAME
BANK_ID_TYPE
BANK_NUMBER
BANK_NAME
BRANCH_NAME
BRANCH_NUMBER
BANK_CONTACT_TYPE
BANK_CONTACT_TELEPHONE
CITY
STATE
POSTAL_CODE
COUNTRY
EFT_USER_NUMBER
EFT_SWIFT_CODE
BANK_CONTACT_NAME
ADDRESSLINE