Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVENTABLE


                            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