Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

BL210

UPDATED BY

BL10.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ITA-COMPANY          Numeric 4                                   BL10.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

ITA-STATE            Alpha 2                                     BL10.1
State or Province    This 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
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  BL210
          ITEM
          STATE

                         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