MMUAVAL

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 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA540 MAI1.1 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POIF.1 POIG.1 POII.1
POIJ.1 POIM.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MUA-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-SYSTEM-CD
Element: System Cd
Alpha 2
This field indicates on what system the transaction originated.
IC = Inventory Control
PO = Purchase Order
RQ = Requisitions
AP = Invoice
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-DOC-TYPE
Element: Doc Type
Alpha 2
This field contains the type of transaction.
AJ = Adjustment
IS = Issue
RC = Receipt
CA = Cost Adjustment
PT = Purchase Order Template
RA = Receiving Adjustment
RJ = Inspection Reject
RR = Requisition Return
RQ = Requisition
PO = Purchase Order Receipt
IN = Invoice
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-DOC-NUMBER
Element: Doc Number
Alpha 14 (Right Justified)
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-DOC-NBR-NUM
Element: Doc Nbr Num
Numeric 10
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-API-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1
MUA-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA540
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POIG.1 POII.1
POIJ.1 POIM.1


MMUAVAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MUASET1 COMPANY
SYSTEM-CD
LOCATION
DOC-TYPE
DOC-NUMBER
DOC-NBR-NUM
PO-CODE
LINE-NBR
API-OBJ-ID
SEQ-NBR
...
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 MA41.1
MA41.2 MA41.4
MUASET2 COMPANY
SYSTEM-CD
DOC-TYPE
API-OBJ-ID
LINE-NBR
SEQ-NBR
KeyChange, Subset
WhereAPI-OBJ-ID !=Zeroes
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
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 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2


File created: Wed Jun 08 20:50:42 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.