API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 6th, 2020
190
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 13.07 KB | None | 0 0
raw download clone embed print report
  1.     TRUNCATE IMP16_EN_NOMK_VERSIONS;
  2.     TRUNCATE IMP16_EN_PREP_VERSIONS;
  3.     TRUNCATE IMP16_ROZN_S_ED;
  4.     TRUNCATE IMP16_ROZN_S_FIRMS;
  5.     TRUNCATE IMP16_ROZN_S_GROUP;
  6.     TRUNCATE IMP16_ROZN_S_LF;
  7.     TRUNCATE IMP16_ROZN_S_LFACT;
  8.     TRUNCATE IMP16_ROZN_S_LFCHR;
  9.     TRUNCATE IMP16_ROZN_S_LFCONC;
  10.     TRUNCATE IMP16_ROZN_S_LFMASS;
  11.     TRUNCATE IMP16_ROZN_S_LFSIZE;
  12.     TRUNCATE IMP16_ROZN_S_MNN;
  13.     TRUNCATE IMP16_ROZN_S_PREP_GROUP;
  14.     TRUNCATE IMP16_ROZN_S_P_USE;
  15.     TRUNCATE IMP16_ROZN_S_SET;
  16.     TRUNCATE IMP16_ROZN_S_TN;
  17.     TRUNCATE IMP16_ROZN_S_VOL;
  18.  
  19.  
  20. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688885, 'IMP16_ROZN_S_PREP_GROUP', 'Отношение товара к группе товаров', '<STRUCTURE>
  21. <ROOT>ROZN_S_PREP_GROUP</ROOT>
  22. <CHARSET>WE8MSUTF8</CHARSET>
  23. <FIELDS>
  24. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  25. <FIELD SOURCE="prep_id" TARGET_TYPE="NUMBER"></FIELD>
  26. <FIELD SOURCE="rozn_s_group_id" TARGET_TYPE="NUMBER"></FIELD>
  27. <FIELD SOURCE="date_b"></FIELD>
  28. <FIELD SOURCE="date_e"></FIELD>
  29. </FIELDS>
  30. </STRUCTURE>', 'ROZN_S_PREP_GROUP.xml', 'IMP16_ROZN_S_PREP_GROUP', 1, NULL, 1, 16377126, NULL, NULL, '');
  31. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688886, 'IMP16_ROZN_S_TN', 'Торговое наименование', '<STRUCTURE>
  32. <ROOT>ROZN_S_TN</ROOT>
  33. <CHARSET>WE8MSUTF8</CHARSET>
  34. <FIELDS>
  35. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  36. <FIELD SOURCE="name"></FIELD>
  37. <FIELD SOURCE="engname"></FIELD>
  38. <FIELD SOURCE="rusname"></FIELD>
  39. <FIELD SOURCE="latin_name"></FIELD>
  40. <FIELD SOURCE="date_b"></FIELD>
  41. <FIELD SOURCE="date_e"></FIELD>
  42. </FIELDS>
  43. </STRUCTURE>', 'ROZN_S_TN.xml', 'IMP16_ROZN_S_TN', 1, NULL, 1, 16377126, NULL, NULL, '');
  44. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688887, 'IMP16_ROZN_S_MNN', 'МНН', '<STRUCTURE>
  45. <ROOT>ROZN_S_MNN</ROOT>
  46. <CHARSET>WE8MSUTF8</CHARSET>
  47. <FIELDS>
  48. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  49. <FIELD SOURCE="pr" TARGET_TYPE="NUMBER"></FIELD>
  50. <FIELD SOURCE="mnn"></FIELD>
  51. <FIELD SOURCE="latin_name"></FIELD>
  52. <FIELD SOURCE="date_b"></FIELD>
  53. <FIELD SOURCE="date_e"></FIELD>
  54. </FIELDS>
  55. </STRUCTURE>', 'ROZN_S_MNN.xml', 'IMP16_ROZN_S_MNN', 1, NULL, 1, 16377126, NULL, NULL, '');
  56. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688888, 'IMP16_ROZN_S_LF', 'Форма выпуска', '<STRUCTURE>
  57. <ROOT>ROZN_S_LF</ROOT>
  58. <CHARSET>WE8MSUTF8</CHARSET>
  59. <FIELDS>
  60. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  61. <FIELD SOURCE="name"></FIELD>
  62. <FIELD SOURCE="fullname"></FIELD>
  63. <FIELD SOURCE="date_b"></FIELD>
  64. <FIELD SOURCE="date_e"></FIELD>
  65. </FIELDS>
  66. </STRUCTURE>', 'ROZN_S_LF.xml', 'IMP16_ROZN_S_LF', 1, NULL, 1, 16377126, NULL, NULL, '');
  67. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688889, 'IMP16_EN_PREP_VERSIONS', 'История изменений товаров', '<STRUCTURE>
  68. <ROOT>PREP_VERSIONS</ROOT>
  69. <CHARSET>WE8MSUTF8</CHARSET>
  70. <FIELDS>
  71. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  72. <FIELD SOURCE="prep_id" TARGET_TYPE="NUMBER"></FIELD>
  73. <FIELD SOURCE="eancode"></FIELD>
  74. <FIELD SOURCE="priceinrub" TARGET_TYPE="NUMBER"></FIELD>
  75. <FIELD SOURCE="pfirmid" TARGET_TYPE="NUMBER"></FIELD>
  76. <FIELD SOURCE="rfirmid" TARGET_TYPE="NUMBER"></FIELD>
  77. <FIELD SOURCE="nfirmid" TARGET_TYPE="NUMBER"></FIELD>
  78. <FIELD SOURCE="p_name"></FIELD>
  79. <FIELD SOURCE="prcena_proizv" TARGET_TYPE="NUMBER"></FIELD>
  80. <FIELD SOURCE="prcena_opt" TARGET_TYPE="NUMBER"></FIELD>
  81. <FIELD SOURCE="artikul"></FIELD>
  82. <FIELD SOURCE="kratnost_up" TARGET_TYPE="NUMBER"></FIELD>
  83. <FIELD SOURCE="har_id" TARGET_TYPE="NUMBER"></FIELD>
  84. <FIELD SOURCE="ed_id" TARGET_TYPE="NUMBER"></FIELD>
  85. <FIELD SOURCE="nomk_id" TARGET_TYPE="NUMBER"></FIELD>
  86. <FIELD SOURCE="p_use" TARGET_TYPE="NUMBER"></FIELD>
  87. <FIELD SOURCE="vgr_kod" TARGET_TYPE="NUMBER"></FIELD>
  88. <FIELD SOURCE="date_b"></FIELD>
  89. <FIELD SOURCE="date_e"></FIELD>
  90. <FIELD SOURCE="last" TARGET_TYPE="NUMBER"></FIELD>
  91. </FIELDS>
  92. </STRUCTURE>', 'EN_PREP_VERSIONS.xml', 'IMP16_EN_PREP_VERSIONS', 1, NULL, 1, 16377126, NULL, NULL, '');
  93. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688890, 'IMP16_ROZN_S_P_USE', 'Вид', '<STRUCTURE>
  94. <ROOT>ROZN_S_P_USE</ROOT>
  95. <CHARSET>WE8MSUTF8</CHARSET>
  96. <FIELDS>
  97. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  98. <FIELD SOURCE="p_use_name"></FIELD>
  99. </FIELDS>
  100. </STRUCTURE>', 'ROZN_S_P_USE.xml', 'IMP16_ROZN_S_P_USE', 1, NULL, 1, 16377126, NULL, NULL, '');
  101. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688891, 'IMP16_EN_NOMK_VERSIONS', 'История изменений номенклатур', '<STRUCTURE>
  102. <ROOT>NOMK_VERSIONS</ROOT>
  103. <CHARSET>WE8MSUTF8</CHARSET>
  104. <FIELDS>
  105. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  106. <FIELD SOURCE="nomk_id" TARGET_TYPE="NUMBER"></FIELD>
  107. <FIELD SOURCE="tradenameid" TARGET_TYPE="NUMBER"></FIELD>
  108. <FIELD SOURCE="id_mnn" TARGET_TYPE="NUMBER"></FIELD>
  109. <FIELD SOURCE="lfid" TARGET_TYPE="NUMBER"></FIELD>
  110. <FIELD SOURCE="lfmass" TARGET_TYPE="NUMBER"></FIELD>
  111. <FIELD SOURCE="lfmassid" TARGET_TYPE="NUMBER"></FIELD>
  112. <FIELD SOURCE="dospk" TARGET_TYPE="NUMBER"></FIELD>
  113. <FIELD SOURCE="ppkvol" TARGET_TYPE="NUMBER"></FIELD>
  114. <FIELD SOURCE="ppkvolid" TARGET_TYPE="NUMBER"></FIELD>
  115. <FIELD SOURCE="ppkmass" TARGET_TYPE="NUMBER"></FIELD>
  116. <FIELD SOURCE="ppkmassid" TARGET_TYPE="NUMBER"></FIELD>
  117. <FIELD SOURCE="pnom" TARGET_TYPE="NUMBER"></FIELD>
  118. <FIELD SOURCE="setid" TARGET_TYPE="NUMBER"></FIELD>
  119. <FIELD SOURCE="lfconc" TARGET_TYPE="NUMBER"></FIELD>
  120. <FIELD SOURCE="lfconcid" TARGET_TYPE="NUMBER"></FIELD>
  121. <FIELD SOURCE="lfact" TARGET_TYPE="NUMBER"></FIELD>
  122. <FIELD SOURCE="lfactid" TARGET_TYPE="NUMBER"></FIELD>
  123. <FIELD SOURCE="lfsize"></FIELD>
  124. <FIELD SOURCE="lfsizeid" TARGET_TYPE="NUMBER"></FIELD>
  125. <FIELD SOURCE="lfchrid" TARGET_TYPE="NUMBER"></FIELD>
  126. <FIELD SOURCE="p_name_s"></FIELD>
  127. <FIELD SOURCE="vgr_kod" TARGET_TYPE="NUMBER"></FIELD>
  128. <FIELD SOURCE="date_b"></FIELD>
  129. <FIELD SOURCE="date_e"></FIELD>
  130. <FIELD SOURCE="last" TARGET_TYPE="NUMBER"></FIELD>
  131. </FIELDS>
  132. </STRUCTURE>', 'EN_NOMK_VERSIONS.xml', 'IMP16_EN_NOMK_VERSIONS', 1, NULL, 1, 16377126, NULL, NULL, '');
  133. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688892, 'IMP16_ROZN_S_LFACT', 'Единицы действующего вещества', '<STRUCTURE>
  134. <ROOT>ROZN_S_LFACT</ROOT>
  135. <CHARSET>WE8MSUTF8</CHARSET>
  136. <FIELDS>
  137. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  138. <FIELD SOURCE="shortname"></FIELD>
  139. <FIELD SOURCE="fullname"></FIELD>
  140. <FIELD SOURCE="date_b"></FIELD>
  141. <FIELD SOURCE="date_e"></FIELD>
  142. </FIELDS>
  143. </STRUCTURE>', 'ROZN_S_LFACT.xml', 'IMP16_ROZN_S_LFACT', 1, NULL, 1, 16377126, NULL, NULL, '');
  144. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688893, 'IMP16_ROZN_S_LFCHR', 'Единицы измерения характеристики лек. формы', '<STRUCTURE>
  145. <ROOT>ROZN_S_LFCHR</ROOT>
  146. <CHARSET>WE8MSUTF8</CHARSET>
  147. <FIELDS>
  148. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  149. <FIELD SOURCE="shortname"></FIELD>
  150. <FIELD SOURCE="fullname"></FIELD>
  151. <FIELD SOURCE="date_b"></FIELD>
  152. <FIELD SOURCE="date_e"></FIELD>
  153. </FIELDS>
  154. </STRUCTURE>', 'ROZN_S_LFCHR.xml', 'IMP16_ROZN_S_LFCHR', 1, NULL, 1, 16377126, NULL, NULL, '');
  155. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688894, 'IMP16_ROZN_S_LFSIZE', 'Размер формы выпуска', '<STRUCTURE>
  156. <ROOT>ROZN_S_LFSIZE</ROOT>
  157. <CHARSET>WE8MSUTF8</CHARSET>
  158. <FIELDS>
  159. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  160. <FIELD SOURCE="shortname"></FIELD>
  161. <FIELD SOURCE="fullname"></FIELD>
  162. <FIELD SOURCE="date_b"></FIELD>
  163. <FIELD SOURCE="date_e"></FIELD>
  164. </FIELDS>
  165. </STRUCTURE>', 'ROZN_S_LFSIZE.xml', 'IMP16_ROZN_S_LFSIZE', 1, NULL, 1, 16377126, NULL, NULL, '');
  166. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688895, 'IMP16_ROZN_S_FIRMS', 'Производители', '<STRUCTURE>
  167. <ROOT>ROZN_S_FIRMS</ROOT>
  168. <CHARSET>WE8MSUTF8</CHARSET>
  169. <FIELDS>
  170. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  171. <FIELD SOURCE="name"></FIELD>
  172. <FIELD SOURCE="fullname"></FIELD>
  173. <FIELD SOURCE="cntrid"></FIELD>
  174. <FIELD SOURCE="date_b"></FIELD>
  175. <FIELD SOURCE="date_e"></FIELD>
  176. </FIELDS>
  177. </STRUCTURE>', 'ROZN_S_FIRMS.xml', 'IMP16_ROZN_S_FIRMS', 1, NULL, 1, 16377126, NULL, NULL, '');
  178. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688896, 'IMP16_ROZN_S_VOL', 'Единицы измерения объема', '<STRUCTURE>
  179. <ROOT>ROZN_S_VOL</ROOT>
  180. <CHARSET>WE8MSUTF8</CHARSET>
  181. <FIELDS>
  182. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  183. <FIELD SOURCE="name"></FIELD>
  184. <FIELD SOURCE="shortname"></FIELD>
  185. <FIELD SOURCE="date_b"></FIELD>
  186. <FIELD SOURCE="date_e"></FIELD>
  187. </FIELDS>
  188. </STRUCTURE>', 'ROZN_S_VOL.xml', 'IMP16_ROZN_S_VOL', 1, NULL, 1, 16377126, NULL, NULL, '');
  189. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688897, 'IMP16_ROZN_S_GROUP', 'Группа товаров', '<STRUCTURE>
  190. <ROOT>ROZN_S_GROUP</ROOT>
  191. <CHARSET>WE8MSUTF8</CHARSET>
  192. <FIELDS>
  193. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  194. <FIELD SOURCE="name"></FIELD>
  195. </FIELDS>
  196. </STRUCTURE>', 'ROZN_S_GROUP.xml', 'IMP16_ROZN_S_GROUP', 1, NULL, 1, 16377126, NULL, NULL, '');
  197. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688898, 'IMP16_ROZN_S_LFCONC', 'Единицы измерения концентрации', '<STRUCTURE>
  198. <ROOT>ROZN_S_LFCONC</ROOT>
  199. <CHARSET>WE8MSUTF8</CHARSET>
  200. <FIELDS>
  201. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  202. <FIELD SOURCE="shortname"></FIELD>
  203. <FIELD SOURCE="fullname"></FIELD>
  204. <FIELD SOURCE="date_b"></FIELD>
  205. <FIELD SOURCE="date_e"></FIELD>
  206. </FIELDS>
  207. </STRUCTURE>', 'ROZN_S_LFCONC.xml', 'IMP16_ROZN_S_LFCONC', 1, NULL, 1, 16377126, NULL, NULL, '');
  208. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688899, 'IMP16_ROZN_S_LFMASS', 'Масса формы выпуска', '<STRUCTURE>
  209. <ROOT>ROZN_S_LFMASS</ROOT>
  210. <CHARSET>WE8MSUTF8</CHARSET>
  211. <FIELDS>
  212. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  213. <FIELD SOURCE="shortname"></FIELD>
  214. <FIELD SOURCE="fullname"></FIELD>
  215. <FIELD SOURCE="date_b"></FIELD>
  216. <FIELD SOURCE="date_e"></FIELD>
  217. </FIELDS>
  218. </STRUCTURE>', 'ROZN_S_LFMASS.xml', 'IMP16_ROZN_S_LFMASS', 1, NULL, 1, 16377126, NULL, NULL, '');
  219. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688900, 'IMP16_ROZN_S_SET', 'Комплектность', '<STRUCTURE>
  220. <ROOT>ROZN_S_SET</ROOT>
  221. <CHARSET>WE8MSUTF8</CHARSET>
  222. <FIELDS>
  223. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  224. <FIELD SOURCE="fullname"></FIELD>
  225. <FIELD SOURCE="shortname"></FIELD>
  226. <FIELD SOURCE="date_b"></FIELD>
  227. <FIELD SOURCE="date_e"></FIELD>
  228. </FIELDS>
  229. </STRUCTURE>', 'ROZN_S_SET.xml', 'IMP16_ROZN_S_SET', 1, NULL, 1, 16377126, NULL, NULL, '');
  230. INSERT INTO public.d_imp_tables (id, it_code, it_name, note, source_table, target_table, table_type, dbf_dos_win_code, set_synonym_grant, cid, last_imp_date, last_info_date, sqlblock) VALUES (30688901, 'IMP16_ROZN_S_ED', 'Единицы измерения', '<STRUCTURE>
  231. <ROOT>ROZN_S_ED</ROOT>
  232. <CHARSET>WE8MSUTF8</CHARSET>
  233. <FIELDS>
  234. <FIELD SOURCE="id" TARGET_TYPE="NUMBER"></FIELD>
  235. <FIELD SOURCE="shortname"></FIELD>
  236. <FIELD SOURCE="fullname"></FIELD>
  237. </FIELDS>
  238. </STRUCTURE>', 'ROZN_S_ED.xml', 'IMP16_ROZN_S_ED', 1, NULL, 1, 16377126, NULL, NULL, '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!