|
|
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 AC440 AC50.1 AC500 AC52.1 AC520
AM18.1 AP01.1 AP02.1 AP05.4 AP102 AP110
AP12.1 AP12.2 AP125 AP126 AP135 AP150
AP151 AP170 AP180 AP181 AP190 AP191
AP193 AP197 AP200 AP202 AP205 AP210
AP212 AP230 AP240 AP25.1 AP25.2 AP25.3
AP25.4 AP250 AP26.1 AP270 AP28.1 AP290
AP30.1 AP30.2 AP30.3 AP30.4 AP300 AP32.1
AP32.2 AP35.1 AP40.1 AP40.2 AP45.1 AP51.1
AP51.2 AP52.1 AP52.2 AP52.3 AP54.1 AP54.2
AP55.1 AP55.2 AP56.1 AP56.2 AP57.2 AP90.1
AP90.2 AP90.6 AP90.7 AP91.1 AP92.1 AP92.3
AP92.4 AP95.1 AP95.2 AP95.3 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
AR501 AR550 AR560 AR570 AR575 AR580
AR82.1 BL02.1 BL122 BL140 BL141 BL202
BL240 BL340 BL41.1 BL80.1 BL802 BL902
BL92.1 CB06.2 CB10.1 CB180 CB191 CB20.1
CB30.1 CB500 CX05.1 CX05.2 CX805 DT180
DT181 EE12.1 EE12.2 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 IC140 IC141 IC142 IC145
IC16.4 IC226 IC263 IC45.1 IC522 IC523
IC526 IC527 IC530 IC62.1 IC63.1 IC81.2
IC812 IC82.1 IC83.1 IC840 IN20.1 MA00.1
MA00.4 MA140 MA190 MA200 MA203 MA204
MA205 MA206 MA208 MA278 MA300 MA520
MA530 MA540 MA95.1 MA95.2 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 OE112
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810
OE920 PBIP.1 PO10.1 PO10.2 PO100 PO115
PO120 PO121 PO122 PO123 PO13.1 PO130
PO131 PO132 PO133 PO135 PO14.1 PO15.1
PO150 PO16.1 PO16.2 PO180 PO20.1 PO202
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO21.6
PO210 PO212 PO213 PO214 PO216 PO22.1
PO22.2 PO22.3 PO220 PO221 PO223 PO224
PO225 PO23.1 PO23.2 PO230 PO231 PO233
PO236 PO24.1 PO25.1 PO25.2 PO25.3 PO25.4
PO251 PO26.1 PO272 PO274 PO275 PO276
PO277 PO28.1 PO28.3 PO28.4 PO28.5 PO28.6
PO28.7 PO28.8 PO280 PO29.1 PO295 PO30.1
PO31.1 PO32.1 PO32.2 PO32.4 PO32.5 PO33.1
PO34.1 PO35.1 PO37.1 PO39.1 PO50.1 PO529
PO53.1 PO53.2 PO530 PO560 PO60.1 PO61.1
PO62.1 PO63.1 PO64.1 PO66.1 PO67.1 PO68.1
PO69.1 PO72.1 PO72.2 PO81.1 PO813 PO820
PO821 PO822 PO85.1 PO94.1 PR05.1 PR05.3
PR150 PR195 PR199 PR26.1 PR514 PR82.1
PR85.1 RQ10.1 RQ10.3 RQ11.1 RQ111 RQ125
RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ35.1 RQ500
TX04.1 TX140 TX40.1 WH130 WH132 WH140
WH190 WH20.2 WH20.7 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 WO235 WO252 WO30.1
WO35.1 WO40.1
UPDATED BY
AP00.1 AP10.1 AP10.3 AP100 AP199 AP20.1
AP20.2 AP20.5 AP20.6 AP20.7 AP23.1 AP510
AP520 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4
MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4
MA52.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 AP10.1
Last Vendor Number The last vendor number used. Used only AP100 AP20.1
Used if the vendor group has Yes selected in AP20.2 AP20.5
the Auto Vendor Numbering field. Used as AP20.6 AP20.7
a starting point for continuing to AP23.1 AP510
number vendors automatically as they are MA40.1 MA40.2
added into to the Lawson Accounts MA41.1 MA41.2
Payable system. If left blank, automatic MA41.4 MA41.5
vendor numbering begins with 1. MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
VGP-LAST-ONE-VEN Numeric 9 AP00.1 AP10.3
Last One-Time The last one-time vendor number added AP520
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-USER-NAME-01 Alpha 15 AP00.1 AP100
Vendor Group - User A user-defined name assigned to the
Name 1 first field of additional vendor
information the user selects to store in
the Lawson Accounts Payable system.
VGP-USER-TYPE-01 Alpha 1 AP00.1 AP100
Vendor Group - Indicates the type of information to be
Field 1 Type stored in the first user-defined vendor
group field. Valid values are:
A = Alpha.
N = Numeric.
D = Date Format (first 6 positions).
Blank = User field is not defined.
VGP-USER-NAME-02 Alpha 15 AP00.1 AP100
Vendor Group - User A user-defined name assigned to the
Name 2 second field of additional vendor
information the user selects to store in
the Lawson Accounts Payable system.
VGP-USER-TYPE-02 Alpha 1 AP00.1 AP100
Vendor Group - Indicates the type of information to be
Field 2 Type stored in the second user-defined vendor
group field. Valid values are:
A = Alpha.
N = Numeric.
D = Date Format (first 6 positions).
Blank = User field is not defined.
VGP-USER-NAME-03 Alpha 15 AP00.1 AP100
Vendor Group - User A user-defined name assigned to the
Name 3 third field of additional vendor
information the user selects to store in
the Lawson Accounts Payable system.
VGP-USER-TYPE-03 Alpha 1 AP00.1 AP100
Vendor Group - Indicates the type of information to be
Field 3 Type stored in the third user-defined vendor
group field. Valid values are:
A = Alpha.
N = Numeric.
D = Date Format (first 6 positions).
Blank = User field is not defined.
VGP-USER-NAME-04 Alpha 15 AP00.1 AP100
Vendor Group - User A user-defined name assigned to the
Name 4 fourth field of additional vendor
information the user selects to store in
the Lawson Accounts Payable system.
VGP-USER-TYPE-04 Alpha 1 AP00.1 AP100
Vendor Group - Indicates the type of information to be
Field 4 Type stored in the fourth user-defined vendor
group field. Valid values are:
A = Alpha.
N = Numeric.
D = Date Format (first 6 positions).
Blank = User field is not defined.
VGP-USER-NAME-05 Alpha 15 AP00.1 AP100
Vendor Group - User A user-defined name assigned to the
Name 5 fifth field of additional vendor
information the user selects to store in
the Lawson Accounts Payable system.
VGP-USER-TYPE-05 Alpha 1 AP00.1 AP100
Vendor Group - Indicates the type of information to be
Field 5 Type stored in the fifth user-defined vendor
group field. Valid values are:
A = Alpha.
N = Numeric.
D = Date Format (first 6 positions).
Blank = User field is not defined.
VGP-USER-NAME-06 Alpha 15 AP00.1 AP100
Vendor Group - User A user-defined name assigned to the
Name 6 sixth field of additional vendor
information the user selects to store in
the Lawson Accounts Payable system.
VGP-USER-TYPE-06 Alpha 1 AP00.1 AP100
Vendor Group - Indicates the type of information to be
Field 6 Type stored in the sixth user-defined vendor
group field. Valid values are:
A = Alpha.
N = Numeric.
D = Date Format (first 6 positions).
Blank = User field is not defined.
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.
VGP-VAT-RPTG-RQD Alpha 1 AP00.1
VAT Reporting Indicates whether VAT Reporting is
Required required for the company.
Y = Yes
N = No
APVENGROUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VGPSET1 VENDOR-GROUP This index is used to access and AC03.4 AC440
validate a vendor group. AC50.1 AC500
AC52.1 AC520
AM18.1 AP00.1
AP00.2 AP00.3
AP00.4 AP01.1
AP02.1 AP05.4
AP10.1 AP10.2
AP10.3 AP10.5
AP10.6 AP100
AP102 AP110
AP12.1 AP12.2
AP125 AP126
AP135 AP150
AP151 AP170
...
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
|