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

AC160     AM115     AM117     AM125     AM135     AM145
AM15.1    AM15.2    AM15.3    AM15.4    AM154     AM19.1
AM19.2    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     AM502     AM551
AM92.1    AM98.1    AP115     AP125     AP126     AP131
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP21.1    AP220     AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP305     API1.1    API2.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.4    MA43.6    MA43.7    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA63.1
MA65.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1
PD10.1    PD10.2    PD130     PD20.1    PD20.2    PD20.3
PO100     PO101     PO122     PO131     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO24.1    PO25.1    PO25.5    PO25.6    PO25.7    PO27.2
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO32.4    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POID.1
POII.1    POIJ.1    RQ10.1    RQ10.2    WH20.2    WH20.7


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 Nbr  The sequence number used to identify
                       multiple allocations for the same start
                       date.

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

AXL-ALLOC-PERCENT      Signed 7.4                                AM06.6
Element: Alloc 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                                                AC160   AM06.6
          ASSET-TYPE                                             AM115   AM117
          SUB-TYPE                                               AM125   AM135
          START-DATE                                             AM145   AM15.1
          SEQUENCE-NBR                                           AM15.2  AM15.3
          ACCT-UNIT                                              AM15.4  AM154
                                                                 AM19.1  AM19.2
                                                                 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
                                                                 ...

                         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