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    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     AM117
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   AM117
                                                                 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   AM117
                                                                 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   AM117
                                                                 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
                                                                 ...

                         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