IT_UIDCustomerChangeAutoLog IT UID Customer Change Auto Log Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IT_UIDCustomerChange_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/IT"+%C$+"/IT_UIDCustomerChangeAutoLog.M4T"
KPRIMARY: ChangeType+UserID+ARDivisionNo+CustomerNo+DateUpdated+TimeUpdated KCUSTUID: ARDivisionNo+CustomerNo+UserID+ChangeType+DateUpdated+TimeUpdated
Fld Column Name M/L TUR Description/Notes Class
1 ChangeType. . . . . . . . . . 1 SNY Change Type . . . . . . . . . . Valid:1,2,3 Notes: 1=.order user ID Change, 2=.order customer change, 3=.store profile change (both user ID and customer) -- {IT8$(1,1)} 2 UserID. . . . . . . . . . . . 15 SYN User Id . . . . . . . . . . . . FmtType:CHARNUM Notes: {ITI$(2,15)} 3 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 4 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 5 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y Notes: {ITI$(17, 6)} 6 TimeUpdated . . . . . . . . . 6 SNN Time Updated. . . . . . . . . . Read Only:Y Notes: {ITI$(23, 6)} 7 UserIDSubmittingChange. . . . 15 SYY User ID Submitting Change . . . FmtType:CHARNUM Notes: {ITI$(29,15)} 8 EmailReasonCode . . . . . . . 5 SYN Email Reason Code . . . . . . .EMAILREASONCODE Notes: {ITI$(45,5)} 9 SuspendAccess . . . . . . . . 1 SNN Suspend Access. . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ITI$(50,1)}