Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             BUYCLASS FILE

                       PO Buyer Purch Class Auth

This optional file defines valid item major and minor purchasing classes for
a buyer.

REFERENCED BY

BL92.1    IN20.1    MA204     OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE113     OE114
OE129     OE14.4    OE15.1    OE15.2    OE15.3    OE15.4
OE15.5    OE15.7    OE510     OE810     OE920     PO100
PO20.1    PO22.1    PO22.3    RQ20.1    RQ20.3    RQ20.4
WH20.2    WH20.7

UPDATED BY

MA04.1    MA04.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BCL-COMPANY          Numeric 4                                   MA04.2
Company              The company number.

BCL-BUYER-CODE       Alpha 3                                     MA04.2
Buyer Code           The user defined buyer identifier.

BCL-PURCH-MAJCL      Alpha 4                                     MA04.2
Major Purchasing     The user-defined major purchasing class
Class                identifier.

BCL-PURCH-MINCL      Alpha 4                                     MA04.2
Minor Purchasing     The user-defined minor purchasing class
Class                identifier.

                         BUYCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCLSET1   COMPANY                                                BL92.1  IN20.1
          BUYER-CODE                                             MA04.1  MA04.2
          PURCH-MAJCL                                            MA204   OE10.1
          PURCH-MINCL                                            OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 OE15.5  OE15.7
                                                                 OE510   OE810
                                                                 ...

                         BUYCLASS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Buyer          BUYER        Required

                            BCL-COMPANY        -> BUY-COMPANY
                            BCL-BUYER-CODE     -> BUY-BUYER-CODE

Iccompany      ICCOMPANY    Required

                            BCL-COMPANY        -> ICC-COMPANY

Majorcl        MAJORCL      Required

                            ICC-ITEM-GROUP     -> MAJ-ITEM-GROUP
                            "P"                -> MAJ-CLASS-TYPE
                            BCL-PURCH-MAJCL    -> MAJ-MAJOR-CLASS

Minorcl        MINORCL      Required
                            When BCL-PURCH-MINCL != Spaces

                            ICC-ITEM-GROUP     -> MIN-ITEM-GROUP
                            "P"                -> MIN-CLASS-TYPE
                            BCL-PURCH-MAJCL    -> MIN-MAJOR-CLASS
                            BCL-PURCH-MINCL    -> MIN-MINOR-CLASS