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

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 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
ALLSET1
  1. COMPANY
  2. ASSET-TYPE
  3. SUB-TYPE
  4. START-DATE
  5. SEQUENCE-NBR
PrimaryAM06.6, AM190
ALLSET2
  1. COMPANY
  2. ASSET-TYPE
  3. SUB-TYPE
  4. START-DATE ↓
  5. SEQUENCE-NBR ↓
KeyChangeAC160, AM06.6, AM115, AM117, AM125, AM135, AM145, 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)
AMTYPALLOXAMTYPALLOC

One to many (1) — child tables

RelationTableRulesConditionField map
AmtypalloxAMTYPALLOX
ALL-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)