Website.CalculateCustomerPrice

Generated using SQL Data Dictionary demo version.

Scalar Function Website.CalculateCustomerPrice

Parameter	Data Type	Default
@CustomerID	int
@StockItemID	int
@PricingDate	date

Result:

Data Type	Nullable
decimal(18,2)	X

Used by:

Procedure
Website.InsertCustomerOrders

Uses:

Table
Sales.Customers
- BuyingGroupID
- CustomerCategoryID
- CustomerID
Table
Sales.SpecialDeals
- BuyingGroupID
- CustomerCategoryID
- CustomerID
- DiscountAmount
- DiscountPercentage
- EndDate
- StartDate
- StockGroupID
- StockItemID
- UnitPrice
Table
Warehouse.StockItems
- StockItemID
- UnitPrice
Table
Warehouse.StockItemStockGroups
- StockGroupID
- StockItemID