[Home] [Help] [Dependency Information]
Object Name: | XTR_BANK_BAL_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_BANK_BAL_INTERFACE |
Subobject Name: | |
Status: | VALID |
XTR_BANK_BAL_INTERFACE contains bank balance information that is to be or has already been uploaded to Treasury. Each row reflects the balance of a specific bank account for a balance date. The "Upload Bank Account Balances" concurrent program transfers the balance data from this table to XTR_BANK_BALANCES.
Scope: public
Product: XTR
Lifecycle: active
Display Name: Treasury Bank Balance Interface
Category: BUSINESS_ENTITY XTR_BANK_BALANCE
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_BANK_BAL_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
COMPANY_CODE
ACCOUNT_NO BALANCE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_NO | VARCHAR2 | (20) | Yes | Alpha-numeric reference to financial accounts of Treasury parties for settlement purposes |
AMOUNT | NUMBER | Yes | Balance amount | |
BALANCE_DATE | DATE | Yes | Balance date | |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
TRANSFER_SUCCEEDED | VARCHAR2 | (1) | Flag to indicate if a balance transfer is successful (Y), or not (N) | |
AMOUNT_ADJ | NUMBER | Adjustment balance amount corresponding to the adjustment balance amount of bank balances. | ||
AMOUNT_CFLOW | NUMBER | Cashflow balance amount corresponding to the cashflow balance amount of bank balances. | ||
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 for settlement purposes |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NO
, AMOUNT
, BALANCE_DATE
, COMPANY_CODE
, TRANSFER_SUCCEEDED
, AMOUNT_ADJ
, AMOUNT_CFLOW
, ONE_DAY_FLOAT
, TWO_DAY_FLOAT
, BANK_ACCT_USE_ID
FROM XTR.XTR_BANK_BAL_INTERFACE;
XTR.XTR_BANK_BAL_INTERFACE does not reference any database object
XTR.XTR_BANK_BAL_INTERFACE is referenced by following:
|
|
|