[Home] [Help] [Dependency Information]
Object Name: | XTR_BANK_ACCOUNTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_BANK_ACCOUNTS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_NUMBER | VARCHAR2 | (20) | Yes | Alpha-numeric reference to financial accounts of Treasury parties |
PARTY_CODE | VARCHAR2 | (7) | Yes | Party code |
CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
BANK_NAME | VARCHAR2 | (50) | Bank name | |
BANK_SHORT_CODE | VARCHAR2 | (80) | Yes | Bank short code |
LOCATION | VARCHAR2 | (35) | Yes | Bank location |
STREET | VARCHAR2 | (35) | Yes | Street name |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created | |
CODE_COMBINATION_ID | NUMBER | (15) | Unique key for identifying GL account references | |
GL_COMPANY_CODE | VARCHAR2 | (7) | General Ledger company code | |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
OPENING_BALANCE | NUMBER | Opening balance | ||
OPENING_BAL_HCE | NUMBER | Opening balance in reporting currency equivalent | ||
STATEMENT_DATE | DATE | Statement date | ||
DEFAULT_ACCT | VARCHAR2 | (1) | Flag to indicate if the account is the default account (Y), or not (N) | |
PARTY_TYPE | VARCHAR2 | (2) | Flag to indicate if the party is a company (C) or counterparty (CP) | |
AUTHORISED | VARCHAR2 | (1) | Flag to indicate if the bank account is authorized for use (Y), or not (N) | |
SETOFF | VARCHAR2 | (5) | Setoff code of the nominal account | |
BANK_CODE | VARCHAR2 | (7) | Bank code | |
SETOFF_ACCOUNT_YN | VARCHAR2 | (1) | Flag to indicate if the account is a nominal account (Y), or not (null) | |
INTEREST_CALCULATION_BASIS | VARCHAR2 | (4) | Interest calculation basis (STEP or FLAT) | |
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
PRIMARY_SETTLEMENT_METHOD | VARCHAR2 | (15) | Not currently used | |
DIRECT_DEBIT_AUTHORITY | VARCHAR2 | (1) | Flag to indicate whether the company has direct debit authority to this account (Y), or not (N) | |
EFT_SCRIPT_NAME | VARCHAR2 | (50) | Settlement script | |
EFT_SCRIPT_OUTPUT_PATH | VARCHAR2 | (50) | EFT script output path | |
SUB_ACCOUNT_AT | VARCHAR2 | (100) | Not currently used | |
SUB_ACCOUNT_NUMBER | VARCHAR2 | (20) | Not currently used | |
CASHFLOWS_TO_CURRENT_DATE | NUMBER | Not currently used | ||
CURRENT_CASHFLOW_DATE | DATE | Not currently used | ||
PROJECTED_BALANCE | NUMBER | Projected balance of bank account based on future recorded cashflows | ||
PROJECTED_BALANCE_DATE | DATE | Projected balance date | ||
PROJECTED_BALANCE_UPDATED_ON | DATE | Date the projected balance was last updated | ||
INTEREST_RATE | NUMBER | Interest rate | ||
DOMICILED_CURRENCY | VARCHAR2 | (15) | National currency in which the bank can make settlements (only applies to euro currency accounts) | |
LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
YEAR_CALC_TYPE | VARCHAR2 | (15) | Day count basis which defines the way in which interest accrues over time | |
INTERNAL_PTY | VARCHAR2 | (1) | Flag to indicate if the party is an internal party (Y), or not (N) | |
PARTY_PRIN_CCID | NUMBER | (15) | No longer used. Code combination identifier of the general ledger account used to account for the principal cash flows of an intercompany account | |
PARTY_INT_CCID | NUMBER | (15) | No longer used. Code combination identifier of the general ledger account used to account for the interest cash flows of an intercompany account | |
SETOFF_COMPANY | VARCHAR2 | (7) | Party code of the nominal account associated with this setoff account | |
SWIFT_ID | VARCHAR2 | (50) | Bank transit identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | For Descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
AP_BANK_ACCOUNT_ID | NUMBER | (38) | Stores the cross-reference AP bank account number. | |
ROUNDING_TYPE | VARCHAR2 | (1) | Method used to round the calculated interest amount. R or NULL - Round, T - Truncate, U - Round Up | |
DAY_COUNT_TYPE | VARCHAR2 | (1) | Method used to calculate number of days for calculating interest. NULL - Current Logic, F - First Day type, L - Last Day type, B - Both Days type | |
PRICING_MODEL | VARCHAR2 | (30) | Bank Account pricing model | |
LEGAL_ACCOUNT_NAME | VARCHAR2 | (240) | Legal account name | |
DUMMY_BANK_ACCOUNT_ID | NUMBER | Dummy AP bank account ID | ||
TARGET_BALANCE | NUMBER | Target bank account balance | ||
CASHFLOW_DISPLAY_ORDER | NUMBER | Cashflow display order | ||
MAX_TARGET_BALANCE | NUMBER | Maximum target balance | ||
CASHPOOL_MIN_RECEIPT_AMT | NUMBER | Minimum receipt amount | ||
CASHPOOL_MIN_PAYMENT_AMT | NUMBER | Minimum payment amount | ||
CASHPOOL_ROUND_FACTOR | NUMBER | Rounding factor | ||
CASHPOOL_ROUND_RULE | VARCHAR2 | (1) | Rounding rule | |
CASHPOOL_ID | NUMBER | (15) | Physical cashpool ID | |
CE_BANK_ACCOUNT_ID | NUMBER | (15) | ||
BANK_BRANCH_ID | NUMBER | (15) | ||
BANK_ACCT_USE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
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
, SETOFF_ACCOUNT_YN
, INTEREST_CALCULATION_BASIS
, AUDIT_INDICATOR
, 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
, DOMICILED_CURRENCY
, LIMIT_CODE
, YEAR_CALC_TYPE
, INTERNAL_PTY
, PARTY_PRIN_CCID
, PARTY_INT_CCID
, SETOFF_COMPANY
, SWIFT_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, AP_BANK_ACCOUNT_ID
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, PRICING_MODEL
, LEGAL_ACCOUNT_NAME
, DUMMY_BANK_ACCOUNT_ID
, TARGET_BALANCE
, CASHFLOW_DISPLAY_ORDER
, MAX_TARGET_BALANCE
, CASHPOOL_MIN_RECEIPT_AMT
, CASHPOOL_MIN_PAYMENT_AMT
, CASHPOOL_ROUND_FACTOR
, CASHPOOL_ROUND_RULE
, CASHPOOL_ID
, CE_BANK_ACCOUNT_ID
, BANK_BRANCH_ID
, BANK_ACCT_USE_ID
FROM APPS.XTR_BANK_ACCOUNTS_V;
|
|
|