Tables [dbo].[ICTransferDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:44 AM Thursday, March 21, 2019
Last Modified1:12:15 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_ICTransferDetails: TransferID\DetailIDForeign Keys FK_ICTransferDetails_TransferID_ICTransfers: [dbo].[ICTransfers].TransferIDTransferIDint4
False
Cluster Primary Key PK_ICTransferDetails: TransferID\DetailIDDetailIDint4
False
Foreign Keys FK_ICTransferDetails_RequestID_ICRequestDetails: [dbo].[ICRequestDetails].RequestID\RequestDetailIDRequestIDint4
True
Foreign Keys FK_ICTransferDetails_RequestID_ICRequestDetails: [dbo].[ICRequestDetails].RequestID\RequestDetailIDRequestDetailIDint4
True
Foreign Keys FK_ICTransferDetails_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
False
SerialNumbervarchar(30)30
False
UMvarchar(4)4
False
Quantitydecimal(18,6)9
False
Foreign Keys FK_ICTransferDetails_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
False
Foreign Keys FK_ICTransferDetails_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
False
Requesteddecimal(18,6)9
False
Canceleddecimal(18,6)9
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_ICTransferDetails_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
Foreign Keys FK_ICTransferDetails_SourceStockTypeID_ICStockTypes: [dbo].[ICStockTypes].SourceStockTypeIDSourceStockTypeIDint4
False
((1))
Foreign Keys FK_ICTransferDetails_TOID_ICTransferOrderDetails: [dbo].[ICTransferOrderDetails].TOID\TODetailIDTOIDint4
True
Foreign Keys FK_ICTransferDetails_TOID_ICTransferOrderDetails: [dbo].[ICTransferOrderDetails].TOID\TODetailIDTODetailIDint4
True
Ordereddecimal(18,6)9
False
((0))
Foreign Keys FK_ICTransferDetails_AssetID_GLAssets: [dbo].[GLAssets].AssetIDAssetIDint4
True
InventoryAmountmoney8
False
((0))
Foreign Keys FK_ICTransferDetails_InventoryGLID_GLAccounts: [dbo].[GLAccounts].InventoryGLIDInventoryGLIDint4
False
Foreign Keys FK_ICTransferDetails_InventoryDeptID_GLDepts: [dbo].[GLDepts].InventoryDeptIDInventoryDeptIDint4
True
AdjAmountmoney8
False
((0))
Foreign Keys FK_ICTransferDetails_AdjGLID_GLAccounts: [dbo].[GLAccounts].AdjGLIDAdjGLIDint4
False
Foreign Keys FK_ICTransferDetails_AdjDeptID_GLDepts: [dbo].[GLDepts].AdjDeptIDAdjDeptIDint4
True
AssetCostOrBasisAmountmoney8
False
((0))
AssetGLIDint4
True
AssetAccumDeprAmountmoney8
False
((0))
AccumDeprGLIDint4
True
Amountmoney8
False
((0))
Foreign Keys FK_ICTransferDetails_PODetailBinID_POOrderDetailBins: [dbo].[POOrderDetailBins].PODetailBinIDPODetailBinIDint4
True
Foreign Keys FK_ICTransferDetails_SOID_SOOrders: [dbo].[SOOrders].SOIDSOIDint4
True
Foreign Keys FK_ICTransferDetails_SODetailBinID_SOOrderDetailBins: [dbo].[SOOrderDetailBins].SODetailBinIDSODetailBinIDint4
True
Foreign Keys FK_ICTransferDetails_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
True
CallMaterialBinIDint4
True
LinkedTransactionNumbervarchar(64)64
False
('')
Foreign Keys FK_ICTransferDetails_LinkedTransactionNewBinID_ICBins: [dbo].[ICBins].LinkedTransactionNewBinIDLinkedTransactionNewBinIDint4
True
LinkedTransactionTransferredTobit1
False
((1))
Foreign Keys FK_ICTransferDetails_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_ICTransferDetails_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_ICTransferDetails_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_ICTransferDetails_IntercompanyGLID_GLAccounts: [dbo].[GLAccounts].IntercompanyGLIDIntercompanyGLIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICTransferDetails: TransferID\DetailIDPK_ICTransferDetailsTransferID, DetailID
True
80
NameColumns
FK_ICTransferDetails_AdjDeptID_GLDeptsAdjDeptID->[dbo].[GLDepts].[DeptID]
FK_ICTransferDetails_AdjGLID_GLAccountsAdjGLID->[dbo].[GLAccounts].[AccountID]
FK_ICTransferDetails_AssetID_GLAssetsAssetID->[dbo].[GLAssets].[AssetID]
FK_ICTransferDetails_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_ICTransferDetails_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_ICTransferDetails_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ICTransferDetails_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_ICTransferDetails_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_ICTransferDetails_IntercompanyGLID_GLAccountsIntercompanyGLID->[dbo].[GLAccounts].[AccountID]
FK_ICTransferDetails_InventoryDeptID_GLDeptsInventoryDeptID->[dbo].[GLDepts].[DeptID]
FK_ICTransferDetails_InventoryGLID_GLAccountsInventoryGLID->[dbo].[GLAccounts].[AccountID]
FK_ICTransferDetails_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_ICTransferDetails_LinkedTransactionNewBinID_ICBinsLinkedTransactionNewBinID->[dbo].[ICBins].[BinID]
FK_ICTransferDetails_PODetailBinID_POOrderDetailBinsPODetailBinID->[dbo].[POOrderDetailBins].[PODetailBinID]
FK_ICTransferDetails_RequestID_ICRequestDetailsRequestID->[dbo].[ICRequestDetails].[RequestID]
RequestDetailID->[dbo].[ICRequestDetails].[DetailID]
FK_ICTransferDetails_SODetailBinID_SOOrderDetailBinsSODetailBinID->[dbo].[SOOrderDetailBins].[SODetailBinID]
FK_ICTransferDetails_SOID_SOOrdersSOID->[dbo].[SOOrders].[SOID]
FK_ICTransferDetails_SourceStockTypeID_ICStockTypesSourceStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_ICTransferDetails_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_ICTransferDetails_TOID_ICTransferOrderDetailsTOID->[dbo].[ICTransferOrderDetails].[TOID]
TODetailID->[dbo].[ICTransferOrderDetails].[DetailID]
FK_ICTransferDetails_TransferID_ICTransfersTransferID->[dbo].[ICTransfers].[TransferID]
FK_ICTransferDetails_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
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