IM_Audit IM Audit Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_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 SYN User Key. . . . . . . . . . . .USER
Mask:0000000000 Notes:
{IM_99$(1,3)}
2 SequenceNo. . . . . . . . . . 14 SNN Sequence Number . . . . . . . .
Mask:00000000000000 Notes:
{IM_99$(10,5)}
3 WorkstationName . . . . . . . 30 SNN Workstation Name. . . . . . . .
4 Date. . . . . . . . . . . . . 8 SNN Date. . . . . . . . . . . . . .DATE
Notes: {IM_99$(4,6)}
5 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
Notes: {IM_99$(17,15)}
6 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
Notes: {IM_99$(32,30)}
7 TransactionType . . . . . . . 1 SYN Audit Transaction Type. . . . .
Valid:A,C,D Notes: {IM_99$(62
,7)} A=Added, C=Changed,
D=Deleted
8 FieldName . . . . . . . . . . 50 SYN Field Name. . . . . . . . . . .NAME
Notes: {IM_99$(69,19)}
9 FieldValueOriginal. . . . . . 30 SNN Original Field Value. . . . . .NAME
Notes: {IM_99$(88,30)}
10 NewFieldValue . . . . . . . . 30 SNN New Field Value . . . . . . . .NAME
Notes: {IM_99$(118,30)}