Lawson Insight Technical Documentation |
|
PROCUREGRP
PROCUREGRP FILE
REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 AP30.1 API1.1 CXCP.1
DR100 IC140 IC141 IC142 IC270 IC28.1
IC281 IC521 IC522 IC524 IC525 IC526
IC527 IC531 IC83.1 MA180 MA205 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.7 MA43.8
MA43.9 MA530 MA531 MA60.2 MA60.3 MA60.5
MA60.1 MA61.1 MA66.2 MA66.3 MA66.1 MA66.8
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
PO01.1 PO02.1 PO03.1 PO04.1 PO04.2 PO04.3
PO04.4 PO05.1 PO06.1 PO100 PO101 PO115
PO12.1 PO122 PO125 PO13.1 PO131 PO137
PO15.1 PO15.2 PO150 PO16.1 PO16.2 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
PO25.1 PO25.2 PO25.3 PO25.5 PO25.6 PO25.7
PO254 PO26.1 PO27.1 PO27.2 PO28.1 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 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 PO536 PO54.1 PO54.2
PO54.3 PO54.4 PO550 PO560 PO72.1 PO737
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 RQ140 RQ300 RQ35.1
RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ500
RQ780 RQIB.1 RQIC.1 RQID.1 RQIE.1 RQIF.1
RQIG.1 RQII.1 RQIJ.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 WO132 WO140 AP510
IC00.1 IC01.1 IC02.1 IC10.1 IC10.2 IC11.1
IC12.1 IC211 IC226 IC243 IC330 IC520
IC590 IC800 ICI1.1 MA278 MA53.1 PO10.1
PO10.2 PO120 PO220 PO230 PO251 PO275
PO276 PO277 PO280 RQ01.1 RQ810 RQIA.1
RQIH.1 SEA2.1 AM115 AM15.1 AM15.2 AM15.3
AM15.4 AM20.1 AM20.3 AM21.1 AM21.3 AM500
AM51.1 AM551 AM97.1 AP00.4 AP10.1 AP10.2
AP210 AP300 AP51.4 AP51.5 AP90.4 API3.1
API4.1 IC840 MA54.1 MA540 MA64.1 MA64.2
MA64.3 MA64.5 MA64.6 MA65.1 PO210 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 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
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC140 IC141
IC142 IC270
IC28.1 IC281
IC521 IC522
IC524 IC525
IC526 IC527
...
PCGSET2 ITEM-GROUP KeyChange AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP510
API1.1 DR100
IC00.1 IC01.1
IC02.1 IC10.1
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC211 IC226
...
PCGSET3 VENDOR-GROUP KeyChange AM115 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.4
AP10.1 AP10.2
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP210
AP23.1 AP30.1
AP300 AP51.4
AP51.5 AP510
...
PROCUREGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Required
PCG-ITEM-GROUP -> ITG-ITEM-GROUP
|