AMTYPALLOX – The Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or…

System
Asset Management (AM)
Prefix
AXL
Primary key
COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBR, ACCT-UNIT
Fields
7
Updated by
1 program
Referenced by
273 programs

AMTYPALLOX is the The Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or… table in Lawson Asset Management (prefix AXL). It is indexed by COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBR, ACCT-UNIT (AXLSET1). It is related 1:1 to AMTYPALLOC. It is updated by AM06.6 and referenced by AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 and 265 more. The table has 7 fields, 1 index and 1 documented relation.

About AMTYPALLOX

The Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or asset type and subtype), start date, and sequence number.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
AXL-COMPANY PK
COMPANY		Numeric 4The company to which the type is attached.AM06.6
AXL-ASSET-TYPE PK
ASSET_TYPE		Alpha 10The type for which the allocation is defined.AM06.6
AXL-SUB-TYPE PK
SUB_TYPE		Alpha 10The subtype for which the allocation is defined.AM06.6
AXL-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)The start date from which to begin allocating deprecation.AM06.6
AXL-SEQUENCE-NBR PK
SEQUENCE_NBR		Numeric 4The sequence number used to identify multiple allocations for the same start date.AM06.6
AXL-ACCT-UNIT PK
ACCT_UNIT		Alpha 15One of the accounting units that will store a portion of the allocated depreciation expense.AM06.6
AXL-ALLOC-PERCENT
ALLOC_PERCENT		Signed 7.4The percentage of the current period depeciation expense to be allocated to the accounting unit.AM06.6

Indexes (1)

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

IndexKeysFlagsConditionUsed in
AXLSET1COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBR, ACCT-UNITPrimaryAC160, AM06.6, AM115, AM117, AM125, AM135, AM145, AM15.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmtypallocAMTYPALLOCRequiredAXL-COMPANY → ALL-COMPANY, AXL-ASSET-TYPE → ALL-ASSET-TYPE, AXL-SUB-TYPE → ALL-SUB-TYPE, AXL-START-DATE → ALL-START-DATE, AXL-SEQUENCE-NBR → ALL-SEQUENCE-NBR

Programs

Updated by (1)

Referenced by (273)