Is there a document somewhere talking about how the new price layer table structures work? I see the names in the table structures document, but no real discussion of how they replace the old T_PMAP and T_SUBPRICE. I've got a number of customizations I need to update for V12, so any such information would be very helpful. I'm slowly sussing it out, but worried I'll miss something. For instance, I expect I'll need to conditionally account for rows in T_PRICE_EVENT?
Hey Gawain,
I've been running through a lot of our procedures to plan for the upgrade (why do we use T_PMAP so much?!) and this is sort of the general replacement code that I've found works alright for most situations
FROM [dbo].T_SUB_LINEITEM sli (NOLOCK) JOIN [dbo].T_LINEITEM li (NOLOCK) on sli.li_seq_no = li.li_seq_no and li.primary_ind = 'Y' JOIN [dbo].T_SLI_DETAIL sd (NOLOCK) on sli.sli_no = sd.sli_no JOIN [dbo].T_PMAP pm (NOLOCK) on sd.pmap_no = pm.pmap_no --V11 Code to replace!
--V12 UPDATEJOIN T_PERF_PRICE_TYPE ppt on sd.pmap_no = ppt.id --Has GL accounts and old pmap_no informationJOIN T_PERF_PRICE_LAYER ptl on ppt.perf_price_layer = ptl.idJOIN TR_PRICE_LAYER_TYPE f ON ptl.price_layer_type = f.id --For price category
Gawain,
I don't know of a document that lays this out. But you might try opening up VB_PMAP to see how they constructed the old data model out of the new one. I spent a little time reviewing it before I started my updates to make our custom reports compatible and it was instructive.
- Levi
There is a document for this, and a Tessitura Hosted Training recording. Both highly recommended if you are going to be making changes for V12.
The Document: http://www.tessituranetwork.com/network/Learning/Documentation/v12/Preparing%20Customizations%20for%20v12.aspx
The THT: http://www.tessituranetwork.com/network/Learning/Tessitura%20Hosted%20Training%20for%20v12/Customizations%20and%20Version%2012.aspx
David
Thanks David! I guess I'd scanned over those, but somehow assumed the wouldn't get into the nitty-gritty. I'm going through them now.
Thanks Paul, that's helpful. Do you know if T_PRICE_EVENT is anything I'll have to watch here? Perhaps only for places where I need to replace T_SUBPRICE?
Thanks Levi,
Somehow missed that view. I'll dig through that now.
Hi Gawain,
There's a new function called FT_GET_PRICES() that is the recommended replacement for T_SUBPRICE. David's documentation has several useful examples of implementing this.
Cheers,
Patrick.
So, I'm not just having to pull data from these tables for our customizations, I also need to add data. We have a custom report that allows our box office to fill in all price types automatically from the base price (as well as doing a number of other things, including connecting those prices to custom tables that allow us to upload our Tessitura financial data to another financial system).
A couple of questions: are all these tables using identity primary key columns, and are there stored procedures or functions that are the preferred way to add data to these tables?
Thanks,
Gawain
Ah, I can see that they are identity columns. Yay! Never liked AP_GET_NEXTID.