[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_BANK_BALANCES |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_BANK_BALANCES
|
| Subobject Name: | |
| Status: | VALID |
XTR_BANK_BALANCES contains the daily bank balances. Each row corresponds to one balance date and amount for a bank account. There can only be one bank balance row per day per bank account. Bank balances can be manually inputted using the Bank Balances window or imported via the XTR_BANK_BAL_INTERFACE table. Treasury uses the daily bank balances to track actual and expected cash flows.
This table corresponds to the Bank Balances window.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_BANK_BALANCES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 COMPANY_CODE
ACCOUNT_NUMBER
BALANCE_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNT_NUMBER | VARCHAR2 | (20) | Yes | Alpha-numeric reference to financial accounts of Treasury parties |
| ACCUM_INT_BFWD | NUMBER | Yes | Accumulated interest on previous balance date | |
| ACCUM_INT_CFWD | NUMBER | Yes | Accumulated interest on current balance date | |
| AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
| BALANCE_ADJUSTMENT | NUMBER | Amount required to adjust the bank statement balance for bank errors (the difference between the interest calculation balance and the statement balance) | ||
| BALANCE_CFLOW | NUMBER | Cash flow balance which reflects counterparty errors and bank errors | ||
| BALANCE_DATE | DATE | Yes | Balance date | |
| COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
| INTEREST | NUMBER | Yes | Interest amount | |
| INTEREST_RATE | NUMBER | Yes | Interest rate at which a deal or transaction is executed | |
| INTEREST_SETTLED | NUMBER | Yes | Interest settlement | |
| INTEREST_SETTLED_HCE | NUMBER | Yes | Interest settlement in reporting currency equivalent | |
| NO_OF_DAYS | NUMBER | Yes | Number of days since the last balance date | |
| SETOFF | VARCHAR2 | (5) | Setoff code of the notional account to which the bank account balance belongs | |
| STATEMENT_BALANCE | NUMBER | Statement balance | ||
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
| CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
| CREATED_ON | DATE | Yes | Date this record was created | |
| ACCRUAL_INTEREST | NUMBER | Running accumulated interest on current balance date | ||
| FIRST_BATCH_ID | NUMBER | (15) | First batch id. Identifier that groups events into one process flow. | |
| LAST_BATCH_ID | NUMBER | (15) | Last batch id. Identifier that groups events into one process flow. | |
| EXCHANGE_RATE | NUMBER | Exchange rate. | ||
| AVERAGE_EXCHANGE_RATE | NUMBER | Average exchange rate. | ||
| ROUNDING_TYPE | VARCHAR2 | (1) | Not currently used | |
| DAY_COUNT_TYPE | VARCHAR2 | (1) | Not currently used | |
| ORIGINAL_AMOUNT | NUMBER | Not currently used | ||
| ONE_DAY_FLOAT | NUMBER | 1-day float bank balance | ||
| TWO_DAY_FLOAT | NUMBER | 2-day float bank balance | ||
| BANK_ACCT_USE_ID | NUMBER | (15) | ID reference to financial accounts of Treasury parties | |
| CE_BANK_ACCOUNT_BALANCE_ID | NUMBER | (15) | Bank Balance Id |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NUMBER
, ACCUM_INT_BFWD
, ACCUM_INT_CFWD
, AUDIT_INDICATOR
, BALANCE_ADJUSTMENT
, BALANCE_CFLOW
, BALANCE_DATE
, COMPANY_CODE
, INTEREST
, INTEREST_RATE
, INTEREST_SETTLED
, INTEREST_SETTLED_HCE
, NO_OF_DAYS
, SETOFF
, STATEMENT_BALANCE
, UPDATED_BY
, UPDATED_ON
, LIMIT_CODE
, CREATED_BY
, CREATED_ON
, ACCRUAL_INTEREST
, FIRST_BATCH_ID
, LAST_BATCH_ID
, EXCHANGE_RATE
, AVERAGE_EXCHANGE_RATE
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, ORIGINAL_AMOUNT
, ONE_DAY_FLOAT
, TWO_DAY_FLOAT
, BANK_ACCT_USE_ID
, CE_BANK_ACCOUNT_BALANCE_ID
FROM XTR.XTR_BANK_BALANCES;
XTR.XTR_BANK_BALANCES does not reference any database object
XTR.XTR_BANK_BALANCES is referenced by following:
APPS
XTR_AID_BANK_BALANCE_T
XTR_AU_BANK_BALANCE_T
XTR_BANK_BALANCES
|
|
|
|