MACOMPANY FILE
Matching Company
The Matching Company file contains matching and account information defined
at the company level.
REFERENCED BY
AP125 AP126 AP131 AP170 AP175 AP176
AP177 AP190 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP220 AP23.1 AP25.1 AP25.2
AP26.1 AP260 AP27.1 AP30.1 AP30.2 AP30.4
AP305 AP520 API1.1 API2.1 DR100 IC02.1
IC10.2 IC11.1 IC130 IC131 IC141 IC142
IC28.1 IC811 IC83.1 MA05.1 MA05.3 MA126
MA180 MA200 MA205 MA208 MA231 MA41.1
MA41.2 MA41.4 MA43.1 MA43.2 MA43.3 MA43.4
MA43.5 MA43.7 MA43.8 MA43.9 MA53.1 MA53.2
MA53.3 MA530 MA531 MA54.8 MA540 MA60.1
MA60.2 MA60.3 MA60.4 MA60.5 MA61.1 MA62.6
MA63.1 MA64.6 MA65.1 MA66.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 PO01.1 PO100
PO101 PO122 PO131 PO135 PO136 PO181
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO27.3 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO529 PO54.4 PO85.1 POED.1
POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ35.1 RQ500 RQIF.1 WH20.2
WH20.7
UPDATED BY
MA01.1 MA310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAY-COMPANY Numeric 4 MA01.1
Company The company number.
MAY-NAME Alpha 30 (Lower Case) MA01.1
Name The location name or description.
MAY-MATCH-TABLE Alpha 10 MA01.1
Match Table Match table. Contains matching and
match processing rules.
MAY-ACC-ACCT-UNIT Alpha 15 MA01.1
PO Accrual PO accrual accounting unit. Used as a
Accounting Unit suspense account for invoiced items and
as a posting account for received not
invoiced report.
MAY-ACC-ACCOUNT Numeric 6 MA01.1
PO Accrual Account PO accrual account number.
MAY-ACC-SUB-ACCT Numeric 4 MA01.1
PO Accrual PO accrual subaccount number.
Subaccount
MAY-VAR-ACCT-UNIT Alpha 15 MA01.1
Cost Variance The item cost variance accounting unit.
Accounting Unit The item cost variance account is the
posting account for cost differences
between the PO and the receipt.
MAY-VAR-ACCOUNT Numeric 6 MA01.1
Cost Variance The item code variance account number.
Account Number
MAY-VAR-SUB-ACCT Numeric 4 MA01.1
Cost Variance The item cost variance account
Subaccount subaccount number.
MAY-TOL-ACCT-UNIT Alpha 15 MA01.1
Tolerance Accouning Tolerance offset accounting unit.
Unit
MAY-TOL-ACCOUNT Numeric 6 MA01.1
Tolerance Account Tolerance offset account number.
MAY-TOL-SUB-ACCT Numeric 4 MA01.1
Tolerance Subaccount Tolerance offset subaccount number.
MAY-DACC-ACCT-UNIT Alpha 15 MA01.1
Discount Accrual Discount accrual accounting unit.
Acct Unit
MAY-DACC-ACCOUNT Numeric 6 MA01.1
Discount Accrual Discount accrual account number.
Account
MAY-DACC-SUB-ACCT Numeric 4 MA01.1
Discount Accrual Discount accrual subaccount number.
Subaccount
MAY-REC-ACCT-UNIT Alpha 15 MA01.1
Receipts Offset The receipt write-off accounting unit.
Account Unit
MAY-REC-ACCOUNT Numeric 6 MA01.1
Receipts Offset The receipt write-off account number.
Account Nbr
MAY-REC-SUB-ACCT Numeric 4 MA01.1
Receipts Offset The receipt write-off subaccount number.
Subaccount M = Match
P = Payment
MAY-MNR-ACCT-UNIT Alpha 15 MA01.1
Matched w/o Receipt The accounting unit for invoice that
Acct Unit match without receipts.
MAY-MNR-ACCOUNT Numeric 6 MA01.1
Matched w/o Receipt The account for invoices that match
Account without receipts.
MAY-MNR-SUB-ACCT Numeric 4 MA01.1
Matched w/o Receipt The subaccount for invoices that match
Subaccount without receipts.
MAY-MWO-ACCT-UNIT Alpha 15 MA01.1
Mwo Acct Unit
MAY-MWO-ACCOUNT Numeric 6 MA01.1
Mwo Account
MAY-MWO-SUB-ACCT Numeric 4 MA01.1
Mwo Sub Acct
MAY-MTCH-EXCESS-NR Numeric 1 MA01.1
Mtch Excess Nr 1 = Matched no receipt
2 = Write off
MAY-MTCH-EXC-REC Numeric 1 MA01.1
Mtch Exc Rec 1 = Matched no receipt
2 = Write off
MAY-DISC-TAKEN Alpha 1 MA01.1
Discount Taken Indicates where a discount was taken.
Valid values are:
P = Payment
M = Match
MAY-CURR-SET-FLAG Alpha 1 MA01.1
Currency Set Flag Flag defines when the currency rate
has been set for the Purchase Order.
E = Purchase Order Entry
R = Receiving
I = Invoicing
MAY-HANDLING-CODE Alpha 4 MA01.1
Handling Code Invoice handling code. The invoice
handling code contains processing rules
for invoice matching. Handling codes can
be assigned at the company level.
MAY-HOLD-INSP-FLAG Alpha 1 MA01.1
Hold Insp Flag If set to "Y", this flag will keep
receiving lines requiring inspection
from being matched until they have been
inspected.
Y = Yes
N = No
MAY-WRITE-OFF-AMT Signed 15.2 MA01.1
Write Off Amt
MAY-VEN-CLAIM-TYPE Alpha 2 MA01.1 PO52.1
Ven Claim Type CB = Chargeback
CM = Credit Memo
N = None
MAY-CLAIM-HOLD-CD Alpha 4 MA01.1
Claim Hold Cd
MAY-CB-HOLD-CODE Alpha 4 MA01.1
Cb Hold Code
MAY-REPLACE-GOODS Alpha 1 MA01.1
Replace Goods Y = Yes
N = No
MAY-SHIP-OR-HOLD Alpha 1 MA01.1 PO52.1
Ship Or Hold S = Ship
H = Hold
MAY-MATCH-CLASS Alpha 10 MA01.1
Match Class A match class is a user-defined
matching key structure made up of
matching elements.
MAY-CURRENCY-CODE Alpha 5 MA01.1
Currency Code The base currency defined for the
company in the Lawson General Ledger
system.
MAY-CURR-ND Numeric 1 MA01.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
MAY-ERS-LOC-CNTRL Alpha 1 MA01.1
ERS Location Control Indicates whether the company controls
ERS by ship-to location.
N = No
Y = Yes
MAY-ERS-COST-UPD Alpha 1 MA01.1
ERS Cost Update Indicates whether to update ERS costs.
N = No
Y = Yes
MAY-EDI-AUTO-REL Alpha 1 MA01.1
EDI Auto Release Indicates whether the company
automatically releases EDI invoices.
N = No
Y = Yes
MAY-POOL-OPTION Numeric 1 MA01.1 MA310
Pool Option 1 = Company Vendor
2 = Company Vendor PO
3 = Company Vendor PO Ship To
MAY-OVER-TOL-FLAG Alpha 1 MA01.1
Over Tol Flag
MAY-UNDER-TOL-FLAG Alpha 1 MA01.1
Under Tol Flag
MAY-ITEM-DIFF-FLAG Alpha 1 MA01.1
Item Diff Flag
MAY-VALIDATE-PO Alpha 1 MA01.1
Validate Po Y = Yes
N = No
MAY-REQUIRE-PO Alpha 1 MA01.1
Require Po Y = Yes
N = No
MAY-PO-COST-MSG-FL Alpha 1 MA01.1
Po Cost Msg Fl
MAY-PO-MATCH-RULE Alpha 10 MA01.1
Po Match Rule
MAY-PO-ORDER Numeric 2 MA01.1
Po Order
MAY-PO-COST-WF Alpha 1 MA01.1
Po Cost Wf
MAY-MATCH-RULE Alpha 10 MA01.1
Match Rule
MAY-ORDER Numeric 2 MA01.1
Order
MAY-RECON-MSG-WF Alpha 1 MA01.1
Recon Msg Wf
MAY-NO-RCPT-DAYS Numeric 3 MA01.1
No Rcpt Days
MAY-NO-RCPT-OPTION Alpha 1 MA01.1
No Rcpt Option
MAY-DAYS-TO-WORK Numeric 3 MA01.1
Days To Work
MAY-DAYS-TO-WRK-OP Alpha 1 MA01.1
Days To Wrk Op
MAY-INVAL-INV-OPT Alpha 1 MA01.1
Inval Inv Opt
MAY-WF-CALC-DATE Alpha 1 MA01.1
Wf Calc Date
MAY-INV-FINRPT-IND Alpha 1 MA01.1
Inv Finrpt Ind Y = Yes
N = No
" " = No
MAY-RCT-FINRPT-IND Alpha 1 IC130 MA01.1
Rct Finrpt Ind Y = Yes
N = No
" " = No
MAY-DRPSHP-MSG-FL Alpha 1 MA01.1
Drpshp Msg Fl
MAY-DRPSHP-RULE Alpha 10 MA01.1
Drpshp Rule
MAY-DRPSHP-ORDER Numeric 2 MA01.1
Drpshp Order
MAY-DRPSHP-WF Alpha 1 MA01.1
Drpshp Wf
MAY-SRVC-MSG-FL Alpha 1 MA01.1
Srvc Msg Fl
MAY-SRVC-RULE Alpha 10 MA01.1
Srvc Rule
MAY-SRVC-ORDER Numeric 2 MA01.1
Srvc Order
MAY-SRVC-WF Alpha 1 MA01.1
Srvc Wf
MACOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAYSET1 COMPANY AP125 AP126
AP131 AP170
AP175 AP176
AP177 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP260
AP27.1 AP30.1
AP30.2 AP30.4
AP305 AP520
API1.1 API2.1
DR100 IC02.1
...
MAYSET2 HANDLING-CODE MA05.1 MA05.3
COMPANY MA205
MACOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Not Required
MAY-COMPANY -> ICC-COMPANY
Pocompany POCOMPANY Not Required
MAY-COMPANY -> PCY-COMPANY
|
