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