Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VENDOR GROUP Table


Stores vendor purchasing group assignments and related sales contact information. Each row represents a vendor-to-purchasing-group relationship used for procurement and sourcing processes.


Field Name

Description

Data Type

Length

PURCHASING_GROUP

Code representing the purchasing group responsible for managing procurement activities for the vendor.

VARCHAR2

4

SALESPERSON

Name of the vendor sales representative assigned to the purchasing group or account.

VARCHAR2

40

SALESPERSON_TELEPHONE

Telephone number of the vendor sales representative associated with the purchasing group.

VARCHAR2

16

VENDOR_NUMBER

Unique identifier of the vendor associated with the purchasing group.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse for reporting and auditing purposes.

DATE