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 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
...
|