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.
Following are the kinds of fields that make up a typical master record in a business information system. There can be many more fields depending on the organization. The "key" fields below are the ones that 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 typical transaction records.
Following are the kinds of fields that make up a typical master record in a business information system. There can be many more fields depending on the organization. The "key" fields below are the ones that 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 typical 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
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Records Master 7.6 (Mac)
- Records Master is a secure file manager that allows you to collect important records (such as bank statements, credit card statements, bills, or receipts) or PDFs in a database and allow for: easy addition of new files importing, organization of files in hierarchical folders, optional organization of files by date,...
- Software downloads 2009-11-28
- CD Duplicate Master 1.0.0.1020 (Windows)
- CD Duplicate Master, a powerful CD duplicate utility, is designed to fit for CD duplicate fan's need. It can enables you to extract digital audio tracks from an audio CD into sound files on your hard disk; burn audio CD, data CD to blank CD disc, and data files to...
- Software downloads 2009-11-26
- TextExporter 2.1.2 (Mac)
- This InDesign plugin exports all the stories of an InDesign document into a single file. Features Include: Export text in three different file formats: Rich Text Format, InDesign Tagged Text and Text. Export stories belonging to a specified range of pages. Allows exclusion of stories on master...
- Software downloads 2009-11-26
- Digital Audio Editor 7.6.0.32 (Windows)
- Digital Audio Editor's friendly interface allows you to perform lots of different operations in easy way. You can use it to record your own music, voice or other audio, edit it, mix it with other audio or musical parts, add effects like reverb, chorus, and echo, and master it so...
- Software downloads 2009-11-26
- S10 Password Vault 3.1 (Windows)
- Store all your usernames/passwords and other account info on your PC with S10 Password Vault, strongly encrypted yet easily accessible using a single master password. It can auto-type the appropriate information for you in any website or program, without having to switch between windows as with copy/paste. Also features launching...
- Software downloads 2009-11-25
- A single search index would speed up the entire Internet
- Such cooperative efforts never work in the real worldIt's not like you can government-mandate this, because the internet is worldwide. And when you have this many groups involved that depend on this for making profits, you'll never get a consensus agreement on the finer details, and you'll never get everybody...
- Discussion threads 2009-11-24
- WireTap Studio 1.1.0 (Mac)
- WireTap Studio is a professional audio recording, editing, and management solution, allowing you to manage and manipulate your audio with ease. Discretely record from a specific application, record all of your Mac system audio simultaneously, or even record from any hardware/line-in device of your choice.After recording, edit your clips with...
- Software downloads 2009-11-24
- NBL Invoicing 1.3.1 (Windows)
- NBL Invoicing is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor invoicing process, from issue quotation/offer, receive sale order, issue delivery order to issue invoice. Master Editor: Store Customer, Employee, Organization particular/contact and Product information. Issuing: Print, fax Quotation, Delivery Order, Invoice...
- Software downloads 2009-11-23
- Radio Master 1.4 (Windows)
- Play and record radio in mp3 format. Watch tv channels. Main features: listen radio stations (over 1400, 53 - russian); watch TV channels (over 220, 70 - russian); record radio in MP3 format; add radio station to favorites; skins support. Version 1.3 includes clickable radio URL, window position is now...
- Software downloads 2009-11-20
- QIF Master 7.22 (Mac)
- QIF Master makes it easier to enter banking, credit card, and investment transactions into Quicken or other programs that accept Quicken Interchange Format QIF. Bank and Credit Card Transactions: Many online banks and credit card companies allow you to download recent transactions (checks, deposits, credit card charges, etc.) into a...
- Software downloads 2009-11-19
- NBL Purchasing 1.3.1 (Windows)
- NBL Purchasing is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor purchasing process, from receive quotation, issue purchase order, receive material to validate supplier bill. Includes features: Master Editor: Store Supplier, Employee, Organization particular / contact and Material information; Issuing: Print, fax...
- Software downloads 2009-11-19
- NBL Product Sale 1.3.1 (Windows)
- NBL Product Sale is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor sale process, include issue quotation, offer price and receive sale order Include feature: Master Editor: Store Customer, Employee, Organization particular / contact and Product information Issuing: Print, fax Quotation, Sale...
- Software downloads 2009-11-19
- Netman 5.59 (Windows)
- Netman is a high security and user-friendly remote control software that is free. As high security software it adopts the DSE encrypt mode generally used by banks which is safe and reliable. You can also set treble password to ensure the safety. Moreover, you can start your computer remotely when...
- Software downloads 2009-11-19
- KavaMovies 1.4.4 (Mac)
- KavaMovies lets you organize the movies you've seen, the movies you want to see, and the movies in your collection. It connects to the internet and downloads tons of information about each of your movies in realtime. Imgagine making a list of all the movies you've ever seen? You'd be...
- Software downloads 2009-11-18
- AthTek File Master 1.3 (Windows)
- AthTek File Master is both an encryption software and file management software rather than a simple file manager like windows explorer. AthTek File Master can convert ordinary file into compressed binary data. The binary data is saved in a protected database and kept away from virus and attack. After backup...
- Software downloads 2009-11-13
- NBL Inventory 1.3.1 (Windows)
- NBL Inventory is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor raw material warehouse or finished product stock quantity and movement Master Editor: Store Employee, Organization particular / contact and Material / Product information. Listing: Query, print or export master data and...
- Software downloads 2009-11-12
- Fresh FTP 5.24 (Windows)
- Fresh FTP File Transfer Protocol is a useful tool for Web master or Web site owner to upload or download Web content (HTML, graphic, SQL backup file, and Web site statistic) from the server. This FTP client software supports ability to resume broken uploads, file and directory upload. This software...
- Software downloads 2009-11-10
- Power Audio Editor 7.4.3.70 (Windows)
- Friendly interface allows you to perform lots of different operations in easy way. You can use it to record your own music, voice or other audio, edit it, mix it with other audio or musical parts, add effects like Reverb, Chorus, and Echo, and master it so that you can...
- Software downloads 2009-11-10
- CD Storage Master 7.0.5 (Windows)
- CD Storage Master is a professional CD catalog/CD database software, Manage your CD/DVD collection for all windows platforms. CD Storage Master can load not only file name, size, create time, modify time but also metadata of file (such as MP3 ID3 Tag, image file width, height and color, Microsoft Office...
- Software downloads 2009-11-08
- Mobile Master 7.5.5 (Windows)
- Mobile Master is a powerful PIM and synchronization tool for mobile phones and iPod. You can synchronize mobile phones addresses and calendar with Outlook (97-2007), Outlook Express, Windows address book, Windows contacts, Lotus Notes, Thunderbird/Sunbird, Palm Desktop, Novell Groupwise Tobit David InfoCenter. You can load, edit and save your phones...
- Software downloads 2009-11-08
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
- Learn more about tools to grow your business
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Save time with the UPS Business Essentials Guide
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
Meet Doc
-
-
Here to help you with your Document Management Needs
- Check out Doc’s Blog on ZDNet
- Help your company, help the earth I want to share with you the Environmental Defense Fund Paper Calculator, which allows you to gauge your organization's environmental impact.
- Which is Greener: Paper or Digital? The Answer May Surprise You Anything we can do to reduce paper consumption is good. But what about the impact of digital waste?
-
Produced by
ZDNet and -
