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