Tables [dbo].[SOQuoteDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:50 AM Thursday, March 21, 2019
Last Modified1:16:14 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SOQuoteDetails: QuoteID\DetailIDForeign Keys FK_SOQuoteDetails_QuoteID_SOQuotes: [dbo].[SOQuotes].QuoteIDQuoteIDint4
False
Cluster Primary Key PK_SOQuoteDetails: QuoteID\DetailIDDetailIDint4
False
Foreign Keys FK_SOQuoteDetails_ItemID_ICItems1: [dbo].[ICItems1].ItemIDItemIDint4
False
Foreign Keys FK_SOQuoteDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
Foreign Keys FK_SOQuoteDetails_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
Descriptionvarchar(255)255
False
Quantitydecimal(18,6)9
False
Foreign Keys FK_SOQuoteDetails_UMID_ICUnits: [dbo].[ICUnits].UMIDUMIDint4
False
UMvarchar(255)255
False
ConvFactordecimal(16,6)9
False
Pricemoney8
False
Discountdecimal(18,6)9
False
Billbit1
False
((1))
Stockedbit1
False
Foreign Keys FK_SOQuoteDetails_DeptID_GLDepts3: [dbo].[GLDepts3].DeptIDDeptIDint4
True
Amountmoney8
False
((0))
TaxFlagint4
False
Costmoney8
False
BackOrdereddecimal(18,6)9
False
Picketeddecimal(18,6)9
False
((0))
Shippeddecimal(18,6)9
False
((0))
Canceleddecimal(18,6)9
False
((0))
UnShippedmoney8
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Foreign Keys FK_SOQuoteDetails_PriceSourceID_ARPriceSources: [dbo].[ARPriceSources].PriceSourceIDPriceSourceIDint4
False
((1))
SystemComputedPricemoney8
False
((0))
Foreign Keys FK_SOQuoteDetails_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnRemarksvarchar(255)255
False
('')
Foreign Keys FK_SOQuoteDetails_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
OverriddenCostbit1
False
((0))
ChargeOutCostmoney8
False
((0))
Foreign Keys FK_SOQuoteDetails_ShipToContactID_CMContacts: [dbo].[CMContacts].ShipToContactIDShipToContactIDint4
True
LineNumbervarchar(100)100
True
DisplayPricemoney8
False
((0))
Foreign Keys FK_SOQuoteDetails_TaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].TaxFlagIDTaxFlagIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SOQuoteDetails: QuoteID\DetailIDPK_SOQuoteDetailsQuoteID, DetailID
True
80
NameNo CheckColumns
FK_SOQuoteDetails_ContractID_SCContracts
True
ContractID->[dbo].[SCContracts].[ContractID]
FK_SOQuoteDetails_DeptID_GLDepts3DeptID->[dbo].[GLDepts3].[DeptID]
FK_SOQuoteDetails_EquipmentID_SCEquipments
True
EquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SOQuoteDetails_ItemID_ICItems1ItemID->[dbo].[ICItems1].[ItemID]
FK_SOQuoteDetails_PriceSourceID_ARPriceSourcesPriceSourceID->[dbo].[ARPriceSources].[PriceSourceID]
FK_SOQuoteDetails_QuoteID_SOQuotesQuoteID->[dbo].[SOQuotes].[QuoteID]
FK_SOQuoteDetails_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SOQuoteDetails_ShipToContactID_CMContactsShipToContactID->[dbo].[CMContacts].[ContactID]
FK_SOQuoteDetails_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_SOQuoteDetails_TaxFlagID_ShTaxFlagsTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SOQuoteDetails_UMID_ICUnitsUMID->[dbo].[ICUnits].[ID]
CREATE TABLE [dbo].[SOQuoteDetails]
(
[QuoteID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] 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 CONSTRAINT [DF_SOQuoteDetails_Bill] DEFAULT ((1)),
[Stocked] [bit] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SOQuoteDetails_Amount] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL,
[Cost] [money] NOT NULL,
[BackOrdered] [decimal] (18, 6) NOT NULL,
[Picketed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOQuoteDetails_Picketed] DEFAULT ((0)),
[Shipped] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOQuoteDetails_Shipped] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOQuoteDetails_Canceled] DEFAULT ((0)),
[UnShipped] [money] NOT NULL CONSTRAINT [DF_SOQuoteDetails_UnShipped] 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_SOQuoteDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOQuoteDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[PriceSourceID] [int] NOT NULL CONSTRAINT [DF_SOQuoteDetails_PriceSourceID] DEFAULT ((1)),
[SystemComputedPrice] [money] NOT NULL CONSTRAINT [DF_SOQuoteDetails_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOQuoteDetails_ReturnRemarks] DEFAULT (''),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SOQuoteDetails_StockTypeID] DEFAULT ((1)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SOQuoteDetails_OverriddenCost] DEFAULT ((0)),
[ChargeOutCost] [money] NOT NULL CONSTRAINT [DF_SOQuoteDetails_ChargeOutCost] DEFAULT ((0)),
[ShipToContactID] [int] NULL,
[LineNumber] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DisplayPrice] [money] NOT NULL CONSTRAINT [DF_SOQuoteDetails_DisplayPrice] DEFAULT ((0)),
[TaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [PK_SOQuoteDetails] PRIMARY KEY CLUSTERED  ([QuoteID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOQuoteDetails] WITH NOCHECK ADD CONSTRAINT [FK_SOQuoteDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_DeptID_GLDepts3] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] WITH NOCHECK ADD CONSTRAINT [FK_SOQuoteDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_QuoteID_SOQuotes] FOREIGN KEY ([QuoteID]) REFERENCES [dbo].[SOQuotes] ([QuoteID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_ShipToContactID_CMContacts] FOREIGN KEY ([ShipToContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] ADD CONSTRAINT [FK_SOQuoteDetails_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO
ALTER TABLE [dbo].[SOQuoteDetails] NOCHECK CONSTRAINT [FK_SOQuoteDetails_ContractID_SCContracts]
GO
ALTER TABLE [dbo].[SOQuoteDetails] NOCHECK CONSTRAINT [FK_SOQuoteDetails_EquipmentID_SCEquipments]
GO