Tables [dbo].[SCHReports]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:19 AM Thursday, March 21, 2019
Last Modified1:15:07 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCHReports: ReportIDReportIDint4
False
ReportNumbervarchar(255)255
True
Foreign Keys FK_SCHReports_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
True
CustomerNamevarchar(255)255
True
Foreign Keys FK_SCHReports_BillToID_ARCustomers: [dbo].[ARCustomers].BillToIDBillToIDint4
True
BillToNamevarchar(255)255
True
Foreign Keys FK_SCHReports_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
Contractvarchar(255)255
True
Foreign Keys FK_SCHReports_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
True
BillCodevarchar(255)255
True
Foreign Keys FK_SCHReports_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
True
CallNumbervarchar(255)255
True
CallDatedatetime8
True
CallDescriptionvarchar(255)255
True
CallNotesvarchar(1024)1024
False
('')
Foreign Keys FK_SCHReports_CallTypeID_SCCallTypes: [dbo].[SCCallTypes].CallTypeIDCallTypeIDint4
True
CallTypeDescriptionvarchar(255)255
True
CallCanceledbit1
True
((0))
Foreign Keys FK_SCHReports_CallCancelCodeID_SCCancelCodes: [dbo].[SCCancelCodes].CallCancelCodeIDCallCancelCodeIDint4
True
CallCancelDescriptionvarchar(255)255
True
CallReleaseDatedatetime8
True
Callbackint4
False
((0))
Foreign Keys FK_SCHReports_RescheduledCallID_SCCalls: [dbo].[SCCalls].RescheduledCallIDRescheduledCallIDint4
True
RescheduledCallNumbervarchar(255)255
True
Datedatetime8
True
PONumbervarchar(32)32
False
Foreign Keys FK_SCHReports_TermID_ShTerms: [dbo].[ShTerms].TermIDTermIDint4
True
Termvarchar(255)255
True
TermDiscountRatefloat8
True
TermDiscountDatedatetime8
True
DueDatedatetime8
True
Foreign Keys FK_SCHReports_SalesRepID_ShAgents: [dbo].[ShAgents].SalesRepIDSalesRepIDint4
True
SalesRepvarchar(255)255
True
MailToAttnvarchar(64)64
True
MailToNamevarchar(128)128
True
MailToAddressvarchar(64)64
True
MailToCityvarchar(32)32
True
MailToStatevarchar(16)16
True
MailToZipvarchar(16)16
True
MailToCountryvarchar(16)16
True
ShipToAttnvarchar(64)64
True
ShipToNamevarchar(128)128
True
ShipToAddressvarchar(64)64
True
ShipToCityvarchar(32)32
True
ShipToStatevarchar(16)16
True
ShipToZipvarchar(16)16
True
ShipToCountryvarchar(16)16
True
Foreign Keys FK_SCHReports_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
True
LocationNumbervarchar(32)32
True
LocationNamevarchar(128)128
True
LocationAddressvarchar(64)64
True
LocationCityvarchar(32)32
True
LocationStatevarchar(16)16
True
LocationZipvarchar(16)16
True
LocationCountryvarchar(16)16
True
LocationContactvarchar(50)50
True
LocationPhonevarchar(50)50
True
LocationFaxvarchar(50)50
True
LocationNotesvarchar(128)128
True
MeterDatedatetime8
True
MeterDisplayint4
True
MeterActualint4
True
MeterOverridebit1
True
CopyCreditsint4
True
IncompleteDescriptionvarchar(255)255
True
Foreign Keys FK_SCHReports_IncompleteCodeID_SCIncompleteCodes: [dbo].[SCIncompleteCodes].IncompleteCodeIDIncompleteCodeIDint4
True
OpenDatedatetime8
True
ResponseHoursfloat8
True
RepairHoursfloat8
True
DownHoursfloat8
True
CloseDatedatetime8
True
TravelBasemoney8
True
TravelHoursfloat8
True
((0))
TravelRatemoney8
True
Mileagefloat8
True
((0))
MileageRatemoney8
True
TravelAmountmoney8
True
((0))
UseBurdenRatebit1
True
TravelCostPerHourmoney8
True
TravelCostPerMilemoney8
True
TravelCostmoney8
True
((0))
MiscDescriptionvarchar(255)255
True
MiscEarnedAmountmoney8
True
MiscAmountmoney8
True
EarnedAmountmoney8
True
((0))
Remarksvarchar(255)255
True
Foreign Keys FK_SCHReports_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
TaxCodevarchar(255)255
True
Taxablebit1
True
((1))
LaborAmountmoney8
True
((0))
MaterialAmountmoney8
True
((0))
TaxAmountmoney8
True
((0))
PostInvoiceNumbervarchar(255)255
True
PreventativeMaintenancebit1
True
((0))
Foreign Keys FK_SCHReports_OnHoldCodeID_ShOnHoldCodes: [dbo].[ShOnHoldCodes].OnHoldCodeIDOnHoldCodeIDint4
True
OnHoldCodevarchar(255)255
True
OnHoldReleaseDatedatetime8
True
OnHoldReleaserIDvarchar(255)255
True
ResponseCalcOverrideDatedatetime8
True
Foreign Keys FK_SCHReports_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
Jobvarchar(255)255
True
Foreign Keys FK_SCHReports_DelayCodeID_SCDelayCodes: [dbo].[SCDelayCodes].DelayCodeIDDelayCodeIDint4
True
DelayCodevarchar(255)255
True
Foreign Keys FK_SCHReports_CallTerritoryID_SCTerritories: [dbo].[SCTerritories].CallTerritoryIDCallTerritoryIDint4
True
CallTerritoryvarchar(255)255
True
Foreign Keys FK_SCHReports_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
EquipmentNumbervarchar(255)255
True
EquipItemvarchar(255)255
True
Foreign Keys FK_SCHReports_EquipModelID_ICModels: [dbo].[ICModels].EquipModelIDEquipModelIDint4
True
EquipModelvarchar(255)255
True
EquipMakevarchar(255)255
True
EquipSerialNumbervarchar(255)255
True
EquipDescriptionvarchar(255)255
True
MileageAmountmoney8
True
MileageCostmoney8
True
LaborCostmoney8
True
((0))
MaterialCostmoney8
True
((0))
UseStandardAdjustmentbit1
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCHReports: ReportIDPK_SCHReportsReportID
True
80
NameColumns
FK_SCHReports_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_SCHReports_BillToID_ARCustomersBillToID->[dbo].[ARCustomers].[CustomerID]
FK_SCHReports_CallCancelCodeID_SCCancelCodesCallCancelCodeID->[dbo].[SCCancelCodes].[CancelCodeID]
FK_SCHReports_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_SCHReports_CallTerritoryID_SCTerritoriesCallTerritoryID->[dbo].[SCTerritories].[TerritoryID]
FK_SCHReports_CallTypeID_SCCallTypesCallTypeID->[dbo].[SCCallTypes].[CallTypeID]
FK_SCHReports_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCHReports_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_SCHReports_DelayCodeID_SCDelayCodesDelayCodeID->[dbo].[SCDelayCodes].[DelayCodeID]
FK_SCHReports_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCHReports_EquipModelID_ICModelsEquipModelID->[dbo].[ICModels].[ModelID]
FK_SCHReports_IncompleteCodeID_SCIncompleteCodesIncompleteCodeID->[dbo].[SCIncompleteCodes].[IncompleteCodeID]
FK_SCHReports_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_SCHReports_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCHReports_OnHoldCodeID_ShOnHoldCodesOnHoldCodeID->[dbo].[ShOnHoldCodes].[OnHoldCodeID]
FK_SCHReports_RescheduledCallID_SCCallsRescheduledCallID->[dbo].[SCCalls].[CallID]
FK_SCHReports_SalesRepID_ShAgentsSalesRepID->[dbo].[ShAgents].[AgentID]
FK_SCHReports_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCHReports_TermID_ShTermsTermID->[dbo].[ShTerms].[TermID]
CREATE TABLE [dbo].[SCHReports]
(
[ReportID] [int] NOT NULL,
[ReportNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToID] [int] NULL,
[BillToName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractID] [int] NULL,
[Contract] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillCodeID] [int] NULL,
[BillCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallID] [int] NULL,
[CallNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallDate] [datetime] NULL,
[CallDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallNotes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCHReports_CallNotes] DEFAULT (''),
[CallTypeID] [int] NULL,
[CallTypeDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallCanceled] [bit] NULL CONSTRAINT [DF_SCHReports_CallCanceled] DEFAULT ((0)),
[CallCancelCodeID] [int] NULL,
[CallCancelDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallReleaseDate] [datetime] NULL,
[Callback] [int] NOT NULL CONSTRAINT [DF_SCHReports_Callback] DEFAULT ((0)),
[RescheduledCallID] [int] NULL,
[RescheduledCallNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TermID] [int] NULL,
[Term] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermDiscountRate] [float] NULL,
[TermDiscountDate] [datetime] NULL,
[DueDate] [datetime] NULL,
[SalesRepID] [int] NULL,
[SalesRep] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationID] [int] NULL,
[LocationNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationContact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationPhone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationFax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationNotes] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterDate] [datetime] NULL,
[MeterDisplay] [int] NULL,
[MeterActual] [int] NULL,
[MeterOverride] [bit] NULL,
[CopyCredits] [int] NULL,
[IncompleteDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IncompleteCodeID] [int] NULL,
[OpenDate] [datetime] NULL,
[ResponseHours] [float] NULL,
[RepairHours] [float] NULL,
[DownHours] [float] NULL,
[CloseDate] [datetime] NULL,
[TravelBase] [money] NULL,
[TravelHours] [float] NULL CONSTRAINT [DF_SCHReports_TravelHours] DEFAULT ((0)),
[TravelRate] [money] NULL,
[Mileage] [float] NULL CONSTRAINT [DF_SCHReports_Mileage] DEFAULT ((0)),
[MileageRate] [money] NULL,
[TravelAmount] [money] NULL CONSTRAINT [DF_SCHReports_TravelAmount] DEFAULT ((0)),
[UseBurdenRate] [bit] NULL,
[TravelCostPerHour] [money] NULL,
[TravelCostPerMile] [money] NULL,
[TravelCost] [money] NULL CONSTRAINT [DF_SCHReports_TravelCost] DEFAULT ((0)),
[MiscDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiscEarnedAmount] [money] NULL,
[MiscAmount] [money] NULL,
[EarnedAmount] [money] NULL CONSTRAINT [DF_SCHReports_EarnedAmount] DEFAULT ((0)),
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaxCodeID] [int] NULL,
[TaxCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Taxable] [bit] NULL CONSTRAINT [DF_SCHReports_Taxable] DEFAULT ((1)),
[LaborAmount] [money] NULL CONSTRAINT [DF_SCHReports_LaborAmount] DEFAULT ((0)),
[MaterialAmount] [money] NULL CONSTRAINT [DF_SCHReports_MaterialAmount] DEFAULT ((0)),
[TaxAmount] [money] NULL CONSTRAINT [DF_SCHReports_TaxAmount] DEFAULT ((0)),
[PostInvoiceNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PreventativeMaintenance] [bit] NULL CONSTRAINT [DF_SCHReports_PreventativeMaintenance] DEFAULT ((0)),
[OnHoldCodeID] [int] NULL,
[OnHoldCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldReleaseDate] [datetime] NULL,
[OnHoldReleaserID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponseCalcOverrideDate] [datetime] NULL,
[JobID] [int] NULL,
[Job] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DelayCodeID] [int] NULL,
[DelayCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallTerritoryID] [int] NULL,
[CallTerritory] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentID] [int] NULL,
[EquipmentNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipItem] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipModelID] [int] NULL,
[EquipModel] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipMake] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipSerialNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MileageAmount] [money] NULL,
[MileageCost] [money] NULL,
[LaborCost] [money] NULL CONSTRAINT [DF_SCHReports_LaborCost] DEFAULT ((0)),
[MaterialCost] [money] NULL CONSTRAINT [DF_SCHReports_MaterialCost] DEFAULT ((0)),
[UseStandardAdjustment] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [PK_SCHReports] PRIMARY KEY CLUSTERED  ([ReportID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallCancelCodeID_SCCancelCodes] FOREIGN KEY ([CallCancelCodeID]) REFERENCES [dbo].[SCCancelCodes] ([CancelCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallTerritoryID_SCTerritories] FOREIGN KEY ([CallTerritoryID]) REFERENCES [dbo].[SCTerritories] ([TerritoryID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallTypeID_SCCallTypes] FOREIGN KEY ([CallTypeID]) REFERENCES [dbo].[SCCallTypes] ([CallTypeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_DelayCodeID_SCDelayCodes] FOREIGN KEY ([DelayCodeID]) REFERENCES [dbo].[SCDelayCodes] ([DelayCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_EquipModelID_ICModels] FOREIGN KEY ([EquipModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_IncompleteCodeID_SCIncompleteCodes] FOREIGN KEY ([IncompleteCodeID]) REFERENCES [dbo].[SCIncompleteCodes] ([IncompleteCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_RescheduledCallID_SCCalls] FOREIGN KEY ([RescheduledCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_SalesRepID_ShAgents] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO