What is master table with example?

Question

Master Data: Data which seldom changes. For example, if a company has a list of 5 customer then they will maintain a customer master table having the name and address of the customers alongwith other data which will remain permanent and is less likely to change. 27 февр. 2016 г.

What is a master table?

« Back to Glossary Index. The tables that hold the records containing general information about the participants or objects of transactions within a module. In General Ledger the master table contains the account names, numbers, and balances.

What is master table in statistics?

The data structure to be used in the linear models statistical analysis can best be visualised by a master table where columns represent regions and rows represent individuals. To build up the master table, aggregated files are required.

What is master table in SQL Server?

The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings.

What is difference between master and transaction table?

master data table is not changes frequently but transactional data table will change frequently. master data records will be less compared to transactional data records. customer table ie KNA1 is Master data table and VBAK ie sales order header table is transactional data table.

Expert · Answer