[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_ALINES_F |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.POA_EDW_ALINES_F |
Subobject Name: | |
Status: | VALID |
The Agreement Line fact data for approved contracts. For Oracle Applications users, this includes only approved Blanket Purchase Agreements. The data is stored at the line 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 fact to determine contract utilization, or to analyze the contract terms.
Some of the measures available in this fact table include the following: Price, List Price, Market Price, Price Limit, Amount Agreed, Quantity Agreed, Amount Released, Quantity Released, Line Minimum Release, Quantity Ordered, Maximum Quantity Ordered, and Minimum Quantity Ordered. Some of the attributes available are: Item Description, Supplier Note, and Receiver Note.
The data in this fact table can be aggregated by the following dimensions: Time, Internal Organization, Geography, Trading Partner, Item, Person, Supplier Item, Instance, PO Line Type, Unit of Measure, Payment Term, Currency, Status, Line Closed, FOB Term, and Freight Term.
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_ALINES_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | AGREE_LN_INST_PK |
POA_EDW_ALINES_F_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | AP_TERMS_FK_KEY |
POA_EDW_ALINES_F_N10 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_CLOSED_FK_KEY |
POA_EDW_ALINES_F_N11 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_TYPE_FK_KEY |
POA_EDW_ALINES_F_N12 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVED_FK_KEY |
POA_EDW_ALINES_F_N13 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CONFIRM_ORDER_FK_KEY |
POA_EDW_ALINES_F_N14 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | NEG_BY_PREPARE_FK_KEY |
POA_EDW_ALINES_F_N15 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CANCELLED_FK_KEY |
POA_EDW_ALINES_F_N16 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | EDI_PROCESSED_FK_KEY |
POA_EDW_ALINES_F_N17 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | USER_HOLD_FK_KEY |
POA_EDW_ALINES_F_N18 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLY_AGREE_FK_KEY |
POA_EDW_ALINES_F_N19 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | LNE_CLOSED_FK_KEY |
POA_EDW_ALINES_F_N2 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_CUR_CODE_FK_KEY |
POA_EDW_ALINES_F_N20 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_VIA_FK_KEY |
POA_EDW_ALINES_F_N21 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CONTRACT_EFFECTIVE_FK_KEY |
POA_EDW_ALINES_F_N22 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FOB_FK_KEY |
POA_EDW_ALINES_F_N23 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FREIGHT_TERMS_FK_KEY |
POA_EDW_ALINES_F_N24 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_REASON_FK_KEY |
POA_EDW_ALINES_F_N25 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PRICE_TYPE_FK_KEY |
POA_EDW_ALINES_F_N26 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PRICE_BREAK_FK_KEY |
POA_EDW_ALINES_F_N27 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ACCPT_REQUIRED_FK_KEY |
POA_EDW_ALINES_F_N28 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FROZEN_FK_KEY |
POA_EDW_ALINES_F_N29 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | OPERATING_UNIT_FK_KEY |
POA_EDW_ALINES_F_N3 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_LOCATION_FK_KEY |
POA_EDW_ALINES_F_N30 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_LINE_TYPE_FK_KEY |
POA_EDW_ALINES_F_N31 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_ITEM_NUM_FK_KEY |
POA_EDW_ALINES_F_N32 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_CREATE_DATE_FK_KEY |
POA_EDW_ALINES_F_N33 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | LNE_CREAT_DATE_FK_KEY |
POA_EDW_ALINES_F_N34 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVED_DATE_FK_KEY |
POA_EDW_ALINES_F_N35 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | REVISED_DATE_FK_KEY |
POA_EDW_ALINES_F_N36 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | START_DATE_FK_KEY |
POA_EDW_ALINES_F_N37 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | END_DATE_FK_KEY |
POA_EDW_ALINES_F_N38 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ACCPT_DUE_DATE_FK_KEY |
POA_EDW_ALINES_F_N39 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_CUR_DATE_FK_KEY |
POA_EDW_ALINES_F_N4 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUP_SITE_GEOG_FK_KEY |
POA_EDW_ALINES_F_N40 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_PRINT_DATE_FK_KEY |
POA_EDW_ALINES_F_N41 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_SITE_FK_KEY |
POA_EDW_ALINES_F_N42 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_UOM_FK_KEY |
POA_EDW_ALINES_F_N43 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BASE_UOM_FK_KEY |
POA_EDW_ALINES_F_N44 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DUNS_FK_KEY |
POA_EDW_ALINES_F_N45 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | UNSPSC_FK_KEY |
POA_EDW_ALINES_F_N46 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SIC_CODE_FK_KEY |
POA_EDW_ALINES_F_N5 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BILL_LOCATION_FK_KEY |
POA_EDW_ALINES_F_N6 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BUYER_FK_KEY |
POA_EDW_ALINES_F_N7 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVER_FK_KEY |
POA_EDW_ALINES_F_N8 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSTANCE_FK_KEY |
POA_EDW_ALINES_F_N9 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ITEM_REVISION_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) | ||
BASE_UOM_FK_KEY | NUMBER | System generated foreign key to the Unit of Measure dimension (Base Unit) | ||
TXN_UOM_FK_KEY | NUMBER | System generated foreign key to the Unit of Measure dimension (Transaction Unit) | ||
SUPPLIER_SITE_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Supplier Site) | ||
PO_PRINT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Printed Date) | ||
TXN_CUR_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Transaction Currency Date) | ||
ACCPT_DUE_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Acceptance Due 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) | ||
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) | ||
LNE_CREAT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Line Creation Date) | ||
PO_CREATE_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Purchase Creation Date) | ||
SUPPLIER_ITEM_NUM_FK_KEY | NUMBER | System generated foreign key to the Supplier Item Number dimension (Supplier Item Number) | ||
PO_LINE_TYPE_FK_KEY | NUMBER | System generated foreign key to the PO Line Type dimension (Line Type) | ||
OPERATING_UNIT_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Operating Unit) | ||
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) | ||
PRICE_BREAK_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Price Break Type) | ||
PRICE_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Price Type) | ||
TXN_REASON_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Transaction Reason) | ||
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) | ||
CONTRACT_EFFECTIVE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Contract in Effect Indicator) | ||
SHIP_VIA_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Ship Method) | ||
LNE_CLOSED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Line Status) | ||
SUPPLY_AGREE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Supply Agreement Indicator) | ||
USER_HOLD_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Hold Indicator) | ||
EDI_PROCESSED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (EDI Processed Indicator) | ||
CANCELLED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Cancelled Indicator) | ||
NEG_BY_PREPARE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Negotiated by Preparer Indicator) | ||
CONFIRM_ORDER_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Confirming Order Indicator) | ||
APPROVED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Approved Indicator) | ||
PO_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Document Type) | ||
PO_CLOSED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Status) | ||
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) | ||
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) | ||
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) | ||
SHIP_LOCATION_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Ship To Location) | ||
TXN_CUR_CODE_FK_KEY | NUMBER | System generated foreign key to the Currency dimension (Transaction Currency) | ||
AP_TERMS_FK_KEY | NUMBER | System generated foreign key to the Payment Term dimension (Payment Term) | ||
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 | ||
USER_FK3_KEY | NUMBER | User defined foreign key | ||
USER_FK2_KEY | NUMBER | User defined foreign key | ||
USER_FK1_KEY | NUMBER | User defined foreign key | ||
UNIT_PRICE_T | NUMBER | Unit price for purchase order line item in transactional currency | ||
UNIT_PRICE_G | NUMBER | Unit price for purchase order line item in warehouse currency | ||
QTY_RELEASED_T | NUMBER | Total quantity released against Blanket Agreement line | ||
QTY_ORDERED_T | NUMBER | Quantity ordered for Blanket Agreement line | ||
QTY_MIN_ORDER_T | NUMBER | Smallest quantity that can be released against a Blanket Agreement line in a single release | ||
QTY_MAX_ORDER_T | NUMBER | Largest quantity that can be released against a Blanket Agreement line in a single release | ||
QTY_AGREED_T | NUMBER | Purchase quantity agreed to | ||
PRICE_LIMIT_T | NUMBER | Unit price limit, in transactional currency, that cannot be exceeded on release shipment | ||
PRICE_LIMIT_G | NUMBER | Unit price limit, in warehosue currency, that cannot be exceeded on release shipment | ||
PO_LINE_ID | NUMBER | Purchase order line identifier | ||
PO_HEADER_ID | NUMBER | Purchase order header identifier | ||
MARKET_PRICE_T | NUMBER | Market unit price in 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 | ||
ITEM_ID | NUMBER | Item indentifier assigned by source application | ||
AMT_RELEASED_T | NUMBER | Amount released against a blanket agreement, in the transactional currency | ||
AMT_RELEASED_G | NUMBER | Amount released against a blanket agreement, in the warehouse currency | ||
AMT_MIN_RELEASE_T | NUMBER | Minimum amount required (transactional currency) for release against contract line | ||
AMT_MIN_RELEASE_G | NUMBER | Minimum amount required (warehouse currency) for release against contract line | ||
AMT_AGREED_T | NUMBER | Purchase amount agreed to in transactional currency | ||
AMT_AGREED_G | NUMBER | Purchase amount agreed to in warehouse currency | ||
AGREE_LN_INST_PK_KEY | NUMBER | System generated unique identifier | ||
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 | |
RECEIVER_NOTE | VARCHAR2 | (480) | Purchase Order note to receiver | |
PO_SUPPLIER_NOTE | VARCHAR2 | (480) | PO line note to supplier | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Description for PO line item | |
COMMENTS | VARCHAR2 | (240) | Purchase order comments | |
CANCEL_REASON | VARCHAR2 | (240) | Reason for PO line cancellation | |
AGREE_LN_INST_PK | VARCHAR2 | (320) | Unique identifier | |
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
, UNSPSC_FK_KEY
, DUNS_FK_KEY
, BASE_UOM_FK_KEY
, TXN_UOM_FK_KEY
, SUPPLIER_SITE_FK_KEY
, PO_PRINT_DATE_FK_KEY
, TXN_CUR_DATE_FK_KEY
, ACCPT_DUE_DATE_FK_KEY
, END_DATE_FK_KEY
, START_DATE_FK_KEY
, REVISED_DATE_FK_KEY
, APPROVED_DATE_FK_KEY
, LNE_CREAT_DATE_FK_KEY
, PO_CREATE_DATE_FK_KEY
, SUPPLIER_ITEM_NUM_FK_KEY
, PO_LINE_TYPE_FK_KEY
, OPERATING_UNIT_FK_KEY
, FROZEN_FK_KEY
, ACCPT_REQUIRED_FK_KEY
, PRICE_BREAK_FK_KEY
, PRICE_TYPE_FK_KEY
, TXN_REASON_FK_KEY
, FREIGHT_TERMS_FK_KEY
, FOB_FK_KEY
, CONTRACT_EFFECTIVE_FK_KEY
, SHIP_VIA_FK_KEY
, LNE_CLOSED_FK_KEY
, SUPPLY_AGREE_FK_KEY
, USER_HOLD_FK_KEY
, EDI_PROCESSED_FK_KEY
, CANCELLED_FK_KEY
, NEG_BY_PREPARE_FK_KEY
, CONFIRM_ORDER_FK_KEY
, APPROVED_FK_KEY
, PO_TYPE_FK_KEY
, PO_CLOSED_FK_KEY
, ITEM_REVISION_FK_KEY
, INSTANCE_FK_KEY
, APPROVER_FK_KEY
, BUYER_FK_KEY
, BILL_LOCATION_FK_KEY
, SUP_SITE_GEOG_FK_KEY
, SHIP_LOCATION_FK_KEY
, TXN_CUR_CODE_FK_KEY
, AP_TERMS_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
, UNIT_PRICE_T
, UNIT_PRICE_G
, QTY_RELEASED_T
, QTY_ORDERED_T
, QTY_MIN_ORDER_T
, QTY_MAX_ORDER_T
, QTY_AGREED_T
, PRICE_LIMIT_T
, PRICE_LIMIT_G
, PO_LINE_ID
, PO_HEADER_ID
, MARKET_PRICE_T
, MARKET_PRICE_G
, LIST_PRICE_T
, LIST_PRICE_G
, ITEM_ID
, AMT_RELEASED_T
, AMT_RELEASED_G
, AMT_MIN_RELEASE_T
, AMT_MIN_RELEASE_G
, AMT_AGREED_T
, AMT_AGREED_G
, AGREE_LN_INST_PK_KEY
, 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
, RECEIVER_NOTE
, PO_SUPPLIER_NOTE
, ITEM_DESCRIPTION
, COMMENTS
, CANCEL_REASON
, AGREE_LN_INST_PK
, LAST_UPDATE_DATE
, CREATION_DATE
FROM POA.POA_EDW_ALINES_F;
POA.POA_EDW_ALINES_F does not reference any database object
POA.POA_EDW_ALINES_F is referenced by following:
|
|
|