Lawson Insight Technical Documentation |
|
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
|