Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTITINV


                            AMASTITINV FILE

The Asset Item Master Inventory file contains the inventory information
scanned by a hand-held terminal, and imported using the importdb utility.

REFERENCED BY

AM252

UPDATED BY

AM152     AM154     AM52.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IIV-RUN-GROUP          Alpha 15                                  AM154   AM52.1
Element: Run Group     The run group is used to group records
                       together for processing as a single
                       file.

IIV-BAR-CODE           Alpha 30                                  AM154   AM52.1
Element: Bar Code      This field contains the scanned item bar
                       code.

IIV-CREATION-DATE      Numeric 8  (yyyymmdd)                     AM154   AM52.1
Element: Date          This field contains the date on which
                       the asset item was scanned.

IIV-CREATION-TIME      Numeric 6  (hhmmss)                       AM154   AM52.1
Element: Sys Time      This field contains the time at which
                       the asset item was scanned.

IIV-ITEM-CONDITION     Alpha 1                                   AM154   AM52.1
Element: Item ConditionThis field contains an assessment of the
                       item's physical condition.  Valid values
                       are:
                       G = Good
                       F = Fair
                       D = Damaged

IIV-COMPANY            Numeric 4                                 AM154   AM52.1
Element: Company       This field contains the company
                       associated with the asset item.

IIV-INV-LOC-NAME       Alpha 15                                  AM154   AM52.1
Element: Inv Loc Name  This field contains the inventory
                       location of the item.

IIV-INV-LOC-DTL        Alpha 14                                  AM154   AM52.1
Element: Inv Loc Dtl   This field contains the inventory
                       location detail of the item.

IIV-INV-QTY            Numeric 8                                 AM154   AM52.1
Element: Inv Qty       This field contains the item quantity.

IIV-CREATOR-ID         Alpha 10                                  AM154
Authorization          This field contains the ID of the person
Identification         who created the inventory file.

IIV-ITEM-STATUS        Numeric 1                                 AM152   AM52.1
Element: Item Status   This field contains the status resulting
                       from the inventory comparison.

                         AMASTITINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IIVSET1   RUN-GROUP                                              AM152   AM154
          BAR-CODE                                               AM252   AM52.1
          CREATION-DATE
          CREATION-TIME