CREATE TABLE [dbo].[ICRequestDetails]
(
[RequestID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UM] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NOT NULL,
[Picketed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICRequestDetails_Picketed] DEFAULT ((0)),
[Transfered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICRequestDetails_Transfered] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICRequestDetails_Canceled] DEFAULT ((0)),
[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_ICRequestDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICRequestDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[PurchaseOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICRequestDetails_PurchaseOrdered] DEFAULT ((0)),
[TransferOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICRequestDetails_TransferOrdered] DEFAULT ((0)),
[RequestDetailID] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICRequestDetails] ADD CONSTRAINT [PK_ICRequestDetails] PRIMARY KEY CLUSTERED ([RequestID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICRequestDetails] ADD CONSTRAINT [FK_ICRequestDetails_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICRequestDetails] ADD CONSTRAINT [FK_ICRequestDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[ICRequestDetails] ADD CONSTRAINT [FK_ICRequestDetails_RequestID_ICRequests] FOREIGN KEY ([RequestID]) REFERENCES [dbo].[ICRequests] ([RequestID])
GO
ALTER TABLE [dbo].[ICRequestDetails] ADD CONSTRAINT [FK_ICRequestDetails_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO