ACPRODLST – Activity Product List

System
AC Billing Revenue (BR)
Prefix
BRP
Primary key
PRODUCT-LIST
Fields
3
Updated by
1 program
Referenced by
11 programs

ACPRODLST is the Activity Product List table in Lawson AC Billing Revenue (prefix BRP). It is indexed by PRODUCT-LIST (BRPSET1). It is related 1:M to ACPRODLSTX. It is updated by BR50.3 and referenced by BR155, BR250, BR252, BR51.1, BR51.2, BR52.1, BR52.2, BR52.5 and 3 more. The table has 3 fields, 1 index and 1 documented relation.

About ACPRODLST

No description in the Lawson data dictionary.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
BRP-PRODUCT-LIST PK
PRODUCT_LIST		Alpha 10—BR50.3
BRP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BR50.3
BRP-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BR50.3

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BRPSET1PRODUCT-LISTPrimaryBR155, BR250, BR252, BR50.1, BR50.2, BR50.3, BR50.4, BR50.5 +8 more

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AcprodlstxACPRODLSTXBRP-PRODUCT-LIST → BRQ-PRODUCT-LIST, → BRQ-PRODUCT, → BRQ-PROD-VERSION

Programs

Updated by (1)

Referenced by (11)