[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_BANK_ACCOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_BANK_ACCOUNTS
|
| Subobject Name: | |
| Status: | VALID |
XTR_BANK_ACCOUNTS contains bank account information. Each row corresponds to one bank account. Whenever you create or settle a deal transaction cashflow, you can use this table to select the bank accounts that serve as either the source or the receiver for that cashflow. Treasury limits your choice of bank accounts to only physical accounts that belong to the parties involved with the deal transaction (either the company, counterparty, or client), and that you are authorized to use.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_BANK_ACCOUNTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ACCOUNT_NUMBER
PARTY_CODE
|
| XTR_BANK_ACCOUNTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
CE_BANK_ACCOUNT_ID
|
| XTR_BANK_ACCOUNTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_CODE
|
| XTR_BANK_ACCOUNTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CURRENCY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNT_NUMBER | VARCHAR2 | (20) | Yes | Alpha-numeric reference to financial accounts of Treasury parties |
| AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
| AUTHORISED | VARCHAR2 | (1) | Flag to indicate if the bank account is authorized for use (Y), or not (N) | |
| BANK_CODE | VARCHAR2 | (7) | Bank code | |
| BANK_NAME | VARCHAR2 | (50) | Bank name | |
| BANK_SHORT_CODE | VARCHAR2 | (80) | Yes | Bank short code |
| CASHFLOWS_TO_CURRENT_DATE | NUMBER | Not currently used | ||
| CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
| CREATED_ON | DATE | Yes | Date this record was created | |
| CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
| CURRENT_CASHFLOW_DATE | DATE | Not currently used | ||
| DEFAULT_ACCT | VARCHAR2 | (1) | Flag to indicate if the account is the default account (Y), or not (N) | |
| 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 | |
| CODE_COMBINATION_ID | NUMBER | (15) | Unique key for identifying GL account references | |
| GL_COMPANY_CODE | VARCHAR2 | (7) | General Ledger company code | |
| INTEREST_CALCULATION_BASIS | VARCHAR2 | (4) | Interest calculation basis (STEP or FLAT) | |
| INTEREST_RATE | NUMBER | Interest rate | ||
| INTERNAL_PTY | VARCHAR2 | (1) | Flag to indicate if the party is an internal party (Y), or not (N) | |
| LOCATION | VARCHAR2 | (35) | Yes | Bank location |
| LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
| OPENING_BALANCE | NUMBER | Opening balance | ||
| OPENING_BAL_HCE | NUMBER | Opening balance in reporting currency equivalent | ||
| PARTY_CODE | VARCHAR2 | (7) | Yes | Party code |
| 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 | |
| PARTY_TYPE | VARCHAR2 | (2) | Flag to indicate if the party is a company (C) or counterparty (CP) | |
| PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
| PRIMARY_SETTLEMENT_METHOD | VARCHAR2 | (15) | 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 | ||
| SETOFF | VARCHAR2 | (5) | Setoff code of the nominal account | |
| SETOFF_ACCOUNT_YN | VARCHAR2 | (1) | Flag to indicate if the account is a nominal account (Y), or not (null) | |
| SETOFF_COMPANY | VARCHAR2 | (7) | Party code of the nominal account associated with this setoff account | |
| STATEMENT_DATE | DATE | Statement date | ||
| STREET | VARCHAR2 | (35) | Yes | Street name |
| SUB_ACCOUNT_AT | VARCHAR2 | (100) | Not currently used | |
| SUB_ACCOUNT_NUMBER | VARCHAR2 | (20) | Not currently used | |
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| DOMICILED_CURRENCY | VARCHAR2 | (15) | National currency in which the bank can make settlements (only applies to euro currency accounts) | |
| YEAR_CALC_TYPE | VARCHAR2 | (15) | Day count basis which defines the way in which interest accrues over time | |
| 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) | No longer used | |
| 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 | |
| TARGET_BALANCE | NUMBER | No longer used | ||
| CASHFLOW_DISPLAY_ORDER | NUMBER | No longer used | ||
| DUMMY_BANK_ACCOUNT_ID | NUMBER | No longer used | ||
| BANK_BRANCH_ID | NUMBER | (15) | Stores the origin bank ID. | |
| BANK_ACCT_USE_ID | NUMBER | (15) | Stores the cross-reference AP bank account ID | |
| MAX_TARGET_BALANCE | NUMBER | No longer used | ||
| CASHPOOL_MIN_PAYMENT_AMT | NUMBER | Minimum payment amount | ||
| CASHPOOL_MIN_RECEIPT_AMT | NUMBER | Minimum receipt 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 Balance Id | |
| IBAN | VARCHAR2 | (50) | IBAN Account Number |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NUMBER
, AUDIT_INDICATOR
, AUTHORISED
, BANK_CODE
, BANK_NAME
, BANK_SHORT_CODE
, CASHFLOWS_TO_CURRENT_DATE
, CREATED_BY
, CREATED_ON
, CURRENCY
, CURRENT_CASHFLOW_DATE
, DEFAULT_ACCT
, DIRECT_DEBIT_AUTHORITY
, EFT_SCRIPT_NAME
, EFT_SCRIPT_OUTPUT_PATH
, CODE_COMBINATION_ID
, GL_COMPANY_CODE
, INTEREST_CALCULATION_BASIS
, INTEREST_RATE
, INTERNAL_PTY
, LOCATION
, LIMIT_CODE
, OPENING_BALANCE
, OPENING_BAL_HCE
, PARTY_CODE
, PARTY_PRIN_CCID
, PARTY_INT_CCID
, PARTY_TYPE
, PORTFOLIO_CODE
, PRIMARY_SETTLEMENT_METHOD
, PROJECTED_BALANCE
, PROJECTED_BALANCE_DATE
, PROJECTED_BALANCE_UPDATED_ON
, SETOFF
, SETOFF_ACCOUNT_YN
, SETOFF_COMPANY
, STATEMENT_DATE
, STREET
, SUB_ACCOUNT_AT
, SUB_ACCOUNT_NUMBER
, UPDATED_BY
, UPDATED_ON
, DOMICILED_CURRENCY
, YEAR_CALC_TYPE
, 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
, TARGET_BALANCE
, CASHFLOW_DISPLAY_ORDER
, DUMMY_BANK_ACCOUNT_ID
, BANK_BRANCH_ID
, BANK_ACCT_USE_ID
, MAX_TARGET_BALANCE
, CASHPOOL_MIN_PAYMENT_AMT
, CASHPOOL_MIN_RECEIPT_AMT
, CASHPOOL_ROUND_FACTOR
, CASHPOOL_ROUND_RULE
, CASHPOOL_ID
, CE_BANK_ACCOUNT_ID
, IBAN
FROM XTR.XTR_BANK_ACCOUNTS;
XTR.XTR_BANK_ACCOUNTS does not reference any database object
XTR.XTR_BANK_ACCOUNTS is referenced by following:
XTR
XTR_BANK_ACCOUNTS#
|
|
|
|