CREATE TABLE [dbo].[POReceiptDetailBins]
(
[ReceiptID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT 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_POReceiptDetailBins_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POReceiptDetailBins_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[PODetailBinID] [int] NULL,
[ConvFactor] [decimal] (18, 6) NOT NULL,
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POReceiptDetailBins_Canceled] DEFAULT ((0)),
[SOID] [int] NULL,
[SODetailBinID] [int] NULL,
[CallID] [int] NULL,
[CallMaterialBinID] [int] NULL,
[LinkedTransactionNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POReceiptDetailBins_LinkedTransactionNumber] DEFAULT (''),
[ReceiptDetailBinID] [int] NOT NULL IDENTITY(1, 1),
[RequestID] [int] NULL,
[RequestDetailID] [int] NULL,
[AppliedReceiptDetailBinID] [int] NULL,
[QuantityReversed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POReceiptDetailBins_QuantityReversed] DEFAULT ((0)),
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_POReceiptDetailBins_IsReturn] DEFAULT ((0)),
[IsRTVReturn] [bit] NOT NULL CONSTRAINT [DF_POReceiptDetailBins_IsRTVReturn] DEFAULT ((0)),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POReceiptDetailBins_Notes] DEFAULT (''),
[OrigReceiptDetailBinID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [PK_POReceiptDetailBins] PRIMARY KEY CLUSTERED ([ReceiptDetailBinID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_PODetailBinID_POOrderDetailBins] FOREIGN KEY ([PODetailBinID]) REFERENCES [dbo].[POOrderDetailBins] ([PODetailBinID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_ReceiptID_POReceiptDetails] FOREIGN KEY ([ReceiptID], [DetailID]) REFERENCES [dbo].[POReceiptDetails] ([ReceiptID], [DetailID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_RequestID_ICRequestDetails] FOREIGN KEY ([RequestID], [RequestDetailID]) REFERENCES [dbo].[ICRequestDetails] ([RequestID], [DetailID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO