CREATE TABLE [dbo].[SCReturnedItems]
(
[ReturnedItemID] [int] NOT NULL,
[ShippedDate] [datetime] NOT NULL CONSTRAINT [DF_SCReturnedItems_ShippedDate] DEFAULT (getdate()),
[ItemID] [int] NOT NULL,
[VendorID] [int] NOT NULL,
[ClaimNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TrackingNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerID] [int] NULL,
[CallID] [int] NULL,
[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_SCReturnedItems_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCReturnedItems_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCReturnedItems_Remarks] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReturnedItems] ADD CONSTRAINT [PK_SCReturnedItems] PRIMARY KEY CLUSTERED ([ReturnedItemID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReturnedItems] ADD CONSTRAINT [FK_SCReturnedItems_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCReturnedItems] WITH NOCHECK ADD CONSTRAINT [FK_SCReturnedItems_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCReturnedItems] ADD CONSTRAINT [FK_SCReturnedItems_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[SCReturnedItems] ADD CONSTRAINT [FK_SCReturnedItems_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO