Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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    AC17.4    AC18.3    AC191     AC217     AC218
AC259     AC42.1    AC50.1    AC500     AC52.1    AC520
AC54.2    AC542     AC550     AC551     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    AP130     AP135
AP141     AP150     AP151     AP170     AP180     AP181
AP190     AP191     AP193     AP197     AP200     AP202
AP205     AP210     AP212     AP230     AP240     AP250
AP251     AP252     AP270     AP28.1    AP30.1    AP30.2
AP30.3    AP30.4    AP300     AP32.1    AP32.2    AP35.1
AP40.1    AP40.2    AP41.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    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     BL02.1    BL140     BL141     BL202
BL240     BL340     BL41.1    BL80.1    BL802     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     IC281     IC320     IC330     IC36.1
IC45.1    IC520     IC521     IC522     IC523     IC524
IC525     IC526     IC527     IC530     IC531     IC62.1
IC63.1    IC81.1    IC81.2    IC812     IC82.1    IC83.1
IC840     PC120     SEA1.1    MA01.1    MA05.1    MA05.6
MA08.1    MA126     MA205     MA208     MA231     MA278
MA310     MA53.1    MA53.2    MA53.3    MA53.4    MA54.1
MA54.2    MA54.3    MA54.8    MA54.9    MA63.1    MA65.1
MA95.1    MA95.2    PO00.1    PO01.1    PO04.4    PO10.1
PO10.2    PO120     PO13.1    PO130     PO132     PO133
PO135     PO136     PO16.1    PO16.2    PO190     PO210
PO216     PO220     PO223     PO224     PO225     PO227
PO228     PO230     PO231     PO233     PO24.1    PO251
PO26.1    PO274     PO275     PO276     PO277     PO280
PO295     PO529     PO560     PO60.1    PO61.1    PO62.1
PO63.1    PO64.1    PO66.1    PO67.1    PO68.1    PO72.1
PO81.1    PO85.1    PO94.1    POA2.1    POA2.4    POED.1
POI7.1    POIF.1    POIJ.1    POIT.1    PR05.1    PR05.3
PR197     PR198     PR26.1    PR47.1    PR514     RQ11.1
RQ111     SEA3.1    TX04.1    TX140     TX40.1    WH130
WH140     WH33.5    WH34.1    WH34.2    WH34.3    WH34.4

UPDATED BY

AP00.1    AP100     AP199     AP510     API3.1    API4.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  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
                     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
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  AC17.4
                        validate a vendor group.                 AC18.3  AC191
                                                                 AC217   AC218
                                                                 AC259   AC42.1
                                                                 AC50.1  AC500
                                                                 AC52.1  AC520
                                                                 AC54.2  AC542
                                                                 AC550   AC551
                                                                 AC59.1  AC92.2
                                                                 AC92.4  AC92.6
                                                                 AM18.1  AP00.1
                                                                 AP00.2  AP00.3
                                                                 AP00.4  AP01.1
                                                                 AP02.1  AP05.4
                                                                 AP10.1  AP10.2
                                                                 ...

                         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