How to master ERP database knowledge faster

First of all, what database does your ERP use......?

Oracle, DB2, SQL Server are not the same.

Also, if you can ask this question, you must not know the username and password of the db, so you can't get in.

The general ERP database is sqlserver, then you start the program, enterprise manager, and then find the database and open the table.

ERP data is simply divided into two categories: static data (master data) and dynamic data (business data) Master data mainly includes:

1) Accounting subjects: including general ledger accounts, merchants, customers, fixed assets, etc.

2) Material master data.

3) Projects. 4) Personnel number.

Business data includes account balances, material quantities, orders, accounting documents, and more.

You're asking too much of a question, isn't it? ERP itself involves many modules, and there are also a lot of data involved under each module. If you take procurement as an example:

Material information, business information, account information, base currency, unit of measure. And so on, these are all basic data.

Material information, BOM sheet, personnel information, account information, customer and business information, some units, currencies and other parameters.

In the ERP system, the success of ERP project implementation depends on three points of technology, seven points of management, and twelve points of data. Therefore, data collation is very important, and collating ERP basic data and data management is a heavy and cumbersome process. Many people will think that it is difficult, but as long as you find the right data collation method and the right ERP manufacturer, the data preparation and connection with the ERP system can be easily achieved.

For example, the data management of the ERP system can not only deal with abnormal and complex data information, but also ensure information sharing and synchronization and improve enterprise efficiency.

1. Basic data.

The basic data mainly includes the company's customer information, office information, employee information, permissions, etc. As long as a piece of information is entered into the system, the existing information can be directly copied quickly, and then the difference information can be modified, so as to speed up the speed of quickly adding similar information.

2. Engineering data.

The engineering data mainly includes scientific coding system, material master file, bill of materials BOM, product process route, etc. The workload of the engineering database is large and it is a long-term work, therefore, the Zhibang international ERP system will have the function of batch import, which can reduce the trouble of manual entry by customers, save the entry time, and improve work efficiency.

3. Inventory data.

Inventory data mainly includes warehouse basic data, warehouse type, location setting, warehouse transaction type parameters, etc. Inventory data is required to be accurate and reliable, so in the ERP system, whether it is the receipt and dispatch management of the warehouse, or borrowing, replenishment, material return, there is a strict operation process, and the system can also establish an effective performance appraisal method for warehouse keepers according to the different situations of each company, so as to strengthen the warehouse management related work.

In addition to data collation, ERP also attaches great importance to data security. We have done work on all dimensions of security, including protection, login restrictions, data encryption, data backup, data recovery, offline analysis, permission control, hardware encryption, etc. Users only need to use it, and the security things are written in **, and they are all in the nature of permissions, so that customers can use it with peace of mind, comfort, and more assured.

The database is part of the standby ERP system.

No matter what ERP software we use, we will use the database, and the financial, production and other data of the enterprise are actually stored in the database.

However, for software operators or enterprise business personnel, there is no need to bother with the database, because there is no need to operate it at all.

There are many varieties of materials, broken locks and non-standardized, at the same time, the warehouse is frequent, and at the same time, because the material is a single operation, undoubtedly brings great difficulty to the warehouse management, how to deal with the registration in and out of the warehouse, while closely monitoring all materials in the warehouse, the warehouse management system gives a comprehensive solution and methods.

1.Opening data.

Beginning data entry is the first step in the operation of the warehouse, before entering the beginning of the data to the warehouse inventory, and then the inventory data.

Input, the opening data entry can be entered in separate warehouses (main material warehouse and auxiliary material warehouse), and also separately for materials and finished products.

Input. 2.Inbound processing.

Procurement and warehousing. Procurement warehousing is mainly the warehousing management of raw materials, procurement warehousing is divided into main material warehousing and auxiliary materials warehousing, the main material warehousing generally has to track the batch of cloth, because each batch of cloth back has color difference, after warehousing the corresponding inventory of the warehouse increases, while increasing the accounts payable of this ** business.

Production warehousing. Production warehousing is mainly to enter the number of completed items, mainly to enter the data of that department to produce that type of document and that style number, how much has been completed, and then track the completion of the production order.

Outsourced processing and warehousing.

This function is to manage and register the outgoing warehousing, and the system will automatically send the outgoing processing order when the outgoing processing order is selected.

The information is imported from the processing order, and then the actual warehousing quantity is entered, and the computer can automatically calculate the processing fee after saving the account.

General warehousing. It is mainly the borrowing operation of general items and other warehousing operations that do not involve payment settlement.

3.Outbound processing.

Production picking. In order to effectively control the material, the picking registration must be carried out when the workshop picks, and the inventory must be reduced after posting, and at the same time it is related to the cost accounting.

Join. Outsourced processing out of the warehouse.

The outsourced processing materials are out of the warehouse, reducing the material inventory, and at the same time transferring to the outsourced processing settlement costs.

Sales out of the warehouse. Sales and shipment management is mainly based on the completion of the order for the delivery management of the warehouse, and the warehouse warehouse after the warehouse shipment is accounted for.

Deposits are automatically reduced, and accounts receivable are automatically generated at the same time.

General outbound. The general outbound operation is mainly the lending operation of general items and other outbound operations that will not occur in the settlement of collection.

4.Inventory counts.

Inventory is to count the goods in the warehouse, verify the accuracy with the book number, find the difference in time, so as to find problems, update the book number, and prevent the actual goods from being inconsistent with the book number.

5.Inventory month-to-month.

The monthly settlement is to count and audit the entire business, and the monthly settlement forms an accurate purchase, sale and inventory statement and inventory closing balance data, and after the year-end basis is confirmed, the data of this month can not be modified, unless the monthly end is revoked.

Warehouse management is still the authority of WMS.

Dear, I am glad to answer for you, according to your question described as follows: 1. First of all, we must master the basic concepts and functions of ERP system; 2. Fully understand the relevant knowledge of warehouse management, and understand the storage, requisition, scrapping and other processes of warehouse items; 3. Learn the installation and use of ERP system, understand the module structure of ERP system, and the connection between them; 4. Through practice, be familiar with the functions of each module in the ERP system, such as material management, warehouse management, procurement management, inventory management, financial management, etc.; 5. Familiar with the report function of ERP system, learn to use reports to count the operation of the warehouse; 6. Learn the customized development of ERP system, and understand how to carry out corresponding customized development according to the specific needs of the enterprise.

ERP is an enterprise resource management system.

It is just the name or definition of a system, so there will be many systems on the market that belong to ERP systems, and these systems generally store data in the database, so database technology is definitely needed.

To do the development of ERP system, it is necessary to be able to design the database, if it is only secondary development or maintenance, then as long as the database can be used, if the administrator of your server, it is also necessary to be able to backup and restore data.

As for what database it is, it depends on what database your ERP uses.