DBA Data[Home] [Help] [Dependency Information]

TABLE: OPI.OPI_EDW_COGS_FSTG

Object Details
Object Name: OPI_EDW_COGS_FSTG
Object Type: TABLE
Owner: OPI
FND Design Data: TableOPI.OPI_EDW_COGS_FSTG
Subobject Name:
Status: VALID


This is the interface table for COGS Shipment Fact. Data from multiple transactional systems is staged here for verification and cleansing before being loaded into the fact table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OPI_EDW_COGS_FSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
ColumnCOGS_PK
Columns
Name Datatype Length Mandatory Comments
MEDCHN_ACTL_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Actual)
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to the market segment dimension (Market Segment Offer)
LOCATOR_FK_KEY NUMBER

System generated foreign key to the invetory location dimension (Locator)
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the item dimension (Item of an organization)
INV_ORG_FK_KEY NUMBER

System generated foreign key to the internal organization dimension (Inventory Organization)
INSTANCE_FK_KEY NUMBER

System generated foreign key to the instance dimension (source instance)
ICAP_QTY_B NUMBER

Intercompany Account Payable Invoiced Quantity in Base UOM
DATE_SHIPPED_FK_KEY NUMBER

System generated foreign key to the time dimension (Date Shipped)
DATE_SCHEDULED_FK_KEY NUMBER

System generated foreign key to the time dimension (Date Scheduled)
DATE_REQUESTED_FK_KEY NUMBER

System generated foreign key to the time dimension (Date Requested)
DATE_PROMISED_FK_KEY NUMBER

System generated foreign key to the time dimension (Date Promised)
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the time dimension (Date Booked)
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
USER_FK5_KEY NUMBER

User defined dimension foreign key
USER_FK4_KEY NUMBER

User defined dimension foreign key
USER_FK3_KEY NUMBER

User defined dimension foreign key
USER_FK2_KEY NUMBER

User defined dimension foreign key
USER_FK1_KEY NUMBER

User defined dimension foreign key
PROM_EARLY_VAL_G NUMBER

COGS value with shipped date no later than promised date
PROM_EARLY_COUNT NUMBER

Number of order lines with shipped date no later than promised date
PROMISE_LEAD_TIME NUMBER

Days between Date Shipped and Date Promised
PROJECT_FK_KEY NUMBER

System generated foreign key to the project dimension (Project)
PRIM_SALES_REP_FK_KEY NUMBER

System generated foreign key to the HR Person dimension (Primary Sales Rep)
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the lookup dimension (Order Type)
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the lookup dimension (Order Source)
ORDER_NUMBER NUMBER

User Visible Order Identifier
ORDER_LEAD_TIME NUMBER

Days between Date Shipped and Date Booked
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the lookup dimension (Order Category)
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the internal organization dimension (Operating Unit)
OFFER_LINE_FK_KEY NUMBER

System generated foreign key to the Offer dimension (Line Level Offer)
OFFER_HDR_FK_KEY NUMBER

System generated foreign key to the Offer dimension (Header Level Offer)
MONTH_BOOKED_FK_KEY NUMBER

System generated foreign key to the time dimension (Month Booked)
MEDCHN_INIT_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Attributed)
SHIP_TO_SITE_FK_KEY NUMBER

System generated foreign key to the trading partner dimension (Ship To Site)
SHIP_TO_LOC_FK_KEY NUMBER

System generated foreign key to the geography dimension (Ship To Location)
SHIPPED_QTY_B NUMBER

Shipped Quantity in Base UOM
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Books)
SALES_CHANNEL_FK_KEY NUMBER

System generated foreign key to the sales channel dimension (Sales Channel)
RMA_VAL_T NUMBER

RMA value in Transaction currency
RMA_VAL_G NUMBER

RMA value in warehouse currency
RMA_QTY_B NUMBER

RMA Quantity in Base UOM
REQ_LATE_VAL_G NUMBER

COGS value with shipped date later than requested date
REQ_LATE_COUNT NUMBER

Number of order lines with shipped date later than requested date
REQ_EARLY_VAL_G NUMBER

COGS value with shipped date no later than requested date
REQ_EARLY_COUNT NUMBER

Number of order lines with shipped date no later than requested date
REQUEST_LEAD_TIME NUMBER

Days between Date Shipped and Date Requested
REQUEST_ID NUMBER

