ITFLINE FILE

                       Field Nbrs for Item Format

The Field Nbrs for Item Format file contains detail lines for the
User-Defined Item Format file. It contains all of the fields selected for the
item format.

REFERENCED BY

IC290     IC36.1

UPDATED BY

IC10.1    IC35.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IFL-COMPANY          Numeric 4                                   IC10.1  IC35.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

IFL-FORMAT-ID        Alpha 10                                    IC10.1  IC35.1
Format Id            This is the user-defined name given to
                     identify the form format.

IFL-FLD-NBR          Numeric 4                                   IC10.1  IC35.1
Dictionary Field     This field contains a number assigned
Number               to the field name in the data dictionary
                     used to validate the field attributes.

IFL-FLD-ORDER        Numeric 2                                   IC10.1  IC35.1
Field Order Number   This field contains a user-defined
                     number that determines the order the
                     field appear on the form.

IFL-REQUIRED-FL      Alpha 1                                     IC10.1  IC35.1
Required Flag        This field indicates whether the field
                     requires entry.
                     N = No
                     Y = Yes

IFL-DEFAULT-VALUE    Alpha 32                                    IC10.1  IC35.1
Default Value of     This field contains an automatically
Field                assigned value to the selected field.

                         ITFLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IFLSET1   COMPANY                                                IC10.1  IC10.2
          FORMAT-ID                                              IC35.1
          FLD-NBR

IFLSET2   COMPANY       KeyChange                                IC10.1  IC10.2
          FORMAT-ID                                              IC290   IC35.1
          FLD-ORDER                                              IC36.1
          FLD-NBR

                         ITFLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icdict         ICDICT       Required

                            IFL-FLD-NBR    -> IDI-FLD-NBR