MMUAVAL – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
MUA
Primary key
COMPANY, SYSTEM-CD, LOCATION, DOC-TYPE, DOC-NUMBER, DOC-NBR-NUM, PO-CODE, LINE-NBR, API-OBJ-ID, SEQ-NBR
Fields
11
Updated by
268 programs
Referenced by
0 programs

MMUAVAL is a Lawson Purchase Order table (prefix MUA); no description in the lawson data dictionary. It is indexed by COMPANY, SYSTEM-CD, LOCATION, DOC-TYPE, DOC-NUMBER, DOC-NBR-NUM, PO-CODE, LINE-NBR, API-OBJ-ID, SEQ-NBR (MUASET1); alternate indexes: MUASET2. It is updated by AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 and 260 more. The table has 11 fields, 2 indexes and 0 documented relations.

About MMUAVAL

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the MUA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MUA-COMPANY PK
COMPANY		Numeric 4Identifies 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 +52 more (list truncated in source)
MUA-SYSTEM-CD PK
SYSTEM_CD		Alpha 2This 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 +52 more (list truncated in source)
MUA-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 +52 more (list truncated in source)
MUA-DOC-TYPE PK
DOC_TYPE		Alpha 2This 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 +52 more (list truncated in source)
MUA-DOC-NUMBER PK
DOC_NUMBER		Alpha 14 (Right Justified)—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 +52 more (list truncated in source)
MUA-DOC-NBR-NUM PK
DOC_NBR_NUM		Numeric 10—AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 +52 more (list truncated in source)
MUA-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 +52 more (list truncated in source)
MUA-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 +52 more (list truncated in source)
MUA-API-OBJ-ID PK
API_OBJ_ID		Numeric 12This 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 +52 more (list truncated in source)
MUA-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 +52 more (list truncated in source)
MUA-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This 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 +52 more (list truncated in source)

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MUASET1COMPANY, SYSTEM-CD, LOCATION, DOC-TYPE, DOC-NUMBER, DOC-NBR-NUM, PO-CODE, LINE-NBR, API-OBJ-ID, SEQ-NBRPrimaryAM17.1, AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198 +22 more (list truncated in source)
MUASET2COMPANY, SYSTEM-CD, DOC-TYPE, API-OBJ-ID, LINE-NBR, SEQ-NBRKeyChange, SubsetWhere API-OBJ-ID != ZeroesAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)

Programs

Updated by (268)