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 AC09.1 AC17.4 AC18.3 AC191 AC209
AC210 AC217 AC218 AC259 AC297 AC42.1
AC50.1 AC500 AC52.1 AC520 AC54.1 AC54.2
AC540 AC542 AC550 AC551 AC56.1 AC560
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
AP125 AP126 AP130 AP131 AP135 AP141
AP150 AP151 AP170 AP180 AP181 AP190
AP191 AP193 AP197 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.6 AP20.7 AP20.8 AP200
AP202 AP205 AP210 AP212 AP23.1 AP230
AP240 AP25.1 AP25.2 AP25.3 AP25.4 AP250
AP251 AP252 AP26.1 AP27.1 AP270 AP28.1
AP290 AP30.1 AP30.2 AP30.3 AP30.4 AP300
AP32.1 AP32.2 AP35.1 AP40.1 AP40.2 AP41.1
AP43.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 AR09.1
AR09.8 AR10.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 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
IC28.1 IC281 IC320 IC330 IC36.1 IC45.1
IC520 IC521 IC522 IC523 IC524 IC525
IC526 IC527 IC530 IC531 IC598 IC62.1
IC63.1 IC81.1 IC81.2 IC812 IC82.1 IC83.1
PC120 SEA1.1 MA01.1 MA05.1 MA05.6 MA08.1
MA126 MA180 MA205 MA208 MA231 MA278
MA310 MA41.1 MA41.2 MA41.4 MA43.1 MA43.2
MA43.3 MA43.4 MA43.5 MA43.7 MA43.8 MA43.9
MA53.1 MA53.2 MA53.3 MA53.4 MA530 MA531
MA54.1 MA54.2 MA54.3 MA54.8 MA54.9 MA540
MA60.1 MA60.2 MA60.3 MA60.4 MA60.5 MA60.7
MA61.1 MA63.1 MA65.1 MA66.3 MA67.1 MA67.2
MA70.1 MA95.1 MA95.2 MAI1.1 PBIP.1 PO00.1
PO01.1 PO04.4 PO10.1 PO10.2 PO100 PO101
PO120 PO122 PO13.1 PO130 PO131 PO132
PO133 PO135 PO136 PO150 PO16.1 PO16.2
PO190 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO210 PO216 PO22.1 PO220 PO223 PO224
PO225 PO227 PO228 PO23.1 PO23.7 PO230
PO231 PO233 PO24.1 PO25.2 PO25.6 PO25.7
PO25.8 PO251 PO26.1 PO27.3 PO274 PO275
PO276 PO277 PO280 PO29.1 PO295 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO529
PO560 PO64.1 PO66.1 PO67.1 PO68.1 PO72.1
PO81.1 PO813 PO85.1 PO94.1 POA2.1 POA2.4
POED.1 POI3.1 POI7.1 POIE.1 POIF.1 POIG.1
POII.1 POIJ.1 POIT.1 PR05.1 PR05.3 PR197
PR198 PR26.1 PR47.1 PR514 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ111 RQ35.1 RQ500 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 SEA3.1 TX04.1
TX140 TX40.1 WH130 WH132 WH140 WH190
WH20.2 WH20.7 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH33.5 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830
UPDATED BY
AP00.1 AP100 AP199 AP510 API3.1 API4.1
IC840
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 IC840
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 IC840
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 AC09.1
validate a vendor group. AC17.4 AC18.3
AC191 AC209
AC210 AC217
AC218 AC259
AC297 AC42.1
AC50.1 AC500
AC52.1 AC520
AC54.1 AC54.2
AC540 AC542
AC550 AC551
AC56.1 AC560
AC59.1 AC92.2
AC92.4 AC92.6
AM18.1 AP00.1
...
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
|
