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.
This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 6 results.
[...] CurrencyRateID int null Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID. SubTotal money not null ((0.00)) Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID. TaxAmt money not null ((0.00)) Tax amount. Freight money not null ((0.00)) Shipping cost. TotalDue Total due from customer. Computed as Subtotal + TaxAmt + Freight. Comment nvarchar(128) null Sales representative comments. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL [...]
[...] (getdate()) Purchase order creation date. ShipDate datetime null Estimated shipment date from the vendor. SubTotal money not null ((0.00)) Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID. TaxAmt money not null ((0.00)) Tax amount. Freight money not null ((0.00)) Shipping cost. TotalDue Total due to vendor. Computed as Subtotal + TaxAmt + Freight. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary [...]
[...] UnitPrice money not null Vendor's selling price of a single product. LineTotal Per product subtotal. Computed as OrderQty * UnitPrice. ReceivedQty decimal(8, 2) not null Quantity actually received from the vendor. RejectedQty decimal(8, 2) not null Quantity rejected during inspection. StockedQty Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID [...]
[...] single product. UnitPriceDiscount money not null ((0.0)) Discount amount. LineTotal Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty. 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_SalesOrderDetail_SalesOrderID_SalesOrderDetailID SalesOrderID, SalesOrderDetailID Indexes Index Type Columns AK_SalesOrderDetail_rowguid [...]
[...] '') + ' ' + c.[LastName] AS [FullName]
,e.[Title]
,st.[Name] AS [SalesTerritory]
,soh.[SubTotal]
,YEAR(DATEADD(m, 6, soh.[OrderDate])) AS [FiscalYear]
FROM [Sales].[SalesPerson] sp
INNER JOIN [Sales].[SalesOrderHeader] soh
ON sp.[SalesPersonID] = soh.[SalesPersonID]
INNER JOIN [Sales].[SalesTerritory] st
ON sp.[TerritoryID] = st.[TerritoryID]
INNER JOIN [HumanResources].[Employee] e
ON soh.[SalesPersonID] = e.[EmployeeID]
INNER JOIN [Person].[Contact] c
ON e.[ContactID] = c.ContactID
) AS soh
PIVOT [...]
[...] MinOrderQty OnOrderQty StandardPrice ReceivedQty RejectedQty UnitPrice Freight OrderDate ShipDate SubTotal TaxAmt ShipBase ShipRate CreditRating [...]