Identifier used by collection program
PROM_LATE_VAL_G NUMBER

COGS value with shipped date later than promised date
PROM_LATE_COUNT NUMBER

Number of order lines with shipped date later than promised date
TRX_CURRENCY_FK_KEY NUMBER

System generated foreign key to the currency dimension (Transaction Currency)
TOP_MODEL_ITEM_FK_KEY NUMBER

System generated foreign key to the item dimension (Top Model Item)
TASK_FK_KEY NUMBER

System generated foreign key to the project dimension (Task)
TARGET_SEGMENT_INIT_FK_KEY NUMBER

System generated foreign key to the target segment dimension (Target Segment Attributed)
TARGET_SEGMENT_ACTL_FK_KEY NUMBER

System generated foreign key to the target segment dimension (Target Segment Actual)
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the trading partner dimension (Customer)
COST_ELEMENT NUMBER

Cost element identifier
COGS_T NUMBER

Cost of Good Sold in Transaction currency
COGS_G NUMBER

Cost of Good Sold in warehouse currency
COGS_B NUMBER

Cost of Good Sold in set of books currency
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign dimension (Campaign Attributed)
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign dimension (Campaign Actual)
BILL_TO_SITE_FK_KEY NUMBER

System generated foreign key to the trading partner dimension (Bill To Site)
BILL_TO_LOC_FK_KEY NUMBER

System generated foreign key to the geography dimension (Bill To Location)
BASE_UOM_FK_KEY NUMBER

System generated foreign key to the UOM dimension (Base UOM)
BASE_CURRENCY_FK_KEY NUMBER

System generated foreign key to the currency dimension (Base Currency)
ACCOUNT NUMBER

Account Identifier
MEDCHN_INIT_FK VARCHAR2 (320)
Foreign key to the Media Channel dimension level
MEDCHN_ACTL_FK VARCHAR2 (320)
Foreign key to the Media Channel dimension level
MARKET_SEGMENT_FK VARCHAR2 (240)
Foreign key to the market segment dimension level
LOT VARCHAR2 (40)
Item lot number
LOCATOR_FK VARCHAR2 (240)
Foreign key to the invetory location dimension level
ITEM_ORG_FK VARCHAR2 (320)
Foreign key to the item Org dimension level
INV_ORG_FK VARCHAR2 (320)
Foreign key to the internal organization dimension level
INSTANCE_FK VARCHAR2 (40)
Foreign key to the instance dimension level
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
DATE_SHIPPED_FK VARCHAR2 (120)
Foreign key to the calendar day time dimension level
DATE_SCHEDULED_FK VARCHAR2 (120)
Foreign key to the calendar day time dimension level
DATE_REQUESTED_FK VARCHAR2 (120)
Foreign key to the calendar day time dimension level
DATE_PROMISED_FK VARCHAR2 (120)
Foreign key to the calendar day time dimension level
WAYBILL_NUMBER VARCHAR2 (40)
Waybill number
USER_FK5 VARCHAR2 (2000)
Foreign key to user defined dimension level
USER_FK4 VARCHAR2 (2000)
Foreign key to user defined dimension level
USER_FK3 VARCHAR2 (2000)
Foreign key to user defined dimension level
USER_FK2 VARCHAR2 (2000)
Foreign key to user defined dimension level
USER_FK1 VARCHAR2 (2000)
Foreign key to user defined dimension level
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
PROJECT_FK VARCHAR2 (80)
Foreign key to the project dimension level
PRIM_SALES_REP_FK VARCHAR2 (1000)
Foreign key to the HR Person dimension Assignment level
ORDER_TYPE_FK VARCHAR2 (80)
Foreign key to the lookup dimension level
ORDER_SOURCE_FK VARCHAR2 (80)
Foreign key to the lookup dimension level
ORDER_CATEGORY_FK VARCHAR2 (80)
Foreign key to the lookup dimension level
OPERATION_CODE VARCHAR2 (30)
Code used by the collection program to determine whether to insert/update/delete this record
OPERATING_UNIT_FK VARCHAR2 (240)
Foreign key to the internal organization dimension level
OFFER_LINE_FK VARCHAR2 (320)
Foreign key to the Offer dimension level
OFFER_HDR_FK VARCHAR2 (320)
Foreign key to the Offer dimension level
MONTH_BOOKED_FK VARCHAR2 (120)
Foreign key to the time dimension level
SHIP_TO_SITE_FK VARCHAR2 (320)
Foreign key to the trading partner dimension location level
SHIP_TO_LOC_FK VARCHAR2 (240)
Foreign key to the geography dimension location level
SET_OF_BOOKS_FK VARCHAR2 (240)
Foreign key to the Set of Books dimension GL Set of Books level
SERIAL_NUMBER VARCHAR2 (40)
Serial number
SALES_CHANNEL_FK VARCHAR2 (240)
Foreign key to the sales channel dimension level
ROW_ID ROWID (10)
Row Id
REVISION VARCHAR2 (40)
Item revision number
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_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_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
TRX_CURRENCY_FK VARCHAR2 (20)
Foreign key to the currency dimension level
TOP_MODEL_ITEM_FK VARCHAR2 (320)
Foreign key to the item org dimension level
TASK_FK VARCHAR2 (120)
Foreign key to the task level of project dimension
TARGET_SEGMENT_INIT_FK VARCHAR2 (120)
Foreign key to the target segment dimension level
TARGET_SEGMENT_ACTL_FK VARCHAR2 (120)
Foreign key to the target segment dimension level
DATE_BOOKED_FK VARCHAR2 (120)
Foreign key to the calendar day time dimension level
CUSTOMER_FK VARCHAR2 (320)
Foreign key to the trading partner dimension location level
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
COGS_PK VARCHAR2 (120)
Unique Identifier
CAMPAIGN_INIT_FK VARCHAR2 (320)
Foreign key to the Campaign dimension level
CAMPAIGN_ACTL_FK VARCHAR2 (320)
Foreign key to the Campaign dimension level
BILL_TO_SITE_FK VARCHAR2 (320)
Foreign key to the trading partner dimension location level
BILL_TO_LOC_FK VARCHAR2 (240)
Foreign key to the geography dimension location level
BASE_UOM_FK VARCHAR2 (80)
Foreign key to the UOM dimension level
BASE_CURRENCY_FK VARCHAR2 (20)
Foreign key to the currency dimension level
CAMPAIGN_STATUS_ACTL_FK VARCHAR2 (240)
Foreign key to Campaign Status dimension
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to Campaign Status dimension (actual status)
CAMPAIGN_STATUS_INIT_FK VARCHAR2 (240)
Foreign key to Campaign Status Dimension (initial status)
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (initial status)
COGS_DATE DATE

