CREATE TABLE [dbo].[ICWarrantyCodes]
(
[WarrantyCodeID] [int] NOT NULL IDENTITY(1, 1),
[WarrantyTypeID] [int] NOT NULL,
[COGSGLID] [int] NOT NULL,
[DepartmentID] [int] NOT NULL,
[WarrantyCoverageCodeID] [int] NULL,
[WarrantyCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICWarrantyCodes_Description] DEFAULT (''),
[UserWarrantyNotice] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICWarrantyCodes_UserWarrantyNotice] DEFAULT (''),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICWarrantyCodes_Remarks] DEFAULT (''),
[ManufactureID] [int] NULL,
[WarrantyDescription] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICWarrantyCodes_WarrantyDescription] DEFAULT (''),
[WarrantyMeterTypeID] [int] NULL,
[PartCalenderCoverage] [bit] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_PartCalenderCoverage] DEFAULT ((0)),
[PartWarrantyPeriodID] [int] NULL,
[LaborCalenderCoverage] [bit] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_LaborCalenderCoverage] DEFAULT ((0)),
[LaborWarrantyPeriodID] [int] NULL,
[PartUsageCoverage] [bit] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_PartUsageCoverage] DEFAULT ((0)),
[PartUsageInterval] [int] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_PartUsageInterval] DEFAULT ((0)),
[LaborUsageCoverage] [bit] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_LaborUsageCoverage] DEFAULT ((0)),
[LaborUsageInterval] [int] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_LaborUsageInterval] DEFAULT ((0)),
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_DBFileHeaderID] DEFAULT ((1)),
[Active] [bit] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_Active] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICWarrantyCodes_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICWarrantyCodes] ADD CONSTRAINT [PK_ICWarrantyCodes] PRIMARY KEY CLUSTERED ([WarrantyCodeID]) ON [PRIMARY]
GO