|
|
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 AC69.2 AC92.2 AC92.4
AC92.6 ACAC.1 AM18.1 AP01.1 AP02.1 AP05.4
AP07.1 AP07.2 AP07.3 AP07.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 AP141 AP145
AP146 AP15.1 AP150 AP151 AP16.1 AP16.2
AP162 AP170 AP180 AP181 AP190 AP191
AP193 AP197 AP200 AP202 AP205 AP211
AP212 AP221 AP230 AP240 AP245 AP250
AP251 AP252 AP270 AP272 AP28.1 AP290
AP295 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 AP62.1 AP810 AP92.1
AP92.3 AP92.4 AP93.1 AP93.3 AP93.4 AP95.1
AP95.2 AP95.3 AP96.1 AR01.1 AR08.1 AR09.1
AR09.8 AR10.1 AR115 AR120 AR124 AR190
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR32.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
BL140 BL141 BL202 BL240 BL340 BL41.1
BL80.1 BL802 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 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 ET08.1 ET09.1
ET530 ET540 ET542 ET545 ET700 HR00.1
HR01.1 IC02.1 IC12.1 IC12.2 IC130 IC320
IC330 IC812 ICLM.1 MA01.1 MA05.1 MA05.6
MA08.1 MA126 MA168 MA205 MA208 MA231
MA264 MA278 MA310 MA53.1 MA53.2 MA53.3
MA53.4 MA54.1 MA54.2 MA54.3 MA54.8 MA54.9
MA540 MA62.7 MA69.1 MA69.2 MA69.7 MA91.1
MA95.1 MA95.2 PD06.1 PO00.1 PO01.1 PO04.4
PO13.1 PO130 PO132 PO133 PO135 PO136
PO139 PO150 PO16.1 PO16.2 PO190 PO210
PO213 PO216 PO224 PO225 PO227 PO228
PO229 PO230 PO231 PO234 PO240 PO251
PO26.1 PO274 PO275 PO276 PO277 PO280
PO295 PO529 PO560 PO63.1 PO64.1 PO66.1
PO67.1 PO72.1 PO81.1 PO813 PO94.1 POA2.1
POA2.4 POED.1 POI7.1 POIF.1 POIG.1 POIM.1
POIT.1 PR198 PW110 PW510 MM280 MM80.1
MM80.2 RQ11.1 RQ111 RQ12.1 RQ13.1 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 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
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP00.1
AP03.3 AP100 AP110 AP115 AP125 AP126
AP131 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 AP30.2 AP30.4
AP305 AP510 AP90.1 AP91.1 API1.1 API2.1
API3.1 API4.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MX123 MX500 MA180 MA279
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 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
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO220 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO27.2 PO278 PO29.1 PO30.1 PO30.2 PO30.3
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 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
WH20.2 WH20.7
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
Element: Auto Vendor 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.
VGP-LAST-VENDOR Numeric 9 AC160 AM115
Element: Last Vendor The last vendor number used. Used only AM117 AM15.1
if the vendor group has Yes selected in AM15.2 AM15.3
the Auto Vendor Numbering field. Used as AM15.4 AM19.1
a starting point for continuing to AM19.2 AM20.1
number vendors automatically as they are AM20.3 AM21.1
added into to the Lawson Accounts AM21.3 AM500
Payable system. If left blank, automatic AM51.1 AM551
vendor numbering begins with 1. AM97.1 AP00.1
AP03.3 AP100
AP110 AP115
AP125 AP126
AP131 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 AP30.2
AP30.4 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
VGP-LAST-ONE-VEN Numeric 9 AC160 AM115
Element: Last Vendor The last one-time vendor number added AM117 AM15.1
to the Lawson Accounts Payable system. AM15.2 AM15.3
Vendor numbers 999000001 through AM15.4 AM19.1
999999999 are reserved for one-time AM19.2 AM20.1
vendor numbering. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.1
AP03.3 AP110
AP115 AP125
AP126 AP131
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
AP30.2 AP30.4
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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
Element: Cred Hold 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.
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: Per 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 AC03.4 AC03.7
AC145 AC160
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
AC69.2 AC92.2
AC92.4 AC92.6
ACAC.1 AM115
AM117 AM15.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
|
