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