Tables [dbo].[ICCostPoolItems]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:27 AM Thursday, March 21, 2019
Last Modified1:11:18 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Foreign Keys FK_ICCostPoolItems_CostPoolID_ICCostPools: [dbo].[ICCostPools].CostPoolIDCostPoolIDint4
False
Foreign Keys FK_ICCostPoolItems_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
False
OnHandQtydecimal(18,6)9
False
((0))
AvgCostmoney8
False
((0))
OnHandCostmoney8
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
NameColumns
FK_ICCostPoolItems_CostPoolID_ICCostPoolsCostPoolID->[dbo].[ICCostPools].[CostPoolID]
FK_ICCostPoolItems_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
CREATE TABLE [dbo].[ICCostPoolItems]
(
[CostPoolID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[OnHandQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICCostPoolItems_OnHandQty] DEFAULT ((0)),
[AvgCost] [money] NOT NULL CONSTRAINT [DF_ICCostPoolItems_AvgCost] DEFAULT ((0)),
[OnHandCost] [money] NOT NULL CONSTRAINT [DF_ICCostPoolItems_OnHandCost] 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_ICCostPoolItems_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICCostPoolItems_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICCostPoolItems] ADD CONSTRAINT [FK_ICCostPoolItems_CostPoolID_ICCostPools] FOREIGN KEY ([CostPoolID]) REFERENCES [dbo].[ICCostPools] ([CostPoolID])
GO
ALTER TABLE [dbo].[ICCostPoolItems] ADD CONSTRAINT [FK_ICCostPoolItems_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO