Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Search Engine

Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.



Filter by Category


This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 4 results.

Sales SalesPersonQuotaHistory (table) — 40.0%

[...] number. Foreign key to SalesPerson.SalesPersonID. QuotaDate datetime not null Sales quota date. SalesQuota money not null Sales quota amount. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate SalesPersonID, QuotaDate Indexes Index Type Columns AK_SalesPersonQuotaHistory_rowguid Unique rowguid [...]

Sales SalesPerson (table) — 40.0%

[...] 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. ModifiedDate datetime [...]

WikiMarkup — 10.0%

[...] ShipRate CreditRating CustomerType UnitPriceDiscount DueDate Bonus CommissionPct SalesLastYear SalesQuota SalesYTD TaxType CostLastYear CostYTD [...]

Sales vSalesPerson (view) — 10.0%

[...] ,[CountryRegionName] = cr.[Name] ,[TerritoryName] = st.[Name] ,[TerritoryGroup] = st.[Group] ,s.[SalesQuota] ,s.[SalesYTD] ,s.[SalesLastYear] FROM [...]

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.