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     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    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

AR02.1    AR115     AR129     AR130     AR131     AR135
AR14.1    AR20.1    AR30.1    AR30.2    AR30.3    AR30.4
AR30.8    AR31.6    AR42.1    AR44.3    AR48.1    AR48.2
AR48.3    AR502     AR503     AR570     AR575     AR580
BR10.1    BR11.1    BR120     BR121     BR122     BR123
BR15.1    BR151     BR152     BR156     BR157     BR16.1
BR16.2    BR20.7    BR211     BR220     BR252     BR420
BR450     BR521     BR91.1    BRIP.1    BRPI.1    CB06.2
PBIP.1    PR197     TX140     WH20.2    WH20.7    WO235

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APV-COMPANY            Numeric 4                                 AR02.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

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

APV-ADDR3              Alpha 30  (Lower Case)                    AR02.1
Element: Address 3

APV-ADDR4              Alpha 30  (Lower Case)                    AR02.1
Element: Address 4

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
                                                                 AR14.1  AR20.1
                       N = No                                    AR30.1  AR30.2
                       Y = Yes                                   AR30.3  AR30.4
                                                                 AR30.8  AR31.6
                                                                 AR42.1  AR44.3
                                                                 AR48.1  AR48.2
                                                                 AR48.3  AR502
                                                                 AR503   AR570
                                                                 AR575   AR580
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR15.1  BR151
                                                                 BR152   BR156
                                                                 BR157   BR16.1
                                                                 BR16.2  BR20.7
                                                                 BR211   BR220
                                                                 BR252   BR420
                                                                 BR450   BR521
                                                                 BR91.1  BRIP.1
                                                                 BRPI.1  CB06.2
                                                                 PBIP.1  PR197
                                                                 TX140   WH20.2
                                                                 WH20.7  WO235

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)

                         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