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?
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
To attack this from the front end you can
Click GoTo > Ticketing Setup
Click Ticketing Setup > Packages
Scroll down to the required package to the right is package details, Modes of Sale (MOS) Price Types etc tabs.
This is were your BO manager or associated person will set your packages up