view: dt_proper_physical_price_code {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_PROPER_PHYSICAL_PRICE_CODE ;;
  # derived_table: {
  #   sql: select product_id as release_id,
  #   'Proper Music Distribution' as store_name,
  #   store_pricing_tier_name,
  #   price_code
  #   from ORCHARD_APP_REPORTING_V2.PROD_OWS_PRICING_PRICING.PRODUCT_STORE_EFFECTIVE_PRICE_CODE
  #   where store_id = 696;;
  # }

dimension: release_id {
  type: number
  hidden: yes
  primary_key: yes
  sql: ${TABLE}.release_id ;;
}

  dimension: store_name {
    type: string
    hidden: yes
    sql: ${TABLE}.store_name ;;
  }

  dimension: store_pricing_tier_name {
    label: "Proper Pricing Tier Name"
    type: string
    hidden: no
    sql: ${TABLE}.store_pricing_tier_name ;;
  }

  dimension: price_code {
    type: number
    hidden: no
    label: "Proper Music Distribution Numeric Price Code"
    value_format: "0.00"
    description: "Price code formatted as a number"
    sql: ${TABLE}.price_code ;;
  }

  dimension: price_code_string {
    type: number
    hidden: no
    label: "Proper Music Distribution Text Price Code"
    description: "Original text price code, e.g. CD11"
    sql: ${TABLE}.price_code ;;
  }

  dimension: price_code_mapping {
    label: "Proper Music Distribution Price Mapping for US "
    type: string
    sql:
      case
  when ${price_code} = 'No Price Assigned' then  '0'
  when ${price_code}= '29USB' Then  '19.1'
  when ${price_code}= '40USB' Then  '27.05'
  when ${price_code}= 'BK14' Then  '7.75'
  when ${price_code}= 'BK16' Then  '8.49'
  when ${price_code}= 'BK22 ' Then  '10.5'
  when ${price_code}= 'BK22A' Then  '10.5'
  when ${price_code}= 'BK24' Then  '12.5'
  when ${price_code}= 'BK24' Then  '12.5'
  when ${price_code}= 'BK29' Then  '15'
  when ${price_code}= 'BK56' Then  '28.49'
  when ${price_code}= 'BK72' Then  '36.49'
  when ${price_code}= 'BK89' Then  '44.99'
  when ${price_code}= 'BK9' Then  '5.16'
  when ${price_code}= 'CD10' Then  '6.82'
  when ${price_code}= 'CD103' Then  '68.63'
  when ${price_code}= 'CD11' Then  '7.76'
  when ${price_code}= 'CD119' Then  '79.2'
  when ${price_code}= 'CD11G' Then  '7.76'
  when ${price_code}= 'CD11R' Then  '9.1'
  when ${price_code}= 'CD12' Then  '8.27'
  when ${price_code}= 'CD129' Then  '85.7'
  when ${price_code}= 'CD13' Then  '9'
  when ${price_code}= 'CD131' Then  '87.11'
  when ${price_code}= 'CD134' Then  '88.32'
  when ${price_code}= 'CD139' Then  '90'
  when ${price_code}= 'CD13R' Then  '9.8'
  when ${price_code}= 'CD13XRT' Then  '9.99'
  when ${price_code}= 'CD14' Then  '9.59'
  when ${price_code}= 'CD143' Then  '93.59'
  when ${price_code}= 'CD149' Then  '97.49'
  when ${price_code}= 'CD15' Then  '10.21'
  when ${price_code}= 'CD16' Then  '10.62'
  when ${price_code}= 'CD167' Then  '110.87'
  when ${price_code}= 'CD16C' Then  '10.95'
  when ${price_code}= 'CD17' Then  '11.24'
  when ${price_code}= 'CD18' Then  '11.86'
  when ${price_code}= 'CD19' Then  '12.79'
  when ${price_code}= 'CD191' Then  '126.71'
  when ${price_code}= 'CD199' Then  '126.94'
  when ${price_code}= 'CD19SP' Then  '14.49'
  when ${price_code}= 'CD1E' Then  '0.95'
  when ${price_code}= 'CD2' Then  '1.76'
  when ${price_code}= 'CD20' Then  '13.28'
  when ${price_code}= 'CD21' Then  '14.03'
  when ${price_code}= 'CD215' Then  '142.55'
  when ${price_code}= 'CD21CMG' Then  '8.5'
  when ${price_code}= 'CD22' Then  '14.66'
  when ${price_code}= 'CD220' Then  '140.3'
  when ${price_code}= 'CD23' Then  '15.29'
  when ${price_code}= 'CD24' Then  '15.92'
  when ${price_code}= 'CD25' Then  '16.56'
  when ${price_code}= 'CD254' Then  '168.29'
  when ${price_code}= 'CD26' Then  '17.63'
  when ${price_code}= 'CD267' Then  '167.78'
  when ${price_code}= 'CD27' Then  '18.19'
  when ${price_code}= 'CD275' Then  '182.15'
  when ${price_code}= 'CD28' Then  '19.13'
  when ${price_code}= 'CD29' Then  '19.1'
  when ${price_code}= 'CD29SP' Then  '21.97'
  when ${price_code}= 'CD3' Then  '2.31'
  when ${price_code}= 'CD30' Then  '20.45'
  when ${price_code}= 'CD31' Then  '20.78'
  when ${price_code}= 'CD32' Then  '21.97'
  when ${price_code}= 'CD33' Then  '21.63'
  when ${price_code}= 'CD34' Then  '22.13'
  when ${price_code}= 'CD35' Then  '22.63'
  when ${price_code}= 'CD36' Then  '24.41'
  when ${price_code}= 'CD36JA' Then  '23.5'
  when ${price_code}= 'CD37' Then  '23.89'
  when ${price_code}= 'CD389' Then  '257.39'
  when ${price_code}= 'CD39' Then  '25.44'
  when ${price_code}= 'CD3E' Then  '1.99'
  when ${price_code}= 'CD4' Then  '2.96'
  when ${price_code}= 'CD41' Then  '27.71'
  when ${price_code}= 'CD419' Then  '270'
  when ${price_code}= 'CD42' Then  '28.37'
  when ${price_code}= 'CD43' Then  '29.03'
  when ${price_code}= 'CD44' Then  '29.5'
  when ${price_code}= 'CD45' Then  '30.65'
  when ${price_code}= 'CD46' Then  '30.81'
  when ${price_code}= 'CD47' Then  '31.67'
  when ${price_code}= 'CD479' Then  '316.79'
  when ${price_code}= 'CD49' Then  '31.49'
  when ${price_code}= 'CD5' Then  '3.54'
  when ${price_code}= 'CD50' Then  '33.65'
  when ${price_code}= 'CD51' Then  '34.31'
  when ${price_code}= 'CD52' Then  '34.97'
  when ${price_code}= 'CD53' Then  '35.63'
  when ${price_code}= 'CD54' Then  '34.96'
  when ${price_code}= 'CD547' Then  '350.08'
  when ${price_code}= 'CD55' Then  '35.6'
  when ${price_code}= 'CD56' Then  '36.23'
  when ${price_code}= 'CD57' Then  '38.27'
  when ${price_code}= 'CD58' Then  '38.93'
  when ${price_code}= 'CD59' Then  '38.12'
  when ${price_code}= 'CD6' Then  '4.33'
  when ${price_code}= 'CD60' Then  '40.25'
  when ${price_code}= 'CD61' Then  '39.38'
  when ${price_code}= 'CD63' Then  '42.23'
  when ${price_code}= 'CD639' Then  '406'
  when ${price_code}= 'CD64' Then  '41.32'
  when ${price_code}= 'CD65' Then  '43.55'
  when ${price_code}= 'CD651' Then  '412.48'
  when ${price_code}= 'CD66' Then  '42.91'
  when ${price_code}= 'CD67' Then  '44.87'
  when ${price_code}= 'CD69' Then  '44.1'
  when ${price_code}= 'CD6O' Then  '4.33'
  when ${price_code}= 'CD7' Then  '4.72'
  when ${price_code}= 'CD71' Then  '47.51'
  when ${price_code}= 'CD74' Then  '49.49'
  when ${price_code}= 'CD75' Then  '50.15'
  when ${price_code}= 'CD77' Then  '51.47'
  when ${price_code}= 'CD79' Then  '51.93'
  when ${price_code}= 'CD8' Then  '5.31'
  when ${price_code}= 'CD83' Then  '55.43'
  when ${price_code}= 'CD84' Then  '56.09'
  when ${price_code}= 'CD85' Then  '54.64'
  when ${price_code}= 'CD87' Then  '57.19'
  when ${price_code}= 'CD89' Then  '58.49'
  when ${price_code}= 'CD9' Then  '6.5'
  when ${price_code}= 'CD908' Then  '583.41'
  when ${price_code}= 'CD99' Then  '65.72'
  when ${price_code}= 'CD99PE' Then  '70'
  when ${price_code}= 'CD9BBY' Then  '8'
  when ${price_code}= 'CDC6' Then  '4'
  when ${price_code}= 'CDD12' Then  '7.93'
  when ${price_code}= 'CDE11' Then  '5.9'
  when ${price_code}= 'CDE12' Then  '6.5'
  when ${price_code}= 'CDE14' Then  '9.45'
  when ${price_code}= 'CDE19' Then  '11.59'
  when ${price_code}= 'CDE24' Then  '12.49'
  when ${price_code}= 'CDE5' Then  '3.42'
  when ${price_code}= 'CDE6' Then  '4.16'
  when ${price_code}= 'CDE7' Then  '4.5'
  when ${price_code}= 'CDE8' Then  '5.31'
  when ${price_code}= 'CDEA14' Then  '7.05'
  when ${price_code}= 'CDEE5' Then  '3.01'
  when ${price_code}= 'CDG12' Then  '8.27'
  when ${price_code}= 'CDG13' Then  '9'
  when ${price_code}= 'CDG14' Then  '9.59'
  when ${price_code}= 'CDG15' Then  '10.21'
  when ${price_code}= 'CDG16' Then  '10.62'
  when ${price_code}= 'CDG17' Then  '11.24'
  when ${price_code}= 'CDG18' Then  '11.86'
  when ${price_code}= 'CDG9' Then  '6.5'
  when ${price_code}= 'CDLB13' Then  '9'
  when ${price_code}= 'CDLB15' Then  '10.21'
  when ${price_code}= 'CDLB16' Then  '10.95'
  when ${price_code}= 'CDLBC15' Then  '10.21'
  when ${price_code}= 'CDLW13' Then  '9'
  when ${price_code}= 'CDLW15' Then  '10.21'
  when ${price_code}= 'CDM119' Then  '69.54'
  when ${price_code}= 'CDM299' Then  '189'
  when ${price_code}= 'CDM399' Then  '231.8'
  when ${price_code}= 'CDM719' Then  '453.6'
  when ${price_code}= 'CDM785' Then  '469.24'
  when ${price_code}= 'CDM99' Then  '63.77'
  when ${price_code}= 'CDME44' Then  '28.35'
  when ${price_code}= 'CDME71' Then  '41.7'
  when ${price_code}= 'CDME89' Then  '56.7'
  when ${price_code}= 'CDMS11' Then  '7.81'
  when ${price_code}= 'CDMS3' Then  '2.01'
  when ${price_code}= 'CDMS7' Then  '4.32'
  when ${price_code}= 'CDMS9' Then  '5.91'
  when ${price_code}= 'CDO16' Then  '10.62'
  when ${price_code}= 'CDO17' Then  '11.24'
  when ${price_code}= 'CDO7' Then  '4.72'
  when ${price_code}= 'CDO8' Then  '5.31'
  when ${price_code}= 'CDO9' Then  '6.5'
  when ${price_code}= 'CDP71' Then  '46.56'
  when ${price_code}= 'CDS0' Then  '0'
  when ${price_code}= 'CDS1' Then  '1.15'
  when ${price_code}= 'CDS2' Then  '1.63'
  when ${price_code}= 'CDS3' Then  '2.01'
  when ${price_code}= 'CDS4' Then  '2.9'
  when ${price_code}= 'CDS5' Then  '3.45'
  when ${price_code}= 'CDS6' Then  '4.08'
  when ${price_code}= 'CDS7' Then  '4.66'
  when ${price_code}= 'CDS8' Then  '5.38'
  when ${price_code}= 'CDS9' Then  '6.5'
  when ${price_code}= 'CDSA129' Then  '85.7'
  when ${price_code}= 'CDSA13' Then  '9'
  when ${price_code}= 'CDSA14' Then  '9.7'
  when ${price_code}= 'CDSA15' Then  '10.21'
  when ${price_code}= 'CDSA18' Then  '11.86'
  when ${price_code}= 'CDSA20' Then  '13.36'
  when ${price_code}= 'CDSA21' Then  '14.03'
  when ${price_code}= 'CDSA22' Then  '14.66'
  when ${price_code}= 'CDSA24' Then  '15.92'
  when ${price_code}= 'CDSA254' Then  '168.29'
  when ${price_code}= 'CDSA26' Then  '17.63'
  when ${price_code}= 'CDSA29' Then  '19.1'
  when ${price_code}= 'CDSA31' Then  '20.78'
  when ${price_code}= 'CDSA33' Then  '21.63'
  when ${price_code}= 'CDSA34' Then  '22.13'
  when ${price_code}= 'CDSA39' Then  '25.44'
  when ${price_code}= 'CDSA45' Then  '30.65'
  when ${price_code}= 'CDSA59' Then  '38.12'
  when ${price_code}= 'CDSA64' Then  '41.35'
  when ${price_code}= 'CDSA99' Then  '65.72'
  when ${price_code}= 'CDSE1' Then  '1.22'
  when ${price_code}= 'CDSE6' Then  '4.33'
  when ${price_code}= 'CDSEE3' Then  '2.58'
  when ${price_code}= 'CDSEE6' Then  '3.75'
  when ${price_code}= 'CDSS1' Then  '1'
  when ${price_code}= 'CDSS2' Then  '1.5'
  when ${price_code}= 'CDSS5' Then  '3.25'
  when ${price_code}= 'CDSSS1' Then  '0.75'
  when ${price_code}= 'CDST5' Then  '3.5'
  when ${price_code}= 'CDT104' Then  '52.35'
  when ${price_code}= 'CDT13' Then  '9.45'
  when ${price_code}= 'CDT14' Then  '10.04'
  when ${price_code}= 'CDT16' Then  '11.07'
  when ${price_code}= 'CDT334' Then  '167.52'
  when ${price_code}= 'CDTE83' Then  '41.88'
  when ${price_code}= 'CDV17' Then  '10.86'
  when ${price_code}= 'CSE10' Then  '6.38'
  when ${price_code}= 'CSE11' Then  '6.9'
  when ${price_code}= 'cse11' Then  '6.9'
  when ${price_code}= 'CSE12' Then  '7.4'
  when ${price_code}= 'CSE13' Then  '8.17'
  when ${price_code}= 'CSE15' Then  '9.33'
  when ${price_code}= 'CSE7' Then  '4.6'
  when ${price_code}= 'CSE9' Then  '5.75'
  when ${price_code}= 'DVM10' Then  '6.37'
  when ${price_code}= 'DVM11' Then  '6.95'
  when ${price_code}= 'DVM12' Then  '7.55'
  when ${price_code}= 'DVM13' Then  '8.1'
  when ${price_code}= 'DVM13' Then  '8.1'
  when ${price_code}= 'DVM14' Then  '9.45'
  when ${price_code}= 'DVM14' Then  '9.45'
  when ${price_code}= 'DVM15' Then  '10.08'
  when ${price_code}= 'DVM15' Then  '10.08'
  when ${price_code}= 'DMV16' Then  '10.08'
  when ${price_code}= 'DVM16' Then  '10.71'
  when ${price_code}= 'DVM16' Then  '10.71'
  when ${price_code}= 'DVM17' Then  '10.86'
  when ${price_code}= 'DVM17' Then  '10.86'
  when ${price_code}= 'DVM17O' Then  '10.43'
  when ${price_code}= 'DVM18' Then  '11.01'
  when ${price_code}= 'DVM18' Then  '11.01'
  when ${price_code}= 'DVM18' Then  '11.01'
  when ${price_code}= 'DVM19' Then  '11.59'
  when ${price_code}= 'DVM19' Then  '11.59'
  when ${price_code}= 'DVM20' Then  '12.38'
  when ${price_code}= 'DVM21' Then  '12.97'
  when ${price_code}= 'DVM21' Then  '12.97'
  when ${price_code}= 'DVM22' Then  '13.78'
  when ${price_code}= 'DVM22' Then  '13.78'
  when ${price_code}= 'DVM23' Then  '14.59'
  when ${price_code}= 'DVM24' Then  '15.75'
  when ${price_code}= 'DVM24' Then  '15.75'
  when ${price_code}= 'DVM24' Then  '15.75'
  when ${price_code}= 'DVM25' Then  '16.38'
  when ${price_code}= 'DVM26' Then  '17.01'
  when ${price_code}= 'DVM26' Then  '17.01'
  when ${price_code}= 'DVM27' Then  '17.63'
  when ${price_code}= 'DVM28' Then  '17.24'
  when ${price_code}= 'DVM28' Then  '17.24'
  when ${price_code}= 'DVM29' Then  '17.39'
  when ${price_code}= 'DVM29' Then  '17.39'
  when ${price_code}= 'DMV29' Then  '17.39'
  when ${price_code}= 'DVM29A' Then  '20.08'
  when ${price_code}= 'DVM3' Then  '2.31'
  when ${price_code}= 'DVM31' Then  '18.55'
  when ${price_code}= 'DVM31' Then  '18.55'
  when ${price_code}= 'DVM33' Then  '19.71'
  when ${price_code}= 'DVM33' Then  '19.71'
  when ${price_code}= 'DVM34' Then  '20.29'
  when ${price_code}= 'DVM35' Then  '20.87'
  when ${price_code}= 'DVM37' Then  '22.03'
  when ${price_code}= 'DVM39' Then  '23.19'
  when ${price_code}= 'DVM399' Then  '231.8'
  when ${price_code}= 'DVM4' Then  '2.89'
  when ${price_code}= 'DVM44' Then  '29.5'
  when ${price_code}= 'DVM46' Then  '27.25'
  when ${price_code}= 'DVM46' Then  '27.25'
  when ${price_code}= 'DVM49' Then  '27.52'
  when ${price_code}= 'DVM5' Then  '3.47'
  when ${price_code}= 'DVM53' Then  '31.31'
  when ${price_code}= 'DVM54' Then  '31.89'
  when ${price_code}= 'DVM59' Then  '30.5'
  when ${price_code}= 'DVM6' Then  '4.05'
  when ${price_code}= 'DVM6' Then  '4.05'
  when ${price_code}= 'DVM65' Then  '38.27'
  when ${price_code}= 'DVM65' Then  '38.27'
  when ${price_code}= 'DVM69' Then  '37.78'
  when ${price_code}= 'DVM7' Then  '4.62'
  when ${price_code}= 'DVM77' Then  '45.23'
  when ${price_code}= 'DVM77' Then  '45.23'
  when ${price_code}= 'DVM79' Then  '43.55'
  when ${price_code}= 'DVM79' Then  '37.78'
  when ${price_code}= 'DVM8' Then  '5.2'
  when ${price_code}= 'DVM9' Then  '5.78'
  when ${price_code}= 'DVM99' Then  '50.84'
  when ${price_code}= 'DVME19' Then  '12.61'
  when ${price_code}= 'DVME3' Then  '1.25'
  when ${price_code}= 'DVME39' Then  '24.79'
  when ${price_code}= 'DVME6' Then  '3.75'
  when ${price_code}= 'DVT14' Then  '7.49'
  when ${price_code}= 'DVT17' Then  '8.99'
  when ${price_code}= 'DVT19' Then  '9.99'
  when ${price_code}= 'DVT23' Then  '14.59'
  when ${price_code}= 'DVT24' Then  '12.49'
  when ${price_code}= 'DVT25' Then  '12.99'
  when ${price_code}= 'DVT4' Then  '2.49'
  when ${price_code}= 'DVT5' Then  '2.99'
  when ${price_code}= 'DVT6' Then  '3.49'
  when ${price_code}= 'DVT669' Then  '335.04'
  when ${price_code}= 'DVT69' Then  '34.99'
  when ${price_code}= 'DVT9' Then  '4.99'
  when ${price_code}= 'DVTE12' Then  '6.49'
  when ${price_code}= 'DVTE19' Then  '10.47'
  when ${price_code}= 'DVTE27' Then  '13.96'
  when ${price_code}= 'DVTE39' Then  '19.96'
  when ${price_code}= 'FMLP38' Then  '19'
  when ${price_code}= 'GU115' Then  '80'
  when ${price_code}= 'GU220' Then  '156'
  when ${price_code}= 'JASON PREPACK' Then  '40.26'
  when ${price_code}= 'LP10' Then  '6.48'
  when ${price_code}= 'LP109' Then  '79.19'
  when ${price_code}= 'LP11' Then  '7'
  when ${price_code}= 'LP115' Then  '83.51'
  when ${price_code}= 'LP119' Then  '86.39'
  when ${price_code}= 'LP119ES' Then  '79.16'
  when ${price_code}= 'LP12' Then  '7.62'
  when ${price_code}= 'LP125' Then  '90.71'
  when ${price_code}= 'LP13' Then  '8.2'
  when ${price_code}= 'LP134' Then  '97.86'
  when ${price_code}= 'LP139' Then  '100.79'
  when ${price_code}= 'LP14' Then  '8.84'
  when ${price_code}= 'LP145' Then  '105.11'
  when ${price_code}= 'LP149' Then  '107.99'
  when ${price_code}= 'LP14A' Then  '8.84'
  when ${price_code}= 'LP15' Then  '9.48'
  when ${price_code}= 'LP16' Then  '10.48'
  when ${price_code}= 'LP160' Then  '115.91'
  when ${price_code}= 'LP17' Then  '11.48'
  when ${price_code}= 'LP175' Then  '126.71'
  when ${price_code}= 'LP18' Then  '11.71'
  when ${price_code}= 'LP189' Then  '136.79'
  when ${price_code}= 'LP19' Then  '12.33'
  when ${price_code}= 'LP20' Then  '12.95'
  when ${price_code}= 'LP21' Then  '13.57'
  when ${price_code}= 'LP215' Then  '155.51'
  when ${price_code}= 'LP22' Then  '14.94'
  when ${price_code}= 'LP23' Then  '16.06'
  when ${price_code}= 'LP24' Then  '16.73'
  when ${price_code}= 'LP24V2' Then  '17.97'
  when ${price_code}= 'LP25' Then  '17.4'
  when ${price_code}= 'LP26' Then  '18.07'
  when ${price_code}= 'LP27' Then  '18.74'
  when ${price_code}= 'LP28' Then  '19.41'
  when ${price_code}= 'LP29' Then  '20.08'
  when ${price_code}= 'LP299DT' Then  '250'
  when ${price_code}= 'LP30' Then  '20.78'
  when ${price_code}= 'LP31' Then  '21.42'
  when ${price_code}= 'LP32' Then  '22.09'
  when ${price_code}= 'LP33' Then  '22.76'
  when ${price_code}= 'LP34' Then  '23.43'
  when ${price_code}= 'LP35' Then  '24.1'
  when ${price_code}= 'LP35' Then  '24.1'
  when ${price_code}= 'LP36' Then  '24.77'
  when ${price_code}= 'LP37' Then  '25.44'
  when ${price_code}= 'LP38' Then  '25.72'
  when ${price_code}= 'LP39' Then  '26.78'
  when ${price_code}= 'LP4' Then  '2.99'
  when ${price_code}= 'LP42' Then  '28.79'
  when ${price_code}= 'LP44' Then  '30.09'
  when ${price_code}= 'LP46' Then  '31.47'
  when ${price_code}= 'LP48' Then  '32.81'
  when ${price_code}= 'LP49' Then  '33.48'
  when ${price_code}= 'LP5' Then  '3.59'
  when ${price_code}= 'LP50' Then  '33.84'
  when ${price_code}= 'LP56' Then  '38.12'
  when ${price_code}= 'LP59' Then  '40.13'
  when ${price_code}= 'LP6' Then  '4.19'
  when ${price_code}= 'LP60' Then  '40.84'
  when ${price_code}= 'LP65' Then  '45.03'
  when ${price_code}= 'LP69' Then  '48.29'
  when ${price_code}= 'LP7' Then  '4.7'
  when ${price_code}= 'LP7' Then  '4.69'
  when ${price_code}= 'LP74' Then  '55.4'
  when ${price_code}= 'LP79' Then  '57.59'
  when ${price_code}= 'LP8' Then  '5.25'
  when ${price_code}= 'LP80' Then  '58.31'
  when ${price_code}= 'LP89' Then  '60.2'
  when ${price_code}= 'LP9' Then  '5.84'
  when ${price_code}= 'LP99' Then  '66.89'
  when ${price_code}= 'LPE10' Then  '5'
  when ${price_code}= 'LPE10' Then  '8.2'
  when ${price_code}= 'LPE12' Then  '6'
  when ${price_code}= 'LPE13' Then  '8.26'
  when ${price_code}= 'LPE14' Then  '8'
  when ${price_code}= 'LPE15' Then  '8'
  when ${price_code}= 'LPE16' Then  '9'
  when ${price_code}= 'LPE19' Then  '10.59'
  when ${price_code}= 'LPE24' Then  '15.74'
  when ${price_code}= 'LPE29' Then  '15.06'
  when ${price_code}= 'LPE7' Then  '4.5'
  when ${price_code}= 'LPE9' Then  '4.5'
  when ${price_code}= 'LPEE5' Then  '3.82'
  when ${price_code}= 'LPEE7' Then  '5.11'
  when ${price_code}= 'LPF35' Then  '24.1'
  when ${price_code}= 'LPX10' Then  '6.19'
  when ${price_code}= 'LPT10' Then  '6.19'
  when ${price_code}= 'LPX11' Then  '7'
  when ${price_code}= 'LPX12' Then  '7.62'
  when ${price_code}= 'LPX13' Then  '8.2'
  when ${price_code}= 'LPX14' Then  '8.84'
  when ${price_code}= 'LPX15' Then  '9.48'
  when ${price_code}= 'LPX16' Then  '10.48'
  when ${price_code}= 'LPX17' Then  '11.48'
  when ${price_code}= 'LPX18' Then  '11.71'
  when ${price_code}= 'LPX19' Then  '12.33'
  when ${price_code}= 'LPX24' Then  '16.73'
  when ${price_code}= 'LPX29' Then  '20.22'
  when ${price_code}= 'LPX46' Then  '31.47'
  when ${price_code}= 'LPX8' Then  '5.25'
  when ${price_code}= 'LPX9' Then  '5.84'
  when ${price_code}= 'M10' Then  '10'
  when ${price_code}= 'M13' Then  '13'
  when ${price_code}= 'M14' Then  '14'
  when ${price_code}= 'M155' Then  '72'
  when ${price_code}= 'M172' Then  '172'
  when ${price_code}= 'M18' Then  '18'
  when ${price_code}= 'M292A' Then  '292.5'
  when ${price_code}= 'M4' Then  '2'
  when ${price_code}= 'M40' Then  '40'
  when ${price_code}= 'M42' Then  '42'
  when ${price_code}= 'M49A' Then  '49.5'
  when ${price_code}= 'M5' Then  '5'
  when ${price_code}= 'M550' Then  '550'
  when ${price_code}= 'M550' Then  '292.5'
  when ${price_code}= 'M6' Then  '6'
  when ${price_code}= 'M6' Then  '6'
  when ${price_code}= 'M6' Then  '6'
  when ${price_code}= 'M62' Then  '62'
  when ${price_code}= 'M7' Then  '7'
  when ${price_code}= 'M72' Then  '72'
  when ${price_code}= 'M7A' Then  '7.5'
  when ${price_code}= 'M8' Then  '8'
  when ${price_code}= 'MACD17' Then  '11.4'
  when ${price_code}= 'MACD18' Then  '12'
  when ${price_code}= 'MACD19' Then  '12.9'
  when ${price_code}= 'MACD20' Then  '13.4'
  when ${price_code}= 'MACD34' Then  '24.46'
  when ${price_code}= 'MACD69' Then  '44.76'
  when ${price_code}= 'MALP19' Then  '13.35'
  when ${price_code}= 'MALP21' Then  '14.5'
  when ${price_code}= 'MALP24' Then  '17.7'
  when ${price_code}= 'MALP27' Then  '19.75'
  when ${price_code}= 'MALP34' Then  '25'
  when ${price_code}= 'MALP44' Then  '32.19'
  when ${price_code}= 'MR22' Then  '10.5'
  when ${price_code}= 'PC15' Then  '10.21'
  when ${price_code}= 'PO39' Then  '19.99'
  when ${price_code}= 'PP111' Then  '71.47'
  when ${price_code}= 'PP158' Then  '102.1'
  when ${price_code}= 'PP80' Then  '51.46'
  when ${price_code}= 'PREPACK#1' Then  '1317.09'
  when ${price_code}= 'PREPACK#2' Then  '245.04'
  when ${price_code}= 'PREPACK#3' Then  '91.89'
  when ${price_code}= 'PREPACK#4' Then  '183.78'
  when ${price_code}= 'PREPACK#5' Then  '214.41'
  when ${price_code}= 'PREPACK#6' Then  '62.49'
  when ${price_code}= 'SACD18' Then  '11.86'
  when ${price_code}= 'S1' Then  '8.5'
  when ${price_code}= 'S11' Then  '13.5'
  when ${price_code}= 'S13' Then  '14.5'
  when ${price_code}= 'S14' Then  '15'
  when ${price_code}= 'S16' Then  '16'
  when ${price_code}= 'S17' Then  '16.5'
  when ${price_code}= 'S18' Then  '17'
  when ${price_code}= 'S19' Then  '17.5'
  when ${price_code}= 'S2' Then  '9'
  when ${price_code}= 'S22' Then  '19'
  when ${price_code}= 'S23' Then  '19.5'
  when ${price_code}= 'S24' Then  '20'
  when ${price_code}= 'S28' Then  '22'
  when ${price_code}= 'S3' Then  '9.5'
  when ${price_code}= 'S32' Then  '24'
  when ${price_code}= 'S3RL' Then  '0'
  when ${price_code}= 'S4' Then  '10'
  when ${price_code}= 'S42' Then  '29'
  when ${price_code}= 'S43' Then  '29.5'
  when ${price_code}= 'S44' Then  '30'
  when ${price_code}= 'S46' Then  '31'
  when ${price_code}= 'S5' Then  '10.5'
  when ${price_code}= 'S6' Then  '11'
  when ${price_code}= 'S63' Then  '39.5'
  when ${price_code}= 'S7' Then  '11.5'
  when ${price_code}= 'S72' Then  '44'
  when ${price_code}= 'S74' Then  '45'
  when ${price_code}= 'S8' Then  '12'
  when ${price_code}= 'S9' Then  '12.5'
  when ${price_code}= 'SV0' Then  '0'
  when ${price_code}= 'SV10' Then  '7.14'
  when ${price_code}= 'SV11' Then  '7.82'
  when ${price_code}= 'SV114' Then  '80'
  when ${price_code}= 'SV12' Then  '8.45'
  when ${price_code}= 'SV143' Then  '100'
  when ${price_code}= 'SV15' Then  '10.39'
  when ${price_code}= 'SV17' Then  '11.69'
  when ${price_code}= 'SV2' Then  '1.98'
  when ${price_code}= 'SV20' Then  '13.66'
  when ${price_code}= 'SV3' Then  '2.58'
  when ${price_code}= 'SV32' Then  '21.44'
  when ${price_code}= 'SV37' Then  '26.4'
  when ${price_code}= 'SV39' Then  '27.7'
  when ${price_code}= 'SV3A' Then  '2.58'
  when ${price_code}= 'SV4' Then  '3.25'
  when ${price_code}= 'SV44' Then  '29.24'
  when ${price_code}= 'SV49' Then  '32.5'
  when ${price_code}= 'SV5' Then  '3.82'
  when ${price_code}= 'SV51' Then  '34.77'
  when ${price_code}= 'SV6' Then  '4.46'
  when ${price_code}= 'SV7' Then  '5.11'
  when ${price_code}= 'SV70' Then  '50'
  when ${price_code}= 'SV74' Then  '53.24'
  when ${price_code}= 'SV8' Then  '5.84'
  when ${price_code}= 'SV8S' Then  '6.15'
  when ${price_code}= 'SV9' Then  '6.49'
  when ${price_code}= 'TB22' Then  '18.5'
  when ${price_code}= 'UM19' Then  '11.59'
  when ${price_code}= 'UM24' Then  '15.75'
  when ${price_code}= 'VHE12' Then  '7.67'
  when ${price_code}= 'VHE13' Then  '8.26'
  when ${price_code}= 'VHE14' Then  '8.86'
  when ${price_code}= 'VHE15' Then  '9.45'
  when ${price_code}= 'VHE19' Then  '10.82'
  when ${price_code}= 'VHEE19' Then  '11.99'
  when ${price_code}= 'VR19' Then  '15'
  when ${price_code}= 'VS10' Then  '6'
  when ${price_code}= 'VS11' Then  '7.82'
  when ${price_code}= 'VS12' Then  '8.5'
  when ${price_code}= 'VS13' Then  '9.09'
  when ${price_code}= 'VS14' Then  '9.74'
  when ${price_code}= 'VS15' Then  '10.39'
  when ${price_code}= 'VS16' Then  '10.19'
  when ${price_code}= 'VS19' Then  '12.39'
  when ${price_code}= 'VS4' Then  '2.75'
  when ${price_code}= 'VS5' Then  '3.37'
  when ${price_code}= 'VS6' Then  '4.19'
  when ${price_code}= 'VS7' Then  '5.11'
  when ${price_code}= 'VS8' Then  '5.38'
  when ${price_code}= 'VS9' Then  '5.68'
  when ${price_code}= 'VSE5' Then  '4.21'
  when ${price_code}= 'VSE6' Then  '3.93'
  when ${price_code}= 'VSEE6' Then  '3.91'
  else ${price_code}
  end ;;
  }

}