Tables [dbo].[SAConfigPrinters]
PropertyValue
Row Count (~)0
Created12:58:57 AM Thursday, March 21, 2019
Last Modified12:58:57 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SAConfigPrinters: ConfigPrinterID\ConfigQuoteID\SupplySourceID\SupplyVendorIDConfigPrinterIDint4
False
1 - 1
Cluster Primary Key PK_SAConfigPrinters: ConfigPrinterID\ConfigQuoteID\SupplySourceID\SupplyVendorIDConfigQuoteIDint4
False
Cluster Primary Key PK_SAConfigPrinters: ConfigPrinterID\ConfigQuoteID\SupplySourceID\SupplyVendorIDSupplySourceIDint4
False
Cluster Primary Key PK_SAConfigPrinters: ConfigPrinterID\ConfigQuoteID\SupplySourceID\SupplyVendorIDSupplyVendorIDint4
False
Termint4
True
Coveragedecimal(10,5)9
True
ClrCoveragedecimal(10,5)9
True
Margindecimal(10,5)9
True
BlkVolumeint4
True
BlkCPPdecimal(14,8)9
True
ClrVolumeint4
True
ClrCPPdecimal(14,8)9
True
BlkCostmoney8
True
ClrCostmoney8
True
TotalPaymentmoney8
True
TotalPricemoney8
True
TotalProfitmoney8
True
TotalVolumebigint8
True
TotalCostmoney8
True
TotalMarginProfitmoney8
True
TotalAvgCPPdecimal(14,8)9
True
Selectedbit1
True
ClrMargindecimal(18,0)9
True
ManualTotalsbit1
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_SAConfigPrinters: ConfigPrinterID\ConfigQuoteID\SupplySourceID\SupplyVendorIDPK_SAConfigPrintersConfigPrinterID, ConfigQuoteID, SupplySourceID, SupplyVendorID
True
CREATE TABLE [dbo].[SAConfigPrinters]
(
[ConfigPrinterID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NOT NULL,
[SupplySourceID] [int] NOT NULL,
[SupplyVendorID] [int] NOT NULL,
[Term] [int] NULL,
[Coverage] [decimal] (10, 5) NULL,
[ClrCoverage] [decimal] (10, 5) NULL,
[Margin] [decimal] (10, 5) NULL,
[BlkVolume] [int] NULL,
[BlkCPP] [decimal] (14, 8) NULL,
[ClrVolume] [int] NULL,
[ClrCPP] [decimal] (14, 8) NULL,
[BlkCost] [money] NULL,
[ClrCost] [money] NULL,
[TotalPayment] [money] NULL,
[TotalPrice] [money] NULL,
[TotalProfit] [money] NULL,
[TotalVolume] [bigint] NULL,
[TotalCost] [money] NULL,
[TotalMarginProfit] [money] NULL,
[TotalAvgCPP] [decimal] (14, 8) NULL,
[Selected] [bit] NULL,
[ClrMargin] [decimal] (18, 0) NULL,
[ManualTotals] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigPrinters] ADD CONSTRAINT [PK_SAConfigPrinters] PRIMARY KEY CLUSTERED  ([ConfigPrinterID], [ConfigQuoteID], [SupplySourceID], [SupplyVendorID]) ON [PRIMARY]
GO