# DW_PO_VERSION_CHANGE_DETAILS_CF

Purchase Order Version change details

## Details

Module: Purchasing

## Key Columns

PO_DISTRIBUTION_ID, PO_HEADER_ID, PO_SCHEDULE_ID, PO_VERSION_ID, PO_LINE_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 |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.