[Home] [Help]
View: XTR_A_BANK_ACCOUNTS_V
View Text
SELECT ACCOUNT_NUMBER
, PARTY_CODE
, CURRENCY
, BANK_NAME
, BANK_SHORT_CODE
, LOCATION
, STREET
, CREATED_BY
, CREATED_ON
, CODE_COMBINATION_ID
, GL_COMPANY_CODE
, UPDATED_BY
, UPDATED_ON
, OPENING_BALANCE
, OPENING_BAL_HCE
, STATEMENT_DATE
, DEFAULT_ACCT
, PARTY_TYPE
, AUTHORISED
, SETOFF
, BANK_CODE
, PARTY_PRIN_CCID
, PARTY_INT_CCID
, INTERNAL_PTY
, SETOFF_COMPANY
, SETOFF_ACCOUNT_YN
, INTEREST_CALCULATION_BASIS
, PORTFOLIO_CODE
, PRIMARY_SETTLEMENT_METHOD
, DIRECT_DEBIT_AUTHORITY
, EFT_SCRIPT_NAME
, EFT_SCRIPT_OUTPUT_PATH
, SUB_ACCOUNT_AT
, SUB_ACCOUNT_NUMBER
, CASHFLOWS_TO_CURRENT_DATE
, CURRENT_CASHFLOW_DATE
, PROJECTED_BALANCE
, PROJECTED_BALANCE_DATE
, PROJECTED_BALANCE_UPDATED_ON
, INTEREST_RATE
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, DOMICILED_CURRENCY
, LIMIT_CODE
, YEAR_CALC_TYPE
FROM XTR_A_BANK_ACCOUNTS
Columns
Name |
ACCOUNT_NUMBER |
PARTY_CODE |
CURRENCY |
BANK_NAME |
BANK_SHORT_CODE |
LOCATION |
STREET |
CREATED_BY |
CREATED_ON |
CODE_COMBINATION_ID |
GL_COMPANY_CODE |
UPDATED_BY |
UPDATED_ON |
OPENING_BALANCE |
OPENING_BAL_HCE |
STATEMENT_DATE |
DEFAULT_ACCT |
PARTY_TYPE |
AUTHORISED |
SETOFF |
BANK_CODE |
PARTY_PRIN_CCID |
PARTY_INT_CCID |
INTERNAL_PTY |
SETOFF_COMPANY |
SETOFF_ACCOUNT_YN |
INTEREST_CALCULATION_BASIS |
PORTFOLIO_CODE |
PRIMARY_SETTLEMENT_METHOD |
DIRECT_DEBIT_AUTHORITY |
EFT_SCRIPT_NAME |
EFT_SCRIPT_OUTPUT_PATH |
SUB_ACCOUNT_AT |
SUB_ACCOUNT_NUMBER |
CASHFLOWS_TO_CURRENT_DATE |
CURRENT_CASHFLOW_DATE |
PROJECTED_BALANCE |
PROJECTED_BALANCE_DATE |
PROJECTED_BALANCE_UPDATED_ON |
INTEREST_RATE |
AUDIT_INDICATOR |
AUDIT_DATE_STORED |
DOMICILED_CURRENCY |
LIMIT_CODE |
YEAR_CALC_BASIS |