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.

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
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.2MA01.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 1MA01.1
MAY-OVER-TOL-FLAG
OVER_TOL_FLAG
Alpha 1MA01.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 1MA01.1, MA999
MAY-PO-MATCH-RULE
PO_MATCH_RULE
Alpha 10MA01.1
MAY-PO-ORDER
PO_ORDER
Numeric 2MA01.1
MAY-PO-COST-WF
PO_COST_WF
Alpha 1MA01.1, MA999
MAY-MATCH-RULE
MATCH_RULE
Alpha 10MA01.1
MAY-ORDER
ORDER
Numeric 2MA01.1
MAY-RECON-MSG-WF
RECON_MSG_WF
Alpha 1MA01.1, MA999
MAY-NO-RCPT-DAYS
NO_RCPT_DAYS
Numeric 3MA01.1
MAY-NO-RCPT-OPTION
NO_RCPT_OPTION
Alpha 1MA01.1
MAY-DAYS-TO-WORK
DAYS_TO_WORK
Numeric 3MA01.1
MAY-DAYS-TO-WRK-OP
DAYS_TO_WRK_OP
Alpha 1MA01.1
MAY-INVAL-INV-OPT
INVAL_INV_OPT
Alpha 1
MAY-WF-CALC-DATE
WF_CALC_DATE
Alpha 1MA01.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 1MA999
MAY-DRPSHP-RULE
DRPSHP_RULE
Alpha 10
MAY-DRPSHP-ORDER
DRPSHP_ORDER
Numeric 2
MAY-DRPSHP-WF
DRPSHP_WF
Alpha 1MA999
MAY-SRVC-MSG-FL
SRVC_MSG_FL
Alpha 1MA01.1, MA999
MAY-SRVC-RULE
SRVC_RULE
Alpha 10MA01.1
MAY-SRVC-ORDER
SRVC_ORDER
Numeric 2MA01.1
MAY-SRVC-WF
SRVC_WF
Alpha 1MA01.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 4MA01.1
MAY-UBILL-ACCT-UNT
UBILL_ACCT_UNT
Alpha 15MA01.1
MAY-UBILL-ACCOUNT
UBILL_ACCOUNT
Numeric 6MA01.1
MAY-UBILL-SUB-ACCT
UBILL_SUB_ACCT
Numeric 4MA01.1
MAY-AOCD-ACCT-UNIT
AOCD_ACCT_UNIT
Alpha 15MA01.1
MAY-AOCD-ACCOUNT
AOCD_ACCOUNT
Numeric 6MA01.1
MAY-AOCD-SUB-ACCT
AOCD_SUB_ACCT
Numeric 4MA01.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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MAYSET1COMPANYPrimaryAP125, AP126, AP131, AP136, AP170, AP175, AP176, AP177 +22 more (list truncated in source)
MAYSET2HANDLING-CODE, COMPANYMA05.1, MA05.3, MA205

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYNot RequiredMAY-COMPANYICC-COMPANY
MamatchtblMAMATCHTBLRequiredMAY-MATCH-TABLEMAM-MATCH-TABLE
MamtchruleMAMTCHRULERequiredMAY-MATCH-RULEMAU-MATCH-RULE
PocompanyPOCOMPANYNot RequiredMAY-COMPANYPCY-COMPANY

Programs

Updated by (4)

Referenced by (302)