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