Tables [dbo].[SCQContractDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:02 AM Thursday, March 21, 2019
Last Modified1:15:20 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SCQContractDetails: QContractDetailIDQContractDetailIDint4
False
1 - 1
Foreign Keys FK_SCQContractDetails_QContractID_SCQContracts: [dbo].[SCQContracts].QContractIDQContractIDint4
False
Foreign Keys FK_SCQContractDetails_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Itemvarchar(255)255
False
MakeIDint4
True
Makevarchar(255)255
False
Foreign Keys FK_SCQContractDetails_ModelID_ICModels: [dbo].[ICModels].ModelIDModelIDint4
True
Modelvarchar(255)255
False
Foreign Keys FK_SCQContractDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
EquipmentInstanceint4
False
EquipmentSourceMethodint4
False
((0))
EquipmentNumbervarchar(32)32
False
('')
SerialNumbervarchar(30)30
False
Quantitydecimal(18,6)9
False
UnitBaseRatemoney8
False
BaseRatemoney8
False
Foreign Keys FK_SCQContractDetails_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
True
LocationNumbervarchar(32)32
False
SyncLocationAddressbit1
False
((0))
Addressvarchar(64)64
False
('')
Cityvarchar(32)32
False
('')
Statevarchar(16)16
False
('')
Zipvarchar(16)16
False
('')
Countryvarchar(16)16
False
('')
Locationvarchar(255)255
False
Foreign Keys FK_SCQContractDetails_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
StartDatedatetime8
True
Foreign Keys FK_SCQContractDetails_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
True
ServiceHourCodeIDint4
True
Remarksvarchar(255)255
False
ConfigQuoteNamevarchar(50)50
True
SONumbervarchar(32)32
True
InvoiceNumbervarchar(32)32
True
Foreign Keys FK_SCQContractDetails_ConfigQuoteDetailID_SAConfigQuoteDetails: [dbo].[SAConfigQuoteDetails].ConfigQuoteDetailIDConfigQuoteDetailIDint4
True
Foreign Keys FK_SCQContractDetails_SODetailBinID_SOOrderDetailBins: [dbo].[SOOrderDetailBins].SODetailBinIDSODetailBinIDint4
True
Foreign Keys FK_SCQContractDetails_FulfillDetailBinID_SOFulfillDetailBins: [dbo].[SOFulfillDetailBins].FulfillDetailBinIDFulfillDetailBinIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
LastUpdatedatetime8
False
timestamptimestamp8
True
Foreign Keys FK_SCQContractDetails_BaseDistributionCodeID_SCContractBaseDistCodes: [dbo].[SCContractBaseDistCodes].BaseDistributionCodeIDBaseDistributionCodeIDint4
True
Foreign Keys FK_SCQContractDetails_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
True
Foreign Keys FK_SCQContractDetails_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
Foreign Keys FK_SCQContractDetails_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
True
IPAddressvarchar(50)50
True
MACAddressvarchar(32)32
True
BillStartDatedatetime8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQContractDetails: QContractDetailIDPK_SCQContractDetailsQContractDetailID
True
80
NameColumns
FK_SCQContractDetails_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCQContractDetails_BaseDistributionCodeID_SCContractBaseDistCodesBaseDistributionCodeID->[dbo].[SCContractBaseDistCodes].[BaseDistributionCodeID]
FK_SCQContractDetails_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_SCQContractDetails_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCQContractDetails_ConfigQuoteDetailID_SAConfigQuoteDetailsConfigQuoteDetailID->[dbo].[SAConfigQuoteDetails].[ConfigQuoteDetailID]
FK_SCQContractDetails_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQContractDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCQContractDetails_FulfillDetailBinID_SOFulfillDetailBinsFulfillDetailBinID->[dbo].[SOFulfillDetailBins].[FulFillDetailBinID]
FK_SCQContractDetails_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCQContractDetails_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCQContractDetails_ModelID_ICModelsModelID->[dbo].[ICModels].[ModelID]
FK_SCQContractDetails_QContractID_SCQContractsQContractID->[dbo].[SCQContracts].[QContractID]
FK_SCQContractDetails_SODetailBinID_SOOrderDetailBinsSODetailBinID->[dbo].[SOOrderDetailBins].[SODetailBinID]
FK_SCQContractDetails_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
CREATE TABLE [dbo].[SCQContractDetails]
(
[QContractDetailID] [int] NOT NULL IDENTITY(1, 1),
[QContractID] [int] NOT NULL,
[ItemID] [int] NULL,
[Item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MakeID] [int] NULL,
[Make] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ModelID] [int] NULL,
[Model] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EquipmentID] [int] NULL,
[EquipmentInstance] [int] NOT NULL,
[EquipmentSourceMethod] [int] NOT NULL CONSTRAINT [DF_SCQContractDetails_EquipmentSourceMethod] DEFAULT ((0)),
[EquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContractDetails_EquipmentNumber] DEFAULT (''),
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UnitBaseRate] [money] NOT NULL,
[BaseRate] [money] NOT NULL,
[LocationID] [int] NULL,
[LocationNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SyncLocationAddress] [bit] NOT NULL CONSTRAINT [DF_SCQContractDetails_SyncLocationAddress] DEFAULT ((0)),
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContractDetails_Address] DEFAULT (''),
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContractDetails_City] DEFAULT (''),
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContractDetails_State] DEFAULT (''),
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContractDetails_Zip] DEFAULT (''),
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContractDetails_Country] DEFAULT (''),
[Location] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TaxCodeID] [int] NULL,
[StartDate] [datetime] NULL,
[BillCodeID] [int] NULL,
[ServiceHourCodeID] [int] NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConfigQuoteName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConfigQuoteDetailID] [int] NULL,
[SODetailBinID] [int] NULL,
[FulfillDetailBinID] [int] NULL,
[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,
[LastUpdate] [datetime] NOT NULL,
[timestamp] [timestamp] NULL,
[BaseDistributionCodeID] [int] NULL,
[DivisionID] [int] NULL,
[BranchID] [int] NULL,
[BalanceSheetGroupID] [int] NULL,
[IPAddress] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MACAddress] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillStartDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [PK_SCQContractDetails] PRIMARY KEY CLUSTERED  ([QContractDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_ConfigQuoteDetailID_SAConfigQuoteDetails] FOREIGN KEY ([ConfigQuoteDetailID]) REFERENCES [dbo].[SAConfigQuoteDetails] ([ConfigQuoteDetailID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_FulfillDetailBinID_SOFulfillDetailBins] FOREIGN KEY ([FulfillDetailBinID]) REFERENCES [dbo].[SOFulfillDetailBins] ([FulFillDetailBinID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_ModelID_ICModels] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_QContractID_SCQContracts] FOREIGN KEY ([QContractID]) REFERENCES [dbo].[SCQContracts] ([QContractID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[SCQContractDetails] ADD CONSTRAINT [FK_SCQContractDetails_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO