CREATE TABLE [dbo].[SCHReportMaterials]
(
[ReportID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NULL,
[Item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quantity] [decimal] (18, 6) NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConvFactor] [decimal] (16, 6) NULL CONSTRAINT [DF_SCHReportMaterials_ConvFactor] DEFAULT ((1)),
[Price] [money] NULL,
[Discount] [decimal] (18, 6) NULL CONSTRAINT [DF_SCHReportMaterials_Discount] DEFAULT ((0)),
[Bill] [bit] NULL,
[Stocked] [bit] NULL,
[Amount] [money] NULL CONSTRAINT [DF_SCHReportMaterials_Amount] DEFAULT ((0)),
[TaxFlag] [int] NULL,
[Cost] [money] NULL CONSTRAINT [DF_SCHReportMaterials_Cost] DEFAULT ((0)),
[PriceSourceID] [int] NULL CONSTRAINT [DF_SCHReportMaterials_PriceSourceID] DEFAULT ((1)),
[PriceSource] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SystemComputedPrice] [money] NULL CONSTRAINT [DF_SCHReportMaterials_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReturnCodeDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OverriddenCost] [bit] NULL CONSTRAINT [DF_SCHReportMaterials_OverriddenCost] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReportMaterials] ADD CONSTRAINT [PK_SCHReportMaterials] PRIMARY KEY CLUSTERED ([ReportID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReportMaterials] ADD CONSTRAINT [FK_SCHReportMaterials_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCHReportMaterials] ADD CONSTRAINT [FK_SCHReportMaterials_ReportID_SCHReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[SCHReports] ([ReportID])
GO