Purchasing.Vendor (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:17Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:28Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:46Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:31Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:53Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:09Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:22Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:34Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:46Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.Vendor |- |} {| border="1" cellpadding="5" cellspacing="0" style=...

2009-01-03T12:35:22Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.Vendor |- |} {| border="1" cellpadding="5" cellspacing="0" style=...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Purchasing.Vendor
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''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())
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
| VendorID
| VendorID
|-
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
| VendorID
| VendorID
|-
| [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
| VendorID
| VendorID
|-
| [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
| VendorID
| VendorID
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Triggers
| '''Type

|-
| dVendor
| INSTEAD OF DELETE
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Purchasing.Vendor
@@ Line 8: / Line 8: @@
 | '''Description
 | Companies from whom Adventure Works Cycles purchases parts or other goods.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | VendorID
@@ Line 76: / Line 74: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Vendor_VendorID
 | VendorID
@@ Line 87: / Line 85: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_Vendor_AccountNumber
 | Unique
@@ Line 100: / Line 98: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_Vendor_CreditRating
 | ([CreditRating]>=(1) AND [CreditRating]<=(5))
@@ Line 113: / Line 111: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
 | VendorID
 | VendorID
-|-
+|- valign="top"
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 | VendorID
 | VendorID
-|-
+|- valign="top"
 | [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
 | VendorID
 | VendorID
-|-
+|- valign="top"
 | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
 | VendorID
@@ Line 135: / Line 133: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Triggers
+| '''Trigger
 | '''Type
-−
-|-
+|- valign="top"
 | dVendor
 | INSTEAD OF DELETE
 |}
-	Trigger dVendor
+==== Trigger dVendor ====
 <pre>
 CREATE TRIGGER [Purchasing].[dVendor] ON [Purchasing].[Vendor]
@@ Line 188: / Line 186: @@
 END;
 </pre>
-−
 === References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
@@ Line 199: / Line 197: @@
 | '''Child Object
-|-
+|- valign="top"
 | Data Type
 | Type
@@ Line 206: / Line 204: @@
+|
+|
-|-
+|- valign="top"
 | Data Type
 | Type
@@ Line 213: / Line 211: @@
+|
+|
-|-
+|- valign="top"
 | Data Type
 | Type
@@ Line 220: / Line 218: @@
+|
+|
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 227: / Line 225: @@
+|
+|
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 234: / Line 232: @@
 | Trigger
 | dVendor
-|-
+|- valign="top"
 | Execute
 | Procedure
@@ Line 250: / Line 248: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View

@@ Line 119: / Line 119: @@
 | Purchasing.Vendor
 |- valign="top"
 | '''Description
 | Companies from whom Adventure Works Cycles purchases parts or other goods.
 |-
 |}

@@ Line 225: / Line 225: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
-| '''Object Type
-| '''Dependency Type
+| '''Child Type
 |-
 | [[dbo.AccountNumber_(type)|dbo.AccountNumber]]
 | Type
 | Data Type
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
-| Type
-| Data Type
 |-
 | Schema
 | Schema
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
-| Procedure
 | Trigger
 | dVendor
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
-| Procedure
 | Trigger
 | dVendor
@@ Line 262: / Line 279: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
-| View
 |}

@@ Line 228: / Line 228: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.AccountNumber_(type)|dbo.AccountNumber]]
@@ Line 241: / Line 241: @@
 | Type
 | Data Type
 |-
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 | Procedure
 | Execute
 |-
 | [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 | Procedure
 | Execute
 |}
@@ Line 257: / Line 265: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Purchasing.vVendor_(view)|Purchasing.vVendor]]

@@ Line 118: / Line 118: @@
 | '''Table
 | Purchasing.Vendor
-|-
+|- valign="top"
 | '''Description
@@ Line 140: / Line 140: @@
 | not null
+|
-| Primary key for Vendor records.PK_Vendor_VendorID
+| Primary key for Vendor records.<br />PK_Vendor_VendorID
 |- valign="top"
 | AccountNumber
@@ Line 146: / Line 146: @@
 | not null
+|
-| Vendor account (identification) number.AK_Vendor_AccountNumber
+| Vendor account (identification) number.<br />AK_Vendor_AccountNumber
 |- valign="top"
 | Name
@@ Line 152: / Line 152: @@
 | not null
+|
-| Company name.
+| Company name.<br />
 |- valign="top"
 | CreditRating
@@ Line 158: / Line 158: @@
 | not null
+|
-| 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average
+| 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average<br />
 |- valign="top"
 | PreferredVendorStatus
@@ Line 164: / Line 164: @@
 | not null
 | (1)
-| 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
+| 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.<br />
 |- valign="top"
 | ActiveFlag
@@ Line 170: / Line 170: @@
 | not null
 | (1)
-| 0 = Vendor no longer used. 1 = Vendor is actively used.
+| 0 = Vendor no longer used. 1 = Vendor is actively used.<br />
 |- valign="top"
 | PurchasingWebServiceURL
@@ Line 176: / Line 176: @@
 | null
+|
-| Vendor URL.
+| Vendor URL.<br />
 |- valign="top"
 | ModifiedDate
@@ Line 182: / Line 182: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}

@@ Line 73: / Line 73: @@
 | (getdate())
+|
+|
 |}