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_FSTG

Object Details

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

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

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FUNCTIONAL_CURRENCY_FK	VARCHAR2	(10)		Foreign key to the currency dimension
SET_OF_BOOKS_FK	VARCHAR2	(80)		Foreign key to the Set of Books dimension
ORG_FK	VARCHAR2	(120)		Foreign key to the Organization dimension
CUSTOMER_FK	VARCHAR2	(85)		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
INVOICE_NUMBER	VARCHAR2	(30)		Invoice number of the invoice installment
INSTALLMENT_NUMBER	NUMBER			Installment number of this installment
RECEIPT_NUMBER	VARCHAR2	(30)		Cash receipt number
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
DISPUTE_DATE	DATE			Dispute date
DEPOSIT_DATE	DATE			Deposit date
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.

Query Text

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


SELECT FUNCTIONAL_CURRENCY_FK
,      SET_OF_BOOKS_FK
,      ORG_FK
,      CUSTOMER_FK
,      RECEIVABLE_G
,      RECEIVABLE_B
,      RECEIVABLE_T
,      UNAPP_RECEIPT_G
,      UNAPP_RECEIPT_B
,      UNAPP_RECEIPT_T
,      FUNCTIONAL_CURRENCY
,      INVOICE_CURRENCY
,      INVOICE_NUMBER
,      INSTALLMENT_NUMBER
,      RECEIPT_NUMBER
,      INVOICE_DATE
,      DUE_DATE
,      DATE_OF_SNAPSHOT
,      DISPUTE_DATE
,      DEPOSIT_DATE
,      TYPE
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM FII.FII_AR_OPEN_INSTALLMENT_FSTG;

Dependencies

[top of page]

FII.FII_AR_OPEN_INSTALLMENT_FSTG does not reference any database object

FII.FII_AR_OPEN_INSTALLMENT_FSTG is referenced by following:

APPS: FII_AR_OPEN_INSTALLMENT_FSTG