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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 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
BRPSET1
  1. PRODUCT-LIST
PrimaryBR155, BR250, BR252, BR50.1, BR50.2, BR50.3, BR50.4, BR50.5 +8 more

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
AcprodlstxACPRODLSTX
BRP-PRODUCT-LIST→BRQ-PRODUCT-LIST
—→BRQ-PRODUCT
—→BRQ-PROD-VERSION

Programs

Updated by (1)

Referenced by (11)