APVENTABLE

Vendor Table

The Vendor Table file contains relationship records of old, non-Lawson vendor numbers and Lawson vendor numbers. The system automatically creates these relationship records during the non-Lawson to Lawson vendor conversion process for vendor groups using automatic vendor numbering.

REFERENCED BY
HVTB.1


UPDATED BY
AP300 AP510 AP54.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VTB-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group. Must be a valid record in the Vendor Group file.
AP510 AP54.1
VTB-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The Lawson vendor number. Must be a valid record in the Vendor file.
AP510 AP54.1
VTB-OLD-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The old vendor number as it existed before conversion to the Lawson Accounts Payable application.
AP510 AP54.1
VTB-LOCATION-CODE
Element: Location Code
Alpha 4
A user-defined code that represents an alternate purchasing or remittance location for the vendor.
AP510 AP54.1
VTB-EDI-NBR
Element: Edi Nbr
Alpha 15
The vendor's electronic data interchange (EDI) number. Used for reference.
AP510 AP54.1
VTB-VENDOR-VNAME
Element: Name
Alpha 30 (Lower Case)
The vendor name.
AP510 AP54.1
VTB-VENDOR-SNAME
Element: Vendor Name
Alpha 30
The search name for the vendor.
AP510 AP54.1


APVENTABLE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VTBSET1 VENDOR-GROUP
OLD-VENDOR
LOCATION-CODE
AP300 AP510
AP54.1 HVTB.1
VTBSET3 VENDOR-GROUP
OLD-VENDOR
VENDOR
EDI-NBR
LOCATION-CODE
KeyChange
AP510 AP54.1


File created: Thu Jun 09 02:07:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.