AMASSETGRP – Asset Group

System
Asset Management (AM)
Prefix
ATG
Primary key
ASSET-GROUP
Fields
5
Updated by
267 programs
Referenced by
6 programs

AMASSETGRP is the Asset Group table in Lawson Asset Management (prefix ATG). It is indexed by ASSET-GROUP (ATGSET1). It is related 1:M to AMASSET. It is updated by AC160, AM115, AM117, AM125, AM13.1, AM13.2, AM15.1, AM15.2 and 259 more and referenced by AM213, AM330, AM75.3, AM80.3, AM85.3 and AM88.7. The table has 5 fields, 1 index and 1 documented relation.

About AMASSETGRP

The Asset Management Asset Group file maitains the names and descriptions of asset groups.

Fields (5)

Column = COBOL field name without the ATG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ATG-ASSET-GROUP PK
ASSET_GROUP		Alpha 10This field contains the name of the asset group.AC160, AM115, AM117, AM125, AM13.1, AM13.2, AM15.1, AM15.2 +52 more (list truncated in source)
ATG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description of the asset group.AC160, AM115, AM117, AM125, AM13.1, AM13.2, AM15.1, AM15.2 +52 more (list truncated in source)
ATG-RESTRICT-MEM
RESTRICT_MEM		Alpha 1This flag indicates whether the assets belonging to an asset group are required to be associated with a specific asset type or asset type and subtype. Valid values are:
  • Y Yes
  • N No
—
ATG-ASSET
ASSET		Numeric 10This field contains the base asset number. That is the first asset to select this asset group. All assets that are added to the asset group subsequently are edited against this asset if the Restrict Mem (Restricted Membership) field is set to Yes.—
ATG-RESTRICT-MOD
RESTRICT_MOD		Alpha 1This field indicates whether all assets belonging to the asset group should be adjusted, transfered,and disposed as a group.—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATGSET1ASSET-GROUPPrimaryAC160, AM115, AM117, AM125, AM13.1, AM13.2, AM15.1, AM15.2 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AmassetAMASSETATG-ASSET-GROUP → AST-ASSET-GROUP, → AST-ASSET

Programs

Updated by (267)

Referenced by (6)