VIEW: POS.POS_SUP_BANK_ACCOUNT_REQUESTS#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, REQUEST_STATUS REQUEST_STATUS, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, VENDOR_ID VENDOR_ID, BANK_BRANCH_ID BANK_BRANCH_ID, BANK_NAME BANK_NAME, BANK_BRANCH_NAME BANK_BRANCH_NAME, BANK_NUMBER BANK_NUMBER, BANK_BRANCH_NUMBER BANK_BRANCH_NUMBER, BRANCH_DESCRIPTION BRANCH_DESCRIPTION, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_LINE4 ADDRESS_LINE4, CITY CITY, COUNTY COUNTY, STATE STATE, ZIP ZIP, PROVINCE PROVINCE, COUNTRY COUNTRY, BANK_BRANCH_TYPE BANK_BRANCH_TYPE, EFT_SWIFT_CODE EFT_SWIFT_CODE, INACTIVE_DATE INACTIVE_DATE, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER, CURRENCY_CODE CURRENCY_CODE, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, CONTACT_FIRST_NAME CONTACT_FIRST_NAME, CONTACT_MIDDLE_NAME CONTACT_MIDDLE_NAME, CONTACT_LAST_NAME CONTACT_LAST_NAME, CONTACT_PREFIX CONTACT_PREFIX, CONTACT_TITLE CONTACT_TITLE, CONTACT_AREA_CODE CONTACT_AREA_CODE, CONTACT_PHONE CONTACT_PHONE, ACCOUNT_TYPE ACCOUNT_TYPE, CHECK_DIGITS CHECK_DIGITS, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME, NOTES_FROM_SUPPLIER NOTES_FROM_SUPPLIER, NOTES_FROM_BUYER NOTES_FROM_BUYER from "POS"."POS_SUP_BANK_ACCOUNT_REQUESTS"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, REQUEST_STATUS REQUEST_STATUS
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VENDOR_ID VENDOR_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, BANK_NAME BANK_NAME
, BANK_BRANCH_NAME BANK_BRANCH_NAME
, BANK_NUMBER BANK_NUMBER
, BANK_BRANCH_NUMBER BANK_BRANCH_NUMBER
, BRANCH_DESCRIPTION BRANCH_DESCRIPTION
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_LINE4 ADDRESS_LINE4
, CITY CITY
, COUNTY COUNTY
, STATE STATE
, ZIP ZIP
, PROVINCE PROVINCE
, COUNTRY COUNTRY
, BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, EFT_SWIFT_CODE EFT_SWIFT_CODE
, INACTIVE_DATE INACTIVE_DATE
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER
, CURRENCY_CODE CURRENCY_CODE
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, CONTACT_FIRST_NAME CONTACT_FIRST_NAME
, CONTACT_MIDDLE_NAME CONTACT_MIDDLE_NAME
, CONTACT_LAST_NAME CONTACT_LAST_NAME
, CONTACT_PREFIX CONTACT_PREFIX
, CONTACT_TITLE CONTACT_TITLE
, CONTACT_AREA_CODE CONTACT_AREA_CODE
, CONTACT_PHONE CONTACT_PHONE
, ACCOUNT_TYPE ACCOUNT_TYPE
, CHECK_DIGITS CHECK_DIGITS
, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME
, NOTES_FROM_SUPPLIER NOTES_FROM_SUPPLIER
, NOTES_FROM_BUYER NOTES_FROM_BUYER
FROM "POS"."POS_SUP_BANK_ACCOUNT_REQUESTS"