CREATE TABLE [dbo].[SCQReportMaterials]
(
[CallID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UMID] [int] NOT NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConvFactor] [decimal] (16, 6) NOT NULL,
[Price] [money] NOT NULL,
[Discount] [decimal] (18, 6) NOT NULL,
[Bill] [bit] NOT NULL,
[Stocked] [bit] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SCQReportMaterials_Amount] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_SCQReportMaterials_Cost] DEFAULT ((0)),
[VoidCost] [money] NOT NULL CONSTRAINT [DF_SCQReportMaterials_VoidCost] 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_SCQReportMaterials_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQReportMaterials_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[PriceSourceID] [int] NOT NULL CONSTRAINT [DF_SCQReportMaterials_PriceSourceID] DEFAULT ((1)),
[SystemComputedPrice] [money] NOT NULL CONSTRAINT [DF_SCQReportMaterials_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQReportMaterials_ReturnRemarks] DEFAULT (''),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SCQReportMaterials_StockTypeID] DEFAULT ((1)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SCQReportMaterials_OverriddenCost] DEFAULT ((0)),
[ChargeOutCost] [money] NOT NULL CONSTRAINT [DF_SCQReportMaterials_ChargeOutCost] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQReportMaterials_Canceled] DEFAULT ((0)),
[WarrantyStarted] [bit] NOT NULL CONSTRAINT [DF_SCQReportMaterials_WarrantyStarted] DEFAULT ((0)),
[IsWarrantied] [bit] NOT NULL CONSTRAINT [DF_SCQReportMaterials_IsWarrantied] DEFAULT ((0)),
[TransactionWarrantyID] [int] NULL,
[UsageStatusID] [int] NOT NULL CONSTRAINT [DF_SCQReportMaterials_UsageStatusID] DEFAULT ((1)),
[ReqDate] [datetime] NULL,
[DeliveryMethodID] [int] NULL,
[ContractItemLimitID] [int] NULL,
[BackOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQReportMaterials_BackOrdered] DEFAULT ((0)),
[MoveOrderDetail] [bit] NOT NULL CONSTRAINT [DF_SCQReportMaterials_MoveOrderDetail] DEFAULT ((0)),
[MoveOrderLinkedDetailID] [int] NULL,
[MoveOrderLocation] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnitCost] [money] NOT NULL CONSTRAINT [DF_SCQReportMaterials_UnitCost] DEFAULT ((0)),
[TaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [PK_SCQReportMaterials] PRIMARY KEY CLUSTERED ([CallID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_CallID_SCQReportMaterials] FOREIGN KEY ([CallID], [MoveOrderLinkedDetailID]) REFERENCES [dbo].[SCQReportMaterials] ([CallID], [DetailID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_CallID_SCQReports] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCQReports] ([CallID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_ContractItemLimitID_SCContractItemLimits] FOREIGN KEY ([ContractItemLimitID]) REFERENCES [dbo].[SCContractItemLimits] ([ContractItemLimitID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_DeliveryMethodID_ICDeliveryMethods] FOREIGN KEY ([DeliveryMethodID]) REFERENCES [dbo].[ICDeliveryMethods] ([DeliveryMethodID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_DeptID_GLDepts5] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO
ALTER TABLE [dbo].[SCQReportMaterials] ADD CONSTRAINT [FK_SCQReportMaterials_UsageStatusID_ICUsageStatuses] FOREIGN KEY ([UsageStatusID]) REFERENCES [dbo].[ICUsageStatuses] ([UsageStatusID])
GO