APPROCLEV – Accounts Payable Process Level

System
Accounts Payable (AP)
Prefix
APR
Primary key
COMPANY, PROC-LEVEL
Fields
28
Updated by
9 programs
Referenced by
329 programs

APPROCLEV is the Accounts Payable Process Level table in Lawson Accounts Payable (prefix APR). It is indexed by COMPANY, PROC-LEVEL (APRSET1); alternate indexes: APRSET2, APRSET3 and APRSET4. It is related 1:1 to APCOMPANY and PROCLEV and 1:M to APPRCLVAUD. It is updated by AP00.4, AP00.5, AP101, AP161, AP195, AP305, AP702, PD130 and 1 more and referenced by AC42.1, AC42.2, AP01.4, AP02.2, AP10.7, AP102, AP115, AP125 and 321 more. The table has 28 fields, 4 indexes and 3 documented relations.

About APPROCLEV

The Accounts Payable Process Level file contains records for each process level defined for a company in the Lawson Accounts Payable system. A company that has Yes selected in the Process Levels Required field must have at least one process level defined. Companies that have No selected in the Process Levels Required field cannot define or use process levels. Process levels can be used to default accounts used for posting transactions, break and subtotal reports, and process payments.

Fields (28)

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

Field / columnTypeDescription & valuesUpdated by
APR-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid accounts payable company with Yes selected in the Process Levels Required field.AP00.5, AP193
APR-PROC-LEVEL PK
PROC_LEVEL		Alpha 5A user-defined code representing a reporting and processing level in the accounts payable company.AP00.5, AP193
APR-NAME
NAME		Alpha 30 (Lower Case)The process level name or description.AP00.5, AP135
APR-ADDR1
ADDR1		Alpha 30 (Lower Case)The first line of address information for the process level.AP00.5
APR-ADDR2
ADDR2		Alpha 30 (Lower Case)The second line of address information for the process level.AP00.5
APR-ADDR3
ADDR3		Alpha 30 (Lower Case)The third line of address information for the process level.AP00.5
APR-ADDR4
ADDR4		Alpha 30 (Lower Case)The fourth line of address information for the process level.AP00.5
APR-CITY-ADDR5
CITY_ADDR5		Alpha 18 (Lower Case)The city or fifth line of address information for the process level.AP00.5
APR-STATE-PROV
STATE_PROV		Alpha 2The state or province for the process level address.AP00.5
APR-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)The postal code for the process level address.AP00.5
APR-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.AP00.5
APR-COUNTRY
COUNTRY		Alpha 30 (Lower Case)The country for the process level address. Can also be used for additional information such as attention name.AP00.5
APR-REGION
REGION		Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)AP00.5
APR-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AP00.5
APR-ACCR-CODE
ACCR_CODE		Alpha 4The invoice accrual code assigned to the process level. Used to default a general ledger accrual account to an invoice during invoice entry. Must be a valid record in the Invoice Accrual Code file. If left blank, the process level uses the invoice accrual code assigned to the company.AP00.5
APR-CASH-CODE
CASH_CODE		Alpha 4The cash code assigned to the process level. Represents a bank account. Must be a valid record in the Cash Code file. If left blank, the cash code assigned to the company, if assigned, or the pay group defaults on invoices entered for the process level.AP00.5
APR-INC-ACCR-CODE
INC_ACCR_CODE		Alpha 10The income withholding code assigned to the process level. Used to default an income withholding accrual account to an invoice during entry to track reportable withholding for a vendor. Must be a valid record in the Income Withholding Code file. If left blank, the process level uses the income withholding code assigned to the company.AP00.5
APR-DISCOUNT-CODE
DISCOUNT_CODE		Alpha 10The discount code assigned to the process level. Used to default a general discount account to an invoice during entry. Must be a valid record in the Discount Code file. If left blank, the process level uses the discount code assigned to the company.AP00.5
APR-PAY-GROUP
PAY_GROUP		Alpha 4The pay group assigned to the process level. A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group. Must be a valid record in the Pay Group file. If left blank, the process level uses the pay group assigned to the company.AP00.5, AP101
APR-DEF-PROC-LEVEL
DEF_PROC_LEVEL		Alpha 1Indicates whether this is the default process level for the company. A company can have only one default process level.
  • Y Yes
  • N No
AP00.5
APR-HANDLING-CODE
HANDLING_CODE		Alpha 4Handling code. Contains processing rules for invoice matching.AP00.5
APR-MATCH-PROC-LEV
MATCH_PROC_LEV		Alpha 1Matching process level.AP00.5
APR-DIST-CODE
DIST_CODE		Alpha 9A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions.AP00.5
APR-RET-ACCR-CODE
RET_ACCR_CODE		Alpha 4—AP00.5
APR-SEC-WTH-CODE1
SEC_WTH_CODE1		Alpha 10—AP00.5
APR-SEC-WTH-CODE2
SEC_WTH_CODE2		Alpha 10—AP00.5
APR-SEC-WTH-CODE3
SEC_WTH_CODE3		Alpha 10—AP00.5
APR-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1—
  • A Active
  • I Inactive
AP00.5, AP702

Indexes (4)

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

IndexKeysFlagsConditionUsed in
APRSET1COMPANY, PROC-LEVELPrimaryAC42.1, AC42.2, AP00.4, AP00.5, AP00.6, AP01.4, AP02.2, AP10.7 +22 more (list truncated in source)
APRSET2PROC-LEVEL, COMPANYKeyChangeAP230, AP250, AP251, CB186, CB187, CB286, MA540
APRSET3PAY-GROUP, PROC-LEVEL, COMPANYKeyChangeAP150, AP151, AP161, AP230, AP250, AP251, AP265, AP40.1 +1 more
APRSET4HANDLING-CODE, COMPANY, PROC-LEVELAC42.1, AC42.2, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredAPR-COMPANY → CPY-COMPANY
MaproclevPROCLEVNot Required, Delete CascadesValid When APR-MATCH-PROC-LEV = "Y"APR-COMPANY → MAZ-COMPANY, APR-PROC-LEVEL → MAZ-PROC-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
Proc AuditAPPRCLVAUDAPR-COMPANY → LVA-COMPANY, APR-PROC-LEVEL → LVA-PROCESS-LEVEL, → LVA-ACTION, → LVA-DATE, → LVA-TIME, → LVA-UNIQUE-I-D

Programs

Updated by (9)

Referenced by (329)