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        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