MAINVREF – No description in the Lawson data dictionary
- System
- Matching (MA)
- Prefix
MRF- Primary key
COMPANY,VENDOR,API-INVOICE,API-SUFFIX,API-CANCEL-SEQ,REF-INV-NBR,REF-SUFFIX,REF-CANCEL-SEQ- Fields
- 8
- Updated by
- 19 programs
- Referenced by
- 1 program
MAINVREF is a Lawson Matching table (prefix MRF); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, API-INVOICE, API-SUFFIX, API-CANCEL-SEQ, REF-INV-NBR, REF-SUFFIX, REF-CANCEL-SEQ (MRFSET1); alternate indexes: MRFSET2. It is related 1:1 to APINVOICE. It is updated by AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 and 11 more and referenced by MAI1.1. The table has 8 fields, 2 indexes and 2 documented relations.
About MAINVREF
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the MRF- 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 |
|---|---|---|---|
#MRF-COMPANY PKCOMPANY | Numeric 4 | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more |
#MRF-VENDOR PKVENDOR | Alpha 9 (Right Justified) | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more |
#MRF-API-INVOICE PKAPI_INVOICE | Alpha 22 | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more |
#MRF-API-SUFFIX PKAPI_SUFFIX | Numeric 3 | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more |
#MRF-API-CANCEL-SEQ PKAPI_CANCEL_SEQ | Numeric 4 | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +11 more |
#MRF-REF-INV-NBR PKREF_INV_NBR | Alpha 22 | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more |
#MRF-REF-SUFFIX PKREF_SUFFIX | Numeric 3 | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more |
#MRF-REF-CANCEL-SEQ PKREF_CANCEL_SEQ | Numeric 4 | — | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more |
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 |
|---|---|---|---|---|
MRFSET1 |
| Primary | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +12 more | |
MRFSET2 |
| MA42.1, MA70.1, MA75.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apinvoice1 | APINVOICE | Required |
| ||||||||||||||||
| Apinvoice2 | APINVOICE | Required |
|
Programs
Updated by (19)
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- API1.1 Add Invoice
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
Referenced by (1)
- MAI1.1 Invoke for MAMATCH Object