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

TABLE: POA.POA_EDW_ALINES_FSTG

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


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

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
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
TXN_UOM_FK_KEY NUMBER

System generated foreign key to the Unit of Measure dimension (Transaction Unit)
TXN_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Transaction Reason)
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)
SUPPLY_AGREE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Supply Agreement Indicator)
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)
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)
REVISED_DATE_FK_KEY NUMBER

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

Identifier used by collection program
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_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Price Type)
PRICE_LIMIT_T NUMBER

Unit price limit, in transactional currency, that cannot be exceeded on a release shipment
PRICE_LIMIT_G NUMBER

Unit price limit, in warehouse currency, that cannot be exceeded on a release shipment
PRICE_BREAK_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Price Break Type)
PO_TYPE_FK_KEY NUMBER

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

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

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

Purchase order line identifier assigned by source application
PO_HEADER_ID NUMBER

Purchase order header identifier assigned by source application
PO_CREATE_DATE_FK_KEY NUMBER

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

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

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

System generated foreign key to the Lookup dimension (Negotiates by Preparer Indicator)
MARKET_PRICE_T NUMBER

Market unit price in transactional currency
MARKET_PRICE_G NUMBER

Market unit price in warehouse currency
LNE_CREAT_DATE_FK_KEY NUMBER

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

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

List unit price in transactional currency
LIST_PRICE_G NUMBER

List unit price in warehouse currency
ITEM_REVISION_FK_KEY NUMBER

System generated foreign key to the Item dimension (Item Revision)
ITEM_ID NUMBER

Item indentifier assigned by source application
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)
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)
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)
BASE_UOM_FK_KEY NUMBER

