Attached is an excel spreadsheet containing a number of sales transactions for an engineering parts distributor. These are the figures of one of the companies branches.
The data contains fields that provide detail about each sales transaction, product code, group etc.
However there are some fields that I don't understand (see below). I'm trying to find out what the entries under these fields could mean by testing for relationships between pricing, margin etc. For example it could be that "catalogue" pricing type could be different from the other pricing types and may have a link to the SPI text type. If I can figure out patterns relating to these values I will be able to analyse the data in greater detail, thus providing greater insight.
Interested to hear peoples findings and techniques for discovery.
Below are some of the fields and their values that I am trying to understand more about.
Approval to Std
Looking forward to your input