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)}