Understanding Record Tables

Each Record Table in the Data Dictionary describes the fields that exist in each record in a  file.  The table below describes the field information, which is displayed in each column of a Record Table.

Note:  To see a list of Record Tables for the files in the software module, refer to the Data Dictionary Overview.

 

Record Table Columns

Field Name Column

Lists the name of the field.

Notes:

  • The field name is required for the report or project that you build using a third-party application such as Crystal Reports™.

  • Frequently, you can click the field name to see more information about the field and where it is used.

  • (Key) next to a field name indicates that this is the specific field of information used to access a record(s) in a Record Table or file. For example, the Account Number is the key to the Customer Master file.

Length Column

Lists the maximum field length.

Notes:

  • x:  Indicates a STRING field length.

  • (x.y):  Indicates a numeric field length (either INTEGER OR DOUBLE), where x is the number of digits to the left of the decimal and y is the number of digits to the right of the decimal.
    Example
    :  (4.2) means 4 digits to the left and 2 digits to the right of the decimal, a total of 6 digits.

  • DATE:  Indicates a field formatted as a date.  Date field lengths can vary depending on the method for storing the century.

  • TIME:  Indicates a field formatted for time.

Format Column

Describes the field format and how it is displayed.  This information may be helpful when planning your project.

  • DOUBLE:  Indicates a numeric field with digits to the left and right of the decimal place.

  • INTEGER:  Indicates a numeric field that contains a whole number.  (In the field length column, y is always zero).

  • STRING:  Indicates an alphanumeric field that contains a string of text.  A text string can contain any combination of characters including letters, words, numbers, and spaces.