You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pricing promotions - unable to join qp_pricing_terms_b with other tables - provide sample queries

edited Jun 30, 2026 7:16AM in Pricing 3 comments

Summary:

I am unable to figure out how in case of promotions qp_pricing_terms_b is connected to other tables other than qp_promotion_lines_b.

Content (please ensure you mask any confidential information):

I have one promotion line and multiple benefits on it:

Obviously, most of this is stored in qp_pricing_terms_b table.

I have a query like this that returns everything I need, but due to missing join between qp_pricing_terms_b and inventory items it is multiplicated as well as not connecting pricing terms with correct items.

(I was expecting an additional table something like what you have in regular discounts in qp_discount_list_items).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!