SY_UserHistory SY User History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SY_User_bus SQL Def: Y SysDB: Y MAS_SYSTEM/SY_UserHistory.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 . . . . . . . . . . . 3 UserLogon . . . . . . . . . . 60 SNN User Logon. . . . . . . . . . .USERLOGON 4 SecurityKey . . . . . . . . . 10 SYN Security Key. . . . . . . . . . Mask:0000000000 FmtType:ZEROF ILL 5 FirstName . . . . . . . . . . 20 SNN First Name. . . . . . . . . . . 6 LastName. . . . . . . . . . . 30 SNN Last Name . . . . . . . . . . . 7 CustomizationCode . . . . . . 3 SYN Customization Code. . . . . . . 8 Password. . . . . . . . . . . 16 SNN Password. . . . . . . . . . . . 9 Active. . . . . . . . . . . . 1 SYN Active. . . . . . . . . . . . .YESNO DfltVal:Y Valid:Y,N 10 InactiveDate. . . . . . . . . 8 SNN Inactive Date . . . . . . . . .DATE 11 LastCompany . . . . . . . . . 10 SNN Last Company. . . . . . . . . . Mask:0000000000 FmtType:ZEROF ILL 12 LookupLimit . . . . . . . . . 6 SNN Lookup Limit. . . . . . . . . . DfltVal:5000 Mask:#####0 FmtType:ZEROFILL 13 PartialLookup . . . . . . . . 1 SYN Partial Lookup. . . . . . . . . Mask:0 FmtType:ZEROFILL 14 ImpliedDecimal. . . . . . . . 1 SYY Implied Decimal . . . . . . . .YESNO DfltVal:Y Valid:Y,N 15 AutoLogoff. . . . . . . . . . 1 SYY Auto Logoff . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 16 InactivityTime. . . . . . . . 3 SNN Inactivity Time . . . . . . . . Mask:000 FmtType:ZEROFILL 17 EnterKeyLikeTab . . . . . . . 1 SYN Enter Key Like Tab. . . . . . .YESNO DfltVal:Y Valid:Y,N 18 InPeriodEnd . . . . . . . . . 1 SYY In Period End . . . . . . . . . DfltVal:N Valid:Y,N,P Notes: Y=Yes, N=No, P=Printed 19 PeriodEndPrinter. . . . . . . 3 SNY Period End Printer. . . . . . . 20 CurrentPrinter. . . . . . . . 3 SNN Current Printer . . . . . . . . 21 LowSpeedConnect . . . . . . . 1 SYN Low Speed Connect . . . . . . .YESNO DfltVal:N Valid:Y,N 22 SystemDate. . . . . . . . . . 8 SNN System Date . . . . . . . . . .DATE Notes: YYYYMMDD 23 Theme . . . . . . . . . . . . 1 SYN Theme . . . . . . . . . . . . . DfltVal:1 24 GraphicReportFormat . . . . . 1 SYY Graphic Report Format . . . . .YESNO DfltVal:Y Valid:Y,N 25 ReductionAmountsInRed . . . . 1 SYY Reduction Amounts In Red. . . .YESNO DfltVal:Y Valid:Y,N 26 PromptForCompanyCode. . . . . 1 SYY Prompt for Company Code . . . .YESNO DfltVal:N Valid:Y,N 27 UseCrystalWebReports. . . . . 1 SYY Use Crystal Web Reports . . . .YESNO DfltVal:N Valid:Y,N 28 Locked. . . . . . . . . . . . 1 SYN Locked. . . . . . . . . . . . .YESNO Valid:Y,N 29 ShowHiddenDialog. . . . . . . 1 SYN Show Manage Your System Dialog.YESNO DfltVal:Y Valid:Y,N 30 External. . . . . . . . . . . 1 SYN External. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 31 LockedDate. . . . . . . . . . 8.0 NNN Locked Date - Julian. . . . . . 32 LockedTime. . . . . . . . . . 8.0 NNN Locked Time . . . . . . . . . . 33 PasswordDate. . . . . . . . . 8.0 NNN Password Date - Julian. . . . . 34 EnableCSODBC. . . . . . . . . 1 SYN Enable CSODBC . . . . . . . . .YESNO DfltVal:N Valid:Y,N 35 AppServSpawn. . . . . . . . . 1 SYN Application Server Spawn. . . .YESNO DfltVal:N Valid:Y,N 36 EnableWebServicesForUser. . . 1 SYN Enable Web Services For User. .YESNO DfltVal:N Valid:Y,N 37 ReportPreviewZoom . . . . . . 3.0 NNN Report Preview Zoom . . . . . . DfltVal:100 Valid:1,2,25-400