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

TABLE: POA.POA_EDW_SUP_PERF_FSTG

Object Details
Object Name: POA_EDW_SUP_PERF_FSTG
Object Type: TABLE
Owner: POA
FND Design Data: TablePOA.POA_EDW_SUP_PERF_FSTG
Subobject Name:
Status: VALID


This is the interface table for the Supplier Performance fact. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 5
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SIC_CODE_FK_KEY NUMBER

System generated foreign key to the SIC Code dimension (Standard Industry Commodity Code)
UNSPSC_FK_KEY NUMBER

System generated foreign key to the UNSPSC dimension (UNSPSC Code)
DUNS_FK_KEY NUMBER

System generated foreign key to the DUNS dimension (D&B DUNS Code)
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

System generated user defined foreign key
USER_FK4_KEY NUMBER

System generated user defined foreign key
USER_FK3_KEY NUMBER

System generated user defined foreign key
USER_FK2_KEY NUMBER

System generated user defined foreign key
USER_FK1_KEY NUMBER

System generated user defined foreign key
TXN_CUR_CODE_FK_KEY NUMBER

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

A price, in the transactional currency, used to determine a supplier's price performance
TARGET_PRICE_G NUMBER

A price, in the warehouse currency, used to determine a supplier's price performance
SUP_SITE_GEOG_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Supplier Site Location)
SUPPLIER_SITE_FK_KEY NUMBER

System generated foreign key to theTrading Partner dimension (Supplier Site)
SUPPLIER_ITEM_FK_KEY NUMBER

System generated foreign key to the Supplier Item dimension (Supplier Item Number)
SHIP_TO_ORG_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Ship To Organization)
SHIP_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship To Location)
REQUEST_ID NUMBER

Identifier used by collection program
RELEASE_NUM NUMBER

Blanket Agreement or Planned Purchase Order release number
RCV_CLOSE_TOL NUMBER

Tolerance percentage within which a purchase order shipment can be closed for receiving
QTY_SUBS_RECEIPT_B NUMBER

Quantity received that were of a substitute item
QTY_SHIPPED_B NUMBER

Quantity shipped
QTY_REJECTED_B NUMBER

Quantity rejected (number of units that failed inspection)
QTY_RECEIVED_TOL NUMBER

Tolerance percentage of the number of units that can be received above or below the quantity ordered
QTY_RECEIVED_B NUMBER

Quantity received
QTY_PAST_DUE_B NUMBER

Quantity past-due, number of units that have not been received, that are late
QTY_ORDERED_B NUMBER

Quantity ordered
QTY_ONTIME_ONDUE_B NUMBER

Quantity received on-time, that were received exactly on the promised date
QTY_ONTIME_BEFDUE_B NUMBER

Quantity received on-time, that were received before the promised date (within the acceptable early days window)
QTY_ONTIME_AFTDUE_B NUMBER

Quantity received on-time, that were received after the promised date (within the acceptable late days window)
QTY_LATE_RECEIPT_B NUMBER

Quantity received late
QTY_EARLY_RECEIPT_B NUMBER

Quantity received early
QTY_DELIVERED_B NUMBER

Quantity delivered
QTY_CANCELLED_B NUMBER

Quantity cancelled
QTY_ACCEPTED_B NUMBER

Quantity accepted, number of units that passed inspection
PURCH_CLASS_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Purchase Classification)
PROMISED_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Promised Date)
PRICE_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Price Type)
PRICE_T NUMBER

Unit price for a purchase order line item, in the transactional currency
PRICE_G NUMBER

Unit price for a purchase order line item, in the warehouse currency
PO_LINE_TYPE_FK_KEY NUMBER

System generated foreign key to the PO Line Type dimension (Line Type)
NUM_SUBS_RECEIPT NUMBER

Number of receipt lines where the item received was a substitute item
NUM_RECEIPT_LINES NUMBER

Number of receipt lines corresponding to the PO shipment
NUM_ONTIME_ONDUE NUMBER

Number of receipt lines that were received on-time, exactly on the promised date
NUM_ONTIME_BEFDUE NUMBER

Number of receipt lines that were received on-time, before the promised date (within the acceptable early days window)
NUM_ONTIME_AFTDUE NUMBER

Number of receipt lines that were received on-time, after the promised date (within the acceptable late days window)
NUM_LATE_RECEIPT NUMBER

Number of receipt lines that were received late
NUM_EARLY_RECEIPT NUMBER

Number of receipt lines that were received early
NUM_DAYS_TO_INVOICE NUMBER

The smallest difference, in days, between the invoice date for all invoice distributions matched to the PO distribution of this PO shipment, and the creation date of the PO distribution
NEED_BY_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Need By Date)
MARKET_PRICE_T NUMBER

Market unit price in the transactional currency
MARKET_PRICE_G NUMBER

Market unit price in warehouse currency
LST_ACCPT_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Latest Acceptable Receipt Date)
LIST_PRICE_T NUMBER

List unit price in transactional currency
LIST_PRICE_G NUMBER

