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

TABLE: POA.POA_EDW_PO_DIST_FSTG

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


This is the interface table for the PO Distributions 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
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)
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)
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 the 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
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_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_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)
SUPPLIER_SITE_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Supplier Site)
SUPPLIER_ITEM_FK_KEY NUMBER

System generated foreign key to the Supplier Item dimension (Supplier Item Number)
SUB_RECEIPT_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Allow Substitute Receipts Indicator)
SOURCE_DIST_ID NUMBER

Planner PO Distribution identifier referenced in creating the scheduled release distribution
SOB_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (Set of Books)
SHP_TAXABLE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Shipment Taxable Indicator)
SHP_SRC_SHIP_ID NUMBER

Planned PO Shipment identifier referenced in creating the scheduled release shipment
SHP_CREAT_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Source Shipment Creation Date)
SHP_CLOSED_FK_KEY NUMBER

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

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

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

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

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

System generated foreign key to the Internal Organization dimension (Ship To Organization)
SHIP_LOCATION_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Shipment Type)
REVISION_NUM NUMBER

PO revision number
REVISED_DATE_FK_KEY NUMBER

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

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

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

Identifier used by collection program
RELEASE_NUM NUMBER

Blanket Agreement or Planned Purchase Order release number
RELEASE_HOLD_FK_KEY NUMBER

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

System generated foreign key to the Time dimension (Release Date)
RECEIPT_REQ_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Receipt Required Indicator)
RCV_ROUTING_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Receipt Routing)
QTY_ORDERED_B NUMBER

Quantity ordered
QTY_DELIVERED_B NUMBER

Quantity delivered
QTY_CANCELLED_B NUMBER

Quantity cancelled
QTY_BILLED_B NUMBER

Quantity billed
PURCH_CLASS_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Purchase Classification)
PROMISED_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Promised Date)
PRINTED_DATE_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Price Type)
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
PRICE_BREAK_FK_KEY NUMBER

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

Blanket Agreement or Planned Purchase Order release identifier
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
PO_HEADER_ID NUMBER

Purchase order header identifier
PO_CREATE_DATE_FK_KEY NUMBER

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

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

System generated foreign key to the Time dimension (Acceptance Date)
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
PCARD_PROCESS_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (PCard Processed Indicator)
ONLINE_REQ_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Online Requisition Indicator)
NEG_BY_PREPARE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Negotiated by Preparer Indicator)
NEED_BY_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Need By Date)
MARKET_PRICE_T NUMBER

Market unit price in transactional currency
MARKET_PRICE_G NUMBER

Market unit price in warehouse currency
LST_ACCPT_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Latest Acceptable Receipt Date)
LNE_CREAT_DATE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Line Creation Date)
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
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)
INSPECTION_REQ_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Inspection Required Indicator)
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)
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)
EDI_PROCESSED_FK_KEY NUMBER

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

System generated foreign key to the Lookup dimension (Distribution Encumbered Indicator)
DST_CREAT_DATE_FK_KEY NUMBER

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

PO distribution identifier
DESTIN_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Destination Type)
DESTIN_ORG_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Destination Organization)
DELIV_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Deliver To Location)
DELIVER_TO_FK_KEY NUMBER

