Home / Inventory of spare parts
About the league between the Inventory of spare parts and Maintenance
Given the robustness of this implementation of Inventory of spare Parts, have it embedded within the program of Management of maintenance would be impractical, both for the wholesaler as well as for the maintenance staff.
Considering that in most companies there is one or more stores of spare parts and consumables that are operated by personnel independent of the personnel that manages and carries out the maintenance work, it is impractical for him or salesmen having to enter the application of maintenance Management to carry out there, all of the steps and movements involved in the management of inventories.
Therefore, it is important to understand that this application is targeted specifically for the staff of the warehouse to make all sorts of movements of inputs and outputs of spare parts and consumables, conduct physical inventories, calculate the value of the store by different methods, to make transfers between stores, make adjustments, get a relationship of parts that should cater to the store, etc
However, this separation between the Inventory of spare Parts and the application of Maintenance Management, the two are linked and interact with each other, so that the maintenance personnel will be able to consult from the application of maintenance Management the information you are interested in knowing, as stocks of spare parts, where are the spare parts, spare parts are used in each computer, the parts relating to the maintenance activities, etc..
The maintenance personnel may, in addition, generate vouchers in store from the application Management of maintenance, but you may not be from there to perform movements of inputs and outputs that correspond to the salesmen.
To carry out this procedure it is necessary to have previously created databases of Maintenance and parts Inventory
League of the Inventory database with the database Maintenance (from the maintenance module)
The maintenance staff needs to check the stock and the characteristics of the spare parts necessary to perform the maintenance work. The connection between the application Management, maintenance, and application Inventory of spare parts allows you to share information between these two to: create vouchers, register consumption, generate flows of resources, and to consult the information of the spare parts and consumables.
Steps to link the databases of Maintenance with an app store's Inventory of spare parts:
The connection between the Maintenance and inventory of spare parts only allows each database maintenance system is linked with a specific store, in contrast, several databases of Maintenance can be linked to the same store.
League of the Inventory database with the database of the MARKER (from the Inventory)
As mentioned, a warehouse can be linked to more than one database Management maintenance, which is necessary to make the league to each one of the bases of maintenance data from the application inventory of spare parts.
Steps to link stores the databases of the Inventory of spare parts with a database maintenance:
Can't find the answer to your doubts or questions?
Additionally, we offer training courses
Our flexible options of online training and face-to-face will provide you with all the knowledge necessary to understand and implement your software maintenance.
Contact us
×
Server IP, user name and password of the database engine
Today, virtually all companies have at least one IT professional who is responsible for, among many other functions to manage the data and servers of the company. Among their functions include the administration of a database engine, which, for security reasons, has access by means of a user name and a password. If not, any person could enter the network, and provide high-databases, query, modify and even delete confidential information of the company.
For example:
| DATABASE ENGINE | ADMINISTRATOR USER BY DEFAULT | PASSWORD (Known only to the manager of IT) |
| MySQL | root | ****** |
| Microsoft SQL-Server | sa | ****** |
| Oracle | System | ****** |
| MariaDB | root | ****** |
| Firebird | SYSDBA | ****** |
When you create a database, or a new connection on the MP, the program prompts you for the server name or IP where you will create or is the database to which you want to connect to, as well as a user name and password.
The username and password that here we ask, are precisely those that allow access to the database engine permissions privileges to create the database.
Now, the administrator of the database can also create different user accounts to allow access to more people by giving them privileges and permissions custom.
With the aim of not to use the administrator user of IT and its respective password each time that the department of maintenance required to create a database or a connection to an existing database, it is recommended that the IT administrator create a user account specifically for the maintenance department.
A single user account to the database engine is sufficient for the creation and connection of multiple databases.
The username and password that here is requested, you do not have any relationship with the licenses of use are acquired or the amount of users that can access the database, so that a single user account can be enough, because in this case it refers specifically to the user and password of the database engine.
EN_US 
ES_MX