Menu
Why do we need to have two tables (master and transaction table) of any topic like sales,purchase,etc.. What should be the relationship between the two tables and what should be the difference between them. Why do we really need them.
959
Transactional data is derived from transactions, while master data provides context to transactions. Transactional data has a time dimension and may lose its relevance over time. Master data, on the other hand, has no time dimension and changes less often.
Master and transactional dataTransactional data relates to the transactions of the organization and includes data that is captured, for example, when a product is sold or purchased. Master data is referred to in different transactions, and examples are customer, product, or supplier data.
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.
Master Data & Transactional Data Master data should be heavily governed and does not typically change that often. Transactional data is the data resulting from the day to day happenings in the supply chain.
Master and Transaction tables are needed in the database schema specially in the verticals of sales.
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.
Transaction Data: Data which frequently changes. For example, the company is selling some materials to one of the customer.So they will prepare a sales order for the customer. When they will generate a sales order means they are doing some sales transactions.Those transactional data will be stored in Transactional table.
This is really required to maintain database normalization.
123
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
