Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMDIVISION


                            AMDIVISION FILE

                                Division

The Division file stores optional division records which are used to report
asset information. Divisions are subordinate to locations in the reporting
hierarchy.


REFERENCED BY

AM200     AM212     AM220     AM221     AM222     AM223
AM224     AM225     AM230     AM235     AM240     AM245
AM25.1    AM250     AM252     AM255     AM260     AM267
AM278     AM280     AM281     AM285     AM287     AM290
AM292     AM295     AM30.1    AM330     AM35.1    AM45.1
AM580     AM60.1    AM70.1    AM90.1    AM90.4    AM90.5
AM91.1    AM91.4    AM91.5    AM95.1    AM95.4    AM95.5
AM95.6

UPDATED BY

AC10.1    AC10.3    AM08.1    AM08.2    AM115     AM12.1
AM15.1    AM15.2    AM15.3    AM15.4    AM170     AM20.1
AM20.2    AM20.3    AM20.4    AM20.5    AM20.6    AM21.1
AM21.2    AM21.3    AM21.4    AM21.5    AM21.6    AM500
AM551     AM88.7    AM96.1    AM98.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DIV-DIVISION           Alpha 15                                  AC10.1  AC10.3
Element: Division      A user-defined division which is used     AM08.1  AM08.2
                       for reporting assets.                     AM115   AM12.1
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

DIV-DESCRIPTION        Alpha 30  (Lower Case)                    AC10.1  AC10.3
Element: Description   The description of the division.          AM08.1  AM08.2
                                                                 AM115   AM12.1
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 AM21.4  AM21.5
                                                                 AM21.6  AM500
                                                                 AM551   AM88.7
                                                                 AM96.1  AM98.1

                         AMDIVISION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DIVSET1   DIVISION                                               AC10.1  AC10.3
                                                                 AM08.1  AM08.2
                                                                 AM115   AM12.1
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM200
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM212   AM220
                                                                 AM221   AM222
                                                                 AM223   AM224
                                                                 ...

                         AMDIVISION FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset1       AMASSET

                            1               -> AST-STATUS
                            DIV-DIVISION    -> AST-DIVISION
                                               AST-DSP-ASSET
                                               AST-ASSET

Amasset2       AMASSET

                            2               -> AST-STATUS
                            DIV-DIVISION    -> AST-DIVISION
                                               AST-DSP-ASSET
                                               AST-ASSET

Amasset3       AMASSET

                            3               -> AST-STATUS
                            DIV-DIVISION    -> AST-DIVISION
                                               AST-DSP-ASSET
                                               AST-ASSET

Amassetadj     AMASSETADJ

                            DIV-DIVISION    -> ASA-DIVISION
                                               ASA-ASSET
                                               ASA-PROCESS-SEQ

Amassetdsp     AMASSET

                            9               -> AST-STATUS
                            DIV-DIVISION    -> AST-DIVISION
                                               AST-DSP-ASSET
                                               AST-ASSET

Amassettrf     AMASSETTRF

                            DIV-DIVISION    -> ATF-DIVISION
                                               ATF-ASSET
                                               ATF-PROCESS-SEQ