CREATE TABLE [dbo].[POQOrderDetailBins]
(
[POQDetailBinID] [int] NOT NULL IDENTITY(1, 1),
[POQID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NULL,
[StockTypeID] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[ConvFactor] [decimal] (18, 6) NOT NULL,
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POQOrderDetailBins_Canceled] DEFAULT ((0)),
[Received] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POQOrderDetailBins_Received] DEFAULT ((0)),
[Requested] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POQOrderDetailBins_Requested] DEFAULT ((0)),
[SOID] [int] NULL,
[SODetailBinID] [int] NULL,
[CallID] [int] NULL,
[CallMaterialBinID] [int] NULL,
[RequestID] [int] NULL,
[RequestDetailID] [int] NULL,
[QOrderID] [int] NULL,
[LinkedTransactionNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POQOrderDetailBins_LinkedTransactionNumber] DEFAULT (''),
[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_POQOrderDetailBins_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POQOrderDetailBins_LastUpdate] DEFAULT (getdate()),
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_POQOrderDetailBins_IsReturn] DEFAULT ((0)),
[IsRTVReturn] [bit] NOT NULL CONSTRAINT [DF_POQOrderDetailBins_IsRTVReturn] DEFAULT ((0)),
[ShippedBinID] [int] NULL,
[SerialNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POQOrderDetailBins_SerialNumber] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [PK__POQOrder__0AF37E6A490D614F] PRIMARY KEY CLUSTERED ([POQDetailBinID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_POQID_POQOrderDetails] FOREIGN KEY ([POQID], [DetailID]) REFERENCES [dbo].[POQOrderDetails] ([POQID], [DetailID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_RequestID_ICRequestDetails] FOREIGN KEY ([RequestID], [RequestDetailID]) REFERENCES [dbo].[ICRequestDetails] ([RequestID], [DetailID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[POQOrderDetailBins] ADD CONSTRAINT [FK_POQOrderDetailBins_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO