|
|
APVENTABLE FILE
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 Alpha 4 AP510 AP54.1
Element: Vendor Group The vendor group. Must be a valid
record in the Vendor Group file.
VTB-VENDOR Alpha 9 (Right Justified) AP510 AP54.1
Element: Vendor ID The Lawson vendor number. Must be a
valid record in the Vendor file.
VTB-OLD-VENDOR Alpha 9 (Right Justified) AP510 AP54.1
Element: Vendor ID The old vendor number as it existed
before conversion to the Lawson Accounts
Payable system.
VTB-LOCATION-CODE Alpha 4 AP510 AP54.1
Purchase From
Location Code
VTB-EDI-NBR Alpha 15 AP510 AP54.1
Element: EDI Number The vendor's electronic data
interchange (EDI) number. Used for
reference.
VTB-VENDOR-VNAME Alpha 30 (Lower Case) AP510 AP54.1
Element: Name The vendor name.
VTB-VENDOR-SNAME Alpha 30 AP510 AP54.1
Element: Vendor Name The search name for the vendor.
APVENTABLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VTBSET1 VENDOR-GROUP This index is used to access vendor AP300 AP510
OLD-VENDOR table records for a vendor number within HVTB.1
LOCATION-CODE a specific vendor group.
VTBSET3 VENDOR-GROUP This index is used to access vendor AP510 AP54.1
OLD-VENDOR table records by the old vendor number.
VENDOR KeyChange
EDI-NBR
LOCATION-CODE
|
