Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PROCUREGRP FILE

REFERENCED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    API1.1    CXCP.1    DR100     IC140     IC141
IC142     IC28.1    IC281     IC521     IC522     IC524
IC525     IC526     IC527     IC531     IC83.1    MA180
MA205     MA43.7    MA43.8    MA43.9    MA43.1    MA43.2
MA43.3    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA66.3    MA66.2    MA66.8    MA67.1    MA67.2
MA70.1    MAI1.1    PO01.1    PO02.1    PO03.1    PO04.1
PO04.2    PO04.3    PO04.4    PO05.1    PO06.1    PO100
PO101     PO12.1    PO122     PO125     PO13.1    PO131
PO15.1    PO15.2    PO150     PO16.1    PO16.2    PO20.1
PO202     PO203     PO204     PO206     PO21.2    PO21.3
PO21.4    PO21.5    PO212     PO213     PO215     PO216
PO22.1    PO224     PO225     PO226     PO227     PO228
PO23.1    PO23.5    PO23.6    PO24.1    PO25.1    PO25.2
PO25.3    PO25.4    PO25.6    PO25.7    PO25.8    PO254
PO26.1    PO27.1    PO27.2    PO27.3    PO27.4    PO28.1
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO33.1    PO34.1    PO35.1    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO54.4    PO550     PO560     PO72.1    PO813     POA1.1
POA10     POA2.2    POA2.4    POA3.1    POAX.1    POCP.1
POI3.1    POIE.1    POIF.1    POII.1    POIJ.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1    RQ140
RQ300     RQ35.1    RQ40.1    RQ41.1    RQ42.1    RQ44.1
RQ44.2    RQ500     RQ780     RQIB.1    RQIC.1    RQID.1
RQIF.1    RQIG.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     AP510     IC01.1    IC02.1    IC10.1
IC10.2    IC11.1    IC12.1    IC130     IC211     IC226
IC243     IC330     IC520     IC590     ICI1.1    MA278
MA53.1    PO10.1    PO10.2    PO120     PO220     PO223
PO230     PO251     PO275     PO276     PO277     PO280
RQ01.1    RQ810     RQIA.1    SEA2.1    AP00.4    AP10.1
AP10.2    AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.7    AP210     AP23.1    AP300     AP51.4    AP51.5
API3.1    API4.1    IC840     MA41.2    MA54.1    MA540
MA64.1    MA64.2    MA64.3    MA64.5    MA64.6    MA65.1
PO210

UPDATED BY

PO00.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

PCG-ITEM-GROUP       Alpha 5                                     PO00.1
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
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
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


PCG-BL-PO-CODE       Alpha 4                                     PO00.1
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
St 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
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  API1.1
                                                                 CXCP.1  DR100
                                                                 IC140   IC141
                                                                 IC142   IC28.1
                                                                 IC281   IC521
                                                                 IC522   IC524
                                                                 IC525   IC526
                                                                 IC527   IC531
                                                                 IC83.1  MA180
                                                                 MA205   MA43.7
                                                                 MA43.8  MA43.9
                                                                 MA530   MA531
                                                                 ...

PCGSET2   ITEM-GROUP    KeyChange                                AP125   AP126
                                                                 AP131   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP510
                                                                 DR100   IC01.1
                                                                 IC02.1  IC10.1
                                                                 IC10.2  IC11.1
                                                                 IC12.1  IC130
                                                                 IC141   IC142
                                                                 IC211   IC226
                                                                 IC243   IC28.1
                                                                 IC281   IC330
                                                                 IC520   IC521
                                                                 IC522   IC524
                                                                 IC525   IC526
                                                                 ...

PCGSET3   VENDOR-GROUP  KeyChange                                AP00.4  AP10.1
                                                                 AP10.2  AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP210   AP23.1
                                                                 AP300   AP51.4
                                                                 AP51.5  AP510
                                                                 API3.1  API4.1
                                                                 IC840   MA41.2
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA54.1
                                                                 MA540   MA61.1
                                                                 MA64.1  MA64.2
                                                                 MA64.3  MA64.5
                                                                 ...

                         PROCUREGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

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