Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARPROCLEVL


                            ARPROCLEVL FILE

                            AR Process Level

The AR Process Level file contains all valid process levels within each
company. There is a requirement that at least one process level be established
for each company.  Process levels contain default GL accounts, and are used
as sort and select options. Each original transaction (credit memo, debit
memo, invoice and payment) that is entered, requires a process level to be
specified.

REFERENCED BY

AR01.1    AR03.1    AR10.2    AR132     AR137     AR15.7
AR150     AR190     AR194     AR201     AR203     AR21.1
AR21.2    AR21.3    AR214     AR222     AR223     AR227
AR228     AR232     AR233     AR234     AR235     AR237
AR238     AR239     AR242     AR251     AR252     AR253
AR258     AR271     AR28.8    AR29.2    AR293     AR294
AR296     AR300     AR35.1    AR35.2    AR36.1    AR38.1
AR38.2    AR38.3    AR43.1    AR50.1    AR560     AR72.2
AR82.1    AR90.2    ARLL.1    BL220     DT150     DT155
DT160     DT161     DT165     DT166     DT180     DT181
DT185     DT30.1    DT30.2    DT40.1    DT45.1    DT52.1
DT520     DT60.1    DT60.2    DT70.1    DT70.3    DT80.1
DT85.1    DT85.2    DT90.1    DT92.1

UPDATED BY

AC56.1    AC560     AR02.1    AR115     AR129     AR130
AR131     AR135     AR14.1    AR20.1    AR30.1    AR30.8
AR32.1    AR33.1    AR33.3    AR33.6    AR34.1    AR39.1
AR39.2    AR42.1    AR44.3    AR48.1    AR48.2    AR48.3
AR502     AR503     AR570     AR575     AR580     BL00.1
BL01.1    BL05.1    BL120     BL122     BL123     BL125
BL130     BL20.1    BL20.3    BL204     BL21.2    BL21.5
BL29.1    BL29.2    BL291     BL47.1    BL520     BL820
BL85.1    BL85.2    BL85.3    BL90.1    BL92.1    BR02.3
BR10.1    BR10.9    BR11.1    BR120     BR121     BR122
BR123     BR131     BR140     BR145     BR151     BR152
BR156     BR157     BR16.1    BR16.2    BR17.1    BR180
BR19.1    BR20.1    BR20.2    BR20.3    BR20.4    BR20.5
BR20.7    BR211     BR216     BR217     BR220     BR245
BR252     BR300     BR420     BR45.1    BR450     BR46.1
BR46.2    BR46.4    BR48.1    BR521     BR91.1    BRIP.1
CB06.2    PW110     TX101     TX140     TX226     TX301
WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APV-COMPANY            Numeric 4                                 AR02.1
Element: Company       The number representing an AR company.

APV-PROCESS-LEVEL      Alpha 5                                   AR02.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

APV-NAME               Alpha 30  (Lower Case)                    AR02.1
Element: Name          The name or description of the accounts
                       receivable process level.

APV-ADDR1              Alpha 30  (Lower Case)                    AR02.1
Element: Address 1     This field contains the first line of
                       address information.

APV-ADDR2              Alpha 30  (Lower Case)                    AR02.1
Element: Address 2     This field contains the first line of
                       address information.

APV-ADDR3              Alpha 30  (Lower Case)                    AR02.1
Element: Address 3     This field contains the first line of
                       address information.

APV-ADDR4              Alpha 30  (Lower Case)                    AR02.1
Element: Address 4     This field contains the first line of
                       address information.

APV-CITY               Alpha 18  (Lower Case)                    AR02.1
Element: City          This field contains the city of the
                       address.

APV-STATE              Alpha 2                                   AR02.1
Element: State or ProviThis field contains the two-character
                       state or province code of the address.

APV-ZIP                Alpha 10                                  AR02.1
Element: Postal Code   Postal code.

APV-COUNTRY            Alpha 30  (Lower Case)                    AR02.1
Element: Country or OthCountry name or other information, such
                       as an additional contact name.

APV-COUNTY             Alpha 25  (Lower Case)                    AR02.1
Element: County        County name. Can be used for additional
                       information such as an attention name.

APV-AR-CODE            Alpha 4                                   AR02.1
Accounts Receivable    This is the AR code indicating the
Code                   default Accounts Receivable general
                       ledger account for this process level.

APV-NOT-APPLD-CD       Alpha 4                                   AR02.1
Element: RNA Code      This is the RNA code indicating the
                       default Received Not Applied general
                       ledger account for this process level.

