Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITCOMMENT


                             ITCOMMENT FILE

REFERENCED BY

BL122     BL80.1    IC210     IC211     IC212     PO130
PO220     PO230     POCP.1    POI7.1    WH130     WH222
WH224

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          This field contains the item
                       identifier.

ICO-SEQ                Numeric 3                                 IC18.1  IC811
Element: Seq           This field contains the record sequence
                       number.

ICO-COMMENT            Alpha 40  (Lower Case)
Element: Comment       This field contains the comment
                       narrative.

ICO-BEGIN-DATE         Numeric 8  (yyyymmdd)                     IC18.1  IC811
Element: Begin Date    The begin date for this effort period.

ICO-END-DATE           Numeric 8  (yyyymmdd)                     IC18.1  IC811
Element: End Date      The end date for this effort period.      WH130

ICO-COM-TYPE           Alpha 1                                   IC18.1  IC811
Element: Com Type

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                                             BL122   BL80.1
          ITEM                                                   IC11.1  IC18.1
          LANGUAGE-CODE                                          IC210   IC211
          SEQ                                                    IC212   IC811
                                                                 PO130   PO220
                                                                 PO230   POCP.1
                                                                 POI7.1  WH130
                                                                 WH222   WH224

                         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