Adding some dates

[phil]

I was thinking about adding a date changed field to stock master (prices and customer master) too... my driver was to only download to and update my POS system with those records that had changed - thus reducing the overhead of master file refreshes - as I could get a stock list of items where change date > the date of the last refresh.

I am a little unsure about the wisdom of adding a date changed stock category field as where would one stop, date changed description, date changed mbflag, date changed barcode, date changed etc of course all of this info can be determined already from the audit trail and it would double the size of the database with largely redundant data. I guess I would prefer not to do this.