Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BUYCLASS


                             BUYCLASS FILE

                       PO Buyer Purch Class Auth

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

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    AP510     API1.1    DR100
IC12.1    IC141     IC142     IC28.1    IC330     IC83.1
MA180     MA278     MA41.2    MA41.7    MA43.1    MA43.2
MA43.3    MA43.9    MA53.1    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.1
MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1    PO10.1
PO100     PO101     PO115     PO120     PO122     PO131
PO15.1    PO15.2    PO150     PO20.1    PO204     PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO220
PO224     PO225     PO229     PO23.1    PO23.5    PO230
PO25.1    PO25.5    PO25.6    PO25.7    PO251     PO27.2
PO275     PO276     PO277     PO280     PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POII.1    POIJ.1    RQ01.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ35.1    RQ44.1    RQ500
RQ810     RQIB.1    RQIC.1    RQIE.1    RQIF.1    RQIG.1
RQII.1    RQIJ.1    WH20.2    WH20.7

UPDATED BY

PO04.1    PO04.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BCL-PROCURE-GROUP      Alpha 4                                   PO04.2
Element: Procure Group This field contains the identifier for a
                       group of companies that share a common
                       procurement effort. They buy items and
                       services together.

BCL-BUYER-CODE         Alpha 3                                   PO04.2
Element: Buyer

BCL-PURCH-MAJCL        Alpha 4                                   PO04.2
Element: Major Class   The user-defined major purchasing class
                       identifier.

BCL-PURCH-MINCL        Alpha 4                                   PO04.2
Element: Minor Class   The user-defined minor purchasing class
                       identifier.

                         BUYCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCLSET1   PROCURE-GROUP                                          AP125   AP126
          BUYER-CODE                                             AP131   AP20.1
          PURCH-MAJCL                                            AP20.2  AP20.3
          PURCH-MINCL                                            AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 ...

                         BUYCLASS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Majorcl        MAJORCL      Required

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

Minorcl        MINORCL      Required

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

Procuregrp     PROCUREGRP   Required

                            BCL-PROCURE-GROUP    -> PCG-PROCURE-GROUP