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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.6    AP20.7    AP20.8    AP200
AP201     AP21.1    AP23.1    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.1    AP52.3    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    CB07.1    CXCP.1
EE135     EE20.1    EE20.2    EE20.3    EE20.4    EE230
EE35.1    EE35.2    EE520     ET09.1    ET09.2    IC02.1
MA05.1    MA05.4    MA180     MA205     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.7
MA530     MA531     MA54.1    MA54.2    MA54.9    MA540
MA60.2    MA60.3    MA60.5    MA61.1    MA65.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     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.1
PO27.2    PO29.1    PO295     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
POCP.1    POI3.1    POID.1    POII.1    POIJ.1    PR198
RQ01.1    RQ10.1    RQ10.2    RQ12.1    RQ13.1    RQ13.2
RQ35.1    RQ500     RQ810     RQIF.1    TX101     TX226
TX301     WH130     WH132     WH190     WH20.2    WH20.7
WH222     WH30.1    WH30.2    WH30.3    WH30.4    WH31.1
WH31.2    WH31.3    WH31.4    WH32.1    WH32.2    WH32.3
WH32.4    WH33.1    WH33.2    WH33.3    WH33.4    WH33.5
WH33.6    WH33.8    WH33.9    WH34.1    WH34.2    WH34.3
WH34.4    WH40.1    WH40.2    WH520     WH830     CB186
CB187     CB286     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 18  (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        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: Dist 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                                                AC42.1  AP00.4
          PROC-LEVEL                                             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   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 ...

APRSET2   PROC-LEVEL    KeyChange                                AP230   AP250
          COMPANY                                                AP251   CB186
                                                                 CB187   CB286
                                                                 MA540

APRSET3   PAY-GROUP     KeyChange                                AP150   AP151
          PROC-LEVEL                                             AP178   AP230
          COMPANY                                                AP250   AP251
                                                                 AP265   AP40.1
                                                                 AP56.2

APRSET4   HANDLING-CODE                                          AC42.1  AP125
          COMPANY                                                AP126   AP131
          PROC-LEVEL                                             AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 AR48.3  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 ...

                         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