 |
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 AP198 AP220 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 MA63.1 MA65.1
MA68.1 PO135 PO136 PO26.1 POIF.1 POIJ.1
RQ11.1 RQ12.1 RQ13.1 WH130 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MUA-COMPANY Numeric 4 AP115 AP198
Company The company number represents an AP220 AP30.2
established company and is entered on AP30.4 AP300
all function codes. 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-SYSTEM-CD Alpha 2 AP115 AP198
System Code This field indicates on what system the AP220 AP30.2
transaction originated. AP30.4 AP300
IC = Inventory Control AP305 API1.1
PO = Purchase Order DR100 IC130
RQ = Requisitions IC141 IC142
AP = 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-LOCATION Alpha 5 AP115 AP198
Location Code This field contains a valid stocking AP220 AP30.2
location within the company inventory. 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-DOC-TYPE Alpha 2 AP115 AP198
Document Type This field contains the type of AP220 AP30.2
transaction. AP30.4 AP300
AJ = Adjustment AP305 API1.1
IS = Issue DR100 IC130
RC = Receipt IC141 IC142
CA = Cost Adjustment IC20.1 IC20.2
PT = Purchase Order Template IC21.1 IC21.2
RA = Receiving Adjustment IC22.1 IC22.2
RJ = Inspection Reject IC23.1 IC23.2
RR = Requisition Return IC24.1 IC24.2
RQ = Requisition IC25.1 IC28.1
PO = Purchase Order Receipt IC50.2 IC500
IN = Invoice IC83.1 MA126
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-DOC-NUMBER Alpha 14 (Right Justified) AP115 AP198
Doc Number AP220 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-DOC-NBR-NUM Numeric 10 AP115 AP198
Doc Nbr Num This field contains the numeric AP220 AP30.2
document number. 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-PO-CODE Alpha 4 AP115 AP198
Po Code This is the purchase order code. AP220 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-LINE-NBR Numeric 6 AP115 AP198
Line Number This field contains the line number. AP220 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-API-OBJ-ID Numeric 12 AP115 AP198
Api Obj Id AP220 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-SEQ-NBR Numeric 4 AP115 AP198
Sequence Number An automatically assigned sequence AP220 AP30.2
number. 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
MA63.1 MA65.1
MA68.1 PO135
PO136 PO26.1
POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MUA-SEGMENT-BLOCK Alpha 103 AP115 AP198
User Analysis This field identifies the user analysis AP220 AP30.2
values included in the transaction. AP30.4 AP300
AP305 API1.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 MA126
how you can select user analysis values. MA63.1 MA65.1
See the User Analysis Entry form help or MA68.1 PO135
the Strategic Ledger procedures manual PO136 PO26.1
for additional information. POIF.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
MMUAVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MUASET1 COMPANY AP115 AP198
SYSTEM-CD AP220 AP30.2
LOCATION AP30.4 AP300
DOC-TYPE AP305 API1.1
DOC-NUMBER DR100 IC130
DOC-NBR-NUM IC141 IC142
PO-CODE IC20.1 IC20.2
LINE-NBR IC21.1 IC21.2
API-OBJ-ID IC22.1 IC22.2
SEQ-NBR IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC28.1
IC50.2 IC500
IC83.1 MA126
MA63.1 MA65.1
...
|