transaction file


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial.
Related to transaction file: master file

transaction file

[tran′sak·shən ‚fīl]
(computer science)

transaction file

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.

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
References in periodicals archive ?
The FB6011 instruments transmits weight data through a serial connection that can be interfaced to a (PC), and has the ability to export transaction files directly to a USB flash drive with csv format.
According to the complaint, Breitbart Texas reporter Lee Stranahan discovered data on the Center for American Future website that appeared to be credit card transaction files of people who had donated to Stockman's Senate campaign.
This kind of a system requires fully integrating every piece of data in all systems of records where customer data resides: from transaction files, from external files, and, of course, from detailed general ledger files.
The decision support files could be viewed as an unnecessary addition, as the same data could be gleaned from the transaction files.
The Laru software will monitor a bank's customer transaction files sent by First Data, developing profiles of each bank client.
She then deleted the transaction files from the computer, hoping to leave no trace on the patient records.
Using the SAFEView Document Management System, RELAY users can complete their online transaction files by uploading signed contracts and other necessary documents directly to RELAY with the click of a button.
Transaction files and reports, such as sales or purchases journals, job costing reports, fixed assets journals, payroll journal;

Full browser ?