eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XTR.XTR_BANK_BAL_INTERFACE

Object Details

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

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_BANK_BAL_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	COMPANY_CODE ACCOUNT_NO BALANCE_DATE

Columns

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

Query Text

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;

Dependencies

[top of page]

XTR.XTR_BANK_BAL_INTERFACE does not reference any database object

XTR.XTR_BANK_BAL_INTERFACE is referenced by following:

XTR: XTR_BANK_BAL_INTERFACE#