Tables [dbo].[SCQReports]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:12 AM Thursday, March 21, 2019
Last Modified1:15:26 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCQReports: CallIDForeign Keys FK_SCQReports_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
False
ReportNumbervarchar(15)15
False
Foreign Keys FK_SCQReports_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
BSABillForServicesbit1
False
BSALaborDiscountfloat8
True
BSAMaterialsDiscountfloat8
True
Foreign Keys FK_SCQReports_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
True
Datedatetime8
False
Foreign Keys FK_SCQReports_SalesRepID_ARSalesReps: [dbo].[ARSalesReps].SalesRepIDSalesRepIDint4
True
MeterDatedatetime8
True
MeterDisplayint4
True
MeterActualint4
True
MeterOverridebit1
False
CopyCreditsint4
False
IncompleteDescriptionvarchar(255)255
False
Foreign Keys FK_SCQReports_IncompleteCodeID_SCIncompleteCodes: [dbo].[SCIncompleteCodes].IncompleteCodeIDIncompleteCodeIDint4
True
OpenDatedatetime8
False
ResponseHoursfloat8
False
RepairHoursfloat8
False
DownHoursfloat8
False
CloseDatedatetime8
False
TravelBasemoney8
False
TravelHoursfloat8
False
((0))
TravelRatemoney8
False
Mileagefloat8
False
((0))
MileageRatemoney8
False
TravelAmountmoney8
False
((0))
UseBurdenRatebit1
False
TravelCostPerHourmoney8
False
TravelCostPerMilemoney8
False
TravelCostmoney8
False
((0))
MiscDescriptionvarchar(255)255
False
MiscEarnedAmountmoney8
False
MiscAmountmoney8
False
Foreign Keys FK_SCQReports_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
LaborAmountmoney8
False
((0))
MaterialAmountmoney8
False
((0))
TaxAmountmoney8
False
((0))
PreventativeMaintenancebit1
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
MeterReadingDatedatetime8
True
Foreign Keys FK_SCQReports_DelayCodeID_SCDelayCodes: [dbo].[SCDelayCodes].DelayCodeIDDelayCodeIDint4
True
MileageAmountmoney8
False
((0))
MileageCostmoney8
False
((0))
UseStandardAdjustmentbit1
False
((0))
BillableMileagedecimal(16,4)9
False
((0))
RecalcNeededbit1
False
((0))
MiscTaxFlagint4
False
((0))
TravelTaxFlagint4
False
NetResolutionHoursfloat8
False
((0))
Foreign Keys FK_SCQReports_MiscTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].MiscTaxFlagIDMiscTaxFlagIDint4
False
((1))
Foreign Keys FK_SCQReports_TravelTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].TravelTaxFlagIDTravelTaxFlagIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQReports: CallIDPK_SCQReportsCallID
True
80
NameColumns
FK_SCQReports_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_SCQReports_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_SCQReports_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCQReports_DelayCodeID_SCDelayCodesDelayCodeID->[dbo].[SCDelayCodes].[DelayCodeID]
FK_SCQReports_IncompleteCodeID_SCIncompleteCodesIncompleteCodeID->[dbo].[SCIncompleteCodes].[IncompleteCodeID]
FK_SCQReports_MiscTaxFlagID_ShTaxFlagsMiscTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCQReports_SalesRepID_ARSalesRepsSalesRepID->[dbo].[ARSalesReps].[SalesRepID]
FK_SCQReports_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCQReports_TravelTaxFlagID_ShTaxFlagsTravelTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
CREATE TABLE [dbo].[SCQReports]
(
[CallID] [int] NOT NULL,
[ReportNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContractID] [int] NULL,
[BSABillForServices] [bit] NOT NULL,
[BSALaborDiscount] [float] NULL,
[BSAMaterialsDiscount] [float] NULL,
[BillCodeID] [int] NULL,
[Date] [datetime] NOT NULL,
[SalesRepID] [int] NULL,
[MeterDate] [datetime] NULL,
[MeterDisplay] [int] NULL,
[MeterActual] [int] NULL,
[MeterOverride] [bit] NOT NULL,
[CopyCredits] [int] NOT NULL,
[IncompleteDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IncompleteCodeID] [int] NULL,
[OpenDate] [datetime] NOT NULL,
[ResponseHours] [float] NOT NULL,
[RepairHours] [float] NOT NULL,
[DownHours] [float] NOT NULL,
[CloseDate] [datetime] NOT NULL,
[TravelBase] [money] NOT NULL,
[TravelHours] [float] NOT NULL CONSTRAINT [DF_SCQReports_TravelHours] DEFAULT ((0)),
[TravelRate] [money] NOT NULL,
[Mileage] [float] NOT NULL CONSTRAINT [DF_SCQReports_Mileage] DEFAULT ((0)),
[MileageRate] [money] NOT NULL,
[TravelAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_TravelAmount] DEFAULT ((0)),
[UseBurdenRate] [bit] NOT NULL,
[TravelCostPerHour] [money] NOT NULL,
[TravelCostPerMile] [money] NOT NULL,
[TravelCost] [money] NOT NULL CONSTRAINT [DF_SCQReports_TravelCost] DEFAULT ((0)),
[MiscDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiscEarnedAmount] [money] NOT NULL,
[MiscAmount] [money] NOT NULL,
[TaxCodeID] [int] NULL,
[LaborAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_LaborAmount] DEFAULT ((0)),
[MaterialAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_MaterialAmount] DEFAULT ((0)),
[TaxAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_TaxAmount] DEFAULT ((0)),
[PreventativeMaintenance] [bit] NOT NULL CONSTRAINT [DF_SCQReports_PreventativeMaintenance] 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_SCQReports_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQReports_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[MeterReadingDate] [datetime] NULL,
[DelayCodeID] [int] NULL,
[MileageAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_MileageAmount] DEFAULT ((0)),
[MileageCost] [money] NOT NULL CONSTRAINT [DF_SCQReports_MileageCost] DEFAULT ((0)),
[UseStandardAdjustment] [bit] NOT NULL CONSTRAINT [DF_SCQReports_UseStandardAdjustment] DEFAULT ((0)),
[BillableMileage] [decimal] (16, 4) NOT NULL CONSTRAINT [DF_SCQReports_BillableMileage] DEFAULT ((0)),
[RecalcNeeded] [bit] NOT NULL CONSTRAINT [DF_SCQReports_RecalcNeeded] DEFAULT ((0)),
[MiscTaxFlag] [int] NOT NULL CONSTRAINT [DF_SCQReports_MiscTaxFlag] DEFAULT ((0)),
[TravelTaxFlag] [int] NOT NULL,
[NetResolutionHours] [float] NOT NULL CONSTRAINT [DF_SCQReports_NetResolutionHours] DEFAULT ((0)),
[MiscTaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCQReports_MiscTaxFlagID] DEFAULT ((1)),
[TravelTaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [PK_SCQReports] PRIMARY KEY CLUSTERED  ([CallID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_DelayCodeID_SCDelayCodes] FOREIGN KEY ([DelayCodeID]) REFERENCES [dbo].[SCDelayCodes] ([DelayCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_IncompleteCodeID_SCIncompleteCodes] FOREIGN KEY ([IncompleteCodeID]) REFERENCES [dbo].[SCIncompleteCodes] ([IncompleteCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_MiscTaxFlagID_ShTaxFlags] FOREIGN KEY ([MiscTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_TravelTaxFlagID_ShTaxFlags] FOREIGN KEY ([TravelTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO