DW_PO_VERSION_CHANGE_DETAILS_CF

Purchase Order Version change details

Details

Module: Purchasing

Key Columns

PO_LINE_ID, PO_HEADER_ID, PO_VERSION_ID, PO_SCHEDULE_ID, PO_DISTRIBUTION_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
PO_HEADER_ID NUMBER 38 0 True Purchase Order Header identifier
PO_LINE_ID NUMBER 38 0 True Purchase Order Line identifier
PO_SCHEDULE_ID NUMBER 38 0 True Purchase Order Shipment schedule identifier
PO_DISTRIBUTION_ID NUMBER 38 0 True Purchase Order DIstribution identifier
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier
CHANGE_ORDER_SEQUENCE NUMBER Change Order Sequence
CHANGE_ORDER_NUMBER VARCHAR2 128 Change Order Number
PURCHASE_ORDER_NUMBER VARCHAR2 32 Purchase Order Number
H_AVAILABLE_FOR_VERSION_FLAG VARCHAR2 16 Set to Y if any changes happened in Header for this version
H_PO_VERSION_ID NUMBER 38 0 Purchase Order Version identifier for the Header record
H_FROM_CHANGE_ORDER_SEQUENCE NUMBER From Change Order Sequence for the Header
H_TO_CHANGE_ORDER_SEQUENCE NUMBER The ending point of the co sequence range within which the record is valid (Exclusive) of Purchase Order Headers
H_CURRENCY_CODE VARCHAR2 16 Currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
H_PREVIOUS_CURRENCY_CODE VARCHAR2 16 Currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
H_CURRENCY_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if Currency code changed from previous version
H_PURCHASE_ORDER_DESCRIPTION VARCHAR2 256 Purchase Order Description
H_PREVIOUS_PURCHASE_ORDER_DESCRIPTION VARCHAR2 256 Purchase Order Description of previous version
H_PURCHASE_ORDER_DESCRIPTION_CHANGED_FLAG VARCHAR2 16 Set to Y if Purchase Order Description changed from previous version
H_SUPPLIER_SITE_ID NUMBER 38 0 Supplier site unique identifier DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
H_PREVIOUS_SUPPLIER_SITE_ID NUMBER 38 0 Supplier site unique identifier of previous version DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
H_SUPPLIER_SITE_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier site unique identifier changed from previous version
H_BUYER_ID NUMBER 38 0 Buyer unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
H_PREVIOUS_BUYER_ID NUMBER 38 0 Buyer unique identifier of previous version DW_PERSON_NAME_CURRENT_D PERSON_ID
H_BUYER_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Buyer unique identifier changed from previous version
H_PAYMENT_TERMS_ID NUMBER 38 0 Payment terms unique identifier DW_AP_TERMS_D PAYMENT_TERMS_ID
H_PREVIOUS_PAYMENT_TERMS_ID NUMBER 38 0 Payment terms unique identifier of previous version DW_AP_TERMS_D PAYMENT_TERMS_ID
H_PAYMENT_TERMS_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Payment terms unique identifier changed from previous version
H_CARRIER_ID NUMBER 38 0 Carrier Identifier DW_PARTY_D PARTY_ID
H_PREVIOUS_CARRIER_ID NUMBER 38 0 Carrier Identifier of previous version DW_PARTY_D PARTY_ID
H_CARRIER_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Carrier Identifier changed from previous version
H_MODE_OF_TRANSPORT VARCHAR2 32 Mode of Transport
H_PREVIOUS_MODE_OF_TRANSPORT VARCHAR2 32 Mode of Transport of previous version
H_MODE_OF_TRANSPORT_CHANGED_FLAG VARCHAR2 16 Set to Y if Mode of Transport changed from previous version
H_SERVICE_LEVEL VARCHAR2 32 Service Level
H_PREVIOUS_SERVICE_LEVEL VARCHAR2 32 Service Level of previous version
H_SERVICE_LEVEL_CHANGED_FLAG VARCHAR2 16 Set to Y if Service Level changed from previous version
H_FREIGHT_TERMS_CODE VARCHAR2 32 Type of freight terms for the document DW_FREIGHT_TERMS_LKP_TL FREIGHT_TERMS_CODE
H_PREVIOUS_FREIGHT_TERMS_CODE VARCHAR2 32 Type of freight terms for the previous version document DW_FREIGHT_TERMS_LKP_TL FREIGHT_TERMS_CODE
H_FREIGHT_TERMS_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if freight terms changed from previous version
H_FOB_CODE VARCHAR2 32 Type of free-on-board terms for the document DW_FOB_LKP_TL FOB_CODE
H_PREVIOUS_FOB_CODE VARCHAR2 32 Type of free-on-board terms for the previous version document DW_FOB_LKP_TL FOB_CODE
H_FOB_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if free-on-board terms changed from previous version
H_PAY_ON_RECEIPT_INDICATOR VARCHAR2 16 Indicator of whether the purchase order will be paid upon receipt
H_PREVIOUS_PAY_ON_RECEIPT_INDICATOR VARCHAR2 16 Indicator of whether the purchase order will be paid upon receipt of previous version
H_PAY_ON_RECEIPT_INDICATOR_CHANGED_FLAG VARCHAR2 16 Set to Y if paid upon receipt changed from previous version
H_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier
H_PREVIOUS_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier of previous version
H_NOTE_TO_SUPPLIER_CHANGED_FLAG VARCHAR2 16 Set to Y if Short note to supplier changed from previous version
H_NOTE_TO_RECEIVER VARCHAR2 999 Note to receiver
H_PREVIOUS_NOTE_TO_RECEIVER VARCHAR2 999 Note to receiver of previous version
H_NOTE_TO_RECEIVER_CHANGED_FLAG VARCHAR2 16 Set to Y if Note to receiver changed from previous version
H_COMMUNICATION_METHOD VARCHAR2 32 Supplier Notification Method DW_DOC_COMM_METHOD_D_TL CODE
H_PREVIOUS_COMMUNICATION_METHOD VARCHAR2 32 Supplier Notification Method of previous version DW_DOC_COMM_METHOD_D_TL CODE
H_COMMUNICATION_METHOD_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier Notification Method changed from pervious version
H_BILL_TO_LOCATION_ID NUMBER 38 0 Bill-to location unique identifier DW_WORKER_LOCATION_D LOCATION_ID
H_PREVIOUS_BILL_TO_LOCATION_ID NUMBER 38 0 Bill-to location unique identifier of previous version DW_WORKER_LOCATION_D LOCATION_ID
H_BILL_TO_LOCATION_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Bill-to location modified from previous version
L_AVAILABLE_FOR_VERSION_FLAG VARCHAR2 16 Set to Y if any changes happened in Line for this version
L_PO_VERSION_ID NUMBER 38 0 Purchase Order Version identifier for the Line record
L_FROM_CHANGE_ORDER_SEQUENCE NUMBER From Change Order Sequence for the Line
L_TO_CHANGE_ORDER_SEQUENCE NUMBER The ending point of the co sequence range within which the record is valid (Exclusive) of Purchase Order Lines
L_TRANSACTION_UOM_CODE VARCHAR2 16 Transaction unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
L_PURCHASE_ORDER_LINE_NUMBER NUMBER Purchase Order Line Number
L_PREVIOUS_PURCHASE_ORDER_LINE_NUMBER NUMBER Purchase Order Line Number of previous version
L_PURCHASE_ORDER_LINE_NUMBER_CHANGED_FLAG VARCHAR2 16 Set to Y if Purchase Order Line Number changed from previous version
L_LINE_DESCRIPTION VARCHAR2 256 Line Item description
L_PREVIOUS_LINE_DESCRIPTION VARCHAR2 256 Line Item description of previous version
L_LINE_DESCRIPTION_CHANGED_FLAG VARCHAR2 16 Set to Y if Line Item description changed from previous version
L_SUPPLIER_ITEM VARCHAR2 512 Supplier product number
L_PREVIOUS_SUPPLIER_ITEM VARCHAR2 512 Supplier product number of previous version
L_SUPPLIER_ITEM_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier product number changed from previous version
L_QUANTITY NUMBER Quantity ordered on the line
L_PREVIOUS_QUANTITY NUMBER Quantity ordered on the line of previous version
L_QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity ordered on the line changed from previous version
L_UNIT_PRICE NUMBER Unit price for the line
L_PREVIOUS_UNIT_PRICE NUMBER Unit price for the line of previous version
L_UNIT_PRICE_CHANGED_FLAG VARCHAR2 16 Set to Y if Unit price for the line changed from previous version
L_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier
L_PREVIOUS_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier of previous version
L_NOTE_TO_SUPPLIER_CHANGED_FLAG VARCHAR2 16 Set to Y if Short note to supplier changed from previous version
LO_AVAILABLE_FOR_VERSION_FLAG VARCHAR2 16 Set to Y if any changes happened in Schedule for this version
LO_PO_VERSION_ID NUMBER 38 0 Purchase Order Version identifier for the Schedule record
LO_FROM_CHANGE_ORDER_SEQUENCE NUMBER From Change Order Sequence for the Schedule
LO_TO_CHANGE_ORDER_SEQUENCE NUMBER The ending point of the co sequence range within which the record is valid (Exclusive) of Purchase Order Line Locations
LO_TRANSACTION_UOM_CODE VARCHAR2 16 Transaction unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
LO_PURCHASE_ORDER_SCHEDULE_NUMBER NUMBER Purchase Order Schedule Number
LO_PREVIOUS_PURCHASE_ORDER_SCHEDULE_NUMBER NUMBER Purchase Order Schedule Number of previous version
LO_PURCHASE_ORDER_SCHEDULE_NUMBER_CHANGED_FLAG VARCHAR2 16 Set to Y if Purchase Order Schedule Number changed from previous version
LO_QUANTITY NUMBER Quantity
LO_PREVIOUS_QUANTITY NUMBER Quantity of previous version
LO_QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity changed from previous version
LO_LOCATION_ID NUMBER 38 0 Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
LO_PREVIOUS_LOCATION_ID NUMBER 38 0 Location Identifier of previous version DW_WORKER_LOCATION_D LOCATION_ID
LO_LOCATION_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Location Identifier changed from previous version
LO_DESTINATION_TYPE_CODE VARCHAR2 32 Destination Type Code DW_POR_DESTINATION_TYPE_D_TL CODE
LO_PREVIOUS_DESTINATION_TYPE_CODE VARCHAR2 32 Destination Type Code of previous version DW_POR_DESTINATION_TYPE_D_TL CODE
LO_DESTINATION_TYPE_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if Destination Type Code changed from previous version
LO_REQUESTED_DELIVERY_DATE DATE Requested Delivery Date
LO_PREVIOUS_REQUESTED_DELIVERY_DATE DATE Requested Delivery Date of previous version
LO_REQUESTED_DELIVERY_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Requested Delivery Date changed from previous version
LO_PROMISED_DELIVERY_DATE DATE Promised Delivery Date
LO_PREVIOUS_PROMISED_DELIVERY_DATE DATE Promised Delivery Date of previous version
LO_PROMISED_DELIVERY_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Promised Delivery Date changed from previous version
LO_REQUESTED_SHIP_DATE DATE Requested Ship Date
LO_PREVIOUS_REQUESTED_SHIP_DATE DATE Requested Ship Date of previous version
LO_REQUESTED_SHIP_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Requested Ship Date changed from previous version
LO_PROMISED_SHIP_DATE DATE Promised Ship Date
LO_PREVIOUS_PROMISED_SHIP_DATE DATE Promised Ship Date of previous version
LO_PROMISED_SHIP_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Promised Ship Date changed from previous version
LO_CARRIER_ID NUMBER 38 0 Carrier Identifier DW_PARTY_D PARTY_ID
LO_PREVIOUS_CARRIER_ID NUMBER 38 0 Carrier Identifier of previous version DW_PARTY_D PARTY_ID
LO_CARRIER_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Carrier Identifier changed from previous version
LO_MODE_OF_TRANSPORT VARCHAR2 32 Mode of Transport
LO_PREVIOUS_MODE_OF_TRANSPORT VARCHAR2 32 Mode of Transport of previous version
LO_MODE_OF_TRANSPORT_CHANGED_FLAG VARCHAR2 16 Set to Y if Mode of Transport changed from previous version
LO_SERVICE_LEVEL VARCHAR2 32 Service Level
LO_PREVIOUS_SERVICE_LEVEL VARCHAR2 32 Service Level of previous version
LO_SERVICE_LEVEL_CHANGED_FLAG VARCHAR2 16 Set to Y if Service Level changed from previous version
LO_RECEIVING_ROUTING_ID NUMBER 38 0 Receiving Routing Identifier DW_RCV_ROUTING_HEADERS_D_TL CODE
LO_PREVIOUS_RECEIVING_ROUTING_ID NUMBER 38 0 Receiving Routing Identifier of previous version DW_RCV_ROUTING_HEADERS_D_TL CODE
LO_RECEIVING_ROUTING_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Receiving Routing Identifier changed from previous version
LO_MATCH_APPROVAL_LEVEL VARCHAR2 16 Match Approval Level
LO_PREVIOUS_MATCH_APPROVAL_LEVEL VARCHAR2 16 Match Approval Level of previous version
LO_MATCH_APPROVAL_LEVEL_CHANGED_FLAG VARCHAR2 16 Set to Y if Match Approval Level changed from previous version
LO_INVOICE_MATCH_OPTION_CODE VARCHAR2 32 Invoice Match Option Code DW_PO_MATCH_OPTION_D_TL CODE
LO_PREVIOUS_INVOICE_MATCH_OPTION_CODE VARCHAR2 32 Invoice Match Option Code of previous version DW_PO_MATCH_OPTION_D_TL CODE
LO_INVOICE_MATCH_OPTION_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if Invoice Match Option Code changed from previous version
LO_NOTE_TO_RECEIVER VARCHAR2 999 Note to Receiver
LO_PREVIOUS_NOTE_TO_RECEIVER VARCHAR2 999 Note to Receiver of previous version
LO_NOTE_TO_RECEIVER_CHANGED_FLAG VARCHAR2 16 Set to Y if Note to Receiver changed from previous version
LO_COUNTRY_OF_ORIGIN_CODE VARCHAR2 16 Country of Origin Code DW_INSERT_COUNTRY_LKP_TL INSERT_COUNTRY_LKP_CODE
LO_PREVIOUS_COUNTRY_OF_ORIGIN_CODE VARCHAR2 16 Country of Origin Code of previous version DW_INSERT_COUNTRY_LKP_TL INSERT_COUNTRY_LKP_CODE
LO_COUNTRY_OF_ORIGIN_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if Country of Origin Code changed from previous version
LO_PO_SCHEDULE_PRICE NUMBER PO Schedule level price
LO_PREVIOUS_PO_SCHEDULE_PRICE NUMBER PO Schedule level price of previous version
LO_PO_SCHEDULE_PRICE_CHANGED_FLAG VARCHAR2 16 Set to Y if PO Schedule level price changed from previous version
D_AVAILABLE_FOR_VERSION_FLAG VARCHAR2 16 Set to Y if any changes happened in Distribution for this version
D_PO_VERSION_ID NUMBER 38 0 Purchase Order Version identifier for the Distribution record
D_FROM_CHANGE_ORDER_SEQUENCE NUMBER From Change Order Sequence for the Distribution
D_TO_CHANGE_ORDER_SEQUENCE NUMBER The ending point of the co sequence range within which the record is valid (Exclusive) of Purchase Order Distributions
D_PURCHASE_ORDER_DISTRIBUTION_NUMBER NUMBER Distribution Number
D_PREVIOUS_PURCHASE_ORDER_DISTRIBUTION_NUMBER NUMBER Distribution Number of previous version
D_PURCHASE_ORDER_DISTRIBUTION_NUMBER_CHANGED_FLAG VARCHAR2 16 Set to Y if Distribution Number changed from previous version
D_REQUESTER_ID NUMBER 38 0 Requester Identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
D_PREVIOUS_REQUESTER_ID NUMBER 38 0 Requester Identifier of previous version DW_PERSON_NAME_CURRENT_D PERSON_ID
D_REQUESTER_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Requester Identifier changed from previous version
D_DELIVER_TO_LOCATION_ID NUMBER 38 0 Deliver-to location Identifier DW_WORKER_LOCATION_D LOCATION_ID
D_PREVIOUS_DELIVER_TO_LOCATION_ID NUMBER 38 0 Deliver-to location Identifier of previous version DW_WORKER_LOCATION_D LOCATION_ID
D_DELIVER_TO_LOCATION_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Deliver-to location Identifier changed from previous version
D_ORDERED_QUANTITY NUMBER Ordered quantity
D_PREVIOUS_ORDERED_QUANTITY NUMBER Ordered quantity of previous version
D_ORDERED_QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Ordered quantity changed from previous version
D_ORDERED_AMOUNT NUMBER Ordered amount
D_PREVIOUS_ORDERED_AMOUNT NUMBER Ordered amount of previous version
D_ORDERED_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Ordered amount changed from previous version
D_CANCELLED_QUANTITY NUMBER Cancelled quantity
D_PREVIOUS_CANCELLED_QUANTITY NUMBER Cancelled quantity of previous version
D_CANCELLED_QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Cancelled quantity changed from previous version
D_CANCELLED_AMOUNT NUMBER Cancelled amount
D_PREVIOUS_CANCELLED_AMOUNT NUMBER Cancelled amount of previous version
D_CANCELLED_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Cancelled amount changed from previous version
D_PO_CHARGE_ACCOUNT_ID NUMBER 38 0 General Ledger charge account identifier DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
D_PREVIOUS_PO_CHARGE_ACCOUNT_ID NUMBER 38 0 General Ledger charge account identifier of previous version DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
D_PO_CHARGE_ACCOUNT_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if General Ledger charge account identifier changed from previous version
D_PO_VARIANCE_ACCOUNT_ID NUMBER 38 0 General Ledger variance account identifier DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
D_PREVIOUS_PO_VARIANCE_ACCOUNT_ID NUMBER 38 0 General Ledger variance account identifier of previous version DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
D_PO_VARIANCE_ACCOUNT_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if General Ledger variance account identifier changed from previous version
D_RECOVERABLE_INCLUSIVE_TAX NUMBER Recoverable inclusive tax amount
D_PREVIOUS_RECOVERABLE_INCLUSIVE_TAX NUMBER Recoverable inclusive tax amount of previous version
D_RECOVERABLE_INCLUSIVE_TAX_CHANGED_FLAG VARCHAR2 16 Set to Y if Recoverable inclusive tax amount changed from previous version
D_NONRECOVERABLE_INCLUSIVE_TAX NUMBER Non-recoverable inclusive tax amount
D_PREVIOUS_NONRECOVERABLE_INCLUSIVE_TAX NUMBER Non-recoverable inclusive tax amount of previous version
D_NONRECOVERABLE_INCLUSIVE_TAX_CHANGED_FLAG VARCHAR2 16 Set to Y if Non-recoverable inclusive tax amount changed from previous version
D_RECOVERABLE_EXCLUSIVE_TAX NUMBER Recoverable exclusive tax amount
D_PREVIOUS_RECOVERABLE_EXCLUSIVE_TAX NUMBER Recoverable exclusive tax amount of previous version
D_RECOVERABLE_EXCLUSIVE_TAX_CHANGED_FLAG VARCHAR2 16 Set to Y if Recoverable exclusive tax amount changed from previous version
D_NONRECOVERABLE_EXCLUSIVE_TAX NUMBER Non-recoverable exclusive tax amount
D_PREVIOUS_NONRECOVERABLE_EXCLUSIVE_TAX NUMBER Non-recoverable exclusive tax amount of previous version
D_NONRECOVERABLE_EXCLUSIVE_TAX_CHANGED_FLAG VARCHAR2 16 Set to Y if Non-recoverable exclusive tax amount changed from previous version