Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPRODLST


                             ACPRODLST FILE

The ACPRODLST file contains the product list name and description. The product
list groups all products by currency. Records in this file are primarily
maintained on Define Product List (BR50.2). The ACPRODLST (product list
header) file is related to the ACPRODLSTX (product list detail) file in a one
to many relationship through the PRODUCT-LIST field.

REFERENCED BY

BR155     BR250     BR252     BR51.1    BR51.2    BR52.1
BR52.2    BR52.5

UPDATED BY

BR50.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BRP-PRODUCT-LIST       Alpha 10                                  BR50.3
Element: Product List

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

BRP-CURRENCY-CODE      Alpha 5                                   BR50.3
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

                         ACPRODLST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BRPSET1   PRODUCT-LIST                                           BR155   BR250
                                                                 BR252   BR50.1
                                                                 BR50.2  BR50.3
                                                                 BR50.4  BR50.5
                                                                 BR51.1  BR51.2
                                                                 BR52.1  BR52.2
                                                                 BR52.5

                         ACPRODLST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acprodlstx     ACPRODLSTX

                            BRP-PRODUCT-LIST    -> BRQ-PRODUCT-LIST
                                                   BRQ-PRODUCT
                                                   BRQ-PROD-VERSION