Data information
The information below tells you more about the SQL table where AGR houses this data, its importance and an external link to more information about the SQL table.
Importance | Required |
Description | Active vendors |
Criteria | All active vendors |
Primary key | NO |
Table documentation |
Column and type
The information below breaks down the data for this SQL table into columns, descriptions and types.
Column | Functional description | Type |
NO | The vendor number | nvarchar(255) |
NAME | The vendor name | nvarchar(255) |
LEAD_TIME_DAYS | The estimated number of days it takes for an order to arrive from the vendor from the moment it is placed | smallint |
CLOSED | 1 if the company no longer trades with the vendor; 0 otherwise | bit |