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