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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#WRQ-ID PK
ID		Alpha 15 (Lower Case)—MA167, MA67.1
#WRQ-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.MA167, MA67.1
#WRQ-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.MA167, MA67.1
#WRQ-VENDOR-SNAME PK
VENDOR_SNAME		Alpha 30The requester can enter the recommended vendor's name for the requested items.MA167, MA67.1
#WRQ-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.MA167, MA67.1
#WRQ-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.MA167, MA67.1
#WRQ-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.MA167, MA67.1
#WRQ-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.MA167, MA67.1
#WRQ-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).MA167, MA67.1
#WRQ-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.MA167, MA67.1
#WRQ-DUE-DATE SET2
DUE_DATE		Numeric 8 (yyyymmdd)The transaction due date.MA167, MA67.1
#WRQ-INVOICE-AMT SET3
INVOICE_AMT		Numeric 16—MA167, MA67.1
#WRQ-INV-COMMENTS
INV_COMMENTS		Alpha 1—MA167, MA67.1
#WRQ-PO-COMMENTS
PO_COMMENTS		Alpha 1—MA167, MA67.1
#WRQ-SERVICE-LINES
SERVICE_LINES		Alpha 1This field indicates a transaction is a Service only transaction.MA167, MA67.1
#WRQ-BUYER
BUYER		Alpha 3——
#WRQ-LOCATION
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.—
#WRQ-OPERATOR
OPERATOR		Alpha 10This field is used to store the login id of the person who entered the record.—
#WRQ-EXT-UNIT-WAOC
EXT_UNIT_WAOC		Signed 18.5——
#WRQ-CB-TYPE
CB_TYPE		Alpha 1——

Indexes (5)

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.

IndexKeysFlagsConditionUsed in
WRQSET1
  1. ID
  2. VENDOR-SNAME
  3. VENDOR
  4. COMPANY
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
PrimaryMA167, MA67.1, MA67.2, MA67.3
WRQSET2
  1. ID
  2. DUE-DATE
  3. COMPANY
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
—
WRQSET3
  1. ID
  2. INVOICE-AMT
  3. COMPANY
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
MA167, MA67.1
WRQSET4
  1. ID
  2. COMPANY
  3. VENDOR-SNAME
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
MA67.1
WRQSET5
  1. ID
  2. INVOICE
  3. COMPANY
  4. VENDOR
  5. SUFFIX
  6. CANCEL-SEQ
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYAPINVOICEMAINVDTLMAPOINVPORECEIVEMAWORKQ

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
WRQ-COMPANY→CPY-COMPANY (CPYSET1)
ApinvoiceAPINVOICERequired
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

RelationTableRulesConditionField map
MainvdtlMAINVDTL
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
MapoinvMAPOINV
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
Porset9PORECEIVE
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

Programs

Updated by (4)