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)