Lawson Insight Technical Documentation |
|
MMUAVAL
MMUAVAL FILE
UPDATED BY
AM17.1 AM19.1 AM19.2 AP115 AP125 AP126
AP131 AP198 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP300
AP305 API1.1 API2.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 IC130 MA180 MA310
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO135 PO136
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 PO32.4 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
POID.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 RQD0.1 RQIB.1 RQIF.1 RQII.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MUA-COMPANY Numeric 4 AM17.1 AM19.1
Element: Company Identifies the AP company if the AM19.2 AP115
resource type = V. Identifies the HR AP125 AP126
company if the resource type = E. It is AP131 AP198
blank for type A, P or Q resources. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-SYSTEM-CD Alpha 2 AM17.1 AM19.1
Element: System Cd This field indicates on what system the AM19.2 AP115
transaction originated. AP125 AP126
IC = Inventory Control AP131 AP198
PO = Purchase Order AP20.1 AP20.2
RQ = Requisitions AP20.3 AP20.4
AP = Invoice AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-LOCATION Alpha 5 AM17.1 AM19.1
Element: Location This field contains a valid stocking AM19.2 AP115
location within the company inventory. AP125 AP126
AP131 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-DOC-TYPE Alpha 2 AM17.1 AM19.1
Element: Doc Type This field contains the type of AM19.2 AP115
transaction. AP125 AP126
AJ = Adjustment AP131 AP198
IS = Issue AP20.1 AP20.2
RC = Receipt AP20.3 AP20.4
CA = Cost Adjustment AP20.5 AP20.7
PT = Purchase Order Template AP21.1 AP220
RA = Receiving Adjustment AP23.1 AP25.1
RJ = Inspection Reject AP25.2 AP26.1
RR = Requisition Return AP27.1 AP30.2
RQ = Requisition AP30.4 AP300
PO = Purchase Order Receipt AP305 API1.1
IN = Invoice API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-DOC-NUMBER Alpha 14 (Right Justified) AM17.1 AM19.1
Element: Doc Number AM19.2 AP115
AP125 AP126
AP131 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-DOC-NBR-NUM Numeric 10 AM17.1 AM19.1
Element: Doc Nbr Num AM19.2 AP115
AP125 AP126
AP131 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-PO-CODE Alpha 4 AM17.1 AM19.1
Element: Po Code This is the purchase order code. AM19.2 AP115
AP125 AP126
AP131 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-LINE-NBR Numeric 6 AM17.1 AM19.1
Element: Line Nbr This field contains the line number. AM19.2 AP115
AP125 AP126
AP131 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-API-OBJ-ID Numeric 12 AM17.1 AM19.1
Element: Obj Id This is the object identifier. It is AM19.2 AP115
used to relate commitments or posted AP125 AP126
transactions back to the originating AP131 AP198
subsystems. Each subsystem record that AP20.1 AP20.2
is updated as a commitment or posted AP20.3 AP20.4
transaction is assigned an object AP20.5 AP20.7
identifier. The object identifier is AP21.1 AP220
maintained in the subsystem files and in AP23.1 AP25.1
the Activity Commitments Detail and AP25.2 AP26.1
Activity Transaction files. The object AP27.1 AP30.2
identifier is a unique key used to drill AP30.4 AP300
back from Activity Management to the AP305 API1.1
subsystems. API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-SEQ-NBR Numeric 4 AM17.1 AM19.1
Element: Seq Nbr An automatically assigned sequence AM19.2 AP115
number. AP125 AP126
AP131 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MUA-SEGMENT-BLOCK Alpha 103 AM17.1 AM19.1
Element: Segment Block This field identifies the user analysis AM19.2 AP115
values included in the transaction. AP125 AP126
AP131 AP198
You can either type up to four values AP20.1 AP20.2
or use Define (F6) to open the User AP20.3 AP20.4
Analysis Entry subform. Use this subform AP20.5 AP20.7
to select the user analysis values you AP21.1 AP220
want to include in the transaction. If AP23.1 AP25.1
you choose to type values, use commas to AP25.2 AP26.1
separate them. For example: AP27.1 AP30.2
value1,value2,value3,value4 AP30.4 AP300
AP305 API1.1
There are three conditions that affect API2.1 BL120
how you can select user analysis values. BL122 BL130
See the User Analysis Entry form help or BL20.1 BL20.3
the Strategic Ledger procedures manual BL21.2 BL21.5
for additional information. BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
MA180 MA310
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
...
MMUAVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MUASET1 COMPANY AM17.1 AM19.1
SYSTEM-CD AM19.2 AP115
LOCATION AP125 AP126
DOC-TYPE AP131 AP198
DOC-NUMBER AP20.1 AP20.2
DOC-NBR-NUM AP20.3 AP20.4
PO-CODE AP20.5 AP20.7
LINE-NBR AP21.1 AP220
API-OBJ-ID AP23.1 AP25.1
SEQ-NBR AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 API1.1
API2.1 BL120
BL122 BL130
...
MUASET2 COMPANY KeyChange, Subset AM19.1 AM19.2
SYSTEM-CD Where API-OBJ-ID != Zeroes AP115 AP125
DOC-TYPE AP126 AP131
API-OBJ-ID AP20.1 AP20.2
LINE-NBR AP20.3 AP20.4
SEQ-NBR AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
|