iMIS Customers feature terms

Before using iMIS Customers, you need to know these terms:

Database

A database is a collection of related information that is organized into meaningful units (for example, files, records, fields, graphics, and photos) for dedicated storage and access.

Table

A table is the highest organizational unit in the database. The iMIS files used most often in the Customer system are the Name tables. The convention for entering field definitions is to put the table name in title-case followed by a period and the field name in capital letters:

Table_Name.FIELD_NAME

Record

A record is an individual unit in a file containing a collection of fields. These fields are consistent in number and type from one record to the next. For example, a separate record is stored in the customer file for each individual or company in the system. (A record is also called a row).

Field

A field is an individual data element in a record (also called a row). A field may display in a data maintenance window in the form of a labeled text box or check box.