Migrating data from Access 97 to Postgres database
選択できるのは25トピックまでです。 トピックは、先頭が英数字で、英数字とダッシュ('-')を使用した35文字以内のものにしてください。

InitialSeedData.sql 108 KiB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633
  1. Delete From "Deviation";
  2. Delete From "Application";
  3. Delete From "Engine";
  4. Delete From "Model";
  5. Delete From "Product";
  6. Delete From "Make";
  7. Delete From "Bom";
  8. Delete From "DesignSpec";
  9. Delete From "CustomerSpec";
  10. Delete From "Document";
  11. Delete From "XCustomerPartNumber";
  12. Delete From "CustomerPrint";
  13. Delete From "PartNumber";
  14. Delete From "Vendor";
  15. Delete From "Customer";
  16. Delete From "Location";
  17. Delete From "PartCode";
  18. Delete From "PartType";
  19. Delete From "Status";
  20. --Status
  21. Insert Into "Status"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(1, 'Active', now(), -1, now(), -1);
  22. Insert Into "Status"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(2, 'Obsolete', now(), -1, now(), -1);
  23. Insert Into "Status"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(3, 'Approved', now(), -1, now(), -1);
  24. Insert Into "Status"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(4, 'In Process', now(), -1, now(), -1);
  25. Insert Into "Status"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(5, 'Submitted for FAC', now(), -1, now(), -1);
  26. Insert Into "Status"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(6, 'Submitted for Approval', now(), -1, now(), -1);
  27. --PartType
  28. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(1, 'Built motor', 100000, 189999, now(), -1, now(), -1);
  29. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(2, 'Upfit kit', 190000, 199999, now(), -1, now(), -1);
  30. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(3, 'MultiVac kit', 310000, 319999, now(), -1, now(), -1);
  31. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(4, 'SCET', 300000, 309999, now(), -1, now(), -1);
  32. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(5, 'Controlled document', 10000, 99999, now(), -1, now(), -1);
  33. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(6, 'General', 100600, 189999, now(), -1, now(), -1);
  34. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(7, 'Experimental', 700000, 709999, now(), -1, now(), -1);
  35. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(8, 'Tooling', 800000, 809999, now(), -1, now(), -1);
  36. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(9, 'Core', 980000, 989999, now(), -1, now(), -1);
  37. Insert Into "PartType"(id, name, "starting", "ending", "createDate", "createUserId", "updateDate", "updateUserId") Values(0, 'N/A', 0, 0, now(), -1, now(), -1);
  38. --PartCode
  39. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(2, 'Cart', now(), -1, now(), -1, 6, '13-0', true, true, 1);
  40. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(72, 'Adapter', now(), -1, now(), -1, 6, '4-10', true, false, 69);
  41. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(297, 'Other', now(), -1, now(), -1, 0, null, true, false, null);
  42. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(1, 'Tooling', now(), -1, now(), -1, 6, '13', true, false, null);
  43. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(3, 'Table', now(), -1, now(), -1, 6, '13-1', true, true, 1);
  44. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(4, 'Half Clean', now(), -1, now(), -1, 6, '13-10', true, false, 3);
  45. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(5, 'Half Used', now(), -1, now(), -1, 6, '13-11', true, false, 3);
  46. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(6, 'Full', now(), -1, now(), -1, 6, '13-12', true, false, 3);
  47. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(7, 'Skids', now(), -1, now(), -1, 6, '13-2', true, true, 1);
  48. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(8, 'Power Gen', now(), -1, now(), -1, 6, '13-20', true, false, 7);
  49. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(9, '60 Gallon', now(), -1, now(), -1, 6, '13-200', true, false, 8);
  50. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(10, '80 Gallon', now(), -1, now(), -1, 6, '13-201', true, false, 8);
  51. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(11, '80 Gallon Short', now(), -1, now(), -1, 6, '13-202', true, false, 8);
  52. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(12, '100 Gallon', now(), -1, now(), -1, 6, '13-203', true, false, 8);
  53. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(13, 'Construction', now(), -1, now(), -1, 6, '13-21', true, false, 7);
  54. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(14, '60 Gallon', now(), -1, now(), -1, 6, '13-210', true, false, 13);
  55. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(15, '90 Gallon', now(), -1, now(), -1, 6, '13-211', true, false, 13);
  56. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(16, '120 Gallon', now(), -1, now(), -1, 6, '13-212', true, false, 13);
  57. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(17, '150 Gallon', now(), -1, now(), -1, 6, '13-213', true, false, 13);
  58. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(18, 'Trailer', now(), -1, now(), -1, 6, '13-3', true, true, 1);
  59. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(19, 'Power Gen', now(), -1, now(), -1, 6, '13-30', true, false, 18);
  60. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(20, '150 Gallon', now(), -1, now(), -1, 6, '13-300', true, false, 19);
  61. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(21, '400 Gallon', now(), -1, now(), -1, 6, '13-301', true, false, 19);
  62. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(22, 'Construction', now(), -1, now(), -1, 6, '13-31', true, false, 18);
  63. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(23, 'Pulse', now(), -1, now(), -1, 6, '13-4', true, true, 1);
  64. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(24, 'Hub', now(), -1, now(), -1, 6, '13-40', true, false, 23);
  65. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(25, 'Extender', now(), -1, now(), -1, 6, '13-41', true, false, 23);
  66. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(26, 'Remote Extender', now(), -1, now(), -1, 6, '13-42', true, false, 23);
  67. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(27, 'Tank Level Monitor', now(), -1, now(), -1, 6, '13-43', true, false, 23);
  68. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(28, 'Meter', now(), -1, now(), -1, 6, '13-44', true, false, 23);
  69. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(29, 'Roll Around', now(), -1, now(), -1, 6, '13-45', true, false, 23);
  70. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(30, 'Reels', now(), -1, now(), -1, 6, '13-5', true, true, 1);
  71. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(31, '3/8"', now(), -1, now(), -1, 6, '13-50', true, false, 30);
  72. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(32, '1/2"', now(), -1, now(), -1, 6, '13-51', true, false, 30);
  73. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(33, '3/4"', now(), -1, now(), -1, 6, '13-52', true, false, 30);
  74. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(34, '1"', now(), -1, now(), -1, 6, '13-53', true, false, 30);
  75. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(35, '1-1/4"', now(), -1, now(), -1, 6, '13-54', true, false, 30);
  76. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(36, '1-1/2"', now(), -1, now(), -1, 6, '13-55', true, false, 30);
  77. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(37, 'Pump', now(), -1, now(), -1, 6, '13-6', true, true, 1);
  78. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(38, 'AC', now(), -1, now(), -1, 6, '13-60', true, false, 37);
  79. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(39, 'Diaphragm', now(), -1, now(), -1, 6, '13-600', true, false, 38);
  80. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(40, 'Gear', now(), -1, now(), -1, 6, '13-601', true, false, 38);
  81. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(41, 'DC', now(), -1, now(), -1, 6, '13-61', true, false, 37);
  82. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(42, 'Diaphragm', now(), -1, now(), -1, 6, '13-610', true, false, 41);
  83. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(43, 'Gear', now(), -1, now(), -1, 6, '13-611', true, false, 41);
  84. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(44, 'Pneumatic', now(), -1, now(), -1, 6, '13-62', true, false, 37);
  85. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(45, 'Diaphragm', now(), -1, now(), -1, 6, '13-620', true, false, 44);
  86. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(46, 'Piston', now(), -1, now(), -1, 6, '13-621', true, false, 44);
  87. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(47, 'AC8', now(), -1, now(), -1, 6, '13-6010', true, false, 40);
  88. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(48, 'SCET', now(), -1, now(), -1, 6, '13-6110', true, false, 43);
  89. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(49, 'Meters', now(), -1, now(), -1, 6, '13-7', true, true, 1);
  90. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(50, 'Digital', now(), -1, now(), -1, 6, '13-70', true, false, 49);
  91. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(51, 'Mechanical', now(), -1, now(), -1, 6, '13-71', true, false, 49);
  92. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(52, 'Tool', now(), -1, now(), -1, 6, '13-8', true, true, 1);
  93. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(53, 'Conversion Kit', now(), -1, now(), -1, 6, '13-80', true, false, 52);
  94. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(54, 'Purge Tool', now(), -1, now(), -1, 6, '13-81', true, false, 52);
  95. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(55, 'Sample Tool', now(), -1, now(), -1, 6, '13-82', true, false, 52);
  96. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(56, 'Activation Tool', now(), -1, now(), -1, 6, '13-83', true, false, 52);
  97. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(57, 'Prelub', now(), -1, now(), -1, 6, '2', true, false, null);
  98. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(58, 'Kits', now(), -1, now(), -1, 6, '3', true, false, null);
  99. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(59, 'QuickEvac', now(), -1, now(), -1, 2, '3-0', true, true, 58);
  100. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(60, 'QuickFit', now(), -1, now(), -1, 4, '3-1', true, true, 58);
  101. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(61, 'MultiVac', now(), -1, now(), -1, 3, '3-2', true, true, 58);
  102. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(62, 'MCES', now(), -1, now(), -1, 4, '3-3', true, true, 58);
  103. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(63, 'SCET', now(), -1, now(), -1, 4, '3-4', true, true, 58);
  104. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(64, 'Prelub', now(), -1, now(), -1, 2, '3-5', true, true, 58);
  105. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(65, 'Electrical', now(), -1, now(), -1, 6, '3-6', true, true, 58);
  106. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(66, 'Plumbing', now(), -1, now(), -1, 6, '3-7', true, true, 58);
  107. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(67, 'Components', now(), -1, now(), -1, 6, '4', true, false, null);
  108. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(68, 'Electrical', now(), -1, now(), -1, 6, '4-0', true, false, 67);
  109. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(69, 'Plumbing', now(), -1, now(), -1, 6, '4-1', true, false, 67);
  110. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(70, 'Hardware', now(), -1, now(), -1, 6, '4-2', true, false, 67);
  111. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(71, 'Brackets', now(), -1, now(), -1, 6, '4-3', true, false, 67);
  112. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(73, 'Hose', now(), -1, now(), -1, 6, '4-11', true, true, 69);
  113. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(74, 'Valve', now(), -1, now(), -1, 6, '4-12', true, true, 69);
  114. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(75, 'Filter Adapter', now(), -1, now(), -1, 6, '4-13', true, true, 69);
  115. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(76, 'Seal', now(), -1, now(), -1, 6, '4-14', true, true, 69);
  116. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(77, 'Plate', now(), -1, now(), -1, 6, '4-15', true, true, 69);
  117. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(78, 'Straight', now(), -1, now(), -1, 6, '4-100', true, true, 72);
  118. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(79, 'Elbow', now(), -1, now(), -1, 6, '4-101', true, true, 72);
  119. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(80, 'Tee', now(), -1, now(), -1, 6, '4-102', true, true, 72);
  120. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(81, 'Cross', now(), -1, now(), -1, 6, '4-103', true, true, 72);
  121. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(82, 'Cap', now(), -1, now(), -1, 6, '4-104', true, true, 72);
  122. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(83, 'Plug', now(), -1, now(), -1, 6, '4-105', true, true, 72);
  123. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(84, 'Banjo', now(), -1, now(), -1, 6, '4-106', true, true, 72);
  124. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(85, 'Hose End', now(), -1, now(), -1, 6, '4-107', true, true, 72);
  125. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(86, 'Bolt', now(), -1, now(), -1, 6, '4-20', true, true, 70);
  126. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(87, 'Screw', now(), -1, now(), -1, 6, '4-21', true, true, 70);
  127. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(88, 'Nut', now(), -1, now(), -1, 6, '4-22', true, true, 70);
  128. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(89, 'Washer', now(), -1, now(), -1, 6, '4-23', true, true, 70);
  129. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(90, 'Assembly', now(), -1, now(), -1, 6, '4-110', true, true, 73);
  130. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(91, 'Socketless', now(), -1, now(), -1, 6, '4-111', true, false, 73);
  131. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(92, 'Heavy Duty', now(), -1, now(), -1, 6, '4-112', true, false, 73);
  132. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(93, 'Marine', now(), -1, now(), -1, 6, '4-113', true, false, 73);
  133. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(216, 'Firesleeve', now(), -1, now(), -1, 6, '4-113', true, true, 73);
  134. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(94, 'Check', now(), -1, now(), -1, 6, '4-120', true, true, 74);
  135. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(95, 'Ball', now(), -1, now(), -1, 6, '4-121', true, true, 74);
  136. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(96, 'Filter Ring', now(), -1, now(), -1, 6, '4-130', true, true, 75);
  137. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(97, 'Nipple', now(), -1, now(), -1, 6, '4-131', true, true, 75);
  138. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(98, 'O-Ring', now(), -1, now(), -1, 6, '4-140', true, true, 76);
  139. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(99, 'Gasket', now(), -1, now(), -1, 6, '4-141', true, true, 76);
  140. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(100, 'Dowty', now(), -1, now(), -1, 6, '4-142', true, true, 76);
  141. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(101, 'Copper', now(), -1, now(), -1, 6, '4-143', true, true, 76);
  142. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(102, 'Labor', now(), -1, now(), -1, 6, '5', true, false, null);
  143. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(103, 'Kit', now(), -1, now(), -1, 6, '5-0', true, false, 102);
  144. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(104, 'Hose', now(), -1, now(), -1, 6, '5-1', true, false, 102);
  145. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(105, 'Tooling', now(), -1, now(), -1, 6, '5-2', true, false, 102);
  146. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(106, 'Installation', now(), -1, now(), -1, 6, '5-3', true, false, 102);
  147. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(107, 'Training', now(), -1, now(), -1, 6, '5-4', true, false, 102);
  148. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(108, 'Overhead', now(), -1, now(), -1, 6, '6', true, false, null);
  149. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(109, 'Kit', now(), -1, now(), -1, 6, '6-0', true, false, 108);
  150. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(110, 'Hose', now(), -1, now(), -1, 6, '6-1', true, false, 108);
  151. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(111, 'Tooling', now(), -1, now(), -1, 6, '6-2', true, false, 108);
  152. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(112, 'Installation', now(), -1, now(), -1, 6, '6-3', true, false, 108);
  153. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(113, 'Training', now(), -1, now(), -1, 6, '6-4', true, false, 108);
  154. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(114, 'Warranty', now(), -1, now(), -1, 6, '7', true, false, null);
  155. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(115, 'Financial', now(), -1, now(), -1, 6, '8', true, false, null);
  156. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(116, 'Core', now(), -1, now(), -1, 9, '9', true, false, null);
  157. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(117, 'Motor', now(), -1, now(), -1, 6, '5-5', true, false, 102);
  158. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(278, 'Motor', now(), -1, now(), -1, 6, '5-5', true, false, 102);
  159. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(118, 'Remote', now(), -1, now(), -1, 6, '5-6', true, false, 102);
  160. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(279, 'Switch', now(), -1, now(), -1, 6, '5-6', true, false, 102);
  161. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(119, 'Switch', now(), -1, now(), -1, 6, '5-7', true, false, 102);
  162. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(120, 'Motor', now(), -1, now(), -1, 6, '6-5', true, false, 108);
  163. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(282, 'Motor', now(), -1, now(), -1, 6, '6-5', true, false, 108);
  164. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(121, 'Remote', now(), -1, now(), -1, 6, '6-6', true, false, 108);
  165. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(283, 'Switch', now(), -1, now(), -1, 6, '6-6', true, false, 108);
  166. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(122, 'Switch', now(), -1, now(), -1, 6, '6-7', true, false, 108);
  167. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(123, 'ConnexionMobile', now(), -1, now(), -1, 6, '10', true, false, null);
  168. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(124, 'Controls', now(), -1, now(), -1, 6, '4-01', true, false, 68);
  169. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(125, 'Wiring', now(), -1, now(), -1, 6, '4-02', true, false, 68);
  170. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(126, 'Wiring Harness', now(), -1, now(), -1, 6, '4-03', true, true, 68);
  171. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(127, 'Switches', now(), -1, now(), -1, 6, '4-010', true, false, 124);
  172. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(128, 'Relay', now(), -1, now(), -1, 6, '4-011', true, true, 124);
  173. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(129, 'Timer', now(), -1, now(), -1, 6, '4-012', true, true, 124);
  174. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(130, 'Switch/Timer', now(), -1, now(), -1, 6, '4-013', true, true, 124);
  175. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(131, 'Circuit Board', now(), -1, now(), -1, 6, '4-014', true, true, 124);
  176. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(132, 'Controller', now(), -1, now(), -1, 6, '4-015', true, true, 124);
  177. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(133, 'Wire', now(), -1, now(), -1, 6, '4-020', true, true, 125);
  178. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(134, 'Connector', now(), -1, now(), -1, 6, '4-021', true, true, 125);
  179. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(135, 'Conduit', now(), -1, now(), -1, 6, '4-022', true, true, 125);
  180. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(136, 'Fuse', now(), -1, now(), -1, 6, '4-023', true, true, 125);
  181. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(137, 'Components', now(), -1, now(), -1, 6, '4-024', true, true, 125);
  182. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(138, 'Heat Shrink', now(), -1, now(), -1, 6, '4-025', true, true, 125);
  183. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(139, 'Main', now(), -1, now(), -1, 6, '4-030', true, true, 126);
  184. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(140, 'Keyswitch', now(), -1, now(), -1, 6, '4-031', true, true, 126);
  185. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(141, 'Sensor', now(), -1, now(), -1, 6, '4-032', true, true, 126);
  186. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(142, 'Extension', now(), -1, now(), -1, 6, '4-033', true, true, 126);
  187. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(143, 'Sensor', now(), -1, now(), -1, 6, '4-016', true, true, 124);
  188. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(144, 'Deutsch', now(), -1, now(), -1, 6, '4-0210', true, true, 134);
  189. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(145, 'Sure Seal', now(), -1, now(), -1, 6, '4-0211', true, true, 134);
  190. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(146, 'Packard', now(), -1, now(), -1, 6, '4-0212', true, true, 134);
  191. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(147, 'Cinch', now(), -1, now(), -1, 6, '4-0213', true, true, 134);
  192. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(148, 'Molex', now(), -1, now(), -1, 6, '4-0214', true, true, 134);
  193. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(149, 'Ring Terminal', now(), -1, now(), -1, 6, '4-0215', true, true, 134);
  194. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(150, 'Quick Disconnect', now(), -1, now(), -1, 6, '4-108', true, true, 72);
  195. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(251, 'Special Fitting', now(), -1, now(), -1, 6, '4-108', true, true, 72);
  196. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(151, 'Pickup Tube', now(), -1, now(), -1, 6, '4-109', true, true, 72);
  197. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(152, 'Controlled Document', now(), -1, now(), -1, 5, '11', true, true, null);
  198. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(153, 'Built', now(), -1, now(), -1, 6, '2-0', true, false, 57);
  199. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(154, 'Unbuilt', now(), -1, now(), -1, 6, '2-1', true, false, 57);
  200. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(155, 'Components', now(), -1, now(), -1, 6, '2-2', true, false, 57);
  201. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(156, 'Armature', now(), -1, now(), -1, 6, '2-20', true, true, 155);
  202. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(157, 'Bearing', now(), -1, now(), -1, 6, '2-21', true, true, 155);
  203. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(158, 'Brush', now(), -1, now(), -1, 6, '2-22', true, true, 155);
  204. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(159, 'Brush Holder', now(), -1, now(), -1, 6, '2-23', true, true, 155);
  205. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(160, 'Brush Plate Assembly', now(), -1, now(), -1, 6, '2-24', true, true, 155);
  206. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(161, 'Bushing', now(), -1, now(), -1, 6, '2-25', true, true, 155);
  207. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(162, 'Cartridge', now(), -1, now(), -1, 6, '2-26', true, true, 155);
  208. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(163, 'CE Plate', now(), -1, now(), -1, 6, '2-27', true, true, 155);
  209. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(164, 'Crank Solenoid', now(), -1, now(), -1, 6, '2-28', true, true, 155);
  210. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(165, 'Cup', now(), -1, now(), -1, 6, '2-29', true, true, 155);
  211. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(166, 'Drive', now(), -1, now(), -1, 6, '2-210', true, true, 155);
  212. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(167, 'Field', now(), -1, now(), -1, 6, '2-211', true, true, 155);
  213. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(168, 'Field Housing', now(), -1, now(), -1, 6, '2-212', true, true, 155);
  214. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(169, 'Frame', now(), -1, now(), -1, 6, '2-213', true, true, 155);
  215. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(170, 'Frame & Field', now(), -1, now(), -1, 6, '2-214', true, true, 155);
  216. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(171, 'Gear', now(), -1, now(), -1, 6, '2-215', true, true, 155);
  217. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(172, 'Ground Strap', now(), -1, now(), -1, 6, '2-216', true, true, 155);
  218. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(173, 'Ground Stud', now(), -1, now(), -1, 6, '2-217', true, true, 155);
  219. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(174, 'Inspection Plug', now(), -1, now(), -1, 6, '2-218', true, true, 155);
  220. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(175, 'Insulation', now(), -1, now(), -1, 6, '2-219', true, true, 155);
  221. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(176, 'Insulator', now(), -1, now(), -1, 6, '2-220', true, true, 155);
  222. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(177, 'Key', now(), -1, now(), -1, 6, '2-221', true, true, 155);
  223. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(178, 'Lever', now(), -1, now(), -1, 6, '2-222', true, true, 155);
  224. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(179, 'Lever Housing', now(), -1, now(), -1, 6, '2-223', true, true, 155);
  225. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(180, 'Pump Lid', now(), -1, now(), -1, 6, '2-224', true, true, 155);
  226. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(181, 'Motor Adapter Plate', now(), -1, now(), -1, 6, '2-225', true, true, 155);
  227. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(182, 'Nose Housing', now(), -1, now(), -1, 6, '2-226', true, true, 155);
  228. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(183, 'Pin', now(), -1, now(), -1, 6, '2-227', true, true, 155);
  229. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(184, 'Pole Shoe', now(), -1, now(), -1, 6, '2-228', true, true, 155);
  230. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(185, 'Pump', now(), -1, now(), -1, 6, '2-229', true, true, 155);
  231. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(186, 'Pump Casting', now(), -1, now(), -1, 6, '2-230', true, true, 155);
  232. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(187, 'Pump Lid Casting', now(), -1, now(), -1, 6, '2-231', true, true, 155);
  233. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(188, 'Pump Lid Gasket', now(), -1, now(), -1, 6, '2-232', true, true, 155);
  234. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(189, 'Shaft', now(), -1, now(), -1, 6, '2-233', true, true, 155);
  235. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(190, 'Wick', now(), -1, now(), -1, 6, '2-234', true, true, 155);
  236. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(191, 'Motor - AC', now(), -1, now(), -1, 6, '2-235', true, true, 155);
  237. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(192, 'Motor - DC', now(), -1, now(), -1, 6, '2-236', true, true, 155);
  238. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(193, 'OE', now(), -1, now(), -1, 6, '2-00', true, false, 153);
  239. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(194, 'Reman', now(), -1, now(), -1, 6, '2-01', true, false, 153);
  240. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(195, 'Remote', now(), -1, now(), -1, 6, '2-000', true, false, 193);
  241. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(196, 'Starter', now(), -1, now(), -1, 6, '2-001', true, false, 193);
  242. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(197, 'Remote', now(), -1, now(), -1, 6, '2-010', true, false, 194);
  243. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(198, 'Starter', now(), -1, now(), -1, 6, '2-011', true, false, 194);
  244. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(199, 'AC', now(), -1, now(), -1, 6, '2-0000', true, false, 195);
  245. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(200, 'DC', now(), -1, now(), -1, 6, '2-0001', true, false, 195);
  246. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(201, 'P1K', now(), -1, now(), -1, 6, '2-00010', true, false, 200);
  247. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(202, 'P2K', now(), -1, now(), -1, 6, '2-00011', true, false, 200);
  248. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(203, 'P3K', now(), -1, now(), -1, 6, '2-00012', true, false, 200);
  249. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(204, 'P3KHD', now(), -1, now(), -1, 6, '2-00013', true, false, 200);
  250. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(205, 'P4K10', now(), -1, now(), -1, 6, '2-00014', true, false, 200);
  251. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(206, 'P4K20', now(), -1, now(), -1, 6, '2-00015', true, false, 200);
  252. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(207, 'P4K40', now(), -1, now(), -1, 6, '2-00016', true, false, 200);
  253. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(208, 'P4L20', now(), -1, now(), -1, 6, '2-00017', true, false, 200);
  254. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(209, 'P4L40', now(), -1, now(), -1, 6, '2-00018', true, false, 200);
  255. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(210, 'HVP', now(), -1, now(), -1, 6, '2-00019', true, false, 200);
  256. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(211, '40RM', now(), -1, now(), -1, 6, '2-000110', true, false, 200);
  257. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(212, '41RM', now(), -1, now(), -1, 6, '2-000111', true, false, 200);
  258. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(213, 'DC', now(), -1, now(), -1, 6, '2-0010', true, false, 202);
  259. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(214, '42MT', now(), -1, now(), -1, 6, '2-00100', true, false, 213);
  260. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(215, '50MT', now(), -1, now(), -1, 6, '2-00101', true, false, 213);
  261. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(217, 'Mag Switch', now(), -1, now(), -1, 6, '4-0100', true, true, 127);
  262. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(218, 'Pressure Switch', now(), -1, now(), -1, 6, '4-0101', true, true, 127);
  263. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(219, 'Grommet', now(), -1, now(), -1, 6, '4-24', true, true, 70);
  264. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(220, 'Pneumatics', now(), -1, now(), -1, 6, '4-4', true, true, 67);
  265. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(221, 'Compressor', now(), -1, now(), -1, 6, '4-40', true, true, 220);
  266. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(222, 'Compressor Accessory', now(), -1, now(), -1, 6, '4-41', true, true, 220);
  267. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(223, 'Clamp', now(), -1, now(), -1, 6, '4-25', true, true, 70);
  268. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(224, 'New Take Off', now(), -1, now(), -1, 9, '9-0', true, false, 116);
  269. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(225, 'Tag', now(), -1, now(), -1, 6, '4-50', true, true, 231);
  270. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(226, 'Remote Bracket', now(), -1, now(), -1, 6, '2-237', true, true, 155);
  271. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(227, 'Snap Ring', now(), -1, now(), -1, 6, '4-27', true, true, 70);
  272. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(228, 'Spacer', now(), -1, now(), -1, 6, '4-28', true, true, 70);
  273. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(229, 'Rivet', now(), -1, now(), -1, 6, '4-29', true, true, 70);
  274. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(230, 'Spring', now(), -1, now(), -1, 6, '4-210', true, true, 70);
  275. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(231, 'Marking', now(), -1, now(), -1, 6, '4-5', true, false, 67);
  276. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(232, 'Manifold', now(), -1, now(), -1, 6, '4-16', true, true, 69);
  277. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(233, 'Components', now(), -1, now(), -1, 6, '13-9', true, false, 1);
  278. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(234, 'Containment', now(), -1, now(), -1, 6, '13-90', true, true, 233);
  279. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(235, 'Tank', now(), -1, now(), -1, 6, '13-91', true, true, 233);
  280. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(236, 'Filter Box', now(), -1, now(), -1, 6, '13-92', true, true, 233);
  281. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(237, 'Reel Box', now(), -1, now(), -1, 6, '13-93', true, true, 233);
  282. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(238, 'Spill Box', now(), -1, now(), -1, 6, '13-94', true, true, 233);
  283. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(239, 'Battery Box', now(), -1, now(), -1, 6, '13-95', true, true, 233);
  284. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(240, 'Sticker', now(), -1, now(), -1, 6, '4-51', true, true, 231);
  285. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(241, '12V', now(), -1, now(), -1, 6, '4-01000', true, false, 217);
  286. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(242, '24V', now(), -1, now(), -1, 6, '4-01001', true, false, 217);
  287. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(243, 'Components', now(), -1, now(), -1, 6, '4-01002', true, false, 217);
  288. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(244, 'Can', now(), -1, now(), -1, 6, '4-010020', true, true, 243);
  289. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(245, 'Coil', now(), -1, now(), -1, 6, '4-010021', true, true, 243);
  290. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(246, 'Contact', now(), -1, now(), -1, 6, '4-010022', true, true, 243);
  291. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(247, 'Contact Disk', now(), -1, now(), -1, 6, '4-010023', true, true, 243);
  292. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(248, 'Plunger', now(), -1, now(), -1, 6, '4-010024', true, true, 243);
  293. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(249, 'Cable Tie', now(), -1, now(), -1, 6, '4-026', true, true, 125);
  294. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(250, 'Enclosure', now(), -1, now(), -1, 6, '4-027', true, true, 125);
  295. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(252, 'Stud', now(), -1, now(), -1, 6, '4-211', true, true, 70);
  296. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(253, 'Packaging', now(), -1, now(), -1, 6, '4-6', true, false, 67);
  297. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(254, 'Box', now(), -1, now(), -1, 6, '4-60', true, true, 254);
  298. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(255, 'Cart', now(), -1, now(), -1, 6, '5-20', true, false, 105);
  299. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(256, 'Skid', now(), -1, now(), -1, 6, '5-21', true, false, 105);
  300. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(257, 'Trailer', now(), -1, now(), -1, 6, '5-22', true, false, 105);
  301. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(258, 'Cart', now(), -1, now(), -1, 6, '6-20', true, false, 111);
  302. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(259, 'Skid', now(), -1, now(), -1, 6, '6-21', true, false, 111);
  303. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(260, 'Trailer', now(), -1, now(), -1, 6, '6-22', true, false, 111);
  304. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(261, 'Warranty Credit', now(), -1, now(), -1, 6, '7-0', true, false, 114);
  305. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(262, 'Error', now(), -1, now(), -1, 6, '8-0', true, false, 115);
  306. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(263, 'R&D', now(), -1, now(), -1, 6, '8-1', true, false, 115);
  307. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(264, 'Adjustments', now(), -1, now(), -1, 6, '8-2', true, false, 115);
  308. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(265, 'Plant', now(), -1, now(), -1, 6, '8-00', true, false, 262);
  309. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(266, 'BOM', now(), -1, now(), -1, 6, '8-01', true, false, 262);
  310. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(267, 'Admin', now(), -1, now(), -1, 6, '8-02', true, false, 262);
  311. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(268, 'Install', now(), -1, now(), -1, 6, '8-03', true, false, 262);
  312. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(269, 'Product Testing', now(), -1, now(), -1, 6, '8-10', true, false, 263);
  313. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(270, 'Field Test', now(), -1, now(), -1, 6, '8-11', true, false, 263);
  314. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(271, 'R&D - For Sale', now(), -1, now(), -1, 6, '8-12', true, false, 263);
  315. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(272, 'R&D - Not For Sale', now(), -1, now(), -1, 6, '8-13', true, false, 263);
  316. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(273, 'Experimental #s', now(), -1, now(), -1, 6, '8-14', true, false, 263);
  317. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(274, 'Pricing Adjust', now(), -1, now(), -1, 6, '8-20', true, false, 264);
  318. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(275, 'No Charge Cr', now(), -1, now(), -1, 6, '8-21', true, false, 264);
  319. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(276, 'Core Credit', now(), -1, now(), -1, 9, '9-1', true, false, 116);
  320. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(277, 'Core Charge', now(), -1, now(), -1, 9, '9-2', true, false, 116);
  321. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(280, 'Starter', now(), -1, now(), -1, 6, '5-50', true, false, 278);
  322. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(281, 'Remote', now(), -1, now(), -1, 6, '5-51', true, false, 278);
  323. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(284, 'Starter', now(), -1, now(), -1, 6, '6-50', true, false, 282);
  324. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(285, 'Remote', now(), -1, now(), -1, 6, '6-51', true, false, 282);
  325. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(286, 'Miscellany ', now(), -1, now(), -1, 0, '12', true, false, null);
  326. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(287, 'Component', now(), -1, now(), -1, 0, '12-0', true, false, 286);
  327. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(288, 'Obsolete item', now(), -1, now(), -1, 0, '12-1', true, false, 286);
  328. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(289, 'Mic Sales/Serv', now(), -1, now(), -1, 0, '12-2', true, false, 286);
  329. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(290, 'Misc Ret/Allow', now(), -1, now(), -1, 0, '12-3', true, false, 286);
  330. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(291, 'Show', now(), -1, now(), -1, 6, '2-02', true, false, 153);
  331. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(292, 'Non Stock Item', now(), -1, now(), -1, 0, '12-4', true, false, 286);
  332. Insert Into "PartCode"(id, name, "createDate", "createUserId", "updateDate", "updateUserId", "partTypeId", "code", "isActive", "isPartCode", "paretnId") Values(293, 'Equipment Lease Program', now(), -1, now(), -1, 0, '12-5', true, false, 286);
  333. --Location
  334. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(2, 'Cart', now(), -1, now(), -1);
  335. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(72, 'Adapter', now(), -1, now(), -1);
  336. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(297, 'Other', now(), -1, now(), -1);
  337. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(1, 'Tooling', now(), -1, now(), -1);
  338. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(3, 'Table', now(), -1, now(), -1);
  339. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(4, 'Half Clean', now(), -1, now(), -1);
  340. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(5, 'Half Used', now(), -1, now(), -1);
  341. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(6, 'Full', now(), -1, now(), -1);
  342. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(7, 'Skids', now(), -1, now(), -1);
  343. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(8, 'Power Gen', now(), -1, now(), -1);
  344. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(9, '60 Gallon', now(), -1, now(), -1);
  345. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(10, '80 Gallon', now(), -1, now(), -1);
  346. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(11, '80 Gallon Short', now(), -1, now(), -1);
  347. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(12, '100 Gallon', now(), -1, now(), -1);
  348. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(13, 'Construction', now(), -1, now(), -1);
  349. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(14, '60 Gallon', now(), -1, now(), -1);
  350. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(15, '90 Gallon', now(), -1, now(), -1);
  351. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(16, '120 Gallon', now(), -1, now(), -1);
  352. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(17, '150 Gallon', now(), -1, now(), -1);
  353. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(18, 'Trailer', now(), -1, now(), -1);
  354. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(19, 'Power Gen', now(), -1, now(), -1);
  355. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(20, '150 Gallon', now(), -1, now(), -1);
  356. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(21, '400 Gallon', now(), -1, now(), -1);
  357. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(22, 'Construction', now(), -1, now(), -1);
  358. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(23, 'Pulse', now(), -1, now(), -1);
  359. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(24, 'Hub', now(), -1, now(), -1);
  360. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(25, 'Extender', now(), -1, now(), -1);
  361. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(26, 'Remote Extender', now(), -1, now(), -1);
  362. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(27, 'Tank Level Monitor', now(), -1, now(), -1);
  363. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(28, 'Meter', now(), -1, now(), -1);
  364. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(29, 'Roll Around', now(), -1, now(), -1);
  365. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(30, 'Reels', now(), -1, now(), -1);
  366. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(31, '3/8"', now(), -1, now(), -1);
  367. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(32, '1/2"', now(), -1, now(), -1);
  368. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(33, '3/4"', now(), -1, now(), -1);
  369. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(34, '1"', now(), -1, now(), -1);
  370. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(35, '1-1/4"', now(), -1, now(), -1);
  371. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(36, '1-1/2"', now(), -1, now(), -1);
  372. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(37, 'Pump', now(), -1, now(), -1);
  373. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(38, 'AC', now(), -1, now(), -1);
  374. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(39, 'Diaphragm', now(), -1, now(), -1);
  375. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(40, 'Gear', now(), -1, now(), -1);
  376. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(41, 'DC', now(), -1, now(), -1);
  377. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(42, 'Diaphragm', now(), -1, now(), -1);
  378. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(43, 'Gear', now(), -1, now(), -1);
  379. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(44, 'Pneumatic', now(), -1, now(), -1);
  380. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(45, 'Diaphragm', now(), -1, now(), -1);
  381. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(46, 'Piston', now(), -1, now(), -1);
  382. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(47, 'AC8', now(), -1, now(), -1);
  383. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(48, 'SCET', now(), -1, now(), -1);
  384. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(49, 'Meters', now(), -1, now(), -1);
  385. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(50, 'Digital', now(), -1, now(), -1);
  386. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(51, 'Mechanical', now(), -1, now(), -1);
  387. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(52, 'Tool', now(), -1, now(), -1);
  388. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(53, 'Conversion Kit', now(), -1, now(), -1);
  389. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(54, 'Purge Tool', now(), -1, now(), -1);
  390. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(55, 'Sample Tool', now(), -1, now(), -1);
  391. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(56, 'Activation Tool', now(), -1, now(), -1);
  392. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(57, 'Prelub', now(), -1, now(), -1);
  393. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(58, 'Kits', now(), -1, now(), -1);
  394. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(59, 'QuickEvac', now(), -1, now(), -1);
  395. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(60, 'QuickFit', now(), -1, now(), -1);
  396. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(61, 'MultiVac', now(), -1, now(), -1);
  397. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(62, 'MCES', now(), -1, now(), -1);
  398. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(63, 'SCET', now(), -1, now(), -1);
  399. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(64, 'Prelub', now(), -1, now(), -1);
  400. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(65, 'Electrical', now(), -1, now(), -1);
  401. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(66, 'Plumbing', now(), -1, now(), -1);
  402. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(67, 'Components', now(), -1, now(), -1);
  403. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(68, 'Electrical', now(), -1, now(), -1);
  404. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(69, 'Plumbing', now(), -1, now(), -1);
  405. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(70, 'Hardware', now(), -1, now(), -1);
  406. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(71, 'Brackets', now(), -1, now(), -1);
  407. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(73, 'Hose', now(), -1, now(), -1);
  408. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(74, 'Valve', now(), -1, now(), -1);
  409. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(75, 'Filter Adapter', now(), -1, now(), -1);
  410. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(76, 'Seal', now(), -1, now(), -1);
  411. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(77, 'Plate', now(), -1, now(), -1);
  412. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(78, 'Straight', now(), -1, now(), -1);
  413. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(79, 'Elbow', now(), -1, now(), -1);
  414. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(80, 'Tee', now(), -1, now(), -1);
  415. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(81, 'Cross', now(), -1, now(), -1);
  416. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(82, 'Cap', now(), -1, now(), -1);
  417. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(83, 'Plug', now(), -1, now(), -1);
  418. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(84, 'Banjo', now(), -1, now(), -1);
  419. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(85, 'Hose End', now(), -1, now(), -1);
  420. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(86, 'Bolt', now(), -1, now(), -1);
  421. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(87, 'Screw', now(), -1, now(), -1);
  422. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(88, 'Nut', now(), -1, now(), -1);
  423. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(89, 'Washer', now(), -1, now(), -1);
  424. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(90, 'Assembly', now(), -1, now(), -1);
  425. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(91, 'Socketless', now(), -1, now(), -1);
  426. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(92, 'Heavy Duty', now(), -1, now(), -1);
  427. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(93, 'Marine', now(), -1, now(), -1);
  428. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(216, 'Firesleeve', now(), -1, now(), -1);
  429. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(94, 'Check', now(), -1, now(), -1);
  430. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(95, 'Ball', now(), -1, now(), -1);
  431. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(96, 'Filter Ring', now(), -1, now(), -1);
  432. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(97, 'Nipple', now(), -1, now(), -1);
  433. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(98, 'O-Ring', now(), -1, now(), -1);
  434. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(99, 'Gasket', now(), -1, now(), -1);
  435. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(100, 'Dowty', now(), -1, now(), -1);
  436. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(101, 'Copper', now(), -1, now(), -1);
  437. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(102, 'Labor', now(), -1, now(), -1);
  438. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(103, 'Kit', now(), -1, now(), -1);
  439. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(104, 'Hose', now(), -1, now(), -1);
  440. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(105, 'Tooling', now(), -1, now(), -1);
  441. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(106, 'Installation', now(), -1, now(), -1);
  442. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(107, 'Training', now(), -1, now(), -1);
  443. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(108, 'Overhead', now(), -1, now(), -1);
  444. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(109, 'Kit', now(), -1, now(), -1);
  445. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(110, 'Hose', now(), -1, now(), -1);
  446. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(111, 'Tooling', now(), -1, now(), -1);
  447. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(112, 'Installation', now(), -1, now(), -1);
  448. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(113, 'Training', now(), -1, now(), -1);
  449. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(114, 'Warranty', now(), -1, now(), -1);
  450. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(115, 'Financial', now(), -1, now(), -1);
  451. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(116, 'Core', now(), -1, now(), -1);
  452. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(117, 'Motor', now(), -1, now(), -1);
  453. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(278, 'Motor', now(), -1, now(), -1);
  454. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(118, 'Remote', now(), -1, now(), -1);
  455. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(279, 'Switch', now(), -1, now(), -1);
  456. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(119, 'Switch', now(), -1, now(), -1);
  457. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(120, 'Motor', now(), -1, now(), -1);
  458. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(282, 'Motor', now(), -1, now(), -1);
  459. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(121, 'Remote', now(), -1, now(), -1);
  460. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(283, 'Switch', now(), -1, now(), -1);
  461. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(122, 'Switch', now(), -1, now(), -1);
  462. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(123, 'ConnexionMobile', now(), -1, now(), -1);
  463. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(124, 'Controls', now(), -1, now(), -1);
  464. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(125, 'Wiring', now(), -1, now(), -1);
  465. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(126, 'Wiring Harness', now(), -1, now(), -1);
  466. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(127, 'Switches', now(), -1, now(), -1);
  467. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(128, 'Relay', now(), -1, now(), -1);
  468. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(129, 'Timer', now(), -1, now(), -1);
  469. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(130, 'Switch/Timer', now(), -1, now(), -1);
  470. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(131, 'Circuit Board', now(), -1, now(), -1);
  471. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(132, 'Controller', now(), -1, now(), -1);
  472. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(133, 'Wire', now(), -1, now(), -1);
  473. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(134, 'Connector', now(), -1, now(), -1);
  474. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(135, 'Conduit', now(), -1, now(), -1);
  475. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(136, 'Fuse', now(), -1, now(), -1);
  476. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(137, 'Components', now(), -1, now(), -1);
  477. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(138, 'Heat Shrink', now(), -1, now(), -1);
  478. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(139, 'Main', now(), -1, now(), -1);
  479. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(140, 'Keyswitch', now(), -1, now(), -1);
  480. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(141, 'Sensor', now(), -1, now(), -1);
  481. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(142, 'Extension', now(), -1, now(), -1);
  482. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(143, 'Sensor', now(), -1, now(), -1);
  483. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(144, 'Deutsch', now(), -1, now(), -1);
  484. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(145, 'Sure Seal', now(), -1, now(), -1);
  485. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(146, 'Packard', now(), -1, now(), -1);
  486. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(147, 'Cinch', now(), -1, now(), -1);
  487. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(148, 'Molex', now(), -1, now(), -1);
  488. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(149, 'Ring Terminal', now(), -1, now(), -1);
  489. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(150, 'Quick Disconnect', now(), -1, now(), -1);
  490. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(251, 'Special Fitting', now(), -1, now(), -1);
  491. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(151, 'Pickup Tube', now(), -1, now(), -1);
  492. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(152, 'Controlled Document', now(), -1, now(), -1);
  493. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(153, 'Built', now(), -1, now(), -1);
  494. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(154, 'Unbuilt', now(), -1, now(), -1);
  495. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(155, 'Components', now(), -1, now(), -1);
  496. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(156, 'Armature', now(), -1, now(), -1);
  497. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(157, 'Bearing', now(), -1, now(), -1);
  498. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(158, 'Brush', now(), -1, now(), -1);
  499. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(159, 'Brush Holder', now(), -1, now(), -1);
  500. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(160, 'Brush Plate Assembly', now(), -1, now(), -1);
  501. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(161, 'Bushing', now(), -1, now(), -1);
  502. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(162, 'Cartridge', now(), -1, now(), -1);
  503. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(163, 'CE Plate', now(), -1, now(), -1);
  504. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(164, 'Crank Solenoid', now(), -1, now(), -1);
  505. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(165, 'Cup', now(), -1, now(), -1);
  506. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(166, 'Drive', now(), -1, now(), -1);
  507. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(167, 'Field', now(), -1, now(), -1);
  508. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(168, 'Field Housing', now(), -1, now(), -1);
  509. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(169, 'Frame', now(), -1, now(), -1);
  510. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(170, 'Frame & Field', now(), -1, now(), -1);
  511. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(171, 'Gear', now(), -1, now(), -1);
  512. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(172, 'Ground Strap', now(), -1, now(), -1);
  513. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(173, 'Ground Stud', now(), -1, now(), -1);
  514. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(174, 'Inspection Plug', now(), -1, now(), -1);
  515. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(175, 'Insulation', now(), -1, now(), -1);
  516. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(176, 'Insulator', now(), -1, now(), -1);
  517. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(177, 'Key', now(), -1, now(), -1);
  518. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(178, 'Lever', now(), -1, now(), -1);
  519. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(179, 'Lever Housing', now(), -1, now(), -1);
  520. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(180, 'Pump Lid', now(), -1, now(), -1);
  521. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(181, 'Motor Adapter Plate', now(), -1, now(), -1);
  522. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(182, 'Nose Housing', now(), -1, now(), -1);
  523. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(183, 'Pin', now(), -1, now(), -1);
  524. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(184, 'Pole Shoe', now(), -1, now(), -1);
  525. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(185, 'Pump', now(), -1, now(), -1);
  526. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(186, 'Pump Casting', now(), -1, now(), -1);
  527. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(187, 'Pump Lid Casting', now(), -1, now(), -1);
  528. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(188, 'Pump Lid Gasket', now(), -1, now(), -1);
  529. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(189, 'Shaft', now(), -1, now(), -1);
  530. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(190, 'Wick', now(), -1, now(), -1);
  531. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(191, 'Motor - AC', now(), -1, now(), -1);
  532. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(192, 'Motor - DC', now(), -1, now(), -1);
  533. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(193, 'OE', now(), -1, now(), -1);
  534. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(194, 'Reman', now(), -1, now(), -1);
  535. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(195, 'Remote', now(), -1, now(), -1);
  536. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(196, 'Starter', now(), -1, now(), -1);
  537. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(197, 'Remote', now(), -1, now(), -1);
  538. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(198, 'Starter', now(), -1, now(), -1);
  539. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(199, 'AC', now(), -1, now(), -1);
  540. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(200, 'DC', now(), -1, now(), -1);
  541. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(201, 'P1K', now(), -1, now(), -1);
  542. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(202, 'P2K', now(), -1, now(), -1);
  543. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(203, 'P3K', now(), -1, now(), -1);
  544. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(204, 'P3KHD', now(), -1, now(), -1);
  545. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(205, 'P4K10', now(), -1, now(), -1);
  546. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(206, 'P4K20', now(), -1, now(), -1);
  547. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(207, 'P4K40', now(), -1, now(), -1);
  548. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(208, 'P4L20', now(), -1, now(), -1);
  549. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(209, 'P4L40', now(), -1, now(), -1);
  550. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(210, 'HVP', now(), -1, now(), -1);
  551. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(211, '40RM', now(), -1, now(), -1);
  552. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(212, '41RM', now(), -1, now(), -1);
  553. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(213, 'DC', now(), -1, now(), -1);
  554. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(214, '42MT', now(), -1, now(), -1);
  555. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(215, '50MT', now(), -1, now(), -1);
  556. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(217, 'Mag Switch', now(), -1, now(), -1);
  557. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(218, 'Pressure Switch', now(), -1, now(), -1);
  558. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(219, 'Grommet', now(), -1, now(), -1);
  559. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(220, 'Pneumatics', now(), -1, now(), -1);
  560. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(221, 'Compressor', now(), -1, now(), -1);
  561. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(222, 'Compressor Accessory', now(), -1, now(), -1);
  562. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(223, 'Clamp', now(), -1, now(), -1);
  563. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(224, 'New Take Off', now(), -1, now(), -1);
  564. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(225, 'Tag', now(), -1, now(), -1);
  565. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(226, 'Remote Bracket', now(), -1, now(), -1);
  566. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(227, 'Snap Ring', now(), -1, now(), -1);
  567. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(228, 'Spacer', now(), -1, now(), -1);
  568. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(229, 'Rivet', now(), -1, now(), -1);
  569. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(230, 'Spring', now(), -1, now(), -1);
  570. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(231, 'Marking', now(), -1, now(), -1);
  571. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(232, 'Manifold', now(), -1, now(), -1);
  572. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(233, 'Components', now(), -1, now(), -1);
  573. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(234, 'Containment', now(), -1, now(), -1);
  574. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(235, 'Tank', now(), -1, now(), -1);
  575. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(236, 'Filter Box', now(), -1, now(), -1);
  576. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(237, 'Reel Box', now(), -1, now(), -1);
  577. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(238, 'Spill Box', now(), -1, now(), -1);
  578. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(239, 'Battery Box', now(), -1, now(), -1);
  579. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(240, 'Sticker', now(), -1, now(), -1);
  580. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(241, '12V', now(), -1, now(), -1);
  581. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(242, '24V', now(), -1, now(), -1);
  582. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(243, 'Components', now(), -1, now(), -1);
  583. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(244, 'Can', now(), -1, now(), -1);
  584. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(245, 'Coil', now(), -1, now(), -1);
  585. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(246, 'Contact', now(), -1, now(), -1);
  586. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(247, 'Contact Disk', now(), -1, now(), -1);
  587. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(248, 'Plunger', now(), -1, now(), -1);
  588. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(249, 'Cable Tie', now(), -1, now(), -1);
  589. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(250, 'Enclosure', now(), -1, now(), -1);
  590. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(252, 'Stud', now(), -1, now(), -1);
  591. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(253, 'Packaging', now(), -1, now(), -1);
  592. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(254, 'Box', now(), -1, now(), -1);
  593. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(255, 'Cart', now(), -1, now(), -1);
  594. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(256, 'Skid', now(), -1, now(), -1);
  595. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(257, 'Trailer', now(), -1, now(), -1);
  596. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(258, 'Cart', now(), -1, now(), -1);
  597. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(259, 'Skid', now(), -1, now(), -1);
  598. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(260, 'Trailer', now(), -1, now(), -1);
  599. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(261, 'Warranty Credit', now(), -1, now(), -1);
  600. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(262, 'Error', now(), -1, now(), -1);
  601. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(263, 'R&D', now(), -1, now(), -1);
  602. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(264, 'Adjustments', now(), -1, now(), -1);
  603. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(265, 'Plant', now(), -1, now(), -1);
  604. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(266, 'BOM', now(), -1, now(), -1);
  605. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(267, 'Admin', now(), -1, now(), -1);
  606. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(268, 'Install', now(), -1, now(), -1);
  607. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(269, 'Product Testing', now(), -1, now(), -1);
  608. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(270, 'Field Test', now(), -1, now(), -1);
  609. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(271, 'R&D - For Sale', now(), -1, now(), -1);
  610. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(272, 'R&D - Not For Sale', now(), -1, now(), -1);
  611. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(273, 'Experimental #s', now(), -1, now(), -1);
  612. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(274, 'Pricing Adjust', now(), -1, now(), -1);
  613. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(275, 'No Charge Cr', now(), -1, now(), -1);
  614. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(276, 'Core Credit', now(), -1, now(), -1);
  615. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(277, 'Core Charge', now(), -1, now(), -1);
  616. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(280, 'Starter', now(), -1, now(), -1);
  617. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(281, 'Remote', now(), -1, now(), -1);
  618. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(284, 'Starter', now(), -1, now(), -1);
  619. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(285, 'Remote', now(), -1, now(), -1);
  620. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(286, 'Miscellany ', now(), -1, now(), -1);
  621. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(287, 'Component', now(), -1, now(), -1);
  622. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(288, 'Obsolete item', now(), -1, now(), -1);
  623. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(289, 'Mic Sales/Serv', now(), -1, now(), -1);
  624. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(290, 'Misc Ret/Allow', now(), -1, now(), -1);
  625. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(291, 'Show', now(), -1, now(), -1);
  626. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(292, 'Non Stock Item', now(), -1, now(), -1);
  627. Insert Into "Location"(id, name, "createDate", "createUserId", "updateDate", "updateUserId") Values(293, 'Equipment Lease Program', now(), -1, now(), -1);