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

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.