VIEW: XTR.XTR_A_BANK_ACCOUNTS#

Source

View Text - Preformatted

select ACCOUNT_NUMBER ACCOUNT_NUMBER, AUDIT_DATE_STORED AUDIT_DATE_STORED, 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_TYPE PARTY_TYPE, PORTFOLIO_CODE PORTFOLIO_CODE, PRIMARY_SETTLEMENT_METHOD PRIMARY_SETTLEMENT_METHOD, PARTY_PRIN_CCID PARTY_PRIN_CCID, PARTY_INT_CCID PARTY_INT_CCID, 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, CASHPOOL_ID CASHPOOL_ID from "XTR"."XTR_A_BANK_ACCOUNTS"

View Text - HTML Formatted

SELECT ACCOUNT_NUMBER ACCOUNT_NUMBER
, AUDIT_DATE_STORED AUDIT_DATE_STORED
, 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_TYPE PARTY_TYPE
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRIMARY_SETTLEMENT_METHOD PRIMARY_SETTLEMENT_METHOD
, PARTY_PRIN_CCID PARTY_PRIN_CCID
, PARTY_INT_CCID PARTY_INT_CCID
, 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
, CASHPOOL_ID CASHPOOL_ID
FROM "XTR"."XTR_A_BANK_ACCOUNTS"