Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              MMUAVAL FILE

This file stores the user analysis values defined for transactions. The
values represent information your organization can use to measure
profitability. Data is written to this file as you create items. You must run
the posting program to interface the information to Strategic Ledger. For
additional information
on user analysis values, see the Strategic Ledger Procedures Manual.

UPDATED BY

AP125     AP126     AP225     AP226     AP25.1    AP25.2
AP26.1    BL92.1    DR100     IC130     IC141     IC142
IC20.1    IC20.2    IC21.1    IC21.2    IC22.1    IC22.2
IC23.1    IC23.2    IC24.1    IC24.2    IC25.1    IC28.1
IC50.2    IC500     IC83.1    IC850     IN20.1    MA40.1
MA41.1    MA41.2    MA41.5    MA41.6    MA43.1    MA43.2
MA43.3    MA43.4    MA52.1    MA520     MA530     MA540
OE10.1    OE10.2    OE10.3    OE10.4    OE10.5    OE10.6
OE10.7    OE10.8    OE11.1    OE11.4    OE11.8    OE11.9
OE110     OE113     OE114     OE129     OE14.4    OE15.1
OE15.2    OE15.3    OE15.4    OE15.5    OE15.7    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE810     OE830     OE920     OE950
PO100     PO180     PO20.1    PO21.1    PO21.3    PO22.1
PO22.2    PO22.3    PO26.1    PO30.1    PO30.2    PO31.1
PO530     RQ10.1    RQ10.3    RQ11.1    RQ20.1    RQ20.2
RQ20.3    RQ20.4    RQ35.1    RQ500     WH130     WH132
WH190     WH20.2    WH20.7    WH30.1    WH30.2    WH30.3
WH31.1    WH31.2    WH31.3    WH32.1    WH32.2    WH32.3
WH33.1    WH33.2    WH33.3    WH33.4    WH33.5    WH33.6
WH33.8    WH33.9    WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830     WO132     WO140

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MUA-COMPANY          Numeric 4                                   AP125   AP126
Company              The company number represents an            AP225   AP226
                     established company and is entered on       AP25.1  AP25.2
                     all function codes.                         AP26.1  BL92.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

MUA-SYSTEM-CD        Alpha 2                                     AP125   AP126
System Code          This field indicates on what system the     AP225   AP226
                     transaction originated.                     AP25.1  AP25.2
                                                                 AP26.1  BL92.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

MUA-LOCATION         Alpha 5                                     AP125   AP126
Location Code        This field contains a valid stocking        AP225   AP226
                     location within the company inventory.      AP25.1  AP25.2
                                                                 AP26.1  BL92.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

MUA-DOC-TYPE         Alpha 2                                     AP125   AP126
Document Type        This field contains the type of             AP225   AP226
                     transaction.                                AP25.1  AP25.2
                                                                 AP26.1  BL92.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

MUA-DOC-NBR          Alpha 10  (Right Justified)                 AP125   AP126
Doc Nbr              This field contains the alpha document      AP225   AP226
                     number.                                     AP25.1  AP25.2
                                                                 AP26.1  BL92.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

MUA-DOC-NBR-NUM      Numeric 10                                  AP125   AP126
Doc Nbr Num          This field contains the numeric             AP225   AP226
                     document number.                            AP25.1  AP25.2
                                                                 AP26.1  BL92.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

MUA-LINE-NBR         Numeric 6                                   AP125   AP126
Line Number          This field contains the line number.        AP225   AP226
                                                                 AP25.1  AP25.2
                                                                 AP26.1  BL92.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 MA41.1  MA41.2
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

MUA-SEGMENT-BLOCK    Alpha 103                                   AP125   AP126
User Analysis        This field identifies the user analysis     AP225   AP226
                     values included in the transaction.         AP25.1  AP25.2
                                                                 AP26.1  BL92.1
                     You can either type up to four values       DR100   IC130
                     or use Define (F6) to open the User         IC141   IC142
                     Analysis Entry subform. Use this subform    IC20.1  IC20.2
                     to select the user analysis values you      IC21.1  IC21.2
                     want to include in the transaction. If      IC22.1  IC22.2
                     you choose to type values, use commas to    IC23.1  IC23.2
                     separate them. For example:                 IC24.1  IC24.2
                     value1,value2,value3,value4                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                     There are three conditions that affect      IC83.1  IC850
                     how you can select user analysis values.    IN20.1  MA40.1
                     See the User Analysis Entry form help or    MA41.1  MA41.2
                     the Strategic Ledger procedures manual      MA41.5  MA41.6
                     for additional information.                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA520
                                                                 MA530   MA540
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 ...

                         MMUAVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MUASET1   COMPANY                                                AP125   AP126
          SYSTEM-CD                                              AP225   AP226
          LOCATION                                               AP25.1  AP25.2
          DOC-TYPE                                               AP26.1  BL92.1
          DOC-NBR                                                DR100   IC130
          DOC-NBR-NUM                                            IC141   IC142
          LINE-NBR                                               IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC50.2  IC500
                                                                 IC83.1  IC850
                                                                 IN20.1  MA40.1
                                                                 ...