[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | POA_EDW_RCV_TXNS_F |
|---|---|
| Object Type: | TABLE |
| Owner: | POA |
| FND Design Data: |  POA.POA_EDW_RCV_TXNS_F
|
| Subobject Name: | |
| Status: | VALID |
The Receiving fact table contains data for the following transactions: receipts, corrections, returns, deliveries, transfers, and inspection results. The data is stored at the receipt line level. This fact is useful for analyzing receiving transaction volume.
Some of the measures available in this fact table include the following: Receiving Transaction Quantity, Net Receiving Transaction Quantity, Quantity Accepted, Quantity Rejected, Quantity Received, Quantity Delivered, Quantity Returned to Receiving, Quantity Returned to Vendor, Quantity Transferred, and Days from Receipt to Full Delivery.
Some of the attributes available are: RMA Reference Number, Packing Slip Number, Bill of Lading Number, Vendor Lot Number, Waybill/Airbill Number, Source Transaction Number, and Invoice Number.
The data in this fact table can be aggregated by the following dimensions: Time, Item, Supplier Item Number, Trading Partner, Geography, Internal Organization, Person, Instance, PO Line Type, Currency, Payment Term, Unit of Measure, Parent Transaction Type, Source Type, and Receipt Routing.
All quantities are expressed in the warehouse base unit of measure.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 30 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| POA_EDW_RCV_TXNS_F_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 RCV_TXN_PK
|
| POA_EDW_RCV_TXNS_F_N1 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TXN_CUR_CODE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N10 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
RECEIVE_EXCEP_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N11 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
USER_ENTERED_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N12 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TXN_REASON_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N13 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PURCHASE_CLASS_CODE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N14 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
RECEIPT_SOURCE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N15 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DESTIN_TYPE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N16 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
RCV_ROUTING_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N17 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SUBST_UNORD_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N18 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PARNT_TXN_TYPE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N19 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
FREIGHT_TERMS_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N2 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SUP_SITE_GEOG_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N20 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INSPECT_STATUS_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N21 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INSPECT_QUAL_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N22 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
RCV_DEL_TO_ORG_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N23 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
AP_TERMS_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N24 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
BUYER_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N25 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DELIVER_TO_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N26 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SUPPLIER_ITEM_NUM_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N27 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TXN_CREAT_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N28 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SHIPPED_TO_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N29 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
EXPCT_RCV_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N3 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
RCV_LOCATION_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N30 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PROMISED_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N31 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
NEED_BY_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N32 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
LST_ACCPT_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N33 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SRC_CREAT_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N34 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PARNT_TXN_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N35 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TXN_DATE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N36 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SUPPLIER_SITE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N37 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
EDW_BASE_UOM_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N38 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
EDW_UOM_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N39 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DUNS_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N4 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DELIV_LOCATION_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N40 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
UNSPSC_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N41 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SIC_CODE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N5 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INSTANCE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N6 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ITEM_REVISION_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N7 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PO_LINE_TYPE_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N8 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
LOCATOR_FK_KEY
|
| POA_EDW_RCV_TXNS_F_N9 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TXN_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 UOM dimension (Transaction Unit) | ||
| EDW_BASE_UOM_FK_KEY | NUMBER | System generated foreign key to the UOM dimension (Base Unit) | ||
| SUPPLIER_SITE_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Supplier Site) | ||
| TXN_DATE_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Supplier) | ||
| PARNT_TXN_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Parent Transaction Date) | ||
| SRC_CREAT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Source Shipment Creation Date) | ||
| LST_ACCPT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Latest Acceptable Receipt Date) | ||
| NEED_BY_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Need by Date) | ||
| PROMISED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Promised Date) | ||
| EXPCT_RCV_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Expected Receipt Date) | ||
| SHIPPED_TO_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Shipped Date) | ||
| TXN_CREAT_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Transaction Creation Date) | ||
| SUPPLIER_ITEM_NUM_FK_KEY | NUMBER | System generated foreign key to the Supplier Item dimension (Supplier Item Number) | ||
| DELIVER_TO_FK_KEY | NUMBER | System generated foreign key to the Person dimension (Requestor) | ||
| 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) | ||
| RCV_DEL_TO_ORG_FK_KEY | NUMBER | System generated foreign key to the Organization dimension (Deliver to Organization) | ||
| INSPECT_QUAL_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Inspection Quality) | ||
| INSPECT_STATUS_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Inspection Status) | ||
| FREIGHT_TERMS_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Freight Term) | ||
| PARNT_TXN_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Parent Transaction Type) | ||
| SUBST_UNORD_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Substitute or Unordered Receipt Indicator) | ||
| RCV_ROUTING_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension ( Receipt Routing ) | ||
| DESTIN_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Destination Type) | ||
| RECEIPT_SOURCE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Shipment Source Type) | ||
| PURCHASE_CLASS_CODE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Purchase Classification). Purchase Classification can be used to classify purchases of production or non-production items. | ||
| TXN_REASON_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Transaction Reason) | ||
| USER_ENTERED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (User Entered Transaction Indicator) | ||
| RECEIVE_EXCEP_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Receipt Exception Indicator) | ||
| TXN_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Transaction Type ) | ||
| LOCATOR_FK_KEY | NUMBER | System generated foreign key to the Inventory Location dimension (Inventory Locator) | ||
| PO_LINE_TYPE_FK_KEY | NUMBER | System generated foreign key to the PO Line Type dimension (Line Type) | ||
| ITEM_REVISION_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) | ||
| DELIV_LOCATION_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Deliver to Location) | ||
| RCV_LOCATION_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Receiving 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 | User defined foreign key | ||
| USER_FK4_KEY | NUMBER | User defined foreign key | ||
| QTY_RETURN_TO_RECEIVING | NUMBER | Quantity returned to receiving | ||
| QTY_REJECT | NUMBER | Quantity rejected | ||
| QTY_RECEIVED | NUMBER | Quantity received | ||
| QTY_DELIVER | NUMBER | Quantity delivered | ||
| QTY_ACCEPT | NUMBER | Quantity accepted | ||
| PRICE_T | NUMBER | Price for the item in the transaction currency | ||
| PRICE_G | NUMBER | Price for the item in the warehouse currency | ||
| NUM_DAYS_TO_FULL_DEL | NUMBER | Number of days from receipt to full delivery | ||
| QTY_TXN_NET | NUMBER | Net receiving quantity transacted | ||
| QTY_TXN | NUMBER | Receiving quantity transaction | ||
| QTY_TRANSFER | NUMBER | Quantity transferred | ||
| QTY_RETURN_TO_VENDOR | NUMBER | Quantity returned to vendor | ||
| USER_FK3_KEY | NUMBER | User defined foreign key | ||
| USER_FK2_KEY | NUMBER | User defined foreign key | ||
| USER_FK1_KEY | NUMBER | User defined foreign key | ||
| RCV_TXN_PK_KEY | NUMBER | System generated unique identifier | ||
| WAY_AIRBILL_NUM | VARCHAR2 | (40) | Air waybill number | |
| VENDOR_LOT_NUM | VARCHAR2 | (40) | Vendor Lot Number | |
| PACKING_SLIP | VARCHAR2 | (40) | Packing Slip Number | |
| INVOICE_NUM | VARCHAR2 | (320) | Invoice Number | |
| BILL_OF_LADING | VARCHAR2 | (40) | Bill of Lading Number | |
| RCV_TXN_PK | VARCHAR2 | (120) | Unique identifier for Receiving Transactions | |
| 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_COMMENTS | VARCHAR2 | (240) | Receiving Transaction Comments | |
| SOURCE_TXN_NUMBER | VARCHAR2 | (320) | Source Transaction Number | |
| SHIP_HDR_COMMENTS | VARCHAR2 | (240) | Shipment Header Comments | |
| SHIPMENT_NUM | VARCHAR2 | (320) | Shipment Number | |
| RMA_REFERENCE | VARCHAR2 | (40) | Return Material Authorization Number | |
| RECEIPT_NUM_INST | VARCHAR2 | (320) | Receipt Number | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| PO_DISTRIBUTION_ID | NUMBER | PO DIstribution id from rcv_transactions |
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
, TXN_DATE_FK_KEY
, PARNT_TXN_DATE_FK_KEY
, SRC_CREAT_DATE_FK_KEY
, LST_ACCPT_DATE_FK_KEY
, NEED_BY_DATE_FK_KEY
, PROMISED_DATE_FK_KEY
, EXPCT_RCV_DATE_FK_KEY
, SHIPPED_TO_DATE_FK_KEY
, TXN_CREAT_FK_KEY
, SUPPLIER_ITEM_NUM_FK_KEY
, DELIVER_TO_FK_KEY
, BUYER_FK_KEY
, AP_TERMS_FK_KEY
, RCV_DEL_TO_ORG_FK_KEY
, INSPECT_QUAL_FK_KEY
, INSPECT_STATUS_FK_KEY
, FREIGHT_TERMS_FK_KEY
, PARNT_TXN_TYPE_FK_KEY
, SUBST_UNORD_FK_KEY
, RCV_ROUTING_FK_KEY
, DESTIN_TYPE_FK_KEY
, RECEIPT_SOURCE_FK_KEY
, PURCHASE_CLASS_CODE_FK_KEY
, TXN_REASON_FK_KEY
, USER_ENTERED_FK_KEY
, RECEIVE_EXCEP_FK_KEY
, TXN_TYPE_FK_KEY
, LOCATOR_FK_KEY
, PO_LINE_TYPE_FK_KEY
, ITEM_REVISION_FK_KEY
, INSTANCE_FK_KEY
, DELIV_LOCATION_FK_KEY
, RCV_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
, QTY_RETURN_TO_RECEIVING
, QTY_REJECT
, QTY_RECEIVED
, QTY_DELIVER
, QTY_ACCEPT
, PRICE_T
, PRICE_G
, NUM_DAYS_TO_FULL_DEL
, QTY_TXN_NET
, QTY_TXN
, QTY_TRANSFER
, QTY_RETURN_TO_VENDOR
, USER_FK3_KEY
, USER_FK2_KEY
, USER_FK1_KEY
, RCV_TXN_PK_KEY
, WAY_AIRBILL_NUM
, VENDOR_LOT_NUM
, PACKING_SLIP
, INVOICE_NUM
, BILL_OF_LADING
, RCV_TXN_PK
, 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_COMMENTS
, SOURCE_TXN_NUMBER
, SHIP_HDR_COMMENTS
, SHIPMENT_NUM
, RMA_REFERENCE
, RECEIPT_NUM_INST
, LAST_UPDATE_DATE
, CREATION_DATE
, PO_DISTRIBUTION_ID
FROM POA.POA_EDW_RCV_TXNS_F;
POA.POA_EDW_RCV_TXNS_F does not reference any database object
POA.POA_EDW_RCV_TXNS_F is referenced by following:
APPS
POA_EDW_RCV_TXNS_F
|
|
|
|