MACOMPANY

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
AP232 AP25.1 AP25.2 AP26.1 AP27.1 AP30.1
AP30.2 AP30.4 AP305 AP36.2 AP510 AP520
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC02.1 IC10.2 IC11.1 IC12.1 IC130
IC131 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC811
IC83.1 MA00.1 MA00.4 MA05.1 MA05.3 MA168
MA180 MA189 MA200 MA205 MA208 MA231
MA237 MA26.1 MA264 MA278 MA279 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 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 MA64.9
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 MA730 MA75.1 MA80.1
MA90.1 MA90.2 MA90.3 MA90.5 MA90.6 MA91.1
MAED.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO01.1 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO135 PO136 PO139
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO181
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO22.5 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO258 PO26.3
PO26.4 PO26.5 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO278 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
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 PO54.5 PO58.1 PO58.2 POCP.1
POED.1 POI3.1 POID.1 POII.1 POIJ.1 MM280
MM80.1 MM80.2 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIA.1 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830


UPDATED BY
MA01.1 MA126 MA310 MA999

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAY-COMPANY
Element: Company
Numeric 4
The company number.
MA01.1
MAY-NAME
Element: Name
Alpha 30 (Lower Case)
The location name or description.
MA01.1 MA540
MAY-MATCH-TABLE
Element: Match Table
Alpha 10
Match table. Contains matching and match processing rules.
MA01.1
MAY-ACC-ACCT-UNIT
PO Accrual
Accounting Unit
Alpha 15
PO 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
Element: PO Accrual Account
Numeric 6
PO accrual account number.
MA01.1
MAY-ACC-SUB-ACCT
PO Accrual
Subaccount
Numeric 4
PO accrual subaccount number.
MA01.1
MAY-VAR-ACCT-UNIT
Element: Acct Unit
Alpha 15
The 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
Element: Account
Numeric 6
The item code variance account number.
MA01.1
MAY-VAR-SUB-ACCT
Element: Sub Acct
Numeric 4
The item cost variance account subaccount number.
MA01.1
MAY-TOL-ACCT-UNIT
Tolerance Accouning
Unit
Alpha 15
Tolerance offset accounting unit.
MA01.1
MAY-TOL-ACCOUNT
Element: Tolerance Account
Numeric 6
Tolerance offset account number.
MA01.1
MAY-TOL-SUB-ACCT
Element: Tolerance Subaccount
Numeric 4
Tolerance offset subaccount number.
MA01.1
MAY-DACC-ACCT-UNIT
Discount Accrual
Acct Unit
Alpha 15
Discount accrual accounting unit.
MA01.1
MAY-DACC-ACCOUNT
Discount Accrual
Account
Numeric 6
Discount accrual account number.
MA01.1
MAY-DACC-SUB-ACCT
Discount Accrual
Subaccount
Numeric 4
Discount accrual subaccount number.
MA01.1
MAY-REC-ACCT-UNIT
Element: Acct Unit
Alpha 15
The receipt write-off accounting unit.
MA01.1
MAY-REC-ACCOUNT
Element: Account
Numeric 6
The receipt write-off account number.
MA01.1
MAY-REC-SUB-ACCT
Element: Sub Acct
Numeric 4
The receipt write-off subaccount number.
MA01.1
MAY-MNR-ACCT-UNIT
Matched w/o Receipt
Acct Unit
Alpha 15
The accounting unit for invoice that match without receipts.
MA01.1
MAY-MNR-ACCOUNT
Matched w/o Receipt
Account
Numeric 6
The account for invoices that match without receipts.
MA01.1
MAY-MNR-SUB-ACCT
Matched w/o Receipt
Subaccount
Numeric 4
The subaccount for invoices that match without receipts.
MA01.1
MAY-MWO-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
MA01.1
MAY-MWO-ACCOUNT
Element: Account
Numeric 6
This 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
Element: Sub Acct
Numeric 4
This 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
Element: Mtch Exc Proc
Numeric 1

