Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             APPROCLEV FILE

                     Accounts Payable Process Level

The Accounts Payable Process Level file contains records for each process
level defined for a company in the Lawson Accounts Payable system. A company
that has Yes selected in the Process Levels Required field must have at least
one process level defined. Companies that have No selected in the Process
Levels Required field cannot define or use process levels.

Process levels can be used to default accounts used for posting transactions,
break and subtotal reports, and process payments.

REFERENCED BY

AC42.1    AC59.1    AP01.4    AP02.2    AP10.7    AP115
AP135     AP150     AP151     AP156     AP170     AP175
AP176     AP180     AP181     AP190     AP191     AP193
AP195     AP200     AP201     AP230     AP240     AP245
AP250     AP251     AP252     AP270     AP275     AP28.1
AP28.2    AP30.1    AP30.2    AP30.3    AP30.4    AP32.2
AP35.1    AP45.2    AP52.7    AP520     AP56.1    AP56.2
AP80.1    AP90.1    AP90.2    AP90.5    AP92.3    AP92.4
AP93.3    AP93.4    AP95.2    AP95.3    AP96.1    API1.1
API2.1    AR48.3    CB06.2    EE135     EE20.1    EE20.2
EE20.3    EE20.4    EE230     EE35.1    EE35.2    EE520
IC02.1    MA05.1    MA05.4    MA205     MA54.1    MA54.9
MA65.1    POIJ.1    PR198     RQ01.1    AP265     AP40.1

UPDATED BY

AP00.5    AP00.4    AP101     AP305

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

APR-COMPANY          Numeric 4                                   AP00.5  AP193
Company              The company number. Must be a valid
                     accounts payable company with Yes
                     selected in the Process Levels Required
                     field.

APR-PROC-LEVEL       Alpha 5                                     AP00.5  AP193
Process Level        A user-defined code representing a
                     reporting and processing level in the
                     accounts payable company.

APR-NAME             Alpha 30  (Lower Case)                      AP00.5  AP135
Name                 The process level name or description.

APR-ADDR1            Alpha 30  (Lower Case)                      AP00.5
Address 1            The first line of address information
                     for the process level.

APR-ADDR2            Alpha 30  (Lower Case)                      AP00.5
Address 2            The second line of address information
                     for the process level.

APR-ADDR3            Alpha 30  (Lower Case)                      AP00.5
Address 3            The third line of address information
                     for the process level.

APR-ADDR4            Alpha 30  (Lower Case)                      AP00.5
Address 4            The fourth line of address information
                     for the process level.

APR-CITY-ADDR5       Alpha 18  (Lower Case)                      AP00.5
City or Address 5    The city or fifth line of address
                     information for the process level.

APR-STATE-PROV       Alpha 2                                     AP00.5
State or Province    The state or province for the process
                     level address.

APR-POSTAL-CODE      Alpha 10  (Lower Case)                      AP00.5
Postal Code          The postal code for the process level
                     address.

APR-COUNTY           Alpha 25  (Lower Case)                      AP00.5
County               The county for the company address.

APR-COUNTRY          Alpha 30  (Lower Case)                      AP00.5
Country              The country for the process level
                     address. Can also be used for additional
                     information such as attention name.

APR-REGION           Alpha 2                                     AP00.5
Region Code          The region code, if applicable for the
                     country. Used by Intrastat. Must be
                     defined in IN02.1 (Region Maintenance)


APR-COUNTRY-CODE     Alpha 2                                     AP00.5
Country Code         The country code.  Required for VAT and
                     intrastat reporting.  Must be defined in
                      IN01.1 (Country Maintenance).


APR-ACCR-CODE        Alpha 4                                     AP00.5
Invoice Accrual Code The invoice accrual code assigned to
                     the process level. Used to default a
                     general ledger accrual account to an
                     invoice during invoice entry. Must be a
                     valid record in the Invoice Accrual Code
                     file. If left blank, the process level
                     uses the invoice accrual code assigned
                     to the company.

