SY_User                             SY User Master                    Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: SY_User_bus
 SQL Def: Y  SysDB: Y                                                            MAS_SYSTEM/SY_User.M4T

 KPRIMARY: UserKey
 KUSERCODE: UserCode(u)
 KUSERLOGON: UserLogon(u)
 KSECURITYKEY: SecurityKey
 KLASTNAME: LastName+FirstName
 KCUSTOMCODE: CustomizationCode+UserKey
 KACTIVE: Active+UserLogon
 KEXTERNAL: External+Active+UserLogon

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  UserKey . . . . . . . . . . .    10 SNY  User Key. . . . . . . . . . . .USER
                                                Mask:0000000000 FmtType:ZEROF
                                                ILL
   2  UserCode. . . . . . . . . . .     3 SYY  User Code . . . . . . . . . . .
                                                ValGroup:ExternalUser
   3  UserLogon . . . . . . . . . .    60 SNN  User Logon. . . . . . . . . . .USERLOGON
   4  SecurityKey . . . . . . . . .    10 SYN  Security Key. . . . . . . . . .
                                                Mask:0000000000 FmtType:ZEROF
                                                ILL ValGroup:ExternalUser
   5  FirstName . . . . . . . . . .    20 SNN  First Name. . . . . . . . . . .
                                                ValGroup:ExternalUser
   6  LastName. . . . . . . . . . .    30 SNN  Last Name . . . . . . . . . . .
                                                ValGroup:ExternalUser
   7  CustomizationCode . . . . . .     3 SYN  Customization Code. . . . . . .
                                                ValGroup:ExternalUser
   8  Password. . . . . . . . . . .    16 SNN  Password. . . . . . . . . . . .
                                                ValGroup:ExternalUser
   9  Active. . . . . . . . . . . .     1 SYN  Active. . . . . . . . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
                                                ValGroup:ExternalUser
  10  InactiveDate. . . . . . . . .     8 SNN  Inactive Date . . . . . . . . .DATE
                                                ValGroup:ExternalUser
  11  LastCompany . . . . . . . . .    10 SNN  Last Company. . . . . . . . . .
                                                Mask:0000000000 FmtType:ZEROF
                                                ILL ValGroup:ExternalUser
  12  LookupLimit . . . . . . . . .     6 SNN  Lookup Limit. . . . . . . . . .
                                                DfltVal:0 Mask:#####0
                                                FmtType:ZEROFILL ValGroup:Ext
                                                ernalUser
  13  PartialLookup . . . . . . . .     1 SYN  Partial Lookup. . . . . . . . .
                                                DfltVal:B Valid:B,G
                                                ValGroup:ExternalUser Notes:
                                                B=Begins with, G=Greater than
  14  ImpliedDecimal. . . . . . . .     1 SYY  Implied Decimal . . . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
                                                ValGroup:ExternalUser
  15  AutoLogoff. . . . . . . . . .     1 SYY  Auto Logoff . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ExternalUser
  16  InactivityTime. . . . . . . .     3 SNN  Inactivity Time . . . . . . . .
                                                Mask:000 Valid:010-999
                                                FmtType:ZEROFILL ValGroup:Ext
                                                ernalUser
  17  EnterKeyLikeTab . . . . . . .     1 SYN  Enter Key Like Tab. . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
                                                ValGroup:ExternalUser
  18  InPeriodEnd . . . . . . . . .     1 SYY  In Period End . . . . . . . . .
                                                DfltVal:N Valid:Y,N,P
                                                ValGroup:ExternalUser Notes:
                                                Y=Yes, N=No, P=Printed
  19  PeriodEndPrinter. . . . . . .     3 SNN  Period End Printer. . . . . . .
                                                ValGroup:ExternalUser
  20  CurrentPrinter. . . . . . . .     3 SNN  Current Printer . . . . . . . .
                                                ValGroup:ExternalUser
  21  LowSpeedConnect . . . . . . .     1 SYN  Low Speed Connect . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ExternalUser
  22  SystemDate. . . . . . . . . .     8 SNN  System Date . . . . . . . . . .DATE
                                                ValGroup:ExternalUser Notes:
                                                YYYYMMDD
  23  Theme . . . . . . . . . . . .     1 SYN  Theme . . . . . . . . . . . . .
                                                DfltVal:1 ValGroup:ExternalUs
                                                er
  24  GraphicReportFormat . . . . .     1 SYY  Graphic Report Format . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
                                                ValGroup:ExternalUser
  25  ReductionAmountsInRed . . . .     1 SYY  Reduction Amounts In Red. . . .YESNO
                                                DfltVal:Y Valid:Y,N
                                                ValGroup:ExternalUser
  26  PromptForCompanyCode. . . . .     1 SYY  Prompt for Company Code . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ExternalUser
  27  UseCrystalWebReports. . . . .     1 SYY  Use Crystal Web Reports . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ExternalUser
  28  Locked. . . . . . . . . . . .     1 SYN  Locked. . . . . . . . . . . . .YESNO
                                                Valid:Y,N ValGroup:ExternalUs
                                                er
  29  ShowHiddenDialog. . . . . . .     1 SYN  Show Manage Your System Dialog.YESNO
                                                DfltVal:Y Valid:Y,N
                                                ValGroup:ExternalUser
  30  External. . . . . . . . . . .     1 SYN  External. . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ExternalUser
  31  LockedDate. . . . . . . . . .  8.0  NNN  Locked Date - Julian. . . . . .
                                                ValGroup:ExternalUser
  32  LockedTime. . . . . . . . . .  8.0  NNN  Locked Time . . . . . . . . . .
                                                ValGroup:ExternalUser
  33  PasswordDate. . . . . . . . .  8.0  NNN  Password Date - Julian. . . . .
                                                ValGroup:ExternalUser
  34  EnableCSODBC. . . . . . . . .     1 SNN  Enable CSODBC . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ExternalUser
  35  AppServSpawn. . . . . . . . .     1 SYN  App Serv Spawn. . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ExternalUser
  36  EnableWebServicesForUser. . .     1 SYN  Enable Web Services for User. .YESNO
                                                DfltVal:N Valid:Y,N
  37  ReportPreviewZoom . . . . . .  3.0  NNN  Default Report Preview Zoom . .
                                                DfltVal:100 Valid:1,2,25-400
                                                Notes: 1=Page Width, 2=Whole
                                                Page, other values are
                                                percentages