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.

Field / column	Type	Description & values	Updated by
`ARS-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	ARLL.1, CB191
`ARS-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company.	ARLL.1, CB191
`ARS-TYPE` PK TYPE	Alpha 2	Type 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.2	This is the total amount of activity since the last running of AR194 (Audit Summary).	ARLL.1, CB191
`ARS-PERIOD-AMT` PERIOD_AMT	Signed 18.2	This 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.2	This 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ARSSET1`	`COMPANY`, `PROCESS-LEVEL`, `TYPE`	Primary		AR02.1, ARLL.1, CB191
`ARSSET2`	`COMPANY`, `TYPE`, `PROCESS-LEVEL`			AR01.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcomp	ARCOMP	Required		`ARS-COMPANY` → `ACO-COMPANY`
Arprocesslevel	ARPROCLEVL	Required		`ARS-COMPANY` → `APV-COMPANY`, `ARS-PROCESS-LEVEL` → `APV-PROCESS-LEVEL`

ARSUMMARY – Transaction Activity

About ARSUMMARY

Fields (7)

Indexes (2)

Relations

One to one (2) — lookups and parents

Programs

Updated by (3)

Referenced by (1)