APVENTABLE – Vendor Table

System
Accounts Payable (AP)
Prefix
VTB
Primary key
VENDOR-GROUP, OLD-VENDOR, LOCATION-CODE
Fields
7
Updated by
3 programs
Referenced by
1 program

APVENTABLE is the Vendor Table table in Lawson Accounts Payable (prefix VTB). It is indexed by VENDOR-GROUP, OLD-VENDOR, LOCATION-CODE (VTBSET1); alternate indexes: VTBSET3. It is updated by AP300, AP510 and AP54.1 and referenced by HVTB.1. The table has 7 fields, 2 indexes and 0 documented relations.

About APVENTABLE

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.

Fields (7)

Column = COBOL field name without the VTB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#VTB-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4The vendor group. Must be a valid record in the Vendor Group file.AP510, AP54.1
#VTB-VENDOR SET3
VENDOR		Alpha 9 (Right Justified)The Lawson vendor number. Must be a valid record in the Vendor file.AP510, AP54.1
#VTB-OLD-VENDOR PK
OLD_VENDOR		Alpha 9 (Right Justified)The old vendor number as it existed before conversion to the Lawson Accounts Payable application.AP510, AP54.1
#VTB-LOCATION-CODE PK
LOCATION_CODE		Alpha 4A user-defined code that represents an alternate purchasing or remittance location for the vendor.AP510, AP54.1
#VTB-EDI-NBR SET3
EDI_NBR		Alpha 15The vendor's electronic data interchange (EDI) number. Used for reference.AP510, AP54.1
#VTB-VENDOR-VNAME
VENDOR_VNAME		Alpha 30 (Lower Case)The vendor name.AP510, AP54.1
#VTB-VENDOR-SNAME
VENDOR_SNAME		Alpha 30The search name for the vendor.AP510, AP54.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
VTBSET1
  1. VENDOR-GROUP
  2. OLD-VENDOR
  3. LOCATION-CODE
PrimaryAP300, AP510, AP54.1, HVTB.1
VTBSET3
  1. VENDOR-GROUP
  2. OLD-VENDOR
  3. VENDOR
  4. EDI-NBR
  5. LOCATION-CODE
KeyChangeAP510, AP54.1

Programs

Updated by (3)

Referenced by (1)