Unique SKU for Microsoft offerings

Having a unique sku per Microsoft (NCE) offering would greatly help in identifying which product offer is 'used', with what subscription term (per month, year subscription with monthly payment, year subscription with yearly payment etc.). This unique SKU is extremly helpful in our CRM/Accounting/Billing systems.

Now Microsoft's own (NCE) pricelist from the partner center does not provide such a sku but there are different columns in the Microsoft pricelist when combined creates a unique SKU. I see that in your own AppXite NCE price report you also have these columns available. See Att. Fig 1.

With these 4 columns in Fig 1 we currently generate a unique SKU for the product offer and knowing the termduration and billingplan by combining the columns for import in our own system.

(A previous suggestion to use the subscription start- and end date to generate a certain code isn't going to work since subscriptions can have started 24 months ago are year subscriptions and are monthly paid. )

Now when I look at the Full Recon outgoing invoices report from your system, you have a column called Vendor Offer ID and I find this same column in your AppXite NCE pricelist called External ID (column B). It seems that you have combined different columns, since it does not appear in the Microsoft pricelist.

Would it be possible to get the Term Duration and Billing plan data as in columns L and M from your own pricelist in the Vendor offer ID? So that it would look something like “cfq7ttc0hl8z/skus/0001/P1M/Monthly” . Or alternatively that you add Term Duration and Billing as extra columns in the full recon outgoing invoices data?

It would be much appreciated.