APVENGROUP – Vendor Group

System
Accounts Payable (AP)
Prefix
VGP
Primary key
VENDOR-GROUP
Fields
28
Updated by
292 programs
Referenced by
302 programs

APVENGROUP is the Vendor Group table in Lawson Accounts Payable (prefix VGP). It is indexed by VENDOR-GROUP (VGPSET1). It is related 1:M to APCOMPANY, APHOLDCODE, APVENCLASS and APVENMAST. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 284 more and referenced by AC03.4, AC03.7, AC145, AC17.4, AC18.3, AC191, AC203, AC210 and 294 more. The table has 28 fields, 1 index and 5 documented relations.

About APVENGROUP

The Vendor Group file contains all vendor group records in the Lawson Accounts Payable system. A vendor group represents a group of vendors that can be shared by one or more accounts payable companies.

Fields (28)

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

Field / columnTypeDescription & valuesUpdated by
VGP-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4A user-defined code used to identify a set of vendors shared by one or more accounts payable companies.AP00.1, AP100
VGP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The name or description of the vendor group.AP00.1, AP135
VGP-VENDOR-AUDIT
VENDOR_AUDIT		Alpha 1Indicates whether to create vendor audit records when vendors within this vendor group are added, changed, or deleted. Valid values are:
  • N No.
  • Y Yes.
AP00.1
VGP-NUM-VEN-NBR
NUM_VEN_NBR		Alpha 1Indicates whether vendors added to this vendor group will have alphanumeric or numeric vendor identification numbers. Valid values are:
  • A Alpha.
  • N Numeric.
AP00.1
VGP-AUTO-VENDOR
AUTO_VENDOR		Alpha 1Indicates whether vendor numbers are automatically assigned in numeric order when vendors are added for the vendor group. Used only if the vendor group has Numeric selected in the Vendor Values field. Valid values are:
  • N No.
  • Y Yes.
AP00.1
VGP-LAST-VENDOR
LAST_VENDOR		Numeric 9The last vendor number used. Used only if the vendor group has Yes selected in the Auto Vendor Numbering field. Used as a starting point for continuing to number vendors automatically as they are added into to the Lawson Accounts Payable system. If left blank, automatic vendor numbering begins with 1.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VGP-LAST-ONE-VEN
LAST_ONE_VEN		Numeric 9The last one-time vendor number added to the Lawson Accounts Payable system. Vendor numbers 999000001 through 999999999 are reserved for one-time vendor numbering.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VGP-MANP-HOLD
MANP_HOLD		Alpha 4The hold code used to place an invoice on hold for manual payment. Creates a record in the Hold Code file. If left blank, MPAY defaults.AP00.1
VGP-CRED-HOLD
CRED_HOLD		Alpha 4The hold code used to place an invoice on hold when the vendor has a credit balance. Creates a record in the Hold Code file. If left blank, CRED defaults.AP00.1
VGP-PREP-HOLD
PREP_HOLD		Alpha 4The hold code used to place an invoice on hold when the invoice is created as a prepayment. Creates a record in the Hold Code file. If left blank, PREP defaults.AP00.1
VGP-ROI-HOLD
ROI_HOLD		Alpha 4The hold code used to place an invoice on hold when it is held due to return on investment calculations. Creates a record in the Hold Code file. If left blank, ROI defaults.AP00.1
VGP-MAXP-HOLD
MAXP_HOLD		Alpha 4The hold code used to place an invoice on hold when the maximum payment amount for a vendor is exceeded. Creates a record in the Hold Code file. If left blank, MAX defaults.AP00.1
VGP-PER-END-DATE
PER_END_DATE		Numeric 8 (yyyymmdd) Occurs 13 Times ×13The period ending date of each period of the current vendor group year.AP00.1, AP199
VGP-GRP-END-DTE-01
GRP_END_DTE_01		DerivedThe period ending date of the first period of the current vendor group year.—
VGP-GRP-END-DTE-02
GRP_END_DTE_02		DerivedThe period ending date of the second period of the current vendor group year.—
VGP-GRP-END-DTE-03
GRP_END_DTE_03		DerivedThe period ending date of the third period of the current vendor group year.—
VGP-GRP-END-DTE-04
GRP_END_DTE_04		DerivedThe period ending date of the fourth period of the current vendor group year.—
VGP-GRP-END-DTE-05
GRP_END_DTE_05		DerivedThe period ending date of the fifth period of the current vendor group year.—
VGP-GRP-END-DTE-06
GRP_END_DTE_06		DerivedThe period ending date of the sixth period of the current vendor group year.—
VGP-GRP-END-DTE-07
GRP_END_DTE_07		DerivedThe period ending date of the seventh period of the current vendor group year.—
VGP-GRP-END-DTE-08
GRP_END_DTE_08		DerivedThe period ending date of the eighth period of the current vendor group year.—
VGP-GRP-END-DTE-09
GRP_END_DTE_09		DerivedThe period ending date of the ninth period of the current vendor group year.—
VGP-GRP-END-DTE-10
GRP_END_DTE_10		DerivedThe period ending date of the tenth period of the current vendor group year.—
VGP-GRP-END-DTE-11
GRP_END_DTE_11		DerivedThe period ending date of the eleventh period of the current vendor group year.—
VGP-GRP-END-DTE-12
GRP_END_DTE_12		DerivedThe period ending date of the twelfth period of the current vendor group year.—
VGP-GRP-END-DTE-13
GRP_END_DTE_13		DerivedThe period ending date of the thirteenth period of the current vendor group year.—
VGP-RET-HOLD
RET_HOLD		Alpha 4—AP00.1
VGP-MINP-HOLD
MINP_HOLD		Alpha 4—AP00.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
VGPSET1VENDOR-GROUPPrimaryAC03.4, AC03.7, AC145, AC160, AC17.4, AC18.3, AC191, AC203 +22 more (list truncated in source)

Relations

One to many (5) — child tables

RelationTableRulesConditionField map
ApcompanyAPCOMPANYVGP-VENDOR-GROUP → CPY-VENDOR-GROUP, → CPY-COMPANY
ApholdcodeAPHOLDCODEVGP-VENDOR-GROUP → HLD-VENDOR-GROUP, → HLD-HLD-CODE
ApvendclassAPVENCLASSDelete CascadesVGP-VENDOR-GROUP → VCL-VENDOR-GROUP, → VCL-VEN-CLASS
ApvendmastAPVENMASTDelete CascadesVGP-VENDOR-GROUP → VEN-VENDOR-GROUP, → VEN-VENDOR
ApvendmastaAPVENMASTVGP-VENDOR-GROUP → VEN-VENDOR-GROUP, → VEN-VENDOR-SNAME, → VEN-VENDOR

Programs

Updated by (292)

Referenced by (302)