APVENGROUP

Vendor Group

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.

REFERENCED BY
AC03.4 AC03.7 AC145 AC17.4 AC18.3 AC191
AC203 AC210 AC217 AC218 AC297 AC41.1
AC41.4 AC42.1 AC440 AC46.1 AC50.1 AC500
AC52.1 AC520 AC54.1 AC540 AC69.2 AC92.2
AC92.4 AC92.6 ACAC.1 AP02.1 AP05.4 AP10.1
AP10.2 AP10.3 AP10.5 AP10.6 AP10.7 AP10.9
AP102 AP109 AP11.1 AP111 AP12.1 AP130
AP135 AP14.1 AP14.2 AP14.3 AP14.4 AP14.5
AP141 AP144 AP145 AP146 AP151 AP16.1
AP16.2 AP170 AP180 AP181 AP190 AP191
AP193 AP197 AP205 AP211 AP212 AP221
AP230 AP233 AP240 AP245 AP250 AP251
AP252 AP270 AP272 AP28.1 AP290 AP295
AP32.1 AP33.1 AP35.1 AP36.2 AP40.1 AP40.2
AP41.1 AP45.1 AP45.3 AP45.4 AP51.1 AP51.2
AP51.3 AP51.4 AP51.5 AP51.6 AP51.8 AP52.1
AP52.2 AP52.3 AP52.7 AP520 AP54.1 AP55.1
AP55.2 AP56.1 AP56.2 AP57.2 AP58.1 AP590
AP92.1 AP92.3 AP92.4 AP93.1 AP93.3 AP93.4
AP95.1 AP95.2 AP95.3 AP96.1 AP97.1 AR01.1
AR08.1 AR09.1 AR09.8 AR10.1 AR501 AR550
ARLL.1 BR40.3 BR43.1 BR46.1 BRIP.1 CB06.2
CB10.1 CB150 CB180 CB191 CB20.1 CB30.1
CB45.1 CB46.1 CB50.1 CB500 CB54.1 CB543
CB544 CB55.1 CB554 CX05.1 CX05.2 CX205
CX805 EE11.1 EE135 EE20.1 EE20.2 EE20.3
EE20.4 EE220 EE230 EE235 EE30.1 EE35.1
EE35.2 EE52.1 EE52.2 EE520 EE90.1 EE90.2
HR00.1 HR01.1 IC02.1 IC10.1 IC10.2 IC12.1
IC12.2 IC125 IC130 IC141 IC145 IC175
IC182 IC225 IC226 IC263 IC266 IC270
IC281 IC282 IC285 IC320 IC330 IC331
IC36.1 IC45.1 IC520 IC521 IC522 IC523
IC524 IC525 IC526 IC527 IC598 IC62.1
IC62.4 IC63.1 IC81.1 IC81.2 IC812 IC82.1
IC84.1 IC84.2 ICLM.1 PC120 ZC522 EX12.1
EX542 EX545 MA08.1 MA126 MA168 MA205
MA208 MA231 MA26.1 MA264 MA278 MA310
MA53.1 MA53.2 MA53.3 MA53.4 MA54.1 MA54.2
MA54.3 MA54.8 MA54.9 MA540 MA62.7 MA64.9
MA730 MA91.1 MA95.1 MA95.2 MAED.1 PD06.1
PO01.1 PO04.4 PO13.1 PO13.3 PO130 PO132
PO133 PO135 PO139 PO16.1 PO16.2 PO210
PO213 PO216 PO222 PO224 PO225 PO227
PO228 PO229 PO230 PO231 PO234 PO251
PO26.1 PO26.2 PO26.4 PO26.5 PO274 PO275
PO276 PO277 PO280 PO295 PO529 PO560
PO63.1 PO64.1 PO66.1 PO67.1 PO81.1 PO813
PO94.1 POED.1 POI7.1 POIF.1 POIG.1 POIM.1
POIT.1 PR198 MM280 MM80.1 MM80.2 RQ11.1
RQ111 RQIB.1 RQIC.1 RQID.1 RQIG.1 RQIH.1
RQII.1 RQIJ.1 TX04.1 TX140 TX40.1 WH140
AM18.1 AP01.1 AP15.1 AP162 AP200 AP202
AP62.1 AP810 AP98.1 AP98.2 MA01.1 MA05.1
MA05.6 PO00.1 PO240 PO72.1 POA2.1 POA2.4


