Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITCOMMENT


                             ITCOMMENT FILE

The Item Comments file stores the comments associated with an Item Master
record. Each item can have up to 999 comments. These comments can be selected
to print on various reports in the Inventory Control, Purchase Order, Order
Entry, and Work Order systems.

REFERENCED BY

IC110     IC210     IC211     IC212     SEA1.1    PO130
PO220     PO230     POCP.1    POI7.1    SEA3.1    WH130
WH222     WH224     WO131

UPDATED BY

IC11.1    IC18.1    IC811

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICO-ITEM-GROUP         Alpha 5                                   IC18.1  IC811
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.

ICO-ITEM               Alpha 32                                  IC18.1  IC811
Element: Item Number   This field contains the item
                       identifier.

ICO-SEQ                Numeric 3                                 IC18.1  IC811
Element: Sequence NumbeThis field contains the sequential
                       number assigned to a line of comments.

ICO-COMMENT            Alpha 40  (Lower Case)
Element: Comment Line  This field contains the comment text
                       about the item.

ICO-BEGIN-DATE         Numeric 8  (yyyymmdd)                     IC18.1  IC811
Element: Date          This field contains the beginning date
                       for the comment line to be printed on
                       any report.

ICO-END-DATE           Numeric 8  (yyyymmdd)                     IC18.1  IC811
Element: Date          This field contains the ending date for   WH130
                       the line comment that is printed on any
                       report.

ICO-COM-TYPE           Alpha 1                                   IC18.1  IC811
Element: Bin Usage TypeThis type code determines on which
                       report this line prints.

ICO-LANGUAGE-CODE      Alpha 10                                  IC18.1
Element: Language Code Language Code (LOCALE).

                         ITCOMMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICOSET1   ITEM-GROUP                                             IC11.1  IC110
          ITEM                                                   IC18.1  IC210
          LANGUAGE-CODE                                          IC211   IC212
          SEQ                                                    IC811   SEA1.1
                                                                 PO130   PO220
                                                                 PO230   POCP.1
                                                                 POI7.1  SEA3.1
                                                                 WH130   WH222
                                                                 WH224   WO131

                         ITCOMMENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            ICO-ITEM-GROUP    -> ITG-ITEM-GROUP

Itemmaster     ITEMMAST     Required

                            ICO-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ICO-ITEM          -> ITE-ITEM