|
|
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 AC131 AC17.4 AC18.3 AC191 AC209
AC210 AC217 AC218 AC259 AC297 AC41.1
AC41.4 AC42.1 AC50.1 AC500 AC52.1 AC520
AC54.1 AC54.2 AC540 AC542 AC550 AC551
AC59.1 AC92.2 AC92.4 AC92.6 ACAC.1 AM18.1
AP01.1 AP02.1 AP05.4 AP10.1 AP10.2 AP10.3
AP10.5 AP10.6 AP10.7 AP10.9 AP102 AP109
AP11.1 AP110 AP115 AP12.1 AP125 AP126
AP130 AP131 AP135 AP141 AP145 AP146
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 AP245 AP25.1 AP25.2 AP25.3 AP25.4
AP250 AP251 AP252 AP26.1 AP27.1 AP270
AP28.1 AP290 AP295 AP30.1 AP30.2 AP30.3
AP30.4 AP300 AP31.3 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.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 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 BR43.1
BRIP.1 BRPI.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 IC285 IC320 IC330 IC331 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 IC84.1 IC84.2 PC120 SEA1.1 MA01.1
MA05.1 MA05.6 MA08.1 MA126 MA180 MA205
MA208 MA231 MA278 MA310 MA41.1 MA41.2
MA41.4 MA41.7 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.2 MA66.3 MA67.1 MA67.2 MA70.1
MA730 MA75.1 MA80.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 PO139
PO150 PO16.1 PO16.2 PO190 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO210 PO213
PO216 PO22.1 PO220 PO224 PO225 PO227
PO228 PO229 PO23.1 PO23.7 PO230 PO231
PO233 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 POIF.1 POIG.1 POII.1
POIJ.1 POIM.1 POIT.1 PR197 PR198 MM280
MM80.1 MM80.2 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ111 RQ12.1 RQ13.1 RQ35.1 RQ500 RQIB.1
RQIC.1 RQID.1 RQIE.1 RQIF.1 RQIG.1 RQIH.1
RQII.1 RQIJ.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 WO140 WO235 WO252
WO30.1 WO35.1 WO40.1
UPDATED BY
AM115 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 PR514 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
Element: All Flag 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 AM115 AM15.1
Last Vendor Number The last vendor number used. Used only AM15.2 AM15.3
Used if the vendor group has Yes selected in AM15.4 AM20.1
the Auto Vendor Numbering field. Used as AM20.3 AM21.1
a starting point for continuing to AM21.3 AM500
number vendors automatically as they are AM51.1 AM551
added into to the Lawson Accounts AM97.1 AP00.1
Payable system. If left blank, automatic AP100 AP510
vendor numbering begins with 1. API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
UK47.1
VGP-LAST-ONE-VEN Numeric 9 AM115 AM15.1
Last Vendor Number The last one-time vendor number added AM15.2 AM15.3
Used to the Lawson Accounts Payable system. AM15.4 AM20.1
Vendor numbers 999000001 through AM20.3 AM21.1
999999999 are reserved for one-time AM21.3 AM500
vendor numbering. AM51.1 AM551
AM97.1 AP00.1
API3.1 API4.1
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 PR514
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
Element: Credit Line 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: 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 AC131
validate a vendor group. AC17.4 AC18.3
AC191 AC209
AC210 AC217
AC218 AC259
AC297 AC41.1
AC41.4 AC42.1
AC50.1 AC500
AC52.1 AC520
AC54.1 AC54.2
AC540 AC542
AC550 AC551
AC59.1 AC92.2
AC92.4 AC92.6
ACAC.1 AM115
...
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
|
