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 . . . . . . . .