APR-CASH-CODE        Alpha 4                                     AP00.5
Cash Code            The cash code assigned to the process
                     level. Represents a bank account. Must
                     be a valid record in the Cash Code file.
                     If left blank, the cash code assigned to
                     the company, if assigned, or the pay
                     group defaults on invoices entered for
                     the process level.

APR-INC-ACCR-CODE    Alpha 10                                    AP00.5
Income Withholding   The income withholding code assigned to
Code                 the process level. Used to default an
                     income withholding accrual account to an
                     invoice during entry to track reportable
                     withholding for a vendor. Must be a
                     valid record in the Income Withholding
                     Code file. If left blank, the process
                     level uses the income withholding code
                     assigned to the company.

APR-DISCOUNT-CODE    Alpha 10                                    AP00.5
Discount Code        The discount code assigned to the
                     process level. Used to default a general
                     discount account to an invoice during
                     entry. Must be a valid record in the
                     Discount Code file. If left blank, the
                     process level uses the discount code
                     assigned to the company.

APR-PAY-GROUP        Alpha 4                                     AP00.5  AP101
Pay Group            The pay group assigned to the process
                     level. A pay group is used for
                     processing accounts payable payments. A
                     pay group lets you create a single
                     payment for a vendor to pay invoices
                     received by all company process levels
                     assigned to the pay group. Must be a
                     valid record in the Pay Group file. If
                     left blank, the process level uses the
                     pay group assigned to the company.

APR-DEF-PROC-LEVEL   Alpha 1                                     AP00.5
Default Process      Indicates whether this is the default
Level                process level for the company. A company
                     can have only one default process level.
                     Y = Yes
                     N = No

APR-HANDLING-CODE    Alpha 4                                     AP00.5
Invoice Handling     Handling code. Contains processing
Code                 rules for invoice matching.

APR-MATCH-PROC-LEV   Alpha 1                                     AP00.5
Match Process Level  Matching process level.

APR-DIST-CODE        Alpha 9                                     AP00.5
Distribution Code    A user-defined code used to
                     automatically create expense
                     distributions or expense distribution
                     "shells" for invoices or to split an
                     invoice distribution into multiple
                     distributions.

                         APPROCLEV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APRSET1   COMPANY       This index is used to access process     AC42.1  AC59.1
          PROC-LEVEL    level records for a specific company.    AP00.4  AP00.5
                                                                 AP00.6  AP01.4
                                                                 AP02.2  AP10.7
                                                                 AP101   AP115
                                                                 AP135   AP150
                                                                 AP151   AP156
                                                                 AP170   AP175
                                                                 AP176   AP180
                                                                 AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP200
                                                                 AP201   AP230
                                                                 AP240   AP245
                                                                 AP250   AP251
                                                                 ...

APRSET2   PROC-LEVEL    This index is used to validate whether   AP230   AP250
          COMPANY       a process level exists.                  AP251
                        KeyChange

APRSET3   PAY-GROUP     This index is used to verify or access   AP150   AP151
          PROC-LEVEL    process level records for a specific pay AP230   AP250
          COMPANY       group.                                   AP251   AP265
                        KeyChange                                AP40.1  AP56.2

APRSET4   HANDLING-CODE                                          AC42.1  AC59.1
          COMPANY                                                AR48.3  MA05.1
          PROC-LEVEL                                             MA05.4  MA205
                                                                 MA54.9  MA65.1
                                                                 POIJ.1  PR198

                         APPROCLEV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            APR-COMPANY       -> CPY-COMPANY

Maproclev      PROCLEV      Not Required, Delete Cascades
                            Valid When APR-MATCH-PROC-LEV = "Y"

                            APR-COMPANY       -> MAZ-COMPANY
                            APR-PROC-LEVEL    -> MAZ-PROC-LEVEL