ARSUMMARY – Transaction Activity

System
Accounts Receivable (AR)
Prefix
ARS
Primary key
COMPANY, PROCESS-LEVEL, TYPE
Fields
7
Updated by
3 programs
Referenced by
1 program

ARSUMMARY is the Transaction Activity table in Lawson Accounts Receivable (prefix ARS). It is indexed by COMPANY, PROCESS-LEVEL, TYPE (ARSSET1); alternate indexes: ARSSET2. It is related 1:1 to ARCOMP and ARPROCLEVL. It is updated by AR01.1, ARLL.1 and CB191 and referenced by AR02.1. The table has 7 fields, 2 indexes and 2 documented relations.

About ARSUMMARY

The Transaction Activity file contains totals by process level of accounts receivable activity. Current, period, and year to date amount totals are maintained.

Fields (7)

Column = COBOL field name without the ARS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ARS-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.ARLL.1, CB191
#ARS-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.ARLL.1, CB191
#ARS-TYPE PK
TYPE		Alpha 2Type is the breakout level of transaction activity for the process level. Valid values are:
  • 01 Invoiced
  • 02 Debits/Credits
  • 03 Payments/Charges
  • 04 Non-AR Payments Entered
  • 05 Beginning Balance
  • 06 Chargebacks
  • 07 Discounts
  • 08 Shorts/Write-Offs
  • 09 Gain/Loss
  • 10 Cashed Bills of Exchange
ARLL.1, CB191
#ARS-TODAYS-AMT
TODAYS_AMT		Signed 18.2This is the total amount of activity since the last running of AR194 (Audit Summary).ARLL.1, CB191
#ARS-PERIOD-AMT
PERIOD_AMT		Signed 18.2This is the total amount of activity for the current period since the last running of AR199 (Period Closing).ARLL.1, CB191
#ARS-CURR-YR-AMT
CURR_YR_AMT		Signed 18.2This is the total amount of activity for the current year since the last running of AR199 (Period Closing) with year-end option.ARLL.1, CB191
#ARS-PREV-DATE
PREV_DATE		Numeric 8 (yyyymmdd)The last date that this record was updated.—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ARSSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. TYPE
PrimaryAR02.1, ARLL.1, CB191
ARSSET2
  1. COMPANY
  2. TYPE
  3. PROCESS-LEVEL
AR01.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPARPROCLEVLARSUMMARY

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
ARS-COMPANY→ACO-COMPANY
ArprocesslevelARPROCLEVLRequired
ARS-COMPANY→APV-COMPANY
ARS-PROCESS-LEVEL→APV-PROCESS-LEVEL

Programs

Updated by (3)

Referenced by (1)