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

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

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

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

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

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

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

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

ALL-STATUS           Numeric 1                                   AM06.6
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
Creation Date        The date the record was created.

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

ALL-CREATOR-ID       Alpha 10                                    AM06.6
Creator Id           The original creator of ther ecord.

                         AMTYPALLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

ALLSET2   COMPANY       KeyChange, Duplicates                    AM06.1  AM06.2
          ASSET-TYPE                                             AM06.3  AM06.5
          SUB-TYPE                                               AM06.6  AM115
          START-DATE*                                            AM12.1  AM125
          SEQUENCE-NBR*                                          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
                                                                 ...

                         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