Notes

SELECT TOP 10
A.SalesPrice AS DealSalesPrice,
A.TradeAllowance1 AS DealTradeAllowance1,
A.TradeAllowance2 AS DealTradeAllowance2,
A.DealerFee AS DealDealerFee,
A.WarrantyPrice AS DealWarranty,
A.CountyTaxName AS SalesTaxName,
A.CountyTaxRate AS SalesTaxRate,
A.SalesTax AS DealSalesTax,
A.Title + A.Tags + A.Registration AS DealTitleTagRegistration,
A.TIPayoff1 + A.TIPayoff2 AS DealPayoff,
A.DownPayment1 + A.DownPayment2 + A.DownPayment3 AS DealDownPayment,
A.Rebates AS DealRebates, A.BalanceDue AS DealBalanceDue,
A.Discount AS DealDiscount,
A.*,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = H.VendorID)) AS WarrantyCompanyName,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = I.VendorID)) AS GAPCompanyName,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = J.VendorID)) AS Product1CompanyName,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = K.VendorID)) AS Product2CompanyName,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = L.VendorID)) AS Product3CompanyName,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = M.VendorID)) AS Product4CompanyName,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = N.VendorID)) AS Product5CompanyName,
(SELECT VendorName FROM VendorListTable WHERE (VendorListTable.VendorID = O.VendorID)) AS Product6CompanyName,
(SELECT SUM((Quantity * Part) + Labor) FROM WeOweTable WHERE DealNumber = A.AccountNumber) AS WeOweCost,
(SELECT SUM(CASH + [CHECK] + CHARGE) FROM CashierTable WHERE (CashierTable.AccountNumber = A.AccountNumber) AND (TransactionType = 'Deals') AND (Reason IN ('Down Payment', 'Down Payment Refund'))) AS DownPaymentReceived,
(SELECT SUM(CASH + [CHECK] + CHARGE) FROM CashierTable WHERE (CashierTable.AccountNumber = A.AccountNumber) AND (TransactionType = 'Deals') AND (Reason IN ('Tag', 'Tag Refund'))) AS TagReceived,
B.Thumbnail AS [Image] , B.VIN AS BVIN, B.Year AS Byear, B.Make AS Bmake, B.Model AS Bmodel, B.Trim AS Btrim, B.Pack AS BPack, B.Cost AS BCost,
ISNULL(BV.VendorFee, 0) AS BVFloorFee,
E.CustomerCode AS ECustomerCode, E.FirstName + ' ' + E.LastName AS ECustommerName,
F.CustomerCode AS FCustomerCode,
G.CountyName AS GCountyName, G.SalesTax AS GSalesTax, G.SurplusTax AS GSurplusTax, G.SurplusAmount AS GSurplusAmount,
FM.FirstName + ' ' + FM.LastName AS FinanceManager, SM.FirstName + ' ' + SM.LastName AS SalesManager
FROM DealsTable AS A
LEFT OUTER JOIN InventoryTable AS B ON B.StockNumber = A.StockNumber
LEFT JOIN VendorListTable BV ON B.FlooredBy = BV.VendorName
LEFT OUTER JOIN CustomerTable AS E ON E.CustomerCode = A.BuyerCode
LEFT OUTER JOIN CustomerTable AS F ON F.CustomerCode = A.CoBuyerCode
LEFT OUTER JOIN SalesTaxTable AS G ON G.CountyName = A.CountyTaxName
LEFT OUTER JOIN DealProductsTable AS H ON H.ProductID = A.WarrantyID
LEFT OUTER JOIN DealProductsTable AS I ON I.ProductID = A.GapID
LEFT OUTER JOIN DealProductsTable AS J ON J.ProductID = A.ProductID1
LEFT OUTER JOIN DealProductsTable AS K ON K.ProductID = A.ProductID2
LEFT OUTER JOIN DealProductsTable AS L ON L.ProductID = A.ProductID3
LEFT OUTER JOIN DealProductsTable AS M ON M.ProductID = A.ProductID4
LEFT OUTER JOIN DealProductsTable AS N ON N.ProductID = A.ProductID5
LEFT OUTER JOIN DealProductsTable AS O ON O.ProductID = A.ProductID6
LEFT OUTER JOIN DMSData.dbo.UsersTable AS FM ON A.FinanceManagerID = FM.UserID
LEFT OUTER JOIN DMSData.dbo.UsersTable AS SM ON A.SalesManagerID = SM.UserID