SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40
Record Type: 1 User Codes 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"U" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1)
User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3)
User Name . . . . . . . . . . . . . . . UserName. . . . . . . . . . . String (5,30)
Supervisor Rights? (Y/N). . . . . . . . SupervisorRights. . . . . . . Yes/No (35,1)
Applies To User Type 'U' Only . . . . . . . . . . . . . . . . . . . Memo
External User . . . . . . . . . . . . . ExternalUser. . . . . . . . . Yes/No (36,1)
Blank is interpreted as "Y" . . . . . . . . . . . . . . . . . . . . Memo
Named User. . . . . . . . . . . . . . . NamedUser . . . . . . . . . . Yes/No (37,1)
Display 'My Business' on Launcher . . . DisplayMyBusinessOnLauncher . Yes/No (38,1)
Blank is interpreted as 'Y' . . . . . . . . . . . . . . . . . . . . Memo
Company Code Prompt . . . . . . . . . . CompanyCodePrompt . . . . . . Yes/No (39,1)
Blank is interpreted as N . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (40,3)
User Type . . . . . . . . . . . . . . . UserType. . . . . . . . . . . String (43,1)
U=User. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
G=Group . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Group Code. . . . . . . . . . . . . . . GroupCode . . . . . . . . . . String (44,3)
Password. . . . . . . . . . . . . . . . Password. . . . . . . . . . . String (47,9)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (56,4)
Reserved for Future Password Exp. . . . . . . . . . . . . . . . . . Memo
Lockout Date. . . . . . . . . . . . . . LockoutDate . . . . . . . . . Date (60,6)
Lockout Time. . . . . . . . . . . . . . LockoutTime . . . . . . . . . Zero-Filled (66,6)
User Flags. . . . . . . . . . . . . . . UserFlags . . . . . . . . . . String (72,1)
________
Total Bytes 74
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40
Record Type: 2 User/Company/Application Security 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"C" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1)
User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3)
Application Code. . . . . . . . . . . . ApplicationCode . . . . . . . String *(8,3)
________
Total Bytes 12
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40
Record Type: 3 Menu Security 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"M" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1)
Application Code. . . . . . . . . . . . ApplicationCode . . . . . . . String *(2,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3)
(A Blank Company Code Indicates . . . . . . . . . . . . . . . . . . Memo
All Companies). . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Menu Bar Number . . . . . . . . . . . . MenuBarNumber . . . . . . . . Zero-Filled *(8,2)
Option Number . . . . . . . . . . . . . OptionNumber. . . . . . . . . Zero-Filled *(10,2)
(An Option Number Of "00" Refers. . . . . . . . . . . . . . . . . . Memo
To Entire Menu Bar) . . . . . . . . . . . . . . . . . . . . . . . . Memo
User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(12,3)
________
Total Bytes 16
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40
Record Type: 4 ODBC/SQL Password Record 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"O" . . . . . . . . . . . . . . . . . . RecordType. . . . . . . . . . Uppercase *(1,1)
"RPT" . . . . . . . . . . . . . . . . . RPT . . . . . . . . . . . . . Uppercase *(2,3)
SQL Password. . . . . . . . . . . . . . SQLPassword . . . . . . . . . String (5,16)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (21,37)
________
Total Bytes 59
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40
Record Type: 5 External User Record 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type ("c") . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1)
User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3)
Validation String . . . . . . . . . . . ValidationString. . . . . . . String (5,50)
________
Total Bytes 56
SY0SEC System Security File (SY0SEC_SystemSecurityFile) Level: 4.40
Record Type: 6 Named User Record 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 75 Min Len: 10 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type ("d") . . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1)
User Code . . . . . . . . . . . . . . . UserCode. . . . . . . . . . . String *(2,3)
Validation String . . . . . . . . . . . ValidationString. . . . . . . String (5,50)
________
Total Bytes 56