Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMBOOKTYPE


                            AMBOOKTYPE FILE

This file contains the class depreciation file rate table for a book, type,
or type and subtype. It is populated by Asset Class Depreciation Rates
(AM06.4).

REFERENCED BY

AM180     AM214

UPDATED BY

AM06.4    AM06.5

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADR-BOOK               Alpha 10                                  AM06.4  AM06.5
Element: Book          This file contains the book for which
                       the class depreciation rate is defined.

ADR-ASSET-TYPE         Alpha 10                                  AM06.4  AM06.5
Element: Asset Type    This file contains the asset type for
                       which the class depreciation rate is
                       defined.

ADR-SUB-TYPE           Alpha 10                                  AM06.4  AM06.5
Element: Sub Type      This field contains the subtype for
                       which the class depreciation rate is
                       defined.

ADR-DEPR-RATE          Percent 6.3  (Percent)                    AM06.4  AM06.5
Element: Depr Rate     This field contains the depreciation
                       rate percentage assigned to the assets
                       associated with the book, type, and
                       (optional) subtype.

                         AMBOOKTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADRSET1   BOOK                                                   AM06.4  AM06.5
          ASSET-TYPE                                             AM180   AM214
          SUB-TYPE

ADRSET2   ASSET-TYPE                                             AM214
          SUB-TYPE
          BOOK

                         AMBOOKTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ambktypex      AMBKTYPEX

                            ADR-BOOK          -> ADX-BOOK
                            ADR-ASSET-TYPE    -> ADX-ASSET-TYPE
                            ADR-SUB-TYPE      -> ADX-SUB-TYPE
                                                 ADX-COMPANY
                                                 ADX-ACCT-UNIT