Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             BUYERGRP FILE

                         PO Buyer Group Master

This file describes valid buyer group codes.  The buyer group description is
contained in this file.

REFERENCED BY

MA00.1    MA04.1    MA203     MA204     MA278     PO120
PO121     PO123     PO220     PO223     PO224     PO225
PO230     PO251     PO275     PO276     PO277     PO280
POA2.1

UPDATED BY

MA03.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BGP-COMPANY          Numeric 4                                   MA03.1
Company              The company number.

BGP-BUYER-GRP        Alpha 5                                     MA03.1
Buyer Group          The user-defined buyer group.

BGP-DESCRIPTION      Alpha 30  (Lower Case)                      MA03.1
Name                 The buyer group description.

                         BUYERGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BGPSET1   COMPANY                                                MA00.1  MA03.1
          BUYER-GRP                                              MA04.1  MA203
                                                                 MA204   MA278
                                                                 PO120   PO121
                                                                 PO123   PO220
                                                                 PO223   PO224
                                                                 PO225   PO230
                                                                 PO251   PO275
                                                                 PO276   PO277
                                                                 PO280   POA2.1

                         BUYERGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pocompany      POCOMPANY    Required

                            BGP-COMPANY    -> PCY-COMPANY