AR_Audit AR Audit Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_Audit.M4T"
KPRIMARY: UserKey+Date+SequenceNo KSEQUENCENO: SequenceNo(u) KWORKSTATIONNAME: WorkstationName+UserKey+Date+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 UserKey . . . . . . . . . . . 10 SNY User Key. . . . . . . . . . . .USER Mask:0000000000 FmtType:ZEROF ILL Notes: {AR_99$(1,3)} 2 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . . Mask:00000000000000 FmtType:ZEROFILL Notes: {AR_99$(10,5)} 3 WorkstationName . . . . . . . 30 SNN Work Station Name . . . . . . . 4 Date. . . . . . . . . . . . . 8 SNY Date. . . . . . . . . . . . . .DATE Notes: {AR_99$(4,6)} 5 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR_99$(17,2)} 6 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC Notes: {AR_99$(19,7)} 7 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME Notes: {AR_99$(26,30)} 8 TransactionType . . . . . . . 1 SYN Audit Transaction Type. . . . . Valid:A,C,D Notes: A=Added, C=Changed, D=Deleted {AR_99$(56,7)} 9 FieldName . . . . . . . . . . 50 SYN Field Name. . . . . . . . . . . Notes: {AR_99$(63,19)} 10 FieldValueOriginal. . . . . . 30 SNN Original Field Value. . . . . . Notes: {AR_99$(82,30)} 11 NewFieldValue . . . . . . . . 30 SNN New Field Value . . . . . . . . Notes: {AR_99$(112,30)}