[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 |