MAWORKQ – No description in the Lawson data dictionary
- System
- Matching (MA)
- Prefix
WRQ- Primary key
ID,VENDOR-SNAME,VENDOR,COMPANY,INVOICE,SUFFIX,CANCEL-SEQ- Fields
- 20
- Updated by
- 4 programs
- Referenced by
- 0 programs
MAWORKQ is a Lawson Matching table (prefix WRQ); no description in the lawson data dictionary. It is indexed by ID, VENDOR-SNAME, VENDOR, COMPANY, INVOICE, SUFFIX, CANCEL-SEQ (WRQSET1); alternate indexes: WRQSET2, WRQSET3, WRQSET4 and WRQSET5. It is related 1:1 to APCOMPANY and APINVOICE and 1:M to MAINVDTL, MAPOINV and PORECEIVE. It is updated by MA167, MA67.1, MA67.2 and MA67.3. The table has 20 fields, 5 indexes and 5 documented relations.
About MAWORKQ
No description in the Lawson data dictionary.
Fields (20)
Column = COBOL field name without the WRQ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WRQ-ID PKID | Alpha 15 (Lower Case) | — | MA167, MA67.1 |
WRQ-COMPANY PKCOMPANY | 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. | MA167, MA67.1 |
WRQ-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | MA167, MA67.1 |
WRQ-VENDOR-SNAME PKVENDOR_SNAME | Alpha 30 | The requester can enter the recommended vendor's name for the requested items. | MA167, MA67.1 |
WRQ-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | MA167, MA67.1 |
WRQ-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | MA167, MA67.1 |
WRQ-CANCEL-SEQ PKCANCEL_SEQ | Numeric 4 | An automatically assigned sequence number. | MA167, MA67.1 |
WRQ-PO-NUMBERPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | MA167, MA67.1 |
WRQ-PO-RELEASEPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | MA167, MA67.1 |
WRQ-PO-CODEPO_CODE | Alpha 4 | This is the purchase order code. | MA167, MA67.1 |
WRQ-DUE-DATEDUE_DATE | Numeric 8 (yyyymmdd) | The transaction due date. | MA167, MA67.1 |
WRQ-INVOICE-AMTINVOICE_AMT | Numeric 16 | — | MA167, MA67.1 |
WRQ-INV-COMMENTSINV_COMMENTS | Alpha 1 | — | MA167, MA67.1 |
WRQ-PO-COMMENTSPO_COMMENTS | Alpha 1 | — | MA167, MA67.1 |
WRQ-SERVICE-LINESSERVICE_LINES | Alpha 1 | This field indicates a transaction is a Service only transaction. | MA167, MA67.1 |
WRQ-BUYERBUYER | Alpha 3 | — | — |
WRQ-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | — |
WRQ-OPERATOROPERATOR | Alpha 10 | This field is used to store the login id of the person who entered the record. | — |
WRQ-EXT-UNIT-WAOCEXT_UNIT_WAOC | Signed 18.5 | — | — |
WRQ-CB-TYPECB_TYPE | Alpha 1 | — | — |
Indexes (5)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
WRQSET1 | ID, VENDOR-SNAME, VENDOR, COMPANY, INVOICE, SUFFIX, CANCEL-SEQ | Primary | MA167, MA67.1, MA67.2, MA67.3 | |
WRQSET2 | ID, DUE-DATE, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ | — | ||
WRQSET3 | ID, INVOICE-AMT, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ | MA167, MA67.1 | ||
WRQSET4 | ID, COMPANY, VENDOR-SNAME, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ | MA67.1 | ||
WRQSET5 | ID, INVOICE, COMPANY, VENDOR, SUFFIX, CANCEL-SEQ | — |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apcompany | APCOMPANY | Required | WRQ-COMPANY → CPY-COMPANY (CPYSET1) | |
| Apinvoice | APINVOICE | Required | WRQ-COMPANY → API-COMPANY, WRQ-VENDOR → API-VENDOR, WRQ-INVOICE → API-INVOICE, WRQ-SUFFIX → API-SUFFIX, WRQ-CANCEL-SEQ → API-CANCEL-SEQ |
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Mainvdtl | MAINVDTL | WRQ-COMPANY → MAD-COMPANY, WRQ-VENDOR → MAD-VENDOR, WRQ-INVOICE → MAD-INVOICE, WRQ-SUFFIX → MAD-SUFFIX, WRQ-PO-NUMBER → MAD-PO-NUMBER, WRQ-PO-RELEASE → MAD-PO-RELEASE, WRQ-PO-CODE → MAD-PO-CODE, MAD-LINE-NBR, MAD-SEQ-NBR | ||
| Mapoinv | MAPOINV | WRQ-COMPANY → AOI-COMPANY, WRQ-VENDOR → AOI-VENDOR, WRQ-INVOICE → AOI-INVOICE, WRQ-SUFFIX → AOI-SUFFIX, AOI-PO-NUMBER, AOI-PO-RELEASE, AOI-PO-CODE | ||
| Porset9 | PORECEIVE | WRQ-COMPANY → POR-COMPANY, WRQ-VENDOR → POR-VENDOR, WRQ-PO-CODE → POR-PO-CODE, WRQ-PO-NUMBER → POR-PO-NUMBER, WRQ-PO-RELEASE → POR-PO-RELEASE, POR-LOCATION, POR-REC-NUMBER |