AMTYPALLOC – The The Asset Management Type Allocation file stores the allocation history for a type (type and subtype).

System
Asset Management (AM)
Prefix
ALL
Primary key
COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBR
Fields
10
Updated by
1 program
Referenced by
274 programs

AMTYPALLOC is the The The Asset Management Type Allocation file stores the allocation history for a type (type and subtype). table in Lawson Asset Management (prefix ALL). It is indexed by COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBR (ALLSET1); alternate indexes: ALLSET2. It is related 1:M to AMTYPALLOX. It is updated by AM06.6 and referenced by AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 and 266 more. The table has 10 fields, 2 indexes and 1 documented relation.

About AMTYPALLOC

The The Asset Management Type Allocation file stores the allocation history for a type (type and subtype).

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
ALL-COMPANY PK
COMPANY		Numeric 4The company to which the type is attached.AM06.6
ALL-ASSET-TYPE PK
ASSET_TYPE		Alpha 10The type for which an allocation is defined.AM06.6
ALL-SUB-TYPE PK
SUB_TYPE		Alpha 10The subtype for which an allocation is defined.AM06.6
ALL-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)The start date from which to begin allocating depreciation.AM06.6
ALL-SEQUENCE-NBR PK
SEQUENCE_NBR		Numeric 4The sequence number used to identify multiple allocations with the same start date.AM06.6
ALL-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date from which to stop allocating depreciation.AM06.6
ALL-STATUS
STATUS		Numeric 1The status of the allocation. Valid values are:
  • R Released
  • U Unreleased (the default).
  • 0 Unreleased
  • 1 Released
AM06.6
ALL-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)The date the record was created.AM06.6
ALL-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The time the recotd was created.AM06.6
ALL-CREATOR-ID
CREATOR_ID		Alpha 10The original creator of ther ecord.AM06.6

Indexes (2)

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

IndexKeysFlagsConditionUsed in
ALLSET1COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBRPrimaryAM06.6, AM190
ALLSET2COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE*, SEQUENCE-NBR*KeyChangeAC160, AM06.6, AM115, AM117, AM125, AM135, AM145, AM15.1 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AmtypalloxAMTYPALLOXALL-COMPANY → AXL-COMPANY, ALL-ASSET-TYPE → AXL-ASSET-TYPE, ALL-SUB-TYPE → AXL-SUB-TYPE, ALL-START-DATE → AXL-START-DATE, ALL-SEQUENCE-NBR → AXL-SEQUENCE-NBR, → AXL-ACCT-UNIT

Programs

Updated by (1)

Referenced by (274)