This query inserts 6 parts that are not present in the OOB v2.85 and OOB v2.86 dataset.

• Liquid Laminator
• Thermal Laminator
• ZeroNine NexGen-Spot Film (Cartridge)
• ZeroNine NexGen-Process Film (Refill)
• ZeroNine NexGen-Spec Spot Film (Refill)
• ZeroNine Legacy-Mirror Film

High. Data is modified in this query. Do not run this except under the direction of a Cyrious Technical Support staff member. Doing otherwise may result in lost or contaminated data. All data modifications done through direct SQL are permanent and non-reversable.

INSERT [dbo].[Part] ([ID], [StoreID], [ClassTypeID], [ModifiedByUser], [ModifiedByComputer], [ModifiedDate], [SeqID], [IsSystem], [IsActive], [CategoryID], [CategoryStoreID], [CategoryClassTypeID], [ItemName], [Description], [HelpText], [InternalNotes], [BarCode], [SKU], [AssetAccountID], [ExpenseAccountID], [InventoryUnitType], [PartType], [TrackInventory], [QuantityOnHand], [QuantityReserved], [QuantityAvailable], [QuantityOnOrder], [QuantityExpected], [ReOrderPoint], [ReOrderQuantity], [YellowNotificationPoint], [RedNotificationPoint], [NotificationAddresses], [NotifyOtherContacts], [UnitID], [RoundingOption], [ScrapFactor], [UnitCost], [TrackCosts], [UnitCostFormula], [UseFixedCost], [CostMultiplier], [CostMultiplierType], [FixedCostMultiplier], [ShowOnProductionSchedule], [InstancesAllowedType], [InstancesAllowed], [Vendor], [VendorPartNumber], [RoundingFactor], [StationID], [StationClassTypeID], [GLDepartmentID], [GLDepartmentClassTypeID], [InventoryID], [AccrueCosts], [ExpenseAccountClassTypeID], [AssetAccountClassTypeID], [UseCategoryDefaults], [ComputedCostAccountID], [ComputedCostAccountClassTypeID], [LastModifiedDate], [UDFLayoutSettings], [LocalTags], [UDFXML], [UseInvUnitsForDisplay], [DisplayUnitID], [DisplayUnitType], [DisplayUnitText], [DisplayConversionFormula], [GLDepartmentIDOV], [ExpenseAccountIDOV], [AssetAccountIDOV], [TransferUnitID], [TransferUnitQuantity], [TransferUnitText], [ResellProductID], [ResellProductIDOV], [ResellProductVariableID]) VALUES (1019, 1001, 12014, N'SSLIPUser', N'CYRIMP', CAST(N'2014-07-23 13:33:00' AS SmallDateTime), 13, 0, 0, 10134, 0, 12035, N'Thermal Laminator', N'Thermal Laminator', NULL, NULL, NULL, NULL, 60, 6062, 1, 2, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, 5, CAST(0.0000 AS DECIMAL(18, 4)), CAST(12.0000 AS DECIMAL(18, 4)), 1, NULL, 1, N'2', 1, N'0', 0, 0, 1, NULL, NULL, CAST(0.0100 AS DECIMAL(18, 4)), 1057, 26100, NULL, NULL, NULL, 0, 8001, 8001, 1, 5102, 8051, CAST(N'2014-07-23 13:33:00' AS SmallDateTime), N'', NULL, N'18060101001012000', 1, 35, 6, N'Hour', NULL, NULL, NULL, NULL, 35, CAST(1.0000 AS DECIMAL(18, 4)), N'Hour', NULL, NULL, NULL)
GO
INSERT [dbo].[Part] ([ID], [StoreID], [ClassTypeID], [ModifiedByUser], [ModifiedByComputer], [ModifiedDate], [SeqID], [IsSystem], [IsActive], [CategoryID], [CategoryStoreID], [CategoryClassTypeID], [ItemName], [Description], [HelpText], [InternalNotes], [BarCode], [SKU], [AssetAccountID], [ExpenseAccountID], [InventoryUnitType], [PartType], [TrackInventory], [QuantityOnHand], [QuantityReserved], [QuantityAvailable], [QuantityOnOrder], [QuantityExpected], [ReOrderPoint], [ReOrderQuantity], [YellowNotificationPoint], [RedNotificationPoint], [NotificationAddresses], [NotifyOtherContacts], [UnitID], [RoundingOption], [ScrapFactor], [UnitCost], [TrackCosts], [UnitCostFormula], [UseFixedCost], [CostMultiplier], [CostMultiplierType], [FixedCostMultiplier], [ShowOnProductionSchedule], [InstancesAllowedType], [InstancesAllowed], [Vendor], [VendorPartNumber], [RoundingFactor], [StationID], [StationClassTypeID], [GLDepartmentID], [GLDepartmentClassTypeID], [InventoryID], [AccrueCosts], [ExpenseAccountClassTypeID], [AssetAccountClassTypeID], [UseCategoryDefaults], [ComputedCostAccountID], [ComputedCostAccountClassTypeID], [LastModifiedDate], [UDFLayoutSettings], [LocalTags], [UDFXML], [UseInvUnitsForDisplay], [DisplayUnitID], [DisplayUnitType], [DisplayUnitText], [DisplayConversionFormula], [GLDepartmentIDOV], [ExpenseAccountIDOV], [AssetAccountIDOV], [TransferUnitID], [TransferUnitQuantity], [TransferUnitText], [ResellProductID], [ResellProductIDOV], [ResellProductVariableID]) VALUES (1061, 1001, 12014, N'asabis', N'CYRIMP', CAST(N'2012-08-08 09:01:00' AS SmallDateTime), 24, 0, 0, 10224, 0, 12035, N'ZeroNine NexGen-Spot Film (Cartridge)', N'ZeroNine NexGen-Spot Film (Cartridge)', NULL, NULL, NULL, NULL, 60, 6007, 3, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 4, CAST(0.0000 AS DECIMAL(18, 4)), CAST(0.5200 AS DECIMAL(18, 4)), 1, NULL, 1, N'2.0', 1, N'0', 0, 0, 1, NULL, NULL, CAST(0.1000 AS DECIMAL(18, 4)), 1057, 26100, NULL, NULL, NULL, 0, 8001, 8001, 1, 5100, 8051, CAST(N'2012-08-08 09:01:00' AS SmallDateTime), N'', NULL, N'2.300', 1, 3, 3, N'Foot', NULL, NULL, NULL, NULL, 3, CAST(1.0000 AS DECIMAL(18, 4)), NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Part] ([ID], [StoreID], [ClassTypeID], [ModifiedByUser], [ModifiedByComputer], [ModifiedDate], [SeqID], [IsSystem], [IsActive], [CategoryID], [CategoryStoreID], [CategoryClassTypeID], [ItemName], [Description], [HelpText], [InternalNotes], [BarCode], [SKU], [AssetAccountID], [ExpenseAccountID], [InventoryUnitType], [PartType], [TrackInventory], [QuantityOnHand], [QuantityReserved], [QuantityAvailable], [QuantityOnOrder], [QuantityExpected], [ReOrderPoint], [ReOrderQuantity], [YellowNotificationPoint], [RedNotificationPoint], [NotificationAddresses], [NotifyOtherContacts], [UnitID], [RoundingOption], [ScrapFactor], [UnitCost], [TrackCosts], [UnitCostFormula], [UseFixedCost], [CostMultiplier], [CostMultiplierType], [FixedCostMultiplier], [ShowOnProductionSchedule], [InstancesAllowedType], [InstancesAllowed], [Vendor], [VendorPartNumber], [RoundingFactor], [StationID], [StationClassTypeID], [GLDepartmentID], [GLDepartmentClassTypeID], [InventoryID], [AccrueCosts], [ExpenseAccountClassTypeID], [AssetAccountClassTypeID], [UseCategoryDefaults], [ComputedCostAccountID], [ComputedCostAccountClassTypeID], [LastModifiedDate], [UDFLayoutSettings], [LocalTags], [UDFXML], [UseInvUnitsForDisplay], [DisplayUnitID], [DisplayUnitType], [DisplayUnitText], [DisplayConversionFormula], [GLDepartmentIDOV], [ExpenseAccountIDOV], [AssetAccountIDOV], [TransferUnitID], [TransferUnitQuantity], [TransferUnitText], [ResellProductID], [ResellProductIDOV], [ResellProductVariableID]) VALUES (1062, 1001, 12014, N'asabis', N'CYRIMP', CAST(N'2012-08-08 09:01:00' AS SmallDateTime), 24, 0, 0, 10224, 0, 12035, N'ZeroNine NexGen-Process Film (Refill)', N'ZeroNine NexGen-Process Film (Refill)', NULL, NULL, NULL, NULL, 60, 6007, 3, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 4, CAST(0.0000 AS DECIMAL(18, 4)), CAST(0.4700 AS DECIMAL(18, 4)), 1, NULL, 1, N'2.0', 1, N'0', 0, 0, 1, NULL, NULL, CAST(0.1000 AS DECIMAL(18, 4)), 1057, 26100, NULL, NULL, NULL, 0, 8001, 8001, 1, 5100, 8051, CAST(N'2012-08-08 09:01:00' AS SmallDateTime), N'', NULL, N'2.300', 1, 3, 3, N'Foot', NULL, NULL, NULL, NULL, 3, CAST(1.0000 AS DECIMAL(18, 4)), NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Part] ([ID], [StoreID], [ClassTypeID], [ModifiedByUser], [ModifiedByComputer], [ModifiedDate], [SeqID], [IsSystem], [IsActive], [CategoryID], [CategoryStoreID], [CategoryClassTypeID], [ItemName], [Description], [HelpText], [InternalNotes], [BarCode], [SKU], [AssetAccountID], [ExpenseAccountID], [InventoryUnitType], [PartType], [TrackInventory], [QuantityOnHand], [QuantityReserved], [QuantityAvailable], [QuantityOnOrder], [QuantityExpected], [ReOrderPoint], [ReOrderQuantity], [YellowNotificationPoint], [RedNotificationPoint], [NotificationAddresses], [NotifyOtherContacts], [UnitID], [RoundingOption], [ScrapFactor], [UnitCost], [TrackCosts], [UnitCostFormula], [UseFixedCost], [CostMultiplier], [CostMultiplierType], [FixedCostMultiplier], [ShowOnProductionSchedule], [InstancesAllowedType], [InstancesAllowed], [Vendor], [VendorPartNumber], [RoundingFactor], [StationID], [StationClassTypeID], [GLDepartmentID], [GLDepartmentClassTypeID], [InventoryID], [AccrueCosts], [ExpenseAccountClassTypeID], [AssetAccountClassTypeID], [UseCategoryDefaults], [ComputedCostAccountID], [ComputedCostAccountClassTypeID], [LastModifiedDate], [UDFLayoutSettings], [LocalTags], [UDFXML], [UseInvUnitsForDisplay], [DisplayUnitID], [DisplayUnitType], [DisplayUnitText], [DisplayConversionFormula], [GLDepartmentIDOV], [ExpenseAccountIDOV], [AssetAccountIDOV], [TransferUnitID], [TransferUnitQuantity], [TransferUnitText], [ResellProductID], [ResellProductIDOV], [ResellProductVariableID]) VALUES (1063, 1001, 12014, N'asabis', N'CYRIMP', CAST(N'2012-08-08 09:01:00' AS SmallDateTime), 25, 0, 0, 10224, 0, 12035, N'ZeroNine NexGen-Spec Spot Film (Refill)', N'ZeroNine NexGen-Spec Spot Film (Refill)', NULL, NULL, NULL, NULL, 60, 6007, 3, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 4, CAST(0.0000 AS DECIMAL(18, 4)), CAST(0.5700 AS DECIMAL(18, 4)), 1, NULL, 1, N'2.0', 1, N'0', 0, 0, 1, NULL, NULL, CAST(0.1000 AS DECIMAL(18, 4)), 1057, 26100, NULL, NULL, NULL, 0, 8001, 8001, 1, 5100, 8051, CAST(N'2012-08-08 09:01:00' AS SmallDateTime), N'', NULL, N'300', 1, 3, 3, N'Foot', NULL, NULL, NULL, NULL, 3, CAST(1.0000 AS DECIMAL(18, 4)), NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Part] ([ID], [StoreID], [ClassTypeID], [ModifiedByUser], [ModifiedByComputer], [ModifiedDate], [SeqID], [IsSystem], [IsActive], [CategoryID], [CategoryStoreID], [CategoryClassTypeID], [ItemName], [Description], [HelpText], [InternalNotes], [BarCode], [SKU], [AssetAccountID], [ExpenseAccountID], [InventoryUnitType], [PartType], [TrackInventory], [QuantityOnHand], [QuantityReserved], [QuantityAvailable], [QuantityOnOrder], [QuantityExpected], [ReOrderPoint], [ReOrderQuantity], [YellowNotificationPoint], [RedNotificationPoint], [NotificationAddresses], [NotifyOtherContacts], [UnitID], [RoundingOption], [ScrapFactor], [UnitCost], [TrackCosts], [UnitCostFormula], [UseFixedCost], [CostMultiplier], [CostMultiplierType], [FixedCostMultiplier], [ShowOnProductionSchedule], [InstancesAllowedType], [InstancesAllowed], [Vendor], [VendorPartNumber], [RoundingFactor], [StationID], [StationClassTypeID], [GLDepartmentID], [GLDepartmentClassTypeID], [InventoryID], [AccrueCosts], [ExpenseAccountClassTypeID], [AssetAccountClassTypeID], [UseCategoryDefaults], [ComputedCostAccountID], [ComputedCostAccountClassTypeID], [LastModifiedDate], [UDFLayoutSettings], [LocalTags], [UDFXML], [UseInvUnitsForDisplay], [DisplayUnitID], [DisplayUnitType], [DisplayUnitText], [DisplayConversionFormula], [GLDepartmentIDOV], [ExpenseAccountIDOV], [AssetAccountIDOV], [TransferUnitID], [TransferUnitQuantity], [TransferUnitText], [ResellProductID], [ResellProductIDOV], [ResellProductVariableID]) VALUES (1064, 1001, 12014, N'asabis', N'CYRIMP', CAST(N'2012-08-08 09:01:00' AS SmallDateTime), 24, 0, 0, 10224, 0, 12035, N'ZeroNine Legacy-Mirror Film', N'ZeroNine Legacy-Mirror Film', NULL, NULL, NULL, NULL, 60, 6007, 3, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 4, CAST(0.0000 AS DECIMAL(18, 4)), CAST(1.1700 AS DECIMAL(18, 4)), 1, NULL, 1, N'2.0', 1, N'0', 0, 0, 1, NULL, NULL, CAST(0.1000 AS DECIMAL(18, 4)), 1057, 26100, NULL, NULL, NULL, 0, 8001, 8001, 1, 5100, 8051, CAST(N'2012-08-08 09:01:00' AS SmallDateTime), N'', NULL, N'6.100', 1, 3, 3, N'Foot', NULL, NULL, NULL, NULL, 3, CAST(1.0000 AS DECIMAL(18, 4)), NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[Part] ([ID], [StoreID], [ClassTypeID], [ModifiedByUser], [ModifiedByComputer], [ModifiedDate], [SeqID], [IsSystem], [IsActive], [CategoryID], [CategoryStoreID], [CategoryClassTypeID], [ItemName], [Description], [HelpText], [InternalNotes], [BarCode], [SKU], [AssetAccountID], [ExpenseAccountID], [InventoryUnitType], [PartType], [TrackInventory], [QuantityOnHand], [QuantityReserved], [QuantityAvailable], [QuantityOnOrder], [QuantityExpected], [ReOrderPoint], [ReOrderQuantity], [YellowNotificationPoint], [RedNotificationPoint], [NotificationAddresses], [NotifyOtherContacts], [UnitID], [RoundingOption], [ScrapFactor], [UnitCost], [TrackCosts], [UnitCostFormula], [UseFixedCost], [CostMultiplier], [CostMultiplierType], [FixedCostMultiplier], [ShowOnProductionSchedule], [InstancesAllowedType], [InstancesAllowed], [Vendor], [VendorPartNumber], [RoundingFactor], [StationID], [StationClassTypeID], [GLDepartmentID], [GLDepartmentClassTypeID], [InventoryID], [AccrueCosts], [ExpenseAccountClassTypeID], [AssetAccountClassTypeID], [UseCategoryDefaults], [ComputedCostAccountID], [ComputedCostAccountClassTypeID], [LastModifiedDate], [UDFLayoutSettings], [LocalTags], [UDFXML], [UseInvUnitsForDisplay], [DisplayUnitID], [DisplayUnitType], [DisplayUnitText], [DisplayConversionFormula], [GLDepartmentIDOV], [ExpenseAccountIDOV], [AssetAccountIDOV], [TransferUnitID], [TransferUnitQuantity], [TransferUnitText], [ResellProductID], [ResellProductIDOV], [ResellProductVariableID]) VALUES (1348, -1, 12014, N'SSLIPUser', N'CYRIMP', CAST(N'2014-07-23 13:33:00' AS SmallDateTime), 6, 0, 0, 10134, 0, 12035, N'Liquid Laminator', N'Liquid Laminator', NULL, NULL, NULL, NULL, 60, 6062, 1, 2, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, 5, CAST(0.0000 AS DECIMAL(18, 4)), CAST(12.0000 AS DECIMAL(18, 4)), 1, NULL, 1, N'2', 1, N'0', 0, 0, 1, NULL, NULL, CAST(0.0100 AS DECIMAL(18, 4)), 1057, 26100, NULL, NULL, NULL, 0, 8001, 8001, 1, 5102, 8051, CAST(N'2014-07-23 13:33:00' AS SmallDateTime), N'', NULL, N'18060101001012000', 1, 35, 6, N'Hour', NULL, NULL, NULL, NULL, 35, CAST(1.0000 AS DECIMAL(18, 4)), N'Hour', NULL, NULL, NULL)
GO

• Entered : 02/02/2015
• Version : OOB v2.85 and OOB v2.86