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 AP510 API1.1 API2.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC12.1 IC130 IC140
IC141 IC142 IC145 IC20.1 IC20.2 IC21.1
IC21.2 IC22.1 IC22.2 IC23.1 IC23.2 IC24.1
IC24.2 IC243 IC25.1 IC28.1 IC330 IC50.2
IC500 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
MA126 MA180 MA26.1 MA278 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
MA53.1 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO135 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO22.5
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.1 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ11.3 RQ11.4 RQ11.5 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
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

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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2
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 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC130 IC140
IC141 IC142
IC145 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC243
IC25.1 IC28.1
IC330 IC50.2


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 AP510
API1.1 API2.1
CX100 CX20.1
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5


File created: Thu Jun 09 02:26:26 2016

Home
Contact Us



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