ACPRODUSER – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
BRU
Primary key
RECORD-TYPE, PRODUCT-LIST, PRODUCT, PROD-VERSION, EFFECTIVE-DT, MAX-USERS
Fields
12
Updated by
4 programs
Referenced by
9 programs

ACPRODUSER is a Lawson AC Billing Revenue table (prefix BRU); no description in the lawson data dictionary. It is indexed by RECORD-TYPE, PRODUCT-LIST, PRODUCT, PROD-VERSION, EFFECTIVE-DT, MAX-USERS (BRUSET1); alternate indexes: BRUSET2. It is related 1:1 to ACPRODLST and ACPRODLSTX. It is updated by BR50.1, BR50.3, BR50.4 and BR50.5 and referenced by BR250, BR51.1, BR51.2, BR52.1, BR52.4, BR52.5, BR570, BR70.1 and 1 more. The table has 12 fields, 2 indexes and 2 documented relations.

About ACPRODUSER

No description in the Lawson data dictionary.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
BRU-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
  • 1 Price
  • 2 Cost
  • 3 Suite
BR50.4, BR50.5
BRU-PRODUCT-LIST PK
PRODUCT_LIST		Alpha 10—BR50.4, BR50.5
BRU-PRODUCT PK
PRODUCT		Alpha 15—BR50.4, BR50.5
BRU-PROD-VERSION PK
PROD_VERSION		Alpha 10—BR50.4, BR50.5
BRU-MAX-USERS PK
MAX_USERS		Numeric 12—BR50.4, BR50.5
BRU-EFFECTIVE-DT PK
EFFECTIVE_DT		Numeric 8 (yyyymmdd)The effective date is the date the record is first valid.BR50.4, BR50.5
BRU-COST-PERCENT
COST_PERCENT		Signed 7.3The percentage determines how much retention is held. It can either be a percentage of each invoice, or it can be a percentage of a total.BR50.4
BRU-BASE-PRICE
BASE_PRICE		Signed 18.2—BR50.4, BR50.5
BRU-BASE-INC-AMT
BASE_INC_AMT		Signed 18.2—BR50.4, BR50.5
BRU-BASE-INC-USER
BASE_INC_USER		Numeric 12—BR50.4, BR50.5
BRU-USER-PRICE
USER_PRICE		Signed 18.2—BR50.4, BR50.5
BRU-MIN-USERS
MIN_USERS		Numeric 12—BR50.4, BR50.5

Indexes (2)

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

IndexKeysFlagsConditionUsed in
BRUSET1RECORD-TYPE, PRODUCT-LIST, PRODUCT, PROD-VERSION, EFFECTIVE-DT*, MAX-USERSPrimaryBR250, BR50.1, BR50.4, BR50.5, BR51.1, BR51.2, BR52.1, BR52.4 +4 more
BRUSET2PRODUCT-LIST, PRODUCT, PROD-VERSION, EFFECTIVE-DT*, RECORD-TYPE, MAX-USERS*BR50.1, BR50.3

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcprodlstACPRODLSTRequiredBRU-PRODUCT-LIST → BRP-PRODUCT-LIST
AcprodlstxACPRODLSTXRequiredBRU-PRODUCT-LIST → BRQ-PRODUCT-LIST, BRU-PRODUCT → BRQ-PRODUCT, BRU-PROD-VERSION → BRQ-PROD-VERSION

Programs

Updated by (4)

Referenced by (9)