Difference between revisions of "Purchasing.Vendor (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.Vendor |- |} {| border="1" cellpadding="5" cellspacing="0" style=...) |
(No difference)
|
Revision as of 13:35, 3 January 2009
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 |
