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_OPERATIONS_SUMMARY

Object Details

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

This summary table holds Orders to Cash operations information. It holds data at the day and set of books level. Key measures are calculated from Order Management and Accounts Receivables system and populated into this table. It is used for Order to Cash portlet and related drilldown views.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AR_OPERATIONS_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_FK_KEY
FII_AR_OPERATIONS_SUM_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SET_OF_BOOKS_FK_KEY
FII_AR_OPERATIONS_SUM_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CALENDAR_DAY_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
PK_KEY	VARCHAR2	(120)		Dummy column for internal processing
OPERATING_UNIT_FK_KEY	NUMBER		Yes	Foreign key to the operating unit level of Organization dimension
SET_OF_BOOKS_FK_KEY	NUMBER		Yes	Foreign key to the Set of Books dimension
CALENDAR_DAY_FK_KEY	NUMBER		Yes	Foreign key to the day level of the time dimension
CALENDAR_DATE	DATE			Date of the transaction
FUNCTIONAL_CURRENCY	VARCHAR2	(20)		Functional currency of the given set of books
AMT_BOOKED_B	NUMBER			Total amount of booked orders in functional currency for the given day/set of books combination.
AMT_BOOKED_G	NUMBER			Total amount of booked orders in warehouse currency for the given day/set of books combination
AMT_SHIPPED_B	NUMBER			Total amount of shipped orders in functional currency
AMT_SHIPPED_G	NUMBER			Total amount of shipped orders in warehouse currency
AMT_INVOICED_OE_B	NUMBER			Total amount of orders invoiced in functional currency
AMT_INVOICED_OE_G	NUMBER			Total amount of orders invoiced in warehouse currency
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
AMT_REV_EARNED_B	NUMBER			Total amount of earned revenue. Amount is in functional currency
AMT_REV_EARNED_G	NUMBER			Total amount of earned revenue
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
AMT_FULFILLED_G	NUMBER			No longer used. Total amount of booked orders in warehouse currency for the given day/set of books combination.
AMT_FULFILLED_B	NUMBER			No longer used. Total amount of booked orders in functional currency for the given day/set of books combination.
ORDER_COUNT	NUMBER			Total number of orders 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 PK_KEY
,      OPERATING_UNIT_FK_KEY
,      SET_OF_BOOKS_FK_KEY
,      CALENDAR_DAY_FK_KEY
,      CALENDAR_DATE
,      FUNCTIONAL_CURRENCY
,      AMT_BOOKED_B
,      AMT_BOOKED_G
,      AMT_SHIPPED_B
,      AMT_SHIPPED_G
,      AMT_INVOICED_OE_B
,      AMT_INVOICED_OE_G
,      AMT_INVOICED_AR_B
,      AMT_INVOICED_AR_G
,      AMT_REV_EARNED_B
,      AMT_REV_EARNED_G
,      AMT_CASH_RECEIVED_B
,      AMT_CASH_RECEIVED_G
,      AMT_FULFILLED_G
,      AMT_FULFILLED_B
,      ORDER_COUNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM FII.FII_AR_OPERATIONS_SUMMARY;

Dependencies

[top of page]

FII.FII_AR_OPERATIONS_SUMMARY does not reference any database object

FII.FII_AR_OPERATIONS_SUMMARY is referenced by following:

APPS: FII_AR_OPERATIONS_SUMMARY