[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_PO_DIST_F |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.POA_EDW_PO_DIST_F |
Subobject Name: | |
Status: | VALID |
The PO Distribution fact contains data for all approved purchase orders. For Oracle Applications users, this includes standard purchase orders, releases against blanket agreements, and scheduled releases against planned purchase orders.
The data in this fact table is stored at the purchase order distribution level, which is the lowest level of detail. Only approved purchase orders and releases are collected. The analyses that can be done using this fact table include spend distribution, contract leakage, new contract opportunities, supplier performance, supplier consolidation, purchase order approval cycle time, and delivery of goods received cycle time.
Some of the measures available in his fact table include: Purchases, Contract Purchases, Non-Contract Purchases, Leakage, Potential Savings, Amount Billed, Quantity Billed, Price, Market Price, List Price, Quantity Ordered, Quantity Delivered, and Quantity Cancelled. Some of the attributes available are: Item Description and Purchase Order Number.
The data in this fact table can be aggregated by the following dimensions: Time, Item, Trading Partner, Geography, Internal Organization, Set of Books, Person, Purchase Order Type, PO Line Type, Supplier Item Number, Instance, Currency, and Unit of Measure.
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_PO_DIST_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | PO_DIST_INST_PK |
POA_EDW_PO_DIST_F_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | AP_TERMS_FK_KEY |
POA_EDW_PO_DIST_F_N10 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BUYER_FK_KEY |
POA_EDW_PO_DIST_F_N11 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DELIVER_TO_FK_KEY |
POA_EDW_PO_DIST_F_N12 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPROVER_FK_KEY |
POA_EDW_PO_DIST_F_N13 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSTANCE_FK_KEY |
POA_EDW_PO_DIST_F_N14 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ITEM_FK_KEY |
POA_EDW_PO_DIST_F_N15 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIPMENT_TYPE_FK_KEY |
POA_EDW_PO_DIST_F_N16 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_VIA_FK_KEY |
POA_EDW_PO_DIST_F_N17 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | RCV_ROUTING_FK_KEY |
POA_EDW_PO_DIST_F_N18 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ACCPT_REQUIRED_FK_KEY |
POA_EDW_PO_DIST_F_N19 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FROZEN_FK_KEY |
POA_EDW_PO_DIST_F_N2 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_CUR_CODE_FK_KEY |
POA_EDW_PO_DIST_F_N20 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | RELEASE_HOLD_FK_KEY |
POA_EDW_PO_DIST_F_N21 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CONFIRM_ORDER_FK_KEY |
POA_EDW_PO_DIST_F_N22 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | NEG_BY_PREPARE_FK_KEY |
POA_EDW_PO_DIST_F_N23 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUB_RECEIPT_FK_KEY |
POA_EDW_PO_DIST_F_N24 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHP_APPROVED_FK_KEY |
POA_EDW_PO_DIST_F_N25 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHP_CANCELLED_FK_KEY |
POA_EDW_PO_DIST_F_N26 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSPECTION_REQ_FK_KEY |
POA_EDW_PO_DIST_F_N27 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FOB_FK_KEY |
POA_EDW_PO_DIST_F_N28 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | RECEIPT_REQ_FK_KEY |
POA_EDW_PO_DIST_F_N29 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ACCRUED_FK_KEY |
POA_EDW_PO_DIST_F_N3 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | EDW_BASE_UOM_FK_KEY |
POA_EDW_PO_DIST_F_N30 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DST_ENCUMB_FK_KEY |
POA_EDW_PO_DIST_F_N31 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ONLINE_REQ_FK_KEY |
POA_EDW_PO_DIST_F_N32 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHP_TAXABLE_FK_KEY |
POA_EDW_PO_DIST_F_N33 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | EDI_PROCESSED_FK_KEY |
POA_EDW_PO_DIST_F_N34 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PCARD_PROCESS_FK_KEY |
POA_EDW_PO_DIST_F_N35 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PURCH_CLASS_FK_KEY |
POA_EDW_PO_DIST_F_N36 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | FREIGHT_TERMS_FK_KEY |
POA_EDW_PO_DIST_F_N37 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_REASON_FK_KEY |
POA_EDW_PO_DIST_F_N38 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PRICE_TYPE_FK_KEY |
POA_EDW_PO_DIST_F_N39 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PRICE_BREAK_FK_KEY |
POA_EDW_PO_DIST_F_N4 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | EDW_UOM_FK_KEY |
POA_EDW_PO_DIST_F_N40 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHP_CLOSED_FK_KEY |
POA_EDW_PO_DIST_F_N41 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DESTIN_TYPE_FK_KEY |
POA_EDW_PO_DIST_F_N42 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CONTRACT_TYPE_FK_KEY |
POA_EDW_PO_DIST_F_N43 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DESTIN_ORG_FK_KEY |
POA_EDW_PO_DIST_F_N44 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_TO_ORG_FK_KEY |
POA_EDW_PO_DIST_F_N45 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_LINE_TYPE_FK_KEY |
POA_EDW_PO_DIST_F_N46 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_ITEM_FK_KEY |
POA_EDW_PO_DIST_F_N47 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_CREATE_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N48 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | LNE_CREAT_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N49 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | NEED_BY_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N5 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SOB_FK_KEY |
POA_EDW_PO_DIST_F_N50 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PROMISED_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N51 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PRINTED_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N52 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TXN_CUR_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N53 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | REQ_CREAT_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N54 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | REQ_APPRV_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N55 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_ACCEPT_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N56 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHP_CREAT_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N57 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DST_CREAT_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N58 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | PO_APP_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N59 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | REVISED_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N6 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHIP_LOCATION_FK_KEY |
POA_EDW_PO_DIST_F_N60 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | ACCPT_DUE_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N61 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | RELEASE_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N62 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SHP_APP_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N63 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | LST_ACCPT_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N64 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_SITE_FK_KEY |
POA_EDW_PO_DIST_F_N65 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INV_CREATION_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N66 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | GOODS_RECEIVED_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N67 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | UNSPSC_FK_KEY |
POA_EDW_PO_DIST_F_N68 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SIC_CODE_FK_KEY |
POA_EDW_PO_DIST_F_N69 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DUNS_FK_KEY |
POA_EDW_PO_DIST_F_N7 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DELIV_LOCATION_FK_KEY |
POA_EDW_PO_DIST_F_N70 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CHECK_CUT_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N71 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INV_RECEIVED_DATE_FK_KEY |
POA_EDW_PO_DIST_F_N72 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | APPRV_SUPPLIER_FK_KEY |
POA_EDW_PO_DIST_F_N73 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | TASK_FK_KEY |
POA_EDW_PO_DIST_F_N8 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SUP_SITE_GEOG_FK_KEY |
POA_EDW_PO_DIST_F_N9 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BILL_LOCATION_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_FK_KEY | NUMBER | System generated foreign key to the Project dimension (Task) | ||
APPRV_SUPPLIER_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Approved Supplier Indicator) | ||
INV_RECEIVED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Invoice Received Date) | ||
CHECK_CUT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Check Cut Date) | ||
IPV_G | NUMBER | The difference in total amount, in the warehouse currency, between the purchase order distribution amount and its invoice, due to variance in the unit price. | ||
IPV_T | NUMBER | The difference in total amount, in the transactional currency, between the purchase order distribution amount and its invoice, due to variance in the unit price. | ||
INV_TO_PAY_CYCLE_TIME | NUMBER | The Invoice to Pay cycle time is the number of days from the time the invoice was received until the time the payment was sent. | ||
INV_CREATION_CYCLE_TIME | NUMBER | The Invoice Creation cycle time is the number of days from the time the invoice was received until the time the invoice was created. | ||
RECEIVE_TO_PAY_CYCL_TIME | NUMBER | The Receive to Pay cycle time is the number of days from the time the goods were first received until the time payment was sent | ||
ORDER_TO_PAY_CYCLE_TIME | NUMBER | The Order to Pay cycle time is the number of days from the time the purchase order was approved until the time the payment was sent | ||
PO_CREATION_CYCLE_TIME | NUMBER | The PO Approval cycle time is the number of days from the time the purchase order was created until the time the purchase order was approved | ||
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) | ||
GOODS_RECEIVED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Receipt Date) | ||
INV_CREATION_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Invoice Date) | ||
SUPPLIER_SITE_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Supplier Site) | ||
LST_ACCPT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Latest Acceptable Receipt Date) | ||
SHP_APP_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Shipment Approval Date) | ||
RELEASE_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Release 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) | ||
PO_APP_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Approval Date) | ||
DST_CREAT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Distribution Creation Date) | ||
SHP_CREAT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Source Shipment Creation Date) | ||
PO_ACCEPT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Acceptance Date) | ||
REQ_APPRV_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Requisition Approval Date) | ||
REQ_CREAT_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Requisition Creation Date) | ||
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) | ||
PROMISED_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Promised Date) | ||
NEED_BY_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Need By 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_FK_KEY | NUMBER | System generated foreign key to the Supplier Item dimension (Supplier Item Number) | ||
PO_LINE_TYPE_FK_KEY | NUMBER | System generated foreign key to the PO Line Type dimension (Line Type) | ||
SHIP_TO_ORG_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Ship To Organization) | ||
DESTIN_ORG_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Destination Organization) | ||
CONTRACT_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Contract Type) | ||
DESTIN_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Destination Type) | ||
SHP_CLOSED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Shipment Status) | ||
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) | ||
PURCH_CLASS_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Purchase Classification) | ||
PCARD_PROCESS_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (PCard Processed Indicator) | ||
EDI_PROCESSED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (EDI Processed Indicator) | ||
SHP_TAXABLE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Shipment Taxable Indicator) | ||
ONLINE_REQ_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Online Requisition Indicator) | ||
DST_ENCUMB_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Distribution Encumbered Indicator) | ||
ACCRUED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Accrued Indicator) | ||
RECEIPT_REQ_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Receipt Required Indicator) | ||
FOB_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (FOB Term) | ||
INSPECTION_REQ_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Inspection Required Indicator) | ||
SHP_CANCELLED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Shipment Cancelled Indicator) | ||
SHP_APPROVED_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Shipment Approved Indicator) | ||
SUB_RECEIPT_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Allow Substitute Receipts 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) | ||
RELEASE_HOLD_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Hold 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) | ||
RCV_ROUTING_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Receipt Routing) | ||
SHIP_VIA_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Ship Method) | ||
SHIPMENT_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Shipment Type) | ||
ITEM_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) | ||
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) | ||
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) | ||
DELIV_LOCATION_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Deliver To Location) | ||
SHIP_LOCATION_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Ship To Location) | ||
SOB_FK_KEY | NUMBER | System generated foreign key to the Set of Books dimension (Set of Books) | ||
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) | ||
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 | ||
SOURCE_DIST_ID | NUMBER | Planned PO distribution identifier referenced in creating the scheduled release distribution | ||
SHP_SRC_SHIP_ID | NUMBER | Planned PO shipment identifier referenced in creating the scheduled release shipment | ||
REVISION_NUM | NUMBER | PO revision number | ||
RELEASE_NUM | NUMBER | Blanket Agreement or Planned Purchase Order release number | ||
QTY_ORDERED_B | NUMBER | Quantity ordered | ||
QTY_DELIVERED_B | NUMBER | Quantity delivered | ||
QTY_CANCELLED_B | NUMBER | Quantity cancelled | ||
QTY_BILLED_B | NUMBER | Quantity billed | ||
PRICE_T | NUMBER | Unit price for purchase order line item in transactional currency | ||
PRICE_LIMIT_T | NUMBER | PO line item unit price limit in transactional currency | ||
PRICE_LIMIT_G | NUMBER | PO line item unit price limit in warehouse currency | ||
PRICE_G | NUMBER | Unit price for purchase order line item in warehouse currency | ||
PO_RELEASE_ID | NUMBER | Blanket Agreement or Planned Purchase Order release identifier | ||
PO_LINE_ID | NUMBER | Purchase order line identifier | ||
PO_HEADER_ID | NUMBER | Purchase order header identifier | ||
PO_DIST_INST_PK_KEY | NUMBER | System generated unique identifier | ||
POTENTIAL_SVG_T | NUMBER | Savings that would have resulted, in the transactional currency, if the purchase had been made using established contracts | ||
POTENTIAL_SVG_G | NUMBER | Savings that would have resulted, in the warehouse currency, if the purchase had been made using established contracts | ||
MARKET_PRICE_T | NUMBER | Market unit price in transactional currency | ||
MARKET_PRICE_G | NUMBER | Market unit price in warehouse currency | ||
LIST_PRC_UNIT_T | NUMBER | List unit price in transactional currency | ||
LIST_PRC_UNIT_G | NUMBER | List unit price in warehouse currency | ||
LINE_LOCATION_ID | NUMBER | PO shipment identifier | ||
ITEM_ID | NUMBER | Line item identifier | ||
DISTRIBUTION_ID | NUMBER | PO distribution identifier | ||
AMT_PURCHASED_T | NUMBER | Amount purchased, in the transactional currency | ||
AMT_PURCHASED_G | NUMBER | Amount purchased, in the warehouse currency | ||
AMT_NONCONTRACT_T | NUMBER | Amount purchased, in the transactional currency, where no contract could have been used for the item or commodity purchased | ||
AMT_NONCONTRACT_G | NUMBER | Amount purchased, in the warehouse currency, where no contract could have been used for the item or commodity purchased | ||
AMT_LEAKAGE_T | NUMBER | Amount purchased, in the transactional currency, where a contract could have been used, but was not | ||
AMT_LEAKAGE_G | NUMBER | Amount purchased, in the warehouse currency, where a contract could have been used, but was not | ||
AMT_CONTRACT_T | NUMBER | Amount purchased, in the transactional currency, using a contract | ||
AMT_CONTRACT_G | NUMBER | Amount purchased, in the warehouse currency, using a contract | ||
AMT_BILLED_T | NUMBER | Amount billed, in the transactional currency | ||
AMT_BILLED_G | NUMBER | Amount billed, in the warehouse currency | ||
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 | |
SUPPLIER_NOTE | VARCHAR2 | (480) | Purchase Order note to supplier | |
SHP_CLOSED_REASON | VARCHAR2 | (240) | Reason for PO shipment close | |
SHP_CANCEL_REASON | VARCHAR2 | (240) | Reason for PO shipment cancellation | |
PO_RECEIVER_NOTE | VARCHAR2 | (480) | Purchase Order note to receiver | |
PO_NUMBER | VARCHAR2 | (20) | PO number assigned in source database | |
PO_DIST_INST_PK | VARCHAR2 | (320) | System generated unique identifier | |
PO_COMMENTS | VARCHAR2 | (240) | Purchase Order comments | |
LNE_SUPPLIER_NOTE | VARCHAR2 | (480) | PO line note to supplier | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Description for PO line item | |
CONTRACT_NUM | VARCHAR2 | (40) | PO number assigned in source database for Blanket Agreements | |
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 TASK_FK_KEY
, APPRV_SUPPLIER_FK_KEY
, INV_RECEIVED_DATE_FK_KEY
, CHECK_CUT_DATE_FK_KEY
, IPV_G
, IPV_T
, INV_TO_PAY_CYCLE_TIME
, INV_CREATION_CYCLE_TIME
, RECEIVE_TO_PAY_CYCL_TIME
, ORDER_TO_PAY_CYCLE_TIME
, PO_CREATION_CYCLE_TIME
, DUNS_FK_KEY
, SIC_CODE_FK_KEY
, UNSPSC_FK_KEY
, GOODS_RECEIVED_DATE_FK_KEY
, INV_CREATION_DATE_FK_KEY
, SUPPLIER_SITE_FK_KEY
, LST_ACCPT_DATE_FK_KEY
, SHP_APP_DATE_FK_KEY
, RELEASE_DATE_FK_KEY
, ACCPT_DUE_DATE_FK_KEY
, REVISED_DATE_FK_KEY
, PO_APP_DATE_FK_KEY
, DST_CREAT_DATE_FK_KEY
, SHP_CREAT_DATE_FK_KEY
, PO_ACCEPT_DATE_FK_KEY
, REQ_APPRV_DATE_FK_KEY
, REQ_CREAT_DATE_FK_KEY
, TXN_CUR_DATE_FK_KEY
, PRINTED_DATE_FK_KEY
, PROMISED_DATE_FK_KEY
, NEED_BY_DATE_FK_KEY
, LNE_CREAT_DATE_FK_KEY
, PO_CREATE_DATE_FK_KEY
, SUPPLIER_ITEM_FK_KEY
, PO_LINE_TYPE_FK_KEY
, SHIP_TO_ORG_FK_KEY
, DESTIN_ORG_FK_KEY
, CONTRACT_TYPE_FK_KEY
, DESTIN_TYPE_FK_KEY
, SHP_CLOSED_FK_KEY
, PRICE_BREAK_FK_KEY
, PRICE_TYPE_FK_KEY
, TXN_REASON_FK_KEY
, FREIGHT_TERMS_FK_KEY
, PURCH_CLASS_FK_KEY
, PCARD_PROCESS_FK_KEY
, EDI_PROCESSED_FK_KEY
, SHP_TAXABLE_FK_KEY
, ONLINE_REQ_FK_KEY
, DST_ENCUMB_FK_KEY
, ACCRUED_FK_KEY
, RECEIPT_REQ_FK_KEY
, FOB_FK_KEY
, INSPECTION_REQ_FK_KEY
, SHP_CANCELLED_FK_KEY
, SHP_APPROVED_FK_KEY
, SUB_RECEIPT_FK_KEY
, NEG_BY_PREPARE_FK_KEY
, CONFIRM_ORDER_FK_KEY
, RELEASE_HOLD_FK_KEY
, FROZEN_FK_KEY
, ACCPT_REQUIRED_FK_KEY
, RCV_ROUTING_FK_KEY
, SHIP_VIA_FK_KEY
, SHIPMENT_TYPE_FK_KEY
, ITEM_FK_KEY
, INSTANCE_FK_KEY
, APPROVER_FK_KEY
, DELIVER_TO_FK_KEY
, BUYER_FK_KEY
, BILL_LOCATION_FK_KEY
, SUP_SITE_GEOG_FK_KEY
, DELIV_LOCATION_FK_KEY
, SHIP_LOCATION_FK_KEY
, SOB_FK_KEY
, EDW_UOM_FK_KEY
, EDW_BASE_UOM_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
, SOURCE_DIST_ID
, SHP_SRC_SHIP_ID
, REVISION_NUM
, RELEASE_NUM
, QTY_ORDERED_B
, QTY_DELIVERED_B
, QTY_CANCELLED_B
, QTY_BILLED_B
, PRICE_T
, PRICE_LIMIT_T
, PRICE_LIMIT_G
, PRICE_G
, PO_RELEASE_ID
, PO_LINE_ID
, PO_HEADER_ID
, PO_DIST_INST_PK_KEY
, POTENTIAL_SVG_T
, POTENTIAL_SVG_G
, MARKET_PRICE_T
, MARKET_PRICE_G
, LIST_PRC_UNIT_T
, LIST_PRC_UNIT_G
, LINE_LOCATION_ID
, ITEM_ID
, DISTRIBUTION_ID
, AMT_PURCHASED_T
, AMT_PURCHASED_G
, AMT_NONCONTRACT_T
, AMT_NONCONTRACT_G
, AMT_LEAKAGE_T
, AMT_LEAKAGE_G
, AMT_CONTRACT_T
, AMT_CONTRACT_G
, AMT_BILLED_T
, AMT_BILLED_G
, 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
, SUPPLIER_NOTE
, SHP_CLOSED_REASON
, SHP_CANCEL_REASON
, PO_RECEIVER_NOTE
, PO_NUMBER
, PO_DIST_INST_PK
, PO_COMMENTS
, LNE_SUPPLIER_NOTE
, ITEM_DESCRIPTION
, CONTRACT_NUM
, LAST_UPDATE_DATE
, CREATION_DATE
FROM POA.POA_EDW_PO_DIST_F;
POA.POA_EDW_PO_DIST_F does not reference any database object
POA.POA_EDW_PO_DIST_F is referenced by following:
|
|
|