ACPRODLSTX – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
BRQ
Primary key
PRODUCT-LIST, PRODUCT, PROD-VERSION
Fields
9
Updated by
2 programs
Referenced by
21 programs

ACPRODLSTX is a Lawson AC Billing Revenue table (prefix BRQ); no description in the lawson data dictionary. It is indexed by PRODUCT-LIST, PRODUCT, PROD-VERSION (BRQSET1). It is related 1:1 to ACPRODLST and 1:M to ACPRODACCT and ACPRODUSER. It is updated by BR50.1 and BR50.3 and referenced by BR124, BR153, BR154, BR155, BR157, BR250, BR252, BR253 and 13 more. The table has 9 fields, 1 index and 5 documented relations.

About ACPRODLSTX

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
BRQ-PRODUCT-LIST PK
PRODUCT_LIST		Alpha 10—BR50.1
BRQ-PRODUCT PK
PRODUCT		Alpha 15—BR50.1
BRQ-PROD-VERSION PK
PROD_VERSION		Alpha 10—BR50.1
BRQ-STATUS
STATUS		Alpha 1Status Code.
  • A Active
  • I Inactive
BR50.1
BRQ-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BR50.1
BRQ-MAINT-FLAG
MAINT_FLAG		Alpha 1—
  • Y Yes
  • N No
BR50.1
BRQ-COST-BASIS
COST_BASIS		Alpha 1—
  • 1 List
  • 2 Net
BR50.1
BRQ-MAINT-BASIS
MAINT_BASIS		Alpha 1—
  • 1 List
  • 2 Net
BR50.1
BRQ-DECOM-DATE
DECOM_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR50.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
BRQSET1PRODUCT-LIST, PRODUCT, PROD-VERSIONPrimaryBR124, BR153, BR154, BR155, BR157, BR250, BR252, BR253 +18 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AcprodlstACPRODLSTRequiredBRQ-PRODUCT-LIST → BRP-PRODUCT-LIST

One to many (4) — child tables

RelationTableRulesConditionField map
AcprodacctACPRODACCTBRQ-PRODUCT-LIST → BRR-PRODUCT-LIST, BRQ-PRODUCT → BRR-PRODUCT, → BRR-RECORD-TYPE
AcproduserACPRODUSERBRQ-PRODUCT-LIST → BRU-PRODUCT-LIST, BRQ-PRODUCT → BRU-PRODUCT, BRQ-PROD-VERSION → BRU-PROD-VERSION, → BRU-EFFECTIVE-DT, → BRU-RECORD-TYPE, → BRU-MAX-USERS
Acproduser CstACPRODUSER"2" → BRU-RECORD-TYPE, BRQ-PRODUCT-LIST → BRU-PRODUCT-LIST, BRQ-PRODUCT → BRU-PRODUCT, BRQ-PROD-VERSION → BRU-PROD-VERSION, → BRU-EFFECTIVE-DT, → BRU-MAX-USERS
Acproduser PrcACPRODUSER"1" → BRU-RECORD-TYPE, BRQ-PRODUCT-LIST → BRU-PRODUCT-LIST, BRQ-PRODUCT → BRU-PRODUCT, BRQ-PROD-VERSION → BRU-PROD-VERSION, → BRU-EFFECTIVE-DT, → BRU-MAX-USERS

Programs

Updated by (2)

Referenced by (21)