Entry Field in Order header

[johnbritto]

Hi Guys,

I want to know if there is any unused fields in the Order header table (OE0520). So that I can store my reference ID along with the order Information for future reference.

Thanks
John

 

[zemp]

Whether he fields are used or not may depend on how your client Accpac is setup. I don't know of any or believe that Accpac has placed any extra fields in the table.

You can try using one of the 6 optional fields, but the data you place in them may be visible in Accpac, again depending on how its set up. Just make sure the field you use is not used for any calculations or is not a key field for something.

Another option would be to create your compani9on database that your program can store this sort of data in. Afterall your client will have the database engine already so it's only a question of building the necessary companion database.

I prefer the last method.

Thanks and Good Luck!

zemp