APVENGROUP FILE
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 AC17.4 AC18.3 AC191 AC217 AC218
AC259 AC42.1 AC50.1 AC500 AC52.1 AC520
AC54.2 AC542 AC550 AC551 AC59.1 AC92.2
AC92.4 AC92.6 AM18.1 AP01.1 AP02.1 AP05.4
AP10.1 AP10.2 AP10.3 AP10.5 AP10.6 AP10.9
AP102 AP110 AP115 AP12.1 AP130 AP135
AP141 AP150 AP151 AP170 AP180 AP181
AP190 AP191 AP193 AP197 AP200 AP202
AP205 AP210 AP212 AP230 AP240 AP250
AP251 AP252 AP270 AP28.1 AP30.1 AP30.2
AP30.3 AP30.4 AP300 AP32.1 AP32.2 AP35.1
AP40.1 AP40.2 AP41.1 AP45.1 AP51.1 AP51.2
AP51.3 AP51.4 AP51.5 AP52.1 AP52.2 AP52.3
AP52.7 AP520 AP54.1 AP55.1 AP55.2 AP56.1
AP56.2 AP57.2 AP90.1 AP90.2 AP90.4 AP90.6
AP90.7 AP91.1 AP91.5 AP91.6 AP92.1 AP92.3
AP92.4 AP93.1 AP93.3 AP93.4 AP95.1 AP95.2
AP95.3 AP96.1 AP96.3 API1.1 API2.1 AR01.1
AR08.1 AR115 AR124 AR190 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2
AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR48.1
AR48.3 AR48.4 AR501 AR550 AR560 AR570
AR575 AR580 BL02.1 BL140 BL141 BL202
BL240 BL340 BL41.1 BL80.1 BL802 BR40.3
BRIP.1 CB06.2 CB10.1 CB180 CB191 CB20.1
CB30.1 CB500 DT180 DT181 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 DR100 IC02.1
IC10.1 IC10.2 IC12.1 IC12.2 IC125 IC130
IC140 IC141 IC142 IC145 IC211 IC225
IC226 IC263 IC281 IC320 IC330 IC36.1
IC45.1 IC520 IC521 IC522 IC523 IC524
IC525 IC526 IC527 IC530 IC531 IC62.1
IC63.1 IC81.1 IC81.2 IC812 IC82.1 IC83.1
IC840 PC120 SEA1.1 MA01.1 MA05.1 MA05.6
MA08.1 MA126 MA205 MA208 MA231 MA278
MA310 MA53.1 MA53.2 MA53.3 MA53.4 MA54.1
MA54.2 MA54.3 MA54.8 MA54.9 MA63.1 MA65.1
MA95.1 MA95.2 PO00.1 PO01.1 PO04.4 PO10.1
PO10.2 PO120 PO13.1 PO130 PO132 PO133
PO135 PO136 PO16.1 PO16.2 PO190 PO210
PO216 PO220 PO223 PO224 PO225 PO227
PO228 PO230 PO231 PO233 PO24.1 PO251
PO26.1 PO274 PO275 PO276 PO277 PO280
PO295 PO529 PO560 PO60.1 PO61.1 PO62.1
PO63.1 PO64.1 PO66.1 PO67.1 PO68.1 PO72.1
PO81.1 PO85.1 PO94.1 POA2.1 POA2.4 POED.1
POI7.1 POIF.1 POIJ.1 POIT.1 PR05.1 PR05.3
PR197 PR198 PR26.1 PR47.1 PR514 RQ11.1
RQ111 SEA3.1 TX04.1 TX140 TX40.1 WH130
WH140 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
UPDATED BY
AP00.1 AP100 AP199 AP510 API3.1 API4.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VGP-VENDOR-GROUP Alpha 4 AP00.1 AP100
Vendor Group A user-defined code used to identify a
set of vendors shared by one or more
accounts payable companies.
VGP-DESCRIPTION Alpha 30 (Lower Case) AP00.1 AP135
Description The name or description of the vendor
group.
VGP-VENDOR-AUDIT Alpha 1 AP00.1
Audit Vendor Changes 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.
VGP-NUM-VEN-NBR Alpha 1 AP00.1
Vendor Values Indicates whether vendors added to this
vendor group will have alphanumeric or
numeric vendor identification numbers.
Valid values are:
A = Alpha.
N = Numeric.
VGP-AUTO-VENDOR Alpha 1 AP00.1
Auto Vendor Indicates whether vendor numbers are
Numbering 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.
VGP-LAST-VENDOR Numeric 9 AP00.1 AP100
Last Vendor Number The last vendor number used. Used only AP510 API3.1
Used if the vendor group has Yes selected in API4.1
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.
VGP-LAST-ONE-VEN Numeric 9 AP00.1 API3.1
Last One-Time The last one-time vendor number added API4.1
Vendor Used to the Lawson Accounts Payable system.
Vendor numbers 999000001 through
999999999 are reserved for one-time
vendor numbering.
VGP-MANP-HOLD Alpha 4 AP00.1
Manual Payment Hold The hold code used to place an invoice
Code on hold for manual payment. Creates a
record in the Hold Code file. If left
blank, MPAY defaults.
VGP-CRED-HOLD Alpha 4 AP00.1
Credit Balance Hold The hold code used to place an invoice
Code on hold when the vendor has a credit
balance. Creates a record in the Hold
Code file. If left blank, CRED defaults.
VGP-PREP-HOLD Alpha 4 AP00.1
Prepayment Hold Code 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.
VGP-ROI-HOLD Alpha 4 AP00.1
Return on The hold code used to place an invoice
Investment Hold Code 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.
VGP-MAXP-HOLD Alpha 4 AP00.1
Maximum Payment The hold code used to place an invoice
Hold Code 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.
VGP-PER-END-DATE Numeric 8 (yyyymmdd) Occurs 13 Times AP00.1 AP199
Period End Date The period ending date of each period
of the current vendor group year.
VGP-GRP-END-DTE-01 Derived
Vendor Group Period The period ending date of the first
1 Ending period of the current vendor group year.
VGP-GRP-END-DTE-02 Derived
Vendor Group Period The period ending date of the second
2 Ending period of the current vendor group year.
VGP-GRP-END-DTE-03 Derived
Vendor Group Period The period ending date of the third
3 Ending period of the current vendor group year.
VGP-GRP-END-DTE-04 Derived
Vendor Group Period The period ending date of the fourth
4 Ending period of the current vendor group year.
VGP-GRP-END-DTE-05 Derived
Vendor Group Period The period ending date of the fifth
5 Ending period of the current vendor group year.
VGP-GRP-END-DTE-06 Derived
Vendor Group Period The period ending date of the sixth
6 Ending period of the current vendor group year.
VGP-GRP-END-DTE-07 Derived
Vendor Group Period The period ending date of the seventh
7 Ending period of the current vendor group year.
VGP-GRP-END-DTE-08 Derived
Vendor Group Period The period ending date of the eighth
8 Ending period of the current vendor group year.
VGP-GRP-END-DTE-09 Derived
Vendor Group Period The period ending date of the ninth
9 Ending period of the current vendor group year.
VGP-GRP-END-DTE-10 Derived
Vendor Group Period The period ending date of the tenth
10 Ending period of the current vendor group year.
VGP-GRP-END-DTE-11 Derived
Vendor Group Period The period ending date of the eleventh
11 Ending period of the current vendor group year.
VGP-GRP-END-DTE-12 Derived
Vendor Group Period The period ending date of the twelfth
12 Ending period of the current vendor group year.
VGP-GRP-END-DTE-13 Derived
Vendor Group Period The period ending date of the
13 Ending thirteenth period of the current vendor
group year.
APVENGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VGPSET1 VENDOR-GROUP This index is used to access and AC03.4 AC17.4
validate a vendor group. AC18.3 AC191
AC217 AC218
AC259 AC42.1
AC50.1 AC500
AC52.1 AC520
AC54.2 AC542
AC550 AC551
AC59.1 AC92.2
AC92.4 AC92.6
AM18.1 AP00.1
AP00.2 AP00.3
AP00.4 AP01.1
AP02.1 AP05.4
AP10.1 AP10.2
...
APVENGROUP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
