Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VENDOR GROUP Table


View exposing vendor purchasing group assignments and related sales contact information used in 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