APV-PRE-PAY-CODE       Alpha 4                                   AR02.1
Element: Prepayment CodThe default prepayment code for payment
                       batches.

APV-CASH-CODE          Alpha 4                                   AR02.1
Element: Cash Code     This is the cash code indicating the
                       default cash general ledger account for
                       this process level.

APV-FIN-GL-CODE        Alpha 4                                   AR02.1
Element: Finance ChargeThis is the finance charge code
                       indicating the default finance charge
                       general ledger account for this process
                       level.

APV-DT-ACCPT-CODE      Alpha 4                                   AR02.1
Element: BOE AcceptanceBills of exchange acceptance GL code.

APV-FIN-REV-CODE       Alpha 4                                   AR02.1
BOE Financial          Bills of exchange financial revenue GL
Revenue Code           code.

APV-FIN-EXP-CODE       Alpha 4                                   AR02.1
BOE Financial          Bills of exchange financial expense GL
Expense Code           code.

APV-DIS-EXP-CODE       Alpha 4                                   AR02.1
Dishonored BOE         Dishonored Expense Code. This code will
Expense Code           be used if the company is processing
                       bills of exchange. If so, the code will
                       be used to post to GL any dishonored
                       bill of exchange expenses.

APV-ACCT-UNIT          Alpha 15                                  AR02.1
Element: Accounting UniDefault accounting unit to be used when
                       an adjustment is made against an invoice
                       from this process level.

APV-ACTIVE-STATUS      Alpha 1                                   AR02.1
Element: Active Status Indicates whether or not this process
                       level is active or inactive. Valid
                       values are:

                       A = Active
                       I = Inactive

APV-USED-FL            Alpha 1                                   AC56.1  AC560
Element: Used Flag     Indicates whether or not the process      AR02.1  AR115
                       level has been used. Valid values are:    AR129   AR130
                                                                 AR131   AR135
                       N = No                                    AR14.1  AR20.1
                       Y = Yes                                   AR30.1  AR30.8
                                                                 AR32.1  AR33.1
                                                                 AR33.3  AR33.6
                                                                 AR34.1  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR44.3  AR48.1
                                                                 AR48.2  AR48.3
                                                                 AR502   AR503
                                                                 AR570   AR575
                                                                 AR580   BL00.1
                                                                 BL01.1  BL05.1
                                                                 BL120   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL204
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL291   BL47.1
                                                                 BL520   BL820
                                                                 BL85.1  BL85.2
                                                                 BL85.3  BL90.1
                                                                 BL92.1  BR02.3
                                                                 BR10.1  BR10.9
                                                                 BR11.1  BR120
                                                                 BR121   BR122
                                                                 ...

APV-COUNTRY-CODE       Alpha 2                                   AR02.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

APV-REGION             Alpha 2                                   AR02.1
Element: Region        The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)

APV-ROUNDING-CODE      Alpha 4                                   AR02.1
Element: Ar Code       This code is used for possible rounding
                       differences with multi currency cash
                       applications.  This code is required if
                       the company enabled for mutli curency
                       processing.

APV-NOTC               Alpha 2                                   AR02.1
Element: Notc          The Nature of Transaction code.  Must
                       be a valid code defined in IN07.1 (NOTC
                       Maintenance).

                         ARPROCLEVL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APVSET1   COMPANY                                                AC56.1  AC560
          PROCESS-LEVEL                                          AR01.1  AR02.1
                                                                 AR03.1  AR10.2
                                                                 AR115   AR129
                                                                 AR130   AR131
                                                                 AR132   AR135
                                                                 AR137   AR14.1
                                                                 AR15.7  AR150
                                                                 AR190   AR194
                                                                 AR20.1  AR201
                                                                 AR203   AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR214   AR222
                                                                 AR223   AR227
                                                                 AR228   AR232
                                                                 ...

                         ARPROCLEVL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcode         ARCODE       Required

                            APV-COMPANY          -> RCD-COMPANY
                            APV-AR-CODE          -> RCD-AR-CODE

Arcomp         ARCOMP       Required

                            APV-COMPANY          -> ACO-COMPANY

Notappldcode   ARCODE       Required

                            APV-COMPANY          -> RCD-COMPANY
                            APV-NOT-APPLD-CD     -> RCD-AR-CODE

                         ARPROCLEVL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arsummary      ARSUMMARY    Delete Restricted

                            APV-COMPANY          -> ARS-COMPANY
                            APV-PROCESS-LEVEL    -> ARS-PROCESS-LEVEL
                                                    ARS-TYPE