AMDIVISION – Asset Division

System
Asset Management (AM)
Prefix
DIV
Primary key
DIVISION
Fields
2
Updated by
273 programs
Referenced by
71 programs

AMDIVISION is the Asset Division table in Lawson Asset Management (prefix DIV). It is indexed by DIVISION (DIVSET1). It is related 1:M to AMASSET, AMASSETADJ, AMASSETTRF and AMDIVISNAU. It is updated by AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM08.1, AM08.2 and 265 more and referenced by AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM125, AM135 and 63 more. The table has 2 fields, 1 index and 7 documented relations.

About AMDIVISION

The Division file stores optional division records which are used to report asset information. Divisions are subordinate to locations in the reporting hierarchy.

Fields (2)

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

Field / columnTypeDescription & valuesUpdated by
DIV-DIVISION PK
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM08.1, AM08.2 +52 more (list truncated in source)
DIV-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the division.AC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM08.1, AM08.2 +52 more (list truncated in source)

Indexes (1)

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

IndexKeysFlagsConditionUsed in
DIVSET1DIVISIONPrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)

Relations

One to many (7) — child tables

RelationTableRulesConditionField map
Amasset1AMASSET1 → AST-STATUS, DIV-DIVISION → AST-DIVISION, → AST-DSP-ASSET, → AST-ASSET
Amasset2AMASSET2 → AST-STATUS, DIV-DIVISION → AST-DIVISION, → AST-DSP-ASSET, → AST-ASSET
Amasset3AMASSET3 → AST-STATUS, DIV-DIVISION → AST-DIVISION, → AST-DSP-ASSET, → AST-ASSET
AmassetadjAMASSETADJDIV-DIVISION → ASA-DIVISION, → ASA-ASSET, → ASA-PROCESS-SEQ
AmassetdspAMASSET9 → AST-STATUS, DIV-DIVISION → AST-DIVISION, → AST-DSP-ASSET, → AST-ASSET
AmassettrfAMASSETTRFDIV-DIVISION → ATF-DIVISION, → ATF-ASSET, → ATF-PROCESS-SEQ
AmdivisnauAMDIVISNAUDIV-DIVISION → ADW-DIVISION, → ADW-ACTION, → ADW-DATE, → ADW-TIME, → ADW-UNIQUE-I-D

Programs

Updated by (273)

Referenced by (71)