|
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
|