CREATE TABLE [dbo].[ICItemWarehouses]
(
[ItemID] [int] NOT NULL,
[WarehouseID] [int] NOT NULL,
[StockMin] [decimal] (18, 6) NOT NULL,
[StockMax] [decimal] (18, 6) NOT NULL,
[OnHandQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_OnHandQty] 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_ICItemWarehouses_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICItemWarehouses_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[StandardQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_StandardQty] DEFAULT ((0)),
[DefectiveQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_DefectiveQty] DEFAULT ((0)),
[UnavailableQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_UnavailableQty] DEFAULT ((0)),
[Ordered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_Ordered] DEFAULT ((0)),
[Allocated] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_Allocated] DEFAULT ((0)),
[StockingCodeID] [int] NULL,
[TransferOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_TransferOrdered] DEFAULT ((0)),
[AllowAutoStockQtyUpdates] [bit] NOT NULL CONSTRAINT [DF_ICItemWarehouses_AllowAutoStockQtyUpdates] DEFAULT ((0)),
[TransferAllocated] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_TransferAllocated] DEFAULT ((0)),
[BackOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_BackOrdered] DEFAULT ((0)),
[TransferBackOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_TransferBackOrdered] DEFAULT ((0)),
[PendingAllocated] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_PendingAllocated] DEFAULT ((0)),
[OrderedAllocated] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_OrderedAllocated] DEFAULT ((0)),
[TransferOrderedAllocated] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItemWarehouses_TransferOrderedAllocated] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICItemWarehouses] ADD CONSTRAINT [PK_ICItemWarehouses] PRIMARY KEY CLUSTERED ([ItemID], [WarehouseID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICItemWarehouses] ADD CONSTRAINT [FK_ICItemWarehouses_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[ICItemWarehouses] ADD CONSTRAINT [FK_ICItemWarehouses_StockingCodeID_ICStockingCodes] FOREIGN KEY ([StockingCodeID]) REFERENCES [dbo].[ICStockingCodes] ([StockingCodeID])
GO
ALTER TABLE [dbo].[ICItemWarehouses] ADD CONSTRAINT [FK_ICItemWarehouses_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO