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: OPI.OPI_EDW_MARGIN_F

Object Details

Object Name:	OPI_EDW_MARGIN_F
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_EDW_MARGIN_F
Subobject Name:
Status:	VALID

This is the Gross Margin fact table, and is derived from the Consolidated Revenue and COGS facts.
It contains the product sales revenue and the matching cost of good sold by period.
Quantities shipped, returned, invoiced, credited are available.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_EDW_MARGIN_F_U	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORDER_LINE_ID ITEM_ORG_FK_KEY SHIP_LOCATION_FK_KEY CUSTOMER_FK_KEY MARGIN_DATE_FK_KEY COGS_DATE_FK_KEY REVENUE_DATE_FK_KEY GL_PERIOD_FK_KEY PRIM_SALES_REP_FK_KEY SHIP_TO_LOC_FK_KEY BILL_TO_LOC_FK_KEY OPERATING_UNIT_FK_KEY SALES_CHANNEL_FK_KEY PROJECT_FK_KEY BASE_CURRENCY_FK_KEY UOM_FK_KEY SOB_FK_KEY INSTANCE_FK_KEY USER_FK5_KEY USER_FK4_KEY USER_FK3_KEY USER_FK2_KEY USER_FK1_KEY
OPI_EDW_MARGIN_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BASE_CURRENCY_FK_KEY
OPI_EDW_MARGIN_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SALES_CHANNEL_FK_KEY
OPI_EDW_MARGIN_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SHIP_LOCATION_FK_KEY
OPI_EDW_MARGIN_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SHIP_TO_LOC_FK_KEY
OPI_EDW_MARGIN_F_N13	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SOB_FK_KEY
OPI_EDW_MARGIN_F_N14	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	UOM_FK_KEY
OPI_EDW_MARGIN_F_N15	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	REVENUE_DATE_FK_KEY
OPI_EDW_MARGIN_F_N16	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	COGS_DATE_FK_KEY
OPI_EDW_MARGIN_F_N17	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_PERIOD_FK_KEY
OPI_EDW_MARGIN_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BILL_TO_LOC_FK_KEY
OPI_EDW_MARGIN_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CUSTOMER_FK_KEY
OPI_EDW_MARGIN_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
OPI_EDW_MARGIN_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ITEM_ORG_FK_KEY
OPI_EDW_MARGIN_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MARGIN_DATE_FK_KEY
OPI_EDW_MARGIN_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_FK_KEY
OPI_EDW_MARGIN_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PRIM_SALES_REP_FK_KEY
OPI_EDW_MARGIN_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PROJECT_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
SOB_FK_KEY	NUMBER			System generated foreign key to the Set of Books dimemsion (GL set of book used to identify currency)
USER_FK5_KEY	NUMBER			User defined foreign key
USER_FK4_KEY	NUMBER			User defined foreign key
USER_FK3_KEY	NUMBER			User defined foreign key
USER_FK2_KEY	NUMBER			User defined foreign key
USER_FK1_KEY	NUMBER			User defined foreign key
USER_MEASURE5	NUMBER			User defined measure
USER_MEASURE4	NUMBER			User defined measure
USER_MEASURE3	NUMBER			User defined measure
USER_MEASURE2	NUMBER			User defined measure
USER_MEASURE1	NUMBER			User defined measure
ICAP_QTY	NUMBER			Quantity from Intercompany Account Payable invoices in Base UOM
RMA_QTY	NUMBER			Quantity returned by customer in Base UOM
SHIPPED_QTY	NUMBER			Quantity shipped to customer in Base UOM
PROD_LINE_QTY_CREDITED	NUMBER			Product quantity credited to customer in Base UOM
PROD_LINE_QTY_INVOICED	NUMBER			Product quantity invoiced in Base UOM
PROD_AMT_B	NUMBER			Product sales revenue in functional currency
PROD_AMT_G	NUMBER			Product sales revenue in Warehouse currency
COGS_B	NUMBER			Cost of sales in functional currency
COGS_G	NUMBER			Cost of sales in Warehouse currency
UOM_FK_KEY	NUMBER			System generated foreign key to the UOM dimemsion (unit of measurement)
PROJECT_FK_KEY	NUMBER			system generated foreign key to the Projects dimemsion
GL_PERIOD_FK_KEY	NUMBER			System generated foreign key to the Time dimemsion (accounting period).
SHIP_TO_LOC_FK_KEY	NUMBER			System generated foreign key to the Geography dimemsion (ship to location)
BILL_TO_LOC_FK_KEY	NUMBER			System generated foreign key to the Geography dimemsion (bill to location)
PRIM_SALES_REP_FK_KEY	NUMBER			System generated foreign key to the HR Person dimemsion (primary sales representative)
INSTANCE_FK_KEY	NUMBER			System generated foreign key to the Instance dimemsion
SALES_CHANNEL_FK_KEY	NUMBER			System generated foreign key to the Sales Channel dimemsion
CUSTOMER_FK_KEY	NUMBER			System generated foreign key to the Trading Partner dimemsion
OPERATING_UNIT_FK_KEY	NUMBER			System generated foreign key to the Internal Org dimemsion
ITEM_ORG_FK_KEY	NUMBER			System generated foreign key to the Item dimemsion
USER_ATTRIBUTE15	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE14	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE13	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE12	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE11	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE10	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE9	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE8	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE7	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE6	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE5	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE4	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE3	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE2	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE1	VARCHAR2	(240)		User defined attribute
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
MARGIN_PK	VARCHAR2	(240)		Margin PK
BASE_CURRENCY_FK_KEY	NUMBER			System generated foreign key to the Currency dimension Using Functional currency.
COGS_DATE_FK_KEY	NUMBER			System generated foreign key to the Time dimemsion Using Ship Date.
INVOICE_DATE	DATE			Invoice Date
MARGIN_DATE_FK_KEY	NUMBER			System generated foreign key to the Time dimension Using Greater of Ship Date and Invoiced date.
ORDER_DATE	DATE			Sales order date
ORDER_LINE_ID	VARCHAR2	(80)		Sales order line id
ORDER_NO	VARCHAR2	(80)		Sales order number
REVENUE_DATE_FK_KEY	NUMBER			System generated foreign key to the Time dimension Using Greater of Invoiced date.
SHIP_DATE	DATE			Sales order shipped date
SHIP_LOCATION_FK_KEY	NUMBER			System generated foreign key to the Inventory Locator Dimension
UNIT_SELLING_PRICE	NUMBER			Unit Selling Price
PRIM_SALESRESOURCE_FK_KEY	NUMBER			System generated foreign key to the Sales Resource dimension (Primary Sales Rep)

Query Text

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


SELECT SOB_FK_KEY
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      ICAP_QTY
,      RMA_QTY
,      SHIPPED_QTY
,      PROD_LINE_QTY_CREDITED
,      PROD_LINE_QTY_INVOICED
,      PROD_AMT_B
,      PROD_AMT_G
,      COGS_B
,      COGS_G
,      UOM_FK_KEY
,      PROJECT_FK_KEY
,      GL_PERIOD_FK_KEY
,      SHIP_TO_LOC_FK_KEY
,      BILL_TO_LOC_FK_KEY
,      PRIM_SALES_REP_FK_KEY
,      INSTANCE_FK_KEY
,      SALES_CHANNEL_FK_KEY
,      CUSTOMER_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      ITEM_ORG_FK_KEY
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE1
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      MARGIN_PK
,      BASE_CURRENCY_FK_KEY
,      COGS_DATE_FK_KEY
,      INVOICE_DATE
,      MARGIN_DATE_FK_KEY
,      ORDER_DATE
,      ORDER_LINE_ID
,      ORDER_NO
,      REVENUE_DATE_FK_KEY
,      SHIP_DATE
,      SHIP_LOCATION_FK_KEY
,      UNIT_SELLING_PRICE
,      PRIM_SALESRESOURCE_FK_KEY
FROM OPI.OPI_EDW_MARGIN_F;

Dependencies

[top of page]

OPI.OPI_EDW_MARGIN_F does not reference any database object

OPI.OPI_EDW_MARGIN_F is referenced by following:

APPS: OPI_EDW_MARGIN_F