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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.