Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MMUAVAL


                              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

AP115     AP125     AP126     AP131     AP198     AP220
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP300     AP305     API1.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     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    MA126     MA180
MA530     MA531     MA540     MA60.2    MA60.3    MA60.5
MA61.1    MA63.1    MA65.1    MA66.2    MA66.3    MA67.1
MA67.2    MA68.1    MA70.1    MA75.1    MA80.1    MAI1.1
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     OE111     OE113     OE114     OE116     OE129
OE13.2    OE13.3    OE13.5    OE13.6    OE14.4    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE530     OE81.1    OE810     OE830
OE90.1    OE90.2    PO100     PO101     PO122     PO131
PO135     PO136     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO25.5    PO26.1
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.1    PO32.2    PO33.1    PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     PO54.4    POI3.1    POIE.1    POIF.1
POIG.1    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3
RQ11.1    RQ12.1    RQ13.1    RQ13.2    RQ35.1    RQ500
RQIB.1    RQIF.1    RQIJ.1    WH130     WH132     WH190
WH20.2    WH20.7    WH30.1    WH30.2    WH30.3    WH30.4
WH31.1    WH31.2    WH31.3    WH31.4    WH32.1    WH32.2
WH32.3    WH32.4    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                                 AP115   AP125
Element: Company       Identifies the AP company if the          AP126   AP131
                       resource type = V.  Identifies the HR     AP198   AP220
                       company if the resource type = E.  It is  AP25.1  AP25.2
                       blank for type A, P or Q resources.       AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-SYSTEM-CD          Alpha 2                                   AP115   AP125
Element: System Code   This field indicates on what system the   AP126   AP131
                       transaction originated.                   AP198   AP220
                       IC = Inventory Control                    AP25.1  AP25.2
                       PO = Purchase Order                       AP26.1  AP27.1
                       RQ = Requisitions                         AP30.2  AP30.4
                       AP = Invoice                              AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-LOCATION           Alpha 5                                   AP115   AP125
Element: Location Code This field contains a valid stocking      AP126   AP131
                       location within the company inventory.    AP198   AP220
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-DOC-TYPE           Alpha 2                                   AP115   AP125
Element: Document Type This field contains the type of           AP126   AP131
                       transaction.                              AP198   AP220
                       AJ = Adjustment                           AP25.1  AP25.2
                       IS = Issue                                AP26.1  AP27.1
                       RC = Receipt                              AP30.2  AP30.4
                       CA = Cost Adjustment                      AP300   AP305
                       PT = Purchase Order Template              API1.1  BL120
                       RA = Receiving Adjustment                 BL122   BL130
                       RJ = Inspection Reject                    BL20.1  BL20.3
                       RR = Requisition Return                   BL21.2  BL21.5
                       RQ = Requisition                          BL29.1  BL29.2
                       PO = Purchase Order Receipt               BL520   BL820
                       IN = Invoice                              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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-DOC-NUMBER         Alpha 14  (Right Justified)               AP115   AP125
Element: Doc Number                                              AP126   AP131
                                                                 AP198   AP220
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-DOC-NBR-NUM        Numeric 10                                AP115   AP125
Element: Doc Nbr Num   This field contains the numeric           AP126   AP131
                       document number.                          AP198   AP220
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-PO-CODE            Alpha 4                                   AP115   AP125
Element: Po Code       This is the purchase order code.          AP126   AP131
                                                                 AP198   AP220
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-LINE-NBR           Numeric 6                                 AP115   AP125
Element: Line Number   This field contains the line number.      AP126   AP131
                                                                 AP198   AP220
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-API-OBJ-ID         Numeric 12                                AP115   AP125
Object                                                           AP126   AP131
Identification                                                   AP198   AP220
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-SEQ-NBR            Numeric 4                                 AP115   AP125
Element: Sequence NumbeAn automatically assigned sequence        AP126   AP131
                       number.                                   AP198   AP220
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 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
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

MUA-SEGMENT-BLOCK      Alpha 103                                 AP115   AP125
Element: User Analysis This field identifies the user analysis   AP126   AP131
                       values included in the transaction.       AP198   AP220
                                                                 AP25.1  AP25.2
                       You can either type up to four values     AP26.1  AP27.1
                       or use Define (F6) to open the User       AP30.2  AP30.4
                       Analysis Entry subform. Use this subform  AP300   AP305
                       to select the user analysis values you    API1.1  BL120
                       want to include in the transaction. If    BL122   BL130
                       you choose to type values, use commas to  BL20.1  BL20.3
                       separate them. For example:               BL21.2  BL21.5
                       value1,value2,value3,value4               BL29.1  BL29.2
                                                                 BL520   BL820
                       There are three conditions that affect    BL92.1  DR100
                       how you can select user analysis values.  IC130   IC141
                       See the User Analysis Entry form help or  IC142   IC20.1
                       the Strategic Ledger procedures manual    IC20.2  IC21.1
                       for additional information.               IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC28.1  IC50.2
                                                                 IC500   IC83.1
                                                                 MA126   MA180
                                                                 MA530   MA531
                                                                 MA540   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 ...

                         MMUAVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MUASET1   COMPANY                                                AP115   AP125
          SYSTEM-CD                                              AP126   AP131
          LOCATION                                               AP198   AP220
          DOC-TYPE                                               AP25.1  AP25.2
          DOC-NUMBER                                             AP26.1  AP27.1
          DOC-NBR-NUM                                            AP30.2  AP30.4
          PO-CODE                                                AP300   AP305
          LINE-NBR                                               API1.1  BL120
          API-OBJ-ID                                             BL122   BL130
          SEQ-NBR                                                BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  DR100
                                                                 IC130   IC141
                                                                 ...