System generated foreign key to the Unit of Measure dimension (Base Unit)
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 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
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)
UNSPSC_FK VARCHAR2 (80)
Foreign key to the UNSPSC dimension (UNSPSC Code)
DUNS_FK VARCHAR2 (80)
Foreign key to the DUNS dimension (D&B DUNS Code)
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_UOM_FK VARCHAR2 (80)
Foreign key to the Unit of Measure dimension (Transaction Unit)
TXN_REASON_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Transaction Reason)
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)
SUPPLY_AGREE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Supply Agreement Indicator)
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)
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
PRICE_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Price Type)
PRICE_BREAK_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Price Break Type)
PO_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Document Type)
PO_SUPPLIER_NOTE VARCHAR2 (480)
PO line note to supplier
PO_PRINT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Printed Date)
PO_LINE_TYPE_FK VARCHAR2 (80)
Foreign key to the PO Line Type dimension (Line Type)
PO_CREATE_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Purchase Creation Date)
PO_CLOSED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Status)
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)
NEG_BY_PREPARE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Negotiated by Preparer Indicator)
LNE_CREAT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Line Creation Date)
LNE_CLOSED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Line Status)
ITEM_REVISION_FK VARCHAR2 (320)
Foreign key to the Item dimension (Item Revision)
ITEM_DESCRIPTION VARCHAR2 (240)
Description for PO line item
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)
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)
CANCEL_REASON VARCHAR2 (240)
Reason for PO line cancellation
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)
BASE_UOM_FK VARCHAR2 (240)
Foreign key to the Unit of Measure dimension (Base Unit)
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)
Foreign key to the Lookup dimension (Approved Indicator)
APPROVED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Approval Date)
AGREE_LN_INST_PK VARCHAR2 (320)
Unique identifier
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
,      UNSPSC_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
,      UNIT_PRICE_T
,      UNIT_PRICE_G
,      TXN_UOM_FK_KEY
,      TXN_REASON_FK_KEY
,      TXN_CUR_DATE_FK_KEY
,      TXN_CUR_CODE_FK_KEY
,      SUP_SITE_GEOG_FK_KEY
,      SUPPLY_AGREE_FK_KEY
,      SUPPLIER_SITE_FK_KEY
,      SUPPLIER_ITEM_NUM_FK_KEY
,      START_DATE_FK_KEY
,      SHIP_VIA_FK_KEY
,      SHIP_LOCATION_FK_KEY
,      REVISED_DATE_FK_KEY
,      REQUEST_ID
,      QTY_RELEASED_T
,      QTY_ORDERED_T
,      QTY_MIN_ORDER_T
,      QTY_MAX_ORDER_T
,      QTY_AGREED_T
,      PRICE_TYPE_FK_KEY
,      PRICE_LIMIT_T
,      PRICE_LIMIT_G
,      PRICE_BREAK_FK_KEY
,      PO_TYPE_FK_KEY
,      PO_PRINT_DATE_FK_KEY
,      PO_LINE_TYPE_FK_KEY
,      PO_LINE_ID
,      PO_HEADER_ID
,      PO_CREATE_DATE_FK_KEY
,      PO_CLOSED_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      NEG_BY_PREPARE_FK_KEY
,      MARKET_PRICE_T
,      MARKET_PRICE_G
,      LNE_CREAT_DATE_FK_KEY
,      LNE_CLOSED_FK_KEY
,      LIST_PRICE_T
,      LIST_PRICE_G
,      ITEM_REVISION_FK_KEY
,      ITEM_ID
,      INSTANCE_FK_KEY
,      FROZEN_FK_KEY
,      FREIGHT_TERMS_FK_KEY
,      FOB_FK_KEY
,      END_DATE_FK_KEY
,      EDI_PROCESSED_FK_KEY
,      CONTRACT_EFFECTIVE_FK_KEY
,      CONFIRM_ORDER_FK_KEY
,      CANCELLED_FK_KEY
,      BUYER_FK_KEY
,      BILL_LOCATION_FK_KEY
,      BASE_UOM_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_AGREED_T
,      AMT_AGREED_G
,      ACCPT_REQUIRED_FK_KEY
,      ACCPT_DUE_DATE_FK_KEY
,      SIC_CODE_FK
,      UNSPSC_FK
,      DUNS_FK
,      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_UOM_FK
,      TXN_REASON_FK
,      TXN_CUR_RATE_TYPE
,      TXN_CUR_DATE_FK
,      TXN_CUR_CODE_FK
,      SUP_SITE_GEOG_FK
,      SUPPLY_AGREE_FK
,      SUPPLIER_SITE_FK
,      SUPPLIER_ITEM_NUM_FK
,      START_DATE_FK
,      SHIP_VIA_FK
,      SHIP_LOCATION_FK
,      ROW_ID
,      REVISED_DATE_FK
,      RECEIVER_NOTE
,      PRICE_TYPE_FK
,      PRICE_BREAK_FK
,      PO_TYPE_FK
,      PO_SUPPLIER_NOTE
,      PO_PRINT_DATE_FK
,      PO_LINE_TYPE_FK
,      PO_CREATE_DATE_FK
,      PO_CLOSED_FK
,      OPERATION_CODE
,      OPERATING_UNIT_FK
,      NEG_BY_PREPARE_FK
,      LNE_CREAT_DATE_FK
,      LNE_CLOSED_FK
,      ITEM_REVISION_FK
,      ITEM_DESCRIPTION
,      INSTANCE_FK
,      FROZEN_FK
,      FREIGHT_TERMS_FK
,      FOB_FK
,      ERROR_CODE
,      END_DATE_FK
,      EDI_PROCESSED_FK
,      CONTRACT_EFFECTIVE_FK
,      CONFIRM_ORDER_FK
,      COMMENTS
,      COLLECTION_STATUS
,      CANCEL_REASON
,      CANCELLED_FK
,      BUYER_FK
,      BILL_LOCATION_FK
,      BASE_UOM_FK
,      AP_TERMS_FK
,      APPROVER_FK
,      APPROVED_FK
,      APPROVED_DATE_FK
,      AGREE_LN_INST_PK
,      ACCPT_REQUIRED_FK
,      ACCPT_DUE_DATE_FK
FROM POA.POA_EDW_ALINES_FSTG;

Dependencies

[top of page]

POA.POA_EDW_ALINES_FSTG does not reference any database object

POA.POA_EDW_ALINES_FSTG is referenced by following:

SchemaAPPS
SynonymPOA_EDW_ALINES_FSTG