Looking to find out if anyone has been able to customize the ticket numbers? We are hoping to have a unique sequential set of numbers for our parking passes and not quite sure if this is doable. We are also trying to figure out the tickets numbers. Do they end at 9999999 and start over or do the numbers just get higher? Any help would be appreciated.
Ticket ID numbers are stored in T_SUB_LINEITEM, and are controlled by T_NEXT_ID WHERE type = 'TN'.
T_SUB_LINEITEM.ticket_no is an INT, which means it has a maximum of 2,147,483,647. I imagine by the time one of the network members approaches that limit, we'll get an upgrade that modifies that datatype to a bigint or something. Regardless, that's not something you want to mess with--the number can only get bigger, no skipping around. DON'T DO THIS: THEORETICALLY you could edit T_NEXT_ID to do a sequence in the negative range and then bounce back, but you would have to lock up your whole database for the duration of that sequence... and Tessi probably doesn't want to have anything to do with negative numbers there in the first place. I'm sure any tessi devs reading this have just broken out in a cold sweat at the mere suggestion.
What I would suggest you do look around for other pieces of data to use in your barcode. You can encode practically any ticket element in a barcode, so I would find a piece of data that already matches the scope of your parking passes in a sequential manner, and then use that. First thing that comes to mind would be to use seat numbers, presuming all of your passes are in the same perf. If they're in different perfs, you could probably combine with the performance code or something else, but at that point maybe a better question for you might be: What is it you are trying to accomplish?