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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AMP-COMPANY PKCOMPANY | Numeric 4 | This is the company for which product category data is maintained. | AM06.3 |
AMP-ASSET-TYPE PKASSET_TYPE | Alpha 10 | This is the asset type for which product category is maintained. | AM06.3 |
AMP-SUB-TYPE PKSUB_TYPE | Alpha 10 | This is the subtype for which product category data is maintained. | AM06.3 |
AMP-BAR-CODEBAR_CODE | Alpha 30 | This is a unique product category bar code generated by AM206 out of the data entered on AM06.3. | AM06.3 |
AMP-VENDOR PKVENDOR | Alpha 9 (Right Justified) | This is the manufacturer ID from which a bar code is generated. | AM06.3 |
AMP-MANUFACTURER PKMANUFACTURER | Alpha 30 | This is the name of the manufacturer, uniquely associated with the manufacturer (vendor) ID. | AM06.3 |
AMP-ITEM-DESCITEM_DESC | Alpha 30 | This is the product category description.. | AM06.3 |
AMP-MODEL-NBR PKMODEL_NBR | Alpha 30 | This is the model number for the product category. | AM06.3 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AMPSET1 | COMPANY, VENDOR, ASSET-TYPE, SUB-TYPE, MANUFACTURER, MODEL-NBR | Primary | — | |
AMPSET2 | COMPANY, ASSET-TYPE, SUB-TYPE, VENDOR, MANUFACTURER, MODEL-NBR | AM06.3, AM206 | ||
AMPSET4 | BAR-CODE*, COMPANY, ASSET-TYPE, SUB-TYPE, VENDOR, MANUFACTURER, MODEL-NBR | AM06.3, AM154 |
Programs
Updated by (1)
- AM06.3 Product Category