Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMADDON


                             ITEMADDON FILE

                            Item Add On Cost

The Item Add-on Cost file.  Whenever a line is added to an order or invoice,
the program checks this file.  If an Item Add-on record exists for the
company, item, and state in this file (or for the company, item, and a blank
state), an add-on charge record is attached to the order and/or invoice line
automatically.

REFERENCED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL210     BL29.1    BL29.2    BL520     BL820
BL92.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE810     OE830
WH20.2    WH20.7

UPDATED BY

BL10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ITA-COMPANY            Numeric 4                                 BL10.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

ITA-ITEM               Alpha 32                                  BL10.1
Element: Item Number   This field contains the item
                       identifier.

ITA-STATE              Alpha 2                                   BL10.1
Element: State or ProviThis field contains the two-character
                       state code of the address of customers
                       that are to be assessed this charge.

ITA-MISC               Alpha 16                                  BL10.1
Element: Misc          This is the add-on charge code that is
                       attached to a percentage or amount that
                       is to be assessed to the line of the
                       order or invoice.

                         ITEMADDON FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITASET1   COMPANY                                                BL10.1  BL120
          ITEM                                                   BL122   BL130
          STATE                                                  BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL210   BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE111
                                                                 OE113   OE114
                                                                 ...

                         ITEMADDON FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            ITA-COMPANY       -> ICC-COMPANY

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ITA-ITEM          -> ITE-ITEM

Oecompany      OECOMPANY    Required

                            ITA-COMPANY       -> OEC-COMPANY

                         ITEMADDON FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oemisc         OEMISC       Required

                            ITA-COMPANY       -> OEM-COMPANY
                            ITA-MISC          -> OEM-MISC
                                                 OEM-CURRENCY-CODE