We only just started using the PRICE_TYPE_GROUP to make our sales reports easier to manage and hopefully ensure accuracy, but I am at a loss to find out how it's tied to a given order. There's no column that I can see in any of the related tables to hold this information.
How does PRICE_TYPE_GROUP link back ro any given order?
Thanks, Tessiturians.
Take a look at TR_PRICE_TYPE.
Is this what you need: Select g.description from t_order o inner join t_sub_lineitem s on s.order_no=o.order_no inner join tr_price_type y on y.id=s.price_type inner join tr_price_type_group g on g.id=y.price_type_group
Is this what you need:
Select g.description
from t_order o
inner join t_sub_lineitem s on s.order_no=o.order_no
inner join tr_price_type y on y.id=s.price_type
inner join tr_price_type_group g on g.id=y.price_type_group