Hey all,
I'm working on a SQL select query of ticketing and seat information, and I'd like to be able to add the n-scan ticket number to the query, but for the life of me I can't find where the number lives in the database. I know it's possible to get the number from the Order Export Utility when it's run in individual mode, but Does anyone have a table or view that they know it lives on?
+1 John Trimble. I believe the scalar function he references is what you need.