Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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     AM278
AM280     AM281     AM285     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     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
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
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