Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPRODLSTX


                            ACPRODLSTX FILE

The ACPRODLSTX file contains the master list of products that an organization
sells and supports. The products created in this file are assigned to a
Product Contract record and ultimately appear on the invoice the customer
receives. Information related to the products in this file includes base
price, price per user, and default billing and revenue accounts. Records are
primarily maintained on Product List (BR50.1). The ACPRODLSTX file is related
to the ACPRODLST file, the ACPRODACCT file, and the ACPRODUSER file.

REFERENCED BY

BR124     BR153     BR154     BR155     BR157     BR250
BR252     BR253     BR31.2    BR31.4    BR51.1    BR51.2
BR52.1    BR52.4    BR52.5    BR53.1    BR53.2    BRPI.1

UPDATED BY

BR50.1    BR50.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BRQ-PRODUCT-LIST       Alpha 10                                  BR50.1
Element: Product List

BRQ-PRODUCT            Alpha 15                                  BR50.1
Element: Product

BRQ-PROD-VERSION       Alpha 10                                  BR50.1
Element: Prod Version

BRQ-STATUS             Alpha 1                                   BR50.1
Element: Status Cd     This field displays the status of the
                       transaction.
                       A = Active
                       I = Inactive

BRQ-DESCRIPTION        Alpha 30  (Lower Case)                    BR50.1
Element: Description   This field displays the description.

BRQ-MAINT-FLAG         Alpha 1                                   BR50.1
Element: Maint Flag    Y = Yes
                       N = No

BRQ-COST-BASIS         Alpha 1                                   BR50.1
Element: List Net Flag 1 = List
                       2 = Net

BRQ-MAINT-BASIS        Alpha 1                                   BR50.1
Element: List Net Flag 1 = List
                       2 = Net

BRQ-DECOM-DATE         Numeric 8  (yyyymmdd)                     BR50.1
Element: Date

                         ACPRODLSTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BRQSET1   PRODUCT-LIST                                           BR124   BR153
          PRODUCT                                                BR154   BR155
          PROD-VERSION                                           BR157   BR250
                                                                 BR252   BR253
                                                                 BR31.2  BR31.4
                                                                 BR50.1  BR50.2
                                                                 BR50.3  BR50.4
                                                                 BR50.5  BR51.1
                                                                 BR51.2  BR52.1
                                                                 BR52.4  BR52.5
                                                                 BR53.1  BR53.2
                                                                 BRPI.1

                         ACPRODLSTX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acprodlst      ACPRODLST    Required

                            BRQ-PRODUCT-LIST    -> BRP-PRODUCT-LIST

                         ACPRODLSTX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acprodacct     ACPRODACCT

                            BRQ-PRODUCT-LIST    -> BRR-PRODUCT-LIST
                            BRQ-PRODUCT         -> BRR-PRODUCT
                                                   BRR-RECORD-TYPE

Acproduser     ACPRODUSER

                            BRQ-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 Cst ACPRODUSER

                            "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 Prc ACPRODUSER

                            "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