Sales.SalesPerson (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:42Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:04Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:18Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:01Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:24Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:13Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:29Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:52Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:05Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:17Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.SalesPerson
@@ Line 8: / Line 8: @@
 | '''Description
 | Sales representative current information.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | SalesPersonID
@@ Line 82: / Line 80: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_SalesPerson_SalesPersonID
 | SalesPersonID
@@ Line 93: / Line 91: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_SalesPerson_rowguid
 | Unique
@@ Line 106: / Line 104: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_SalesPerson_Bonus
 | ([Bonus]>=(0.00))
 | Check constraint [Bonus] >= (0.00)
-|-
+|- valign="top"
 | CK_SalesPerson_CommissionPct
 | ([CommissionPct]>=(0.00))
 | Check constraint [CommissionPct] >= (0.00)
-|-
+|- valign="top"
 | CK_SalesPerson_SalesLastYear
 | ([SalesLastYear]>=(0.00))
 | Check constraint [SalesLastYear] >= (0.00)
-|-
+|- valign="top"
 | CK_SalesPerson_SalesQuota
 | ([SalesQuota]>(0.00))
 | Check constraint [SalesQuota] > (0.00)
-|-
+|- valign="top"
 | CK_SalesPerson_SalesYTD
 | ([SalesYTD]>=(0.00))
@@ Line 135: / Line 133: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
 | SalesPersonID
 | EmployeeID
-|-
+|- valign="top"
 | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 | TerritoryID
@@ Line 152: / Line 150: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | SalesPersonID
 | SalesPersonID
-|-
+|- valign="top"
 | [[Sales.SalesPersonQuotaHistory_(table)|Sales.SalesPersonQuotaHistory]]
 | SalesPersonID
 | SalesPersonID
-|-
+|- valign="top"
 | [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]]
 | SalesPersonID
 | SalesPersonID
-|-
+|- valign="top"
 | [[Sales.Store_(table)|Sales.Store]]
 | SalesPersonID
@@ Line 178: / Line 176: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 195: / Line 193: @@
 | '''Child Object
-|-
+|- valign="top"
 | Select
 | View
@@ Line 202: / Line 200: @@
+|
+|
-|-
+|- valign="top"
 | Select
 | View
@@ Line 209: / Line 207: @@
+|
+|
-|-
+|- valign="top"
 | Update
 | Table

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for SalesPerson records.<br />PK_SalesPerson_SalesPersonID
+| Primary key for SalesPerson records.
 |- valign="top"
 | TerritoryID
@@ Line 31: / Line 32: @@
 | null
+|
-| Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.<br />
+| Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
 |- valign="top"
 | SalesQuota
@@ Line 37: / Line 38: @@
 | null
+|
-| Projected yearly sales.<br />
+| Projected yearly sales.
 |- valign="top"
 | Bonus
@@ Line 43: / Line 44: @@
 | not null
 | ((0.00))
-| Bonus due if quota is met.<br />
+| Bonus due if quota is met.
 |- valign="top"
 | CommissionPct
@@ Line 49: / Line 50: @@
 | not null
 | ((0.00))
-| Commision percent received per sale.<br />
+| Commision percent received per sale.
 |- valign="top"
 | SalesYTD
@@ Line 55: / Line 56: @@
 | not null
 | ((0.00))
-| Sales total year to date.<br />
+| Sales total year to date.
 |- valign="top"
 | SalesLastYear
@@ Line 61: / Line 62: @@
 | not null
 | ((0.00))
-| Sales total of previous year.<br />
+| Sales total of previous year.
 |- valign="top"
 | rowguid
@@ Line 67: / Line 68: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesPerson_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 73: / Line 74: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 94: / Line 146: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 119: / Line 171: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 151: / Line 217: @@
 | uSalesOrderHeader
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.SalesPerson
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | SalesPersonID
 | int
 | not null
+|
-| PK_SalesPerson_SalesPersonID
+| Primary key for SalesPerson records.<br />PK_SalesPerson_SalesPersonID
+|- valign="top"
 | TerritoryID
 | int
 | null
+|
+| Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.<br />
+|- valign="top"
 | SalesQuota
 | money
 | null
+|
+| Projected yearly sales.<br />
+|- valign="top"
 | Bonus
 | money
 | not null
 | ((0.00))
+| Bonus due if quota is met.<br />
+|- valign="top"
 | CommissionPct
 | smallmoney
 | not null
 | ((0.00))
+| Commision percent received per sale.<br />
+|- valign="top"
 | SalesYTD
 | money
 | not null
 | ((0.00))
+| Sales total year to date.<br />
+|- valign="top"
 | SalesLastYear
 | money
 | not null
 | ((0.00))
+| Sales total of previous year.<br />
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesPerson_rowguid
-| AK_SalesPerson_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 125: / Line 118: @@
 | SalesPersonID
 |}
 == automatically generated ==

@@ Line 132: / Line 132: @@
 | Sales.SalesPerson
 |- valign="top"
 | '''Description
 | Sales representative current information.
 |-
 |}

@@ Line 250: / Line 250: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}
@@ Line 263: / Line 264: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
-| '''Object Type
-| '''Reference Type
+| '''Child Type
 |-
 | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 | View
 | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
-| View
-| Select
 |-
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
-| Table
 | Trigger
 | uSalesOrderHeader
 |}