[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_SUP_PERF_F |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.POA_EDW_SUP_PERF_F |
Subobject Name: | |
Status: | VALID |
The Supplier Performance fact contains data for approved purchase orders and releases. For Oracle Applications users, this includes standard purchase orders, releases against blanket agreements, and scheduled releases against planned purchase orders.
The data is stored at the purchase order shipment level. For each purchase order shipment, data for corresponding quotations, receipts and invoices is also considered. This fact is useful for analyzing supplier performance in the area of price, quality, and delivery.
Some of the measures available in this fact table include the following: Price, Market Price, List Price, Target Price, Invoice Price Variance, Purchases, Quantity Ordered, Quantity Received, Quantity Delivered, Quantity Past Due, Quantity Received Late, Quantity Received Early, Quantity Accepted, Quantity Rejected, Quantity Cancelled, Substitute Receipt Quantity, Quantity Shipped, Number of Late Receipt Lines, Number of Early Receipt Lines, Number of Days to Invoice, Number of Receipt Lines, and Number of Substitute Receipt Lines.
The data in this fact table can be aggregated by the following dimensions: Time, Item, Trading Partner, Person, Geography, Internal Organization, PO Line Type, Unit of Measure, Supplier Item, Instance, Payment Term, Currency.
All quantities are expressed in the warehouse base unit of measure. Amounts are expressed in either the warehouse currency or transactional currency.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
POA_EDW_SUP_PERF_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | SUP_PERF_PK |
POA_EDW_SUP_PERF_F_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_CUR_CODE_FK_KEY |
POA_EDW_SUP_PERF_F_N10 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_TO_ORG_FK_KEY |
POA_EDW_SUP_PERF_F_N11 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BUYER_FK_KEY |
POA_EDW_SUP_PERF_F_N12 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | AP_TERMS_FK_KEY |
POA_EDW_SUP_PERF_F_N13 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_ITEM_FK_KEY |
POA_EDW_SUP_PERF_F_N14 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CREATION_DATE_FK_KEY |
POA_EDW_SUP_PERF_F_N15 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DATE_DIM_FK_KEY |
POA_EDW_SUP_PERF_F_N16 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FIRST_REC_DATE_FK_KEY |
POA_EDW_SUP_PERF_F_N17 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | NEED_BY_DATE_FK_KEY |
POA_EDW_SUP_PERF_F_N18 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PROMISED_DATE_FK_KEY |
POA_EDW_SUP_PERF_F_N19 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVAL_DATE_FK_KEY |
POA_EDW_SUP_PERF_F_N2 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUP_SITE_GEOG_FK_KEY |
POA_EDW_SUP_PERF_F_N20 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | LST_ACCPT_DATE_FK_KEY |
POA_EDW_SUP_PERF_F_N21 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INVOICE_DATE_FK_KEY |
POA_EDW_SUP_PERF_F_N22 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_SITE_FK_KEY |
POA_EDW_SUP_PERF_F_N23 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | EDW_BASE_UOM_FK_KEY |
POA_EDW_SUP_PERF_F_N24 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | EDW_UOM_FK_KEY |
POA_EDW_SUP_PERF_F_N25 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DUNS_FK_KEY |
POA_EDW_SUP_PERF_F_N26 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | UNSPSC_FK_KEY |
POA_EDW_SUP_PERF_F_N27 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SIC_CODE_FK_KEY |
POA_EDW_SUP_PERF_F_N3 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_LOCATION_FK_KEY |
POA_EDW_SUP_PERF_F_N4 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSTANCE_FK_KEY |
POA_EDW_SUP_PERF_F_N5 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ITEM_FK_KEY |
POA_EDW_SUP_PERF_F_N6 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CLOSED_CODE_FK_KEY |
POA_EDW_SUP_PERF_F_N7 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PRICE_TYPE_FK_KEY |
POA_EDW_SUP_PERF_F_N8 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PURCH_CLASS_FK_KEY |
POA_EDW_SUP_PERF_F_N9 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_LINE_TYPE_FK_KEY |
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) | ||
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) | ||
SUPPLIER_SITE_FK_KEY | NUMBER | System generated foreign key to theTrading Partner dimension (Supplier Site) | ||
INVOICE_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Invoice Date) | ||
LST_ACCPT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Latest Acceptable Receipt Date) | ||
APPROVAL_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Approval Date) | ||
PROMISED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Promised Date) | ||
NEED_BY_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Need By Date) | ||
FIRST_REC_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (First Receipt Date) | ||
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) | ||
SUPPLIER_ITEM_FK_KEY | NUMBER | System generated foreign key to the Supplier Item dimension (Supplier Item Number) | ||
AP_TERMS_FK_KEY | NUMBER | System generated foreign key to the Payment Term dimension (Payment Term) | ||
BUYER_FK_KEY | NUMBER | System generated foreign key to the Person dimension (Buyer) | ||
SHIP_TO_ORG_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Ship To Organization) | ||
PO_LINE_TYPE_FK_KEY | NUMBER | System generated foreign key to the PO Line Type dimension (Line Type) | ||
PURCH_CLASS_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Purchase Classification) | ||
PRICE_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Price Type) | ||
CLOSED_CODE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Status) | ||
ITEM_FK_KEY | NUMBER | System generated foreign key to the Item dimension (Item Revision) | ||
INSTANCE_FK_KEY | NUMBER | System generated foreign key to the Instance dimension (Instance) | ||
SHIP_LOCATION_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Ship To Location) | ||
SUP_SITE_GEOG_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Supplier Site Location) | ||
TXN_CUR_CODE_FK_KEY | NUMBER | System generated foreign key to the Currency dimension (Transaction Currency) | ||
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 | ||
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_PERF_PK_KEY | NUMBER | System generated unique identifier | ||
RELEASE_NUM | NUMBER | Blanket Agreement or Planned Purchase Order release number | ||
RCV_CLOSE_TOL | NUMBER | Tolerance percentage within which purchase order shipment can be closed for receiving | ||
QTY_SUBS_RECEIPT_B | NUMBER | The number of units received that were a substitute item | ||
QTY_SHIPPED_B | NUMBER | Quantity shipped | ||
QTY_REJECTED_B | NUMBER | Quantity rejected, the number of unit 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, the 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 | ||
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 | ||
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 | ||
MARKET_PRICE_T | NUMBER | The market unit price in the transactional currency | ||
MARKET_PRICE_G | NUMBER | Market unit price in warehouse currency | ||
LIST_PRICE_T | NUMBER | List unit price in transactional currency | ||
LIST_PRICE_G | NUMBER | List unit price in warehouse currency | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
IPV_T | NUMBER | Difference in total amount, in transactional currency, between a purchase order shipment amount and its invoice, due to variance in the unit price | ||
IPV_G | NUMBER | Difference in total amount, in warehouse currency, between a purchase order shipment amount and its invoice, due to variance in the unit price | ||
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 | ||
CREATION_DATE | DATE | Yes | Standard Who Column | |
AMT_PURCHASED_T | NUMBER | Amount purchased, in the transactional currency | ||
AMT_PURCHASED_G | NUMBER | Amount purchased, in the warehouse currency | ||
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 | |
SUP_PERF_PK | VARCHAR2 | (320) | Unique identifier | |
PO_NUMBER | VARCHAR2 | (20) | PO Number assigned in source database | |
CONTRACT_NUM | VARCHAR2 | (25) | PO Number assigned in source database for Blanket Agreements |
Cut, paste (and edit) the following text to query this object:
SELECT SIC_CODE_FK_KEY
, UNSPSC_FK_KEY
, DUNS_FK_KEY
, EDW_UOM_FK_KEY
, EDW_BASE_UOM_FK_KEY
, SUPPLIER_SITE_FK_KEY
, INVOICE_DATE_FK_KEY
, LST_ACCPT_DATE_FK_KEY
, APPROVAL_DATE_FK_KEY
, PROMISED_DATE_FK_KEY
, NEED_BY_DATE_FK_KEY
, FIRST_REC_DATE_FK_KEY
, DATE_DIM_FK_KEY
, CREATION_DATE_FK_KEY
, SUPPLIER_ITEM_FK_KEY
, AP_TERMS_FK_KEY
, BUYER_FK_KEY
, SHIP_TO_ORG_FK_KEY
, PO_LINE_TYPE_FK_KEY
, PURCH_CLASS_FK_KEY
, PRICE_TYPE_FK_KEY
, CLOSED_CODE_FK_KEY
, ITEM_FK_KEY
, INSTANCE_FK_KEY
, SHIP_LOCATION_FK_KEY
, SUP_SITE_GEOG_FK_KEY
, TXN_CUR_CODE_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
, TARGET_PRICE_T
, TARGET_PRICE_G
, SUP_PERF_PK_KEY
, 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
, PRICE_T
, PRICE_G
, 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
, MARKET_PRICE_T
, MARKET_PRICE_G
, LIST_PRICE_T
, LIST_PRICE_G
, LAST_UPDATE_DATE
, IPV_T
, IPV_G
, DAYS_LATE_REC
, DAYS_EARLY_REC
, CREATION_DATE
, AMT_PURCHASED_T
, AMT_PURCHASED_G
, 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
, SUP_PERF_PK
, PO_NUMBER
, CONTRACT_NUM
FROM POA.POA_EDW_SUP_PERF_F;
POA.POA_EDW_SUP_PERF_F does not reference any database object
POA.POA_EDW_SUP_PERF_F is referenced by following:
|
|
|