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