[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_CONTRACT_F |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.POA_EDW_CONTRACT_F |
Subobject Name: | |
Status: | VALID |
The Contract fact contains data for approved contracts. For Oracle Applications users, this includes approved Blanket Purchase Agreements and Contract Agreements. The data is stored at the header level. This fact is useful for analyzing information about contracts that you have entered into with your suppliers. It can be used in conjunction with the Contract Lines fact to determine contract utilization, or to analyze the contract terms.
Some of the measures available in this fact table include the following: Releases, Amount Agreed, Amount Limit, and Minimum Release.
The data in this fact table can be aggregated by the following dimensions: Time, Person, Geography, Internal Organization, Trading Partner, Instance, Currency, Payment Term, Freight Term, FOB Term, and Status.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
POA_EDW_CONTRACT_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | CONTRACT_PK |
POA_EDW_CONTRACT_F_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_CUR_CODE_FK_KEY |
POA_EDW_CONTRACT_F_N10 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CONTRACT_EFFECTIVE_FK_KEY |
POA_EDW_CONTRACT_F_N11 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_TYPE_FK_KEY |
POA_EDW_CONTRACT_F_N12 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_VIA_FK_KEY |
POA_EDW_CONTRACT_F_N13 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FOB_FK_KEY |
POA_EDW_CONTRACT_F_N14 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FREIGHT_TERMS_FK_KEY |
POA_EDW_CONTRACT_F_N15 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ACCPT_REQUIRED_FK_KEY |
POA_EDW_CONTRACT_F_N16 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FROZEN_FK_KEY |
POA_EDW_CONTRACT_F_N17 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CANCELLED_FK_KEY |
POA_EDW_CONTRACT_F_N18 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | USER_HOLD_FK_KEY |
POA_EDW_CONTRACT_F_N19 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | OPERATING_UNIT_FK_KEY |
POA_EDW_CONTRACT_F_N2 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUP_SITE_GEOG_FK_KEY |
POA_EDW_CONTRACT_F_N20 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | AP_TERMS_FK_KEY |
POA_EDW_CONTRACT_F_N21 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BUYER_FK_KEY |
POA_EDW_CONTRACT_F_N22 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVER_FK_KEY |
POA_EDW_CONTRACT_F_N23 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CREATION_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N24 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVED_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N25 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | REVISED_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N26 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ACCPT_DUE_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N27 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | START_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N28 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | END_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N29 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PRINTED_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N3 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BILL_LOCATION_FK_KEY |
POA_EDW_CONTRACT_F_N30 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_CUR_DATE_FK_KEY |
POA_EDW_CONTRACT_F_N31 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_SITE_FK_KEY |
POA_EDW_CONTRACT_F_N32 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DUNS_FK_KEY |
POA_EDW_CONTRACT_F_N33 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SIC_CODE_FK_KEY |
POA_EDW_CONTRACT_F_N4 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_LOCATION_FK_KEY |
POA_EDW_CONTRACT_F_N5 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSTANCE_FK_KEY |
POA_EDW_CONTRACT_F_N6 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CLOSED_FK_KEY |
POA_EDW_CONTRACT_F_N7 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CONFIRM_ORDER_FK_KEY |
POA_EDW_CONTRACT_F_N8 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVED_FK_KEY |
POA_EDW_CONTRACT_F_N9 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | EDI_PROCESSED_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) | ||
DUNS_FK_KEY | NUMBER | System generated foreign key to the DUNS dimension (D&B DUNS Code) | ||
SUPPLIER_SITE_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Supplier Site) | ||
TXN_CUR_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Transaction Currency Date) | ||
PRINTED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Printed Date) | ||
END_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (End Date) | ||
START_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Start Date) | ||
ACCPT_DUE_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Acceptance Due Date) | ||
REVISED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Revised Date) | ||
APPROVED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Approval Date) | ||
CREATION_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Creation Date) | ||
APPROVER_FK_KEY | NUMBER | System generated foreign key to the Person dimension (Approver) | ||
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) | ||
OPERATING_UNIT_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Operating Unit) | ||
USER_HOLD_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Hold Indicator) | ||
CANCELLED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Cancelled Indicator) | ||
FROZEN_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Frozen Indicator) | ||
ACCPT_REQUIRED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Acceptance Required 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) | ||
SHIP_VIA_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Ship Method) | ||
PO_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Document Type) | ||
CONTRACT_EFFECTIVE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Contract in Effect Indicator) | ||
EDI_PROCESSED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (EDI Processed Indicator) | ||
APPROVED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Approved 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) | ||
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) | ||
BILL_LOCATION_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Bill 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 | ||
TXN_CUR_RATE | NUMBER | Exchange rate to convert from transaction to set of books currency | ||
REVISION_NUM | NUMBER | PO revision number | ||
PO_HEADER_ID | NUMBER | Purchase order header identifier | ||
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 the 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 | ||
CONTRACT_PK_KEY | NUMBER | System generated unique identifier | ||
AMT_RELEASED_T | NUMBER | Amount released against a blanket or a 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 blanket | ||
AMT_MIN_RELEASE_G | NUMBER | Minimum amount required (warehouse currency) for release against blanket | ||
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 | ||
CONTRACT_NUM | VARCHAR2 | (40) | PO number assigned by the source application for the contract | |
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 | |
SUPPLIER_NOTE | VARCHAR2 | (480) | Purchase Order note to supplier | |
RECEIVER_NOTE | VARCHAR2 | (480) | Purchase order note to receiver | |
CONTRACT_PK | VARCHAR2 | (320) | Unique identifier | |
COMMENTS | VARCHAR2 | (240) | Purchase order comments | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT SIC_CODE_FK_KEY
, DUNS_FK_KEY
, SUPPLIER_SITE_FK_KEY
, TXN_CUR_DATE_FK_KEY
, PRINTED_DATE_FK_KEY
, END_DATE_FK_KEY
, START_DATE_FK_KEY
, ACCPT_DUE_DATE_FK_KEY
, REVISED_DATE_FK_KEY
, APPROVED_DATE_FK_KEY
, CREATION_DATE_FK_KEY
, APPROVER_FK_KEY
, BUYER_FK_KEY
, AP_TERMS_FK_KEY
, OPERATING_UNIT_FK_KEY
, USER_HOLD_FK_KEY
, CANCELLED_FK_KEY
, FROZEN_FK_KEY
, ACCPT_REQUIRED_FK_KEY
, FREIGHT_TERMS_FK_KEY
, FOB_FK_KEY
, SHIP_VIA_FK_KEY
, PO_TYPE_FK_KEY
, CONTRACT_EFFECTIVE_FK_KEY
, EDI_PROCESSED_FK_KEY
, APPROVED_FK_KEY
, CONFIRM_ORDER_FK_KEY
, CLOSED_FK_KEY
, INSTANCE_FK_KEY
, SHIP_LOCATION_FK_KEY
, BILL_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
, TXN_CUR_RATE
, REVISION_NUM
, PO_HEADER_ID
, NUM_DAYS_CREATE_TO_APP
, NUM_DAYS_APP_TO_SEND
, NUM_DAYS_APP_SEND_TO_ACCPT
, CONTRACT_PK_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
, CONTRACT_NUM
, 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
, SUPPLIER_NOTE
, RECEIVER_NOTE
, CONTRACT_PK
, COMMENTS
, LAST_UPDATE_DATE
, CREATION_DATE
FROM POA.POA_EDW_CONTRACT_F;
POA.POA_EDW_CONTRACT_F does not reference any database object
POA.POA_EDW_CONTRACT_F is referenced by following:
|
|
|