Table: dbo.Vendor_Type | |||
Table used to store the types of vendors. | |||
Columns | |||
Name | Type | Constraints | Description |
vendor_type_KEY | int (4) | NOT NULL | Primary key for this table. |
description | nvarchar (28) | NOT NULL | Description of the vendor type. |
Primary key | |||
Name | Columns | Description | |
PK_Vendor_Type | vendor_type_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Vendor_Type$description | description |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Vendor__Vendor_Type__current__vendor_type_KEY | current__vendor_type_KEY | Vendor | |
FK_Manage_AP_Payment_Processable_Transaction__Vendor_Type__vendor_type_KEY | vendor_type_KEY | Manage_AP_Payment_Processable_Transaction |