fjaroli

Untitled

Jun 16th, 2023
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.37 KB | None | 0 0
  1. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_VEGETABLES";
  2. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_CEREALS";
  3. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_PESTICIDES";
  4. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_FERTILIZERS";
  5. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_PULSES";
  6. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_SEEDS";
  7. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_ANIMAL_FEED";
  8. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_OIL_SEED";
  9. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_SPICES";
  10. update bridgedb.productclassification set notes = "UOM.WEIGHT.L" where ProductClassificationCode = "IE_AP_OIL";
  11. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IE_AP_FRUIT";
  12. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IE_AP_FLOWERS";
  13. update bridgedb.productclassification set notes = "UOM.WEIGHT.L" where ProductClassificationCode = "IE_AP_NATURAL_INPUTS";
  14. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "UNDP_BIO_-_INPUT";
  15. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_MADHUBANI_PAINTING";
  16. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_T_SHIRT";
  17. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_BASKET";
  18. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_OIL";
  19. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_PACKAGED_OIL";
  20. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_PACKAGED_OIL_CAKE";
  21. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_PACKAGED_CEREALS";
  22. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_PROCESSED_PULSES";
  23. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_PACKAGED_FOODS";
  24. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_TARPAULIN_AND_SHEETS";
  25. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_FARM_MACHINARIES";
  26. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IGC.AP_NTFP_PRODUCT";
  27. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IGC.AP_ALLIED_PRODUCTS";
  28. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_MILK_PRODUCTS";
  29. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_PACKED_MILLET";
  30. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IGC.AP_FRUIT_PULP";
  31. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_FLOWER_HERB";
  32. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IGC.AP_MAJOR_MILLETS";
  33. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_INSECT_TRAP";
  34. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IGC.AP_PACKED/PROCESSED_DRY_FRUITS";
  35. update bridgedb.productclassification set notes = "UOM.WEIGHT.PIECE" where ProductClassificationCode = "IGC.AP_VAP-GROCERY";
  36. update bridgedb.productclassification set notes = "UOM.WEIGHT.KG" where ProductClassificationCode = "IGC.AP_GRADED_VEGETABLES";
Advertisement
Add Comment
Please, Sign In to add comment