I think that the idea is to create another table like tblsublicenses, with the purchasing information for each license, and then to have some reports to compare the license's table and this new table (specially the quatity bought vs the licenses used)..
When you buy a new licenses, you have the following information:
• Location (Is possible that you buy licenses only for 1 location or for differents locations)
• Vendor
• Purchasing Order
• Invoice Number
• Invoice Date
• Expiration Date
• Licences number
• Licence name (Ex: Visio Std 2003 Win32 OLP NL, Windows Svr Std 2003 OLP NL, etc)
• Version
• Quantity
• Type (OEM/FPP/Select/Open, Download/etc)
• LicenseID ( Asociation with the licenses’s table )
• Price
• Custom1
• Custom2
• Custom3
• Custom4
With this information we can have a good control for the purchasing licenses.
Thanks for your help.
Regards,
Diego