Purchasing.Vendor (table)
wikibot
| Table | Purchasing.Vendor |
| Column | Data Type | Nullable | Default | PK | Index |
| VendorID | int | not null | PK_Vendor_VendorID | ||
| AccountNumber | dbo.AccountNumber | not null | AK_Vendor_AccountNumber | ||
| Name | dbo.Name | not null | |||
| CreditRating | tinyint | not null | |||
| PreferredVendorStatus | dbo.Flag | not null | ((1)) | ||
| ActiveFlag | dbo.Flag | not null | ((1)) | ||
| PurchasingWebServiceURL | nvarchar(1024) | null | |||
| ModifiedDate | datetime | not null | (getdate()) |
| Detail Table | Column | Referencing Column |
| Purchasing.ProductVendor | VendorID | VendorID |
| Purchasing.PurchaseOrderHeader | VendorID | VendorID |
| Purchasing.VendorAddress | VendorID | VendorID |
| Purchasing.VendorContact | VendorID | VendorID |
| Triggers | Type |
| dVendor | INSTEAD OF DELETE |
