Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMPRODCAT


                             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
Element: Company       This is the company for which product
                       category data is maintained.

AMP-ASSET-TYPE         Alpha 10                                  AM06.3
Element: Asset Type    This is the asset type for which product
                       category is maintained.

AMP-SUB-TYPE           Alpha 10                                  AM06.3
Element: Sub Type      This is the subtype for which product
                       category data is maintained.

AMP-BAR-CODE           Alpha 30                                  AM06.3
Element: 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
Element: Vendor ID     This is the manufacturer ID from which a
                       bar code is generated.



AMP-MANUFACTURER       Alpha 30                                  AM06.3
Element: Manufacturer  This is the name of the manufacturer,
                       uniquely associated with the
                       manufacturer (vendor) ID.

AMP-ITEM-DESC          Alpha 30                                  AM06.3
Element: Item DescriptiThis is the product category
                       description..

AMP-MODEL-NBR          Alpha 30                                  AM06.3
Element: Model Number  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

AMPSET4   BAR-CODE*                                              AM06.3  AM154
          COMPANY
          ASSET-TYPE
          SUB-TYPE
          VENDOR
          MANUFACTURER
          MODEL-NBR