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

TABLE: POA.POA_EDW_CONTRACT_FSTG

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


This is the interface table for the Contract 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)
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_HOLD_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Hold Indicator)
USER_FK5_KEY NUMBER

User defined foreign key
USER_FK4_KEY NUMBER

User defined foreign key
USER_FK3_KEY NUMBER

User defined foreign key
USER_FK2_KEY NUMBER

User defined foreign key
USER_FK1_KEY NUMBER

User defined foreign key
TXN_CUR_RATE NUMBER

Exchange rate to convert from transaction to set of books currency
TXN_CUR_DATE_FK_KEY NUMBER

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

System generated foreign key to the Currency dimension (Transaction Currency)
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)
START_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Start Date)
SHIP_VIA_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Ship Method)
SHIP_LOCATION_FK_KEY NUMBER

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

PO revision number
REVISED_DATE_FK_KEY NUMBER

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

Identifier used by collection program
PRINTED_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Printed Date)
PO_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Document Type)
PO_HEADER_ID NUMBER

Purchase order header identifier
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit)
NUM_DAYS_CREATE_TO_APP NUMBER

Purchase Order Approval Cycle Time. The difference in days between the date the PO was created and the date it was approved
NUM_DAYS_APP_TO_SEND NUMBER

Purchase Order Send Cycle Time. The difference in days between thel date the PO was approved and the date the PO was last printed
NUM_DAYS_APP_SEND_TO_ACCPT NUMBER

Purchase Order Acceptance Cycle Time. The difference in days between the date the PO was last printed and the date the supplier accepts it
INSTANCE_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Frozen Indicator)
FREIGHT_TERMS_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (FOB Term)
END_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (End Date)
EDI_PROCESSED_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (EDI Processed Indicator)
CREATION_DATE_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Contract in Effect Indicator)
CONFIRM_ORDER_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Confirming Order Indicator)
CLOSED_FK_KEY NUMBER

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

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

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

System generated foreign key to the Geography dimension (Bill To Location)
AP_TERMS_FK_KEY NUMBER

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

System generated foreign key to the Person dimension (Approver)
APPROVED_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Approved Indicator)
APPROVED_DATE_FK_KEY NUMBER

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

Amount released against a blanket or contract agreement, in the transactional currency
AMT_RELEASED_G NUMBER

Amount released against a blanket or contract agreement, in the warehouse currency
AMT_MIN_RELEASE_T NUMBER

Minimum amount required (transactional currency) for release against contract
AMT_MIN_RELEASE_G NUMBER

Minimum amount required (warehouse currency) for release against contract
AMT_LIMIT_T NUMBER

Maximum amount (transactional currency) for total of all releases against a contract
AMT_LIMIT_G NUMBER

Maximum amount (warehouse currency) for total of all releases against a contract
AMT_AGREED_T NUMBER

Amount agreed in transactional currency
AMT_AGREED_G NUMBER

Amount agreed in warehouse currency
ACCPT_REQUIRED_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Acceptance Required Indicator)
ACCPT_DUE_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Acceptance Due Date)
SIC_CODE_FK VARCHAR2 (80)
Foreign key to the SIC Code dimension (Standard Industry Commodity Code)
DUNS_FK VARCHAR2 (80)
Foreign key to the DUNS dimension (D&B DUNS Code)
CONTRACT_NUM VARCHAR2 (40)
PO number assigned by the source application for the contract
USER_HOLD_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Hold Indicator)
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_RATE_TYPE VARCHAR2 (40)
Transaction currency exchange rate type
TXN_CUR_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Transaction Currency Date)
TXN_CUR_CODE_FK VARCHAR2 (20)
Foreign key to the Currency dimension (Transaction Currency)
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_NOTE VARCHAR2 (480)
Purchase Order note to supplier
START_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Start Date)
SHIP_VIA_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Ship Method)
SHIP_LOCATION_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Ship To Location)
ROW_ID ROWID (10)
Row identifier
REVISED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Revised Date)
RECEIVER_NOTE VARCHAR2 (480)
Purchase Order note to receiver
PRINTED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Printed Date)
PO_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Document Type)
OPERATION_CODE VARCHAR2 (30)
Code used by the loader program to determine whether to insert/update/delete this record
OPERATING_UNIT_FK VARCHAR2 (240)
Foreign key to the Internal Organization dimension (Operating Unit)
INSTANCE_FK VARCHAR2 (40)
Foreign key to the Instance dimension (Instance)
FROZEN_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Frozen Indicator)
FREIGHT_TERMS_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Freight Term)
FOB_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (FOB Term)
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
END_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (End Date)
EDI_PROCESSED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (EDI Processed Indicator)
CREATION_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Creation Date)
CONTRACT_PK VARCHAR2 (320)
Unique identifier
CONTRACT_EFFECTIVE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Contract in Effect Indicator)
CONFIRM_ORDER_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Confirming Order Indicator)
COMMENTS VARCHAR2 (240)
Purchase order comments
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_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Status)
CANCELLED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Cancelled Indicator)
BUYER_FK VARCHAR2 (1000)
Foreign key to the Person dimension (Buyer)
BILL_LOCATION_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Bill To Location)
AP_TERMS_FK VARCHAR2 (80)
Foreign key to the Payment Term dimension (Payment Term)
APPROVER_FK VARCHAR2 (1000)
Foreign key to the Person dimension (Approver)
APPROVED_FK VARCHAR2 (240)
System generated foreign key to the Lookup dimension (Approved Indicator)
APPROVED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Approval Date)
ACCPT_REQUIRED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Acceptance Required Indicator)
ACCPT_DUE_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Acceptance Due Date)
Query Text

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


