|
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 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 The old vendor number as it existed
before conversion to the Lawson Accounts
Payable application.
VTB-LOCATION-CODE Alpha 4 AP510 AP54.1
Element: Location Code A user-defined code that represents an
alternate purchasing or remittance
location for the vendor.
VTB-EDI-NBR Alpha 15 AP510 AP54.1
Element: Edi Nbr 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 AP300 AP510
OLD-VENDOR AP54.1 HVTB.1
LOCATION-CODE
VTBSET3 VENDOR-GROUP KeyChange AP510 AP54.1
OLD-VENDOR
VENDOR
EDI-NBR
LOCATION-CODE
|