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    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    DA90.2    DA91.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
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    BR20.7    BR211     BR220     BR450     BRIP.1
CB06.2    PBIP.1    PR197     TX140     WH20.2    WH20.7

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   BR10.1
                                                                 BR11.1  BR20.7
                                                                 BR211   BR220
                                                                 BR450   BRIP.1
                                                                 CB06.2  PBIP.1
                                                                 PR197   TX140
                                                                 WH20.2  WH20.7

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