From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| SalesPersonID
|
int
|
not null
|
|
PK_SalesPerson_SalesPersonID
|
|
| TerritoryID
|
int
|
null
|
|
|
|
| SalesQuota
|
money
|
null
|
|
|
|
| Bonus
|
money
|
not null
|
((0.00))
|
|
|
| CommissionPct
|
smallmoney
|
not null
|
((0.00))
|
|
|
| SalesYTD
|
money
|
not null
|
((0.00))
|
|
|
| SalesLastYear
|
money
|
not null
|
((0.00))
|
|
|
| rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_SalesPerson_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
automatically generated
| Table
|
Sales.SalesPerson
|
| Description
|
Sales representative current information.
|
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
PK / Index
|
| SalesPersonID
|
int
|
not null
|
|
Primary key for SalesPerson records.
|
PK_SalesPerson_SalesPersonID
|
| TerritoryID
|
int
|
null
|
|
Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
|
|
| SalesQuota
|
money
|
null
|
|
Projected yearly sales.
|
|
| Bonus
|
money
|
not null
|
(0.00)
|
Bonus due if quota is met.
|
|
| CommissionPct
|
smallmoney
|
not null
|
(0.00)
|
Commision percent received per sale.
|
|
| SalesYTD
|
money
|
not null
|
(0.00)
|
Sales total year to date.
|
|
| SalesLastYear
|
money
|
not null
|
(0.00)
|
Sales total of previous year.
|
|
| rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
AK_SalesPerson_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
|
