Hi everyone,
I need to pull quite a few ticket numbers so we can manually mark them as attended (around 500) and I think I can pull this in SQL however I am having trouble finding a table that shows tck_no in the same way as it shows up in Tessi.
I thought I had it last week with LV_TKT_HIST_REPORT but the tck_no that is populated here does not appear to be the same as what shows up in the constituent record.
Any ideas?
ticket_no from T_SUB_LINEITEM?That's the ticket no that's in the Order History tab of Order Details screen
Thanks! That will work. I was overthinking it.