Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


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