Hi folks,
I'm sure/hoping the answer is probably staring me in the face but how do I relate the entries in the T_SLI_DETAIL table to the various price layers in v12?
I have a performance with 3 price layers (Ticket Price, Agency Inside Charge and Venue Approved Agency Fee) meaning that for every entry in T_SUB_LINEITEM table, there are 3 entries in the T_SLI_DETAIL table. All good so far. My problem is that T_SLI_DETAIL has a column called pmap_no - as the whole PMAP functionality has now been replace with Price Layers, I'm not sure what this value is used for. There are no corresponding values in the T_PMAP table in v12.
I need to be able to split the ticket sales into their 3 layers - can anyone help please?
Martin
Martin,
The T_SLI_DETAIL.pmap_no column now points to T_PERF_PRICE_TYPE.id, which identifies the layer and price type.
David
Ah!
Brilliant, many thanks David