Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICAUDIT


                              ICAUDIT FILE

                        Item/Item Location Audit

The Item/Item Location Audit file is created as a result of choosing the
audit options in IC00.1 (Corporate Item Group) and/or IC01.1 (Company). When
the options are selected, the file is updated whenever a change is made to
either the Item Master or the Item Location Master file.

UPDATED BY

IC11.1    IC12.1    IC12.2    IC320     IC330     IC811
IC812     PO150     PO25.6    PO25.7    PO36.2    PO536


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IAU-ITEM-GROUP         Alpha 5                                   IC11.1  IC12.1
Element: Item Group    This field contains the identifier for    IC12.2  IC320
                       a group of items that can be shared by    IC330   IC811
                       one or more companies.                    IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-COMPANY            Numeric 4                                 IC11.1  IC12.1
Element: Company       Identifies the AP company if the          IC12.2  IC320
                       resource type = V.  Identifies the HR     IC330   IC811
                       company if the resource type = E.  It is  IC812   PO150
                       blank for type A, P or Q resources.       PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-LOCATION           Alpha 5                                   IC11.1  IC12.1
Element: Location      This field contains a valid stocking      IC12.2  IC320
                       location within the company inventory.    IC330   IC811
                                                                 IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-ITEM               Alpha 32                                  IC11.1  IC12.1
Element: Item          This field contains the item's            IC12.2  IC320
                       identifier.                               IC330   IC811
                                                                 IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-DATE               Numeric 8  (yyyymmdd)                     IC11.1  IC12.1
Element: Date          This field contains the system date       IC12.2  IC320
                       when the audit record was created.        IC330   IC811
                                                                 IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-TIME               Numeric 8                                 IC11.1  IC12.1
Element: Time          This field contains the system time       IC12.2  IC320
                       when the audit record was created.        IC330   IC811
                                                                 IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-FLD-NBR            Numeric 4                                 IC11.1  IC12.1
Element: Fld Nbr       This field contains a unique number       IC12.2  IC320
                       assigned to a field that identifies the   IC330   IC811
                       description of the field.                 IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-BEFORE-IMAGE       Alpha 32                                  IC11.1  IC12.1
Element: Before Image  This field contains the field image       IC12.2  IC320
                       before the change.                        IC330   IC811
                                                                 IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-AFTER-IMAGE        Alpha 32                                  IC11.1  IC12.1
Element: Before Image  This field contains the field image       IC12.2  IC320
                       after the change.                         IC330   IC811
                                                                 IC812   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-DB-FILE            Alpha 3                                   IC11.1  IC12.1
Element: Db File       This field identifies which file is       IC12.2  IC320
                       being maintained by this audit record.    IC330   IC811
                       ITE = Item Master File (ITEMMAST)         IC812   PO150
                       ITL = Item Location File (ITEMLOC)        PO25.6  PO25.7
                                                                 PO36.2  PO536

IAU-OPERATOR-ID        Alpha 10                                  IC11.1  IC12.1
Element: Operator      This field contains the terminal sign     IC12.2  IC320
                       on when this update was performed to the  IC330   IC812
                       database.                                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536

                         ICAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IAUSET1   ITEM-GROUP
          COMPANY
          LOCATION
          ITEM
          DATE
          TIME
          FLD-NBR

                         ICAUDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required
                            When IAU-COMPANY != Zeroes

                            IAU-COMPANY       -> ICC-COMPANY

Icdict         ICDICT       Required

                            IAU-FLD-NBR       -> IDI-FLD-NBR

Itemgroup      ITEMGROUP    Required
                            When IAU-ITEM-GROUP != Spaces

                            IAU-ITEM-GROUP    -> ITG-ITEM-GROUP

Itemmast       ITEMMAST     Required

                            IAU-ITEM-GROUP    -> ITE-ITEM-GROUP
                            IAU-ITEM          -> ITE-ITEM

Location       ICLOCATION   Required

                            IAU-COMPANY       -> ICL-COMPANY
                            IAU-LOCATION      -> ICL-LOCATION