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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 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
DIVSET1
  1. DIVISION
PrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AMASSETAMASSETADJAMASSETTRFAMDIVISNAUAMDIVISION

One to many (7) — child tables

RelationTableRulesConditionField map
Amasset1AMASSET
1→AST-STATUS
DIV-DIVISION→AST-DIVISION
—→AST-DSP-ASSET
—→AST-ASSET
Amasset2AMASSET
2→AST-STATUS
DIV-DIVISION→AST-DIVISION
—→AST-DSP-ASSET
—→AST-ASSET
Amasset3AMASSET
3→AST-STATUS
DIV-DIVISION→AST-DIVISION
—→AST-DSP-ASSET
—→AST-ASSET
AmassetadjAMASSETADJ
DIV-DIVISION→ASA-DIVISION
—→ASA-ASSET
—→ASA-PROCESS-SEQ
AmassetdspAMASSET
9→AST-STATUS
DIV-DIVISION→AST-DIVISION
—→AST-DSP-ASSET
—→AST-ASSET
AmassettrfAMASSETTRF
DIV-DIVISION→ATF-DIVISION
—→ATF-ASSET
—→ATF-PROCESS-SEQ
AmdivisnauAMDIVISNAU
DIV-DIVISION→ADW-DIVISION
—→ADW-ACTION
—→ADW-DATE
—→ADW-TIME
—→ADW-UNIQUE-I-D

Programs

Updated by (273)

Referenced by (71)