Is it possible to add specific data in to change log if field does not exist in table?
We are tracing VendorNum under PartPlant, it displays VendorNum, but is it possible somehow to log VendorID instead VendorNum without creating new field in Db under PartPlant. Because number does not tell anything for users while ID is the main data users work with.
I don’t know the answer to your question, but, VendorID can be changed, so if somebody changes the VendorID and you are looking up changes on that basis, you could potentially be looking at the wrong record. VendorNum doesn’t change and is the true key for the record so that is the correct way to capture the change. Same with CustID/CustNum.
