 |
Lawson Insight Technical Documentation |
|
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 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 MA41.1 MA41.2 MA41.4 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 MAI1.1 PO100 PO101
PO122 PO131 PO135 PO136 PO20.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO25.6
PO26.1 PO27.3 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 RQ35.1 RQ500
RQIF.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MUA-COMPANY Numeric 4 AP115 AP125
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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-SYSTEM-CD Alpha 2 AP115 AP125
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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-LOCATION Alpha 5 AP115 AP125
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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-DOC-TYPE Alpha 2 AP115 AP125
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 DR100 IC130
PO = Purchase Order Receipt IC141 IC142
IN = Invoice 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 MA41.1
MA41.2 MA41.4
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
...
MUA-DOC-NUMBER Alpha 14 (Right Justified) AP115 AP125
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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-DOC-NBR-NUM Numeric 10 AP115 AP125
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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-PO-CODE Alpha 4 AP115 AP125
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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-LINE-NBR Numeric 6 AP115 AP125
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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-API-OBJ-ID Numeric 12 AP115 AP125
Api Obj Id 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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-SEQ-NBR Numeric 4 AP115 AP125
Sequence Number An 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
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 MA41.1
MA41.2 MA41.4
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
...
MUA-SEGMENT-BLOCK Alpha 103 AP115 AP125
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 DR100 IC130
IC141 IC142
There are three conditions that affect IC20.1 IC20.2
how you can select user analysis values. IC21.1 IC21.2
See the User Analysis Entry form help or IC22.1 IC22.2
the Strategic Ledger procedures manual IC23.1 IC23.2
for additional information. IC24.1 IC24.2
IC25.1 IC28.1
IC50.2 IC500
IC83.1 MA126
MA180 MA41.1
MA41.2 MA41.4
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
...
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
DR100 IC130
IC141 IC142
IC20.1 IC20.2
IC21.1 IC21.2
...
|