AMPRODCAT FILE
The Asset Management Product Category file maintains product category
information that can be downloaded to a Product Category Workbook to produce
scannable product category bar codes.
This file is populated by Product Category (AM06.3).
REFERENCED BY
AM206 AM154
UPDATED BY
AM06.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMP-COMPANY Numeric 4 AM06.3
Company This is the company for which product
category data is maintained.
AMP-ASSET-TYPE Alpha 10 AM06.3
Asset Type This is the asset type for which product
category is maintained.
AMP-SUB-TYPE Alpha 10 AM06.3
Sub Type This is the subtype for which product
category data is maintained.
AMP-BAR-CODE Alpha 30 AM06.3
Bar Code This is a unique product category bar
code generated by AM206 out of the data
entered on AM06.3.
AMP-VENDOR Alpha 9 (Right Justified) AM06.3
Vendor ID This is the manufacturer ID from which a
bar code is generated.
AMP-MANUFACTURER Alpha 30 AM06.3
Manufacturer This is the name of the manufacturer,
uniquely associated with the
manufacturer (vendor) ID.
AMP-ITEM-DESC Alpha 30 AM06.3
Item Description This is the product category
description..
AMP-MODEL-NBR Alpha 30 AM06.3
Model Nbr This is the model number for the product
category.
AMPRODCAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMPSET1 COMPANY
VENDOR
ASSET-TYPE
SUB-TYPE
MANUFACTURER
MODEL-NBR
AMPSET2 COMPANY AM06.3 AM206
ASSET-TYPE
SUB-TYPE
VENDOR
MANUFACTURER
MODEL-NBR
AMPSET3 VENDOR
MANUFACTURER
COMPANY
ASSET-TYPE
SUB-TYPE
MODEL-NBR
AMPSET4 BAR-CODE* AM06.3 AM154
COMPANY
ASSET-TYPE
SUB-TYPE
VENDOR
MANUFACTURER
MODEL-NBR
|