|
|
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 AP220 AP25.1 AP25.2 AP26.1
AP260 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 DR100 IC02.1
IC10.2 IC11.1 IC130 IC131 IC141 IC142
IC28.1 IC811 IC83.1 MA00.1 MA05.1 MA05.3
MA126 MA180 MA200 MA205 MA208 MA231
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 MA75.1
MA80.1 MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 PO01.1 PO100
PO101 PO122 PO131 PO135 PO136 PO150
PO181 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO529 PO536 PO54.4 POED.1 POI3.1
POIE.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 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: Accounting UniThe 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: Subaccount 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: Accounting UniThe 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: Subaccount 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: Accounting Unit
MAY-MWO-ACCOUNT Numeric 6 MA01.1
Element: Account
MAY-MWO-SUB-ACCT Numeric 4 MA01.1
Element: Subaccount
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: Currency Set FFlag 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
MAY-CB-HOLD-CODE Alpha 4 MA01.1
Element: 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
Account Currency Represents the number of decimals
Code defined for the currency of the object.
MAY-ERS-LOC-CNTRL Alpha 1 MA01.1
Element: ERS Location CIndicates 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 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 MA999
Element: Po Cost Msg Fl
MAY-NO-RCPT-DAYS Numeric 3
Element: No Rcpt Days
MAY-NO-RCPT-OPTION Alpha 1
Element: No Rcpt Option
MAY-DAYS-TO-WORK Numeric 3
Element: Days To Work
MAY-DAYS-TO-WRK-OP Alpha 1
Element: Days To Wrk Op
MAY-INVAL-INV-OPT Alpha 1
Element: Inval Inv Opt
MAY-WF-CALC-DATE Alpha 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 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 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
Element: Ubill Acct Unt
MAY-UBILL-ACCOUNT Numeric 6
Element: Ubill Account
MAY-UBILL-SUB-ACCT Numeric 4
Element: Ubill Sub Acct
MAY-AOCD-ACCT-UNIT Alpha 15
Element: Aocd Acct Unit
MAY-AOCD-ACCOUNT Numeric 6
Element: Aocd Account
MAY-AOCD-SUB-ACCT Numeric 4
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 sub account.
MACOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAYSET1 COMPANY AP125 AP126
AP131 AP170
AP175 AP176
AP177 AP190
AP220 AP25.1
AP25.2 AP26.1
AP260 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
...
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
|
