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
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
|---|---|---|---|---|
| VGP-VENDOR-GROUP Element: Vendor Group | Alpha 4 A user-defined code used to identify a set of vendors shared by one or more accounts payable companies. |
|
||
| VGP-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The name or description of the vendor group. |
|
||
| VGP-VENDOR-AUDIT Element: Audit Vendor Changes | Alpha 1 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 Element: Vendor Values | Alpha 1 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 Element: Auto Vendor | Alpha 1 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 Element: Last Vendor | Numeric 9 The last vendor number used. Used only if the vendor group has Yes selected in 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 Element: Last Vendor | Numeric 9 The last one-time vendor number added to the Lawson Accounts Payable system. Vendor numbers 999000001 through 999999999 are reserved for one-time vendor numbering. |
|||
| VGP-MANP-HOLD Element: Hold Code | Alpha 4 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 Element: Cred Hold | Alpha 4 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 Element: Hold Code | Alpha 4 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 Element: Hold Code | Alpha 4 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 Element: Hold Code | Alpha 4 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 Element: Per End Date | Numeric 8 (yyyymmdd) Occurs 13 Times The period ending date of each period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-01 Vendor Group Period 1 Ending | Derived The period ending date of the first period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-02 Vendor Group Period 2 Ending | Derived The period ending date of the second period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-03 Vendor Group Period 3 Ending | Derived The period ending date of the third period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-04 Vendor Group Period 4 Ending | Derived The period ending date of the fourth period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-05 Vendor Group Period 5 Ending | Derived The period ending date of the fifth period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-06 Vendor Group Period 6 Ending | Derived The period ending date of the sixth period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-07 Vendor Group Period 7 Ending | Derived The period ending date of the seventh period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-08 Vendor Group Period 8 Ending | Derived The period ending date of the eighth period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-09 Vendor Group Period 9 Ending | Derived The period ending date of the ninth period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-10 Vendor Group Period 10 Ending | Derived The period ending date of the tenth period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-11 Vendor Group Period 11 Ending | Derived The period ending date of the eleventh period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-12 Vendor Group Period 12 Ending | Derived The period ending date of the twelfth period of the current vendor group year. |
|
||
| VGP-GRP-END-DTE-13 Vendor Group Period 13 Ending | Derived The period ending date of the thirteenth period of the current vendor group year. |
|
||
| VGP-RET-HOLD Element: Hold Code | Alpha 4 |
|
||
| VGP-MINP-HOLD Element: Hold Code | Alpha 4 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VGPSET1 |
VENDOR-GROUP |
|
| ||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Apcompany | APCOMPANY |
| |||||||||
| Apholdcode | APHOLDCODE |
| |||||||||
| Apvendclass | APVENCLASS |
Delete Cascades
| |||||||||
| Apvendmast | APVENMAST |
Delete Cascades
| |||||||||
| Apvendmasta | APVENMAST |
|
All trademarks and registered trademarks are the property of their
respective owners.