GO

/****** Object:  Table [dbo].[JobCard]    Script Date: 25-03-2025 19:56:27 ******/
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






GO

/****** Object:  Table [dbo].[JobCard]    Script Date: 25-03-2025 19:56:58 ******/
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