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     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.1    AM41.2    AM500
AM551     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: Date          The start date from which to begin
                       allocating deprecation.

AXL-SEQUENCE-NBR       Numeric 4                                 AM06.6
Element: Number of ItemThe 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                                             AM125   AM135
          SUB-TYPE                                               AM145   AM15.1
          START-DATE                                             AM15.2  AM15.3
          SEQUENCE-NBR                                           AM15.4  AM154
          ACCT-UNIT                                              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.1  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