CREATE TABLE [dbo].[POOrderDetailBins]
(
[PODetailBinID] [int] NOT NULL IDENTITY(1, 1),
[POID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[ConvFactor] [decimal] (18, 6) NOT NULL,
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_Canceled] DEFAULT ((0)),
[Received] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_Received] DEFAULT ((0)),
[Requested] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_Requested] DEFAULT ((0)),
[SOID] [int] NULL,
[SODetailBinID] [int] NULL,
[CallID] [int] NULL,
[CallMaterialBinID] [int] NULL,
[LinkedTransactionNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrderDetailBins_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_POOrderDetailBins_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POOrderDetailBins_LastUpdate] DEFAULT (getdate()),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_POOrderDetailBins_StockTypeID] DEFAULT ((1)),
[RequestID] [int] NULL,
[RequestDetailID] [int] NULL,
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_POOrderDetailBins_IsReturn] DEFAULT ((0)),
[IsRTVReturn] [bit] NOT NULL CONSTRAINT [DF_POOrderDetailBins_IsRTVReturn] DEFAULT ((0)),
[ShippedBinID] [int] NULL,
[SerialNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrderDetailBins_SerialNumber] DEFAULT (''),
[Arrived] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_Arrived] DEFAULT ((0)),
[Transferred] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_Transferred] DEFAULT ((0)),
[Disposed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_Disposed] DEFAULT ((0)),
[Shipped] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_Shipped] DEFAULT ((0)),
[TransferredAndShipped] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetailBins_TransferredAndShipped] DEFAULT ((0)),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrderDetailBins_Notes] DEFAULT (''),
[OrigReceiptDetailBinID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [PK__POOrderD__04764AB2E61261EA] PRIMARY KEY CLUSTERED ([PODetailBinID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_POID_POOrderDetails] FOREIGN KEY ([POID], [DetailID]) REFERENCES [dbo].[POOrderDetails] ([POID], [DetailID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_RequestID_ICRequestDetails] FOREIGN KEY ([RequestID], [RequestDetailID]) REFERENCES [dbo].[ICRequestDetails] ([RequestID], [DetailID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_ShippedBinID_ICBins] FOREIGN KEY ([ShippedBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[POOrderDetailBins] ADD CONSTRAINT [FK_POOrderDetailBins_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO