Explanation of SQL

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


Risk of Data Corruption if Run Improperly

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.

SQL

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'<PartLayoutTabs/>', NULL, N'<UDFs><Lam___Speed>180</Lam___Speed><Lam___Max_Width>60</Lam___Max_Width><Lam___Setup_Time>10</Lam___Setup_Time><Lam___Labor_Percentage>100</Lam___Labor_Percentage><Lam___Setup_Charge>10</Lam___Setup_Charge><Lam___Mount_Speed>120</Lam___Mount_Speed><Test_1>0</Test_1><Billboard_Land_Lessor>0</Billboard_Land_Lessor></UDFs>', 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'<PartLayoutTabs/>', NULL, N'<UDFs><Edge___FoilSqFootPrice>2.3</Edge___FoilSqFootPrice><Test_1>0</Test_1><Billboard_Land_Lessor>0</Billboard_Land_Lessor></UDFs>', 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'<PartLayoutTabs/>', NULL, N'<UDFs><Edge___FoilSqFootPrice>2.3</Edge___FoilSqFootPrice><Test_1>0</Test_1><Billboard_Land_Lessor>0</Billboard_Land_Lessor></UDFs>', 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'<PartLayoutTabs/>', NULL, N'<UDFs><Edge___FoilSqFootPrice>3</Edge___FoilSqFootPrice><Test_1>0</Test_1><Billboard_Land_Lessor>0</Billboard_Land_Lessor></UDFs>', 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'<PartLayoutTabs/>', NULL, N'<UDFs><Edge___FoilSqFootPrice>6.1</Edge___FoilSqFootPrice><Test_1>0</Test_1><Billboard_Land_Lessor>0</Billboard_Land_Lessor></UDFs>', 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'<PartLayoutTabs/>', NULL, N'<UDFs><Lam___Speed>180</Lam___Speed><Lam___Max_Width>60</Lam___Max_Width><Lam___Setup_Time>10</Lam___Setup_Time><Lam___Labor_Percentage>100</Lam___Labor_Percentage><Lam___Setup_Charge>10</Lam___Setup_Charge><Lam___Mount_Speed>120</Lam___Mount_Speed><Test_1>0</Test_1><Billboard_Land_Lessor>0</Billboard_Land_Lessor></UDFs>', 1, 35, 6, N'Hour', NULL, NULL, NULL, NULL, 35, CAST(1.0000 AS DECIMAL(18, 4)), N'Hour', NULL, NULL, NULL)
GO

Version Information

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

Related SQLs