AMASTTYPE – Asset Type

System
Asset Management (AM)
Prefix
ATP
Primary key
COMPANY, ASSET-TYPE, SUB-TYPE
Fields
9
Updated by
290 programs
Referenced by
72 programs

AMASTTYPE is the Asset Type table in Lawson Asset Management (prefix ATP). It is indexed by COMPANY, ASSET-TYPE, SUB-TYPE (ATPSET1); alternate indexes: ATPSET2. It is related 1:1 to AMCONTROL and GLSYSTEM and 1:M to AMACCOUNT, AMASSET, AMASSETADJ, AMASSETTRF, AMASTTYPAU, AMBOOKTYPE, AMCLASSDEP and AMTYPALLOC. It is updated by AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 and 282 more and referenced by AC10.1, AC10.3, AC56.1, AC560, AC71.1, AM05.1, AM08.1, AM08.2 and 64 more. The table has 9 fields, 2 indexes and 13 documented relations.

About AMASTTYPE

The Asset Type file stores asset types and subtypes, which represent groupings of like assets that can be used for reporting and defaulting common asset definition data. You must define at least one asset type. Asset types must be unique within a general ledger company, and asset subtypes must be unique within an asset type. Each Asset Type record has one or more Account records, which identify the general ledger accounts used to create journal entries when you process (add, adjust, transfer, and dispose of) assets.

Fields (9)

Column = COBOL field name without the ATP- 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
#ATP-COMPANY PK
COMPANY		Numeric 4The general ledger company number associated with the asset type record.AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-ASSET-TYPE PK
ASSET_TYPE		Alpha 10An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data.AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-SUB-TYPE PK
SUB_TYPE		Alpha 10An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and to default common asset definition data. Subtypes must be unique within an asset type.AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The asset type description.AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-PROPERTY
PROPERTY		Alpha 1This value classifies the kind of property that is represented by this asset type.
  • P Personal
  • R Real
  • L Land
  • S Stock
  • O Other
AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-INV-FLAG
INV_FLAG		Alpha 1This flag indicates whether an asset should be included as part of the physical inventory. If it is not, the asset is ignored in inventories. Valid values are:
  • Y Yes
  • N No
AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-DEP-EXP-ALLOC
DEP_EXP_ALLOC		Alpha 1This field indicates whether the asset type allows depreciation expense to ve allocated to multiple accounting units. Valid values are:
  • N No (the default)
  • Y Yes
AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-REVALUE-FLAG
REVALUE_FLAG		Alpha 1—AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
#ATP-REVALUE-METHOD
REVALUE_METHOD		Alpha 1—AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)

Indexes (2)

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
ATPSET1
  1. COMPANY
  2. ASSET-TYPE
  3. SUB-TYPE
PrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)
ATPSET2
  1. ASSET-TYPE
  2. SUB-TYPE
  3. COMPANY
KeyChangeAC160, AM06.4, AM06.5, AM115, AM117, AM12.1, AM12.2, AM15.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)
AMCONTROLGLSYSTEMAMACCOUNTAMASSETAMASSETADJAMASSETTRFAMASTTYPAUAMBOOKTYPEAMCLASSDEPAMTYPALLOCAMASTTYPE

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmcontrolAMCONTROLNot Required
ATP-COMPANY→CTL-COMPANY
GlsystemGLSYSTEMRequired
ATP-COMPANY→GLS-COMPANY

One to many (11) — child tables

RelationTableRulesConditionField map
AmaccountAMACCOUNTDelete Cascades
ATP-COMPANY→AAC-COMPANY
Spaces→AAC-ACCT-GRP
ATP-ASSET-TYPE→AAC-ASSET-TYPE
ATP-SUB-TYPE→AAC-SUB-TYPE
—→AAC-ACCT-TYPE
—→AAC-ASSET-EVENT
Amasset1AMASSET
1→AST-STATUS
ATP-COMPANY→AST-COMPANY
ATP-ASSET-TYPE→AST-ASSET-TYPE
ATP-SUB-TYPE→AST-SUB-TYPE
—→AST-DSP-ASSET
—→AST-ASSET
Amasset2AMASSET
2→AST-STATUS
ATP-COMPANY→AST-COMPANY
ATP-ASSET-TYPE→AST-ASSET-TYPE
ATP-SUB-TYPE→AST-SUB-TYPE
—→AST-DSP-ASSET
—→AST-ASSET
Amasset3AMASSET
3→AST-STATUS
ATP-COMPANY→AST-COMPANY
ATP-ASSET-TYPE→AST-ASSET-TYPE
ATP-SUB-TYPE→AST-SUB-TYPE
—→AST-DSP-ASSET
—→AST-ASSET
AmassetadjAMASSETADJ
ATP-COMPANY→ASA-COMPANY
ATP-ASSET-TYPE→ASA-ASSET-TYPE
ATP-SUB-TYPE→ASA-SUB-TYPE
—→ASA-ASSET
—→ASA-PROCESS-SEQ
AmassetdspAMASSET
9→AST-STATUS
ATP-COMPANY→AST-COMPANY
ATP-ASSET-TYPE→AST-ASSET-TYPE
ATP-SUB-TYPE→AST-SUB-TYPE
—→AST-DSP-ASSET
—→AST-ASSET
AmassettrfAMASSETTRF
ATP-COMPANY→ATF-COMPANY
ATP-ASSET-TYPE→ATF-ASSET-TYPE
ATP-SUB-TYPE→ATF-SUB-TYPE
—→ATF-ASSET
—→ATF-PROCESS-SEQ
AmasttypauAMASTTYPAU
ATP-COMPANY→ASW-COMPANY
ATP-ASSET-TYPE→ASW-ASSET-TYPE
ATP-SUB-TYPE→ASW-SUB-TYPE
—→ASW-ACTION
—→ASW-DATE
—→ASW-TIME
—→ASW-UNIQUE-I-D
AmbooktypeAMBOOKTYPE
ATP-ASSET-TYPE→ADR-ASSET-TYPE
—→ADR-SUB-TYPE
—→ADR-BOOK
AmclassdepAMCLASSDEP
ATP-ASSET-TYPE→CLD-ASSET-TYPE
ATP-SUB-TYPE→CLD-SUB-TYPE
—→CLD-BOOK
—→CLD-COMPANY
—→CLD-AST-ACCT-UNIT
—→CLD-EXP-ACCT-UNIT
—→CLD-ACM-ACCT-UNIT
—→CLD-YR-END-DATE
—→CLD-PERIOD
AmtypallocAMTYPALLOC
ATP-COMPANY→ALL-COMPANY
ATP-ASSET-TYPE→ALL-ASSET-TYPE
ATP-SUB-TYPE→ALL-SUB-TYPE
—→ALL-START-DATE
—→ALL-SEQUENCE-NBR

Programs

Updated by (290)

Referenced by (72)