Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APPROCLEV


                             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    AP01.4    AP02.2    AP10.7    AP115     AP125
AP126     AP131     AP135     AP151     AP156     AP161
AP170     AP175     AP176     AP180     AP181     AP190
AP191     AP193     AP195     AP200     AP201     AP230
AP235     AP240     AP245     AP25.1    AP25.2    AP250
AP251     AP252     AP26.1    AP27.1    AP270     AP275
AP28.1    AP28.2    AP295     AP30.1    AP30.2    AP30.3
AP30.4    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    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    CB06.2    EE135     EE20.1
EE20.2    EE20.3    EE20.4    EE230     EE35.1    EE35.2
EE520     IC02.1    IC28.1    MA05.1    MA05.4    MA180
MA205     MA530     MA531     MA54.1    MA54.9    MA540
MA60.2    MA60.3    MA60.5    MA61.1    MA65.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    PO100     PO101     PO122
PO131     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO27.1    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO33.1
PO34.1    PO35.1    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     POI3.1    POIE.1    POII.1
POIJ.1    PR198     RQ01.1    RQ10.1    RQ10.2    RQ810
TX101     TX226     TX301     WH20.2    WH20.7    AP150
AP178     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
Element: 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
Element: 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
Element: Name          The process level name or description.

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

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

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

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

APR-CITY-ADDR5         Alpha 30  (Lower Case)                    AP00.5
Element: City or AddresThe city or fifth line of address
                       information for the process level.

APR-STATE-PROV         Alpha 2                                   AP00.5
Element: State or ProviThe state or province for the process
                       level address.

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

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

APR-COUNTRY            Alpha 30  (Lower Case)                    AP00.5
Element: 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
Element: 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
Element: 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
Element: Invoice AccruaThe 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
Element: 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
Element: 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
Element: 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
Element: Match Process Matching process level.

APR-DIST-CODE          Alpha 9                                   AP00.5
Element: Distribution CA 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  AP00.4
          PROC-LEVEL    level records for a specific company.    AP00.5  AP00.6
                                                                 AP01.4  AP02.2
                                                                 AP10.7  AP101
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP135   AP151
                                                                 AP156   AP161
                                                                 AP170   AP175
                                                                 AP176   AP180
                                                                 AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP200
                                                                 AP201   AP230
                                                                 AP235   AP240
                                                                 ...

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

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

APRSET4   HANDLING-CODE                                          AC42.1  AP125
          COMPANY                                                AP126   AP131
          PROC-LEVEL                                             AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AR48.3
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA05.1
                                                                 MA05.4  MA180
                                                                 MA205   MA530
                                                                 MA531   MA54.9
                                                                 ...

APRSET99  POSTAL-CODE
          PROC-LEVEL
          COMPANY

                         APPROCLEV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            APR-COMPANY       -> CPY-COMPANY  (CPYSET1)

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

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