BEGIN
INSERT INTO im_inventorymaster  (ItemNumber, ItemDescription, ProductLine, ProductType, Procurement, Valuation, PriceCode, BackordersAllowed2, IT_Enabled,  DefaultWhse,
Weight, ImageFile, DateLastSold, AlternateItems, PriceByItem, PriceByCustomerPriceLevel, PriceByCustomerNumberr, ExplodeKit, ReturnsAllowed,TaxClass,
WarrantyCode, SuggestedRetailPrice, StdPrice, TotalQtyOnHand, Volume, DateCreated, TimeCreated, DateUpdated)
VALUES (TRIM(NEW.ItemNumber), TRIM(NEW.ItemDescription), NEW.ProductLine, NEW.ProductType, NEW.Procurement, NEW.Valuation, TRIM(NEW.PriceCode), NEW.BackordersAllowed,
NEW.IT_Enabled,  NEW.DefaultWhse, TRIM( NEW.Weight), TRIM(NEW.ImageFile), NEW.DateLastSold, NEW.AlternateItems, NEW.PriceByItem, NEW.PriceByCustomerPriceLevel, NEW.PriceByCustomerNumber,
NEW.ExplodeKit, NEW.ReturnsAllowed, NEW.TaxClass, NEW.WarrantyCode, NEW.SuggestedRetailPrice, NEW.StdPrice, NEW.TotalQtyOnHand, TRIM(NEW.Volume), NEW.DateCreated, NEW.TimeCreated,
NOW())
ON duplicate KEY
UPDATE ItemDescription = TRIM(NEW.ItemDescription), ProductLine = NEW.ProductLine, ProductType = NEW.ProductType, Procurement = NEW.Procurement,
Valuation = NEW.Valuation, PriceCode = TRIM(NEW.PriceCode), BackordersAllowed2 = NEW.BackordersAllowed, IT_Enabled = NEW.IT_Enabled,  DefaultWhse = NEW.DefaultWhse,
Weight = TRIM( NEW.Weight), ImageFile = TRIM(NEW.ImageFile), DateLastSold = NEW.DateLastSold, AlternateItems = NEW.AlternateItems, PriceByItem = NEW.PriceByItem,
PriceByCustomerPriceLevel = NEW.PriceByCustomerPriceLevel, PriceByCustomerNumber = NEW.PriceByCustomerNumber, ExplodeKit = NEW.ExplodeKit, ReturnsAllowed = NEW.ReturnsAllowed,
TaxClass = NEW.TaxClass, WarrantyCode = NEW.WarrantyCode, SuggestedRetailPrice = NEW.SuggestedRetailPrice, StdPrice = NEW.StdPrice, TotalQtyOnHand = NEW.TotalQtyOnHand,
Volume = TRIM(NEW.Volume), DateCreated = NEW.DateCreated, TimeCreated = NEW.TimeCreated, DateUpdated = NOW(), DateDeleted = 0;
END