Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROCLEV


                              PROCLEV FILE

                         Matching Process Level

The Process Level file contains matching account information for a process
level. These accounts are assigned in MA01.2 (Process Level).

REFERENCED BY

AP125     AP126     AP131     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.4    API1.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MA180     MA200     MA41.1    MA41.2    MA41.4    MA41.7
MA43.1    MA43.2    MA43.3    MA43.7    MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO135     PO136     PO139     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
PO27.2    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     PO536     POI3.1
POID.1    POII.1    POIJ.1    RQ10.1    RQ10.2    WH20.2
WH20.7

UPDATED BY

MAPL.1    MA01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MAZ-COMPANY            Numeric 4                                 MAPL.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

MAZ-PROC-LEVEL         Alpha 5                                   MAPL.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

MAZ-NAME               Alpha 30  (Lower Case)                    MAPL.1
Element: Name          Displays the company description.

MAZ-ACC-ACCT-UNIT      Alpha 15                                  MAPL.1
PO Accrual             PO accrual accounting unit.
Accounting Unit        Used as a suspense account for invoiced
                       items and as a posting account for
                       received not invoiced report.

MAZ-ACC-ACCOUNT        Numeric 6                                 MAPL.1
Element: PO Accrual AccPO accrual account number.

MAZ-ACC-SUB-ACCT       Numeric 4                                 MAPL.1
PO Accrual             PO accrual subaccount number.
Subaccount

MAZ-VAR-ACCT-UNIT      Alpha 15                                  MA66.2  MAPL.1
Inv Cost Var           The invoice cost variance account
Accounting Unit        accounting unit. Used as a posting
                       account for cost differences between the
                       PO and the receipt.

MAZ-VAR-ACCOUNT        Numeric 6                                 MA66.2  MAPL.1
Invoice Cost           The invoice cost variance account
Variance Account       number.

MAZ-VAR-SUB-ACCT       Numeric 4                                 MA66.2  MAPL.1
Invoice Cost Var       The invoice cost variance account
Subaccount             subaccount number.

MAZ-TOL-ACCT-UNIT      Alpha 15                                  MAPL.1
Tolerance              Tolerance offset accounting unit. The
Accounting Unit        tolerance account is used for posting
                       quantity and cost differences when
                       performing an invoice match.

MAZ-TOL-ACCOUNT        Numeric 6                                 MAPL.1
Element: Tolerance AccoTolerance offset account number.

MAZ-TOL-SUB-ACCT       Numeric 4                                 MAPL.1
Element: Tolerance SubaTolerance offset subaccount number.

MAZ-REC-ACCT-UNIT      Alpha 15                                  MAPL.1
Element: Acct Unit     The receipt write-off general ledger
                       accounting unit. This is the account
                       that will be posted to when archiving
                       receipts from the system.

MAZ-REC-ACCOUNT        Numeric 6                                 MAPL.1
Element: Account       The receipt write-off general ledger
                       account number.

MAZ-REC-SUB-ACCT       Numeric 4                                 MAPL.1
Element: Sub Acct      The receipt write-off general ledger
                       subaccount number.

MAZ-MNR-ACCT-UNIT      Alpha 15                                  MAPL.1
Matched w/o Receipt    The accounting unit for invoices that
Acct Unit              match without receipts.

MAZ-MNR-ACCOUNT        Numeric 6                                 MAPL.1
Matched w/o Receipt    The account for invoices that match
Account                without receipts.

MAZ-MNR-SUB-ACCT       Numeric 4                                 MAPL.1
Matched w/o Receipt    The subaccount for invoices that match
Subaccount             without receipts.

MAZ-MWO-ACCT-UNIT      Alpha 15                                  MAPL.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.


MAZ-MWO-ACCOUNT        Numeric 6                                 MAPL.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.

MAZ-MWO-SUB-ACCT       Numeric 4                                 MAPL.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.

MAZ-UBILL-ACCT-UNT     Alpha 15                                  MAPL.1
Element: Ubill Acct Unt

MAZ-UBILL-ACCOUNT      Numeric 6                                 MAPL.1
Element: Ubill Account

MAZ-UBILL-SUB-ACCT     Numeric 4                                 MAPL.1
Element: Ubill Sub Acct

MAZ-AOCD-ACCT-UNIT     Alpha 15                                  MAPL.1
Element: Aocd Acct Unit

MAZ-AOCD-ACCOUNT       Numeric 6                                 MAPL.1
Element: Aocd Account

MAZ-AOCD-SUB-ACCT      Numeric 4                                 MAPL.1
Element: Aocd Sub Acct

MAZ-IRA-ACCT-UNIT      Alpha 15                                  MAPL.1
Element: Ira Acct Unit Inventory Receipts Archival accounting
                       unit. This is used by the purchasing
                       archival program for inventory item
                       invoices where the receiving was
                       missing. It is reconciled by a physical
                       inventory.

MAZ-IRA-ACCOUNT        Numeric 6                                 MAPL.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.

MAZ-IRA-SUB-ACCT       Numeric 4                                 MAPL.1
Element: Ira Sub Acct  Inventory Receipts Archival sub account.

                         PROCLEV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAZSET1   COMPANY                                                AP125   AP126
          PROC-LEVEL                                             AP131   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.4  API1.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...