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
I'd suggest you search for the "Tessitura Table Structures" document on the website. Specifically, the Ticketing and Subscription Related Tables, and Pricing Related Tables sections.
Another good trick to see the components of an order is to use PORD or PCONT. They should help with doing the JOINs.
In SQL, EXEC PORD ####, @include_web_tables = 'N' --Replace #### with order number. For WEB orders: EXEC PORD @order_no = ####, @include_web_tables = 'Y' --Replace #### with order number.
For Contribution batches: EXEC PCONT #### --Replace #### with contribution number [ref_no]
Sorry, it should be:
EXEC PORD @order_no = ####, @include_web_tables = 'N'--Replace #### with order number.
(I forgot the @order_no = part)