System generated foreign key to the Person dimension (Requestor)
CONTRACT_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Contract Type)
CONFIRM_ORDER_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Confirming Order 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)
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
ACCRUED_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Accrued Indicator)
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)
TASK_FK VARCHAR2 (120)
Foreign key to the Project dimension (Task)
APPRV_SUPPLIER_FK VARCHAR2 (120)
Foreign key to the Lookup dimension (Approved Supplier Indicator)
GOODS_RECEIVED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Receipt Date)
INV_CREATION_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Invoice Date)
INV_RECEIVED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Invoice Received Date)
CHECK_CUT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Check Cut 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_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_REASON_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Transaction Reason)
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
SUPPLIER_ITEM_FK VARCHAR2 (480)
Foreign key to the Supplier Item dimension (Supplier Item Number)
SUB_RECEIPT_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Allow Substitute Receipts Indicator)
SOB_FK VARCHAR2 (80)
Foreign key to the Set of Books dimension (Set of Books)
SHP_TAXABLE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Shipment Taxable Indicator)
SHP_CREAT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Source Shipment Creation Date)
SHP_CLOSED_REASON VARCHAR2 (240)
Reason for PO shipment close
SHP_CLOSED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Shipment Status)
SHP_CANCEL_REASON VARCHAR2 (240)
Reason for PO shipment cancellation
SHP_CANCELLED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Shipment Cancelled Indicator)
SHP_APP_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Shipment Approval Date)
SHP_APPROVED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Shipment Approved Indicator)
SHIP_VIA_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Ship Method)
SHIP_TO_ORG_FK VARCHAR2 (320)
Foreign key to the Internal Organization dimension (Ship To Organization)
SHIP_LOCATION_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Ship To Location)
SHIPMENT_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Shipment Type)
ROW_ID ROWID (10)
Row identifier
REVISED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Revised Date)
REQ_CREAT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Requisition Creation Date)
REQ_APPRV_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Requisition Approval Date)
RELEASE_HOLD_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Hold Indicator)
RELEASE_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Release Date)
RECEIPT_REQ_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Receipt Required Indicator)
RCV_ROUTING_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Receipt Routing)
PURCH_CLASS_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Purchase Classification)
PROMISED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Promised Date)
PRINTED_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Printed Date)
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_RECEIVER_NOTE VARCHAR2 (480)
Purchase Order note to receiver
PO_NUMBER VARCHAR2 (20)
PO number assigned in source database
PO_LINE_TYPE_FK VARCHAR2 (80)
Foreign key to the PO Line Type dimension (Line Type)
PO_DIST_INST_PK VARCHAR2 (320)
System generated unique identifier
PO_CREATE_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Purchase Creation Date)
PO_COMMENTS VARCHAR2 (240)
Purchase Order Comments
PO_APP_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Approval Date)
PO_ACCEPT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Acceptance Date)
PCARD_PROCESS_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (PCard Processed Indicator)
OPERATION_CODE VARCHAR2 (30)
Code used by the loader program to determine whether to insert/update/delete this record
ONLINE_REQ_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Online Requisition Indicator)
NEG_BY_PREPARE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Negotiated by Preparer Indicator)
NEED_BY_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Need By Date)
LST_ACCPT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Latest Acceptable Receipt Date)
LNE_SUPPLIER_NOTE VARCHAR2 (480)
Line note to supplier
LNE_CREAT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Line Creation Date)
ITEM_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)
INSPECTION_REQ_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Inspection Required Indicator)
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
EDW_UOM_FK VARCHAR2 (80)
Foreign key to the Unit of Measure dimension (Transaction Unit)
EDW_BASE_UOM_FK VARCHAR2 (240)
Foreign key to the Unit of Measure dimension (Base Unit)
EDI_PROCESSED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (EDI Processed Indicator)
DST_ENCUMB_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Distribution Encumbered Indicator)
DST_CREAT_DATE_FK VARCHAR2 (120)
Foreign key to the Time dimension (Distribution Creation Date)
DESTIN_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Destination Type)
DESTIN_ORG_FK VARCHAR2 (320)
Foreign key to the Internal Organization dimension (Destination Organization)
DELIV_LOCATION_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Deliver To Location)
DELIVER_TO_FK VARCHAR2 (1000)
Foreign key to the Person dimension (Requestor)
CONTRACT_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Contract Type)
CONTRACT_NUM VARCHAR2 (40)
PO number assigned in source database for Blanket Agreements
CONFIRM_ORDER_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Confirming Order Indicator)
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)
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)
ACCRUED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Accrued Indicator)
ACCPT_REQUIRED_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Acceptance Required Indicator)
ACCPT_DUE_DATE_FK VARCHAR2 (240)
Foreign key to the Time dimension (Acceptance Due Date)
Query Text

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


