Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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