Package Purchase Amount

Does anyone have any ideas on how to get just the PURCHASE amount from a season package, or by chance know what sql table holds that info? 

Parents
  • vs_package_history is used in output sets and has a good ammount of info (also referenced here)

    You can look into the view to get the actual tables but that is a good comprehensive Slight smile

    • pkg_hist_no
    • season customer_no
    • Role pkg_no
    • pkg_code pkg_desc
    • pkg_type
    • order_no
    • MOS
    • zone_no
    • perf_count
    • order_dt
    • pkg_amt
    • num_seats
    • price_type location

Reply
  • vs_package_history is used in output sets and has a good ammount of info (also referenced here)

    You can look into the view to get the actual tables but that is a good comprehensive Slight smile

    • pkg_hist_no
    • season customer_no
    • Role pkg_no
    • pkg_code pkg_desc
    • pkg_type
    • order_no
    • MOS
    • zone_no
    • perf_count
    • order_dt
    • pkg_amt
    • num_seats
    • price_type location

Children
No Data