CREATE TABLE [dbo].[ICItems]
(
[ItemID] [int] NOT NULL,
[Item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BarCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Serialized] [bit] NOT NULL,
[WebEnabled] [bit] NOT NULL,
[UMID] [int] NOT NULL,
[CategoryID] [int] NOT NULL,
[InventoryCodeID] [int] NULL,
[Cost] [money] NOT NULL,
[ExpenseCodeID] [int] NULL,
[SalesCodeID] [int] NULL,
[BackOrder] [bit] NOT NULL,
[Tax] [bit] NOT NULL,
[RoundPrice] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PriceAdjustment] [money] NOT NULL,
[ServiceCodeID] [int] NULL,
[Yield] [int] NOT NULL,
[EquipmentCodeID] [int] NULL,
[StdOverhead] [money] NOT NULL,
[MfgLaborHours] [decimal] (16, 6) NOT NULL,
[MfgLaborRate] [money] NOT NULL,
[MfgType] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SourceCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Weight] [decimal] (16, 6) NOT NULL,
[WeightUMID] [int] NULL,
[OnHandQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_OnHandQty] DEFAULT ((0)),
[OnHandCost] [money] NOT NULL CONSTRAINT [DF_ICItems_OnHandCost] DEFAULT ((0)),
[AvgCost] [money] NOT NULL CONSTRAINT [DF_ICItems_AvgCost] DEFAULT ((0)),
[Ordered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_Ordered] DEFAULT ((0)),
[Allocated] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_Allocated] DEFAULT ((0)),
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_ICItems_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_ICItems_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICItems_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[ModelID] [int] NULL,
[TaxFlag] [int] NOT NULL CONSTRAINT [DF_ICItems_TaxFlag] DEFAULT ((1)),
[EnableDefaultPrice] [bit] NOT NULL CONSTRAINT [DF_ICItems_EnableDefaultPrice] DEFAULT ((0)),
[DefaultPrice] [money] NOT NULL CONSTRAINT [DF_ICItems_DefaultPrice] DEFAULT ((0)),
[LastCost] [money] NOT NULL CONSTRAINT [DF_ICItems_LastCost] DEFAULT ((0)),
[LastCostDate] [datetime] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICItems_Remarks] DEFAULT (''),
[StandardQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_StandardQty] DEFAULT ((0)),
[DefectiveQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_DefectiveQty] DEFAULT ((0)),
[UnavailableQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_UnavailableQty] DEFAULT ((0)),
[BaseChargeOutCost] [money] NOT NULL CONSTRAINT [DF_ICItems_BaseChargeOutCost] DEFAULT ((0)),
[CommissionClassID] [int] NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_ICItems_DBFileHeaderID] DEFAULT ((1)),
[EnableContractUsageLimits] [bit] NOT NULL CONSTRAINT [DF_ICItems_EnableContractUsageLimits] DEFAULT ((0)),
[UsageLimitMeterTypeID] [int] NULL,
[IsReturnable] [bit] NOT NULL CONSTRAINT [DF_ICItems_IsReturnable] DEFAULT ((0)),
[WarrantyEffectiveStartDate] [datetime] NULL,
[WarrantyEffectiveEndDate] [datetime] NULL,
[StockingCodeID] [int] NULL,
[BackOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_BackOrdered] DEFAULT ((0)),
[EffectiveOnHandQty] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_ICItems_EffectiveOnHandQty] DEFAULT ((0)),
[EffectiveOnHandCost] [money] NOT NULL CONSTRAINT [DF_ICItems_EffectiveOnHandCost] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ICItems_NoteFlag] DEFAULT ((0)),
[UseBaseOutCost] [bit] NOT NULL CONSTRAINT [DF_ICItems_UseBaseOutCost] DEFAULT ((0)),
[BaseOutCost] [money] NOT NULL CONSTRAINT [DF_ICItems_BaseOutCost] DEFAULT ((0)),
[OutCostGroupID] [int] NOT NULL CONSTRAINT [DF_ICItems_OutCostGroupID] DEFAULT ((1)),
[AutoSerialize] [bit] NOT NULL CONSTRAINT [DF_ICItems_AutoSerialize] DEFAULT ((0)),
[NextSerialNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICItems_NextSerialNumber] DEFAULT (''),
[ShTrackingConfigID] [int] NULL,
[PrefVendorID] [int] NULL,
[PrefMfgNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICItems_PrefMfgNumber] DEFAULT (''),
[cuTypeCode] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cuUsedBy] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsOEMCompatibleItem] [bit] NOT NULL CONSTRAINT [DF_ICItems_IsOEMCompatibleItem] DEFAULT ((0)),
[OEMNumber] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICItems_OEMNumber] DEFAULT (''),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ICItems_NoteCount] DEFAULT ((0)),
[ContractRate] [money] NOT NULL CONSTRAINT [DF_ICItems_ContractRate] DEFAULT ((0)),
[ContractRateCycleID] [int] NULL,
[ContractRateRoundNoDigits] [int] NOT NULL CONSTRAINT [DF_ICItems_ContractRateRoundNoDigits] DEFAULT ((0)),
[ContractRateFlag] [int] NOT NULL CONSTRAINT [DF_ICItems_ContractRateFlag] DEFAULT ((0)),
[CoreChargeItemID] [int] NULL,
[ServiceableAsItem] [bit] NOT NULL CONSTRAINT [DF_ICItems_ServiceableAsItem] DEFAULT ((0)),
[BaseDistributionCodeID] [int] NULL,
[TaxFlagID] [int] NOT NULL CONSTRAINT [DF_ICItems_TaxFlagID] DEFAULT ((2)),
[StockingSetSize] [int] NOT NULL CONSTRAINT [DF_ICItems_StockingSetSize] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [PK_ICItems] PRIMARY KEY CLUSTERED ([ItemID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_CategoryID_ICCategories] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[ICCategories] ([CategoryID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_ContractRateCycleID_SCBillingCycles] FOREIGN KEY ([ContractRateCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_CoreChargeItemID_ICItems] FOREIGN KEY ([CoreChargeItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_DBFileHeaderID_DBFileHeader] FOREIGN KEY ([DBFileHeaderID]) REFERENCES [dbo].[DBFileHeader] ([DBFileHeaderID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_EquipmentCodeID_ICEquipmentCodes] FOREIGN KEY ([EquipmentCodeID]) REFERENCES [dbo].[ICEquipmentCodes] ([EquipmentCodeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_ExpenseCodeID_ICExpenseCodes] FOREIGN KEY ([ExpenseCodeID]) REFERENCES [dbo].[ICExpenseCodes] ([ExpenseCodeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_InventoryCodeID_ICInventoryCodes] FOREIGN KEY ([InventoryCodeID]) REFERENCES [dbo].[ICInventoryCodes] ([InventoryCodeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_ModelID_ICModels] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_NoteID_ICItemNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ICItemNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_OutCostGroupID_ICOutCostGroups] FOREIGN KEY ([OutCostGroupID]) REFERENCES [dbo].[ICOutCostGroups] ([OutCostGroupID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_PrefVendorID_APVendors] FOREIGN KEY ([PrefVendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_SalesCodeID_ICSalesCodes] FOREIGN KEY ([SalesCodeID]) REFERENCES [dbo].[ICSalesCodes] ([SalesCodeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_ServiceCodeID_ICServiceCodes] FOREIGN KEY ([ServiceCodeID]) REFERENCES [dbo].[ICServiceCodes] ([ServiceCodeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_StockingCodeID_ICStockingCodes] FOREIGN KEY ([StockingCodeID]) REFERENCES [dbo].[ICStockingCodes] ([StockingCodeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_UsageLimitMeterTypeID_MTMeterTypes] FOREIGN KEY ([UsageLimitMeterTypeID]) REFERENCES [dbo].[MTMeterTypes] ([MeterTypeID])
GO
ALTER TABLE [dbo].[ICItems] ADD CONSTRAINT [FK_ICItems_WeightUMID_ICUnits] FOREIGN KEY ([WeightUMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO