DW_PURCHASE_ORDER_CHANGE_HEADERS_CF
Contains details for Purchase Order Headers for Accepted Purchase Order Versions. Data for Cancelled Purchase Orders and Cancelled Change Order Versions will not be available. Also, data will appear only when some changes happen for the Purchase Order header as part of the Purchase Order Version (Changes may happen for details which are not available on the Fact)
Details
Module: Purchasing
Key Columns
FROM_CHANGE_ORDER_SEQUENCE, PO_HEADER_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PO_HEADER_ID | NUMBER | 38 | 0 | True | Purchase Order Header identifier | ||
| FROM_CHANGE_ORDER_SEQUENCE | NUMBER | True | The starting point of the co sequence range within which the record is valid (Inclusive) | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source record identifier | ||||
| TO_CHANGE_ORDER_SEQUENCE | NUMBER | The ending point of the co sequence range within which the record is valid (Exclusive) | |||||
| PO_VERSION_ID | NUMBER | 38 | 0 | Purchase Order Version identifier | |||
| CHANGE_ORDER_NUMBER | VARCHAR2 | 128 | Change Order Number | ||||
| PURCHASE_ORDER_NUMBER | VARCHAR2 | 32 | Purchase Order Number | ||||
| CURRENCY_CODE | VARCHAR2 | 16 | Currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| PREVIOUS_CURRENCY_CODE | VARCHAR2 | 16 | Currency code of previous version | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| CURRENCY_CODE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Currency code modified from previous version | ||||
| PURCHASE_ORDER_DESCRIPTION | VARCHAR2 | 256 | Purchase Order Description | ||||
| PREVIOUS_PURCHASE_ORDER_DESCRIPTION | VARCHAR2 | 256 | Purchase Order Description of previous version | ||||
| PURCHASE_ORDER_DESCRIPTION_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Purchase Order Description changed from previous version | ||||
| SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site unique identifier | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| PREVIOUS_SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site unique identifier of previous version | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| SUPPLIER_SITE_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Supplier site unique identifier changed from previous version | ||||
| BUYER_ID | NUMBER | 38 | 0 | Buyer unique identifier | DW_PERSON_NAME_CURRENT_D | PERSON_ID | |
| PREVIOUS_BUYER_ID | NUMBER | 38 | 0 | Buyer unique identifier of previous version | DW_PERSON_NAME_CURRENT_D | PERSON_ID | |
| BUYER_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Buyer unique identifier changed from previous version | ||||
| PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment terms unique identifier | DW_AP_TERMS_D | PAYMENT_TERMS_ID | |
| PREVIOUS_PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment terms unique identifier of previous version | DW_AP_TERMS_D | PAYMENT_TERMS_ID | |
| PAYMENT_TERMS_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Payment terms unique identifier changed from previous version | ||||
| CARRIER_ID | NUMBER | 38 | 0 | Carrier Identifier | DW_PARTY_D | PARTY_ID | |
| PREVIOUS_CARRIER_ID | NUMBER | 38 | 0 | Carrier Identifier of previous version | DW_PARTY_D | PARTY_ID | |
| CARRIER_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Carrier Identifier changed from previous version | ||||
| MODE_OF_TRANSPORT | VARCHAR2 | 32 | Mode of Transport | ||||
| PREVIOUS_MODE_OF_TRANSPORT | VARCHAR2 | 32 | Mode of Transport of previous version | ||||
| MODE_OF_TRANSPORT_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Mode of Transport changed from previous version | ||||
| SERVICE_LEVEL | VARCHAR2 | 32 | Service Level | ||||
| PREVIOUS_SERVICE_LEVEL | VARCHAR2 | 32 | Service Level of previous version | ||||
| SERVICE_LEVEL_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Service Level changed from previous version | ||||
| FREIGHT_TERMS_CODE | VARCHAR2 | 32 | Type of freight terms for the document | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE | ||
| PREVIOUS_FREIGHT_TERMS_CODE | VARCHAR2 | 32 | Type of freight terms for the previous version document | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE | ||
| FREIGHT_TERMS_CODE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if freight terms changed from previous version | ||||
| FOB_CODE | VARCHAR2 | 32 | Type of free-on-board terms for the document | DW_FOB_LKP_TL | FOB_CODE | ||
| PREVIOUS_FOB_CODE | VARCHAR2 | 32 | Type of free-on-board terms for the previous version document | DW_FOB_LKP_TL | FOB_CODE | ||
| FOB_CODE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if free-on-board terms changed from previous version | ||||
| PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 | Indicator of whether the purchase order will be paid upon receipt | ||||
| PREVIOUS_PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 | Indicator of whether the purchase order will be paid upon receipt of previous version | ||||
| PAY_ON_RECEIPT_INDICATOR_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if paid upon receipt changed from previous version | ||||
| NOTE_TO_SUPPLIER | VARCHAR2 | 999 | Short note to supplier | ||||
| PREVIOUS_NOTE_TO_SUPPLIER | VARCHAR2 | 999 | Short note to supplier of previous version | ||||
| NOTE_TO_SUPPLIER_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Short note to supplier changed from previous version | ||||
| NOTE_TO_RECEIVER | VARCHAR2 | 999 | Note to receiver | ||||
| PREVIOUS_NOTE_TO_RECEIVER | VARCHAR2 | 999 | Note to receiver of previous version | ||||
| NOTE_TO_RECEIVER_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Note to receiver changed from previous version | ||||
| COMMUNICATION_METHOD | VARCHAR2 | 32 | Supplier Notification Method | DW_DOC_COMM_METHOD_D_TL | CODE | ||
| PREVIOUS_COMMUNICATION_METHOD | VARCHAR2 | 32 | Supplier Notification Method of previous version | DW_DOC_COMM_METHOD_D_TL | CODE | ||
| COMMUNICATION_METHOD_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Supplier Notification Method changed from pervious version | ||||
| BILL_TO_LOCATION_ID | NUMBER | 38 | 0 | Bill-to location unique identifier | DW_WORKER_LOCATION_D | LOCATION_ID | |
| PREVIOUS_BILL_TO_LOCATION_ID | NUMBER | 38 | 0 | Bill-to location unique identifier of previous version | DW_WORKER_LOCATION_D | LOCATION_ID | |
| BILL_TO_LOCATION_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Bill-to location modified from previous version | ||||
| CREATION_TIMESTAMP | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_TIMESTAMP | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |