MAINVMSG – Invoice and PO Cost Message

System: Matching (MA)
Prefix: MAG
Primary key: COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, MAD-SEQ-NBR, SEQ-NBR
Fields: 36
Updated by: 34 programs
Referenced by: 14 programs

MAINVMSG is the Invoice and PO Cost Message table in Lawson Matching (prefix MAG). It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, MAD-SEQ-NBR, SEQ-NBR (MAGSET1); alternate indexes: MAGSET10, MAGSET2, MAGSET3, MAGSET4, MAGSET5, MAGSET6, MAGSET7, MAGSET8 and 1 more. It is related 1:M to POMATCHOBJ. It is updated by AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 and 26 more and referenced by MA264, MA67.3, MA68.3, MA90.2, MA90.3, MA90.5, MA90.6, MM280 and 6 more. The table has 36 fields, 10 indexes and 1 documented relation.

About MAINVMSG

No description in the Lawson data dictionary.

Fields (36)

Column = COBOL field name without the MAG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`MAG-COMPANY` PK COMPANY	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.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-AUTH-CODE` AUTH_CODE	Alpha 3	A user-defined code representing a person or department responsible for approving a registered invoice.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-SUFFIX` PK SUFFIX	Numeric 3	This is the suffix for the invoice.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-CANCEL-SEQ` PK CANCEL_SEQ	Numeric 4	An automatically assigned sequence number.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-PO-NUMBER` PO_NUMBER	Alpha 14 (Right Justified)	This field contains the number representing the purchase order.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-PO-RELEASE` PO_RELEASE	Numeric 4	Used to identify a purchase order release (created from a Blanket or Standing order).	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-PO-CODE` PO_CODE	Alpha 4	This is the purchase order code.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-PO-LINE-NBR` PO_LINE_NBR	Numeric 6	This field contains the line number.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-MAD-SEQ-NBR` PK MAD_SEQ_NBR	Numeric 4	An automatically assigned sequence number.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-API-OBJ-ID` API_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.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-MSG-ORIGIN` MSG_ORIGIN	Alpha 1	— `1` PO Cost `2` Recon Match `3` DropShip `4` Service	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-ITEM` ITEM	Alpha 32	This field contains the item identifier.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-MATCH-DTL-KEY` MATCH_DTL_KEY	Alpha 85	—	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `0` Unreleased `1` Open `2` Pending Action `9` Closed	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA64.9, MA66.2, MA66.3 +2 more
`MAG-ACTION` ACTION	Alpha 1	" " = Open `1` Approved `2` Chargeback `3` Disapprove `4` Forward `5` Accept Cost `6` Adjust Cost `7` Chargeback netted to zero	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA64.9, MA66.2, MA66.3 +2 more
`MAG-OPERATOR` OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	The creation date.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-PROCURE-GROUP` PROCURE_GROUP	Alpha 4	This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-BUYER-CODE` BUYER_CODE	Alpha 3	—	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-AUTH-CODE-MAIL` AUTH_CODE_MAIL	Alpha 30	—	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-FWD-AUTH-OPER` FWD_AUTH_OPER	Alpha 10	This field is used to store the login id of the person who entered the record.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA64.9, MA66.2, MA66.3 +2 more
`MAG-TYPE` TYPE	Alpha 2	This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code. `C` Cost `Q` Quantity `I` Item `NR` No Receipt Line	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-VAR-TYPE` VAR_TYPE	Alpha 1	The Variance Type field contains the value that represents the variance type for fiscal year variances. Valid values are: " " = Item Difference `A` Variance Amount `P` Variance Percent `O` Invoice Over Receipt `U` Invoice Under Receipt	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-REASON-CODE` REASON_CODE	Alpha 4	This field contains the reason code, which indicates the cause for credit memos.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA64.9, MA66.2, MA66.3 +2 more
`MAG-PRIORITY` PRIORITY	Numeric 1	Indicates order of precedence for contracts to determine costing defaults for items. `1` Urgent `2` Normal	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.1, MA66.2, MA66.3 +2 more
`MAG-MATCH-OBJ-ID` MATCH_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.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-RESPOND-DATE` RESPOND_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA64.9, MA66.1, MA66.2 +3 more
`MAG-DISC-DATE` DISC_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-LOCATION` LOCATION	Alpha 5	This field contains a valid stocking location within the company inventory.	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA66.2, MA66.3, MAI1.1 +1 more
`MAG-PO-COST-UPD` PO_COST_UPD	Signed 18.5	—	API1.1, MA43.1, MA43.3, MA44.1, MA64.6, MA64.9, MA66.2, MA66.3 +2 more
`MAG-VEN-ITEM` VEN_ITEM	Alpha 32	—	API1.1, MA43.1, MA43.3, MA44.1, MA66.2, MA66.3, MAI1.1, POI3.1
`MAG-GTIN` GTIN	Numeric 14	—	MA43.1, MA43.3, MA44.1, MA66.2, MA66.3, MAI1.1

