Skip to Content
0
Feb 27, 2023 at 03:59 PM

Need to join Sales Orders to their Price Component after Query

57 Views Last edit Sep 04, 2023 at 07:24 AM 2 rev

As part of an integration process within different applications, we are in need to query sales order information out through SQL selection.

We have been able to query information from

  • sales_order
  • sales_order_item
  • sales_order_item_product_tax_details
  • sales_order_item_schedule_line
  • sales_order_price_component

We are however unable to join the price component with the corresponding salesorder and item. The price component table doesn't seem to contain any reference key we can use to do so.

Does anyone know if it is possible to retrieve the relationship between the UUID of the price component table and the salesorderID and ItemID of the sales order? This will allow us to appropriately query and join the information correctly from an external system