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_OPER_CUST_SUMMARY_F

Object Details

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

This summary table holds Customer Operation Information. It is used to support Order to Cash portlets.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AR_OPER_CUST_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SET_OF_BOOKS_FK_KEY
FII_AR_OPER_CUST_SUM_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_FK_KEY
FII_AR_OPER_CUST_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CUSTOMER_FK_KEY
FII_AR_OPER_CUST_SUM_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CALENDAR_DAY_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_FK_KEY	NUMBER		Yes	Foreign key to the Set of Books dimension
OPERATING_UNIT_FK_KEY	NUMBER		Yes	Foreign key to the operating unit level of Organization dimension
ORG_FK_KEY	NUMBER		Yes	Foreign key to the organization level of Organization dimension
CUSTOMER_FK_KEY	NUMBER		Yes	Foreign key to the Trading Partner dimension
CALENDAR_DAY_FK_KEY	NUMBER		Yes	Foreign key to the Time dimension
CALENDAR_DATE	DATE			Date of the transaction
FUNCTIONAL_CURRENCY	VARCHAR2	(20)		Functional currency of the given set of books
AMT_INVOICED_AR_B	NUMBER			Net invoice amounts including all the adjustments and credit memos applied to an invoice. Amount is in functional currency
AMT_INVOICED_AR_G	NUMBER			Net invoice amounts including all the adjustments and credit memos applied to an invoice. Amount is in warehouse currency
AMT_REV_EARNED_B	NUMBER			Total amount of earned revenue. Amount is in functional currency
AMT_REV_EARNED_G	NUMBER			Total amount of cash received. Amount is in warehouse currency
AMT_CASH_RECEIVED_B	NUMBER			Total amount of cash received. Amount is in functional currency
AMT_CASH_RECEIVED_G	NUMBER			Total amount of cash received. Amount is in warehouse currency
INV_CREATED_CNT	NUMBER			Total number of receivable transaction distributions created for a given day
INV_REVREC_CNT	NUMBER			Total number of revenue transaction distributions created for a given day
RECEIPT_CNT	NUMBER			Total number of receipts created for a given day
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 SET_OF_BOOKS_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      ORG_FK_KEY
,      CUSTOMER_FK_KEY
,      CALENDAR_DAY_FK_KEY
,      CALENDAR_DATE
,      FUNCTIONAL_CURRENCY
,      AMT_INVOICED_AR_B
,      AMT_INVOICED_AR_G
,      AMT_REV_EARNED_B
,      AMT_REV_EARNED_G
,      AMT_CASH_RECEIVED_B
,      AMT_CASH_RECEIVED_G
,      INV_CREATED_CNT
,      INV_REVREC_CNT
,      RECEIPT_CNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM FII.FII_AR_OPER_CUST_SUMMARY_F;

Dependencies

[top of page]

FII.FII_AR_OPER_CUST_SUMMARY_F does not reference any database object

FII.FII_AR_OPER_CUST_SUMMARY_F is referenced by following:

APPS: FII_AR_OPER_CUST_SUMMARY_F