Indexes (10)

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
`MAGSET1`	`COMPANY`, `VENDOR`, `INVOICE`, `SUFFIX`, `CANCEL-SEQ`, `MAD-SEQ-NBR`, `SEQ-NBR`	Primary		AP30.4, MA42.1, MA43.1, MA43.3, MA44.1, MA60.3, MA64.1, MA64.4 +13 more
`MAGSET10`	`COMPANY`, `AUTH-CODE`, `GTIN`, `VAR-TYPE`, `TYPE`, `API-OBJ-ID`, `MAD-SEQ-NBR`, `SEQ-NBR`	Subset	Where STATUS = 1	—
`MAGSET2`	`COMPANY`, `AUTH-CODE`, `PO-NUMBER`, `PO-RELEASE`, `PO-CODE`, `INVOICE`, `PO-LINE-NBR`, `MAD-SEQ-NBR`, `VENDOR`, `API-OBJ-ID`, `SEQ-NBR`	KeyChange, Subset	Where STATUS = 1	MA64.2
`MAGSET3`	`COMPANY`, `AUTH-CODE`, `ITEM`, `VAR-TYPE`, `TYPE`, `API-OBJ-ID`, `MAD-SEQ-NBR`, `SEQ-NBR`	KeyChange, Subset	Where STATUS = 1	MA64.3
`MAGSET4`	`COMPANY`, `AUTH-CODE`, `MATCH-DTL-KEY`, `VAR-TYPE`, `TYPE`, `API-OBJ-ID`, `MAD-SEQ-NBR`, `SEQ-NBR`	KeyChange, Subset	Where STATUS = 1	MA64.3
`MAGSET5`	`API-OBJ-ID`, `MAD-SEQ-NBR`, `SEQ-NBR`			AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +22 more (list truncated in source)
`MAGSET6`	`COMPANY`, `AUTH-CODE`, `VENDOR`, `INVOICE`, `SUFFIX`, `CANCEL-SEQ`, `SEQ-NBR`	KeyChange, Subset	Where STATUS = 1	MA64.1
`MAGSET7`	`COMPANY`, `STATUS`, `OPERATOR`, `MSG-ORIGIN`, `CREATE-DATE`, `RESPOND-DATE`, `VENDOR`, `API-OBJ-ID`, `MAD-SEQ-NBR`, `SEQ-NBR`	KeyChange		MA264
`MAGSET8`	`COMPANY`, `STATUS`, `AUTH-CODE`, `MSG-ORIGIN`, `CREATE-DATE`, `RESPOND-DATE`, `VENDOR`, `API-OBJ-ID`, `MAD-SEQ-NBR`, `SEQ-NBR`	KeyChange		MA264
`MAGSET9`	`COMPANY`, `AUTH-CODE`, `VEN-ITEM`, `VAR-TYPE`, `TYPE`, `API-OBJ-ID`, `MAD-SEQ-NBR`, `SEQ-NBR`	Subset	Where STATUS = 1	MA64.3

Relations

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Pomatchobj	POMATCHOBJ			`MAG-COMPANY` → `PMJ-COMPANY`, `MAG-PO-NUMBER` → `PMJ-PO-NUMBER`, `MAG-PO-RELEASE` → `PMJ-PO-RELEASE`, `MAG-PO-CODE` → `PMJ-PO-CODE`, `MAG-PO-LINE-NBR` → `PMJ-LINE-NBR`, → `PMJ-TRAN-DATE`, → `PMJ-TRAN-TIME`, → `PMJ-MATCH-OBJ-ID`, → `PMJ-MATCH-SEQ-NBR`, → `PMJ-TYPE`

Programs

Updated by (34)

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
AP25.2 Batch Review
AP30.4 Invoice Cancel
AP300 Invoice and Vendor History Purge
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.1 Invoice Line Detail - Purchase Order
MA43.2 Purchase Order Lookup
MA43.3 Invoice Line Detail - Receipt
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA60.3 Detail Level Match
MA61.1 Match Invoice Approval
MA64.6 Message Detail by Invoice
MA64.9 PO Cost Message Accept Upload
MA66.1 Review Invoice Message
MA66.2 Invoice Message - Details
MA66.3 Purchase Order Cost Review Message
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MAI1.1 Invoke for MAMATCH Object
PO136 Matched, Not Received Report
POI3.1 Invoke for POPI70PD

Referenced by (14)

MA264 Invoice Message Listing
MA67.3 Detail Match from frontend
MA68.3 Detail Level Match - Prepaid
MA90.2 All Transactions for Invoice
MA90.3 Match Analysis Details
MA90.5 Misc AOC for an Invoice
MA90.6 Summarization
MM280 Departmental Procurement Expense Report
MM80.1 Departmental Procurement Expense Inquiry Selection
MM80.2 Departmental Procurement Expense Inquiry Detail
PO135 Received, Not Invoiced Report
PO139 Standard Cost Calculation
PO278 RNI Aging Report
POIJ.1 Invoke for POPLIUPD