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

TABLE: POA.POA_EDW_RCV_TXNS_FSTG

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


This is the interface table for the Receiving 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
DUNS_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (User Entered Transaction Indicator)
TXN_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Transaction Type )
TXN_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Transaction Reason)
TXN_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Transaction Date)
TXN_CUR_CODE_FK_KEY NUMBER

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

System generated foreign key to the Time dimension (Creation Date)
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 the Trading Partner dimension (Supplier Site)
SUPPLIER_ITEM_NUM_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Substitute or Unordered Receipt Indicator)
SRC_CREAT_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Source Shipment Creation Date)
SHIPPED_TO_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Shipped Date)
REQUEST_ID NUMBER

Identifier used by collection program
RECEIVE_EXCEP_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Receipt Exception Indicator)
RECEIPT_SOURCE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension ( Source Type)
RCV_ROUTING_FK_KEY NUMBER

System generated foreign key to the Lookup dimension ( Receipt Routing )
RCV_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Receiving Location)
RCV_DEL_TO_ORG_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Deliver-to Organization)
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
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
PURCHASE_CLASS_CODE_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_T NUMBER

Price for the item in the transaction currency
PRICE_G NUMBER

Price for the item in the warehouse currency
PO_LINE_TYPE_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Parent Transaction Type)
PARNT_TXN_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Parent Transaction Date)
NUM_DAYS_TO_FULL_DEL NUMBER

Number of days from receipt to full delivery
NEED_BY_DATE_FK_KEY NUMBER

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

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

System generated foreign key to the Inventory Location dimension (Inventory Locator)
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)
INSPECT_STATUS_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Inspection Quality)
FREIGHT_TERMS_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Freight Term)
EXPCT_RCV_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Expected Arrival 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)
DESTIN_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Destination Type)
DELIV_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Deliver To Location)
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)
DUNS_FK VARCHAR2 (80)
Foreign key to the DUNS dimension (D&B DUNS Code)
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)
WAY_AIRBILL_NUM VARCHAR2 (40)
Air waybill number
VENDOR_LOT_NUM VARCHAR2 (40)
Vendor Lot Number
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_ENTERED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (User Entered)
USER_ATTRIBUTE9 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User Attribute
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute
TXN_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Transaction Type )
TXN_REASON_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Transaction Reason)
TXN_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Transaction Date)
TXN_CUR_CODE_FK VARCHAR2 (240)
Foreign key to the Currency dimension (Transaction Currency)
TXN_CREAT_FK VARCHAR2 (120)
Foreign key to the Time dimension (Transaction Creation Date)
TXN_COMMENTS VARCHAR2 (240)
Receiving Transaction Comments
SUP_SITE_GEOG_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Supplier Site Location)
SUPPLIER_SITE_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Supplier Site)
SUPPLIER_ITEM_NUM_FK VARCHAR2 (480)
Foreign key to the Supplier Item dimension (Supplier Item Number)
SUBST_UNORD_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Substitute or Unordered Receipt Indicator)
SRC_CREAT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Source Shipment Creation Date)
SOURCE_TXN_NUMBER VARCHAR2 (320)
Source Transaction Number
SHIP_HDR_COMMENTS VARCHAR2 (240)
Shipment Header Comments
SHIPPED_TO_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Shipped Date)
SHIPMENT_NUM VARCHAR2 (320)
Shipment Number
ROW_ID ROWID (10)
Row identifier
RMA_REFERENCE VARCHAR2 (40)
Return Material Authorization Number
RECEIVE_EXCEP_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Receipt Exception Indicator)
RECEIPT_SOURCE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension ( Source Type)
RECEIPT_NUM_INST VARCHAR2 (320)
Receipt Number
RCV_TXN_PK VARCHAR2 (120)
Unique identifier
RCV_ROUTING_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Receipt Routing)
RCV_LOCATION_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Receiving Location)
RCV_DEL_TO_ORG_FK VARCHAR2 (240)
Foreign key to the Internal Organization dimension (Deliver-to Organization)
PURCHASE_CLASS_CODE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Purchase Classification)
PROMISED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Promised Date)
PO_LINE_TYPE_FK VARCHAR2 (80)
Foreign key to the PO Line Type dimension (Line Type)
PARNT_TXN_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Parent Transaction Type)
PARNT_TXN_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Parent Transaction Date)
PACKING_SLIP VARCHAR2 (40)
Packing Slip Number
OPERATION_CODE VARCHAR2 (30)
Code used by the loader program to determine whether to insert/update/delete this record
NEED_BY_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Need By Date)
LST_ACCPT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Last Accept Date)
LOCATOR_FK VARCHAR2 (320)
Foreign key to the Item dimension (Item Revision)
ITEM_REVISION_FK VARCHAR2 (320)
Foreign key to the Item dimension (Item)
INVOICE_NUM VARCHAR2 (320)
Invoice number
INSTANCE_FK VARCHAR2 (40)
Foreign key to the Instance dimension (Instance)
INSPECT_STATUS_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Inspection Status)
INSPECT_QUAL_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Inspection Quality)
FREIGHT_TERMS_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Freight Term)
EXPCT_RCV_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Expected Receipt Date)
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
EDW_UOM_FK VARCHAR2 (80)
Foreign key to the Unit of Measure dimension (Transaction Unit)
EDW_BASE_UOM_FK VARCHAR2 (80)
Foreign key to the Unit of Measure dimension (Base Unit)
DESTIN_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Destination Type)
DELIV_LOCATION_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Deliver To Location)
DELIVER_TO_FK VARCHAR2 (1000)
Foreign key to the Person dimension (Requestor)
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)
BUYER_FK VARCHAR2 (1000)
Foreign key to the Person dimension (Buyer)
BILL_OF_LADING VARCHAR2 (40)
Bill of Lading Number
AP_TERMS_FK VARCHAR2 (80)
Foreign key to the Payment Term dimension (Payment Term)
PO_DISTRIBUTION_ID NUMBER

