Re: Shop Order Soft Delete

I concur, looking through the journals is an easy way to find this stuff
out.
Sequence . . . . . . : 1093737131
Code . . . . . . . . : R - Operation on specific record
Type . . . . . . . . : UB - Update, before-image
Object . . . . . . . : FSO
Library . . . . . : ERPLXF
Member . . . . . . : FSO
Type . . . . . . . : *QDDS
Date . . . . . . . . : 11/18/11
Time . . . . . . . . : 10:20:20
Flag . . . . . . . . : 1
Count/RRN . . . . . : 1049
Commit cycle ID . . : 0
Nested commit level : 0
Job . . . . . . . . : 349527/PATR/GDML6S3
User profile . . . . : PATR
Program . . . . . . : SFC500D2

The next entry is the "after image". So you can see exactly what fields
were changed.

Since we're a Mimix shop, journalling is required. But once the
department saw what journals can do they went hog wild. We're a bit
extreme - we keep our journals for 77 days. (2 month ends). Serious disk
usage? Yes, but that's our choice.


Rob Berendt