ACRETAINX – No description in the Lawson data dictionary

System: AC Billing Revenue (BR)
Prefix: REX
Primary key: ACTIVITY, RETAIN-ID, RETAIN-CODE
Fields: 7
Updated by: 8 programs
Referenced by: 15 programs

ACRETAINX is a Lawson AC Billing Revenue table (prefix REX); no description in the lawson data dictionary. It is indexed by ACTIVITY, RETAIN-ID, RETAIN-CODE (REXSET1). It is related 1:1 to ACACTIVITY and ACRETAIN. It is updated by AC300, BR00.1, BR02.1, BR02.2, BR10.1, BR122, BR140 and BRIP.1 and referenced by BR120, BR121, BR123, BR151, BR152, BR156, BR20.1, BR20.2 and 7 more. The table has 7 fields, 1 index and 2 documented relations.

About ACRETAINX

No description in the Lawson data dictionary.

Fields (7)

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

Field / column	Type	Description & values	Updated by
`REX-ACTIVITY` PK ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	BR02.2
`REX-RETAIN-ID` PK RETAIN_ID	Numeric 6	—	BR02.2
`REX-RETAIN-CODE` PK RETAIN_CODE	Alpha 3	—	BR02.2
`REX-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	BR02.2
`REX-RETAINER` RETAINER	Signed 18.2	—	BR02.2
`REX-RETAINER-PCT` RETAINER_PCT	Percent 15.2 (Percent)	—	BR02.2
`REX-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `1` Apply to Next `2` Applied `3` Hold	AC300, BR02.2, BR122, BR140, BRIP.1

Indexes (1)

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
`REXSET1`	`ACTIVITY`, `RETAIN-ID`, `RETAIN-CODE`	Primary		AC300, BR00.1, BR02.1, BR02.2, BR02.3, BR10.1, BR120, BR121 +16 more

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acactivity	ACACTIVITY	Required		`REX-ACTIVITY` → `ACV-ACTIVITY`
Acretain	ACRETAIN	Required		`REX-ACTIVITY` → `RET-ACTIVITY`, `REX-RETAIN-ID` → `RET-RETAIN-ID`

Programs

Updated by (8)

AC300 Activity Group Purge
BR00.1 Activity Billing
BR02.1 Retainer Parameters
BR02.2 Retainer Detail
BR10.1 Contract Parameters
BR122 Online batch invoice process
BR140 Billing and Revenue Backout
BRIP.1 Invoice Print Program

Referenced by (15)

BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR123 Product Invoice Cancel
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR156 Maintenance Quote
BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR202 Retainer Listing
BR420 Billing Invoice Report
BR450 Activity Aging
BR521 Billing Import