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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#BRQ-PRODUCT-LIST PKPRODUCT_LIST | Alpha 10 | — | BR50.1 |
#BRQ-PRODUCT PKPRODUCT | Alpha 15 | — | BR50.1 |
#BRQ-PROD-VERSION PKPROD_VERSION | Alpha 10 | — | BR50.1 |
#BRQ-STATUSSTATUS | Alpha 1 | Status Code.
| BR50.1 |
#BRQ-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | BR50.1 |
#BRQ-MAINT-FLAGMAINT_FLAG | Alpha 1 | —
| BR50.1 |
#BRQ-COST-BASISCOST_BASIS | Alpha 1 | —
| BR50.1 |
#BRQ-MAINT-BASISMAINT_BASIS | Alpha 1 | —
| BR50.1 |
#BRQ-DECOM-DATEDECOM_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | BR50.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BRQSET1 |
| Primary | BR124, BR153, BR154, BR155, BR157, BR250, BR252, BR253 +18 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Acprodlst | ACPRODLST | Required |
|
One to many (4) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acprodacct | ACPRODACCT |
| ||||||||||||||||||||
| Acproduser | ACPRODUSER |
| ||||||||||||||||||||
| Acproduser Cst | ACPRODUSER |
| ||||||||||||||||||||
| Acproduser Prc | ACPRODUSER |
|
Programs
Updated by (2)
Referenced by (21)
- BR124 Deferred Revenue Adjustment
- BR153 Product Revenue Calculation
- BR154 Maintenance Revenue Calculation
- BR155 Maintenance Schedule Copy
- BR157 Maintenance Cancel
- BR250 Product List Listing
- BR252 Maintenance Schedule Listing
- BR253 Deferred Revenue Listing
- BR31.2 Product Detail Comments
- BR31.4 Maintenance Product Comments
- BR51.1 Product Contract
- BR51.2 Product Cost of Goods Sold
- BR52.1 Maintenance Schedule
- BR52.4 Renew All
- BR52.5 Product Maintenance Renewal
- BR53.1 Product Deferred Revenue Schedule
- BR53.2 Product Deferred Revenue Auto Scheduler
- BR570 Product Contract Interface
- BR70.1 Product Contract Interface Adjustment
- BR70.2 Product Interface Cost of Goods Sold
- BRIP.1 Invoice Print Program