PO Distribution Id from RCV_TRANSACTIONS
Query Text

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


SELECT DUNS_FK_KEY
,      SIC_CODE_FK_KEY
,      UNSPSC_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
,      USER_ENTERED_FK_KEY
,      TXN_TYPE_FK_KEY
,      TXN_REASON_FK_KEY
,      TXN_DATE_FK_KEY
,      TXN_CUR_CODE_FK_KEY
,      TXN_CREAT_FK_KEY
,      SUP_SITE_GEOG_FK_KEY
,      SUPPLIER_SITE_FK_KEY
,      SUPPLIER_ITEM_NUM_FK_KEY
,      SUBST_UNORD_FK_KEY
,      SRC_CREAT_DATE_FK_KEY
,      SHIPPED_TO_DATE_FK_KEY
,      REQUEST_ID
,      RECEIVE_EXCEP_FK_KEY
,      RECEIPT_SOURCE_FK_KEY
,      RCV_ROUTING_FK_KEY
,      RCV_LOCATION_FK_KEY
,      RCV_DEL_TO_ORG_FK_KEY
,      QTY_TXN_NET
,      QTY_TXN
,      QTY_TRANSFER
,      QTY_RETURN_TO_VENDOR
,      QTY_RETURN_TO_RECEIVING
,      QTY_REJECT
,      QTY_RECEIVED
,      QTY_DELIVER
,      QTY_ACCEPT
,      PURCHASE_CLASS_CODE_FK_KEY
,      PROMISED_DATE_FK_KEY
,      PRICE_T
,      PRICE_G
,      PO_LINE_TYPE_FK_KEY
,      PARNT_TXN_TYPE_FK_KEY
,      PARNT_TXN_DATE_FK_KEY
,      NUM_DAYS_TO_FULL_DEL
,      NEED_BY_DATE_FK_KEY
,      LST_ACCPT_DATE_FK_KEY
,      LOCATOR_FK_KEY
,      ITEM_REVISION_FK_KEY
,      INSTANCE_FK_KEY
,      INSPECT_STATUS_FK_KEY
,      INSPECT_QUAL_FK_KEY
,      FREIGHT_TERMS_FK_KEY
,      EXPCT_RCV_DATE_FK_KEY
,      EDW_UOM_FK_KEY
,      EDW_BASE_UOM_FK_KEY
,      DESTIN_TYPE_FK_KEY
,      DELIV_LOCATION_FK_KEY
,      DELIVER_TO_FK_KEY
,      BUYER_FK_KEY
,      AP_TERMS_FK_KEY
,      DUNS_FK
,      SIC_CODE_FK
,      UNSPSC_FK
,      WAY_AIRBILL_NUM
,      VENDOR_LOT_NUM
,      USER_FK5
,      USER_FK4
,      USER_FK3
,      USER_FK2
,      USER_FK1
,      USER_ENTERED_FK
,      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_TYPE_FK
,      TXN_REASON_FK
,      TXN_DATE_FK
,      TXN_CUR_CODE_FK
,      TXN_CREAT_FK
,      TXN_COMMENTS
,      SUP_SITE_GEOG_FK
,      SUPPLIER_SITE_FK
,      SUPPLIER_ITEM_NUM_FK
,      SUBST_UNORD_FK
,      SRC_CREAT_DATE_FK
,      SOURCE_TXN_NUMBER
,      SHIP_HDR_COMMENTS
,      SHIPPED_TO_DATE_FK
,      SHIPMENT_NUM
,      ROW_ID
,      RMA_REFERENCE
,      RECEIVE_EXCEP_FK
,      RECEIPT_SOURCE_FK
,      RECEIPT_NUM_INST
,      RCV_TXN_PK
,      RCV_ROUTING_FK
,      RCV_LOCATION_FK
,      RCV_DEL_TO_ORG_FK
,      PURCHASE_CLASS_CODE_FK
,      PROMISED_DATE_FK
,      PO_LINE_TYPE_FK
,      PARNT_TXN_TYPE_FK
,      PARNT_TXN_DATE_FK
,      PACKING_SLIP
,      OPERATION_CODE
,      NEED_BY_DATE_FK
,      LST_ACCPT_DATE_FK
,      LOCATOR_FK
,      ITEM_REVISION_FK
,      INVOICE_NUM
,      INSTANCE_FK
,      INSPECT_STATUS_FK
,      INSPECT_QUAL_FK
,      FREIGHT_TERMS_FK
,      EXPCT_RCV_DATE_FK
,      ERROR_CODE
,      EDW_UOM_FK
,      EDW_BASE_UOM_FK
,      DESTIN_TYPE_FK
,      DELIV_LOCATION_FK
,      DELIVER_TO_FK
,      COLLECTION_STATUS
,      BUYER_FK
,      BILL_OF_LADING
,      AP_TERMS_FK
,      PO_DISTRIBUTION_ID
FROM POA.POA_EDW_RCV_TXNS_FSTG;

Dependencies

[top of page]

POA.POA_EDW_RCV_TXNS_FSTG does not reference any database object

POA.POA_EDW_RCV_TXNS_FSTG is referenced by following:

SchemaAPPS
SynonymPOA_EDW_RCV_TXNS_FSTG