AMPRODCAT – Asset Product Category

System
Asset Management (AM)
Prefix
AMP
Primary key
COMPANY, VENDOR, ASSET-TYPE, SUB-TYPE, MANUFACTURER, MODEL-NBR
Fields
8
Updated by
1 program
Referenced by
2 programs

AMPRODCAT is the Asset Product Category table in Lawson Asset Management (prefix AMP). It is indexed by COMPANY, VENDOR, ASSET-TYPE, SUB-TYPE, MANUFACTURER, MODEL-NBR (AMPSET1); alternate indexes: AMPSET2 and AMPSET4. It is updated by AM06.3 and referenced by AM154 and AM206. The table has 8 fields, 3 indexes and 0 documented relations.

About AMPRODCAT

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

Fields (8)

Column = COBOL field name without the AMP- 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
#AMP-COMPANY PK
COMPANY		Numeric 4This is the company for which product category data is maintained.AM06.3
#AMP-ASSET-TYPE PK
ASSET_TYPE		Alpha 10This is the asset type for which product category is maintained.AM06.3
#AMP-SUB-TYPE PK
SUB_TYPE		Alpha 10This is the subtype for which product category data is maintained.AM06.3
#AMP-BAR-CODE SET4
BAR_CODE		Alpha 30This is a unique product category bar code generated by AM206 out of the data entered on AM06.3.AM06.3
#AMP-VENDOR PK
VENDOR		Alpha 9 (Right Justified)This is the manufacturer ID from which a bar code is generated.AM06.3
#AMP-MANUFACTURER PK
MANUFACTURER		Alpha 30This is the name of the manufacturer, uniquely associated with the manufacturer (vendor) ID.AM06.3
#AMP-ITEM-DESC
ITEM_DESC		Alpha 30This is the product category description..AM06.3
#AMP-MODEL-NBR PK
MODEL_NBR		Alpha 30This is the model number for the product category.AM06.3

Indexes (3)

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
AMPSET1
  1. COMPANY
  2. VENDOR
  3. ASSET-TYPE
  4. SUB-TYPE
  5. MANUFACTURER
  6. MODEL-NBR
Primary—
AMPSET2
  1. COMPANY
  2. ASSET-TYPE
  3. SUB-TYPE
  4. VENDOR
  5. MANUFACTURER
  6. MODEL-NBR
AM06.3, AM206
AMPSET4
  1. BAR-CODE ↓
  2. COMPANY
  3. ASSET-TYPE
  4. SUB-TYPE
  5. VENDOR
  6. MANUFACTURER
  7. MODEL-NBR
AM06.3, AM154

Programs

Updated by (1)

Referenced by (2)