CREATE TABLE [dbo].[SCReportMaterialWarranties]
(
[SCReportMaterialWarrantyID] [int] NOT NULL IDENTITY(1, 1),
[ReportID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[WarrantyCodeID] [int] NOT NULL,
[ItemWarrantyTypeID] [int] NOT NULL,
[MostRecentActual] [decimal] (18, 6) NULL,
[PartEndDate] [datetime] NULL,
[PartEndMeter] [decimal] (18, 6) NULL,
[LaborEndDate] [datetime] NULL,
[LaborEndMeter] [decimal] (18, 6) NULL,
[WarrantyEndDate] [datetime] NULL,
[WarrantyEndMeter] [decimal] (18, 6) NULL,
[timestamp] [timestamp] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportMaterialWarranties] ADD CONSTRAINT [PK_SCReportMaterialWarranties] PRIMARY KEY CLUSTERED ([SCReportMaterialWarrantyID]) ON [PRIMARY]
GO