Hi guys,
We are trying to query some data from Tessitura by SQL code and it's been a challenge to find the table that has the ticket price info.
We need to know only the Ticket Price without any fees, charges, discounts or taxes.
Example:
Order1 bought 1 seat and paid the total of: $50,00 (Ticket Price: $45.00 / Facility Fee: $2.50 / Service Charge: $2.50)
Order2 bought 1 seat and paid the total of: $100 (Ticket Price: $80.00 / Facility Fee: $3.00 / Service Charge: $2.50 / discount: $14.50)
We are looking for just only the Ticket Price amount paid.
Thanks
Hi Amanda,
I suspect what you're looking for is T_SUB_LINEITEM. However, that may be complicated by how you are implementing fees and charges. Normal fees will be split out of this, but if you are adding charges via Price Layers then subtracting them back out will be more difficult.
--Gawain