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 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC130 IC140 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 IC66.1 IC83.1 MA180 MA26.1
MA310 MA41.1 MA41.2 MA41.4 MA41.7 MA42.1
MA42.2 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA44.1 MA44.2 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 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 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO22.5 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.1 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO54.5
POCP.1 POD0.1 POI3.1 POID.1 POIF.1 POIG.1
POII.1 POIJ.1 POIM.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 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 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 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 ZW130

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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC130 IC140
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
IC66.1 IC83.1
MA180 MA26.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 CX100
CX20.1 CX20.2
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220


File created: Thu Jun 09 11:23:34 2016

Home
Contact Us



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