1 = Matched no receipt
2 = Write off
MA01.1
MAY-MTCH-EXC-REC
Element: Mtch Exc Proc
Numeric 1

1 = Matched no receipt
2 = Write off
MA01.1
MAY-DISC-TAKEN
Element: Discount Taken
Alpha 1
Indicates where a discount was taken. Valid values are:
P = Payment
M = Match
MA01.1
MAY-CURR-SET-FLAG
Element: Curr Set Flag
Alpha 1
Flag 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
Element: Handling Code
Alpha 4
Invoice 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
Element: Hold Insp Flag
Alpha 1
If 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
Element: Intl Amt
Signed 18.2
MA01.1
MAY-VEN-CLAIM-TYPE
Element: Ven Claim Type
Alpha 2

CB = Chargeback
CM = Credit Memo
N = None
MA01.1 PO52.1
MAY-CLAIM-HOLD-CD
Element: Hold Code
Alpha 4
The hold code.
MA01.1
MAY-CB-HOLD-CODE
Element: Hold Code
Alpha 4
The hold code.
MA01.1
MAY-REPLACE-GOODS
Element: Replace Goods
Alpha 1

Y = Yes
N = No
MA01.1
MAY-SHIP-OR-HOLD
Element: Ship Or Hold
Alpha 1

S = Ship
H = Hold
MA01.1 PO52.1
MAY-MATCH-CLASS
Element: Match Class
Alpha 10
A match class is a user-defined matching key structure made up of matching elements.
MA01.1
MAY-CURRENCY-CODE
Element: Currency Code
Alpha 5
The base currency defined for the company in the Lawson General Ledger system.
MA01.1
MAY-CURR-ND
Element: Acct Nd
Numeric 1
Represents the number of decimals defined for the currency of the object.
MA01.1
MAY-ERS-LOC-CNTRL
Element: Ers Loc Cntrl
Alpha 1
Indicates whether the company controls ERS by ship-to location.
N = No
Y = Yes
MA01.1
MAY-ERS-COST-UPD
Element: All Flag
Alpha 1
Indicates whether to update ERS costs.
N = No
Y = Yes
MA01.1
MAY-EDI-AUTO-REL
Element: EDI Auto Release
Alpha 1
Indicates whether the company automatically releases EDI invoices.
N = No
Y = Yes
MA01.1
MAY-POOL-OPTION
Element: Au Flag
Numeric 1

1 = Company Vendor
2 = Company Vendor PO
3 = Company Vendor PO Ship To
MA01.1 MA310
MAY-UNDER-TOL-FLAG
Element: Under Tol Flag
Alpha 1
MA01.1
MAY-OVER-TOL-FLAG
Element: Over Tol Flag
Alpha 1
MA01.1
MAY-ITEM-DIFF-FLAG
Element: Item Diff Flag
Alpha 1
MAY-VALIDATE-PO
Element: Validate Po
Alpha 1

Y = Yes
N = No
MA01.1 MA999
MAY-REQUIRE-PO
Element: Require Po
Alpha 1

Y = Yes
N = No
MA01.1 MA999
MAY-PO-COST-MSG-FL
Element: Po Cost Msg Fl
Alpha 1
MA01.1 MA999
MAY-PO-MATCH-RULE
Element: Match Rule
Alpha 10
MA01.1
MAY-PO-ORDER
Element: Po Order
Numeric 2
MA01.1
MAY-PO-COST-WF
Element: Po Cost Msg Fl
Alpha 1
MA01.1 MA999
MAY-MATCH-RULE
Element: Match Rule
Alpha 10
MA01.1
MAY-ORDER
Element: Order
Numeric 2
MA01.1
MAY-RECON-MSG-WF
Element: Po Cost Msg Fl
Alpha 1
MA01.1 MA999
MAY-NO-RCPT-DAYS
Element: No Rcpt Days
Numeric 3
MA01.1
MAY-NO-RCPT-OPTION
Element: No Rcpt Option
Alpha 1
MA01.1
MAY-DAYS-TO-WORK
Element: Days To Work
Numeric 3
MA01.1
MAY-DAYS-TO-WRK-OP
Element: Days To Wrk Op
Alpha 1
MA01.1
MAY-INVAL-INV-OPT
Element: Inval Inv Opt
Alpha 1
MAY-WF-CALC-DATE
Element: Wf Calc Date
Alpha 1
MA01.1
MAY-INV-FINRPT-IND
Element: Pull For Fr Fl
Alpha 1

