PROCUREGRP – Procurement Group

System
Purchase Order (PO)
Prefix
PCG
Primary key
PROCURE-GROUP
Fields
31
Updated by
1 program
Referenced by
468 programs

PROCUREGRP is the Procurement Group table in Lawson Purchase Order (prefix PCG). It is indexed by PROCURE-GROUP (PCGSET1); alternate indexes: PCGSET2 and PCGSET3. It is related 1:1 to ITEMGROUP. It is updated by PO00.1 and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 460 more. The table has 31 fields, 3 indexes and 1 documented relation.

About PROCUREGRP

No description in the Lawson data dictionary.

Fields (31)

Column = COBOL field name without the PCG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PCG-PROCURE-GROUP PK
PROCURE_GROUP
Alpha 4Type or select a procurement group. A procurement group is 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 +19 more
PCG-PROC-GRP-DESC
PROC_GRP_DESC
Alpha 30PO00.1, PO514
PCG-ITEM-GROUP
ITEM_GROUP
Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.PO00.1
PCG-VENDOR-GROUP
VENDOR_GROUP
Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.PO00.1
PCG-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).PO00.1
PCG-BL-PO-CODE
BL_PO_CODE
Alpha 4PO Code that will default on a "blanket" price agreement that is defined at the procurement group level.PO00.1
PCG-ST-PO-CODE
ST_PO_CODE
Alpha 4PO Code that will default on a "standing order" price agreement that is defined at the procurement group level.PO00.1
PCG-SV-PO-CODE
SV_PO_CODE
Alpha 4PO Code that will default on a "services" price agreement that is defined at the procurement group level.PO00.1
PCG-TEMPL-SPECIAL
TEMPL_SPECIAL
Alpha 1PO00.1
PCG-LAST-TERM-COND
LAST_TERM_COND
Numeric 8
PCG-LAST-ARTICLE
LAST_ARTICLE
Numeric 8
PCG-LAST-ART-DISP
LAST_ART_DISP
Numeric 8
PCG-LAST-QUESTION
LAST_QUESTION
Numeric 8
PCG-LAST-CONTACT
LAST_CONTACT
Numeric 8
PCG-AUDIT-PIV-FL
AUDIT_PIV_FL
Numeric 1
  • 0 No
  • 1 Yes
PO00.1
PCG-AUDIT-AGMT-FL
AUDIT_AGMT_FL
Numeric 1
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-AOC-CT
INCL_AOC_CT
Numeric 1Include Catalog Add-On Charge in Lifetime Maximum calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-AOC-BL
INCL_AOC_BL
Numeric 1Include Blanket Add-On Charge amount in the Lifetime Maximum AOC calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-AOC-CN
INCL_AOC_CN
Numeric 1Include Contract Add-On Charge amount in the Lifetime Maximum Amount calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-AOC-SV
INCL_AOC_SV
Numeric 1Include Service Add-On Charge amount in the Lifetime Maximum AOC calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-AOC-ST
INCL_AOC_ST
Numeric 1Include Standing Order Add-On Charge amount in the Lifetime Maximum AOC calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-TAX-CT
INCL_TAX_CT
Numeric 1Include Catalog Tax amount in the Lifetime Maximum Tax calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-TAX-BL
INCL_TAX_BL
Numeric 1Include Blanket Tax amount in the Lifetime Maximum Tax calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-TAX-CN
INCL_TAX_CN
Numeric 1Include Contract Tax Amount in the Lifetime Maximum Tax calculation for this procurement groupPO00.1
PCG-INCL-TAX-SV
INCL_TAX_SV
Numeric 1Include Service Tax Amount in the Lifetime Maximum Tax calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-INCL-TAX-ST
INCL_TAX_ST
Numeric 1Include Standing Order Tax Amount in the Lifetime Maximum Tax calculation for this procurement group
  • 0 No
  • 1 Yes
PO00.1
PCG-AUDIT-PO-COMP
AUDIT_PO_COMP
Numeric 1Audit changes to the PO company setup.
  • 0 No
  • 1 Yes
PO00.1
PCG-AUDIT-PCARDS
AUDIT_PCARDS
Numeric 1
  • 0 No
  • 1 Yes
PO00.1
PCG-AUDIT-PO-VEND
AUDIT_PO_VEND
Numeric 1
  • 0 No
  • 1 Yes
PO00.1
PCG-AUDIT-PROC-TMP
AUDIT_PROC_TMP
Numeric 1PO00.1
PCG-MAINTENANCE-FL
MAINTENANCE_FL
Numeric 1
  • 1 Yes
  • 0 No
PO00.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCGSET1PROCURE-GROUPPrimaryAP125, AP126, AP131, AP133, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
PCGSET2ITEM-GROUPKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PCGSET3VENDOR-GROUPKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequiredPCG-ITEM-GROUPITG-ITEM-GROUP

Programs

Updated by (1)

Referenced by (468)