Master data

Master data can be defined as information key to the operation of a business that is often non-transactional but supports transactional processes and operations.

Customers are a good example of master data. Data about customers (their names, addresses, phone numbers, and so on) is not transactional data but will support a transactional operation, for example, a sales order for a customer.

Microsoft Dynamics NAV has several master data tables, namely, Customer, Vendor, Item, Contact, Resource, Fixed Asset, and so on. Each master data table is the primary table in an application area. The Customer table is the main table in the sales application area, while the Vendor table is the main table in the Purchases application area.

Secondary tables, such as Sales Prices, also support transactions just as the master tables do. You will also need to take the secondary tables into account while migrating the master data.

The master and secondary tables that will be used in Microsoft Dynamics...