The purpose of this procedure is to view, browse, add, change and delete records in the database table "x_user" (User Profiles).
Key Fields
These entry field(s) are used to retrieve a specific record from this table.
User ID.
ID code assigned to this user
Data Fields
These are the data fields in each record from this table.
Class ID.
User's ID in related table for user class (empl#, cust#, etc)
Default Printer.
Default Printer ID for this user.
Email Address.
Email address for this user (Ex: "jsmith@xxx.com")
Entity1 List.
Comma-delimited list of level1 entities that user can access
Such as companies, divisions, etc.
Entity2 List.
Comma-delimited list of level2 entities that user can access
Such as warehouses, branches, etc.
File Path.
Absolute or relative directory name for user's reports & files
Used to create report files and temporary text files for this user.
Group List.
Comma-delimited list of groups to which this user is assigned
Cannot be blank or asterisk.
Password.
Encrypted password for this user
Startup Menu.
Client app to run at login/startup for this user.
User Class.
Class or type of user: employee, customer, vendor, etc.
User Name.
Name of this user ("Jane Smith").
User Status.
User status: new/active/hold/inactive
In the browse for this procedure, you can select and sort records by the following fields.
User ID.
ID code assigned to this user
User Name.
Name of this user ("Jane Smith").
User Status.
User status: new/active/hold/inactive
User Class.
Class or type of user: employee, customer, vendor, etc.
Default Printer.
Default Printer ID for this user.
Startup Menu.
Client app to run at login/startup for this user.
Email Address.
Email address for this user (Ex: "jsmith@xxx.com")
None.