Tables [dbo].[SADeviceItemOverrides]
PropertyValue
Row Count (~)0
Created12:59:00 AM Thursday, March 21, 2019
Last Modified12:59:00 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SADeviceItemOverrides: DeviceItemID\SupplyVendorID\DetailIDDeviceItemIDint4
False
Cluster Primary Key PK_SADeviceItemOverrides: DeviceItemID\SupplyVendorID\DetailIDSupplyVendorIDint4
False
Cluster Primary Key PK_SADeviceItemOverrides: DeviceItemID\SupplyVendorID\DetailIDDetailIDint4
False
1 - 1
LaborCPPdecimal(14,8)9
True
PartsCPPdecimal(14,8)9
True
BlackCPPdecimal(14,8)9
True
ColorCPPdecimal(14,8)9
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SADeviceItemOverrides: DeviceItemID\SupplyVendorID\DetailIDPK_SADeviceItemOverridesDeviceItemID, SupplyVendorID, DetailID
True
80
CREATE TABLE [dbo].[SADeviceItemOverrides]
(
[DeviceItemID] [int] NOT NULL,
[SupplyVendorID] [int] NOT NULL,
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[LaborCPP] [decimal] (14, 8) NULL,
[PartsCPP] [decimal] (14, 8) NULL,
[BlackCPP] [decimal] (14, 8) NULL,
[ColorCPP] [decimal] (14, 8) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SADeviceItemOverrides] ADD CONSTRAINT [PK_SADeviceItemOverrides] PRIMARY KEY CLUSTERED  ([DeviceItemID], [SupplyVendorID], [DetailID]) ON [PRIMARY]
GO