ARLOCKBOX – Lock Box Location

System
Accounts Receivable (AR)
Prefix
ARL
Primary key
LOCK-BOX
Fields
18
Updated by
8 programs
Referenced by
94 programs

ARLOCKBOX is the Lock Box Location table in Lawson Accounts Receivable (prefix ARL). It is indexed by LOCK-BOX (ARLSET1). It is related 1:1 to ARCOMP and ARPROCLEVL. It is updated by AR01.1, AR09.1, AR10.1, AR14.1, AR301, AR501, AR550 and TX140 and referenced by AC56.1, AC560, AR08.1, AR214, BR00.1, BR00.2, BR02.3, BR10.1 and 86 more. The table has 18 fields, 1 index and 2 documented relations.

About ARLOCKBOX

The AR Lock Box Location file contains lock box records representing the address location of a lock box, as well as a default comapny, process level cash code, and cusrrency for cash entry.

Fields (18)

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

Field / columnTypeDescription & valuesUpdated by
ARL-COMPANY
COMPANY		Numeric 4The number representing an AR company.AR14.1
ARL-LOCK-BOX PK
LOCK_BOX		Alpha 2Lock box number that identifies a lock box.AR14.1
ARL-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AR14.1
ARL-CASH-CODE
CASH_CODE		Alpha 4Cash code that this lock box will reference during processing. Cash codes are tied to GL cash accounts.AR14.1
ARL-NAME
NAME		Alpha 30 (Lower Case)This is the name given for the lock box location.AR14.1
ARL-REMIT-ADDR1
REMIT_ADDR1		Alpha 30First address line of lock box address.AR14.1
ARL-REMIT-ADDR2
REMIT_ADDR2		Alpha 30Second address line of lock box address.AR14.1
ARL-REMIT-ADDR3
REMIT_ADDR3		Alpha 30Third address line of lock box address.AR14.1
ARL-REMIT-ADDR4
REMIT_ADDR4		Alpha 30Fourth address line of lock box address.AR14.1
ARL-CITY
CITY		Alpha 18 (Lower Case)City name in the lock box address.AR14.1
ARL-STATE
STATE		Alpha 2State or province abbreviation in the lock box address.AR14.1
ARL-ZIP
ZIP		Alpha 10Postal code in the lock box address.AR14.1
ARL-COUNTRY
COUNTRY		Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.AR14.1
ARL-COUNTY
COUNTY		Alpha 25 (Lower Case)This field contains the county of the address, or it can be used for additional information such as an attention name.AR14.1
ARL-USED-FL
USED_FL		Alpha 1This field indicates whether the lock box has been used.AR09.1, AR10.1, AR301, AR501, AR550, TX140
ARL-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12This field contains the journal book number for the lock box.AR14.1
ARL-CURRENCY-CD
CURRENCY_CD		Alpha 5The currency code of the lockbox.AR14.1
ARL-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AR14.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ARLSET1LOCK-BOXPrimaryAC56.1, AC560, AR01.1, AR08.1, AR09.1, AR10.1, AR14.1, AR214 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Ar CompanyARCOMPRequiredARL-COMPANY → ACO-COMPANY
ArproclevlARPROCLEVLRequiredARL-COMPANY → APV-COMPANY, ARL-PROCESS-LEVEL → APV-PROCESS-LEVEL

Programs

Updated by (8)

Referenced by (94)