ARCSTMXVAL – This file contains an attribute value for a customer.

System: Accounts Receivable (AR)
Prefix: CTV
Primary key: OBJ-ID, MATRIX-CAT
Fields: 3
Updated by: 9 programs
Referenced by: 7 programs

ARCSTMXVAL is the This file contains an attribute value for a customer. table in Lawson Accounts Receivable (prefix CTV). It is indexed by OBJ-ID, MATRIX-CAT (CTVSET1); alternate indexes: CTVSET2. It is related 1:1 to ARCUSTOMER. It is updated by AR09.1, AR10.1, AR23.1, AR23.2, AR301, AR501, AR550, MX500 and 1 more and referenced by AR210, AR211, AR217, MX123, WH110, WH130 and WH226. The table has 3 fields, 2 indexes and 1 documented relation.

About ARCSTMXVAL

This file contains an attribute value for a customer. The objet ID element relates the value to a customer. Attribute values are used to help formulate customer lists for reporting purposes within the AR system.

Fields (3)

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

Field / column	Type	Description & values	Updated by
`CTV-OBJ-ID` PK OBJ_ID	Numeric 12	This is the object identifier that relates to a specific company customer record.	AR23.1, AR23.2, AR501, AR550, MX500
`CTV-MATRIX-CAT` PK MATRIX_CAT	Alpha 12	Attribute name assigned to an object (like customert) to track additional information.	AR23.1, AR23.2, AR501, AR550, MX500
`CTV-MX-VALUE` MX_VALUE	Alpha 32	The attribute value.	AR23.1, AR23.2, AR501, AR550, MX500

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
`CTVSET1`	`OBJ-ID`, `MATRIX-CAT`	Primary		AR09.1, AR10.1, AR210, AR211, AR217, AR23.1, AR23.2, AR23.3 +9 more
`CTVSET2`	`MATRIX-CAT`, `MX-VALUE`, `OBJ-ID`	KeyChange		AR210, AR211, AR217, AR23.3, AR301, MX123, MX500, WH110 +2 more

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcustomer	ARCUSTOMER	Not Required		`CTV-OBJ-ID` → `ACM-OBJ-ID`

Programs

Updated by (9)

AR09.1 Customer Group Address
AR10.1 Customer
AR23.1 Customer Attributes
AR23.2 Values By Customer Attributes
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
MX500 Attribute Value Population
TX140 Vertex Geocode Update

Referenced by (7)

AR210 Customer Listing
AR211 Customer Optional Fields Listing
AR217 Comments Listing
MX123 List Member Build
WH110 Batch Allocation
WH130 Pick List Print
WH226 Items on Backorder Report