SELECT SIC_CODE_FK_KEY
,      DUNS_FK_KEY
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_HOLD_FK_KEY
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      TXN_CUR_RATE
,      TXN_CUR_DATE_FK_KEY
,      TXN_CUR_CODE_FK_KEY
,      SUP_SITE_GEOG_FK_KEY
,      SUPPLIER_SITE_FK_KEY
,      START_DATE_FK_KEY
,      SHIP_VIA_FK_KEY
,      SHIP_LOCATION_FK_KEY
,      REVISION_NUM
,      REVISED_DATE_FK_KEY
,      REQUEST_ID
,      PRINTED_DATE_FK_KEY
,      PO_TYPE_FK_KEY
,      PO_HEADER_ID
,      OPERATING_UNIT_FK_KEY
,      NUM_DAYS_CREATE_TO_APP
,      NUM_DAYS_APP_TO_SEND
,      NUM_DAYS_APP_SEND_TO_ACCPT
,      INSTANCE_FK_KEY
,      FROZEN_FK_KEY
,      FREIGHT_TERMS_FK_KEY
,      FOB_FK_KEY
,      END_DATE_FK_KEY
,      EDI_PROCESSED_FK_KEY
,      CREATION_DATE_FK_KEY
,      CONTRACT_EFFECTIVE_FK_KEY
,      CONFIRM_ORDER_FK_KEY
,      CLOSED_FK_KEY
,      CANCELLED_FK_KEY
,      BUYER_FK_KEY
,      BILL_LOCATION_FK_KEY
,      AP_TERMS_FK_KEY
,      APPROVER_FK_KEY
,      APPROVED_FK_KEY
,      APPROVED_DATE_FK_KEY
,      AMT_RELEASED_T
,      AMT_RELEASED_G
,      AMT_MIN_RELEASE_T
,      AMT_MIN_RELEASE_G
,      AMT_LIMIT_T
,      AMT_LIMIT_G
,      AMT_AGREED_T
,      AMT_AGREED_G
,      ACCPT_REQUIRED_FK_KEY
,      ACCPT_DUE_DATE_FK_KEY
,      SIC_CODE_FK
,      DUNS_FK
,      CONTRACT_NUM
,      USER_HOLD_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_RATE_TYPE
,      TXN_CUR_DATE_FK
,      TXN_CUR_CODE_FK
,      SUP_SITE_GEOG_FK
,      SUPPLIER_SITE_FK
,      SUPPLIER_NOTE
,      START_DATE_FK
,      SHIP_VIA_FK
,      SHIP_LOCATION_FK
,      ROW_ID
,      REVISED_DATE_FK
,      RECEIVER_NOTE
,      PRINTED_DATE_FK
,      PO_TYPE_FK
,      OPERATION_CODE
,      OPERATING_UNIT_FK
,      INSTANCE_FK
,      FROZEN_FK
,      FREIGHT_TERMS_FK
,      FOB_FK
,      ERROR_CODE
,      END_DATE_FK
,      EDI_PROCESSED_FK
,      CREATION_DATE_FK
,      CONTRACT_PK
,      CONTRACT_EFFECTIVE_FK
,      CONFIRM_ORDER_FK
,      COMMENTS
,      COLLECTION_STATUS
,      CLOSED_FK
,      CANCELLED_FK
,      BUYER_FK
,      BILL_LOCATION_FK
,      AP_TERMS_FK
,      APPROVER_FK
,      APPROVED_FK
,      APPROVED_DATE_FK
,      ACCPT_REQUIRED_FK
,      ACCPT_DUE_DATE_FK
FROM POA.POA_EDW_CONTRACT_FSTG;

Dependencies

[top of page]

POA.POA_EDW_CONTRACT_FSTG does not reference any database object

POA.POA_EDW_CONTRACT_FSTG is referenced by following:

SchemaAPPS
SynonymPOA_EDW_CONTRACT_FSTG