Tables [dbo].[SCReturnedItems]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:19 AM Thursday, March 21, 2019
Last Modified1:15:31 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCReturnedItems: ReturnedItemIDReturnedItemIDint4
False
ShippedDatedatetime8
False
(getdate())
Foreign Keys FK_SCReturnedItems_ItemID_ICItems1: [dbo].[ICItems1].ItemIDItemIDint4
False
Foreign Keys FK_SCReturnedItems_VendorID_APVendors: [dbo].[APVendors].VendorIDVendorIDint4
False
ClaimNumbervarchar(30)30
False
TrackingNumbervarchar(30)30
False
Foreign Keys FK_SCReturnedItems_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
True
Foreign Keys FK_SCReturnedItems_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Remarksvarchar(1024)1024
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCReturnedItems: ReturnedItemIDPK_SCReturnedItemsReturnedItemID
True
80
NameNo CheckColumns
FK_SCReturnedItems_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_SCReturnedItems_CustomerID_ARCustomers
True
CustomerID->[dbo].[ARCustomers].[CustomerID]
FK_SCReturnedItems_ItemID_ICItems1ItemID->[dbo].[ICItems1].[ItemID]
FK_SCReturnedItems_VendorID_APVendorsVendorID->[dbo].[APVendors].[VendorID]
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