VIEW: XTR.XTR_BANK_ACCOUNTS#

Source

View Text - Preformatted

select ACCOUNT_NUMBER ACCOUNT_NUMBER, AUDIT_INDICATOR AUDIT_INDICATOR, AUTHORISED AUTHORISED, BANK_CODE BANK_CODE, BANK_NAME BANK_NAME, BANK_SHORT_CODE BANK_SHORT_CODE, CASHFLOWS_TO_CURRENT_DATE CASHFLOWS_TO_CURRENT_DATE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CURRENCY CURRENCY, CURRENT_CASHFLOW_DATE CURRENT_CASHFLOW_DATE, DEFAULT_ACCT DEFAULT_ACCT, DIRECT_DEBIT_AUTHORITY DIRECT_DEBIT_AUTHORITY, EFT_SCRIPT_NAME EFT_SCRIPT_NAME, EFT_SCRIPT_OUTPUT_PATH EFT_SCRIPT_OUTPUT_PATH, CODE_COMBINATION_ID CODE_COMBINATION_ID, GL_COMPANY_CODE GL_COMPANY_CODE, INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS, INTEREST_RATE INTEREST_RATE, INTERNAL_PTY INTERNAL_PTY, LOCATION LOCATION, LIMIT_CODE LIMIT_CODE, OPENING_BALANCE OPENING_BALANCE, OPENING_BAL_HCE OPENING_BAL_HCE, PARTY_CODE PARTY_CODE, PARTY_PRIN_CCID PARTY_PRIN_CCID, PARTY_INT_CCID PARTY_INT_CCID, PARTY_TYPE PARTY_TYPE, PORTFOLIO_CODE PORTFOLIO_CODE, PRIMARY_SETTLEMENT_METHOD PRIMARY_SETTLEMENT_METHOD, PROJECTED_BALANCE PROJECTED_BALANCE, PROJECTED_BALANCE_DATE PROJECTED_BALANCE_DATE, PROJECTED_BALANCE_UPDATED_ON PROJECTED_BALANCE_UPDATED_ON, SETOFF SETOFF, SETOFF_ACCOUNT_YN SETOFF_ACCOUNT_YN, SETOFF_COMPANY SETOFF_COMPANY, STATEMENT_DATE STATEMENT_DATE, STREET STREET, SUB_ACCOUNT_AT SUB_ACCOUNT_AT, SUB_ACCOUNT_NUMBER SUB_ACCOUNT_NUMBER, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, DOMICILED_CURRENCY DOMICILED_CURRENCY, YEAR_CALC_TYPE YEAR_CALC_TYPE, SWIFT_ID SWIFT_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, AP_BANK_ACCOUNT_ID AP_BANK_ACCOUNT_ID, ROUNDING_TYPE ROUNDING_TYPE, DAY_COUNT_TYPE DAY_COUNT_TYPE, PRICING_MODEL PRICING_MODEL, LEGAL_ACCOUNT_NAME LEGAL_ACCOUNT_NAME, TARGET_BALANCE TARGET_BALANCE, CASHFLOW_DISPLAY_ORDER CASHFLOW_DISPLAY_ORDER, DUMMY_BANK_ACCOUNT_ID DUMMY_BANK_ACCOUNT_ID, BANK_BRANCH_ID BANK_BRANCH_ID, BANK_ACCT_USE_ID BANK_ACCT_USE_ID, MAX_TARGET_BALANCE MAX_TARGET_BALANCE, CASHPOOL_MIN_PAYMENT_AMT CASHPOOL_MIN_PAYMENT_AMT, CASHPOOL_MIN_RECEIPT_AMT CASHPOOL_MIN_RECEIPT_AMT, CASHPOOL_ROUND_FACTOR CASHPOOL_ROUND_FACTOR, CASHPOOL_ROUND_RULE CASHPOOL_ROUND_RULE, CASHPOOL_ID CASHPOOL_ID, CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNT_ID, IBAN IBAN from "XTR"."XTR_BANK_ACCOUNTS"

View Text - HTML Formatted

SELECT ACCOUNT_NUMBER ACCOUNT_NUMBER
, AUDIT_INDICATOR AUDIT_INDICATOR
, AUTHORISED AUTHORISED
, BANK_CODE BANK_CODE
, BANK_NAME BANK_NAME
, BANK_SHORT_CODE BANK_SHORT_CODE
, CASHFLOWS_TO_CURRENT_DATE CASHFLOWS_TO_CURRENT_DATE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CURRENCY CURRENCY
, CURRENT_CASHFLOW_DATE CURRENT_CASHFLOW_DATE
, DEFAULT_ACCT DEFAULT_ACCT
, DIRECT_DEBIT_AUTHORITY DIRECT_DEBIT_AUTHORITY
, EFT_SCRIPT_NAME EFT_SCRIPT_NAME
, EFT_SCRIPT_OUTPUT_PATH EFT_SCRIPT_OUTPUT_PATH
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, GL_COMPANY_CODE GL_COMPANY_CODE
, INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS
, INTEREST_RATE INTEREST_RATE
, INTERNAL_PTY INTERNAL_PTY
, LOCATION LOCATION
, LIMIT_CODE LIMIT_CODE
, OPENING_BALANCE OPENING_BALANCE
, OPENING_BAL_HCE OPENING_BAL_HCE
, PARTY_CODE PARTY_CODE
, PARTY_PRIN_CCID PARTY_PRIN_CCID
, PARTY_INT_CCID PARTY_INT_CCID
, PARTY_TYPE PARTY_TYPE
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRIMARY_SETTLEMENT_METHOD PRIMARY_SETTLEMENT_METHOD
, PROJECTED_BALANCE PROJECTED_BALANCE
, PROJECTED_BALANCE_DATE PROJECTED_BALANCE_DATE
, PROJECTED_BALANCE_UPDATED_ON PROJECTED_BALANCE_UPDATED_ON
, SETOFF SETOFF
, SETOFF_ACCOUNT_YN SETOFF_ACCOUNT_YN
, SETOFF_COMPANY SETOFF_COMPANY
, STATEMENT_DATE STATEMENT_DATE
, STREET STREET
, SUB_ACCOUNT_AT SUB_ACCOUNT_AT
, SUB_ACCOUNT_NUMBER SUB_ACCOUNT_NUMBER
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, DOMICILED_CURRENCY DOMICILED_CURRENCY
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, SWIFT_ID SWIFT_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, AP_BANK_ACCOUNT_ID AP_BANK_ACCOUNT_ID
, ROUNDING_TYPE ROUNDING_TYPE
, DAY_COUNT_TYPE DAY_COUNT_TYPE
, PRICING_MODEL PRICING_MODEL
, LEGAL_ACCOUNT_NAME LEGAL_ACCOUNT_NAME
, TARGET_BALANCE TARGET_BALANCE
, CASHFLOW_DISPLAY_ORDER CASHFLOW_DISPLAY_ORDER
, DUMMY_BANK_ACCOUNT_ID DUMMY_BANK_ACCOUNT_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, BANK_ACCT_USE_ID BANK_ACCT_USE_ID
, MAX_TARGET_BALANCE MAX_TARGET_BALANCE
, CASHPOOL_MIN_PAYMENT_AMT CASHPOOL_MIN_PAYMENT_AMT
, CASHPOOL_MIN_RECEIPT_AMT CASHPOOL_MIN_RECEIPT_AMT
, CASHPOOL_ROUND_FACTOR CASHPOOL_ROUND_FACTOR
, CASHPOOL_ROUND_RULE CASHPOOL_ROUND_RULE
, CASHPOOL_ID CASHPOOL_ID
, CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNT_ID
, IBAN IBAN
FROM "XTR"."XTR_BANK_ACCOUNTS"