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.

Field / column	Type	Description & values	Updated by
`MRF-COMPANY` PK COMPANY	Numeric 4	—	AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
`MRF-VENDOR` PK VENDOR	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` PK API_INVOICE	Alpha 22	—	AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
`MRF-API-SUFFIX` PK API_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` PK API_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` PK REF_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` PK REF_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` PK REF_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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MRFSET1`	`COMPANY`, `VENDOR`, `API-INVOICE`, `API-SUFFIX`, `API-CANCEL-SEQ`, `REF-INV-NBR`, `REF-SUFFIX`, `REF-CANCEL-SEQ`	Primary		AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +12 more
`MRFSET2`	`COMPANY`, `VENDOR`, `REF-INV-NBR`, `REF-SUFFIX`, `REF-CANCEL-SEQ`, `API-INVOICE`, `API-SUFFIX`, `API-CANCEL-SEQ`			MA42.1, MA70.1, MA75.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Apinvoice1	APINVOICE	Required		`MRF-COMPANY` → `API-COMPANY`, `MRF-VENDOR` → `API-VENDOR`, `MRF-API-INVOICE` → `API-INVOICE`, `MRF-API-SUFFIX` → `API-SUFFIX`, `MRF-API-CANCEL-SEQ` → `API-CANCEL-SEQ`
Apinvoice2	APINVOICE	Required		`MRF-COMPANY` → `API-COMPANY`, `MRF-VENDOR` → `API-VENDOR`, `MRF-REF-INV-NBR` → `API-INVOICE`, `MRF-REF-SUFFIX` → `API-SUFFIX`, `MRF-REF-CANCEL-SEQ` → `API-CANCEL-SEQ`

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