UPDATED 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.1 AP03.3 AP100 AP110 AP115 AP125
AP126 AP131 AP150 AP199 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP210
AP220 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP271 AP30.2 AP30.4 AP300 AP305 AP510
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC142 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
IC840 EX14.1 MX123 MX500 MA180 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 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD235 PO10.1 PO100
PO101 PO120 PO122 PO131 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO223 PO23.1 PO233
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO253
PO254 PO27.2 PO278 PO28.2 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 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.1 PO54.2 PO54.3
PO54.4 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500
RQIF.1 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VGP-VENDOR-GROUP
Element: Vendor Group
Alpha 4
A user-defined code used to identify a set of vendors shared by one or more accounts payable companies.
AP00.1 AP100
VGP-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The name or description of the vendor group.
AP00.1 AP135
VGP-VENDOR-AUDIT
Element: Audit Vendor Changes
Alpha 1
Indicates 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
Element: Vendor Values
Alpha 1
Indicates 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
Element: Auto Vendor
Alpha 1
Indicates 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
Element: Last Vendor
Numeric 9
The 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
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.1 AP03.3
AP100 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
VGP-LAST-ONE-VEN
Element: Last Vendor
Numeric 9
The 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
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
VGP-MANP-HOLD
Element: Hold Code
Alpha 4
The 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
Element: Cred Hold
Alpha 4
The 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
Element: Hold Code
Alpha 4
The 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
Element: Hold Code
Alpha 4
The 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
Element: Hold Code
Alpha 4
The 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
Element: Per End Date
Numeric 8 (yyyymmdd) Occurs 13 Times
The period ending date of each period of the current vendor group year.
AP00.1 AP199
VGP-GRP-END-DTE-01
Vendor Group Period
1 Ending
Derived
The period ending date of the first period of the current vendor group year.
VGP-GRP-END-DTE-02
Vendor Group Period
2 Ending
Derived
The period ending date of the second period of the current vendor group year.
VGP-GRP-END-DTE-03
Vendor Group Period
3 Ending
Derived
The period ending date of the third period of the current vendor group year.
VGP-GRP-END-DTE-04
Vendor Group Period
4 Ending
Derived
The period ending date of the fourth period of the current vendor group year.
VGP-GRP-END-DTE-05
Vendor Group Period
5 Ending
Derived
The period ending date of the fifth period of the current vendor group year.
VGP-GRP-END-DTE-06
Vendor Group Period
6 Ending
Derived
The period ending date of the sixth period of the current vendor group year.
VGP-GRP-END-DTE-07
Vendor Group Period
7 Ending
Derived
The period ending date of the seventh period of the current vendor group year.
VGP-GRP-END-DTE-08
Vendor Group Period
8 Ending
Derived
The period ending date of the eighth period of the current vendor group year.
VGP-GRP-END-DTE-09
Vendor Group Period
9 Ending
Derived
The period ending date of the ninth period of the current vendor group year.
VGP-GRP-END-DTE-10
Vendor Group Period
10 Ending
Derived
The period ending date of the tenth period of the current vendor group year.
VGP-GRP-END-DTE-11
Vendor Group Period
11 Ending
Derived
The period ending date of the eleventh period of the current vendor group year.
VGP-GRP-END-DTE-12
Vendor Group Period
12 Ending
Derived
The period ending date of the twelfth period of the current vendor group year.
VGP-GRP-END-DTE-13
Vendor Group Period
13 Ending
Derived
The period ending date of the thirteenth period of the current vendor group year.
VGP-RET-HOLD
Element: Hold Code
Alpha 4
AP00.1
VGP-MINP-HOLD
Element: Hold Code
Alpha 4
AP00.1


APVENGROUP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VGPSET1 VENDOR-GROUP
...
AC03.4 AC03.7
AC145 AC160
AC17.4 AC18.3
AC191 AC203
AC210 AC217
AC218 AC297
AC41.1 AC41.4
AC42.1 AC440
AC46.1 AC50.1
AC500 AC52.1
AC520 AC54.1
AC540 AC69.2
AC92.2 AC92.4
AC92.6 ACAC.1
AM115 AM117


APVENGROUP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY
VGP-VENDOR-GROUP->CPY-VENDOR-GROUP
  CPY-COMPANY
Apholdcode APHOLDCODE
VGP-VENDOR-GROUP->HLD-VENDOR-GROUP
  HLD-HLD-CODE
Apvendclass APVENCLASS Delete Cascades
VGP-VENDOR-GROUP->VCL-VENDOR-GROUP
  VCL-VEN-CLASS
Apvendmast APVENMAST Delete Cascades
VGP-VENDOR-GROUP->VEN-VENDOR-GROUP
  VEN-VENDOR
Apvendmasta APVENMAST
VGP-VENDOR-GROUP->VEN-VENDOR-GROUP
  VEN-VENDOR-SNAME
  VEN-VENDOR


File created: Thu Jun 09 11:07:45 2016

Home
Contact Us



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