Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICDICT


                              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
Element: Data Type     This field indicates whether the field
                       is alphanumeric or numeric.
                       A = Alpha
                       N = Numeric

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

IDI-DECIMALS           Numeric 1                                 IC180
Element: Number of DeciThis field contains the number of
                       decimals in the database field.

IDI-REQUIRED-FL        Alpha 1                                   IC180
Element: All 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 )