Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ICDICT FILE

                     Item/Item Location Dictionary

The Item/Item Location Dictionary file is a file of all Item Master and Item
Location fields that can be selected for user-defined item maintenance and
inquiry formats. Initially, IC180 (Dictionary Setup) must be run once to load
this file.

REFERENCED BY

IC00.1    IC01.1    IC10.1    IC10.2    IC11.1    IC12.1
IC183     IC191     IC192     IC290     IC330     IC35.1
IC36.1

UPDATED BY

IC180

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IDI-FLD-NBR          Numeric 4                                   IC180
Dictionary Field     This field contains a unique number
Number               assigned to the field.

IDI-FLD-NAME         Alpha 15                                    IC180
Dictionary Field     This field contains the database field
Name                 name.

IDI-DB-FILE          Alpha 3                                     IC180
Data Base File       This field identifies the file related
Prefix               to the field name.
                     ITE = Item Master File (ITEMMAST)
                     ITL = Item Location File (ITEMLOC)

IDI-PROMPT           Alpha 20                                    IC180
Prompt Name for a    This field contains the name for the
Field                field that displays on forms or prints
                     on reports identifying the field.

IDI-DATA-TYPE        Alpha 1                                     IC180
Data Type            This field indicates whether the field
                     is alphanumeric or numeric.
                     A = Alpha
                     N = Numeric

IDI-SIZE             Numeric 2                                   IC180
Size                 This field contains the size of the
                     database field.

IDI-DECIMALS         Numeric 1                                   IC180
Number of Decimals   This field contains the number of
                     decimals in the database field.

IDI-REQUIRED-FL      Alpha 1                                     IC180
Required Flag        This field indicates whether the
                     database field is required.
                     N = No
                     Y = Yes

                         ICDICT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IDISET1   FLD-NBR                                                IC00.1  IC01.1
                                                                 IC10.1  IC10.2
                                                                 IC11.1  IC12.1
                                                                 IC180   IC183
                                                                 IC191   IC192
                                                                 IC290   IC330
                                                                 IC35.1  IC36.1

IDISET2   FLD-NBR       Subset
                        Where (FLD-NBR >  Zeroes
                        And    FLD-NBR <= 196 )
                        Or    (FLD-NBR >= 515
                        And    FLD-NBR <= 603 )