MACOMPANY – Matching Company

System
Matching (MA)
Prefix
MAY
Primary key
COMPANY
Fields
85
Updated by
4 programs
Referenced by
302 programs

MACOMPANY is the Matching Company table in Lawson Matching (prefix MAY). It is indexed by COMPANY (MAYSET1); alternate indexes: MAYSET2. It is related 1:1 to ICCOMPANY, MAMATCHTBL, MAMTCHRULE and POCOMPANY. It is updated by MA01.1, MA126, MA310 and MA999 and referenced by AP125, AP126, AP131, AP136, AP170, AP175, AP176, AP177 and 294 more. The table has 85 fields, 2 indexes and 4 documented relations.

About MACOMPANY

The Matching Company file contains matching and account information defined at the company level.

Fields (85)

Column = COBOL field name without the MAY- 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
#MAY-COMPANY PK
COMPANY
Numeric 4The company number.MA01.1
#MAY-NAME
NAME
Alpha 30 (Lower Case)The location name or description.MA01.1, MA540
#MAY-MATCH-TABLE
MATCH_TABLE
Alpha 10Match table. Contains matching and match processing rules.MA01.1
#MAY-ACC-ACCT-UNIT
ACC_ACCT_UNIT
Alpha 15PO accrual accounting unit. Used as a suspense account for invoiced items and as a posting account for received not invoiced report.MA01.1
#MAY-ACC-ACCOUNT
ACC_ACCOUNT
Numeric 6PO accrual account number.MA01.1
#MAY-ACC-SUB-ACCT
ACC_SUB_ACCT
Numeric 4PO accrual subaccount number.MA01.1
#MAY-VAR-ACCT-UNIT
VAR_ACCT_UNIT
Alpha 15The item cost variance accounting unit. The item cost variance account is the posting account for cost differences between the PO and the receipt.MA01.1
#MAY-VAR-ACCOUNT
VAR_ACCOUNT
Numeric 6The item code variance account number.MA01.1
#MAY-VAR-SUB-ACCT
VAR_SUB_ACCT
Numeric 4The item cost variance account subaccount number.MA01.1
#MAY-TOL-ACCT-UNIT
TOL_ACCT_UNIT
Alpha 15Tolerance offset accounting unit.MA01.1
#MAY-TOL-ACCOUNT
TOL_ACCOUNT
Numeric 6Tolerance offset account number.MA01.1
#MAY-TOL-SUB-ACCT
TOL_SUB_ACCT
Numeric 4Tolerance offset subaccount number.MA01.1
#MAY-DACC-ACCT-UNIT
DACC_ACCT_UNIT
Alpha 15Discount accrual accounting unit.MA01.1
#MAY-DACC-ACCOUNT
DACC_ACCOUNT
Numeric 6Discount accrual account number.MA01.1
#MAY-DACC-SUB-ACCT
DACC_SUB_ACCT
Numeric 4Discount accrual subaccount number.MA01.1
#MAY-REC-ACCT-UNIT
REC_ACCT_UNIT
Alpha 15The receipt write-off accounting unit.MA01.1
#MAY-REC-ACCOUNT
REC_ACCOUNT
Numeric 6The receipt write-off account number.MA01.1
#MAY-REC-SUB-ACCT
REC_SUB_ACCT
Numeric 4The receipt write-off subaccount number.MA01.1
#MAY-MNR-ACCT-UNIT
MNR_ACCT_UNIT
Alpha 15The accounting unit for invoice that match without receipts.MA01.1
#MAY-MNR-ACCOUNT
MNR_ACCOUNT
Numeric 6The account for invoices that match without receipts.MA01.1
#MAY-MNR-SUB-ACCT
MNR_SUB_ACCT
Numeric 4The subaccount for invoices that match without receipts.MA01.1
#MAY-MWO-ACCT-UNIT
MWO_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.MA01.1
#MAY-MWO-ACCOUNT
MWO_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.MA01.1
#MAY-MWO-SUB-ACCT
MWO_SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.MA01.1
#MAY-MTCH-EXCESS-NR
MTCH_EXCESS_NR
Numeric 1—
  • 1 Matched no receipt
  • 2 Write off
MA01.1
#MAY-MTCH-EXC-REC
MTCH_EXC_REC
Numeric 1—
  • 1 Matched no receipt
  • 2 Write off
MA01.1
#MAY-DISC-TAKEN
DISC_TAKEN
Alpha 1Indicates where a discount was taken. Valid values are:
  • P Payment
  • M Match
