Permission Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: PERMISS.DAT

The PERMISS.DAT file is used in connection with the Roles feature to specify which permissions a given user has in the product.

Note: The values stored in PermissionID in this file are mostly irrelevant since the actual values from the user's roles are added in before this record is actually used.

  • To add Permission fields to your Crystal reports, select PERMISS.DAT.

Indexes and their uses

The PERMISS.DAT file has the following indexes:

1 = By szUserID

2 = By InactiveSw and then by szUser and then by IsNonInteractive

3 = By m_GUID

4 = By CloudUserID

5 = By Email

Fields

The following table shows the fields available in the PERMISS.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment
UserID String 16 The user's name
Inactive Bool 16 True if the user is inactive
Data1 Binary 17  
Data2 Bool array 320 Each element of this array represents a specific permission level in the product.
Data10 Zstring 88  
Data20 Zstring 88  
GUID GUID    
ExpirationDate Date   Datetime when the password expires.
AdminReset Logical   Indicates that the password has been reset by the administrator when true.
LogoutDateTime DateTime   Date/time when the user should be logged out.
LogoutMessage Zstring 255 Warning message sent to user when they are logged out.
LogoutNagInterval Integer   Unused.
FailedLoginCount Integer   Number of times the user entered the wrong password.
LoginLockout Logical   Indicates that the user is locked out and cannot login.
LoginLockoutTime DateTime   Date/time when the user was locked out.
HistData101 Zstring 88 Historic password data.
HistData102 Zstring 88 Second historic password (encrypted).
HistData103 Zstring 88  
HistData104 Zstring 88  
HistData201 Zstring 88  
HistData202 Zstring 88  
HistData203 Zstring 88  
HistData204 Zstring 88  
EarliestLoginTime DateTime   Time when the user can log back in to Sage 50. Used in conjunction with LogoutDateTime.
IsNonInteractive Logical   Flag for determining if the user is normal/SDK.
LastUpdateCounter Unsigned long    
Email Zstring 64 The user's Sage account email address.
IsCloudOwner Logical   Indicates if the user is the data owner.
CloudUserID Ubinary 16 The user's Sage account ID.
BIAccepted UTinyInt   Internal use only. Do not use.
BIToken Ubinary   Internal use only. Do not use.
IsCloudUser UTinyInt   Indicates whether the user is required to authenticate with their Sage account credentials rather than their local credentials.