Vendor
The primary key of the table is VENDOR_ID.
The access path in the UI is Acquisitions > Acquisitions Infrastructure > Vendors > Add/Edit Vendor.
See Adding a Vendor and Vendor Account for more information.
| Field | Description | Field Location in Alma | Additional Information | Data Type | Data Size |
|---|---|---|---|---|---|
| Additional Code | A code in addition to the vendor code. | Summary tab on "Vendor Details". | VARCHAR | 255 | |
| Creation Date | The date the vendor was created. |
Right information pane for "Vendor Details" page. Label in Alma is "Created on". |
DATE | ||
| Creator | The user who created the vendor |
Right information pane for "Vendor Details" page. Label in Alma is "Created by". |
VARCHAR | 255 | |
| ERP Code | A code used by an institution's financial system, such as the Enterprise Resource Planning (ERP) system |
Summary tab on "Vendor Details". Label in Alma is "Financial Sys. code". |
VARCHAR | 255 | |
| Modification Date | The date the vendor was modified |
Right information pane for "Vendor Details" page. Label in Alma is "Last updated on". |
DATE | ||
| Modified By | The user who modified the vendor |
Right information pane for "Vendor Details" page. Label in Alma is "Last updated by". |
VARCHAR | 255 | |
| Vendor Code | The vendor code unique to the institution |
Summary tab on "Vendor Details". Label in Alma is "Code". |
All the vendors that have been on the order, not just the active vendor. The code must be unique across all vendors. Note that the PO Lines tab displays all PO lines whose vendor code is the current vendor. |
VARCHAR | 255 |
| Vendor Name | The vendor name |
Summary tab on "Vendor Details". Label in Alma is "Name". |
It is a required field. | VARCHAR | 255 |
| Vendor Status | The status of the vendor |
Summary tab on "Vendor Details". Label in Alma is "Status". |
Possible values:
|
VARCHAR | 255 |