Following are the kinds of fields that make up a typical transaction 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 fast matching against the master record. The account number is usually the primary key, but name may also be used as a primary key. See master file for examples of typical master records.
EMPLOYEE PAYROLL RECORD
key Employee account number
Today's date
Hours worked
ORDER RECORD
key Customer account number
Today's date
Quantity
Product number
PAYMENT RECORD
key Customer number
Today's date
Invoice number
Amount paid
Check number
PURCHASE ORDER
key Purchase order number
Today's date
Department
Authorizing agent
Vendor account number
Quantity
Product number
Due date
Total cost
WAREHOUSE RECEIPT
key Purchase order number
key Invoice number
Today's date
Quantity
Product number
![]() | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- More security holes appear in Microsoft Office
- In addition to this long list of missing Microsoft patches, there are at least three serious unpatched vulnerabilities in the Microsoft Office productivity suite. On August 12, the same day Microsoft released a slew of Office patches, TippingPoint's DV Labs published a bare-bones advisory warning about a...
- Blog posts 2008-08-21
- Dell bets on Salesforce.com's platform as a service
- Amid a quarter that Salesforce.com CEO Marc Benioff called "spectacular," but spooked analysts worried about future growth was an interesting nugget: Dell has jumped on the platform as a service bandwagon. On Salesforce.com's second quarter conference call (earnings recap, InStranet acquisition) Benioff revealed that Dell signed a...
- Blog posts 2008-08-21
- Amazon: Persistent storage open for EC2
- Amazon said Thursday that its Elastic Block Store feature is now available to all of its EC2 Web service customers. The move gives Amazon Web Services a full storage suite delivered as a service. EC2 is Amazon's storage service and the Elastic Block Store gives customers a...
- Blog posts 2008-08-21
- The Waltham Pact: Where are the tangibles?
- This week, Microsoft renewed their union with Novell, to the tune of an additional 100 million dollars in commitment to buy more SUSE Linux support certificates that it can sell to its customers. Dang, Ballmer, for that kind of cash, you can get your vows renewed...
- Blog posts 2008-08-20
- New touch screen Classmates unveiled today
- Intel unveiled a new iteration of its Classmate PC today, featuring a touch screen with tablet mode, a new wedge design, and motion-sensing internal hardware. According to Intel's press release, "Our ethnographic research has shown us that students responded well to tablet and touch screen...
- Blog posts 2008-08-20
- Opera patches 7 vulnerabilities but keeps one a secret
- Opera Software has shipped a new version of its flagship Web browser with fixes for at least seven documented security problems but details on one vulnerability -- a cross-site scripting issue reported by Chris Weber-- is being kept under wraps. Opera warned that one of the seven...
- Blog posts 2008-08-20
- What SaaS can teach us about customer service
- In the SaaS model, the power is with the customer and vendors need to take a very different approach to both sales and service, here's how to do it says Archie Black, President and CEO of SPS Commerce. Commentary--Software-as-a-Service SaaS is one of the fastest growing segments of...
- News items 2008-08-20
- Yahoo: TV widgets and pondering a Disney takeover
- If Yahoo's battle with Google has taught us anything it's that the company isn't run by engineers. Sure, Yahoo is tech savvy. Sure it has an open platform. And sure it'll do things like plan a Widget Channel with Intel and tout it at a developers conference. But Yahoo is...
- Blog posts 2008-08-20
- Can Adobe mitigate 'clipboard hijack' issue?
- Adobe's product security incident response team PSIRT says it is investigating possible solutions to the clipboard hijack attacks spotted on Flash-based advertisements on high-profile Web sites. A barebones note on the PSIRT blog simply acknowledges the issue and promised more information after the investigation but, by mentioning...
- Blog posts 2008-08-20
- Why do you want WinFS?
- Every time the conversation turns to Windows 7, the subject of WinFS comes up. This next-generation file storage software was cut from Windows Vista and eventually killed completely nearly four years ago. But it keeps reappearing on lists of features that people want to see in Windows 7. Why? WinFS...
- Blog posts 2008-08-20
- Visa, banks to test real-time fraud alerts
- Credit card giant Visa is teaming up with with eight North American banks to deliver fraud alerts in real-time via SMS text messages and e-mails to cell phones. The pilot program will allow about 2,000 Visa cardholders to set thresholds that will trigger an immediate transaction alert...
- Blog posts 2008-08-20
- PDF Splitter and Merger (exe)
- PDF Splitter and Merger is a PDF tool developed for quicker and more efficient access to information needed from your PDF files, reorganizing them in a way that makes them easier to manage and handle. With the ability to split PDF files into separate documents, either by page range or...
- Software downloads 2008-08-20
- FictionSoftware HashTray (exe)
- HashTray is a windows hash calculator for verification of file integrity. With HashTray you can generate different hashes for a single file, or use the multi file hasher to easy compare files or find duplicate files. Use the 'Download & Verify' feature to automatically validate downloaded files. This version is...
- Software downloads 2008-08-20
- Windows 7 wishes
- Windows 7 wishesOn layers.Per Ed's post, IE 8 continues to be integrated and integral to the OS. It is likely that many other user space apps that MS creates, will at least be partially embedded, if not completely.End user applications have no business being part of the OS itself,...
- Discussion threads 2008-08-19
- IE 8 to get 'porn mode'?
- IE 8 to get 'porn mode'?Double-edged swordsSeveral years ago, our company implemented very stringent usage rules on our IT assets, including Internet access. And the IT department installed "monitoring tools" aka spyware to keep an eye on the rank-and-file.The result? A number of employees got fired for surfing porn, trading...
- Discussion threads 2008-08-19
- Apple releases iPhone 2.0.2, as usual, sans changelog
- Apple releases iPhone 2.0.2, as usual, sans changelogJust do it!Come on, you bought the iPhone because Brother Steve knows what's cool. And what's good for you. He wants you to update your phone, so just do it! You'll thank him later.The morgue called.They said they found the...
- Discussion threads 2008-08-19
- Psystar fails to meet court deadline again
- Psystar fails to meet court deadline againThey have NOT failed to meet a court deadline!!!"that an extension has been granted"They simply had the date moved.The court permitted it, so it's NOT a "failed to meet a court deadline" thing.Is there no law to stop Bloggers from printing a deliberate lie?Not...
- Discussion threads 2008-08-19
- My Windows 7 wish list
- My Windows 7 wish listPut more muscle in thereWhen you pay 100+ bucks, you'd expect it's loaded with more than just Notepad or Paint. Those two haven't had much major upgrade since Windows 3.0. If you want some themes, you shouldn't have to pay another 40 or so to get...
- Discussion threads 2008-08-19
- An Event Apart 2008: Day 2
- The second day of An Event Apart will feature plenty of web standards jargon. I will be posting photos and notes from today's events. Unfortunately, the slides are reserved for attendees only, but I will try to gather as much information as...
- Blog posts 2008-08-19
- Excel and Basic Accounting Error
- Excel and Basic Accounting ErrorWe should go back to manual ledgers...VisiCalc was created to eliminate accounting errors. Now the spreadsheet is now being blamed for accounting errors. Perhaps the real problem is GIGO. Garbage in, Garbage out.The real culprit is slick sleaze ball corporate accountants and managers that are trying...
- Discussion threads 2008-08-19
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Which solar technology will survive?
-
At the Cleantech Forum in San Francisco, Todd Glass of Heller Ehrman moderates a discussion, among tech execs, on the various solar technologies making a difference in the green movement.
- Watch the video >>
- Access the latest Intel and industry best practices
-
Designed specifically to address the concerns of senior IT managers at organizations with more than 100 employees, the Intel Premier IT Professional Program provides best practices via local and e-Seminars and a members-only Web site.
- View the Intel Premier IT Professional web-site tour >>








