User Properties Overview
Each user that is created exists as a record in the EPUsers table. All properties of the user exist as a column in this table. When users log in, the values in these columns are stored as user session variables so that when the user navigates the site, properties of the user can be pulled from the session variables for reference and use by the EASYCommerce site.
This is the value the user will log in as. This is the primary key of the table, so this value must be unique. This means the UserId cannot be the same for any other user that exists in the portal.
This is the password the user creates for themselves. When a user is initially created, this is an auto-generated value.
The first name of the user. When the user is logged in, they will be referred to by name instead of their user id.
The last name of the user. When the user is logged in they will be referred to by name instead of their user id.
This is a type the user is assigned. The types determine the user’s access. The Admin can decide that all “Full Access” types can create orders and all “Basic Access” types can only view the catalog. These access rules can be changed, but they are maintained based on user authorization types.
The catalog the user is assigned to. Different catalogs can exist in the portal and this is the catalog this user should see.
This is either Active or Deactivated. A user can be manually deactivated by an Admin who wants to limit access to certain UserIds. A user will also become deactivated if too many incorrect password attempts are made.
The email of the user. This is used when orders are made and an order email is sent out or if the user requests a password change and the site must email the user a link to reset the password.
Each time a user unsuccessfully attempts to log in, this count is increased by one. When this count reaches a certain number (determined by site admin), the user will be locked out and their status will become deactivated
When the user has forgotten their password, a predetermined Security Question can be answered in order to regain access to the account.
This is the user’s entered answer to the security question. This will be compared against the user-entered value when a password is lost and the user is attempting to regain access.
Each time a user visits the site, they have an associated session id as determined by IIS. This session id is saved when they log in so they can be identified.
When the user’s status changes to become deactivated, the date is stored. This provides some information for the admin to see how long the user has been inactive.
Then the user’s status changes to become deactivated, the reason is stored. This provides some information for the admin to see why the user was deactivated.
The security level of the user determines which webpages can be visited. For example, an admin webpage would have a security level of 999 because only the admin should see this. However, the default value for all users is -1. This allows the admin to create overrides and use the overrides instead of the stored security levels. The -1 values tells EASYProcess to not use this value, because the admin would instead like to be able to control this via the webpage access page for user authorization types.
This is the K-Rise created AccountId which belongs to this user’s Parent Address Number.
This is the K-Rise created AccountId which belongs to this user’s default Billing Address Number.
This is the JDE ERP Address Number for this user’s default Billing Address.
This is the K-Rise created AccountId which belongs to this user’s default Shipping Address Number.
This is the JDE ERP Address Number for this user’s default Shipping Address.
Currency/ BaseCurrency/ CurrencyMode
A user has two currencies associated: a user currency and a base currency. When these values are the same, the user's currency mode is Domestic (D). When these values are different, the user's currency mode is Foreign (F). The base currency is the currency of the user's parent address number’s company. The user currency comes from the customer master for the user’s parent address number.