Lawson Insight Technical Documentation

                            AMTYPALLOC FILE

The The Asset Management Type Allocation file stores the allocation history
for a type (type and subtype).

REFERENCED BY

AM190     AM115     AM125     AM135     AM145     AM15.1
AM15.2    AM15.3    AM15.4    AM154     AM170     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

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

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

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

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

ALL-SEQUENCE-NBR       Numeric 4                                 AM06.6
Element: Number of ItemThe sequence number used to identify
                       multiple allocations with the same start
                       date.

ALL-END-DATE           Numeric 8  (yyyymmdd)                     AM06.6
Element: Date          The end date from which to stop
                       allocating depreciation.

ALL-STATUS             Numeric 1                                 AM06.6
Element: Status        The status of the allocation. Valid
                       values are:
                       R = Released
                       U = Unreleased (the default).
                       0 = Unreleased
                       1 = Released

ALL-CREATION-DATE      Numeric 8  (yyyymmdd)                     AM06.6
Element: Date          The date the record was created.

ALL-CREATION-TIME      Numeric 6  (hhmmss)                       AM06.6
Element: Sys Time      The time the recotd was created.

ALL-CREATOR-ID         Alpha 10                                  AM06.6
Authorization          The original creator of ther ecord.
Identification

                         AMTYPALLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ALLSET1   COMPANY                                                AM06.6  AM190
          ASSET-TYPE
          SUB-TYPE
          START-DATE
          SEQUENCE-NBR

ALLSET2   COMPANY       KeyChangeDuplicates                      AM06.6  AM115
          ASSET-TYPE                                             AM125   AM135
          SUB-TYPE                                               AM145   AM15.1
          START-DATE*                                            AM15.2  AM15.3
          SEQUENCE-NBR*                                          AM15.4  AM154
                                                                 AM170   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
                                                                 ...

                         AMTYPALLOC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amtypallox     AMTYPALLOX

                            ALL-COMPANY         -> AXL-COMPANY
                            ALL-ASSET-TYPE      -> AXL-ASSET-TYPE
                            ALL-SUB-TYPE        -> AXL-SUB-TYPE
                            ALL-START-DATE      -> AXL-START-DATE
                            ALL-SEQUENCE-NBR    -> AXL-SEQUENCE-NBR
                                                   AXL-ACCT-UNIT