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     AM258     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    AC160     AC56.1    AC560     AC71.1
AM08.1    AM08.2    AM115     AM117     AM12.1    AM15.1
AM15.2    AM15.3    AM15.4    AM17.1    AM170     AM19.1
AM19.2    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
AP115     AP125     AP126     AP131     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP21.1    AP220
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP305     API1.1    API2.1    BL120     BL122
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL820     BL92.1    MA180     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.4    MA43.6    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA63.1    MA65.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.5
MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PO100     PO101
PO122     PO131     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO24.1    PO25.1
PO25.5    PO25.6    PO25.7    PO27.2    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO32.4    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POI3.1    POID.1    POII.1    POIJ.1
RQ10.1    RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DIV-DIVISION           Alpha 15                                  AC10.1  AC10.3
Element: Division      A user-defined division which is used     AC160   AC56.1
                       for reporting assets.                     AC560   AC71.1
                                                                 AM08.1  AM08.2
                                                                 AM115   AM117
                                                                 AM12.1  AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM17.1
                                                                 AM170   AM19.1
                                                                 AM19.2  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
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 ...

DIV-DESCRIPTION        Alpha 30  (Lower Case)                    AC10.1  AC10.3
Element: Description   The description of the division.          AC160   AC56.1
                                                                 AC560   AC71.1
                                                                 AM08.1  AM08.2
                                                                 AM115   AM117
                                                                 AM12.1  AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM17.1
                                                                 AM170   AM19.1
                                                                 AM19.2  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
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 ...

                         AMDIVISION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DIVSET1   DIVISION                                               AC10.1  AC10.3
                                                                 AC160   AC56.1
                                                                 AC560   AC71.1
                                                                 AM08.1  AM08.2
                                                                 AM115   AM117
                                                                 AM12.1  AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM15.5
                                                                 AM15.6  AM17.1
                                                                 AM170   AM19.1
                                                                 AM19.2  AM19.4
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM200   AM21.1
                                                                 ...

                         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