Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PROCUREGRP FILE

REFERENCED BY

CXCP.1    DR100     IC140     IC141     IC142     IC281
IC521     IC522     IC524     IC525     IC526     IC527
IC531     IC83.1    MA205     PO01.1    PO02.1    PO03.1
PO04.1    PO04.2    PO04.3    PO04.4    PO05.1    PO06.1
PO12.1    PO125     PO13.1    PO15.1    PO15.2    PO16.1
PO16.2    PO202     PO203     PO204     PO206     PO212
PO213     PO215     PO216     PO225     PO226     PO227
PO228     PO24.1    PO26.1    PO28.1    PO550     PO560
PO72.1    POA2.1    POA2.2    POA2.3    POA2.4    POA3.1
POAX.1    POCP.1    POIF.1    POIJ.1    RQ11.1    RQ12.1
RQ13.1    RQ140     RQ300     RQ40.1    RQ41.1    RQ42.1
RQ44.1    RQ44.2    RQ780     WH130     WH33.1    WH33.2
WH33.3    WH33.4    WH33.5    WH33.6    WH33.8    WH33.9
WH34.1    WH34.2    WH34.3    WH34.4    AP510     IC01.1
IC02.1    IC11.1    IC12.1    IC130     IC211     IC226
IC330     IC520     IC590     ICI1.1    MA278     MA53.1
PO10.1    PO10.2    PO120     PO220     PO223     PO224
PO230     PO251     PO275     PO276     PO277     PO280
PO61.1    RQ01.1    RQ810     SEA2.1    AP00.4    AP10.1
AP10.2    AP210     AP300     AP51.4    AP51.5    API3.1
API4.1    MA54.1    MA65.1    PO210

UPDATED BY

PO00.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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                                          CXCP.1  DR100
                                                                 IC140   IC141
                                                                 IC142   IC281
                                                                 IC521   IC522
                                                                 IC524   IC525
                                                                 IC526   IC527
                                                                 IC531   IC83.1
                                                                 MA205   PO00.1
                                                                 PO01.1  PO02.1
                                                                 PO03.1  PO04.1
                                                                 PO04.2  PO04.3
                                                                 PO04.4  PO05.1
                                                                 PO06.1  PO12.1
                                                                 PO125   PO13.1
                                                                 PO15.1  PO15.2
                                                                 ...

PCGSET2   ITEM-GROUP    KeyChange                                AP510   DR100
                                                                 IC01.1  IC02.1
                                                                 IC11.1  IC12.1
                                                                 IC130   IC141
                                                                 IC142   IC211
                                                                 IC226   IC281
                                                                 IC330   IC520
                                                                 IC521   IC522
                                                                 IC524   IC525
                                                                 IC526   IC527
                                                                 IC590   IC83.1
                                                                 ICI1.1  MA278
                                                                 MA53.1  PO00.1
                                                                 PO10.1  PO120
                                                                 PO15.1  PO15.2
                                                                 ...

PCGSET3   VENDOR-GROUP  KeyChange                                AP00.4  AP10.1
                                                                 AP10.2  AP210
                                                                 AP300   AP51.4
                                                                 AP51.5  AP510
                                                                 API3.1  API4.1
                                                                 MA54.1  MA65.1
                                                                 PO00.1  PO10.1
                                                                 PO10.2  PO210

                         PROCUREGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

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