RQLMXVAL – No description in the Lawson data dictionary
- System
- Requisitions (RQ)
- Prefix
RQV- Primary key
RQL-OBJ-ID,MATRIX-CAT- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 16 programs
RQLMXVAL is a Lawson Requisitions table (prefix RQV); no description in the lawson data dictionary. It is indexed by RQL-OBJ-ID, MATRIX-CAT (RQVSET1); alternate indexes: RQVSET2. It is related 1:1 to MXCATDEF, MXOBJCAT and RQLOC. It is updated by MX500 and RQBL.3 and referenced by AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 and 8 more. The table has 3 fields, 2 indexes and 3 documented relations.
About RQLMXVAL
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the RQV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RQV-RQL-OBJ-ID PKRQL_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. | MX500, RQ01.3, RQBL.3 |
#RQV-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis. | MX500, RQ01.3, RQBL.3 |
#RQV-MX-VALUE SET2MX_VALUE | Alpha 32 | The attribute value. | MX500, RQ01.3, RQBL.3 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RQVSET1 |
| Primary | AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +11 more | |
RQVSET2 |
| KeyChange | MX500, RQBL.1 |
Relations
One to one (3) — lookups and parents
Programs
Updated by (2)
Referenced by (16)
- AP510 Vendor Conversion
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC81.1 Cart, Par Location
- IC840 Cart Par Location Conversion
- RQ01.1 Requesting Locations
- RQ01.2 RQ Location Attributes
- RQ01.3 Values by RQ Location Attributes
- RQ810 Request Location Load