Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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