Hello Tessitura Community!
We want to use the premium functionality to track our corporate sponsorship comp ticket benefit use. We're trying to create a stored procedure that will update the T_CUST_PREM table based on ticket purchases and returns for the corporate sponsor ticket price type.
Has anyone successfully added records to or deleted records from this table using a custom stored procedure? We're specifically stuck on auto incrementing the cust_prem_no (PK) field. We successfully manually inserted values (including the cust_prem_no field) into the table and we know that numbers are not reused even when a record has been deleted from the table. However, we do not know what table to query in our procedure in order to maintain the integrity of the sequential numbering system for T_CUST_PREM.
Any help or pointing in the right direction would be greatly appreciated!
Thank you!
Mandy