/****** Object:  Table [dbo].[JobCard]    Script Date: 3/18/2025 4:22:55 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[JobCard](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[JobCardNo] [nvarchar](100) NOT NULL,
	[JobOrderNo] [nvarchar](50) NULL,
	[EntryDate] [datetime] NOT NULL,
	[JobCardDate] [datetime] NOT NULL,
	[PromisedDate] [datetime] NULL,
	[ChassisNo] [nvarchar](500) NULL,
	[PlateNo] [nvarchar](200) NULL,
	[VehicleCode] [nvarchar](500) NULL,
	[VehicleName] [nvarchar](500) NULL,
	[TypeCode] [nvarchar](500) NULL,
	[TypeName] [nvarchar](500) NULL,
	[EngineCode] [nvarchar](500) NULL,
	[EngineName] [nvarchar](500) NULL,
	[TransmissionCode] [nvarchar](500) NULL,
	[TransmissionName] [nvarchar](500) NULL,
	[Model] [nvarchar](500) NULL,
	[Colour] [nvarchar](500) NULL,
	[Kilometer] [nvarchar](500) NULL,
	[CustomerCode] [nvarchar](500) NULL,
	[CustomerName] [nvarchar](500) NULL,
	[DeliveredBy] [nvarchar](500) NULL,
	[ContactNo] [nvarchar](100) NULL,
	[TimeIn] [nvarchar](100) NULL,
	[TimeOut] [nvarchar](100) NULL,
	[GuaranteePeriod] [nvarchar](500) NULL,
	[BillType] [nvarchar](50) NULL,
	[Reference] [nvarchar](500) NULL,
	[Status] [nvarchar](50) NULL,
	[Salesman] [nvarchar](500) NULL,
	[VehicleInfo] [nvarchar](max) NULL,
	[Comments] [nvarchar](max) NULL,
	[BranchName] [varchar](100) NULL,
	[BranchCode] [varchar](100) NULL,
	[Brand] [varchar](500) NULL,
	[Category] [varchar](500) NULL,
	[Remarks] [nvarchar](500) NULL,
	[Year] [nvarchar](500) NULL,
	[GrossAmount] [float] NULL,
	[LessPerc] [float] NULL,
	[LessAmount] [float] NULL,
	[NetAmount] [float] NULL,
	[vattotal] [float] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO




/****** Object:  Table [dbo].[JobCardDetails]    Script Date: 3/18/2025 4:23:18 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[JobCardDetails](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[JobCardNo] [nvarchar](50) NOT NULL,
	[Branch] [nvarchar](15) NULL,
	[EntryDate] [datetime] NULL,
	[ItemCode] [nvarchar](500) NULL,
	[ItemName] [nvarchar](2000) NULL,
	[ArabicName] [nvarchar](500) NULL,
	[Unit] [nvarchar](50) NULL,
	[Qty] [float] NULL,
	[Rate] [float] NULL,
	[Amount] [float] NULL,
	[SlNo] [numeric](18, 0) NULL,
	[Cost] [float] NULL,
	[DocumentNo] [numeric](18, 0) NULL,
	[SQTY] [float] NULL,
	[Sales] [float] NULL,
	[QtyPerUnit] [float] NULL,
	[TOTQty] [float] NULL,
	[PerQty] [float] NULL,
	[stdcost] [float] NULL,
	[RateAfterDisc] [float] NULL,
	[RetQty] [float] NULL,
	[Deleted] [nvarchar](500) NULL,
	[VATPER] [float] NULL,
	[VATAMT] [float] NULL,
	[VAT] [float] NULL,
	[IDiscPer] [float] NULL,
	[IDiscRate] [float] NULL,
	[NetDiscPer] [float] NULL,
	[NetDiscAmt] [float] NULL,
	[NetVatAmt] [float] NULL,
	[SubId] [int] NULL,
	[BranchCode] [nvarchar](500) NULL,
	[BranchName] [nvarchar](500) NULL,
	[AvgCost] [float] NULL,
	[AvgCostWtQty] [float] NULL,
	[LineTotal] [float] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

insert into setup(code,svalue) values('JobCardNo','1000');
go

alter table invoice 
add JobCardNo nvarchar(100);
go

alter table Quotation 
add JobCardNo nvarchar(100);
go

alter table DeliveryNote 
add JobCardNo nvarchar(100);
go

alter table ProformaInvoice 
add JobCardNo nvarchar(100);
go