CREATE TABLE [dbo].[ICTransferDetails]
(
[TransferID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[RequestID] [int] NULL,
[RequestDetailID] [int] NULL,
[ItemID] [int] NOT NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UM] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NOT NULL,
[Requested] [decimal] (18, 6) NOT NULL,
[Canceled] [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_ICTransferDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICTransferDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_ICTransferDetails_StockTypeID] DEFAULT ((1)),
[SourceStockTypeID] [int] NOT NULL CONSTRAINT [DF_ICTransferDetails_SourceStockTypeID] DEFAULT ((1)),
[TOID] [int] NULL,
[TODetailID] [int] NULL,
[Ordered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICTransferDetails_Ordered] DEFAULT ((0)),
[AssetID] [int] NULL,
[InventoryAmount] [money] NOT NULL CONSTRAINT [DF_ICTransferDetails_InventoryAmount] DEFAULT ((0)),
[InventoryGLID] [int] NOT NULL,
[InventoryDeptID] [int] NULL,
[AdjAmount] [money] NOT NULL CONSTRAINT [DF_ICTransferDetails_AdjAmount] DEFAULT ((0)),
[AdjGLID] [int] NOT NULL,
[AdjDeptID] [int] NULL,
[AssetCostOrBasisAmount] [money] NOT NULL CONSTRAINT [DF_ICTransferDetails_AssetCostOrBasisAmount] DEFAULT ((0)),
[AssetGLID] [int] NULL,
[AssetAccumDeprAmount] [money] NOT NULL CONSTRAINT [DF_ICTransferDetails_AssetAccumDeprAmount] DEFAULT ((0)),
[AccumDeprGLID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_ICTransferDetails_Amount] DEFAULT ((0)),
[PODetailBinID] [int] NULL,
[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_ICTransferDetails_LinkedTransactionNumber] DEFAULT (''),
[LinkedTransactionNewBinID] [int] NULL,
[LinkedTransactionTransferredTo] [bit] NOT NULL CONSTRAINT [DF_ICTransferDetails_LinkedTransactionTransferredTo] DEFAULT ((1)),
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[IntercompanyGLID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [PK_ICTransferDetails] PRIMARY KEY CLUSTERED ([TransferID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_AdjDeptID_GLDepts] FOREIGN KEY ([AdjDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_AdjGLID_GLAccounts] FOREIGN KEY ([AdjGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_AssetID_GLAssets] FOREIGN KEY ([AssetID]) REFERENCES [dbo].[GLAssets] ([AssetID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_IntercompanyGLID_GLAccounts] FOREIGN KEY ([IntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_InventoryDeptID_GLDepts] FOREIGN KEY ([InventoryDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_InventoryGLID_GLAccounts] FOREIGN KEY ([InventoryGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_LinkedTransactionNewBinID_ICBins] FOREIGN KEY ([LinkedTransactionNewBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_PODetailBinID_POOrderDetailBins] FOREIGN KEY ([PODetailBinID]) REFERENCES [dbo].[POOrderDetailBins] ([PODetailBinID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_RequestID_ICRequestDetails] FOREIGN KEY ([RequestID], [RequestDetailID]) REFERENCES [dbo].[ICRequestDetails] ([RequestID], [DetailID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_SourceStockTypeID_ICStockTypes] FOREIGN KEY ([SourceStockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_TOID_ICTransferOrderDetails] FOREIGN KEY ([TOID], [TODetailID]) REFERENCES [dbo].[ICTransferOrderDetails] ([TOID], [DetailID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_TransferID_ICTransfers] FOREIGN KEY ([TransferID]) REFERENCES [dbo].[ICTransfers] ([TransferID])
GO
ALTER TABLE [dbo].[ICTransferDetails] ADD CONSTRAINT [FK_ICTransferDetails_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO