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
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?
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.