Frequently Asked Questions

This page is to be continually updated, with the team providing insights and building the knowledge base to help on-board new team members and to clarify questions for existing team members. 

Invoices - Invoices are receipts for sales. When we make a ticket sale, we will have an invoice for that sale. An invoice is also called a "Sell Order". Sell Orders can be found in the sellOrder tables on the database. 

Purchase Orders - Purchase Orders are receipts for buys. When we buy a ticket, we will have a Purchase Orders for that buy. An Purchase Orders is also called a "Buy Order". Buy Orders can be found in the buyOrder tables on the database. 

TicketGroup - A ticketgroup is a collection of tickets that were purchased together. Those tickets can be sold separately. (Example: a purchase order that has 10 tickets would be 1 ticketgroup, but those 10 tickets can be sold on 1 invoice as 10 tickets or on 10 invoices as 1 ticket per invoice or anything inbetween.) There are buyorderticketgroup and sellorderticketgroup tables that are used to link specific ticketgroups to Purchase Orders and Sell Orders

Linking Purchases to Sales - To link Purchases to Sales we have link on the same ticketgroups, but as discussed in the TicketGroup section, this isn't always a one to one relationship. So TB_POtoInvoiceBridgeView was created to make this possible. Here is an example of a typical link. (JOIN KC.eiboxoffice.dbo.TB_POtoInvoiceBridgeView br on (br.InvoiceNumber = so.InvoiceNumber and br.ticketgroupid = tg.ticketgroupid)) where so is SellOrder table and tg is TicketGroup table. Purchases to Sales is also known as Cost of Goods Sold.