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 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 MA208
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA54.8 MA540
MAED.1 MAI1.1 PO01.1 PO136 PO190 PO300
PO520 POCP.1 POED.1 POI3.1 POII.1 POIJ.1
MM280


UPDATED BY
AP177 MA05.1 MA05.3 MA205

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

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

1 = Matched no receipt
2 = Write off
MAY-DISC-TAKEN
Element: Discount Taken
Alpha 1
Indicates where a discount was taken. Valid values are:
P = Payment
M = Match
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
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.
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
MAY-WRITE-OFF-AMT
Element: Intl Amt
Signed 18.2
MAY-VEN-CLAIM-TYPE
Element: Ven Claim Type
Alpha 2

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

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

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

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

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

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

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

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


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
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
Mamtchrule MAMTCHRULE Required
MAY-MATCH-RULE->MAU-MATCH-RULE
Pocompany POCOMPANY Not Required
MAY-COMPANY->PCY-COMPANY


File created: Wed Jun 08 20:50:08 2016

Home
Contact Us



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