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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATPSET1COMPANY, ASSET-TYPE, SUB-TYPEPrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM05.1, AM06.1 +22 more (list truncated in source)
ATPSET2ASSET-TYPE, SUB-TYPE, COMPANYKeyChangeAC160, AM06.4, AM06.5, AM115, AM117, AM12.1, AM12.2, AM15.1 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmcontrolAMCONTROLNot RequiredATP-COMPANY → CTL-COMPANY
GlsystemGLSYSTEMRequiredATP-COMPANY → GLS-COMPANY

One to many (11) — child tables

RelationTableRulesConditionField map
AmaccountAMACCOUNTDelete CascadesATP-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
Amasset1AMASSET1 → AST-STATUS, ATP-COMPANY → AST-COMPANY, ATP-ASSET-TYPE → AST-ASSET-TYPE, ATP-SUB-TYPE → AST-SUB-TYPE, → AST-DSP-ASSET, → AST-ASSET
Amasset2AMASSET2 → AST-STATUS, ATP-COMPANY → AST-COMPANY, ATP-ASSET-TYPE → AST-ASSET-TYPE, ATP-SUB-TYPE → AST-SUB-TYPE, → AST-DSP-ASSET, → AST-ASSET
Amasset3AMASSET3 → AST-STATUS, ATP-COMPANY → AST-COMPANY, ATP-ASSET-TYPE → AST-ASSET-TYPE, ATP-SUB-TYPE → AST-SUB-TYPE, → AST-DSP-ASSET, → AST-ASSET
AmassetadjAMASSETADJATP-COMPANY → ASA-COMPANY, ATP-ASSET-TYPE → ASA-ASSET-TYPE, ATP-SUB-TYPE → ASA-SUB-TYPE, → ASA-ASSET, → ASA-PROCESS-SEQ
AmassetdspAMASSET9 → AST-STATUS, ATP-COMPANY → AST-COMPANY, ATP-ASSET-TYPE → AST-ASSET-TYPE, ATP-SUB-TYPE → AST-SUB-TYPE, → AST-DSP-ASSET, → AST-ASSET
AmassettrfAMASSETTRFATP-COMPANY → ATF-COMPANY, ATP-ASSET-TYPE → ATF-ASSET-TYPE, ATP-SUB-TYPE → ATF-SUB-TYPE, → ATF-ASSET, → ATF-PROCESS-SEQ
AmasttypauAMASTTYPAUATP-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
AmbooktypeAMBOOKTYPEATP-ASSET-TYPE → ADR-ASSET-TYPE, → ADR-SUB-TYPE, → ADR-BOOK
AmclassdepAMCLASSDEPATP-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
AmtypallocAMTYPALLOCATP-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)