A collection of transaction records. The data in transaction files is used to update the master files, which contain the data about the subjects of the organization (customers, employees, vendors, etc.). Transaction files also serve as audit trails and history for the organization. Where before they were transferred to offline storage after some period of time, they are increasingly being kept online for routine analyses. See data warehouse, transaction processing and information system.
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.
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-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- SQLWriter 2.3.0 (Windows)
- SQLWriter is a powerful SQL script editor for all database developers and database administrators. It can edit different database SQL scripts in the same window and support Windows 98, Windows NT 4.0, Windows 2000, Windows ME, Windows XP and Window2003. In addition, it also edits or runs SQL queries and...
- Software downloads 2009-11-23
- 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
- Corona 3.3 (Mac)
- Originally introduced in 2001, Corona has been upgraded regularly to become a full general ledger accounting tool, yet still retains its "simple check register" appeal and price. Corona features "drag and drop" accounting, on-the-fly account creation, and one-click reconcilement. Innovations: On-the-fly account creation Journal selector for entry forms Popup selectors...
- Software downloads 2009-11-16
- Warehouse Inventory 1.0 (Windows)
- Mange your inventory with this easy to learn software. If you have an online shop for example this program helps you to keep the overview. You can use a barcode scanner or input the article number manually or simply click a button to increase or decrease the quantity of an...
- Software downloads 2009-11-15
- NBL Finance Tool 1.3.1 (Windows)
- NBL Finance Tool is a Windows database-driven software designed for personal, soho, small and medium size company, to manage and monitor personal or organization money, expenses and cheque transaction include cheque printer. Includes features: Master Editor: Store Bank, Employee, Organization particular / contact and Account information. Issuing: Print and configure...
- Software downloads 2009-11-06
- Net neutrality: a faster Internet for all
- If I pay my ISP for fast speeds, I should get it.If I pay my ISP for fast speeds, I should get it.I do [b]not[/b] want my internet to slow down just because some person on the [b]other[/b] end didn't pay for priority traffic.Net Neutrality had to happen in the...
- Discussion threads 2009-10-23
- 01 Transaction Pro Exporter 3.0 (Windows)
- Need to export transaction data from QuickBooks. Look no further than the Transaction Pro Exporter. With a few clicks you have QuickBooks transaction or list data exported into excel in a usable flat file format. Use in conjunction with the 01 Transaction Pro Importer to move transactions from one QuickBooks...
- Software downloads 2009-10-18
- Zed Axis 4.0.28 (Windows)
- Zed Axis is the best way to import transaction data into QuickBooks, it will save you hours in data entry and reduce costly mistakes. Import invoices, sales receipts, sales orders, receive payments, credit memos, bills, checks, credit card payments, journals, timesheets from spreadsheets or text files directly into your QuickBooks...
- Software downloads 2009-10-09
- Open source and forced obsolescence
- You gutted your own articleFirst, no one forces you to update your software, period. There *are* companies that won't support antiques, and who can blame them? Support costs are very high, especially since one person or team can't be expected to be expert in a dozen different versions of the...
- Discussion threads 2009-10-02
- .NET ZIP Component for C#,VB,ASP.NET 3.0 (Windows)
- NetXtremeZip is an advanced ZIP compression library for .NET Framework. It is designed to put flexibility into the hands of developer with a lot of features including Deflate64�¢�?�¢, BZip2, and PPMd compression methods, Zip64, PKZip and AES encryptions, streaming, transaction, repairing, unicode file names and much more. The component is...
- Software downloads 2009-09-29
- Should "Patch Tuesday" updates include a free virus scan?
- No, because if Microsoft was to offer such a service the other antivirus companies will cry about it and more antitrust issues will come up. I really don't think Microsoft would be able to do it from a legal stand point. There may also be an issue of conflicting...
- Discussion threads 2009-09-21
- E-Mergence Log Detective 1.3.1 (Windows)
- E-Mergence Log Detective provides capabilities for mining the vast amounts of data in Web log files to get valuable information about users' patterns, your site performance, or information of other similar nature. Log File Searching: E-Mergence Log Detective provides the ability to search using information readily available in your log...
- Software downloads 2009-08-18
- BreachGuard 1.0 (Windows)
- BreachGuard can protect you from potential online identity theft by preventing inadvertent or accidental leakage of credit card numbers over clear-text protocols and applications such as outlook, webmail, Yahoo, Hotmail, Gmail, instant messaging IM, FTP, HTTP, SMTP. It also provides you with the option to block or allow the insecure...
- Software downloads 2009-08-10
- EURO-Ueberweisung 2.1 (Windows)
- German application to perform wire transfers. With this program you can transmit foreign remittances and DTA files or via HBCI online to your bank . Once entered transfers can be saved as a template. Thus, the data can be easily used for a re-booking. This allows a simple way of...
- Software downloads 2009-07-29
- SmartCVS Professional 7.0.9 (Mac)
- SmartCVS Professional is a very powerful and still easy to use CVS client which contains all required tools (e.g. SSH-client, file compare). It runs on all major platforms (Windows NT/2000/XP/2003/98/ME, Linux, Solaris, MacOSX). Major features include: supported authentication methods: pserver, sserver, ext (SSH1+SSH2) single-click-commit (automatically adds/removes unversioned/missing...
- Software downloads 2009-07-29
- Tripwire Case Study: Sitel, Inc.
- Sitel is a global Business Process Outsourcing BPO leader. The company meets clients' customer care and transaction processing needs through 60,000 associates in 27 countries. The challenge was to attain a state of standardized audit readiness and compliance across multiple data centers, for meeting PCI DSS requirements, and other forthcoming...
- Case studies 2009-07-16
- NBL Finance Tool 1.2.5 (Windows)
- NBL Finance Tool is a Windows database-driven software designed for personal, soho, small and medium size company, to manage and monitor personal or organization money, expenses and cheque transaction include cheque printer. Includes features: Master Editor: Store Bank, Employee, Organization particular / contact and Account information. Issuing: Print and configure...
- Software downloads 2009-07-09
- DMT SQL Backup Manager 2.4 (Windows)
- DMT SQL Backup Manager is a powerful tool for creating, compressing and protecting your SQL Server backups. Compatible with SQL Server 2000 and 2005, it includes a range of features to make backups faster, simpler and more secure. The backup files generated by this application are up to 90% smaller...
- Software downloads 2009-07-01
- Checkmark MultiLedger 7.1.1 (Mac)
- MultiLedger is an integrated accounting program combining General Ledger, Accounts Receivable, Accounts Payable, and Inventory. MultiLedgerprovides invoicing, profit centers, job costing, and commissionable sales. Full Import/Export including transactions is built-in.MultiLedger maintains a full year of transaction history. Transactions can be modified, and adjustments can be made to any month in...
- Software downloads 2009-06-26
- eBay scammers try to scam security expert
- eBay scammers try to scam security expertIt sounds like the system works quite well!Since in both cases the scammer failed, I would have to say that the system works quite well. What this story does tell us though is that sellers might want to hold off a day before sending...
- Discussion threads 2009-06-22
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- 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>>
- Save time with automated shipping solutions
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Visit the UPS Business Essentials Guide
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- Can your business work smarter? Learn more about Lotus Symphony
- Learn how to work smarter and optimize cost using the IBM Smart SOA approach Download the eBook
- Smarter ways to make smarter products Read the brief from IBM