Y = Yes
N = No
" " = No
MA01.1 MA999
MAY-RCT-FINRPT-IND
Element: Pull For Fr Fl
Alpha 1

Y = Yes
N = No
" " = No
IC130 MA01.1
MA999
MAY-DRPSHP-MSG-FL
Element: Po Cost Msg Fl
Alpha 1
MA999
MAY-DRPSHP-RULE
Element: Match Rule
Alpha 10
MAY-DRPSHP-ORDER
Element: Po Order
Numeric 2
MAY-DRPSHP-WF
Element: Po Cost Msg Fl
Alpha 1
MA999
MAY-SRVC-MSG-FL
Element: Po Cost Msg Fl
Alpha 1
MA01.1 MA999
MAY-SRVC-RULE
Element: Match Rule
Alpha 10
MA01.1
MAY-SRVC-ORDER
Element: Po Order
Numeric 2
MA01.1
MAY-SRVC-WF
Element: Po Cost Msg Fl
Alpha 1
MA01.1 MA999
MAY-PRP-ACCT-UNIT
Element: Prp Acct Unit
Alpha 15
Accounting unit for the match prepayment differences
MA01.1
MAY-PRP-ACCOUNT
Element: Prp Account
Numeric 6
Account for the match prepayment differences
MA01.1
MAY-PRP-SUB-ACCT
Element: Prp Sub Acct
Numeric 4
MA01.1
MAY-UBILL-ACCT-UNT
Element: Ubill Acct Unt
Alpha 15
MA01.1
MAY-UBILL-ACCOUNT
Element: Ubill Account
Numeric 6
MA01.1
MAY-UBILL-SUB-ACCT
Element: Ubill Sub Acct
Numeric 4
MA01.1
MAY-AOCD-ACCT-UNIT
Element: Aocd Acct Unit
Alpha 15
MA01.1
MAY-AOCD-ACCOUNT
Element: Aocd Account
Numeric 6
MA01.1
MAY-AOCD-SUB-ACCT
Element: Aocd Sub Acct
Numeric 4
MA01.1
MAY-IRA-ACCT-UNIT
Element: Ira Acct Unit
Alpha 15
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.
MA01.1
MAY-IRA-ACCOUNT
Element: Ira Account
Numeric 6
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.
MA01.1
MAY-IRA-SUB-ACCT
Element: Ira Sub Acct
Numeric 4
Inventory Receipts Archival subaccount.
MA01.1
MAY-SUMM-APDIST-FL
Element: Summary Flag
Alpha 1
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
MA01.1
MAY-OPEN-ZERO-COST
Element: All Flag
Alpha 1
Use 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


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
AP232 AP25.1
AP25.2 AP26.1
AP27.1 AP30.1
AP30.2 AP30.4
AP305 AP36.2
AP510 AP520
MAYSET2 HANDLING-CODE
COMPANY
MA05.1 MA05.3
MA205


MACOMPANY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Not Required
MAY-COMPANY->ICC-COMPANY
Mamatchtbl MAMATCHTBL Required
MAY-MATCH-TABLE->MAM-MATCH-TABLE
Mamtchrule MAMTCHRULE Required
MAY-MATCH-RULE->MAU-MATCH-RULE
Pocompany POCOMPANY Not Required
MAY-COMPANY->PCY-COMPANY


File created: Thu Jun 09 02:22:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.