COGS recognition date
COGS_DATE_FK VARCHAR2 (120)
Foreign key to the Time Dimension
COGS_DATE_FK_KEY NUMBER

System generated foreign key to the Time Dimension
ORDER_LINE_ID VARCHAR2 (80)
Foreign key to the EDW_NA dimension
SHIP_INV_LOCATOR_FK VARCHAR2 (80)
Foreign key to Inventory Location dimension
SHIP_INV_LOCATOR_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension
ORDER_DATE DATE

ordered date
CREATION_DATE DATE

Row Who Column
LAST_UPDATE_DATE DATE

Row Who Column
DELIVERY_ID NUMBER

Delivery Id
PRIM_SALESRESOURCE_FK VARCHAR2 (240)
Foreign key to the Sales Resource dimension (Primary Sales Rep)
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 MEDCHN_ACTL_FK_KEY
,      MARKET_SEGMENT_FK_KEY
,      LOCATOR_FK_KEY
,      ITEM_ORG_FK_KEY
,      INV_ORG_FK_KEY
,      INSTANCE_FK_KEY
,      ICAP_QTY_B
,      DATE_SHIPPED_FK_KEY
,      DATE_SCHEDULED_FK_KEY
,      DATE_REQUESTED_FK_KEY
,      DATE_PROMISED_FK_KEY
,      DATE_BOOKED_FK_KEY
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      PROM_EARLY_VAL_G
,      PROM_EARLY_COUNT
,      PROMISE_LEAD_TIME
,      PROJECT_FK_KEY
,      PRIM_SALES_REP_FK_KEY
,      ORDER_TYPE_FK_KEY
,      ORDER_SOURCE_FK_KEY
,      ORDER_NUMBER
,      ORDER_LEAD_TIME
,      ORDER_CATEGORY_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      OFFER_LINE_FK_KEY
,      OFFER_HDR_FK_KEY
,      MONTH_BOOKED_FK_KEY
,      MEDCHN_INIT_FK_KEY
,      SHIP_TO_SITE_FK_KEY
,      SHIP_TO_LOC_FK_KEY
,      SHIPPED_QTY_B
,      SET_OF_BOOKS_FK_KEY
,      SALES_CHANNEL_FK_KEY
,      RMA_VAL_T
,      RMA_VAL_G
,      RMA_QTY_B
,      REQ_LATE_VAL_G
,      REQ_LATE_COUNT
,      REQ_EARLY_VAL_G
,      REQ_EARLY_COUNT
,      REQUEST_LEAD_TIME
,      REQUEST_ID
,      PROM_LATE_VAL_G
,      PROM_LATE_COUNT
,      TRX_CURRENCY_FK_KEY
,      TOP_MODEL_ITEM_FK_KEY
,      TASK_FK_KEY
,      TARGET_SEGMENT_INIT_FK_KEY
,      TARGET_SEGMENT_ACTL_FK_KEY
,      CUSTOMER_FK_KEY
,      COST_ELEMENT
,      COGS_T
,      COGS_G
,      COGS_B
,      CAMPAIGN_INIT_FK_KEY
,      CAMPAIGN_ACTL_FK_KEY
,      BILL_TO_SITE_FK_KEY
,      BILL_TO_LOC_FK_KEY
,      BASE_UOM_FK_KEY
,      BASE_CURRENCY_FK_KEY
,      ACCOUNT
,      MEDCHN_INIT_FK
,      MEDCHN_ACTL_FK
,      MARKET_SEGMENT_FK
,      LOT
,      LOCATOR_FK
,      ITEM_ORG_FK
,      INV_ORG_FK
,      INSTANCE_FK
,      ERROR_CODE
,      DATE_SHIPPED_FK
,      DATE_SCHEDULED_FK
,      DATE_REQUESTED_FK
,      DATE_PROMISED_FK
,      WAYBILL_NUMBER
,      USER_FK5
,      USER_FK4
,      USER_FK3
,      USER_FK2
,      USER_FK1
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      PROJECT_FK
,      PRIM_SALES_REP_FK
,      ORDER_TYPE_FK
,      ORDER_SOURCE_FK
,      ORDER_CATEGORY_FK
,      OPERATION_CODE
,      OPERATING_UNIT_FK
,      OFFER_LINE_FK
,      OFFER_HDR_FK
,      MONTH_BOOKED_FK
,      SHIP_TO_SITE_FK
,      SHIP_TO_LOC_FK
,      SET_OF_BOOKS_FK
,      SERIAL_NUMBER
,      SALES_CHANNEL_FK
,      ROW_ID
,      REVISION
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE1
,      TRX_CURRENCY_FK
,      TOP_MODEL_ITEM_FK
,      TASK_FK
,      TARGET_SEGMENT_INIT_FK
,      TARGET_SEGMENT_ACTL_FK
,      DATE_BOOKED_FK
,      CUSTOMER_FK
,      COLLECTION_STATUS
,      COGS_PK
,      CAMPAIGN_INIT_FK
,      CAMPAIGN_ACTL_FK
,      BILL_TO_SITE_FK
,      BILL_TO_LOC_FK
,      BASE_UOM_FK
,      BASE_CURRENCY_FK
,      CAMPAIGN_STATUS_ACTL_FK
,      CAMPAIGN_STATUS_ACTL_FK_KEY
,      CAMPAIGN_STATUS_INIT_FK
,      CAMPAIGN_STATUS_INIT_FK_KEY
,      COGS_DATE
,      COGS_DATE_FK
,      COGS_DATE_FK_KEY
,      ORDER_LINE_ID
,      SHIP_INV_LOCATOR_FK
,      SHIP_INV_LOCATOR_FK_KEY
,      ORDER_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELIVERY_ID
,      PRIM_SALESRESOURCE_FK
,      PRIM_SALESRESOURCE_FK_KEY
FROM OPI.OPI_EDW_COGS_FSTG;

Dependencies

[top of page]

OPI.OPI_EDW_COGS_FSTG does not reference any database object

OPI.OPI_EDW_COGS_FSTG is referenced by following:

SchemaAPPS
SynonymOPI_EDW_COGS_FSTG