|
|
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 AC03.7 AC145 AC17.4 AC18.3 AC191
AC203 AC210 AC217 AC218 AC41.1 AC41.4
AC42.1 AC440 AC46.1 AC50.1 AC500 AC52.1
AC520 AC54.1 AC540 AC92.2 AC92.4 AC92.6
ACAC.1 AM18.1 AP01.1 AP02.1 AP03.1 AP05.4
AP10.1 AP10.2 AP10.3 AP10.5 AP10.6 AP10.9
AP102 AP109 AP11.1 AP110 AP115 AP12.1
AP125 AP126 AP130 AP131 AP135 AP14.1
AP14.3 AP141 AP15.1 AP150 AP151 AP16.1
AP170 AP180 AP181 AP190 AP191 AP193
AP197 AP200 AP202 AP205 AP210 AP211
AP212 AP230 AP240 AP25.1 AP25.2 AP25.3
AP25.4 AP250 AP251 AP252 AP26.1 AP27.1
AP270 AP272 AP28.1 AP290 AP295 AP30.1
AP30.2 AP30.3 AP30.4 AP300 AP32.1 AP35.1
AP36.2 AP40.1 AP40.2 AP41.1 AP45.1 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 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 AR34.1
AR42.1 AR42.2 AR42.7 AR43.1 AR48.1 AR48.3
AR48.4 AR501 AR550 AR560 AR570 AR575
AR580 ARLL.1 BL02.1 BL120 BL122 BL130
BL140 BL141 BL20.1 BL20.3 BL202 BL21.2
BL21.5 BL240 BL29.1 BL29.2 BL340 BL41.1
BL520 BL80.1 BL802 BL820 BL92.1 BR40.3
BR43.1 BR46.1 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
IC182 IC225 IC226 IC263 IC270 IC28.1
IC281 IC282 IC320 IC330 IC331 IC36.1
IC45.1 IC520 IC521 IC522 IC523 IC524
IC525 IC526 IC527 IC530 IC531 IC598
IC62.1 IC62.4 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 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.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MA95.1 MA95.2 MAI1.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE112 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.5 OE13.6 OE14.4 OE16.1 OE229
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE88.1 OE90.1 OE90.2 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 PO224 PO225
PO227 PO228 PO229 PO23.1 PO23.7 PO230
PO231 PO233 PO240 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.1 PO27.2 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 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO529 PO536 PO560 PO63.1 PO64.1
PO66.1 PO67.1 PO72.1 PO81.1 PO813 PO94.1
POA2.1 POA2.4 POED.1 POI3.1 POI7.1 POIE.1
POIF.1 POIG.1 POII.1 POIJ.1 POIM.1 POIT.1
PR197 PR198 MM280 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ111 RQ13.2 RQ35.1 RQ500 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1 RQII.1
RQIJ.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 WO140 WO235 WO252 WO30.1 WO35.1
WO40.1
UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP00.1 AP100 AP199 AP510
API3.1 API4.1 IC840 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VGP-VENDOR-GROUP Alpha 4 AP00.1 AP100
Element: 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
Element: Description The name or description of the vendor
group.
VGP-VENDOR-AUDIT Alpha 1 AP00.1
Element: Audit Vendor CIndicates 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
Element: 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 AM115 AM117
Last Vendor Number The last vendor number used. Used only AM15.1 AM15.2
Used if the vendor group has Yes selected in AM15.3 AM15.4
the Auto Vendor Numbering field. Used as AM20.1 AM20.3
a starting point for continuing to AM21.1 AM21.3
number vendors automatically as they are AM500 AM51.1
added into to the Lawson Accounts AM551 AM97.1
Payable system. If left blank, automatic AP00.1 AP100
vendor numbering begins with 1. AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VGP-LAST-ONE-VEN Numeric 9 AM115 AM117
Last Vendor Number The last one-time vendor number added AM15.1 AM15.2
Used to the Lawson Accounts Payable system. AM15.3 AM15.4
Vendor numbers 999000001 through AM20.1 AM20.3
999999999 are reserved for one-time AM21.1 AM21.3
vendor numbering. AM500 AM51.1
AM551 AM97.1
AP00.1 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VGP-MANP-HOLD Alpha 4 AP00.1
Element: Hold Code 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.
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
Element: 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
Element: Hold Code 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.
VGP-MAXP-HOLD Alpha 4 AP00.1
Element: Hold Code 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.
VGP-PER-END-DATE Numeric 8 (yyyymmdd) Occurs 13 Times AP00.1 AP199
Element: Period End DatThe 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 AC03.7
validate a vendor group. AC145 AC17.4
AC18.3 AC191
AC203 AC210
AC217 AC218
AC41.1 AC41.4
AC42.1 AC440
AC46.1 AC50.1
AC500 AC52.1
AC520 AC54.1
AC540 AC92.2
AC92.4 AC92.6
ACAC.1 AM115
AM117 AM15.1
AM15.2 AM15.3
...
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
|
