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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 30—PO00.1, PO514
#PCG-ITEM-GROUP SET2
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 SET3
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 1—PO00.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 1—PO00.1
#PCG-MAINTENANCE-FL
MAINTENANCE_FL
Numeric 1—
  • 1 Yes
  • 0 No
PO00.1

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCGSET1
  1. PROCURE-GROUP
PrimaryAP125, AP126, AP131, AP133, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
PCGSET2
  1. ITEM-GROUP
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PCGSET3
  1. VENDOR-GROUP
KeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ITEMGROUPPROCUREGRP

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequired
PCG-ITEM-GROUP→ITG-ITEM-GROUP

Programs

Updated by (1)

Referenced by (468)