Master-file meaning

A collection of records pertaining to one of the main subjects of an information system, such as customers, employees, products and vendors. Master files contain descriptive data, such as name and address, as well as summary information, such as amount due and year-to-date sales. Contrast with transaction file. See master data management.Although there can be many more, following are the typical fields in a business master record. The "key" fields are generally indexed for matching against the transaction records as well as fast retrieval for queries. The account number is usually the primary key, but name may also be primary. There can be secondary indexes; for example, in an inverted file structure, almost all the fields could be indexed. See transaction file for examples of transaction records.EMPLOYEE MASTER RECORD key Employee account number key Name (last) Name (first) Address, city, state, zip Hire date Birth date Title Job class Pay rate Year-to-date gross pay CUSTOMER MASTER RECORD key Customer account number key Name Bill-to address, city, state, zip Ship-to address, city, state, zip Credit limit Date of first order Sales-to-date Balance due VENDOR MASTER RECORD key Vendor account number key Name Address, city, state, zip Terms Quality rating Shipping method PRODUCT MASTER RECORD key Product number key Name Description Quantity on hand Location Primary vendor Secondary vendor.
3
0
Advertisement