
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'2828282', N'Metal item', N'M', N'R', N'M', N'S', N'A', N'Supply co', CAST(45.00 AS Decimal(11, 2)), CAST(50.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'50014', N'Old Item', N'M', N'F', N'M', N'S', N'A', N'', CAST(3.00 AS Decimal(11, 2)), CAST(5.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'50681221', N'complex product', N'M', N'F', N'M', N'S', N'A', N'', CAST(33.00 AS Decimal(11, 2)), CAST(44.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'ABC', N'New Item ABC', N'M', N'F', N'M', N'S', N'A', N'', CAST(100.00 AS Decimal(11, 2)), CAST(250.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'DEF', N'Another Item', N'M', N'C', N'M', N'S', N'A', N'', CAST(1300.00 AS Decimal(11, 2)), CAST(1750.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'GHI', N'a new xalt item', N'M', N'F', N'M', N'S', N'A', N'', CAST(0.00 AS Decimal(11, 2)), CAST(0.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'RST', N'An Item', N'W', N'R', N'P', N'S', N'A', N'', CAST(66.00 AS Decimal(11, 2)), CAST(342.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Item_Master] ([item_number], [item_description], [item_class], [item_type], [item_source], [item_category], [item_status], [item_supplier], [item_cost], [item_price], [item_image1]) VALUES (N'XYZ', N'Third Item', N'M', N'F', N'M', N'S', N'A', N'', CAST(344.00 AS Decimal(11, 2)), CAST(762.00 AS Decimal(11, 2)), NULL)
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'A', N'Paperwork', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'C', N'Chemistry', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'D', N'Drawing Interpretation', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'E', N'Moisture', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'I', N'Dimensions off', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'K', N'Part Mark', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'M', N'Material Defect', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'O', N'Documentation Error', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'P', N'Porosity', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'R', N'Wrong Part', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'T', N'Training', NULL, N'A')
GO
INSERT [dbo].[Nonconform_Reason] ([reason], [reason_description], [reason_QE_user], [reason_status]) VALUES (N'W', N'Weld Variation', NULL, N'A')
GO
