Tables [dbo].[ICWarehouses]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:58 AM Thursday, March 21, 2019
Last Modified1:16:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_ICWarehouses: WarehouseIDWarehouseIDint4
False
Warehousevarchar(15)15
False
Descriptionvarchar(50)50
False
Addressvarchar(64)64
False
Cityvarchar(32)32
False
Statevarchar(16)16
False
Zipvarchar(16)16
False
Countryvarchar(16)16
False
Activebit1
False
Locksint4
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_ICWarehouses_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_ICWarehouses_DefaultStandardBinID_ICBins: [dbo].[ICBins].DefaultStandardBinIDDefaultStandardBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultDefectiveBinID_ICBins: [dbo].[ICBins].DefaultDefectiveBinIDDefaultDefectiveBinIDint4
True
DefaultUnavailableBinIDint4
True
Foreign Keys FK_ICWarehouses_WarehouseTypeID_ICWarehouseTypes: [dbo].[ICWarehouseTypes].WarehouseTypeIDWarehouseTypeIDint4
False
((1))
Foreign Keys FK_ICWarehouses_ParentWarehouseID_ICWarehouses: [dbo].[ICWarehouses].ParentWarehouseIDParentWarehouseIDint4
True
UseParentForReceivingbit1
False
((0))
Foreign Keys FK_ICWarehouses_DropShipBinID_ICBins: [dbo].[ICBins].DropShipBinIDDropShipBinIDint4
True
Foreign Keys FK_ICWarehouses_SpecialOrderBinID_ICBins: [dbo].[ICBins].SpecialOrderBinIDSpecialOrderBinIDint4
True
DefaultFulFillmentBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultReceivingBinID_ICBins: [dbo].[ICBins].DefaultReceivingBinIDDefaultReceivingBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultIncreaseBinID_ICBins: [dbo].[ICBins].DefaultIncreaseBinIDDefaultIncreaseBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultDecreaseBinID_ICBins: [dbo].[ICBins].DefaultDecreaseBinIDDefaultDecreaseBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultTransferBinID_ICBins: [dbo].[ICBins].DefaultTransferBinIDDefaultTransferBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultPreAssemblyBinID_ICBins: [dbo].[ICBins].DefaultPreAssemblyBinIDDefaultPreAssemblyBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultPostAssemblyBinID_ICBins: [dbo].[ICBins].DefaultPostAssemblyBinIDDefaultPostAssemblyBinIDint4
True
SyncAddressbit1
False
((0))
SyncAddressSourceint4
False
((1))
Foreign Keys FK_ICWarehouses_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
True
Foreign Keys FK_ICWarehouses_AgentID_ShAgents: [dbo].[ShAgents].AgentIDAgentIDint4
True
Foreign Keys FK_ICWarehouses_DefaultSOShippedBinID_ICBins: [dbo].[ICBins].DefaultSOShippedBinIDDefaultSOShippedBinIDint4
True
ShowInAllBranchesbit1
False
((0))
Foreign Keys FK_ICWarehouses_CostPoolID_ICCostPools: [dbo].[ICCostPools].CostPoolIDCostPoolIDint4
False
Foreign Keys FK_ICWarehouses_DefectiveCostPoolID_ICCostPools: [dbo].[ICCostPools].DefectiveCostPoolIDDefectiveCostPoolIDint4
False
Foreign Keys FK_ICWarehouses_WarehouseCostingTypeID_ICWarehouseCostingTypes: [dbo].[ICWarehouseCostingTypes].WarehouseCostingTypeIDWarehouseCostingTypeIDint4
False
((1))
TrackCostsSeparatelybit1
False
((0))
ExcludeFromOnHandQtybit1
False
((0))
ExcludeFromAvgCostbit1
False
((0))
Foreign Keys FK_ICWarehouses_ShTrackingConfigID_ShTrackingConfigs: [dbo].[ShTrackingConfigs].ShTrackingConfigIDShTrackingConfigIDint4
True
NameExternalvarchar(128)128
True
('')
Foreign Keys FK_ICWarehouses_DefaultAssembledBinID_ICBins: [dbo].[ICBins].DefaultAssembledBinIDDefaultAssembledBinIDint4
True
Foreign Keys FK_ICWarehouses_DefaultSOShippedAssembledBinID_ICBins: [dbo].[ICBins].DefaultSOShippedAssembledBinIDDefaultSOShippedAssembledBinIDint4
True
Foreign Keys FK_ICWarehouses_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Emailvarchar(255)255
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICWarehouses: WarehouseIDPK_ICWarehousesWarehouseID
True
80
NameColumns
FK_ICWarehouses_AgentID_ShAgentsAgentID->[dbo].[ShAgents].[AgentID]
FK_ICWarehouses_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_ICWarehouses_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ICWarehouses_CostPoolID_ICCostPoolsCostPoolID->[dbo].[ICCostPools].[CostPoolID]
FK_ICWarehouses_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_ICWarehouses_DefaultAssembledBinID_ICBinsDefaultAssembledBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultDecreaseBinID_ICBinsDefaultDecreaseBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultDefectiveBinID_ICBinsDefaultDefectiveBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultIncreaseBinID_ICBinsDefaultIncreaseBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultPostAssemblyBinID_ICBinsDefaultPostAssemblyBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultPreAssemblyBinID_ICBinsDefaultPreAssemblyBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultReceivingBinID_ICBinsDefaultReceivingBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultSOShippedAssembledBinID_ICBinsDefaultSOShippedAssembledBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultSOShippedBinID_ICBinsDefaultSOShippedBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultStandardBinID_ICBinsDefaultStandardBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefaultTransferBinID_ICBinsDefaultTransferBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_DefectiveCostPoolID_ICCostPoolsDefectiveCostPoolID->[dbo].[ICCostPools].[CostPoolID]
FK_ICWarehouses_DropShipBinID_ICBinsDropShipBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_ParentWarehouseID_ICWarehousesParentWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_ICWarehouses_ShTrackingConfigID_ShTrackingConfigsShTrackingConfigID->[dbo].[ShTrackingConfigs].[ShTrackingConfigID]
FK_ICWarehouses_SpecialOrderBinID_ICBinsSpecialOrderBinID->[dbo].[ICBins].[BinID]
FK_ICWarehouses_WarehouseCostingTypeID_ICWarehouseCostingTypesWarehouseCostingTypeID->[dbo].[ICWarehouseCostingTypes].[WarehouseCostingTypeID]
FK_ICWarehouses_WarehouseTypeID_ICWarehouseTypesWarehouseTypeID->[dbo].[ICWarehouseTypes].[WarehouseTypeID]
CREATE TABLE [dbo].[ICWarehouses]
(
[WarehouseID] [int] NOT NULL,
[Warehouse] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_ICWarehouses_Locks] DEFAULT ((0)),
[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_ICWarehouses_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICWarehouses_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BranchID] [int] NOT NULL,
[DefaultStandardBinID] [int] NULL,
[DefaultDefectiveBinID] [int] NULL,
[DefaultUnavailableBinID] [int] NULL,
[WarehouseTypeID] [int] NOT NULL CONSTRAINT [DF_ICWarehouses_WarehouseTypeID] DEFAULT ((1)),
[ParentWarehouseID] [int] NULL,
[UseParentForReceiving] [bit] NOT NULL CONSTRAINT [DF_ICWarehouses_UseParentForReceiving] DEFAULT ((0)),
[DropShipBinID] [int] NULL,
[SpecialOrderBinID] [int] NULL,
[DefaultFulFillmentBinID] [int] NULL,
[DefaultReceivingBinID] [int] NULL,
[DefaultIncreaseBinID] [int] NULL,
[DefaultDecreaseBinID] [int] NULL,
[DefaultTransferBinID] [int] NULL,
[DefaultPreAssemblyBinID] [int] NULL,
[DefaultPostAssemblyBinID] [int] NULL,
[SyncAddress] [bit] NOT NULL CONSTRAINT [DF_ICWarehouses_SyncAddress] DEFAULT ((0)),
[SyncAddressSource] [int] NOT NULL CONSTRAINT [DF_ICWarehouses_SyncAddressSource] DEFAULT ((1)),
[CustomerID] [int] NULL,
[AgentID] [int] NULL,
[DefaultSOShippedBinID] [int] NULL,
[ShowInAllBranches] [bit] NOT NULL CONSTRAINT [DF_ICWarehouses_ShowInAllBranches] DEFAULT ((0)),
[CostPoolID] [int] NOT NULL,
[DefectiveCostPoolID] [int] NOT NULL,
[WarehouseCostingTypeID] [int] NOT NULL CONSTRAINT [DF_ICWarehouses_WarehouseCostingTypeID] DEFAULT ((1)),
[TrackCostsSeparately] [bit] NOT NULL CONSTRAINT [DF_ICWarehouses_TrackCostsSeparately] DEFAULT ((0)),
[ExcludeFromOnHandQty] [bit] NOT NULL CONSTRAINT [DF_ICWarehouses_ExcludeFromOnHandQty] DEFAULT ((0)),
[ExcludeFromAvgCost] [bit] NOT NULL CONSTRAINT [DF_ICWarehouses_ExcludeFromAvgCost] DEFAULT ((0)),
[ShTrackingConfigID] [int] NULL,
[NameExternal] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ICWarehouses_NameExternal] DEFAULT (''),
[DefaultAssembledBinID] [int] NULL,
[DefaultSOShippedAssembledBinID] [int] NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[Email] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICWarehouses_Email] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [PK_ICWarehouses] PRIMARY KEY CLUSTERED  ([WarehouseID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_AgentID_ShAgents] FOREIGN KEY ([AgentID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_CostPoolID_ICCostPools] FOREIGN KEY ([CostPoolID]) REFERENCES [dbo].[ICCostPools] ([CostPoolID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultAssembledBinID_ICBins] FOREIGN KEY ([DefaultAssembledBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultDecreaseBinID_ICBins] FOREIGN KEY ([DefaultDecreaseBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultDefectiveBinID_ICBins] FOREIGN KEY ([DefaultDefectiveBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultIncreaseBinID_ICBins] FOREIGN KEY ([DefaultIncreaseBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultPostAssemblyBinID_ICBins] FOREIGN KEY ([DefaultPostAssemblyBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultPreAssemblyBinID_ICBins] FOREIGN KEY ([DefaultPreAssemblyBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultReceivingBinID_ICBins] FOREIGN KEY ([DefaultReceivingBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultSOShippedAssembledBinID_ICBins] FOREIGN KEY ([DefaultSOShippedAssembledBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultSOShippedBinID_ICBins] FOREIGN KEY ([DefaultSOShippedBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultStandardBinID_ICBins] FOREIGN KEY ([DefaultStandardBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefaultTransferBinID_ICBins] FOREIGN KEY ([DefaultTransferBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DefectiveCostPoolID_ICCostPools] FOREIGN KEY ([DefectiveCostPoolID]) REFERENCES [dbo].[ICCostPools] ([CostPoolID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_DropShipBinID_ICBins] FOREIGN KEY ([DropShipBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_ParentWarehouseID_ICWarehouses] FOREIGN KEY ([ParentWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_SpecialOrderBinID_ICBins] FOREIGN KEY ([SpecialOrderBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_WarehouseCostingTypeID_ICWarehouseCostingTypes] FOREIGN KEY ([WarehouseCostingTypeID]) REFERENCES [dbo].[ICWarehouseCostingTypes] ([WarehouseCostingTypeID])
GO
ALTER TABLE [dbo].[ICWarehouses] ADD CONSTRAINT [FK_ICWarehouses_WarehouseTypeID_ICWarehouseTypes] FOREIGN KEY ([WarehouseTypeID]) REFERENCES [dbo].[ICWarehouseTypes] ([WarehouseTypeID])
GO