VIEW: POS.POS_BANK_ACCOUNT_DET_INT#

Source

View Text - Preformatted

select BANK_ACCOUNT_INTERFACE_ID BANK_ACCOUNT_INTERFACE_ID, PAYEE_NAME PAYEE_NAME, PAYEE_PARTY_ID PAYEE_PARTY_ID, PAYEE_SITE_NAME PAYEE_SITE_NAME, PARTY_SITE_ID PARTY_SITE_ID, OGANIZATION_NAME OGANIZATION_NAME, ORG_ID ORG_ID, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, COUNTRY_CODE COUNTRY_CODE, ALLOW_INTERNATIONAL_PAYMENTS ALLOW_INTERNATIONAL_PAYMENTS, BATCH_ID BATCH_ID, SOURCE_SYSTEM SOURCE_SYSTEM, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE, PAYMENT_FACTOR_FLAG PAYMENT_FACTOR_FLAG, BANK_NAME BANK_NAME, BANK_NUMBER BANK_NUMBER, BANK_ID BANK_ID, BRANCH_NAME BRANCH_NAME, BRANCH_NUMBER BRANCH_NUMBER, BRANCH_ID BRANCH_ID, BIC BIC, BRANCH_TYPE BRANCH_TYPE, BANK_INST_TYPE BANK_INST_TYPE, ALT_BANK_NAME ALT_BANK_NAME, BANK_DESCRIPTION BANK_DESCRIPTION, BANK_END_DATE BANK_END_DATE, BANK_ADDRESS_LINE1 BANK_ADDRESS_LINE1, BANK_ADDRESS_LINE2 BANK_ADDRESS_LINE2, BANK_ADDRESS_LINE3 BANK_ADDRESS_LINE3, BANK_CITY BANK_CITY, BANK_STATE BANK_STATE, BANK_ZIP BANK_ZIP, ALT_BRANCH_NAME ALT_BRANCH_NAME, BRANCH_DESCRIPTION BRANCH_DESCRIPTION, BRANCH_RFC_IDENTIFIER BRANCH_RFC_IDENTIFIER, BRANCH_END_DATE BRANCH_END_DATE, BRANCH_ADDRESS_LINE1 BRANCH_ADDRESS_LINE1, BRANCH_ADDRESS_LINE2 BRANCH_ADDRESS_LINE2, BRANCH_ADDRESS_LINE3 BRANCH_ADDRESS_LINE3, BRANCH_CITY BRANCH_CITY, BRANCH_STATE BRANCH_STATE, BRANCH_ZIP BRANCH_ZIP, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, CHECK_DIGITS CHECK_DIGITS, IBAN IBAN, ACCOUNT_NAME ACCOUNT_NAME, ACCOUNT_CURRENCY_CODE ACCOUNT_CURRENCY_CODE, ALT_ACCOUNT_NAME ALT_ACCOUNT_NAME, ACCOUNT_SUFFIX ACCOUNT_SUFFIX, EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE_AGREEMENT_TYPE, EXCHANGE_RATE EXCHANGE_RATE, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE, ACCOUNT_START_DATE ACCOUNT_START_DATE, ACCOUNT_TYPE ACCOUNT_TYPE, SEC_ACCOUNT_REF SEC_ACCOUNT_REF, EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_NUM, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, ACCOUNT_END_DATE ACCOUNT_END_DATE, FOREIGN_PAYMENT_USE_FLAG FOREIGN_PAYMENT_USE_FLAG, INTER_ACCOUNT1_COUNTRY_CODE INTER_ACCOUNT1_COUNTRY_CODE, INTER_ACCOUNT1_BANK_NAME INTER_ACCOUNT1_BANK_NAME, INTER_ACCOUNT1_BRANCH_NUMBER INTER_ACCOUNT1_BRANCH_NUMBER, INTER_ACCOUNT1_NUMBER INTER_ACCOUNT1_NUMBER, INTER_ACCOUNT1_IBAN INTER_ACCOUNT1_IBAN, INTER_ACCOUNT1_CITY INTER_ACCOUNT1_CITY, INTER_ACCOUNT1_BANK_CODE INTER_ACCOUNT1_BANK_CODE, INTER_ACCOUNT1_BIC INTER_ACCOUNT1_BIC, INTER_ACCOUNT1_CHECK_DIGITS INTER_ACCOUNT1_CHECK_DIGITS, INTER_ACCOUNT1_COMMENTS INTER_ACCOUNT1_COMMENTS, INTER_ACCOUNT2_COUNTRY_CODE INTER_ACCOUNT2_COUNTRY_CODE, INTER_ACCOUNT2_BANK_NAME INTER_ACCOUNT2_BANK_NAME, INTER_ACCOUNT2_BRANCH_NUMBER INTER_ACCOUNT2_BRANCH_NUMBER, INTER_ACCOUNT2_NUMBER INTER_ACCOUNT2_NUMBER, INTER_ACCOUNT2_IBAN INTER_ACCOUNT2_IBAN, INTER_ACCOUNT2_CITY INTER_ACCOUNT2_CITY, INTER_ACCOUNT2_BANK_CODE INTER_ACCOUNT2_BANK_CODE, INTER_ACCOUNT2_BIC INTER_ACCOUNT2_BIC, INTER_ACCOUNT2_CHECK_DIGITS INTER_ACCOUNT2_CHECK_DIGITS, INTER_ACCOUNT2_COMMENTS INTER_ACCOUNT2_COMMENTS, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, INTERFACE_STATUS INTERFACE_STATUS, PARTY_SITE_ORIG_SYS PARTY_SITE_ORIG_SYS, PARTY_SITE_ORIG_SYS_REF PARTY_SITE_ORIG_SYS_REF, PARTY_SITE_NAME PARTY_SITE_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG, PARTY_ID PARTY_ID from "POS"."POS_BANK_ACCOUNT_DET_INT"

