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

AP510     AP54.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

VTB-VENDOR-GROUP     Alpha 4                                     AP510   AP54.1
Vendor Group         The vendor group. Must be a valid
                     record in the Vendor Group file.

VTB-VENDOR           Alpha 9                                     AP510   AP54.1
Vendor ID            The Lawson vendor number. Must be a
                     valid record in the Vendor file.

VTB-OLD-VENDOR       Alpha 9                                     AP510   AP54.1
Old Vendor ID        The old vendor number as it existed
                     before conversion to the Lawson Accounts
                     Payable system.

VTB-LOCATION-CODE    Alpha 4                                     AP510
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
EDI Number           The vendor's electronic data
                     interchange (EDI) number.

VTB-VENDOR-VNAME     Alpha 30  (Lower Case)                      AP510   AP54.1
Vendor Name          The vendor name.

VTB-VENDOR-SNAME     Alpha 30                                    AP510   AP54.1
Vendor Search 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      AP510   HVTB.1
          OLD-VENDOR    table records for a vendor number within
          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, Duplicates
          EDI-NBR