Lawson Insight Technical Documentation |
|
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 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP300 AP305 API1.1 API2.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
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.5 MA43.7 MA43.8
MA43.9 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 PO100 PO101 PO122 PO131 PO135
PO136 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.1 PO25.5 PO25.6
PO25.7 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 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.4 POD0.1 POI3.1 POIF.1 POIG.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ35.1 RQ500 RQD0.1 RQIB.1
RQIE.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 The company number represents an AP126 AP131
established company and is entered on AP198 AP20.1
all function codes. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-SYSTEM-CD Alpha 2 AP115 AP125
Element: System Code This field indicates on what system the AP126 AP131
transaction originated. AP198 AP20.1
IC = Inventory Control AP20.2 AP20.3
PO = Purchase Order AP20.4 AP20.5
RQ = Requisitions AP20.7 AP220
AP = Invoice AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-LOCATION Alpha 5 AP115 AP125
Element: Location Code This field contains a valid stocking AP126 AP131
location within the company inventory. AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-DOC-TYPE Alpha 2 AP115 AP125
Element: Document Type This field contains the type of AP126 AP131
transaction. AP198 AP20.1
AJ = Adjustment AP20.2 AP20.3
IS = Issue AP20.4 AP20.5
RC = Receipt AP20.7 AP220
CA = Cost Adjustment AP23.1 AP25.1
PT = Purchase Order Template AP25.2 AP26.1
RA = Receiving Adjustment AP27.1 AP30.2
RJ = Inspection Reject AP30.4 AP300
RR = Requisition Return AP305 API1.1
RQ = Requisition API2.1 DR100
PO = Purchase Order Receipt IC130 IC141
IN = Invoice 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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-DOC-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: Doc Number AP126 AP131
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-DOC-NBR-NUM Numeric 10 AP115 AP125
Element: Doc Nbr Num This field contains the numeric AP126 AP131
document number. AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-PO-CODE Alpha 4 AP115 AP125
Element: Po Code This is the purchase order code. AP126 AP131
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-LINE-NBR Numeric 6 AP115 AP125
Element: Line Number This field contains the line number. AP126 AP131
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-API-OBJ-ID Numeric 12 AP115 AP125
Object AP126 AP131
Identification AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-SEQ-NBR Numeric 4 AP115 AP125
Element: Sequence NumbeAn automatically assigned sequence AP126 AP131
number. AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.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
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MUA-SEGMENT-BLOCK Alpha 103 AP115 AP125
Element: User Analysis This field identifies the user analysis AP126 AP131
values included in the transaction. AP198 AP20.1
AP20.2 AP20.3
You can either type up to four values AP20.4 AP20.5
or use Define (F6) to open the User AP20.7 AP220
Analysis Entry subform. Use this subform AP23.1 AP25.1
to select the user analysis values you AP25.2 AP26.1
want to include in the transaction. If AP27.1 AP30.2
you choose to type values, use commas to AP30.4 AP300
separate them. For example: AP305 API1.1
value1,value2,value3,value4 API2.1 DR100
IC130 IC141
There are three conditions that affect IC142 IC20.1
how you can select user analysis values. IC20.2 IC21.1
See the User Analysis Entry form help or IC21.2 IC22.1
the Strategic Ledger procedures manual IC22.2 IC23.1
for additional information. IC23.2 IC24.1
IC24.2 IC25.1
IC28.1 IC50.2
IC500 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
MMUAVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MUASET1 COMPANY AP115 AP125
SYSTEM-CD AP126 AP131
LOCATION AP198 AP20.1
DOC-TYPE AP20.2 AP20.3
DOC-NUMBER AP20.4 AP20.5
DOC-NBR-NUM AP20.7 AP220
PO-CODE AP23.1 AP25.1
LINE-NBR AP25.2 AP26.1
API-OBJ-ID AP27.1 AP30.2
SEQ-NBR AP30.4 AP300
AP305 API1.1
API2.1 DR100
IC130 IC141
IC142 IC20.1
IC20.2 IC21.1
...
|