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

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 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
BRUSET1
  1. RECORD-TYPE
  2. PRODUCT-LIST
  3. PRODUCT
  4. PROD-VERSION
  5. EFFECTIVE-DT ↓
  6. MAX-USERS
PrimaryBR250, BR50.1, BR50.4, BR50.5, BR51.1, BR51.2, BR52.1, BR52.4 +4 more
BRUSET2
  1. PRODUCT-LIST
  2. PRODUCT
  3. PROD-VERSION
  4. EFFECTIVE-DT ↓
  5. RECORD-TYPE
  6. MAX-USERS ↓
BR50.1, BR50.3

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcprodlstACPRODLSTRequired
BRU-PRODUCT-LIST→BRP-PRODUCT-LIST
AcprodlstxACPRODLSTXRequired
BRU-PRODUCT-LIST→BRQ-PRODUCT-LIST
BRU-PRODUCT→BRQ-PRODUCT
BRU-PROD-VERSION→BRQ-PROD-VERSION

Programs

Updated by (4)

Referenced by (9)