Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARPROCLEVL FILE

                            AR Process Level

AR Process Level

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     AR227
AR228     AR232     AR233     AR234     AR235     AR242
AR251     AR252     AR253     AR258     AR271     AR28.8
AR29.2    AR294     AR300     AR35.1    AR35.2    AR36.1
AR43.1    AR50.1    AR560     AR72.2    AR73.2    AR82.1
AR90.2    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

AC15.2    AR02.1    AR115     AR130     AR131     AR135
AR20.1    AR30.1    AR30.2    AR30.3    AR30.4    AR30.8
AR31.6    AR42.1    AR44.3    AR502     AR503     AR570
AR575     AR580     AR970     BL00.1    BL01.1    BL05.1
BL120     BL122     BL123     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    BL940     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     OE113
OE114     OE129     OE14.4    OE15.1    OE15.2    OE15.3
OE15.4    OE15.5    OE15.7    OE280     OE281     OE285
OE294     OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE810     OE830
OE920     OE950     PBIP.1    WH20.2    WH20.7    WO235

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

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

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

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

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

APV-STATE            Alpha 2                                     AR02.1  AR970
State or Province    This field contains the two-character
                     state or province code of the address.

APV-ZIP              Alpha 10                                    AR02.1  AR970
Postal Code          Postal code.

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

APV-COUNTY           Alpha 25
County               For use in a future release.

APV-AR-CODE          Alpha 4                                     AR02.1  AR970
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  AR970
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  AR970
Prepayment Code      The default prepayment code for payment
                     batches.

APV-CASH-CODE        Alpha 4                                     AR02.1  AR970
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  AR970
Finance Charge Code  This 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  AR970
BOE Acceptance Code  Bills of exchange acceptance GL code.

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

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

APV-DIS-EXP-CODE     Alpha 4                                     AR02.1  AR970
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  AR970
Accounting Unit      Default accounting unit to be used when
                     an adjustment is made against an invoice
                     from this process level.

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

                     A = Active
                     I = Inactive

APV-USED-FL          Alpha 1                                     AC15.2  AR02.1
Used Flag            Indicates whether or not the process        AR115   AR130
                     level has been used. Valid values are:      AR131   AR135
                                                                 AR20.1  AR30.1
                     N = No                                      AR30.2  AR30.3
                     Y = Yes                                     AR30.4  AR30.8
                                                                 AR31.6  AR42.1
                                                                 AR44.3  AR502
                                                                 AR503   AR570
                                                                 AR575   AR580
                                                                 AR970   BL00.1
                                                                 BL01.1  BL05.1
                                                                 BL120   BL122
                                                                 BL123   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
                                                                 BL940   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   OE113
                                                                 ...

APV-COUNTRY-CODE     Alpha 2                                     AR02.1
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
Region Code          The region code, if applicable for the
                     country. Used only by Intrastat. Must be
                     defined in IN02.1 (Region Maintenance).


APV-NOTC             Alpha 2                                     AR02.1
Notc                 The Nature Of Transaction Code. This
                     code must be 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  AC15.2  AR01.1
          PROCESS-LEVEL and record selection.                    AR02.1  AR03.1
                                                                 AR10.2  AR115
                                                                 AR130   AR131
                                                                 AR132   AR135
                                                                 AR137   AR14.1
                                                                 AR15.7  AR150
                                                                 AR190   AR194
                                                                 AR20.1  AR201
                                                                 AR203   AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR214   AR222
                                                                 AR227   AR228
                                                                 AR232   AR233
                                                                 AR234   AR235
                                                                 ...

                         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