Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMTYPALLOC


                            AMTYPALLOC FILE

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

REFERENCED BY

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

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: Start Date    The start date from which to begin
                       allocating depreciation.

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

ALL-END-DATE           Numeric 8  (yyyymmdd)                     AM06.6
Element: Ending 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: Creation Date The date the record was created.

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

ALL-CREATOR-ID         Alpha 10                                  AM06.6
Element: Operator Code The original creator of ther ecord.

                         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       KeyChange                                AM06.6  AM115
          ASSET-TYPE                                             AM117   AM125
          SUB-TYPE                                               AM135   AM145
          START-DATE*                                            AM15.1  AM15.2
          SEQUENCE-NBR*                                          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
                                                                 ...

                         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