|
|
MACOMPANY FILE
Matching Company
The Matching Company file contains matching and account information defined
at the company level.
REFERENCED BY
AP125 AP126 AP131 AP136 AP170 AP175
AP176 AP177 AP190 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.1 AP30.2
AP30.4 AP305 AP36.2 AP520 API1.1 API2.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
IC02.1 IC11.1 IC130 IC811 MA00.1 MA05.1
MA05.3 MA168 MA180 MA200 MA205 MA208
MA231 MA279 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
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 MA67.3 MA68.1
MA68.2 MA68.3 MA68.4 MA68.5 MA69.1 MA69.2
MA70.1 MA75.1 MA80.1 MA90.1 MA90.2 MA90.3
MA90.5 MA91.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO01.1 PO100 PO101
PO122 PO131 PO135 PO136 PO139 PO150
PO181 PO190 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO258 PO27.2 PO278
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO529 PO536 PO54.4
PO58.1 PO58.2 POED.1 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ13.2
RQ35.1 RQ500 RQIA.1 RQIB.1 RQIF.1 RQII.1
RQIJ.1 WH20.2 WH20.7
UPDATED BY
MA01.1 MA126 MA310 MA999
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAY-COMPANY Numeric 4 MA01.1
Element: Company The company number.
MAY-NAME Alpha 30 (Lower Case) MA01.1 MA540
Element: Name The location name or description.
MAY-MATCH-TABLE Alpha 10 MA01.1
Element: 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
Element: PO Accrual AccPO 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
Element: Acct Unit The item cost variance 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
Element: Account The item code variance account number.
MAY-VAR-SUB-ACCT Numeric 4 MA01.1
Element: Sub Acct The item cost variance account
subaccount number.
MAY-TOL-ACCT-UNIT Alpha 15 MA01.1
Tolerance Accouning Tolerance offset accounting unit.
Unit
MAY-TOL-ACCOUNT Numeric 6 MA01.1
Element: Tolerance AccoTolerance offset account number.
MAY-TOL-SUB-ACCT Numeric 4 MA01.1
Element: Tolerance SubaTolerance 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
Element: Acct Unit The receipt write-off accounting unit.
MAY-REC-ACCOUNT Numeric 6 MA01.1
Element: Account The receipt write-off account number.
MAY-REC-SUB-ACCT Numeric 4 MA01.1
Element: Sub Acct The receipt write-off subaccount number.
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
Element: Acct Unit The 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.
MAY-MWO-ACCOUNT Numeric 6 MA01.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
MAY-MWO-SUB-ACCT Numeric 4 MA01.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
MAY-MTCH-EXCESS-NR Numeric 1 MA01.1
Element: Mtch Exc Proc 1 = Matched no receipt
2 = Write off
MAY-MTCH-EXC-REC Numeric 1 MA01.1
Element: Mtch Exc Proc 1 = Matched no receipt
2 = Write off
MAY-DISC-TAKEN Alpha 1 MA01.1
Element: Discount TakenIndicates where a discount was taken.
Valid values are:
P = Payment
M = Match
MAY-CURR-SET-FLAG Alpha 1 MA01.1
Element: Curr 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
Element: 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
Element: Hold Insp FlagIf 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 18.2 MA01.1
Element: Intl Amt
MAY-VEN-CLAIM-TYPE Alpha 2 MA01.1 PO52.1
Element: Ven Claim TypeCB = Chargeback
CM = Credit Memo
N = None
MAY-CLAIM-HOLD-CD Alpha 4 MA01.1
Element: Hold Code The hold code.
MAY-CB-HOLD-CODE Alpha 4 MA01.1
Element: Hold Code The hold code.
MAY-REPLACE-GOODS Alpha 1 MA01.1
Element: Replace Goods Y = Yes
N = No
MAY-SHIP-OR-HOLD Alpha 1 MA01.1 PO52.1
Element: Ship Or Hold S = Ship
H = Hold
MAY-MATCH-CLASS Alpha 10 MA01.1
Element: Match Class A match class is a user-defined
matching key structure made up of
matching elements.
MAY-CURRENCY-CODE Alpha 5 MA01.1
Element: Currency Code The base currency defined for the
company in the Lawson General Ledger
system.
MAY-CURR-ND Numeric 1 MA01.1
Element: Acct Nd Represents the number of decimals
defined for the currency of the object.
MAY-ERS-LOC-CNTRL Alpha 1 MA01.1
Element: Ers Loc Cntrl Indicates whether the company controls
ERS by ship-to location.
N = No
Y = Yes
MAY-ERS-COST-UPD Alpha 1 MA01.1
Element: All Flag Indicates whether to update ERS costs.
N = No
Y = Yes
MAY-EDI-AUTO-REL Alpha 1 MA01.1
Element: EDI Auto ReleaIndicates whether the company
automatically releases EDI invoices.
N = No
Y = Yes
MAY-POOL-OPTION Numeric 1 MA01.1 MA310
Element: Au Flag 1 = Company Vendor
2 = Company Vendor PO
3 = Company Vendor PO Ship To
MAY-UNDER-TOL-FLAG Alpha 1 MA01.1
Element: Under Tol Flag
MAY-OVER-TOL-FLAG Alpha 1 MA01.1
Element: Over Tol Flag
MAY-ITEM-DIFF-FLAG Alpha 1
Element: Item Diff Flag
MAY-VALIDATE-PO Alpha 1 MA01.1 MA999
Element: Validate Po Y = Yes
N = No
MAY-REQUIRE-PO Alpha 1 MA01.1 MA999
Element: Require Po Y = Yes
N = No
MAY-PO-COST-MSG-FL Alpha 1 MA01.1 MA999
Element: Po Cost Msg Fl
MAY-PO-MATCH-RULE Alpha 10 MA01.1
Element: Match Rule
MAY-PO-ORDER Numeric 2 MA01.1
Element: Po Order
MAY-PO-COST-WF Alpha 1 MA01.1 MA999
Element: Po Cost Msg Fl
MAY-MATCH-RULE Alpha 10 MA01.1
Element: Match Rule
MAY-ORDER Numeric 2 MA01.1
Element: Order
MAY-RECON-MSG-WF Alpha 1 MA01.1 MA999
Element: Po Cost Msg Fl
MAY-NO-RCPT-DAYS Numeric 3 MA01.1
Element: No Rcpt Days
MAY-NO-RCPT-OPTION Alpha 1 MA01.1
Element: No Rcpt Option
MAY-DAYS-TO-WORK Numeric 3 MA01.1
Element: Days To Work
MAY-DAYS-TO-WRK-OP Alpha 1 MA01.1
Element: Days To Wrk Op
MAY-INVAL-INV-OPT Alpha 1
Element: Inval Inv Opt
MAY-WF-CALC-DATE Alpha 1 MA01.1
Element: Wf Calc Date
MAY-INV-FINRPT-IND Alpha 1 MA01.1 MA999
Element: Pull For Fr FlY = Yes
N = No
" " = No
MAY-RCT-FINRPT-IND Alpha 1 IC130 MA01.1
Element: Pull For Fr FlY = Yes MA999
N = No
" " = No
MAY-DRPSHP-MSG-FL Alpha 1 MA01.1 MA999
Element: Po Cost Msg Fl
MAY-DRPSHP-RULE Alpha 10 MA01.1
Element: Match Rule
MAY-DRPSHP-ORDER Numeric 2 MA01.1
Element: Po Order
MAY-DRPSHP-WF Alpha 1 MA01.1 MA999
Element: Po Cost Msg Fl
MAY-SRVC-MSG-FL Alpha 1 MA01.1 MA999
Element: Po Cost Msg Fl
MAY-SRVC-RULE Alpha 10 MA01.1
Element: Match Rule
MAY-SRVC-ORDER Numeric 2 MA01.1
Element: Po Order
MAY-SRVC-WF Alpha 1 MA01.1 MA999
Element: Po Cost Msg Fl
MAY-PRP-ACCT-UNIT Alpha 15 MA01.1
Element: Prp Acct Unit Accounting unit for the match prepayment
differences
MAY-PRP-ACCOUNT Numeric 6 MA01.1
Element: Prp Account Account for the match prepayment
differences
MAY-PRP-SUB-ACCT Numeric 4 MA01.1
Element: Prp Sub Acct
MAY-UBILL-ACCT-UNT Alpha 15 MA01.1
Element: Ubill Acct Unt
MAY-UBILL-ACCOUNT Numeric 6 MA01.1
Element: Ubill Account
MAY-UBILL-SUB-ACCT Numeric 4 MA01.1
Element: Ubill Sub Acct
MAY-AOCD-ACCT-UNIT Alpha 15 MA01.1
Element: Aocd Acct Unit
MAY-AOCD-ACCOUNT Numeric 6 MA01.1
Element: Aocd Account
MAY-AOCD-SUB-ACCT Numeric 4 MA01.1
Element: Aocd Sub Acct
MAY-IRA-ACCT-UNIT Alpha 15 MA01.1
Element: Ira Acct Unit Inventory 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.
MAY-IRA-ACCOUNT Numeric 6 MA01.1
Element: Ira Account Inventory 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.
MAY-IRA-SUB-ACCT Numeric 4 MA01.1
Element: Ira Sub Acct Inventory Receipts Archival subaccount.
MAY-SUMM-APDIST-FL Alpha 1 MA01.1
Element: Summary Flag This 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
MACOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAYSET1 COMPANY AP125 AP126
AP131 AP136
AP170 AP175
AP176 AP177
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 AP305
AP36.2 AP520
API1.1 API2.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
Mamtchrule MAMTCHRULE Required
MAY-MATCH-RULE -> MAU-MATCH-RULE
Pocompany POCOMPANY Not Required
MAY-COMPANY -> PCY-COMPANY
|
