Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMTYPALLOX


                            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     AM117     AM125     AM135     AM145     AM15.1
AM15.2    AM15.3    AM15.4    AM154     AM190     AM192
AM20.1    AM20.2    AM20.4    AM20.5    AM205     AM21.1
AM21.2    AM21.4    AM21.5    AM30.1    AM30.2    AM30.3
AM40.1    AM40.2    AM40.3    AM40.4    AM41.2    AM500
AM502     AM551     AM92.1    AM98.1

UPDATED BY

AM06.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

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

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

AXL-ALLOC-PERCENT      Signed 7.4                                AM06.6
Element: Allocation PerThe 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.6  AM115
          ASSET-TYPE                                             AM117   AM125
          SUB-TYPE                                               AM135   AM145
          START-DATE                                             AM15.1  AM15.2
          SEQUENCE-NBR                                           AM15.3  AM15.4
          ACCT-UNIT                                              AM154   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.4
                                                                 AM20.5  AM205
                                                                 AM21.1  AM21.2
                                                                 AM21.4  AM21.5
                                                                 AM30.1  AM30.2
                                                                 AM30.3  AM40.1
                                                                 AM40.2  AM40.3
                                                                 AM40.4  AM41.2
                                                                 ...

                         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