ERP Internals/Data Tables/User

This group of tables control who can log on to the company and what functions they can perform. Each user can be assigned one or more roles (such as Purchasing Agent) which gives them access to a variety of functions. This allows the Systems Administrator to define a limited set of roles and allocate those roles to a large group of users. In smaller enterprises, the Systems Administrator would simply assign functions to each user directly. The contents of these tables are encrypted to increase security. User This table contains one record for every user that can log into this company. Used by: Every function in every module Key: User Number Fields: User Number (a unique number assigned by the ERP package) User Name User Password Password Expiry Date Minimum Password Length Inactive (Yes/No) Employee Number Language Notes Role This table contains one record for each role. Used by: Every function in every module Key: Role Number Fields: Role Number Role Description Notes User Role This table contains one record for each role each user has. Used by: Every function in every module Key: User Number, Role Number Fields: User Number Role Number User Access This table contains one record for every function the user can perform in this company. Although this is how the data is stored, the ERP uses a more compact format for efficiency reasons. Used by: Every function in every module Key: User Number, Function Number Fields: User Number Function Number Type of Access Role Access This table contains one record for every function the role can perform in this company. Although this is how the data is stored, the ERP uses a more compact format for efficiency reasons. Used by: Every function in every module Key: Role Number, Function Number Fields: Role Number Function Number Type of Access Functions The ERP package has pre-defined tables that list all the possible functions that can be performed as well as all the types of access.