ARPROCLEVL – Accounts Receivable Proc Level

System
Accounts Receivable (AR)
Prefix
APV
Primary key
COMPANY, PROCESS-LEVEL
Fields
28
Updated by
56 programs
Referenced by
8 programs

ARPROCLEVL is the Accounts Receivable Proc Level table in Lawson Accounts Receivable (prefix APV). It is indexed by COMPANY, PROCESS-LEVEL (APVSET1). It is related 1:1 to ARCODE and ARCOMP and 1:M to ARPRLAUD and ARSUMMARY. It is updated by AC56.1, AC560, AR02.1, AR14.1, BR02.3, BR10.1, BR10.9, BR11.1 and 48 more and referenced by AR01.1, AR03.1, AR10.2, AR15.7, AR201, AR203, AR214 and ARLL.1. The table has 28 fields, 1 index and 5 documented relations.

About ARPROCLEVL

The AR Process Level file contains all valid process levels within each company. There is a requirement that at least one process level be established for each company. Process levels contain default GL accounts, 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.

Fields (28)

Column = COBOL field name without the APV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
APV-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR02.1
APV-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AR02.1
APV-NAME
NAME		Alpha 30 (Lower Case)The name or description of the accounts receivable process level.AR02.1
APV-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.AR02.1
APV-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.AR02.1
APV-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.AR02.1
APV-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.AR02.1
APV-CITY
CITY		Alpha 18 (Lower Case)This field contains the city of the address.AR02.1
APV-STATE
STATE		Alpha 2This field contains the two-character state or province code of the address.AR02.1
APV-ZIP
ZIP		Alpha 10Postal code.AR02.1
APV-COUNTRY
COUNTRY		Alpha 30 (Lower Case)Country name or other information, such as an additional contact name.AR02.1
APV-COUNTY
COUNTY		Alpha 25 (Lower Case)County name. Can be used for additional information such as an attention name.AR02.1
APV-AR-CODE
AR_CODE		Alpha 4This is the AR code indicating the default Accounts Receivable general ledger account for this process level.AR02.1
APV-NOT-APPLD-CD
NOT_APPLD_CD		Alpha 4This is the RNA code indicating the default Received Not Applied general ledger account for this process level.AR02.1
APV-PRE-PAY-CODE
PRE_PAY_CODE		Alpha 4The default prepayment code for payment batches.AR02.1
APV-CASH-CODE
CASH_CODE		Alpha 4This is the cash code indicating the default cash general ledger account for this process level.AR02.1
APV-FIN-GL-CODE
FIN_GL_CODE		Alpha 4This is the finance charge code indicating the default finance charge general ledger account for this process level.AR02.1
APV-DT-ACCPT-CODE
DT_ACCPT_CODE		Alpha 4Bills of exchange acceptance GL code.AR02.1
APV-FIN-REV-CODE
FIN_REV_CODE		Alpha 4Bills of exchange financial revenue GL code.AR02.1
APV-FIN-EXP-CODE
FIN_EXP_CODE		Alpha 4Bills of exchange financial expense GL code.AR02.1
APV-DIS-EXP-CODE
DIS_EXP_CODE		Alpha 4Dishonored Expense Code. This code will 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.AR02.1
APV-ACCT-UNIT
ACCT_UNIT		Alpha 15Default accounting unit to be used when an adjustment is made against an invoice from this process level.AR02.1
APV-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Indicates whether or not this process level is active or inactive. Valid values are:
  • A Active
  • I Inactive
AR02.1
APV-USED-FL
USED_FL		Alpha 1Indicates whether or not the process level has been used. Valid values are:
  • N No
  • Y Yes
AC56.1, AC560, AR02.1, AR14.1, BR02.3, BR10.1, BR10.9, BR11.1 +48 more
APV-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AR02.1
APV-REGION
REGION		Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)AR02.1
APV-ROUNDING-CODE
ROUNDING_CODE		Alpha 4This code is used for possible rounding differences with multi currency cash applications. This code is required if the company enabled for mutli curency processing.AR02.1
APV-NOTC
NOTC		Alpha 2The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).AR02.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APVSET1COMPANY, PROCESS-LEVELPrimaryAC56.1, AC560, AR01.1, AR02.1, AR03.1, AR10.2, AR14.1, AR15.7 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ArcodeARCODERequiredAPV-COMPANY → RCD-COMPANY, APV-AR-CODE → RCD-AR-CODE
ArcompARCOMPRequiredAPV-COMPANY → ACO-COMPANY
NotappldcodeARCODERequiredAPV-COMPANY → RCD-COMPANY, APV-NOT-APPLD-CD → RCD-AR-CODE

One to many (2) — child tables

RelationTableRulesConditionField map
ArprlaudARPRLAUDAPV-COMPANY → RPA-COMPANY, APV-PROCESS-LEVEL → RPA-PROCESS-LEVEL, → RPA-UNIQUE-I-D
ArsummaryARSUMMARYDelete RestrictedAPV-COMPANY → ARS-COMPANY, APV-PROCESS-LEVEL → ARS-PROCESS-LEVEL, → ARS-TYPE

Programs

Updated by (56)

Referenced by (8)