Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITFLINE


                              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
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

IFL-FORMAT-ID          Alpha 10                                  IC10.1  IC35.1
Element: Format Id     This is the user-defined name given to
                       identify the format that this line is
                       for.

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
Element: Field Order NuThis 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
Element: All 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