CREATE TABLE [dbo].[ICTransactionWarranties]
(
[TransactionWarrantyID] [int] NOT NULL IDENTITY(1, 1),
[TransactionWarrantyGroupID] [int] NOT NULL,
[WarrantyCodeID] [int] NULL,
[ItemWarrantyTypeID] [int] NOT NULL,
[WarrantyTypeID] [int] NOT NULL,
[WarrantyMeterTypeID] [int] 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,
[UserWarrantyNotice] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransactionWarranties_UserWarrantyNotice] DEFAULT (''),
[ExpiringMeterReadingGroupID] [int] NULL,
[MostRecentActual] [decimal] (18, 6) NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_ICTransactionWarranties_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_ICTransactionWarranties_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICTransactionWarranties_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransactionWarranties] ADD CONSTRAINT [PK_ICTransactionWarranties] PRIMARY KEY CLUSTERED ([TransactionWarrantyID]) ON [PRIMARY]
GO