     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