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

IC10.2    IC11.1    IC12.1    IC12.2    IC183     IC191
IC192     IC320     IC330     IC81.1    IC811     IC812
PO150     PO25.6    PO25.7    PO36.2    PO536

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

IAU-COMPANY            Numeric 4                                 IC10.2  IC11.1
Element: Company       The company number represents an          IC12.1  IC12.2
                       established company and is entered on     IC183   IC320
                       all function codes.                       IC330   IC81.1
                                                                 IC811   IC812
                                                                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536

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

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

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

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

IAU-FLD-NBR            Numeric 4                                 IC10.2  IC11.1
Dictionary Field       This field contains a unique number       IC12.1  IC12.2
Number                 assigned to a field that identifies the   IC183   IC320
                       description of the field.                 IC330   IC81.1
                                                                 IC811   IC812
                                                                 PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536

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

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

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

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

                         ICAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IAUSET1   ITEM-GROUP                                             IC191   IC192
          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