GL_Audit Audit Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_Audit.M4T"
KPRIMARY: UserKey+Date+SequenceNo KACCOUNTKEY: AccountKey KSEQUENCENO: SequenceNo(u) KWORKSTATIONNAME: WorkstationName+UserKey+Date+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 UserKey . . . . . . . . . . . 10 SYY User Key. . . . . . . . . . . .USER Mask:0000000000 FmtType:ZEROF ILL 2 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . . Mask:00000000000000 3 WorkstationName . . . . . . . 30 SNN Workstation Name. . . . . . . . 4 Date. . . . . . . . . . . . . 8 SNY Date. . . . . . . . . . . . . .DATE 5 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 6 TransactionType . . . . . . . 1 SYY Audit Transaction Type. . . . . Valid:A,C,D Notes: A=Added, C=Changed, D=Deleted 7 FieldName . . . . . . . . . . 30 SYY Field Name. . . . . . . . . . . 8 FieldValueOriginal. . . . . . 50 SNY Original Field Value. . . . . . 9 NewFieldValue . . . . . . . . 50 SNY New Field Value . . . . . . . .