PROCUREGRP

REFERENCED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP00.4 AP03.3 AP10.1 AP10.2 AP110 AP115
AP125 AP126 AP131 AP133 AP150 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP210 AP220 AP23.1 AP233 AP25.1 AP25.2
AP26.1 AP27.1 AP271 AP30.1 AP30.2 AP30.4
AP300 AP305 AP510 AP52.1 AP520 AP90.1
AP90.4 AP91.1 AP97.1 API1.1 API2.1 API3.1
API4.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX205 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC00.1 IC02.1 IC10.1 IC10.2 IC11.1
IC12.1 IC14.1 IC140 IC141 IC142 IC145
IC175 IC211 IC216 IC226 IC243 IC270
IC281 IC282 IC330 IC520 IC521 IC522
IC524 IC525 IC526 IC527 IC590 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 IC840 ICI1.1
ICI9.1 ZC522 MX123 MX500 MA180 MA205
MA278 MA279 MA41.1 MA41.2 MA41.4 MA41.7
MA42.1 MA42.2 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA54.1 MA54.2 MA540 MA60.1 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA64.1 MA64.2
MA64.3 MA64.5 MA64.6 MA64.9 MA65.1 MA66.1
MA66.2 MA66.3 MA66.8 MA67.2 MA67.3 MA68.1
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD01.1 PD06.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD21.1 PD235
PD570 PO01.1 PO04.1 PO04.2 PO04.3 PO04.4
PO04.5 PO100 PO101 PO115 PO12.1 PO120
PO122 PO125 PO13.1 PO13.3 PO131 PO136
PO137 PO15.1 PO15.2 PO15.4 PO150 PO16.1
PO16.2 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO210
PO213 PO215 PO216 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO222 PO223 PO224
PO225 PO227 PO228 PO229 PO23.1 PO23.5
PO23.6 PO230 PO233 PO234 PO24.1 PO25.1
PO25.2 PO25.3 PO25.5 PO25.6 PO25.7 PO251
PO253 PO254 PO26.1 PO26.2 PO26.3 PO26.4
PO26.5 PO26.6 PO26.7 PO26.8 PO26.9 PO27.1
PO27.2 PO275 PO276 PO277 PO278 PO28.1
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO525 PO53.1 PO53.2 PO53.3
PO53.4 PO53.5 PO53.8 PO53.9 PO536 PO54.1
PO54.2 PO54.3 PO54.4 PO54.5 PO550 PO560
PO813 POA3.1 POCP.1 POI3.1 POI6.1 POID.1
POIE.1 POIF.1 POIH.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 MM280 MM80.1 MM80.2 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ44.1 RQ500 RQ504
RQ810 RQIA.1 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIH.1 RQII.1 RQIJ.1 PO983 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 WH32.5
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 ZW130 PD00.1
PD04.1 PO02.1 PO03.1 PO05.1 PO06.1 PO07.1
PO202 PO203 PO206 PO212 PO226 PO240
PO72.1 POA1.1 POA10 POA2.2 POA2.4 POAX.1
IC01.1 IC258 IC58.1 IC58.2 IC58.3


UPDATED BY
AP51.4 AP51.5 IC800 PO00.1 PO10.1 PO10.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCG-PROCURE-GROUP
Element: Procure Group		Alpha 4
This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP30.1 AP30.2
AP300 AP52.1
AP520 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA54.2
MA540 MA61.1
MA65.1 PO00.1
PO210
PCG-PROC-GRP-DESC
Element: Proc Grp Desc		Alpha 30
PO00.1
PCG-ITEM-GROUP
Element: Item Group		Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
PO00.1
PCG-VENDOR-GROUP
Element: Vendor Group		Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
PO00.1
PCG-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PO00.1
PCG-BL-PO-CODE
Element: Bl Po Code		Alpha 4
PO Code that will default on a "blanket" price agreement that is defined at the procurement group level.
PO00.1
PCG-ST-PO-CODE
Element: Po Code		Alpha 4
PO Code that will default on a "standing order" price agreement that is defined at the procurement group level.
PO00.1
PCG-SV-PO-CODE
Element: Sv Po Code		Alpha 4
PO Code that will default on a "services" price agreement that is defined at the procurement group level.
PO00.1
PCG-TEMPL-SPECIAL
Element: All Flag		Alpha 1
PO00.1
PCG-LAST-TERM-COND
Element: Last Land Seq		Numeric 8
PCG-LAST-ARTICLE
Element: Last Land Seq		Numeric 8
PCG-LAST-ART-DISP
Element: Last Land Seq		Numeric 8
PCG-LAST-QUESTION
Element: Last Land Seq		Numeric 8
PCG-LAST-CONTACT
Element: Last Land Seq		Numeric 8


PROCUREGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCGSET1 PROCURE-GROUP
...
AP125 AP126
AP131 AP133
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
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 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
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300
CX506 CXCP.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 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.4 AP03.3
AP10.1 AP10.2
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2


PROCUREGRP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Required
PCG-ITEM-GROUP->ITG-ITEM-GROUP

File created: Thu Jun 09 11:25:19 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.