MACOMPANY FILE
Matching Company
The Matching Company file contains matching and account information defined
at the company level.
REFERENCED BY
AP130 AP170 AP176 AP190 AP220 AP252
AP260 AP30.2 AP30.4 AP305 API1.1 API2.1
DR100 IC02.1 IC10.2 IC11.1 IC141 IC142
IC811 IC83.1 MA05.1 MA05.3 MA126 MA200
MA205 MA208 MA231 MA53.1 MA53.2 MA53.3
MA54.8 MA62.6 MA63.1 MA65.1 MA66.1 PO01.1
PO135 PO136 PO181 PO529 PO85.1 POED.1
POIJ.1 RQ11.1
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-INV-RECON-DAYS Numeric 3 AP252 MA01.1
Invoice Invoice reconciliation days. Determines
Reconciliation Days the average number of days it takes an
invoice to be worked in reconciliation.
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
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
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-OVER-COST-AMT Signed 15.2 MA01.1
Over Cost Amt
MAY-OVER-COST-COND Alpha 3 MA01.1
Over Cost Cond
MAY-OVER-COST-PCT Percent 7.5 (Percent) MA01.1
Over Cost Pct
MAY-UNDER-COST-AMT Signed 15.2 MA01.1
Under Cost Amt
MAY-UNDER-COST-CON Alpha 3 MA01.1
Under Cost Con
MAY-UNDER-COST-PCT Percent 7.5 (Percent) MA01.1
Under Cost Pct
MAY-COST-OPEN-MSG Alpha 1 MA01.1
Cost Open Msg
MAY-COST-CLO-MSG Alpha 1 MA01.1
Cost Clo Msg
MAY-COST-REASON-CD Alpha 4 MA01.1
Cost Reason Cd
MAY-QTY-OPEN-MSG Alpha 1 MA01.1
Qty Open Msg
MAY-QTY-CLO-MSG Alpha 1 MA01.1
Qty Clo Msg
MAY-QTY-REASON-CD Alpha 4 MA01.1
Qty Reason Cd
MAY-OVER-QTY-AMT Signed 15.2 MA01.1
Over Qty Amt
MAY-OVER-QTY-COND Alpha 3 MA01.1
Over Qty Cond
MAY-OVER-QTY-PCT Percent 7.5 (Percent) MA01.1
Over Qty Pct
MAY-UNDER-QTY-AMT Signed 15.2 MA01.1
Under Qty Amt
MAY-UNDER-QTY-COND Alpha 3 MA01.1
Under Qty Cond
MAY-UNDER-QTY-PCT Percent 7.5 (Percent) MA01.1
Under Qty Pct
MACOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAYSET1 COMPANY AP130 AP170
AP176 AP190
AP220 AP252
AP260 AP30.2
AP30.4 AP305
API1.1 API2.1
DR100 IC02.1
IC10.2 IC11.1
IC141 IC142
IC811 IC83.1
MA01.1 MA05.1
MA126 MA200
MA205 MA208
MA231 MA310
MA53.1 MA53.2
...
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
|