MA01.1
#MAY-CURR-SET-FLAG
CURR_SET_FLAG
Alpha 1Flag defines when the currency rate has been set for the Purchase Order.
  • E Purchase Order Entry
  • R Receiving
  • I Invoicing
MA01.1
#MAY-HANDLING-CODE SET2
HANDLING_CODE
Alpha 4Invoice handling code. The invoice handling code contains processing rules for invoice matching. Handling codes can be assigned at the company level.MA01.1
#MAY-HOLD-INSP-FLAG
HOLD_INSP_FLAG
Alpha 1If set to "Y", this flag will keep receiving lines requiring inspection from being matched until they have been inspected.
  • Y Yes
  • N No
MA01.1
#MAY-WRITE-OFF-AMT
WRITE_OFF_AMT
Signed 18.2—MA01.1
#MAY-VEN-CLAIM-TYPE
VEN_CLAIM_TYPE
Alpha 2—
  • CB Chargeback
  • CM Credit Memo
  • N None
MA01.1, PO52.1
#MAY-CLAIM-HOLD-CD
CLAIM_HOLD_CD
Alpha 4The hold code.MA01.1
#MAY-CB-HOLD-CODE
CB_HOLD_CODE
Alpha 4The hold code.MA01.1
#MAY-REPLACE-GOODS
REPLACE_GOODS
Alpha 1—
  • Y Yes
  • N No
MA01.1
#MAY-SHIP-OR-HOLD
SHIP_OR_HOLD
Alpha 1—
  • S Ship
  • H Hold
MA01.1, PO52.1
#MAY-MATCH-CLASS
MATCH_CLASS
Alpha 10A match class is a user-defined matching key structure made up of matching elements.MA01.1
#MAY-CURRENCY-CODE
CURRENCY_CODE
Alpha 5The base currency defined for the company in the Lawson General Ledger system.MA01.1
#MAY-CURR-ND
CURR_ND
Numeric 1Represents the number of decimals defined for the currency of the object.MA01.1
#MAY-ERS-LOC-CNTRL
ERS_LOC_CNTRL
Alpha 1Indicates whether the company controls ERS by ship-to location.
  • N No
  • Y Yes
MA01.1
#MAY-ERS-COST-UPD
ERS_COST_UPD
Alpha 1Indicates whether to update ERS costs.
  • N No
  • Y Yes
MA01.1
#MAY-EDI-AUTO-REL
EDI_AUTO_REL
Alpha 1Indicates whether the company automatically releases EDI invoices.
  • N No
  • Y Yes
MA01.1
#MAY-POOL-OPTION
POOL_OPTION
Numeric 1—
  • 1 Company Vendor
  • 2 Company Vendor PO
  • 3 Company Vendor PO Ship To
MA01.1, MA310
#MAY-UNDER-TOL-FLAG
UNDER_TOL_FLAG
Alpha 1—MA01.1
#MAY-OVER-TOL-FLAG
OVER_TOL_FLAG
Alpha 1—MA01.1
#MAY-ITEM-DIFF-FLAG
ITEM_DIFF_FLAG
Alpha 1——
#MAY-VALIDATE-PO
VALIDATE_PO
Alpha 1—
  • Y Yes
  • N No
MA01.1, MA999
#MAY-REQUIRE-PO
REQUIRE_PO
Alpha 1—
  • Y Yes
  • N No
MA01.1, MA999
#MAY-PO-COST-MSG-FL
PO_COST_MSG_FL
Alpha 1—MA01.1, MA999
#MAY-PO-MATCH-RULE
PO_MATCH_RULE
Alpha 10—MA01.1
#MAY-PO-ORDER
PO_ORDER
Numeric 2—MA01.1
#MAY-PO-COST-WF
PO_COST_WF
Alpha 1—MA01.1, MA999
#MAY-MATCH-RULE
MATCH_RULE
Alpha 10—MA01.1
#MAY-ORDER
ORDER
Numeric 2—MA01.1
#MAY-RECON-MSG-WF
RECON_MSG_WF
Alpha 1—MA01.1, MA999
#MAY-NO-RCPT-DAYS
NO_RCPT_DAYS
Numeric 3—MA01.1
#MAY-NO-RCPT-OPTION
NO_RCPT_OPTION
Alpha 1—MA01.1
#MAY-DAYS-TO-WORK
DAYS_TO_WORK
Numeric 3—MA01.1
#MAY-DAYS-TO-WRK-OP
DAYS_TO_WRK_OP
Alpha 1—MA01.1
#MAY-INVAL-INV-OPT
INVAL_INV_OPT
Alpha 1——
#MAY-WF-CALC-DATE
WF_CALC_DATE
Alpha 1—MA01.1
#MAY-INV-FINRPT-IND
INV_FINRPT_IND
Alpha 1" " = No
  • Y Yes
  • N No
