set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




ALTER PROCEDURE [dbo].[STPListInvoiceDetailPrint] 
	@SerialNo int
AS
SELECT     invoiceDetailTbl.GoodSysCode AS کدکالا, invoiceDetailTbl.Comment AS توضیحات_کالا, invoiceDetailTbl.Quantity AS تعداد, invoiceDetailTbl.Fee AS فی, 
                      invoiceDetailTbl.Unit AS واحد, invoiceDetailTbl.UnitRate AS نسبت_واحد, invoiceDetailTbl.UserPrice AS قیمت_مصرف_کننده, 
                      invoiceDetailTbl.SerialNo AS شماره_سریال, invoiceDetailTbl.DiscountPercent AS درصدتخفیف, StockTbl.Title AS نام_کالا, StockTbl.Code AS کدفنی, 
                      StockTbl.BarCode AS بارکد, invoiceDetailTbl.Term AS نحوه_پرداخت, StockTbl.Weight AS وزن, GoodSizeTbl.SizeName AS سایز, 
                      WareHouseTbl.WareHouseName AS انبار, GoodColorTbl.ColorName AS رنگ, invoiceDetailTbl.RowNo AS ردیف, 
                      invoiceDetailTbl.Fee * invoiceDetailTbl.UnitRate AS فی_واحد, 
                      invoiceDetailTbl.Fee * invoiceDetailTbl.Quantity * invoiceDetailTbl.UnitRate * invoiceDetailTbl.DiscountPercent AS تخفیف, 
                      invoiceDetailTbl.Fee * invoiceDetailTbl.Quantity * invoiceDetailTbl.UnitRate AS مبلغ, 
                      (invoiceDetailTbl.Fee * invoiceDetailTbl.Quantity * invoiceDetailTbl.UnitRate) * (1 - invoiceDetailTbl.DiscountPercent) AS مبلغ_کل
FROM         invoiceDetailTbl INNER JOIN
                      StockTbl ON invoiceDetailTbl.GoodSysCode = StockTbl.GoodSyscode LEFT OUTER JOIN
                      WareHouseTbl ON invoiceDetailTbl.WareHouse = WareHouseTbl.SysCode LEFT OUTER JOIN
                      GoodSizeTbl ON invoiceDetailTbl.Size = GoodSizeTbl.SysCode LEFT OUTER JOIN
                      GoodColorTbl ON invoiceDetailTbl.Color = GoodColorTbl.SysCode
WHERE     (invoiceDetailTbl.FK_InvoiceSysCode = @SerialNo)