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

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

View Text

SELECT BB.BANK_BRANCH_ID
, BB.BANK_NAME
, BB.BANK_NAME_ALT
, BB.BANK_NUMBER
, BB.BANK_BRANCH_NAME
, BB.BANK_BRANCH_NAME_ALT
, BB.BANK_NUM
, BB.BANK_BRANCH_TYPE
, BB.INSTITUTION_TYPE
, BB.DESCRIPTION
, BB.ACTIVE_DATE
, BB.END_DATE
, BB.ADDRESS_LINE1
, BB.ADDRESS_LINE2
, BB.ADDRESS_LINE3
, BB.ADDRESS_LINE4
, BB.ADDRESS_LINES_ALT
, BB.CITY
, BB.COUNTY
, BB.STATE
, BB.ZIP
, BB.COUNTRY
, BB.AREA_CODE
, BB.PHONE
, BB.CONTACT_FIRST_NAME
, BB.CONTACT_MIDDLE_NAME
, BB.CONTACT_LAST_NAME
, BB.CONTACT_PREFIX
, BB.CONTACT_TITLE
, BB.EFT_USER_NUMBER
, BB.EFT_SWIFT_CODE
, BB.EDI_ID_NUMBER
, BB.CREATION_DATE
, BB.CREATED_BY
, BB.LAST_UPDATE_DATE
, BB.LAST_UPDATED_BY
FROM AP_BANK_BRANCHES BB WITH READ ONLY

Columns

Name
BANK_BRANCH_ID
BANK_NAME
ALTERNATE_BANK_NAME
BANK_NUMBER
BANK_BRANCH_NAME
ALTERNATE_BANK_BRANCH_NAME
BANK_BRANCH_NUMBER
BANK_BRANCH_TYPE
INSTITUTION_TYPE
DESCRIPTION
START_EFFECTIVE_DATE
END_EFFECTIVE_DATE
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
ALTERNATE_ADDRESS_LINES
CITY
COUNTY
STATE
ZIP_CODE
COUNTRY
AREA_CODE
PHONE
CONTACT_FIRST_NAME
CONTACT_MIDDLE_NAME
CONTACT_LAST_NAME
CONTACT_PREFIX
CONTACT_TITLE
EFT_USER_NUMBER
EFT_SWIFT_CODE
EDI_ID_NUMBER
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY