• Replies 9 replies
  • Subscribers 337 subscribers
  • Views 171 views
  • Users 0 members are here
Related

price layer table structures

Gawain Lavers
$organization

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?

Parents
  • $organization

    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 UPDATE
    JOIN T_PERF_PRICE_TYPE ppt on sd.pmap_no = ppt.id --Has GL accounts and old pmap_no information
    JOIN T_PERF_PRICE_LAYER ptl on ppt.perf_price_layer = ptl.id
    JOIN TR_PRICE_LAYER_TYPE f ON ptl.price_layer_type = f.id  --For price category

  • $organization in reply to Paul Kappel

    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?

Reply Children