DW_PURCHASE_ORDER_VERSIONS_CF

This table contains version details of all Submitted Purchase Orders and Change Orders for Purchase Orders

Details

Module: Purchasing

Key Columns

PO_VERSION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PO_VERSION_ID NUMBER 38 0 True Purchase Order Version identifier
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier
PO_HEADER_ID NUMBER 38 0 Purchase Order Header identifier
PURCHASE_ORDER_NUMBER VARCHAR2 32 Purchase Order Number
PROCUREMENT_BU_ID NUMBER 38 0 Procurement Business Unit identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
PROCUREMENT_LEDGER_ID NUMBER 38 0 Primary Ledger ID of Procurement Business Unit DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name #1 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type #1 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
CHANGE_ORDER_NUMBER VARCHAR2 128 Change Order Number
CHANGE_ORDER_SEQUENCE NUMBER Change Order Sequence
REVISION_NUMBER NUMBER Revision of the document when the change order is applied
CHANGE_ORDER_DESCRIPTION VARCHAR2 999 Change Order Description
CHANGE_ORDER_STATUS_CODE VARCHAR2 32 Status of the change order DW_CHANGE_ORDER_STATUS_LKP_TL CHANGE_ORDER_STATUS_CODE
INITIATING_PARTY_TYPE_CODE VARCHAR2 32 Type of the role initiating the change DW_INITIATING_PARTY_LKP_TL INITIATING_PARTY_CODE
INITIATING_PERSON_ID NUMBER 38 0 Identifier of the person initiating the change order DW_PERSON_NAME_CURRENT_D PERSON_ID
INITIATING_SUPPLIER_PARTY_ID NUMBER 38 0 Identifier of the supplier initiating the change order DW_PARTY_D PARTY_ID
SUBMITTED_TIMESTAMP TIMESTAMP Timestamp when the document version is submitted for approval
SUBMITTED_DATE DATE Date when the document version is submitted for approval DW_DAY_D CALENDAR_DATE
REJECTED_FLAG VARCHAR2 16 Flag indicating whether the document version was rejected
WITHDRAWN_FLAG VARCHAR2 16 Flag indicating whether the document version was withdrawn
CANCELED_FLAG VARCHAR2 16 Flag indicating whether the document version was canceled
DOCUMENT_CANCELED_FLAG VARCHAR2 16 The value is set to Y if the change order is created for canceling the purchase order
APPROVED_TIMESTAMP TIMESTAMP Timestamp when the document version is approved by the buyer
APPROVED_DATE DATE Date when the document version is approved by the buyer DW_DAY_D CALENDAR_DATE
PROCESSED_TIMESTAMP TIMESTAMP Timestamp in which the change order is processed
PROCESSED_DATE DATE Date in which the change order is processed DW_DAY_D CALENDAR_DATE
CREATION_TIMESTAMP TIMESTAMP Indicates the date and time of the creation of the row
LAST_UPDATE_TIMESTAMP TIMESTAMP Indicates the date and time of the last update of the row

Notes

#1 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on SUBMITTED_DATE column