Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROCUREGRP


                            PROCUREGRP FILE

REFERENCED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    CXCP.1    DR100     IC140     IC141
IC142     IC270     IC28.1    IC281     IC521     IC522
IC524     IC525     IC526     IC527     IC531     IC83.1
MA180     MA205     MA530     MA531     MA60.2    MA60.3
MA60.5    MA60.1    MA61.1    MA66.2    MA66.3    MA66.1
MA66.8    MA67.1    MA67.2    MA70.1    MA75.1    MA80.1
MAI1.1    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     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE81.1    OE810
OE830     OE90.1    OE90.2    PO01.1    PO02.1    PO03.1
PO04.1    PO04.2    PO04.3    PO04.4    PO05.1    PO06.1
PO100     PO101     PO115     PO12.1    PO122     PO125
PO13.1    PO131     PO137     PO15.1    PO15.2    PO150
PO16.1    PO16.2    PO20.1    PO202     PO203     PO204
PO206     PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO212     PO213     PO215     PO216     PO22.1    PO223
PO224     PO225     PO226     PO227     PO228     PO229
PO23.1    PO23.5    PO23.6    PO240     PO25.1    PO25.2
PO25.3    PO25.5    PO25.6    PO25.7    PO254     PO26.1
PO27.1    PO27.2    PO28.1    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    PO36.6    PO38.1
PO39.1    PO39.2    PO44.1    PO45.1    PO50.1    PO52.1
PO520     PO53.1    PO53.2    PO53.3    PO53.4    PO53.5
PO53.8    PO536     PO54.1    PO54.2    PO54.3    PO54.4
PO550     PO560     PO72.1    PO813     POA1.1    POA10
POA2.2    POA2.4    POA3.1    POAX.1    POCP.1    POI3.1
POI6.1    POID.1    POIE.1    POIF.1    POII.1    POIJ.1
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1
RQ13.2    RQ140     RQ300     RQ35.1    RQ40.1    RQ41.1
RQ42.1    RQ44.1    RQ44.2    RQ500     RQIB.1    RQIC.1
RQID.1    RQIF.1    RQIG.1    RQII.1    RQIJ.1    WH130
WH132     WH190     WH20.2    WH20.7    WH222     WH25.1
WH25.2    WH30.1    WH30.2    WH30.3    WH30.4    WH31.1
WH31.2    WH31.3    WH31.4    WH32.1    WH32.2    WH32.3
WH32.4    WH33.1    WH33.2    WH33.3    WH33.4    WH33.5
WH33.6    WH33.8    WH33.9    WH34.1    WH34.2    WH34.3
WH34.4    WH40.1    WH40.2    WH520     WH830     WO132
WO140     AP510     IC00.1    IC01.1    IC02.1    IC10.1
IC10.2    IC11.1    IC12.1    IC211     IC226     IC243
IC330     IC520     IC590     IC800     ICI1.1    MA278
MA53.1    PO10.1    PO10.2    PO120     PO220     PO230
PO251     PO275     PO276     PO277     PO280     RQ01.1
RQ810     RQIA.1    AM115     AM117     AM15.1    AM15.2
AM15.3    AM15.4    AM20.1    AM20.3    AM21.1    AM21.3
AM500     AM51.1    AM551     AM97.1    AP00.4    AP10.1
AP10.2    AP210     AP300     AP51.4    AP51.5    API3.1
API4.1    IC840     MA54.1    MA540     MA64.1    MA64.2
MA64.3    MA64.5    MA64.6    MA65.1    PO210     PR05.1
PR05.3    PR226     PR247     PR26.1    PR47.1    UK47.1

UPDATED BY

PO00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCG-PROCURE-GROUP      Alpha 4                                   MA540   MA61.1
Element: Procure Group This field contains the identifier for a  MA65.1  PO00.1
                       group of companies that share a common    PO210
                       procurement effort. They buy items and
                       services together.

PCG-PROC-GRP-DESC      Alpha 30                                  PO00.1
Element: Proc Grp Desc

PCG-ITEM-GROUP         Alpha 5                                   PO00.1
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.

PCG-VENDOR-GROUP       Alpha 4                                   PO00.1
Element: Vendor Group  A vendor group represents a group of
                       vendors that can be shared by one or
                       more companies.

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

PCG-BL-PO-CODE         Alpha 4                                   PO00.1
Element: Bl Po Code    PO Code that will default on a "blanket"
                       price agreement that is defined at the
                       procurement group level.

PCG-ST-PO-CODE         Alpha 4                                   PO00.1
Element: Po Code       PO Code that will default on a "standing
                       order" price agreement that is defined
                       at the procurement group level.

PCG-SV-PO-CODE         Alpha 4                                   PO00.1
Element: Sv Po Code    PO Code that will default on a
                       "services" price agreement that is
                       defined at the procurement group level.

                         PROCUREGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCGSET1   PROCURE-GROUP                                          AP125   AP126
                                                                 AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 CXCP.1  DR100
                                                                 IC140   IC141
                                                                 IC142   IC270
                                                                 IC28.1  IC281
                                                                 IC521   IC522
                                                                 ...

PCGSET2   ITEM-GROUP    KeyChange                                AP125   AP126
                                                                 AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  DR100
                                                                 IC00.1  IC01.1
                                                                 IC02.1  IC10.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC141
                                                                 ...

PCGSET3   VENDOR-GROUP  KeyChange                                AM115   AM117
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.4  AP10.1
                                                                 AP10.2  AP131
                                                                 AP210   AP300
                                                                 AP51.4  AP51.5
                                                                 AP510   API3.1
                                                                 API4.1  IC840
                                                                 MA54.1  MA540
                                                                 MA60.1  MA60.2
                                                                 ...

                         PROCUREGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            PCG-ITEM-GROUP    -> ITG-ITEM-GROUP