Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


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

AR02.1    AR115     AR129     AR130     AR131     AR135
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     BL00.1
BL01.1    BL05.1    BL123     BL125     BL204     BL291
BL47.1    BL85.1    BL85.2    BL85.3    BL90.1    BR10.1
BR11.1    BR211     BR220     BR450     BRIP.1    CB06.2
PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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


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

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

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

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

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


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

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

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

APV-COUNTY           Alpha 25  (Lower Case)                      AR02.1
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
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
Prepayment Code      The default prepayment code for payment
                     batches.

APV-CASH-CODE        Alpha 4                                     AR02.1
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
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
BOE Acceptance Code  Bills 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
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
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                                     AR02.1  AR115
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.2  AR30.3
                     Y = Yes                                     AR30.4  AR30.8
                                                                 AR31.6  AR42.1
                                                                 AR44.3  AR48.1
                                                                 AR48.2  AR48.3
                                                                 AR502   AR503
                                                                 AR570   AR575
                                                                 AR580   BL00.1
                                                                 BL01.1  BL05.1
                                                                 BL123   BL125
                                                                 BL204   BL291
                                                                 BL47.1  BL85.1
                                                                 BL85.2  BL85.3
                                                                 BL90.1  BR10.1
                                                                 BR11.1  BR211
                                                                 BR220   BR450
                                                                 BRIP.1  CB06.2
                                                                 PR197

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