View Text - HTML Formatted

SELECT BANK_ACCOUNT_INTERFACE_ID BANK_ACCOUNT_INTERFACE_ID
, PAYEE_NAME PAYEE_NAME
, PAYEE_PARTY_ID PAYEE_PARTY_ID
, PAYEE_SITE_NAME PAYEE_SITE_NAME
, PARTY_SITE_ID PARTY_SITE_ID
, OGANIZATION_NAME OGANIZATION_NAME
, ORG_ID ORG_ID
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, COUNTRY_CODE COUNTRY_CODE
, ALLOW_INTERNATIONAL_PAYMENTS ALLOW_INTERNATIONAL_PAYMENTS
, BATCH_ID BATCH_ID
, SOURCE_SYSTEM SOURCE_SYSTEM
, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE
, PAYMENT_FACTOR_FLAG PAYMENT_FACTOR_FLAG
, BANK_NAME BANK_NAME
, BANK_NUMBER BANK_NUMBER
, BANK_ID BANK_ID
, BRANCH_NAME BRANCH_NAME
, BRANCH_NUMBER BRANCH_NUMBER
, BRANCH_ID BRANCH_ID
, BIC BIC
, BRANCH_TYPE BRANCH_TYPE
, BANK_INST_TYPE BANK_INST_TYPE
, ALT_BANK_NAME ALT_BANK_NAME
, BANK_DESCRIPTION BANK_DESCRIPTION
, BANK_END_DATE BANK_END_DATE
, BANK_ADDRESS_LINE1 BANK_ADDRESS_LINE1
, BANK_ADDRESS_LINE2 BANK_ADDRESS_LINE2
, BANK_ADDRESS_LINE3 BANK_ADDRESS_LINE3
, BANK_CITY BANK_CITY
, BANK_STATE BANK_STATE
, BANK_ZIP BANK_ZIP
, ALT_BRANCH_NAME ALT_BRANCH_NAME
, BRANCH_DESCRIPTION BRANCH_DESCRIPTION
, BRANCH_RFC_IDENTIFIER BRANCH_RFC_IDENTIFIER
, BRANCH_END_DATE BRANCH_END_DATE
, BRANCH_ADDRESS_LINE1 BRANCH_ADDRESS_LINE1
, BRANCH_ADDRESS_LINE2 BRANCH_ADDRESS_LINE2
, BRANCH_ADDRESS_LINE3 BRANCH_ADDRESS_LINE3
, BRANCH_CITY BRANCH_CITY
, BRANCH_STATE BRANCH_STATE
, BRANCH_ZIP BRANCH_ZIP
, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, CHECK_DIGITS CHECK_DIGITS
, IBAN IBAN
, ACCOUNT_NAME ACCOUNT_NAME
, ACCOUNT_CURRENCY_CODE ACCOUNT_CURRENCY_CODE
, ALT_ACCOUNT_NAME ALT_ACCOUNT_NAME
, ACCOUNT_SUFFIX ACCOUNT_SUFFIX
, EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE_AGREEMENT_TYPE
, EXCHANGE_RATE EXCHANGE_RATE
, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE
, ACCOUNT_START_DATE ACCOUNT_START_DATE
, ACCOUNT_TYPE ACCOUNT_TYPE
, SEC_ACCOUNT_REF SEC_ACCOUNT_REF
, EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_NUM
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, ACCOUNT_END_DATE ACCOUNT_END_DATE
, FOREIGN_PAYMENT_USE_FLAG FOREIGN_PAYMENT_USE_FLAG
, INTER_ACCOUNT1_COUNTRY_CODE INTER_ACCOUNT1_COUNTRY_CODE
, INTER_ACCOUNT1_BANK_NAME INTER_ACCOUNT1_BANK_NAME
, INTER_ACCOUNT1_BRANCH_NUMBER INTER_ACCOUNT1_BRANCH_NUMBER
, INTER_ACCOUNT1_NUMBER INTER_ACCOUNT1_NUMBER
, INTER_ACCOUNT1_IBAN INTER_ACCOUNT1_IBAN
, INTER_ACCOUNT1_CITY INTER_ACCOUNT1_CITY
, INTER_ACCOUNT1_BANK_CODE INTER_ACCOUNT1_BANK_CODE
, INTER_ACCOUNT1_BIC INTER_ACCOUNT1_BIC
, INTER_ACCOUNT1_CHECK_DIGITS INTER_ACCOUNT1_CHECK_DIGITS
, INTER_ACCOUNT1_COMMENTS INTER_ACCOUNT1_COMMENTS
, INTER_ACCOUNT2_COUNTRY_CODE INTER_ACCOUNT2_COUNTRY_CODE
, INTER_ACCOUNT2_BANK_NAME INTER_ACCOUNT2_BANK_NAME
, INTER_ACCOUNT2_BRANCH_NUMBER INTER_ACCOUNT2_BRANCH_NUMBER
, INTER_ACCOUNT2_NUMBER INTER_ACCOUNT2_NUMBER
, INTER_ACCOUNT2_IBAN INTER_ACCOUNT2_IBAN
, INTER_ACCOUNT2_CITY INTER_ACCOUNT2_CITY
, INTER_ACCOUNT2_BANK_CODE INTER_ACCOUNT2_BANK_CODE
, INTER_ACCOUNT2_BIC INTER_ACCOUNT2_BIC
, INTER_ACCOUNT2_CHECK_DIGITS INTER_ACCOUNT2_CHECK_DIGITS
, INTER_ACCOUNT2_COMMENTS INTER_ACCOUNT2_COMMENTS
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, INTERFACE_STATUS INTERFACE_STATUS
, PARTY_SITE_ORIG_SYS PARTY_SITE_ORIG_SYS
, PARTY_SITE_ORIG_SYS_REF PARTY_SITE_ORIG_SYS_REF
, PARTY_SITE_NAME PARTY_SITE_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG
, PARTY_ID PARTY_ID
FROM "POS"."POS_BANK_ACCOUNT_DET_INT"