List unit price in warehouse currency
ITEM_FK_KEY NUMBER

System generated foreign key to the Item dimension (Item Revision)
IPV_T NUMBER

The difference in total amount, in the transactional currency, between purchase order shipment amount and its invoice, due to variance in the unit price
IPV_G NUMBER

The difference in total amount, in the warehouse currency, between purchase order shipment amount and its invoice, due to variance in the unit price
INVOICE_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Invoice Date)
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension (Instance)
FIRST_REC_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (First Receipt Date)
EDW_UOM_FK_KEY NUMBER

System generated foreign key to the Unit of Measure dimension (Transaction Unit)
EDW_BASE_UOM_FK_KEY NUMBER

System generated foreign key to the Unit of Measure dimension (Base Unit)
DAYS_LATE_REC NUMBER

Maximum acceptable number of days that a shipment can be received late, without being counted as late
DAYS_EARLY_REC NUMBER

Maximum acceptable number of days that a shipment can be received early, without being counted as early
DATE_DIM_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Dimension)
CREATION_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Creation Date)
CLOSED_CODE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Status)
BUYER_FK_KEY NUMBER

System generated foreign key to the Person dimension (Buyer)
AP_TERMS_FK_KEY NUMBER

System generated foreign key to the Payment Term dimension (Payment Term)
APPROVAL_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Approval Date)
AMT_PURCHASED_T NUMBER

Amount purchased in the transactional currency
AMT_PURCHASED_G NUMBER

Amount purchased in the warehouse currency
SIC_CODE_FK VARCHAR2 (80)
Foreign key to the SIC Code dimension (Standard Industry Commodity Code)
UNSPSC_FK VARCHAR2 (80)
Foreign key to the UNSPSC dimension (UNSPSC Code)
DUNS_FK VARCHAR2 (80)
Foreign key to the DUNS dimension (D&B DUNS Code)
USER_FK5 VARCHAR2 (2000)
User defined foreign key
USER_FK4 VARCHAR2 (2000)
User defined foreign key
USER_FK3 VARCHAR2 (2000)
User defined foreign key
USER_FK2 VARCHAR2 (2000)
User defined foreign key
USER_FK1 VARCHAR2 (2000)
User defined foreign key
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_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
TXN_CUR_CODE_FK VARCHAR2 (320)
Foreign key to the Currency dimension (Transaction Currency)
SUP_SITE_GEOG_FK VARCHAR2 (320)
Foreign key to the Geography dimension (Supplier Site Location)
SUP_PERF_PK VARCHAR2 (320)
Unique identifier
SUPPLIER_SITE_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Supplier Site)
SUPPLIER_ITEM_FK VARCHAR2 (480)
Foreign key to the Supplier Item dimension (Supplier Item Number)
SHIP_TO_ORG_FK VARCHAR2 (320)
Foreign key to the Internal Organization dimension (Ship To Organization)
SHIP_LOCATION_FK VARCHAR2 (320)
Foreign key to the Geography dimension (Ship To Location)
ROW_ID ROWID (10)
Internal row identifier
PURCH_CLASS_FK VARCHAR2 (320)
Foreign key to the Lookup dimension (Purchase Classification)
PROMISED_DATE_FK VARCHAR2 (320)
Foreign key to the Time dimension (Promised Date)
PRICE_TYPE_FK VARCHAR2 (320)
Foreign key to the Lookup dimension (Price Type)
PO_NUMBER VARCHAR2 (20)
PO Number assigned in source database
PO_LINE_TYPE_FK VARCHAR2 (320)
Foreign key to the PO Line Type dimension (Line Type)
OPERATION_CODE VARCHAR2 (30)
Code used by the loader program to determine whether to insert/update/delete this record
NEED_BY_DATE_FK VARCHAR2 (320)
Foreign key to the Time dimension (Need By Date)
LST_ACCPT_DATE_FK VARCHAR2 (320)
Foreign key to the Time dimension (Latest Acceptable Receipt Date)
ITEM_FK VARCHAR2 (320)
Foreign key to the Item dimension (Item Revision)
INVOICE_DATE_FK VARCHAR2 (320)
Foreign key to the Time dimension (Invoice Date)
INSTANCE_FK VARCHAR2 (320)
Foreign key to the Instance dimension (Instance)
FIRST_REC_DATE_FK VARCHAR2 (320)
System generated foreign key to the Time dimension (First Receipt Date)
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
EDW_UOM_FK VARCHAR2 (320)
Foreign key to the Unit of Measure dimension (Transaction Unit)
EDW_BASE_UOM_FK VARCHAR2 (320)
Foreign key to the Unit of Measure dimension (Base Unit)
DATE_DIM_FK VARCHAR2 (320)
Foreign key to the Time dimension (Date Dimension)
CREATION_DATE_FK VARCHAR2 (320)
Foreign key to the Time dimension (Creation Date)
CONTRACT_NUM VARCHAR2 (25)
PO Number assigned in source database for Blanket Agreements
COLLECTION_STATUS VARCHAR2 (30)
Loading status code for the record (It refers to the status after the Load Engine attempts to move the record from the staging table to the fact table. It does not refer to the movement of the data from the source to the staging table)
CLOSED_CODE_FK VARCHAR2 (320)
Foreign key to the Lookup dimension (Starus)
BUYER_FK VARCHAR2 (320)
Foreign key to the Person dimension (Buyer)
AP_TERMS_FK VARCHAR2 (320)
Foreign key to the Payment Term dimension (Payment Term)
APPROVAL_DATE_FK VARCHAR2 (320)
System generated foreign key to the Time dimension (Approval Date)
Query Text

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


