ALTER PROCEDURE [dbo].[sp_SaveJobCard]
    @DocNo NVARCHAR(100)
AS
BEGIN
    SELECT
        j.JobCardNo, j.JobOrderNo, j.EntryDate, j.JobCardDate, j.PromisedDate, j.ChassisNo, j.PlateNo, j.Model, 
        j.Colour, j.Kilometer, j.CustomerCode, j.CustomerName, j.DeliveredBy, j.ContactNo, j.TimeIn, j.GuaranteePeriod, 
        j.BillType, j.Reference, j.Status, j.Salesman, j.VehicleInfo, j.Comments, j.BranchName, j.BranchCode, j.Brand,
		j.Remarks, j.Year, j.GrossAmount, j.LessPerc, j.LessAmount, j.NetAmount,j.vattotal,
		i.itemcode,i.ItemName,i.ItemNameAR,i.Category,jd.Qty,jd.Unit,jd.Rate,jd.Amount,jd.VATAMT,
		c.Name as CustomerName,c.Vatno
        
    FROM JobCard j
    JOIN JobOrder jo ON jo.JobOrderNo = j.JobOrderNo
    JOIN JobCardDetails jd ON jd.JobCardNo= j.JobCardNo
	Join Item i on i.itemcode=jd.ItemCode
	JOIN Customer c on j.CustomerCode=c.Code
    WHERE j.JobCardNo = @DocNo
END