It is quite common that we use optional fields in Sage to store key-value pairs. The way this works in Sage is the Value column of an optional field is considered the key and the description is considered the value.
To make interaction with this even easier with HuLib, include HuLib.AccPac.Client, it includes an overload for Connection that can easily pull all this data into a dictionary that is ready to use:
Dictionary<string, string> custVendorLookup = Connection.GetOptFieldMap("CUSTTOSTORE"); string vendor = custVendorLookup["1100"]; // 0083
Feel free to use this to lookup values from Sage without creating views manually!