SELECT SIC_CODE_FK_KEY
,      UNSPSC_FK_KEY
,      DUNS_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
,      TXN_CUR_CODE_FK_KEY
,      TARGET_PRICE_T
,      TARGET_PRICE_G
,      SUP_SITE_GEOG_FK_KEY
,      SUPPLIER_SITE_FK_KEY
,      SUPPLIER_ITEM_FK_KEY
,      SHIP_TO_ORG_FK_KEY
,      SHIP_LOCATION_FK_KEY
,      REQUEST_ID
,      RELEASE_NUM
,      RCV_CLOSE_TOL
,      QTY_SUBS_RECEIPT_B
,      QTY_SHIPPED_B
,      QTY_REJECTED_B
,      QTY_RECEIVED_TOL
,      QTY_RECEIVED_B
,      QTY_PAST_DUE_B
,      QTY_ORDERED_B
,      QTY_ONTIME_ONDUE_B
,      QTY_ONTIME_BEFDUE_B
,      QTY_ONTIME_AFTDUE_B
,      QTY_LATE_RECEIPT_B
,      QTY_EARLY_RECEIPT_B
,      QTY_DELIVERED_B
,      QTY_CANCELLED_B
,      QTY_ACCEPTED_B
,      PURCH_CLASS_FK_KEY
,      PROMISED_DATE_FK_KEY
,      PRICE_TYPE_FK_KEY
,      PRICE_T
,      PRICE_G
,      PO_LINE_TYPE_FK_KEY
,      NUM_SUBS_RECEIPT
,      NUM_RECEIPT_LINES
,      NUM_ONTIME_ONDUE
,      NUM_ONTIME_BEFDUE
,      NUM_ONTIME_AFTDUE
,      NUM_LATE_RECEIPT
,      NUM_EARLY_RECEIPT
,      NUM_DAYS_TO_INVOICE
,      NEED_BY_DATE_FK_KEY
,      MARKET_PRICE_T
,      MARKET_PRICE_G
,      LST_ACCPT_DATE_FK_KEY
,      LIST_PRICE_T
,      LIST_PRICE_G
,      ITEM_FK_KEY
,      IPV_T
,      IPV_G
,      INVOICE_DATE_FK_KEY
,      INSTANCE_FK_KEY
,      FIRST_REC_DATE_FK_KEY
,      EDW_UOM_FK_KEY
,      EDW_BASE_UOM_FK_KEY
,      DAYS_LATE_REC
,      DAYS_EARLY_REC
,      DATE_DIM_FK_KEY
,      CREATION_DATE_FK_KEY
,      CLOSED_CODE_FK_KEY
,      BUYER_FK_KEY
,      AP_TERMS_FK_KEY
,      APPROVAL_DATE_FK_KEY
,      AMT_PURCHASED_T
,      AMT_PURCHASED_G
,      SIC_CODE_FK
,      UNSPSC_FK
,      DUNS_FK
,      USER_FK5
,      USER_FK4
,      USER_FK3
,      USER_FK2
,      USER_FK1
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      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
,      TXN_CUR_CODE_FK
,      SUP_SITE_GEOG_FK
,      SUP_PERF_PK
,      SUPPLIER_SITE_FK
,      SUPPLIER_ITEM_FK
,      SHIP_TO_ORG_FK
,      SHIP_LOCATION_FK
,      ROW_ID
,      PURCH_CLASS_FK
,      PROMISED_DATE_FK
,      PRICE_TYPE_FK
,      PO_NUMBER
,      PO_LINE_TYPE_FK
,      OPERATION_CODE
,      NEED_BY_DATE_FK
,      LST_ACCPT_DATE_FK
,      ITEM_FK
,      INVOICE_DATE_FK
,      INSTANCE_FK
,      FIRST_REC_DATE_FK
,      ERROR_CODE
,      EDW_UOM_FK
,      EDW_BASE_UOM_FK
,      DATE_DIM_FK
,      CREATION_DATE_FK
,      CONTRACT_NUM
,      COLLECTION_STATUS
,      CLOSED_CODE_FK
,      BUYER_FK
,      AP_TERMS_FK
,      APPROVAL_DATE_FK
FROM POA.POA_EDW_SUP_PERF_FSTG;

Dependencies

[top of page]

POA.POA_EDW_SUP_PERF_FSTG does not reference any database object

POA.POA_EDW_SUP_PERF_FSTG is referenced by following:

SchemaAPPS
SynonymPOA_EDW_SUP_PERF_FSTG