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.
|