SELECT TASK_FK_KEY
,      APPRV_SUPPLIER_FK_KEY
,      GOODS_RECEIVED_DATE_FK_KEY
,      INV_CREATION_DATE_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
,      SIC_CODE_FK_KEY
,      UNSPSC_FK_KEY
,      DUNS_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_REASON_FK_KEY
,      TXN_CUR_DATE_FK_KEY
,      TXN_CUR_CODE_FK_KEY
,      SUP_SITE_GEOG_FK_KEY
,      SUPPLIER_SITE_FK_KEY
,      SUPPLIER_ITEM_FK_KEY
,      SUB_RECEIPT_FK_KEY
,      SOURCE_DIST_ID
,      SOB_FK_KEY
,      SHP_TAXABLE_FK_KEY
,      SHP_SRC_SHIP_ID
,      SHP_CREAT_DATE_FK_KEY
,      SHP_CLOSED_FK_KEY
,      SHP_CANCELLED_FK_KEY
,      SHP_APP_DATE_FK_KEY
,      SHP_APPROVED_FK_KEY
,      SHIP_VIA_FK_KEY
,      SHIP_TO_ORG_FK_KEY
,      SHIP_LOCATION_FK_KEY
,      SHIPMENT_TYPE_FK_KEY
,      REVISION_NUM
,      REVISED_DATE_FK_KEY
,      REQ_CREAT_DATE_FK_KEY
,      REQ_APPRV_DATE_FK_KEY
,      REQUEST_ID
,      RELEASE_NUM
,      RELEASE_HOLD_FK_KEY
,      RELEASE_DATE_FK_KEY
,      RECEIPT_REQ_FK_KEY
,      RCV_ROUTING_FK_KEY
,      QTY_ORDERED_B
,      QTY_DELIVERED_B
,      QTY_CANCELLED_B
,      QTY_BILLED_B
,      PURCH_CLASS_FK_KEY
,      PROMISED_DATE_FK_KEY
,      PRINTED_DATE_FK_KEY
,      PRICE_TYPE_FK_KEY
,      PRICE_T
,      PRICE_LIMIT_T
,      PRICE_LIMIT_G
,      PRICE_G
,      PRICE_BREAK_FK_KEY
,      PO_RELEASE_ID
,      PO_LINE_TYPE_FK_KEY
,      PO_LINE_ID
,      PO_HEADER_ID
,      PO_CREATE_DATE_FK_KEY
,      PO_APP_DATE_FK_KEY
,      PO_ACCEPT_DATE_FK_KEY
,      POTENTIAL_SVG_T
,      POTENTIAL_SVG_G
,      PCARD_PROCESS_FK_KEY
,      ONLINE_REQ_FK_KEY
,      NEG_BY_PREPARE_FK_KEY
,      NEED_BY_DATE_FK_KEY
,      MARKET_PRICE_T
,      MARKET_PRICE_G
,      LST_ACCPT_DATE_FK_KEY
,      LNE_CREAT_DATE_FK_KEY
,      LIST_PRC_UNIT_T
,      LIST_PRC_UNIT_G
,      LINE_LOCATION_ID
,      ITEM_ID
,      ITEM_FK_KEY
,      INSTANCE_FK_KEY
,      INSPECTION_REQ_FK_KEY
,      FROZEN_FK_KEY
,      FREIGHT_TERMS_FK_KEY
,      FOB_FK_KEY
,      EDW_UOM_FK_KEY
,      EDW_BASE_UOM_FK_KEY
,      EDI_PROCESSED_FK_KEY
,      DST_ENCUMB_FK_KEY
,      DST_CREAT_DATE_FK_KEY
,      DESTRIBUTION_ID
,      DESTIN_TYPE_FK_KEY
,      DESTIN_ORG_FK_KEY
,      DELIV_LOCATION_FK_KEY
,      DELIVER_TO_FK_KEY
,      CONTRACT_TYPE_FK_KEY
,      CONFIRM_ORDER_FK_KEY
,      BUYER_FK_KEY
,      BILL_LOCATION_FK_KEY
,      AP_TERMS_FK_KEY
,      APPROVER_FK_KEY
,      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
,      ACCRUED_FK_KEY
,      ACCPT_REQUIRED_FK_KEY
,      ACCPT_DUE_DATE_FK_KEY
,      TASK_FK
,      APPRV_SUPPLIER_FK
,      GOODS_RECEIVED_DATE_FK
,      INV_CREATION_DATE_FK
,      INV_RECEIVED_DATE_FK
,      CHECK_CUT_DATE_FK
,      SIC_CODE_FK
,      UNSPSC_FK
,      DUNS_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_REASON_FK
,      TXN_CUR_DATE_FK
,      TXN_CUR_CODE_FK
,      SUP_SITE_GEOG_FK
,      SUPPLIER_SITE_FK
,      SUPPLIER_NOTE
,      SUPPLIER_ITEM_FK
,      SUB_RECEIPT_FK
,      SOB_FK
,      SHP_TAXABLE_FK
,      SHP_CREAT_DATE_FK
,      SHP_CLOSED_REASON
,      SHP_CLOSED_FK
,      SHP_CANCEL_REASON
,      SHP_CANCELLED_FK
,      SHP_APP_DATE_FK
,      SHP_APPROVED_FK
,      SHIP_VIA_FK
,      SHIP_TO_ORG_FK
,      SHIP_LOCATION_FK
,      SHIPMENT_TYPE_FK
,      ROW_ID
,      REVISED_DATE_FK
,      REQ_CREAT_DATE_FK
,      REQ_APPRV_DATE_FK
,      RELEASE_HOLD_FK
,      RELEASE_DATE_FK
,      RECEIPT_REQ_FK
,      RCV_ROUTING_FK
,      PURCH_CLASS_FK
,      PROMISED_DATE_FK
,      PRINTED_DATE_FK
,      PRICE_TYPE_FK
,      PRICE_BREAK_FK
,      PO_RECEIVER_NOTE
,      PO_NUMBER
,      PO_LINE_TYPE_FK
,      PO_DIST_INST_PK
,      PO_CREATE_DATE_FK
,      PO_COMMENTS
,      PO_APP_DATE_FK
,      PO_ACCEPT_DATE_FK
,      PCARD_PROCESS_FK
,      OPERATION_CODE
,      ONLINE_REQ_FK
,      NEG_BY_PREPARE_FK
,      NEED_BY_DATE_FK
,      LST_ACCPT_DATE_FK
,      LNE_SUPPLIER_NOTE
,      LNE_CREAT_DATE_FK
,      ITEM_FK
,      ITEM_DESCRIPTION
,      INSTANCE_FK
,      INSPECTION_REQ_FK
,      FROZEN_FK
,      FREIGHT_TERMS_FK
,      FOB_FK
,      ERROR_CODE
,      EDW_UOM_FK
,      EDW_BASE_UOM_FK
,      EDI_PROCESSED_FK
,      DST_ENCUMB_FK
,      DST_CREAT_DATE_FK
,      DESTIN_TYPE_FK
,      DESTIN_ORG_FK
,      DELIV_LOCATION_FK
,      DELIVER_TO_FK
,      CONTRACT_TYPE_FK
,      CONTRACT_NUM
,      CONFIRM_ORDER_FK
,      COLLECTION_STATUS
,      BUYER_FK
,      BILL_LOCATION_FK
,      AP_TERMS_FK
,      APPROVER_FK
,      ACCRUED_FK
,      ACCPT_REQUIRED_FK
,      ACCPT_DUE_DATE_FK
FROM POA.POA_EDW_PO_DIST_FSTG;

Dependencies

[top of page]

POA.POA_EDW_PO_DIST_FSTG does not reference any database object

POA.POA_EDW_PO_DIST_FSTG is referenced by following:

SchemaAPPS
SynonymPOA_EDW_PO_DIST_FSTG