AMASTITINV – The Asset Item Master Inventory file contains the inventory information scanned by a hand-held terminal, and imported…

System
Asset Management (AM)
Prefix
IIV
Primary key
RUN-GROUP, BAR-CODE, CREATION-DATE, CREATION-TIME
Fields
11
Updated by
3 programs
Referenced by
1 program

AMASTITINV is the The Asset Item Master Inventory file contains the inventory information scanned by a hand-held terminal, and imported… table in Lawson Asset Management (prefix IIV). It is indexed by RUN-GROUP, BAR-CODE, CREATION-DATE, CREATION-TIME (IIVSET1). It is updated by AM152, AM154 and AM52.1 and referenced by AM252. The table has 11 fields, 1 index and 0 documented relations.

About AMASTITINV

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

Fields (11)

Column = COBOL field name without the IIV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#IIV-RUN-GROUP PK
RUN_GROUP		Alpha 15The run group is used to group records together for processing as a single file.AM154, AM52.1
#IIV-BAR-CODE PK
BAR_CODE		Alpha 30This field contains the scanned item bar code.AM154, AM52.1
#IIV-CREATION-DATE PK
CREATION_DATE		Numeric 8 (yyyymmdd)This field contains the date on which the asset item was scanned.AM154, AM52.1
#IIV-CREATION-TIME PK
CREATION_TIME		Numeric 6 (hhmmss)This field contains the time at which the asset item was scanned.AM154, AM52.1
#IIV-ITEM-CONDITION
ITEM_CONDITION		Alpha 1This field contains an assessment of the item's physical condition. Valid values are:
  • G Good
  • F Fair
  • D Damaged
AM154, AM52.1
#IIV-COMPANY
COMPANY		Numeric 4This field contains the company associated with the asset item.AM154, AM52.1
#IIV-INV-LOC-NAME
INV_LOC_NAME		Alpha 15This field contains the inventory location of the item.AM154, AM52.1
#IIV-INV-LOC-DTL
INV_LOC_DTL		Alpha 14This field contains the inventory location detail of the item.AM154, AM52.1
#IIV-INV-QTY
INV_QTY		Numeric 8This field contains the item quantity.AM154, AM52.1
#IIV-CREATOR-ID
CREATOR_ID		Alpha 10This field contains the ID of the person who created the inventory file.AM154
#IIV-ITEM-STATUS
ITEM_STATUS		Numeric 1This field contains the status resulting from the inventory comparison.AM152, AM52.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IIVSET1
  1. RUN-GROUP
  2. BAR-CODE
  3. CREATION-DATE
  4. CREATION-TIME
PrimaryAM152, AM154, AM252, AM52.1

Programs

Updated by (3)

Referenced by (1)