FND Design Data [Home] [Help]

View: XTR_A_BANK_ACCOUNTS_V

Product: XTR - Treasury
Description:
Implementation/DBA Data: ViewAPPS.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