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: FII.FII_AR_OPEN_INSTALLMENT_F

Object Details

Object Name:	FII_AR_OPEN_INSTALLMENT_F
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AR_OPEN_INSTALLMENT_F
Subobject Name:
Status:	VALID

This summary table holds summary information of open installments. It is used to support Risk Indiactor portlets.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AR_OPEN_INSTALLMENT_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SET_OF_BOOKS_FK_KEY
FII_AR_OPEN_INSTALLMENT_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_FK_KEY
FII_AR_OPEN_INSTALLMENT_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CUSTOMER_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
FUNCTIONAL_CURRENCY_FK_KEY	NUMBER			Foreign key to the currency dimension
SET_OF_BOOKS_FK_KEY	NUMBER			Foreign key to the Set of Books dimension
OPERATING_UNIT_FK_KEY	NUMBER			Foreign key to the operating unit level of Organization dimension
CUSTOMER_FK_KEY	NUMBER			Foreign key to the trading partner dimension
RECEIVABLE_G	NUMBER			Total open receivable amount in warehouse currency
RECEIVABLE_B	NUMBER			Total open receivable amount in base currency
RECEIVABLE_T	NUMBER			Total open receivable amount in transaction currency
UNAPP_RECEIPT_G	NUMBER			Total unapplied receipt amount in warehouse currency
UNAPP_RECEIPT_B	NUMBER			Total unapplied receipt amount in base currency
UNAPP_RECEIPT_T	NUMBER			Total unapplied receipt amount in transaction currency
FUNCTIONAL_CURRENCY	VARCHAR2	(80)		Base currency of the set of books to which this transaction belongs to
INVOICE_CURRENCY	VARCHAR2	(80)		Transaction currency of the invoice
CUSTOMER_NAME	VARCHAR2	(120)		Name of the customer
INVOICE_NUMBER	VARCHAR2	(30)		Invoice number of the invoice installment
INSTALLMENT_NUMBER	NUMBER			Installment number of this installment
INVOICE_DATE	DATE			Invoice date of the invoice
DUE_DATE	DATE			Due date of this installment
DATE_OF_SNAPSHOT	DATE			Date which this record is collected
AGE_BUCKET	NUMBER	(1)		The age bucket to which this installment falls into
TYPE	VARCHAR2	(1)		Type of the age bucket
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
RECEIPT_NUMBER	VARCHAR2	(30)		No longer used. Cash receipt number
DISPUTE_DATE	DATE			No longer used. Dispute date
DEPOSIT_DATE	DATE			No longer used. Deposit date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FUNCTIONAL_CURRENCY_FK_KEY
,      SET_OF_BOOKS_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      CUSTOMER_FK_KEY
,      RECEIVABLE_G
,      RECEIVABLE_B
,      RECEIVABLE_T
,      UNAPP_RECEIPT_G
,      UNAPP_RECEIPT_B
,      UNAPP_RECEIPT_T
,      FUNCTIONAL_CURRENCY
,      INVOICE_CURRENCY
,      CUSTOMER_NAME
,      INVOICE_NUMBER
,      INSTALLMENT_NUMBER
,      INVOICE_DATE
,      DUE_DATE
,      DATE_OF_SNAPSHOT
,      AGE_BUCKET
,      TYPE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      RECEIPT_NUMBER
,      DISPUTE_DATE
,      DEPOSIT_DATE
FROM FII.FII_AR_OPEN_INSTALLMENT_F;

Dependencies

[top of page]

FII.FII_AR_OPEN_INSTALLMENT_F does not reference any database object

FII.FII_AR_OPEN_INSTALLMENT_F is referenced by following:

APPS: FII_AR_OPEN_INSTALLMENT_F