Lawson Insight Technical Documentation


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

AP01.4    AP02.2    AP10.7    AP125     AP126     AP135
AP150     AP151     AP156     AP170     AP175     AP180
AP181     AP190     AP191     AP193     AP195     AP20.1
AP20.2    AP20.5    AP20.6    AP20.7    AP20.8    AP200
AP201     AP225     AP226     AP23.1    AP230     AP240
AP245     AP25.1    AP25.2    AP250     AP26.1    AP270
AP275     AP28.1    AP28.2    AP30.1    AP30.2    AP30.3
AP30.4    AP32.2    AP35.1    AP45.2    AP520     AP56.1
AP56.2    AP80.1    AP90.1    AP90.2    AP90.5    AP92.3
AP92.4    AP95.2    AP95.3    AP954     BL92.1    CB06.2
EE135     EE20.1    EE20.2    EE20.3    EE20.4    EE230
EE35.1    EE35.2    EE520     IN20.1    MA05.1    MA40.1
MA40.2    MA41.1    MA41.2    MA41.4    MA41.5    MA41.6
MA43.1    MA43.2    MA43.3    MA43.4    MA52.1    MA520
MA530     MA540     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     OE113     OE114     OE129
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    OE510     OE810     OE920     PO20.1    PO22.2
PO22.3    PO25.1    PO31.1    PO820     PR199     RQ20.1
RQ20.3    RQ20.4    WH20.2    WH20.7    AP265     AP40.1

UPDATED BY

AP00.7    AP00.4    AP101     AP305     AP956

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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


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

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


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


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


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


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


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


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


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


APR-ACCR-CODE        Alpha 4                                     AP00.7  AP956
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.7  AP956
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.7  AP956
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.7  AP956
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.7  AP101
Pay Group            The pay group assigned to the process       AP956
                     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.7  AP956
Default Process      Indicates whether this is the default
Level                process level for the company. A company
                     can have only one default process level.


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


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


APR-DIST-CODE        Alpha 9                                     AP00.7
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     AP00.4  AP00.7
          PROC-LEVEL    level records for a specific company.    AP00.8  AP01.4
                                                                 AP02.2  AP10.7
                                                                 AP101   AP125
                                                                 AP126   AP135
                                                                 AP150   AP151
                                                                 AP156   AP170
                                                                 AP175   AP180
                                                                 AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP20.8  AP200
                                                                 AP201   AP225
                                                                 ...

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

                        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
                        group.                                   AP265   AP40.1
                                                                 AP56.2
                        KeyChange, Duplicates

                         APPROCLEV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            APR-COMPANY    -> CPY-COMPANY