MA01.1, MA999
#MAY-RCT-FINRPT-IND
RCT_FINRPT_IND
Alpha 1" " = No
  • Y Yes
  • N No
IC130, MA01.1, MA999
#MAY-DRPSHP-MSG-FL
DRPSHP_MSG_FL
Alpha 1—MA999
#MAY-DRPSHP-RULE
DRPSHP_RULE
Alpha 10——
#MAY-DRPSHP-ORDER
DRPSHP_ORDER
Numeric 2——
#MAY-DRPSHP-WF
DRPSHP_WF
Alpha 1—MA999
#MAY-SRVC-MSG-FL
SRVC_MSG_FL
Alpha 1—MA01.1, MA999
#MAY-SRVC-RULE
SRVC_RULE
Alpha 10—MA01.1
#MAY-SRVC-ORDER
SRVC_ORDER
Numeric 2—MA01.1
#MAY-SRVC-WF
SRVC_WF
Alpha 1—MA01.1, MA999
#MAY-PRP-ACCT-UNIT
PRP_ACCT_UNIT
Alpha 15Accounting unit for the match prepayment differencesMA01.1
#MAY-PRP-ACCOUNT
PRP_ACCOUNT
Numeric 6Account for the match prepayment differencesMA01.1
#MAY-PRP-SUB-ACCT
PRP_SUB_ACCT
Numeric 4—MA01.1
#MAY-UBILL-ACCT-UNT
UBILL_ACCT_UNT
Alpha 15—MA01.1
#MAY-UBILL-ACCOUNT
UBILL_ACCOUNT
Numeric 6—MA01.1
#MAY-UBILL-SUB-ACCT
UBILL_SUB_ACCT
Numeric 4—MA01.1
#MAY-AOCD-ACCT-UNIT
AOCD_ACCT_UNIT
Alpha 15—MA01.1
#MAY-AOCD-ACCOUNT
AOCD_ACCOUNT
Numeric 6—MA01.1
#MAY-AOCD-SUB-ACCT
AOCD_SUB_ACCT
Numeric 4—MA01.1
#MAY-IRA-ACCT-UNIT
IRA_ACCT_UNIT
Alpha 15Inventory Receipts Archival accounting unit. It is used by the purchasing archival program for inventory item invoices where the receiving was missing. It is reconciled by a physical inventory.MA01.1
#MAY-IRA-ACCOUNT
IRA_ACCOUNT
Numeric 6Inventory Receipts Archival account. It is used by the purchasing archival program for inventory item invoices where the receiving was missing. It is reconciled by a physical inventory.MA01.1
#MAY-IRA-SUB-ACCT
IRA_SUB_ACCT
Numeric 4Inventory Receipts Archival subaccount.MA01.1
#MAY-SUMM-APDIST-FL
SUMM_APDIST_FL
Alpha 1This flag determines whether the like distributions will be summarized in the invoice match process. By default they will be summarized (Summ-apdist-fl = spaces).
  • N No
MA01.1
#MAY-OPEN-ZERO-COST
OPEN_ZERO_COST
Alpha 1Use this field to indicate whether or not the MA Company will allow a zero-cost invoice line to be left open up through the matching process.
  • N No
  • Y Yes
—

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.

IndexKeysFlagsConditionUsed in
MAYSET1
  1. COMPANY
PrimaryAP125, AP126, AP131, AP136, AP170, AP175, AP176, AP177 +22 more (list truncated in source)
MAYSET2
  1. HANDLING-CODE
  2. COMPANY
MA05.1, MA05.3, MA205

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYNot Required
MAY-COMPANY→ICC-COMPANY
MamatchtblMAMATCHTBLRequired
MAY-MATCH-TABLE→MAM-MATCH-TABLE
MamtchruleMAMTCHRULERequired
MAY-MATCH-RULE→MAU-MATCH-RULE
PocompanyPOCOMPANYNot Required
MAY-COMPANY→PCY-COMPANY

Programs

Updated by (4)

Referenced by (302)