Lawson Insight Technical Documentation

                            ACPRODLSTX 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    BR570
BR70.1    BR70.2    BRIP.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     Status Code.
                       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          This field displays the system date
                       when this was created.

                         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
                                                                 BR570   BR70.1
                                                                 BR70.2  BRIP.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