pur.suppliers
| Documentation | Procurement |
| Schema | pur |
| Name | suppliers |
| Module | Suppliers |
List of current, past and potential suppliers.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Sensitive | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | supplier_id | int | Identity | Supplier system id | |||||
| Supplier system id Identity |
|||||||||
| 2 | supplier_name | nvarchar(50) | Full name of the supplier used on the documents | ||||||
| Full name of the supplier used on the documents |
|||||||||
| 3 | short_name | nvarchar(50) | Short name used in the UI | ||||||
| Short name used in the UI |
|||||||||
| 4 | address | nvarchar(500) | Address | ||||||
| Address |
|||||||||
| 5 | postal_code | nvarchar(50) | Postal code | ||||||
| Postal code |
|||||||||
| 6 | country | nchar(10) | Country | ||||||
| Country |
|||||||||
| 7 | approved_flag | bit | Is supplier approved | ||||||
| Is supplier approved |
|||||||||
| 8 | attribute1 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 9 | attribute2 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 10 | attribute3 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 11 | attribute4 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 12 | attribute5 | nvarchar(150) | Login of employee who approved supplier | Y | |||||
| Login of employee who approved supplier Sensitive: Y |
|||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| pur.item_suppliers (Item suppliers) | pur.suppliers | pur.item_suppliers.supplier_id = pur.suppliers.supplier_id | FK_item_suppliers_suppliers |
|
|
pur.item_suppliers.supplier_id = pur.suppliers.supplier_id Name: FK_item_suppliers_suppliers |
||||
| pur.purchase_orders | pur.suppliers | pur.purchase_orders.supplier_id = pur.suppliers.supplier_id | FK_purchase_orders_suppliers |
|
|
pur.purchase_orders.supplier_id = pur.suppliers.supplier_id Name: FK_purchase_orders_suppliers |
||||
| pur.quotations | pur.suppliers | pur.quotations.supplier_id = pur.suppliers.supplier_id | FK_quotations_suppliers |
|
|
pur.quotations.supplier_id = pur.suppliers.supplier_id Name: FK_quotations_suppliers |
||||
| pur.rfqs (RFQs) | pur.suppliers | pur.rfqs.supplier_id = pur.suppliers.supplier_id | FK_rfqs_suppliers |
|
|
pur.rfqs.supplier_id = pur.suppliers.supplier_id Name: FK_rfqs_suppliers |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_vendors | supplier_id | ||
Used by
| Name |
|---|
|
pur.suppliers
|
Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:11