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 is established
for each company. Process levels contain default accounting logic, 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     AR14.1
AR15.7    AR150     AR190     AR194     AR201     AR203
AR21.1    AR21.2    AR21.3    AR214     AR222     AR223
AR227     AR228     AR232     AR233     AR234     AR235
AR242     AR251     AR252     AR253     AR258     AR271
AR28.8    AR29.2    AR293     AR294     AR300     AR35.1
AR35.2    AR36.1    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    SAOR.1

UPDATED BY

AR02.1    AR115     AR129     AR130     AR131     AR135
AR20.1    AR30.1    AR30.8    AR31.6    AR33.1    AR33.3
AR33.6    AR34.1    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    BR11.1    BR120     BR121     BR122
BR140     BR145     BR16.1    BR17.1    BR19.1    BR20.1
BR20.2    BR20.3    BR20.4    BR20.5    BR20.7    BR211
BR216     BR217     BR220     BR245     BR300     BR420
BR45.1    BR450     BR46.1    BR46.2    BR46.4    BR521
BRIP.1    CB06.2    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
OE129     OE13.2    OE14.4    OE280     OE281     OE285
OE294     OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE530     OE810
OE830     PBIP.1    PR197     TX101     TX140     TX301
WH20.2    WH20.7    WO235

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APV-COMPANY            Numeric 4                                 AR02.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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 second line of
                       address information.

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

APV-ADDR4              Alpha 30  (Lower Case)                    AR02.1
Element: Address 4     This field contains the fourth 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                                   AR02.1  AR115
Element: Used Flag     Indicates whether or not the process      AR129   AR130
                       level has been used. Valid values are:    AR131   AR135
                                                                 AR20.1  AR30.1
                       N = No                                    AR30.8  AR31.6
                       Y = Yes                                   AR33.1  AR33.3
                                                                 AR33.6  AR34.1
                                                                 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
                                                                 BR11.1  BR120
                                                                 BR121   BR122
                                                                 BR140   BR145
                                                                 BR16.1  BR17.1
                                                                 BR19.1  BR20.1
                                                                 ...

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 Code   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
Accounts Receivable
Code

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       This path is used for record uniqueness  AR01.1  AR02.1
          PROCESS-LEVEL and record selection.                    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
                                                                 AR233   AR234
                                                                 ...

                         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