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     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    AP30.1    AP30.2
API1.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    CXCP.1    MA180     MA205     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.6
MA43.7    MA43.4    MA53.1    MA530     MA531     MA60.2
MA60.3    MA60.5    MA60.1    MA61.1    MA66.2    MA66.3
MA66.1    MA66.8    MA67.2    MA67.3    MA68.2    MA68.3
MA68.5    MA68.1    MA70.1    MA75.1    MA80.1    MAI1.1
PD01.1    PD04.1    PD06.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PD21.1    PD235     PD570
PO01.1    PO02.1    PO03.1    PO04.1    PO04.2    PO04.3
PO04.4    PO04.5    PO05.1    PO06.1    PO07.1    PO100
PO101     PO115     PO12.1    PO122     PO125     PO13.1
PO131     PO137     PO15.1    PO15.2    PO150     PO16.1
PO16.2    PO190     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    PO24.1    PO240     PO25.1
PO25.2    PO25.3    PO25.5    PO25.6    PO25.7    PO253
PO254     PO26.1    PO27.1    PO27.2    PO28.1    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO32.4    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    PO53.9    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    RQ35.1
RQ500     RQIB.1    RQIC.1    RQID.1    RQIF.1    RQIG.1
RQII.1    RQIJ.1    WH130     WH132     WH190     WH20.2
WH20.7    WH222     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
AP510     IC00.1    IC01.1    IC02.1    IC11.1    IC12.1
IC14.1    IC211     IC330     IC800     ICI1.1    MA278
PO10.1    PO10.2    PO120     PO220     PO230     PO234
PO251     PO275     PO276     PO277     PO280     MM280
MM80.1    MM80.2    RQ01.1    RQ44.1    RQ810     RQIA.1
RQIH.1    AC160     AM115     AM117     AM15.1    AM15.2
AM15.3    AM15.4    AM19.1    AM19.2    AM20.1    AM20.3
AM21.1    AM21.3    AM500     AM51.1    AM551     AM97.1
AP00.4    AP03.3    AP10.1    AP10.2    AP110     AP115
AP14.4    AP210     AP220     AP300     AP305     AP51.4
AP51.5    AP52.1    AP520     AP90.1    AP90.4    AP91.1
API2.1    API3.1    API4.1    MX123     MX500     MA279
MA54.1    MA54.2    MA540     MA63.1    MA64.1    MA64.2
MA64.3    MA64.5    MA64.6    MA65.1    MA69.1    PO210
PO233     PO278     PR05.1    PR05.3    PR226     PR247
PR26.1    PR47.1    PR514     UK47.1

UPDATED BY

PO00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCG-PROCURE-GROUP      Alpha 4                                   AP20.1  AP20.2
Element: Procure Group This field contains the identifier for    AP20.3  AP20.4
                       a group of companies that share a common  AP20.5  AP20.7
                       procurement effort. They buy items and    AP21.1  AP23.1
                       services together.                        AP30.1  AP30.2
                                                                 AP300   AP52.1
                                                                 AP520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA54.2  MA540
                                                                 MA61.1  MA65.1
                                                                 PO00.1  PO210

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   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 ...

PCGSET2   ITEM-GROUP    KeyChange                                AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

PCGSET3   VENDOR-GROUP  KeyChange                                AC160   AM115
                                                                 AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.4
                                                                 AP03.3  AP10.1
                                                                 AP10.2  AP110
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP14.4  AP20.1
                                                                 AP20.2  AP20.3
                                                                 ...

                         PROCUREGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

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