Skip to content
[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 |