Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMTYPALLOX FILE

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.

REFERENCED BY

AM115     AM12.1    AM125     AM135     AM145     AM15.1
AM15.2    AM15.3    AM15.4    AM154     AM170     AM180
AM190     AM192     AM20.1    AM20.2    AM20.3    AM20.4
AM20.5    AM20.6    AM205     AM206     AM21.1    AM21.2
AM21.3    AM21.4    AM21.5    AM21.6    AM211     AM230
AM282     AM30.1    AM30.2    AM30.3    AM40.1    AM40.2
AM40.3    AM40.4    AM41.2    AM500     AM551     AM88.7
AM96.1    AM98.1

UPDATED BY

AM06.6

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AXL-COMPANY          Numeric 4                                   AM06.6
Company              The company to which the type is
                     attached.

AXL-ASSET-TYPE       Alpha 10                                    AM06.6
Asset Type           The type for which the allocation is
                     defined.

AXL-SUB-TYPE         Alpha 10                                    AM06.6
Sub Type             The subtype for which the allocation is
                     defined.

AXL-START-DATE       Numeric 8  (yyyymmdd)                       AM06.6
Start Date           The start date from which to begin
                     allocating deprecation.

AXL-SEQUENCE-NBR     Numeric 4                                   AM06.6
Sequence Number      The sequence number used to identify
                     multiple allocations for the same start
                     date.

AXL-ACCT-UNIT        Alpha 15                                    AM06.6
Accounting Unit      One of the accounting units that will
                     store a portion of the allocated
                     depreciation expense.

AXL-ALLOC-PERCENT    Signed 7.4                                  AM06.6
Allocation Percent   The percentage of the current period
                     depeciation expense to be allocated to
                     the accounting unit.

                         AMTYPALLOX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AXLSET1   COMPANY                                                AM06.1  AM06.2
          ASSET-TYPE                                             AM06.3  AM06.5
          SUB-TYPE                                               AM06.6  AM115
          START-DATE                                             AM12.1  AM125
          SEQUENCE-NBR                                           AM135   AM145
          ACCT-UNIT                                              AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM180   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM205
                                                                 AM206   AM21.1
                                                                 AM21.2  AM21.3
                                                                 ...

                         AMTYPALLOX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amtypalloc     AMTYPALLOC   Required

                            AXL-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