Advertisement
Guest User

Untitled

a guest
Mar 25th, 2018
1,555
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 225.86 KB | None | 0 0
  1. # -------------------------------------------------------
  2. # # used 'header validation mode' during script generation was: import_strict
  3. "#% impex.setLocale( new Locale( ""en"" , """" ) );"
  4. # -------------------------------------------------------
  5.  
  6. # ---- Extension: core ---- Type: Link ----
  7. "#% impex.setTargetFile( ""Link.csv"" );"
  8. insert_update Link;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(pk)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  9. "#% impex.exportItems( ""Link"" , false );"
  10.  
  11. # ---- Extension: core ---- Type: ProductMediaLink ----
  12. "#% impex.setTargetFile( ""ProductMediaLink.csv"" );"
  13. insert_update ProductMediaLink;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  14. "#% impex.exportItems( ""ProductMediaLink"" , false );"
  15.  
  16. # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2CurrencyRelation ----
  17. "#% impex.setTargetFile( ""SolrFacetSearchConfig2CurrencyRelation.csv"" );"
  18. insert_update SolrFacetSearchConfig2CurrencyRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(name)[unique=true,allownull=true];target(isocode)[unique=true,allownull=true]
  19. "#% impex.exportItems( ""SolrFacetSearchConfig2CurrencyRelation"" , false );"
  20.  
  21. # ---- Extension: commerceservices ---- Type: BaseStore2CountryRel ----
  22. "#% impex.setTargetFile( ""BaseStore2CountryRel.csv"" );"
  23. insert_update BaseStore2CountryRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(isocode)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  24. "#% impex.exportItems( ""BaseStore2CountryRel"" , false );"
  25.  
  26. # ---- Extension: commerceservices ---- Type: BaseStore2WarehouseRel ----
  27. "#% impex.setTargetFile( ""BaseStore2WarehouseRel.csv"" );"
  28. insert_update BaseStore2WarehouseRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  29. "#% impex.exportItems( ""BaseStore2WarehouseRel"" , false );"
  30.  
  31. # ---- Extension: comments ---- Type: ComponentWritePrincipalRelation ----
  32. "#% impex.setTargetFile( ""ComponentWritePrincipalRelation.csv"" );"
  33. insert_update ComponentWritePrincipalRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,domain(code))[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  34. "#% impex.exportItems( ""ComponentWritePrincipalRelation"" , false );"
  35.  
  36. # ---- Extension: workflow ---- Type: WorkflowActionItemAttachmentRelation ----
  37. "#% impex.setTargetFile( ""WorkflowActionItemAttachmentRelation.csv"" );"
  38. insert_update WorkflowActionItemAttachmentRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  39. "#% impex.exportItems( ""WorkflowActionItemAttachmentRelation"" , false );"
  40.  
  41. # ---- Extension: commerceservices ---- Type: StoreLocation2StoreLocatorFeature ----
  42. "#% impex.setTargetFile( ""StoreLocation2StoreLocatorFeature.csv"" );"
  43. insert_update StoreLocation2StoreLocatorFeature;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(name)[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  44. "#% impex.exportItems( ""StoreLocation2StoreLocatorFeature"" , false );"
  45.  
  46. # ---- Extension: comments ---- Type: ComponentReadPrincipalRelation ----
  47. "#% impex.setTargetFile( ""ComponentReadPrincipalRelation.csv"" );"
  48. insert_update ComponentReadPrincipalRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,domain(code))[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  49. "#% impex.exportItems( ""ComponentReadPrincipalRelation"" , false );"
  50.  
  51. # ---- Extension: catalog ---- Type: SyncJob2LangRel ----
  52. "#% impex.setTargetFile( ""SyncJob2LangRel.csv"" );"
  53. insert_update SyncJob2LangRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[unique=true,allownull=true];target(isocode)[unique=true,allownull=true]
  54. "#% impex.exportItems( ""SyncJob2LangRel"" , false );"
  55.  
  56. # ---- Extension: commerceservices ---- Type: BaseStore2CurrencyRel ----
  57. "#% impex.setTargetFile( ""BaseStore2CurrencyRel.csv"" );"
  58. insert_update BaseStore2CurrencyRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(isocode)[unique=true,allownull=true]
  59. "#% impex.exportItems( ""BaseStore2CurrencyRel"" , false );"
  60.  
  61. # ---- Extension: validation ---- Type: ConstraintGroup2AbstractConstraintRelation ----
  62. "#% impex.setTargetFile( ""ConstraintGroup2AbstractConstraintRelation.csv"" );"
  63. insert_update ConstraintGroup2AbstractConstraintRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(id)[unique=true,allownull=true];target(interfaceName)[unique=true,allownull=true]
  64. "#% impex.exportItems( ""ConstraintGroup2AbstractConstraintRelation"" , false );"
  65.  
  66. # ---- Extension: catalog ---- Type: SyncJob2TypeRel ----
  67. "#% impex.setTargetFile( ""SyncJob2TypeRel.csv"" );"
  68. insert_update SyncJob2TypeRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  69. "#% impex.exportItems( ""SyncJob2TypeRel"" , false );"
  70.  
  71. # ---- Extension: processing ---- Type: CronJobPendingStepsRelation ----
  72. "#% impex.setTargetFile( ""CronJobPendingStepsRelation.csv"" );"
  73. insert_update CronJobPendingStepsRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(code,sequenceNumber)[unique=true,allownull=true]
  74. "#% impex.exportItems( ""CronJobPendingStepsRelation"" , false );"
  75.  
  76. # ---- Extension: solrfacetsearch ---- Type: SolrIndexedProperty2SolrValueRangeSetRelation ----
  77. "#% impex.setTargetFile( ""SolrIndexedProperty2SolrValueRangeSetRelation.csv"" );"
  78. insert_update SolrIndexedProperty2SolrValueRangeSetRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(pk)[unique=true,allownull=true];target(name)[unique=true,allownull=true]
  79. "#% impex.exportItems( ""SolrIndexedProperty2SolrValueRangeSetRelation"" , false );"
  80.  
  81. # ---- Extension: basecommerce ---- Type: StoresForCMSSite ----
  82. "#% impex.setTargetFile( ""StoresForCMSSite.csv"" );"
  83. insert_update StoresForCMSSite;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  84. "#% impex.exportItems( ""StoresForCMSSite"" , false );"
  85.  
  86. # ---- Extension: promotions ---- Type: ProductPromotionRelation ----
  87. "#% impex.setTargetFile( ""ProductPromotionRelation.csv"" );"
  88. insert_update ProductPromotionRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  89. "#% impex.exportItems( ""ProductPromotionRelation"" , false );"
  90.  
  91. # ---- Extension: catalog ---- Type: Principal2ReadableCatalogVersionRelation ----
  92. "#% impex.setTargetFile( ""Principal2ReadableCatalogVersionRelation.csv"" );"
  93. insert_update Principal2ReadableCatalogVersionRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(catalog(id),version)[unique=true,allownull=true]
  94. "#% impex.exportItems( ""Principal2ReadableCatalogVersionRelation"" , false );"
  95.  
  96. # ---- Extension: comments ---- Type: CommentItemRelation ----
  97. "#% impex.setTargetFile( ""CommentItemRelation.csv"" );"
  98. insert_update CommentItemRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  99. "#% impex.exportItems( ""CommentItemRelation"" , false );"
  100.  
  101. # ---- Extension: commerceservices ---- Type: QuoteToNotificationRel ----
  102. "#% impex.setTargetFile( ""QuoteToNotificationRel.csv"" );"
  103. insert_update QuoteToNotificationRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,version)[unique=true,allownull=true];target(code,itemtype(code))[unique=true,allownull=true]
  104. "#% impex.exportItems( ""QuoteToNotificationRel"" , false );"
  105.  
  106. # ---- Extension: workflow ---- Type: WorkflowActionOrderingRelation ----
  107. "#% impex.setTargetFile( ""WorkflowActionOrderingRelation.csv"" );"
  108. insert_update WorkflowActionOrderingRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  109. "#% impex.exportItems( ""WorkflowActionOrderingRelation"" , false );"
  110.  
  111. # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2LanguageRelation ----
  112. "#% impex.setTargetFile( ""SolrFacetSearchConfig2LanguageRelation.csv"" );"
  113. insert_update SolrFacetSearchConfig2LanguageRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(name)[unique=true,allownull=true];target(isocode)[unique=true,allownull=true]
  114. "#% impex.exportItems( ""SolrFacetSearchConfig2LanguageRelation"" , false );"
  115.  
  116. # ---- Extension: catalog ---- Type: Principal2WriteableCatalogVersionRelation ----
  117. "#% impex.setTargetFile( ""Principal2WriteableCatalogVersionRelation.csv"" );"
  118. insert_update Principal2WriteableCatalogVersionRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(catalog(id),version)[unique=true,allownull=true]
  119. "#% impex.exportItems( ""Principal2WriteableCatalogVersionRelation"" , false );"
  120.  
  121. # ---- Extension: basecommerce ---- Type: HistoryDocumentRelation ----
  122. "#% impex.setTargetFile( ""HistoryDocumentRelation.csv"" );"
  123. insert_update HistoryDocumentRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(pk)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  124. "#% impex.exportItems( ""HistoryDocumentRelation"" , false );"
  125.  
  126. # ---- Extension: catalog ---- Type: CategoryMediaRelation ----
  127. "#% impex.setTargetFile( ""CategoryMediaRelation.csv"" );"
  128. insert_update CategoryMediaRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  129. "#% impex.exportItems( ""CategoryMediaRelation"" , false );"
  130.  
  131. # ---- Extension: catalog ---- Type: Category2PrincipalRelation ----
  132. "#% impex.setTargetFile( ""Category2PrincipalRelation.csv"" );"
  133. insert_update Category2PrincipalRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  134. "#% impex.exportItems( ""Category2PrincipalRelation"" , false );"
  135.  
  136. # ---- Extension: processing ---- Type: CronJobProcessedStepsRelation ----
  137. "#% impex.setTargetFile( ""CronJobProcessedStepsRelation.csv"" );"
  138. insert_update CronJobProcessedStepsRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(code,sequenceNumber)[unique=true,allownull=true]
  139. "#% impex.exportItems( ""CronJobProcessedStepsRelation"" , false );"
  140.  
  141. # ---- Extension: basecommerce ---- Type: ProductDeliveryModeRelation ----
  142. "#% impex.setTargetFile( ""ProductDeliveryModeRelation.csv"" );"
  143. insert_update ProductDeliveryModeRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  144. "#% impex.exportItems( ""ProductDeliveryModeRelation"" , false );"
  145.  
  146. # ---- Extension: catalog ---- Type: SyncItemJob2Principal ----
  147. "#% impex.setTargetFile( ""SyncItemJob2Principal.csv"" );"
  148. insert_update SyncItemJob2Principal;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  149. "#% impex.exportItems( ""SyncItemJob2Principal"" , false );"
  150.  
  151. # ---- Extension: workflow ---- Type: WorkflowActionLinkRelation ----
  152. "#% impex.setTargetFile( ""WorkflowActionLinkRelation.csv"" );"
  153. insert_update WorkflowActionLinkRelation;pk;active;andConnection[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(code)[unique=true,allownull=true];template(language(isocode),source(code),target(code))[allownull=true,forceWrite=true]
  154. "#% impex.exportItems( ""WorkflowActionLinkRelation"" , false );"
  155.  
  156. # ---- Extension: basecommerce ---- Type: CatalogsForBaseStores ----
  157. "#% impex.setTargetFile( ""CatalogsForBaseStores.csv"" );"
  158. insert_update CatalogsForBaseStores;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(id)[unique=true,allownull=true]
  159. "#% impex.exportItems( ""CatalogsForBaseStores"" , false );"
  160.  
  161. # ---- Extension: comments ---- Type: CommentWatcherRelation ----
  162. "#% impex.setTargetFile( ""CommentWatcherRelation.csv"" );"
  163. insert_update CommentWatcherRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  164. "#% impex.exportItems( ""CommentWatcherRelation"" , false );"
  165.  
  166. # ---- Extension: commons ---- Type: Format2ComTypRel ----
  167. "#% impex.setTargetFile( ""Format2ComTypRel.csv"" );"
  168. insert_update Format2ComTypRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  169. "#% impex.exportItems( ""Format2ComTypRel"" , false );"
  170.  
  171. # ---- Extension: platformbackoffice ---- Type: BackofficeSavedQuery2UserGroupRelation ----
  172. "#% impex.setTargetFile( ""BackofficeSavedQuery2UserGroupRelation.csv"" );"
  173. insert_update BackofficeSavedQuery2UserGroupRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(pk)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  174. "#% impex.exportItems( ""BackofficeSavedQuery2UserGroupRelation"" , false );"
  175.  
  176. # ---- Extension: comments ---- Type: ComponentRemovePrincipalRelation ----
  177. "#% impex.setTargetFile( ""ComponentRemovePrincipalRelation.csv"" );"
  178. insert_update ComponentRemovePrincipalRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,domain(code))[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  179. "#% impex.exportItems( ""ComponentRemovePrincipalRelation"" , false );"
  180.  
  181. # ---- Extension: commerceservices ---- Type: BaseStore2DeliveryModeRel ----
  182. "#% impex.setTargetFile( ""BaseStore2DeliveryModeRel.csv"" );"
  183. insert_update BaseStore2DeliveryModeRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  184. "#% impex.exportItems( ""BaseStore2DeliveryModeRel"" , false );"
  185.  
  186. # ---- Extension: validation ---- Type: ComposedType2CoverageConstraintGroupRelation ----
  187. "#% impex.setTargetFile( ""ComposedType2CoverageConstraintGroupRelation.csv"" );"
  188. insert_update ComposedType2CoverageConstraintGroupRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(interfaceName)[unique=true,allownull=true]
  189. "#% impex.exportItems( ""ComposedType2CoverageConstraintGroupRelation"" , false );"
  190.  
  191. # ---- Extension: commerceservices ---- Type: BaseStore2LanguageRel ----
  192. "#% impex.setTargetFile( ""BaseStore2LanguageRel.csv"" );"
  193. insert_update BaseStore2LanguageRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(isocode)[unique=true,allownull=true]
  194. "#% impex.exportItems( ""BaseStore2LanguageRel"" , false );"
  195.  
  196. # ---- Extension: catalog ---- Type: DependentCatalogVersionSyncJobRelation ----
  197. "#% impex.setTargetFile( ""DependentCatalogVersionSyncJobRelation.csv"" );"
  198. insert_update DependentCatalogVersionSyncJobRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[unique=true,allownull=true];target(code,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[unique=true,allownull=true]
  199. "#% impex.exportItems( ""DependentCatalogVersionSyncJobRelation"" , false );"
  200.  
  201. # ---- Extension: catalog ---- Type: CategoryProductRelation ----
  202. "#% impex.setTargetFile( ""CategoryProductRelation.csv"" );"
  203. insert_update CategoryProductRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  204. "#% impex.exportItems( ""CategoryProductRelation"" , false );"
  205.  
  206. # ---- Extension: deliveryzone ---- Type: ZoneCountryRelation ----
  207. "#% impex.setTargetFile( ""ZoneCountryRelation.csv"" );"
  208. insert_update ZoneCountryRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(isocode)[unique=true,allownull=true]
  209. "#% impex.exportItems( ""ZoneCountryRelation"" , false );"
  210.  
  211. # ---- Extension: comments ---- Type: CommentAssigneeRelation ----
  212. "#% impex.setTargetFile( ""CommentAssigneeRelation.csv"" );"
  213. insert_update CommentAssigneeRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  214. "#% impex.exportItems( ""CommentAssigneeRelation"" , false );"
  215.  
  216. # ---- Extension: catalog ---- Type: Category2KeywordRelation ----
  217. "#% impex.setTargetFile( ""Category2KeywordRelation.csv"" );"
  218. insert_update Category2KeywordRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),keyword,language(isocode))[unique=true,allownull=true]
  219. "#% impex.exportItems( ""Category2KeywordRelation"" , false );"
  220.  
  221. # ---- Extension: catalog ---- Type: Product2KeywordRelation ----
  222. "#% impex.setTargetFile( ""Product2KeywordRelation.csv"" );"
  223. insert_update Product2KeywordRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),keyword,language(isocode))[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  224. "#% impex.exportItems( ""Product2KeywordRelation"" , false );"
  225.  
  226. # ---- Extension: commerceservices ---- Type: PromotionRestriction2OrderRel ----
  227. "#% impex.setTargetFile( ""PromotionRestriction2OrderRel.csv"" );"
  228. insert_update PromotionRestriction2OrderRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  229. "#% impex.exportItems( ""PromotionRestriction2OrderRel"" , false );"
  230.  
  231. # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2SolrValueRangeSetRelation ----
  232. "#% impex.setTargetFile( ""SolrFacetSearchConfig2SolrValueRangeSetRelation.csv"" );"
  233. insert_update SolrFacetSearchConfig2SolrValueRangeSetRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(name)[unique=true,allownull=true];target(name)[unique=true,allownull=true]
  234. "#% impex.exportItems( ""SolrFacetSearchConfig2SolrValueRangeSetRelation"" , false );"
  235.  
  236. # ---- Extension: basecommerce ---- Type: StockLevelProductRelation ----
  237. "#% impex.setTargetFile( ""StockLevelProductRelation.csv"" );"
  238. insert_update StockLevelProductRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(pk)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  239. "#% impex.exportItems( ""StockLevelProductRelation"" , false );"
  240.  
  241. # ---- Extension: catalog ---- Type: CategoryCategoryRelation ----
  242. "#% impex.setTargetFile( ""CategoryCategoryRelation.csv"" );"
  243. insert_update CategoryCategoryRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  244. "#% impex.exportItems( ""CategoryCategoryRelation"" , false );"
  245.  
  246. # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2CatalogVersionRelation ----
  247. "#% impex.setTargetFile( ""SolrFacetSearchConfig2CatalogVersionRelation.csv"" );"
  248. insert_update SolrFacetSearchConfig2CatalogVersionRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(name)[unique=true,allownull=true];target(catalog(id),version)[unique=true,allownull=true]
  249. "#% impex.exportItems( ""SolrFacetSearchConfig2CatalogVersionRelation"" , false );"
  250.  
  251. # ---- Extension: comments ---- Type: ComponentCreatePrincipalRelation ----
  252. "#% impex.setTargetFile( ""ComponentCreatePrincipalRelation.csv"" );"
  253. insert_update ComponentCreatePrincipalRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code,domain(code))[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  254. "#% impex.exportItems( ""ComponentCreatePrincipalRelation"" , false );"
  255.  
  256. # ---- Extension: commerceservices ---- Type: PoS2WarehouseRel ----
  257. "#% impex.setTargetFile( ""PoS2WarehouseRel.csv"" );"
  258. insert_update PoS2WarehouseRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(name)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  259. "#% impex.exportItems( ""PoS2WarehouseRel"" , false );"
  260.  
  261. # ---- Extension: commons ---- Type: Format2MedForRel ----
  262. "#% impex.setTargetFile( ""Format2MedForRel.csv"" );"
  263. insert_update Format2MedForRel;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  264. "#% impex.exportItems( ""Format2MedForRel"" , false );"
  265.  
  266. # ---- Extension: core ---- Type: OrderDiscountRelation ----
  267. "#% impex.setTargetFile( ""OrderDiscountRelation.csv"" );"
  268. insert_update OrderDiscountRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  269. "#% impex.exportItems( ""OrderDiscountRelation"" , false );"
  270.  
  271. # ---- Extension: basecommerce ---- Type: ProductVendorRelation ----
  272. "#% impex.setTargetFile( ""ProductVendorRelation.csv"" );"
  273. insert_update ProductVendorRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  274. "#% impex.exportItems( ""ProductVendorRelation"" , false );"
  275.  
  276. # ---- Extension: workflow ---- Type: WorkflowTemplate2PrincipalRelation ----
  277. "#% impex.setTargetFile( ""WorkflowTemplate2PrincipalRelation.csv"" );"
  278. insert_update WorkflowTemplate2PrincipalRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  279. "#% impex.exportItems( ""WorkflowTemplate2PrincipalRelation"" , false );"
  280.  
  281. # ---- Extension: promotions ---- Type: CategoryPromotionRelation ----
  282. "#% impex.setTargetFile( ""CategoryPromotionRelation.csv"" );"
  283. insert_update CategoryPromotionRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];target(pk)[unique=true,allownull=true]
  284. "#% impex.exportItems( ""CategoryPromotionRelation"" , false );"
  285.  
  286. # ---- Extension: workflow ---- Type: WorkflowActionTemplateLinkTemplateRelation ----
  287. "#% impex.setTargetFile( ""WorkflowActionTemplateLinkTemplateRelation.csv"" );"
  288. insert_update WorkflowActionTemplateLinkTemplateRelation;pk;andConnectionTemplate[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(code)[unique=true,allownull=true];target(code)[unique=true,allownull=true]
  289. "#% impex.exportItems( ""WorkflowActionTemplateLinkTemplateRelation"" , false );"
  290.  
  291. # ---- Extension: core ---- Type: PrincipalGroupRelation ----
  292. "#% impex.setTargetFile( ""PrincipalGroupRelation.csv"" );"
  293. insert_update PrincipalGroupRelation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];language(isocode)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier;reverseSequenceNumber;sequenceNumber;source(uid)[unique=true,allownull=true];target(uid)[unique=true,allownull=true]
  294. "#% impex.exportItems( ""PrincipalGroupRelation"" , false );"
  295.  
  296. # ---- Extension: core ---- Type: GenericItem ----
  297. "#% impex.setTargetFile( ""GenericItem.csv"" );"
  298. insert_update GenericItem;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  299. "#% impex.exportItems( ""GenericItem"" , false );"
  300.  
  301. # ---- Extension: core ---- Type: SystemSetupAudit ----
  302. "#% impex.setTargetFile( ""SystemSetupAudit.csv"" );"
  303. insert_update SystemSetupAudit;pk;className[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;extensionName[allownull=true,forceWrite=true];hash[forceWrite=true,unique=true,allownull=true];methodName[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[allownull=true,forceWrite=true];owner(pk)[forceWrite=true];patch[allownull=true,forceWrite=true];required[allownull=true,forceWrite=true];user(uid)[allownull=true,forceWrite=true]
  304. "#% impex.exportItems( ""SystemSetupAudit"" , false );"
  305.  
  306. # ---- Extension: backofficesolrsearch ---- Type: BackofficeIndexedTypeToSolrFacetSearchConfig ----
  307. "#% impex.setTargetFile( ""BackofficeIndexedTypeToSolrFacetSearchConfig.csv"" );"
  308. insert_update BackofficeIndexedTypeToSolrFacetSearchConfig;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];indexedType(code)[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];solrFacetSearchConfig(name)[allownull=true]
  309. "#% impex.exportItems( ""BackofficeIndexedTypeToSolrFacetSearchConfig"" , false );"
  310.  
  311. # ---- Extension: commons ---- Type: JaloTranslatorConfiguration ----
  312. "#% impex.setTargetFile( ""JaloTranslatorConfiguration.csv"" );"
  313. insert_update JaloTranslatorConfiguration;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  314. "#% impex.exportItems( ""JaloTranslatorConfiguration"" , false );"
  315.  
  316. # ---- Extension: ecrpimbackoffice ---- Type: TdsIngredient ----
  317. "#% impex.setTargetFile( ""TdsIngredient.csv"" );"
  318. insert_update TdsIngredient;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));approvalStatus(code,itemtype(code))[allownull=true];buyerIDS(key(code,itemtype(code)));catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];contentUnit(code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);deliveryTime;detail(catalogVersion(catalog(id),version),code);ean;endLineNumber;erpGroupBuyer;erpGroupSupplier;europe1Discounts(pk);europe1Prices(pk);europe1Taxes(pk);factoryCode(pk);factoryNumber;galleryImages(catalogVersion(catalog(id),version),qualifier);logo(catalogVersion(catalog(id),version),code);manufacturerAID;manufacturerName;maxOrderQuantity;minOrderQuantity;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);numberContentUnits;offlineDate[dateformat=dd.MM.yyyy hh:mm:ss];onlineDate[dateformat=dd.MM.yyyy hh:mm:ss];order;orderQuantityInterval;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);priceQuantity;productOrderLimit(pk);properties;specialTreatmentClasses();startLineNumber;supplierAlternativeAID;thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code);unit(code);untypedFeatures(language(isocode),product(catalogVersion(catalog(id),version),code),qualifier,unit(code,systemVersion(catalog(id),version),unitType),valuePosition);variantType(code);xmlcontent
  319. "#% impex.exportItems( ""TdsIngredient"" , false );"
  320.  
  321. # ---- Extension: workflow ---- Type: WorkflowAction ----
  322. "#% impex.setTargetFile( ""WorkflowAction.csv"" );"
  323. insert_update WorkflowAction;pk;actionType(code,itemtype(code))[allownull=true];activated[dateformat=dd.MM.yyyy hh:mm:ss];code[forceWrite=true,unique=true];comment;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];emailAddress;firstActivated[dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(uid)[allownull=true,forceWrite=true];principalAssigned(uid)[allownull=true];rendererTemplate(code);selectedDecision(code);sendEmail[allownull=true];status(code,itemtype(code));template(code)[allownull=true,forceWrite=true];workflow(code)[allownull=true,forceWrite=true];workflowPOS
  324. "#% impex.exportItems( ""WorkflowAction"" , false );"
  325.  
  326. # ---- Extension: basecommerce ---- Type: RefundEntry ----
  327. "#% impex.setTargetFile( ""RefundEntry.csv"" );"
  328. insert_update RefundEntry;pk[unique=true];action(code,itemtype(code))[allownull=true];amount;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expectedQuantity;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];notes;orderEntry(entryNumber)[allownull=true];owner(pk)[forceWrite=true];reachedDate[dateformat=dd.MM.yyyy hh:mm:ss];reason(code,itemtype(code))[allownull=true];receivedQuantity;refundedDate[dateformat=dd.MM.yyyy hh:mm:ss];returnRequest(code);returnRequestPOS;status(code,itemtype(code))[allownull=true]
  329. "#% impex.exportItems( ""RefundEntry"" , false );"
  330.  
  331. # ---- Extension: impex ---- Type: ImportBatchContent ----
  332. "#% impex.setTargetFile( ""ImportBatchContent.csv"" );"
  333. insert_update ImportBatchContent;pk;code[forceWrite=true,unique=true,allownull=true];content[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  334. "#% impex.exportItems( ""ImportBatchContent"" , false );"
  335.  
  336. # ---- Extension: impex ---- Type: DistributedImportSplitErrorDump ----
  337. "#% impex.setTargetFile( ""DistributedImportSplitErrorDump.csv"" );"
  338. insert_update DistributedImportSplitErrorDump;pk;code[forceWrite=true,unique=true,allownull=true];content[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];processCode[allownull=true,forceWrite=true]
  339. "#% impex.exportItems( ""DistributedImportSplitErrorDump"" , false );"
  340.  
  341. # ---- Extension: basecommerce ---- Type: ConsignmentEntry ----
  342. "#% impex.setTargetFile( ""ConsignmentEntry.csv"" );"
  343. insert_update ConsignmentEntry;pk[unique=true];consignment(pk)[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];orderEntry(entryNumber)[allownull=true,forceWrite=true];owner(pk)[forceWrite=true];quantity[allownull=true];shippedQuantity
  344. "#% impex.exportItems( ""ConsignmentEntry"" , false );"
  345.  
  346. # ---- Extension: core ---- Type: BruteForceLoginAttempts ----
  347. "#% impex.setTargetFile( ""BruteForceLoginAttempts.csv"" );"
  348. insert_update BruteForceLoginAttempts;pk;attempts[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];uid[forceWrite=true,unique=true,allownull=true]
  349. "#% impex.exportItems( ""BruteForceLoginAttempts"" , false );"
  350.  
  351. # ---- Extension: solrfacetsearch ---- Type: SolrIndexerQueryParameter ----
  352. "#% impex.setTargetFile( ""SolrIndexerQueryParameter.csv"" );"
  353. insert_update SolrIndexerQueryParameter;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[allownull=true];owner(pk)[forceWrite=true];solrIndexerQuery(identifier);solrIndexerQueryPOS;value[allownull=true]
  354. "#% impex.exportItems( ""SolrIndexerQueryParameter"" , false );"
  355.  
  356. # ---- Extension: promotions ---- Type: PromotionResult ----
  357. "#% impex.setTargetFile( ""PromotionResult.csv"" );"
  358. insert_update PromotionResult;pk[unique=true];actions(pk);certainty;consumedEntries(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];custom;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code);owner(pk)[forceWrite=true];promotion(pk)
  359. "#% impex.exportItems( ""PromotionResult"" , false );"
  360.  
  361. # ---- Extension: core ---- Type: Order ----
  362. "#% impex.setTargetFile( ""Order.csv"" );"
  363. insert_update Order;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));appliedVoucherCodes;calculated;code[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];date[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryCost;deliveryMode(code);deliveryStatus(code,itemtype(code));description;discountsIncludeDeliveryCost[allownull=true];discountsIncludePaymentCost[allownull=true];entryGroups;expirationTime[dateformat=dd.MM.yyyy hh:mm:ss];exportStatus(code,itemtype(code));fraudulent;globalDiscountValues;globalDiscountValuesInternal;guid;language(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;net[allownull=true];originalVersion(code,versionID)[forceWrite=true];owner(pk)[forceWrite=true];paymentAddress(pk);paymentCost;paymentInfo(pk);paymentMode(code);paymentStatus(code,itemtype(code));placedBy(uid);potentiallyFraudulent;previousDeliveryMode(code);quoteDiscountValuesInternal;quoteReference(code,version);salesApplication(code,itemtype(code));site(uid);status(code,itemtype(code));statusInfo;store(uid);subtotal;totalDiscounts;totalPrice;totalTax;totalTaxValues;totalTaxValuesInternal;user(uid)[allownull=true];versionID[forceWrite=true,unique=true]
  364. "#% impex.exportItems( ""Order"" , false );"
  365.  
  366. # ---- Extension: basecommerce ---- Type: ReplacementOrder ----
  367. "#% impex.setTargetFile( ""ReplacementOrder.csv"" );"
  368. insert_update ReplacementOrder;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));appliedVoucherCodes;calculated;code[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];date[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryCost;deliveryMode(code);deliveryStatus(code,itemtype(code));description;discountsIncludeDeliveryCost[allownull=true];discountsIncludePaymentCost[allownull=true];entryGroups;expirationTime[dateformat=dd.MM.yyyy hh:mm:ss];exportStatus(code,itemtype(code));fraudulent;fulfilmentStatus(code,itemtype(code))[allownull=true];globalDiscountValues;globalDiscountValuesInternal;guid;language(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;net[allownull=true];notes;originalVersion(code,versionID)[forceWrite=true];owner(pk)[forceWrite=true];paymentAddress(pk);paymentCost;paymentInfo(pk);paymentMode(code);paymentStatus(code,itemtype(code));placedBy(uid);potentiallyFraudulent;previousDeliveryMode(code);quoteDiscountValuesInternal;quoteReference(code,version);salesApplication(code,itemtype(code));site(uid);status(code,itemtype(code));statusInfo;store(uid);subtotal;totalDiscounts;totalPrice;totalTax;totalTaxValues;totalTaxValuesInternal;user(uid)[allownull=true];versionID[forceWrite=true,unique=true]
  369. "#% impex.exportItems( ""ReplacementOrder"" , false );"
  370.  
  371. # ---- Extension: catalog ---- Type: ProductReference ----
  372. "#% impex.setTargetFile( ""ProductReference.csv"" );"
  373. insert_update ProductReference;pk;active[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];icon(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];preselected[allownull=true];qualifier;quantity;referenceType(code,itemtype(code))[unique=true];source(catalogVersion(catalog(id),version),code)[forceWrite=true,unique=true,allownull=true];sourcePOS;target(catalogVersion(catalog(id),version),code)[unique=true,allownull=true]
  374. "#% impex.exportItems( ""ProductReference"" , false );"
  375.  
  376. # ---- Extension: oauth2 ---- Type: OAuthRefreshToken ----
  377. "#% impex.setTargetFile( ""OAuthRefreshToken.csv"" );"
  378. insert_update OAuthRefreshToken;pk[unique=true];authentication;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];token;tokenId[allownull=true]
  379. "#% impex.exportItems( ""OAuthRefreshToken"" , false );"
  380.  
  381. # ---- Extension: catalog ---- Type: ProductCatalogVersionDifference ----
  382. "#% impex.setTargetFile( ""ProductCatalogVersionDifference.csv"" );"
  383. insert_update ProductCatalogVersionDifference;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];cronJob(code,maxPriceTolerance,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[forceWrite=true,unique=true,allownull=true];differenceText;differenceValue;mode(code,itemtype(code))[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];sourceProduct(catalogVersion(catalog(id),version),code)[forceWrite=true,unique=true];sourceVersion(catalog(id),version)[forceWrite=true,unique=true,allownull=true];targetProduct(catalogVersion(catalog(id),version),code)[forceWrite=true,unique=true];targetVersion(catalog(id),version)[forceWrite=true,unique=true,allownull=true]
  384. "#% impex.exportItems( ""ProductCatalogVersionDifference"" , false );"
  385.  
  386. # ---- Extension: voucher ---- Type: OrderRestriction ----
  387. "#% impex.setTargetFile( ""OrderRestriction.csv"" );"
  388. insert_update OrderRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];net[allownull=true];owner(pk)[forceWrite=true];positive[allownull=true];total[allownull=true];valueofgoodsonly[allownull=true];voucher(code)[allownull=true,forceWrite=true];voucherPOS
  389. "#% impex.exportItems( ""OrderRestriction"" , false );"
  390.  
  391. # ---- Extension: promotions ---- Type: PromotionNullAction ----
  392. "#% impex.setTargetFile( ""PromotionNullAction.csv"" );"
  393. insert_update PromotionNullAction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];guid;markedApplied[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];promotionResult(pk)
  394. "#% impex.exportItems( ""PromotionNullAction"" , false );"
  395.  
  396. # ---- Extension: core ---- Type: Media ----
  397. "#% impex.setTargetFile( ""Media.csv"" );"
  398. insert_update Media;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];size;subFolderPath
  399. "#% impex.exportItems( ""Media"" , false );"
  400.  
  401. # ---- Extension: basecommerce ---- Type: BarcodeMedia ----
  402. "#% impex.setTargetFile( ""BarcodeMedia.csv"" );"
  403. insert_update BarcodeMedia;pk;URL;altText;barcodeText[allownull=true];barcodeType(code,itemtype(code))[allownull=true];catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];contextItem(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deeplinkUrl(code);deniedPrincipals(uid);description;folder(qualifier);internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];size;subFolderPath
  404. "#% impex.exportItems( ""BarcodeMedia"" , false );"
  405.  
  406. # ---- Extension: catalog ---- Type: CatalogUnawareMedia ----
  407. "#% impex.setTargetFile( ""CatalogUnawareMedia.csv"" );"
  408. insert_update CatalogUnawareMedia;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];size;subFolderPath
  409. "#% impex.exportItems( ""CatalogUnawareMedia"" , false );"
  410.  
  411. # ---- Extension: catalog ---- Type: CatalogVersionSyncScheduleMedia ----
  412. "#% impex.setTargetFile( ""CatalogVersionSyncScheduleMedia.csv"" );"
  413. insert_update CatalogVersionSyncScheduleMedia;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];cronjob(code)[allownull=true,forceWrite=true];cronjobPOS;dataPK;deniedPrincipals(uid);description;folder(qualifier);internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];scheduledCount;size;subFolderPath
  414. "#% impex.exportItems( ""CatalogVersionSyncScheduleMedia"" , false );"
  415.  
  416. # ---- Extension: commons ---- Type: Document ----
  417. "#% impex.setTargetFile( ""Document.csv"" );"
  418. insert_update Document;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);format(code)[allownull=true,forceWrite=true];internalURL;itemTimestamp[dateformat=dd.MM.yyyy hh:mm:ss];location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];size;sourceItem(pk)[forceWrite=true];subFolderPath
  419. "#% impex.exportItems( ""Document"" , false );"
  420.  
  421. # ---- Extension: auditreportservices ---- Type: AuditReportData ----
  422. "#% impex.setTargetFile( ""AuditReportData.csv"" );"
  423. insert_update AuditReportData;pk;URL;altText;auditReportConfig(pk);auditRootItem(pk)[allownull=true];catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];size;subFolderPath
  424. "#% impex.exportItems( ""AuditReportData"" , false );"
  425.  
  426. # ---- Extension: commons ---- Type: VelocityFormatter ----
  427. "#% impex.setTargetFile( ""VelocityFormatter.csv"" );"
  428. insert_update VelocityFormatter;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];outputMimeType[allownull=true];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];script;size;subFolderPath
  429. "#% impex.exportItems( ""VelocityFormatter"" , false );"
  430.  
  431. # ---- Extension: commons ---- Type: XMLTransformFormatter ----
  432. "#% impex.setTargetFile( ""XMLTransformFormatter.csv"" );"
  433. insert_update XMLTransformFormatter;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);inputMimeType[allownull=true];internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];outputMimeType[allownull=true];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];script;size;subFolderPath
  434. "#% impex.exportItems( ""XMLTransformFormatter"" , false );"
  435.  
  436. # ---- Extension: commons ---- Type: CustomOrder2XML ----
  437. "#% impex.setTargetFile( ""CustomOrder2XML.csv"" );"
  438. insert_update CustomOrder2XML;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];outputMimeType[allownull=true];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];script;size;subFolderPath
  439. "#% impex.exportItems( ""CustomOrder2XML"" , false );"
  440.  
  441. # ---- Extension: commons ---- Type: FOPFormatter ----
  442. "#% impex.setTargetFile( ""FOPFormatter.csv"" );"
  443. insert_update FOPFormatter;pk;URL;altText;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK;deniedPrincipals(uid);description;folder(qualifier);inputMimeType[allownull=true];internalURL;location;locationHash;mediaContainer(catalogVersion(catalog(id),version),qualifier);mediaFormat(qualifier);mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];outputMimeType[allownull=true];owner(pk)[forceWrite=true];permittedPrincipals(uid);realFileName;removable[allownull=true];script;size;subFolderPath
  444. "#% impex.exportItems( ""FOPFormatter"" , false );"
  445.  
  446. # ---- Extension: europe1 ---- Type: GlobalDiscountRow ----
  447. "#% impex.setTargetFile( ""GlobalDiscountRow.csv"" );"
  448. insert_update GlobalDiscountRow;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);dateRange[dateformat=dd.MM.yyyy hh:mm:ss];discount(code)[allownull=true,forceWrite=true];endTime[dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];productId[forceWrite=true];productMatchQualifier;startTime[dateformat=dd.MM.yyyy hh:mm:ss];ug(code,itemtype(code));user(uid);userMatchQualifier;value
  449. "#% impex.exportItems( ""GlobalDiscountRow"" , false );"
  450.  
  451. # ---- Extension: basecommerce ---- Type: ReturnRequest ----
  452. "#% impex.setTargetFile( ""ReturnRequest.csv"" );"
  453. insert_update ReturnRequest;pk;RMA;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID);orderPOS;owner(pk)[forceWrite=true];refundDeliveryCost;replacementOrder(code,versionID);returnForm(catalogVersion(catalog(id),version),code);returnLabel(catalogVersion(catalog(id),version),code);returnWarehouse(pk);status(code,itemtype(code));subtotal
  454. "#% impex.exportItems( ""ReturnRequest"" , false );"
  455.  
  456. # ---- Extension: solrfacetsearch ---- Type: SolrProductRedirect ----
  457. "#% impex.setTargetFile( ""SolrProductRedirect.csv"" );"
  458. insert_update SolrProductRedirect;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];redirectItem(catalogVersion(catalog(id),version),code)[allownull=true]
  459. "#% impex.exportItems( ""SolrProductRedirect"" , false );"
  460.  
  461. # ---- Extension: basecommerce ---- Type: OrderCancelConfig ----
  462. "#% impex.setTargetFile( ""OrderCancelConfig.csv"" );"
  463. insert_update OrderCancelConfig;pk[unique=true];cancelAfterWarehouseAllowed[allownull=true];completeCancelAfterShippingStartedAllowed[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];orderCancelAllowed[allownull=true];owner(pk)[forceWrite=true];partialCancelAllowed[allownull=true];partialOrderEntryCancelAllowed[allownull=true];queuedOrderWaitingTime[allownull=true]
  464. "#% impex.exportItems( ""OrderCancelConfig"" , false );"
  465.  
  466. # ---- Extension: processing ---- Type: BusinessProcess ----
  467. "#% impex.setTargetFile( ""BusinessProcess.csv"" );"
  468. insert_update BusinessProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endMessage;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;state(code,itemtype(code))[allownull=true];user(uid)
  469. "#% impex.exportItems( ""BusinessProcess"" , false );"
  470.  
  471. # ---- Extension: basecommerce ---- Type: ConsignmentProcess ----
  472. "#% impex.setTargetFile( ""ConsignmentProcess.csv"" );"
  473. insert_update ConsignmentProcess;pk;code[forceWrite=true,unique=true,allownull=true];consignment(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endMessage;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];parentProcess(code);processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;state(code,itemtype(code))[allownull=true];user(uid)
  474. "#% impex.exportItems( ""ConsignmentProcess"" , false );"
  475.  
  476. # ---- Extension: basecommerce ---- Type: OrderProcess ----
  477. "#% impex.setTargetFile( ""OrderProcess.csv"" );"
  478. insert_update OrderProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endMessage;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID);owner(pk)[forceWrite=true];processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;state(code,itemtype(code))[allownull=true];user(uid)
  479. "#% impex.exportItems( ""OrderProcess"" , false );"
  480.  
  481. # ---- Extension: commerceservices ---- Type: QuoteProcess ----
  482. "#% impex.setTargetFile( ""QuoteProcess.csv"" );"
  483. insert_update QuoteProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endMessage;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;quoteCode;state(code,itemtype(code))[allownull=true];user(uid)
  484. "#% impex.exportItems( ""QuoteProcess"" , false );"
  485.  
  486. # ---- Extension: basecommerce ---- Type: ReturnProcess ----
  487. "#% impex.setTargetFile( ""ReturnProcess.csv"" );"
  488. insert_update ReturnProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endMessage;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;returnRequest(code);state(code,itemtype(code))[allownull=true];user(uid)
  489. "#% impex.exportItems( ""ReturnProcess"" , false );"
  490.  
  491. # ---- Extension: commerceservices ---- Type: StoreFrontProcess ----
  492. "#% impex.setTargetFile( ""StoreFrontProcess.csv"" );"
  493. insert_update StoreFrontProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endMessage;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;site(uid);state(code,itemtype(code))[allownull=true];store(uid);user(uid)
  494. "#% impex.exportItems( ""StoreFrontProcess"" , false );"
  495.  
  496. # ---- Extension: commerceservices ---- Type: StoreFrontCustomerProcess ----
  497. "#% impex.setTargetFile( ""StoreFrontCustomerProcess.csv"" );"
  498. insert_update StoreFrontCustomerProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];customer(uid);endMessage;language(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;site(uid);state(code,itemtype(code))[allownull=true];store(uid);user(uid)
  499. "#% impex.exportItems( ""StoreFrontCustomerProcess"" , false );"
  500.  
  501. # ---- Extension: commerceservices ---- Type: ForgottenPasswordProcess ----
  502. "#% impex.setTargetFile( ""ForgottenPasswordProcess.csv"" );"
  503. insert_update ForgottenPasswordProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];customer(uid);endMessage;language(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];processDefinitionName[allownull=true,forceWrite=true];processDefinitionVersion;site(uid);state(code,itemtype(code))[allownull=true];store(uid);token;user(uid)
  504. "#% impex.exportItems( ""ForgottenPasswordProcess"" , false );"
  505.  
  506. # ---- Extension: platformbackoffice ---- Type: BackofficeSearchCondition ----
  507. "#% impex.setTargetFile( ""BackofficeSearchCondition.csv"" );"
  508. insert_update BackofficeSearchCondition;pk[unique=true];attribute[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];disabled;editor;editorParameters();languageCode;mandatory;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];operatorCode[allownull=true];owner(pk)[forceWrite=true];savedQuery(pk);selected;sortable;value;valueReference(pk)
  509. "#% impex.exportItems( ""BackofficeSearchCondition"" , false );"
  510.  
  511. # ---- Extension: basecommerce ---- Type: BaseSite ----
  512. "#% impex.setTargetFile( ""BaseSite.csv"" );"
  513. insert_update BaseSite;pk;channel(code,itemtype(code));creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultLanguage(isocode);defaultPromotionGroup(Identifier);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];solrFacetSearchConfiguration(name);theme(code,itemtype(code));uid[unique=true,allownull=true]
  514. "#% impex.exportItems( ""BaseSite"" , false );"
  515.  
  516. # ---- Extension: catalog ---- Type: Keyword ----
  517. "#% impex.setTargetFile( ""Keyword.csv"" );"
  518. insert_update Keyword;pk;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];keyword[unique=true,allownull=true];language(isocode)[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  519. "#% impex.exportItems( ""Keyword"" , false );"
  520.  
  521. # ---- Extension: catalog ---- Type: ClassificationKeyword ----
  522. "#% impex.setTargetFile( ""ClassificationKeyword.csv"" );"
  523. insert_update ClassificationKeyword;pk;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];externalID;keyword[unique=true,allownull=true];language(isocode)[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  524. "#% impex.exportItems( ""ClassificationKeyword"" , false );"
  525.  
  526. # ---- Extension: basecommerce ---- Type: OrderReturnRecord ----
  527. "#% impex.setTargetFile( ""OrderReturnRecord.csv"" );"
  528. insert_update OrderReturnRecord;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];identifier[unique=true];inProgress[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID)[allownull=true];owner(pk)[forceWrite=true]
  529. "#% impex.exportItems( ""OrderReturnRecord"" , false );"
  530.  
  531. # ---- Extension: core ---- Type: Product ----
  532. "#% impex.setTargetFile( ""Product.csv"" );"
  533. insert_update Product;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));approvalStatus(code,itemtype(code))[allownull=true];buyerIDS(key(code,itemtype(code)));catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];contentUnit(code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);deliveryTime;detail(catalogVersion(catalog(id),version),code);ean;endLineNumber;erpGroupBuyer;erpGroupSupplier;europe1Discounts(pk);europe1Prices(pk);europe1Taxes(pk);galleryImages(catalogVersion(catalog(id),version),qualifier);logo(catalogVersion(catalog(id),version),code);manufacturerAID;manufacturerName;maxOrderQuantity;minOrderQuantity;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);numberContentUnits;offlineDate[dateformat=dd.MM.yyyy hh:mm:ss];onlineDate[dateformat=dd.MM.yyyy hh:mm:ss];order;orderQuantityInterval;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);priceQuantity;productOrderLimit(pk);specialTreatmentClasses();startLineNumber;supplierAlternativeAID;thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code);unit(code);untypedFeatures(language(isocode),product(catalogVersion(catalog(id),version),code),qualifier,unit(code,systemVersion(catalog(id),version),unitType),valuePosition);variantType(code);xmlcontent
  534. "#% impex.exportItems( ""Product"" , false );"
  535.  
  536. # ---- Extension: basecommerce ---- Type: GenericVariantProduct ----
  537. "#% impex.setTargetFile( ""GenericVariantProduct.csv"" );"
  538. insert_update GenericVariantProduct;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));approvalStatus(code,itemtype(code))[allownull=true];baseProduct(catalogVersion(catalog(id),version),code)[allownull=true];buyerIDS(key(code,itemtype(code)));catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];contentUnit(code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);deliveryTime;detail(catalogVersion(catalog(id),version),code);ean;endLineNumber;erpGroupBuyer;erpGroupSupplier;europe1Discounts(pk);europe1Prices(pk);europe1Taxes(pk);galleryImages(catalogVersion(catalog(id),version),qualifier);logo(catalogVersion(catalog(id),version),code);manufacturerAID;manufacturerName;maxOrderQuantity;minOrderQuantity;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);numberContentUnits;offlineDate[dateformat=dd.MM.yyyy hh:mm:ss];onlineDate[dateformat=dd.MM.yyyy hh:mm:ss];order;orderQuantityInterval;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);priceQuantity;productOrderLimit(pk);specialTreatmentClasses();startLineNumber;supplierAlternativeAID;thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code);unit(code);untypedFeatures(language(isocode),product(catalogVersion(catalog(id),version),code),qualifier,unit(code,systemVersion(catalog(id),version),unitType),valuePosition);variantType(code);xmlcontent
  539. "#% impex.exportItems( ""GenericVariantProduct"" , false );"
  540.  
  541. # ---- Extension: ecrpimbackoffice ---- Type: TdsIngredientVariant ----
  542. "#% impex.setTargetFile( ""TdsIngredientVariant.csv"" );"
  543. insert_update TdsIngredientVariant;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));approvalStatus(code,itemtype(code))[allownull=true];baseProduct(catalogVersion(catalog(id),version),code)[allownull=true];buyerIDS(key(code,itemtype(code)));catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];contentUnit(code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);deliveryTime;detail(catalogVersion(catalog(id),version),code);ean;endLineNumber;erpGroupBuyer;erpGroupSupplier;europe1Discounts(pk);europe1Prices(pk);europe1Taxes(pk);galleryImages(catalogVersion(catalog(id),version),qualifier);logo(catalogVersion(catalog(id),version),code);manufacturerAID;manufacturerName;maxOrderQuantity;minOrderQuantity;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);numberContentUnits;offlineDate[dateformat=dd.MM.yyyy hh:mm:ss];onlineDate[dateformat=dd.MM.yyyy hh:mm:ss];order;orderQuantityInterval;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);priceQuantity;productOrderLimit(pk);specialTreatmentClasses();startLineNumber;supplierAlternativeAID;thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code);unit(code);untypedFeatures(language(isocode),product(catalogVersion(catalog(id),version),code),qualifier,unit(code,systemVersion(catalog(id),version),unitType),valuePosition);variantType(code);xmlcontent
  544. "#% impex.exportItems( ""TdsIngredientVariant"" , false );"
  545.  
  546. # ---- Extension: catalog ---- Type: ItemSyncTimestamp ----
  547. "#% impex.setTargetFile( ""ItemSyncTimestamp.csv"" );"
  548. insert_update ItemSyncTimestamp;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];lastSyncSourceModifiedTime[dateformat=dd.MM.yyyy hh:mm:ss];lastSyncTime[dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];pendingAttributeQualifiers;pendingAttributesOwnerJob(code);pendingAttributesScheduledTurn;sourceItem(pk)[allownull=true,forceWrite=true];sourceVersion(catalog(id),version)[allownull=true,forceWrite=true];syncJob(code,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[forceWrite=true];targetItem(pk)[allownull=true,forceWrite=true];targetVersion(catalog(id),version)[allownull=true,forceWrite=true]
  549. "#% impex.exportItems( ""ItemSyncTimestamp"" , false );"
  550.  
  551. # ---- Extension: promotions ---- Type: OrderThresholdChangeDeliveryModePromotion ----
  552. "#% impex.setTargetFile( ""OrderThresholdChangeDeliveryModePromotion.csv"" );"
  553. insert_update OrderThresholdChangeDeliveryModePromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryMode(code);description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];thresholdTotals(pk);title
  554. "#% impex.exportItems( ""OrderThresholdChangeDeliveryModePromotion"" , false );"
  555.  
  556. # ---- Extension: impex ---- Type: ExternalImportKey ----
  557. "#% impex.setTargetFile( ""ExternalImportKey.csv"" );"
  558. insert_update ExternalImportKey;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];sourceKey[allownull=true];sourceSystemID[allownull=true];targetPK[allownull=true]
  559. "#% impex.exportItems( ""ExternalImportKey"" , false );"
  560.  
  561. # ---- Extension: core ---- Type: SavedValues ----
  562. "#% impex.setTargetFile( ""SavedValues.csv"" );"
  563. insert_update SavedValues;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modificationType(code,itemtype(code))[allownull=true];modifiedItem(pk)[forceWrite=true];modifiedItemDisplayString[allownull=true];modifiedItemPOS;modifiedItemType(code)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];timestamp[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];user(uid)[allownull=true]
  564. "#% impex.exportItems( ""SavedValues"" , false );"
  565.  
  566. # ---- Extension: processing ---- Type: DistributedProcess ----
  567. "#% impex.setTargetFile( ""DistributedProcess.csv"" );"
  568. insert_update DistributedProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currentExecutionId[allownull=true];extendedStatus;handlerBeanId[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup[forceWrite=true];owner(pk)[forceWrite=true];progress;state(code,itemtype(code))[allownull=true];status;stopRequested[allownull=true]
  569. "#% impex.exportItems( ""DistributedProcess"" , false );"
  570.  
  571. # ---- Extension: impex ---- Type: DistributedImportProcess ----
  572. "#% impex.setTargetFile( ""DistributedImportProcess.csv"" );"
  573. insert_update DistributedImportProcess;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currentExecutionId[allownull=true];extendedStatus;handlerBeanId[forceWrite=true];impExImportCronJob(code)[allownull=true];metadata[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup[forceWrite=true];owner(pk)[forceWrite=true];progress;state(code,itemtype(code))[allownull=true];status;stopRequested[allownull=true]
  574. "#% impex.exportItems( ""DistributedImportProcess"" , false );"
  575.  
  576. # ---- Extension: processing ---- Type: SimpleDistributedProcess ----
  577. "#% impex.setTargetFile( ""SimpleDistributedProcess.csv"" );"
  578. insert_update SimpleDistributedProcess;pk;batchSize[forceWrite=true];code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currentExecutionId[allownull=true];extendedStatus;handlerBeanId[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup[forceWrite=true];owner(pk)[forceWrite=true];progress;state(code,itemtype(code))[allownull=true];status;stopRequested[allownull=true]
  579. "#% impex.exportItems( ""SimpleDistributedProcess"" , false );"
  580.  
  581. # ---- Extension: solrfacetsearch ---- Type: SolrIndexerDistributedProcess ----
  582. "#% impex.setTargetFile( ""SolrIndexerDistributedProcess.csv"" );"
  583. insert_update SolrIndexerDistributedProcess;pk;batchSize[forceWrite=true];code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currentExecutionId[allownull=true];extendedStatus;externalIndexOperation;facetSearchConfig;handlerBeanId[forceWrite=true];index;indexOperation(code,itemtype(code));indexOperationId;indexedProperties;indexedType;indexerHints();modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup[forceWrite=true];owner(pk)[forceWrite=true];progress;sessionCurrency;sessionLanguage;sessionUser;state(code,itemtype(code))[allownull=true];status;stopRequested[allownull=true]
  584. "#% impex.exportItems( ""SolrIndexerDistributedProcess"" , false );"
  585.  
  586. # ---- Extension: catalog ---- Type: Catalog ----
  587. "#% impex.setTargetFile( ""Catalog.csv"" );"
  588. insert_update Catalog;pk;activeCatalogVersion(catalog(id),version);buyer(uid);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultCatalog[allownull=true];id[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];previewURLTemplate;supplier(uid);urlPatterns
  589. "#% impex.exportItems( ""Catalog"" , false );"
  590.  
  591. # ---- Extension: catalog ---- Type: ClassificationSystem ----
  592. "#% impex.setTargetFile( ""ClassificationSystem.csv"" );"
  593. insert_update ClassificationSystem;pk;activeCatalogVersion(catalog(id),version);buyer(uid);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultCatalog[allownull=true];id[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];previewURLTemplate;supplier(uid);urlPatterns
  594. "#% impex.exportItems( ""ClassificationSystem"" , false );"
  595.  
  596. # ---- Extension: comments ---- Type: CommentUserSetting ----
  597. "#% impex.setTargetFile( ""CommentUserSetting.csv"" );"
  598. insert_update CommentUserSetting;pk[unique=true];comment(pk)[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];ignored;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;read;user(uid)[allownull=true,forceWrite=true]
  599. "#% impex.exportItems( ""CommentUserSetting"" , false );"
  600.  
  601. # ---- Extension: customerreview ---- Type: CustomerReview ----
  602. "#% impex.setTargetFile( ""CustomerReview.csv"" );"
  603. insert_update CustomerReview;pk[unique=true];alias;approvalStatus(code,itemtype(code))[allownull=true];blocked[allownull=true];comment;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];headline;language(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];product(catalogVersion(catalog(id),version),code)[allownull=true,forceWrite=true];rating[allownull=true];user(uid)[allownull=true]
  604. "#% impex.exportItems( ""CustomerReview"" , false );"
  605.  
  606. # ---- Extension: basecommerce ---- Type: DeeplinkUrl ----
  607. "#% impex.setTargetFile( ""DeeplinkUrl.csv"" );"
  608. insert_update DeeplinkUrl;pk;baseUrl[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[allownull=true];owner(pk)[forceWrite=true]
  609. "#% impex.exportItems( ""DeeplinkUrl"" , false );"
  610.  
  611. # ---- Extension: core ---- Type: Tax ----
  612. "#% impex.setTargetFile( ""Tax.csv"" );"
  613. insert_update Tax;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];value
  614. "#% impex.exportItems( ""Tax"" , false );"
  615.  
  616. # ---- Extension: core ---- Type: Title ----
  617. "#% impex.setTargetFile( ""Title.csv"" );"
  618. insert_update Title;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  619. "#% impex.exportItems( ""Title"" , false );"
  620.  
  621. # ---- Extension: core ---- Type: PaymentInfo ----
  622. "#% impex.setTargetFile( ""PaymentInfo.csv"" );"
  623. insert_update PaymentInfo;pk[unique=true];billingAddress(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];duplicate;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];original(pk)[forceWrite=true];owner(pk)[forceWrite=true];saved;user(uid)[allownull=true,forceWrite=true]
  624. "#% impex.exportItems( ""PaymentInfo"" , false );"
  625.  
  626. # ---- Extension: core ---- Type: AdvancePaymentInfo ----
  627. "#% impex.setTargetFile( ""AdvancePaymentInfo.csv"" );"
  628. insert_update AdvancePaymentInfo;pk[unique=true];billingAddress(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];duplicate;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];original(pk)[forceWrite=true];owner(pk)[forceWrite=true];saved;user(uid)[allownull=true,forceWrite=true]
  629. "#% impex.exportItems( ""AdvancePaymentInfo"" , false );"
  630.  
  631. # ---- Extension: core ---- Type: CreditCardPaymentInfo ----
  632. "#% impex.setTargetFile( ""CreditCardPaymentInfo.csv"" );"
  633. insert_update CreditCardPaymentInfo;pk[unique=true];billingAddress(pk);ccOwner[allownull=true];code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];duplicate;issueNumber;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];number[allownull=true];original(pk)[forceWrite=true];owner(pk)[forceWrite=true];saved;subscriptionId;type(code,itemtype(code))[allownull=true];user(uid)[allownull=true,forceWrite=true];validFromMonth;validFromYear;validToMonth[allownull=true];validToYear[allownull=true]
  634. "#% impex.exportItems( ""CreditCardPaymentInfo"" , false );"
  635.  
  636. # ---- Extension: core ---- Type: DebitPaymentInfo ----
  637. "#% impex.setTargetFile( ""DebitPaymentInfo.csv"" );"
  638. insert_update DebitPaymentInfo;pk[unique=true];accountNumber[allownull=true];baOwner[allownull=true];bankIDNumber[allownull=true];bank[allownull=true];billingAddress(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];duplicate;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];original(pk)[forceWrite=true];owner(pk)[forceWrite=true];saved;user(uid)[allownull=true,forceWrite=true]
  639. "#% impex.exportItems( ""DebitPaymentInfo"" , false );"
  640.  
  641. # ---- Extension: core ---- Type: InvoicePaymentInfo ----
  642. "#% impex.setTargetFile( ""InvoicePaymentInfo.csv"" );"
  643. insert_update InvoicePaymentInfo;pk[unique=true];billingAddress(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];duplicate;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];original(pk)[forceWrite=true];owner(pk)[forceWrite=true];saved;user(uid)[allownull=true,forceWrite=true]
  644. "#% impex.exportItems( ""InvoicePaymentInfo"" , false );"
  645.  
  646. # ---- Extension: solrfacetsearch ---- Type: SolrIndexOperation ----
  647. "#% impex.setTargetFile( ""SolrIndexOperation.csv"" );"
  648. insert_update SolrIndexOperation;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endTime[dateformat=dd.MM.yyyy hh:mm:ss];external[allownull=true];id[forceWrite=true,unique=true,allownull=true];index(pk)[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];operation(code,itemtype(code))[allownull=true,forceWrite=true];owner(pk)[forceWrite=true];startTime[dateformat=dd.MM.yyyy hh:mm:ss];status(code,itemtype(code))[allownull=true]
  649. "#% impex.exportItems( ""SolrIndexOperation"" , false );"
  650.  
  651. # ---- Extension: workflow ---- Type: WorkflowActionComment ----
  652. "#% impex.setTargetFile( ""WorkflowActionComment.csv"" );"
  653. insert_update WorkflowActionComment;pk[unique=true];comment[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];user(uid);workflowAction(code)[allownull=true]
  654. "#% impex.exportItems( ""WorkflowActionComment"" , false );"
  655.  
  656. # ---- Extension: processing ---- Type: CronJobHistory ----
  657. "#% impex.setTargetFile( ""CronJobHistory.csv"" );"
  658. insert_update CronJobHistory;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];cronJob(code);cronJobCode[allownull=true,forceWrite=true];cronJobPOS;endTime[dateformat=dd.MM.yyyy hh:mm:ss];failureMessage;jobCode[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeID[allownull=true];owner(pk)[forceWrite=true];progress;result(code,itemtype(code));scheduled;startTime[forceWrite=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];status(code,itemtype(code));statusLine;userUid
  659. "#% impex.exportItems( ""CronJobHistory"" , false );"
  660.  
  661. # ---- Extension: core ---- Type: MediaContext ----
  662. "#% impex.setTargetFile( ""MediaContext.csv"" );"
  663. insert_update MediaContext;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier[unique=true,allownull=true]
  664. "#% impex.exportItems( ""MediaContext"" , false );"
  665.  
  666. # ---- Extension: promotions ---- Type: PromotionGroup ----
  667. "#% impex.setTargetFile( ""PromotionGroup.csv"" );"
  668. insert_update PromotionGroup;pk;Identifier[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  669. "#% impex.exportItems( ""PromotionGroup"" , false );"
  670.  
  671. # ---- Extension: voucher ---- Type: UserRestriction ----
  672. "#% impex.setTargetFile( ""UserRestriction.csv"" );"
  673. insert_update UserRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];positive[allownull=true];users(uid)[allownull=true];voucher(code)[allownull=true,forceWrite=true];voucherPOS
  674. "#% impex.exportItems( ""UserRestriction"" , false );"
  675.  
  676. # ---- Extension: promotions ---- Type: OrderThresholdFreeVoucherPromotion ----
  677. "#% impex.setTargetFile( ""OrderThresholdFreeVoucherPromotion.csv"" );"
  678. insert_update OrderThresholdFreeVoucherPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];freeVoucher(code);immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];thresholdTotals(pk);title
  679. "#% impex.exportItems( ""OrderThresholdFreeVoucherPromotion"" , false );"
  680.  
  681. # ---- Extension: payment ---- Type: PaymentTransaction ----
  682. "#% impex.setTargetFile( ""PaymentTransaction.csv"" );"
  683. insert_update PaymentTransaction;pk[unique=true];code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);info(pk);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code);owner(pk)[forceWrite=true];paymentProvider;plannedAmount;requestId;requestToken;versionID[forceWrite=true]
  684. "#% impex.exportItems( ""PaymentTransaction"" , false );"
  685.  
  686. # ---- Extension: core ---- Type: AuditReportConfig ----
  687. "#% impex.setTargetFile( ""AuditReportConfig.csv"" );"
  688. insert_update AuditReportConfig;pk[unique=true];active[allownull=true,forceWrite=true];checksum;code[allownull=true,forceWrite=true];content[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];version[allownull=true]
  689. "#% impex.exportItems( ""AuditReportConfig"" , false );"
  690.  
  691. # ---- Extension: validation ---- Type: ConstraintGroup ----
  692. "#% impex.setTargetFile( ""ConstraintGroup.csv"" );"
  693. insert_update ConstraintGroup;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];id[allownull=true];interfaceName[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  694. "#% impex.exportItems( ""ConstraintGroup"" , false );"
  695.  
  696. # ---- Extension: validation ---- Type: CoverageConstraintGroup ----
  697. "#% impex.setTargetFile( ""CoverageConstraintGroup.csv"" );"
  698. insert_update CoverageConstraintGroup;pk;coverageDomainID[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];id[allownull=true];interfaceName[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  699. "#% impex.exportItems( ""CoverageConstraintGroup"" , false );"
  700.  
  701. # ---- Extension: core ---- Type: IndexTestItem ----
  702. "#% impex.setTargetFile( ""IndexTestItem.csv"" );"
  703. insert_update IndexTestItem;pk[unique=true];column1[allownull=true,forceWrite=true];column2[allownull=true,forceWrite=true];column3[allownull=true,forceWrite=true];column4[allownull=true,forceWrite=true];column5[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  704. "#% impex.exportItems( ""IndexTestItem"" , false );"
  705.  
  706. # ---- Extension: workflow ---- Type: WorkflowItemAttachment ----
  707. "#% impex.setTargetFile( ""WorkflowItemAttachment.csv"" );"
  708. insert_update WorkflowItemAttachment;pk[unique=true];code[forceWrite=true];comment;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];item(pk)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];workflow(code)[allownull=true,forceWrite=true];workflowPOS
  709. "#% impex.exportItems( ""WorkflowItemAttachment"" , false );"
  710.  
  711. # ---- Extension: solrfacetsearch ---- Type: SolrQueryAggregatedStats ----
  712. "#% impex.setTargetFile( ""SolrQueryAggregatedStats.csv"" );"
  713. insert_update SolrQueryAggregatedStats;pk[unique=true];avgNumberOfResults[allownull=true];count[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];indexConfig(name)[allownull=true];language(isocode)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];query[allownull=true];time[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss]
  714. "#% impex.exportItems( ""SolrQueryAggregatedStats"" , false );"
  715.  
  716. # ---- Extension: core ---- Type: QuoteEntry ----
  717. "#% impex.setTargetFile( ""QuoteEntry.csv"" );"
  718. insert_update QuoteEntry;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));basePrice;calculated;chosenVendor(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryMode(code);deliveryPointOfService(name);discountValues;discountValuesInternal;entryGroupNumbers;entryNumber[unique=true];giveAway[allownull=true];info;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];namedDeliveryDate[dateformat=dd.MM.yyyy hh:mm:ss];order(code,version)[forceWrite=true,unique=true,allownull=true];owner(pk)[forceWrite=true];product(catalogVersion(catalog(id),version),code)[allownull=true];quantityStatus(code,itemtype(code));quantity[allownull=true];rejected[allownull=true];taxValues;taxValuesInternal;totalPrice;unit(code)[allownull=true]
  719. "#% impex.exportItems( ""QuoteEntry"" , false );"
  720.  
  721. # ---- Extension: comments ---- Type: Comment ----
  722. "#% impex.setTargetFile( ""Comment.csv"" );"
  723. insert_update Comment;pk;author(uid)[allownull=true,forceWrite=true];code[unique=true];commentType(pk)[allownull=true,forceWrite=true];component(code,domain(code))[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;relatedItems(pk);subject;text[allownull=true]
  724. "#% impex.exportItems( ""Comment"" , false );"
  725.  
  726. # ---- Extension: comments ---- Type: CommentType ----
  727. "#% impex.setTargetFile( ""CommentType.csv"" );"
  728. insert_update CommentType;pk[unique=true];code[forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];domain(code)[allownull=true,forceWrite=true];metaType(code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[forceWrite=true]
  729. "#% impex.exportItems( ""CommentType"" , false );"
  730.  
  731. # ---- Extension: promotions ---- Type: PromotionUserRestriction ----
  732. "#% impex.setTargetFile( ""PromotionUserRestriction.csv"" );"
  733. insert_update PromotionUserRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];positive[allownull=true];promotion(pk);users(uid)
  734. "#% impex.exportItems( ""PromotionUserRestriction"" , false );"
  735.  
  736. # ---- Extension: processing ---- Type: BusinessProcessParameter ----
  737. "#% impex.setTargetFile( ""BusinessProcessParameter.csv"" );"
  738. insert_update BusinessProcessParameter;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[allownull=true];owner(pk)[forceWrite=true];process(code)[allownull=true];value[allownull=true]
  739. "#% impex.exportItems( ""BusinessProcessParameter"" , false );"
  740.  
  741. # ---- Extension: core ---- Type: Cart ----
  742. "#% impex.setTargetFile( ""Cart.csv"" );"
  743. insert_update Cart;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));appliedVoucherCodes;calculated;code[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];date[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryCost;deliveryMode(code);deliveryStatus(code,itemtype(code));description;discountsIncludeDeliveryCost[allownull=true];discountsIncludePaymentCost[allownull=true];entryGroups;expirationTime[dateformat=dd.MM.yyyy hh:mm:ss];exportStatus(code,itemtype(code));globalDiscountValues;globalDiscountValuesInternal;guid;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;net[allownull=true];owner(pk)[forceWrite=true];paymentAddress(pk);paymentCost;paymentInfo(pk);paymentMode(code);paymentStatus(code,itemtype(code));previousDeliveryMode(code);quoteDiscountValuesInternal;quoteReference(code,version);saveTime[dateformat=dd.MM.yyyy hh:mm:ss];savedBy(uid);sessionId;site(uid);status(code,itemtype(code));statusInfo;store(uid);subtotal;totalDiscounts;totalPrice;totalTax;totalTaxValues;totalTaxValuesInternal;user(uid)[allownull=true]
  744. "#% impex.exportItems( ""Cart"" , false );"
  745.  
  746. # ---- Extension: basecommerce ---- Type: ReplacementEntry ----
  747. "#% impex.setTargetFile( ""ReplacementEntry.csv"" );"
  748. insert_update ReplacementEntry;pk[unique=true];action(code,itemtype(code))[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expectedQuantity;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];notes;orderEntry(entryNumber)[allownull=true];owner(pk)[forceWrite=true];reachedDate[dateformat=dd.MM.yyyy hh:mm:ss];reason(code,itemtype(code))[allownull=true];receivedQuantity;returnRequest(code);returnRequestPOS;status(code,itemtype(code))[allownull=true]
  749. "#% impex.exportItems( ""ReplacementEntry"" , false );"
  750.  
  751. # ---- Extension: promotions ---- Type: PromotionQuantityAndPricesRow ----
  752. "#% impex.setTargetFile( ""PromotionQuantityAndPricesRow.csv"" );"
  753. insert_update PromotionQuantityAndPricesRow;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];prices(pk);quantity[allownull=true]
  754. "#% impex.exportItems( ""PromotionQuantityAndPricesRow"" , false );"
  755.  
  756. # ---- Extension: processing ---- Type: AfterRetentionCleanupRule ----
  757. "#% impex.setTargetFile( ""AfterRetentionCleanupRule.csv"" );"
  758. insert_update AfterRetentionCleanupRule;pk;actionReference[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];itemFilterExpression;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];retentionTimeSeconds;retirementDateAttribute(enclosingType(code),qualifier);retirementDateExpression;retirementItemType(code)[allownull=true]
  759. "#% impex.exportItems( ""AfterRetentionCleanupRule"" , false );"
  760.  
  761. # ---- Extension: core ---- Type: Address ----
  762. "#% impex.setTargetFile( ""Address.csv"" );"
  763. insert_update Address;pk[unique=true];appartment;billingAddress[allownull=true];building;cellphone;company;contactAddress[allownull=true];country(isocode);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dateOfBirth[dateformat=dd.MM.yyyy hh:mm:ss];department;district;duplicate;email;fax;firstname;gender(code,itemtype(code));lastname;line1;line2;middlename;middlename2;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];original(pk)[forceWrite=true];phone1;phone2;pobox;postalcode;publicKey;region(country(isocode),isocode);remarks;shippingAddress[allownull=true];streetname;streetnumber;title(code);town;unloadingAddress[allownull=true];url;visibleInAddressBook
  764. "#% impex.exportItems( ""Address"" , false );"
  765.  
  766. # ---- Extension: oauth2 ---- Type: OAuthAuthorizationCode ----
  767. "#% impex.setTargetFile( ""OAuthAuthorizationCode.csv"" );"
  768. insert_update OAuthAuthorizationCode;pk;authentication;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  769. "#% impex.exportItems( ""OAuthAuthorizationCode"" , false );"
  770.  
  771. # ---- Extension: commons ---- Type: RendererTemplate ----
  772. "#% impex.setTargetFile( ""RendererTemplate.csv"" );"
  773. insert_update RendererTemplate;pk;code[unique=true,allownull=true];contextClass;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];outputMimeType;owner(pk)[forceWrite=true];rendererType(code,itemtype(code))[allownull=true]
  774. "#% impex.exportItems( ""RendererTemplate"" , false );"
  775.  
  776. # ---- Extension: auditreportservices ---- Type: AuditReportTemplate ----
  777. "#% impex.setTargetFile( ""AuditReportTemplate.csv"" );"
  778. insert_update AuditReportTemplate;pk;code[unique=true,allownull=true];contextClass;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];includeText[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];outputMimeType;owner(pk)[forceWrite=true];rendererType(code,itemtype(code))[allownull=true]
  779. "#% impex.exportItems( ""AuditReportTemplate"" , false );"
  780.  
  781. # ---- Extension: core ---- Type: Currency ----
  782. "#% impex.setTargetFile( ""Currency.csv"" );"
  783. insert_update Currency;pk;active[allownull=true];base[allownull=true];conversion[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];digits[allownull=true];isocode[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];symbol[allownull=true]
  784. "#% impex.exportItems( ""Currency"" , false );"
  785.  
  786. # ---- Extension: promotions ---- Type: OrderThresholdPerfectPartnerPromotion ----
  787. "#% impex.setTargetFile( ""OrderThresholdPerfectPartnerPromotion.csv"" );"
  788. insert_update OrderThresholdPerfectPartnerPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;discountProduct(catalogVersion(catalog(id),version),code);enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;includeDiscountedPriceInThreshold[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;productPrices(pk);restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];thresholdTotals(pk);title
  789. "#% impex.exportItems( ""OrderThresholdPerfectPartnerPromotion"" , false );"
  790.  
  791. # ---- Extension: promotions ---- Type: ProductPerfectPartnerPromotion ----
  792. "#% impex.setTargetFile( ""ProductPerfectPartnerPromotion.csv"" );"
  793. insert_update ProductPerfectPartnerPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];partnerPrices(pk);partnerProducts(catalogVersion(catalog(id),version),code);priority;productBanner(catalogVersion(catalog(id),version),code);restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  794. "#% impex.exportItems( ""ProductPerfectPartnerPromotion"" , false );"
  795.  
  796. # ---- Extension: catalog ---- Type: ClassificationAttributeValue ----
  797. "#% impex.setTargetFile( ""ClassificationAttributeValue.csv"" );"
  798. insert_update ClassificationAttributeValue;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];externalID;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];systemVersion(catalog(id),version)[forceWrite=true,unique=true,allownull=true]
  799. "#% impex.exportItems( ""ClassificationAttributeValue"" , false );"
  800.  
  801. # ---- Extension: promotions ---- Type: ProductFixedPricePromotion ----
  802. "#% impex.setTargetFile( ""ProductFixedPricePromotion.csv"" );"
  803. insert_update ProductFixedPricePromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;productBanner(catalogVersion(catalog(id),version),code);productFixedUnitPrice(pk);restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  804. "#% impex.exportItems( ""ProductFixedPricePromotion"" , false );"
  805.  
  806. # ---- Extension: core ---- Type: Country ----
  807. "#% impex.setTargetFile( ""Country.csv"" );"
  808. insert_update Country;pk;active[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];isocode[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  809. "#% impex.exportItems( ""Country"" , false );"
  810.  
  811. # ---- Extension: catalog ---- Type: Category ----
  812. "#% impex.setTargetFile( ""Category.csv"" );"
  813. insert_update Category;pk;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);detail(catalogVersion(catalog(id),version),code);logo(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);order;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code)
  814. "#% impex.exportItems( ""Category"" , false );"
  815.  
  816. # ---- Extension: catalog ---- Type: ClassificationClass ----
  817. "#% impex.setTargetFile( ""ClassificationClass.csv"" );"
  818. insert_update ClassificationClass;pk;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[forceWrite=true,unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);declaredClassificationAttributeAssignments(classificationAttribute(code,systemVersion(catalog(id),version)),classificationClass(catalogVersion(catalog(id),version),code),systemVersion(catalog(id),version));detail(catalogVersion(catalog(id),version),code);externalID;hmcXML;logo(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);order;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);revision;showEmptyAttributes[allownull=true];thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code)
  819. "#% impex.exportItems( ""ClassificationClass"" , false );"
  820.  
  821. # ---- Extension: catalog ---- Type: ConfigurationCategory ----
  822. "#% impex.setTargetFile( ""ConfigurationCategory.csv"" );"
  823. insert_update ConfigurationCategory;pk;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);detail(catalogVersion(catalog(id),version),code);logo(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);order;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code)
  824. "#% impex.exportItems( ""ConfigurationCategory"" , false );"
  825.  
  826. # ---- Extension: basecommerce ---- Type: VariantCategory ----
  827. "#% impex.setTargetFile( ""VariantCategory.csv"" );"
  828. insert_update VariantCategory;pk;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);detail(catalogVersion(catalog(id),version),code);hasImage[allownull=true];logo(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);order;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code)
  829. "#% impex.exportItems( ""VariantCategory"" , false );"
  830.  
  831. # ---- Extension: basecommerce ---- Type: VariantValueCategory ----
  832. "#% impex.setTargetFile( ""VariantValueCategory.csv"" );"
  833. insert_update VariantValueCategory;pk;catalog(id)[allownull=true];catalogVersion(catalog(id),version)[unique=true,allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];data_sheet(catalogVersion(catalog(id),version),code);detail(catalogVersion(catalog(id),version),code);logo(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];normal(catalogVersion(catalog(id),version),code);order;others(catalogVersion(catalog(id),version),code);owner(pk)[forceWrite=true];picture(catalogVersion(catalog(id),version),code);sequence;thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code)
  834. "#% impex.exportItems( ""VariantValueCategory"" , false );"
  835.  
  836. # ---- Extension: voucher ---- Type: RegularCustomerOrderTotalRestriction ----
  837. "#% impex.setTargetFile( ""RegularCustomerOrderTotalRestriction.csv"" );"
  838. insert_update RegularCustomerOrderTotalRestriction;pk[unique=true];allOrdersTotal[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];net[allownull=true];owner(pk)[forceWrite=true];positive;valueofgoodsonly[allownull=true];voucher(code)[allownull=true,forceWrite=true];voucherPOS
  839. "#% impex.exportItems( ""RegularCustomerOrderTotalRestriction"" , false );"
  840.  
  841. # ---- Extension: basecommerce ---- Type: OrderHistoryEntry ----
  842. "#% impex.setTargetFile( ""OrderHistoryEntry.csv"" );"
  843. insert_update OrderHistoryEntry;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;employee(uid);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID)[allownull=true,forceWrite=true];orderPOS;owner(pk)[forceWrite=true];previousOrderVersion(code,versionID);timestamp[forceWrite=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss]
  844. "#% impex.exportItems( ""OrderHistoryEntry"" , false );"
  845.  
  846. # ---- Extension: voucher ---- Type: DateRestriction ----
  847. "#% impex.setTargetFile( ""DateRestriction.csv"" );"
  848. insert_update DateRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endDate[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];positive;startDate[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];voucher(code)[allownull=true,forceWrite=true];voucherPOS
  849. "#% impex.exportItems( ""DateRestriction"" , false );"
  850.  
  851. # ---- Extension: promotions ---- Type: OrderThresholdFreeGiftPromotion ----
  852. "#% impex.setTargetFile( ""OrderThresholdFreeGiftPromotion.csv"" );"
  853. insert_update OrderThresholdFreeGiftPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];giftProduct(catalogVersion(catalog(id),version),code);immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];thresholdTotals(pk);title
  854. "#% impex.exportItems( ""OrderThresholdFreeGiftPromotion"" , false );"
  855.  
  856. # ---- Extension: commerceservices ---- Type: Consent ----
  857. "#% impex.setTargetFile( ""Consent.csv"" );"
  858. insert_update Consent;pk[unique=true];code[allownull=true];consentGivenDate[dateformat=dd.MM.yyyy hh:mm:ss];consentTemplate(pk)[allownull=true];consentWithdrawnDate[dateformat=dd.MM.yyyy hh:mm:ss];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];customer(uid)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  859. "#% impex.exportItems( ""Consent"" , false );"
  860.  
  861. # ---- Extension: solrfacetsearch ---- Type: SolrSearchQueryProperty ----
  862. "#% impex.setTargetFile( ""SolrSearchQueryProperty.csv"" );"
  863. insert_update SolrSearchQueryProperty;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];facetDisplayNameProvider;facetSortProvider;facetTopValuesProvider;facetType(code,itemtype(code))[allownull=true];facet[allownull=true];ftsFuzzyQueryBoost;ftsFuzzyQueryFuzziness;ftsFuzzyQueryMinTermLength;ftsFuzzyQuery[allownull=true];ftsPhraseQueryBoost;ftsPhraseQuerySlop;ftsPhraseQuery[allownull=true];ftsQueryBoost;ftsQueryMinTermLength;ftsQuery[allownull=true];ftsWildcardQueryBoost;ftsWildcardQueryMinTermLength;ftsWildcardQueryType(code,itemtype(code))[allownull=true];ftsWildcardQuery[allownull=true];includeInResponse[allownull=true];indexedProperty(pk)[forceWrite=true,unique=true,allownull=true];indexedPropertyPOS;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority[allownull=true];searchQueryTemplate(indexedType(identifier,indexName),name)[forceWrite=true,unique=true,allownull=true];searchQueryTemplatePOS;useForHighlighting[allownull=true]
  864. "#% impex.exportItems( ""SolrSearchQueryProperty"" , false );"
  865.  
  866. # ---- Extension: core ---- Type: MediaFormat ----
  867. "#% impex.setTargetFile( ""MediaFormat.csv"" );"
  868. insert_update MediaFormat;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];externalID;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];qualifier[unique=true,allownull=true]
  869. "#% impex.exportItems( ""MediaFormat"" , false );"
  870.  
  871. # ---- Extension: solrfacetsearch ---- Type: SolrValueRangeSet ----
  872. "#% impex.setTargetFile( ""SolrValueRangeSet.csv"" );"
  873. insert_update SolrValueRangeSet;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[unique=true,allownull=true];owner(pk)[forceWrite=true];qualifier;type[allownull=true]
  874. "#% impex.exportItems( ""SolrValueRangeSet"" , false );"
  875.  
  876. # ---- Extension: core ---- Type: AbstractContactInfo ----
  877. "#% impex.setTargetFile( ""AbstractContactInfo.csv"" );"
  878. insert_update AbstractContactInfo;pk[unique=true];code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];user(uid)[allownull=true];userPOS
  879. "#% impex.exportItems( ""AbstractContactInfo"" , false );"
  880.  
  881. # ---- Extension: core ---- Type: PhoneContactInfo ----
  882. "#% impex.setTargetFile( ""PhoneContactInfo.csv"" );"
  883. insert_update PhoneContactInfo;pk[unique=true];code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];phoneNumber[allownull=true];type(code,itemtype(code))[allownull=true];user(uid)[allownull=true];userPOS
  884. "#% impex.exportItems( ""PhoneContactInfo"" , false );"
  885.  
  886. # ---- Extension: basecommerce ---- Type: OrderEntryCancelRecordEntry ----
  887. "#% impex.setTargetFile( ""OrderEntryCancelRecordEntry.csv"" );"
  888. insert_update OrderEntryCancelRecordEntry;pk[unique=true];cancelReason(code,itemtype(code));cancelRequestQuantity;cancelledQuantity;code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modificationRecordEntry(code)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];notes;orderEntry(entryNumber,order(code,versionID));originalOrderEntry(entryNumber,order(code,versionID));owner(pk)[forceWrite=true]
  889. "#% impex.exportItems( ""OrderEntryCancelRecordEntry"" , false );"
  890.  
  891. # ---- Extension: europe1 ---- Type: PriceRow ----
  892. "#% impex.setTargetFile( ""PriceRow.csv"" );"
  893. insert_update PriceRow;pk[unique=true];catalogVersion(catalog(id),version);channel(code,itemtype(code));creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];dateRange[dateformat=dd.MM.yyyy hh:mm:ss];endTime[dateformat=dd.MM.yyyy hh:mm:ss];giveAwayPrice[allownull=true];matchValue;minqtd[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];net[allownull=true];owner(pk)[forceWrite=true];pg(code,itemtype(code))[forceWrite=true];price[allownull=true];product(catalogVersion(catalog(id),version),code)[forceWrite=true];productId[forceWrite=true];productMatchQualifier;startTime[dateformat=dd.MM.yyyy hh:mm:ss];ug(code,itemtype(code));unit(code)[allownull=true];unitFactor[allownull=true];user(uid);userMatchQualifier
  894. "#% impex.exportItems( ""PriceRow"" , false );"
  895.  
  896. # ---- Extension: catalog ---- Type: ClassificationAttribute ----
  897. "#% impex.setTargetFile( ""ClassificationAttribute.csv"" );"
  898. insert_update ClassificationAttribute;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultAttributeValues(code,systemVersion(catalog(id),version));externalID;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];systemVersion(catalog(id),version)[unique=true,allownull=true]
  899. "#% impex.exportItems( ""ClassificationAttribute"" , false );"
  900.  
  901. # ---- Extension: promotions ---- Type: PromotionProductRestriction ----
  902. "#% impex.setTargetFile( ""PromotionProductRestriction.csv"" );"
  903. insert_update PromotionProductRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];products(catalogVersion(catalog(id),version),code);promotion(pk)
  904. "#% impex.exportItems( ""PromotionProductRestriction"" , false );"
  905.  
  906. # ---- Extension: promotions ---- Type: PromotionPriceRow ----
  907. "#% impex.setTargetFile( ""PromotionPriceRow.csv"" );"
  908. insert_update PromotionPriceRow;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];price[allownull=true]
  909. "#% impex.exportItems( ""PromotionPriceRow"" , false );"
  910.  
  911. # ---- Extension: basecommerce ---- Type: OrderReplacementRecordEntry ----
  912. "#% impex.setTargetFile( ""OrderReplacementRecordEntry.csv"" );"
  913. insert_update OrderReplacementRecordEntry;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expectedQuantity;failedMessage;modificationRecord(identifier)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];notes;originalVersion(pk)[allownull=true,forceWrite=true];owner(pk)[forceWrite=true];principal(uid);returnStatus(code,itemtype(code));status(code,itemtype(code))[allownull=true];timestamp[forceWrite=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss]
  914. "#% impex.exportItems( ""OrderReplacementRecordEntry"" , false );"
  915.  
  916. # ---- Extension: promotions ---- Type: PromotionOrderAdjustTotalAction ----
  917. "#% impex.setTargetFile( ""PromotionOrderAdjustTotalAction.csv"" );"
  918. insert_update PromotionOrderAdjustTotalAction;pk[unique=true];amount;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];guid;markedApplied[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];promotionResult(pk)
  919. "#% impex.exportItems( ""PromotionOrderAdjustTotalAction"" , false );"
  920.  
  921. # ---- Extension: promotions ---- Type: OrderThresholdDiscountPromotion ----
  922. "#% impex.setTargetFile( ""OrderThresholdDiscountPromotion.csv"" );"
  923. insert_update OrderThresholdDiscountPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;discountPrices(pk);enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];thresholdTotals(pk);title
  924. "#% impex.exportItems( ""OrderThresholdDiscountPromotion"" , false );"
  925.  
  926. # ---- Extension: promotions ---- Type: ProductPercentageDiscountPromotion ----
  927. "#% impex.setTargetFile( ""ProductPercentageDiscountPromotion.csv"" );"
  928. insert_update ProductPercentageDiscountPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];percentageDiscount;priority;productBanner(catalogVersion(catalog(id),version),code);restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  929. "#% impex.exportItems( ""ProductPercentageDiscountPromotion"" , false );"
  930.  
  931. # ---- Extension: processing ---- Type: SimpleAction ----
  932. "#% impex.setTargetFile( ""SimpleAction.csv"" );"
  933. insert_update SimpleAction;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];target[allownull=true,forceWrite=true];type(code,itemtype(code))[allownull=true,forceWrite=true]
  934. "#% impex.exportItems( ""SimpleAction"" , false );"
  935.  
  936. # ---- Extension: validation ---- Type: TypeConstraint ----
  937. "#% impex.setTargetFile( ""TypeConstraint.csv"" );"
  938. insert_update TypeConstraint;pk;active[allownull=true];annotation[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];id[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];severity(code,itemtype(code));target;type(code)
  939. "#% impex.exportItems( ""TypeConstraint"" , false );"
  940.  
  941. # ---- Extension: validation ---- Type: DynamicConstraint ----
  942. "#% impex.setTargetFile( ""DynamicConstraint.csv"" );"
  943. insert_update DynamicConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expression[allownull=true];id[unique=true,allownull=true];language(code,itemtype(code))[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];severity(code,itemtype(code));target;type(code)
  944. "#% impex.exportItems( ""DynamicConstraint"" , false );"
  945.  
  946. # ---- Extension: validation ---- Type: XorNullReferenceConstraint ----
  947. "#% impex.setTargetFile( ""XorNullReferenceConstraint.csv"" );"
  948. insert_update XorNullReferenceConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];firstFieldName[allownull=true];id[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];secondFieldName[allownull=true];severity(code,itemtype(code));target;type(code)
  949. "#% impex.exportItems( ""XorNullReferenceConstraint"" , false );"
  950.  
  951. # ---- Extension: oauth2 ---- Type: BruteForceOAuthDisabledAudit ----
  952. "#% impex.setTargetFile( ""BruteForceOAuthDisabledAudit.csv"" );"
  953. insert_update BruteForceOAuthDisabledAudit;pk[unique=true];changingApplication;changingUser;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];failedOAuthAuthorizations[allownull=true,forceWrite=true];ipAddress[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];uid[allownull=true,forceWrite=true];userPK[allownull=true,forceWrite=true]
  954. "#% impex.exportItems( ""BruteForceOAuthDisabledAudit"" , false );"
  955.  
  956. # ---- Extension: promotions ---- Type: ProductSteppedMultiBuyPromotion ----
  957. "#% impex.setTargetFile( ""ProductSteppedMultiBuyPromotion.csv"" );"
  958. insert_update ProductSteppedMultiBuyPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];priority;productBanner(catalogVersion(catalog(id),version),code);qualifyingCountsAndBundlePrices(pk);restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  959. "#% impex.exportItems( ""ProductSteppedMultiBuyPromotion"" , false );"
  960.  
  961. # ---- Extension: workflow ---- Type: WorkflowDecisionTemplate ----
  962. "#% impex.setTargetFile( ""WorkflowDecisionTemplate.csv"" );"
  963. insert_update WorkflowDecisionTemplate;pk;actionTemplate(code);code[forceWrite=true,unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true]
  964. "#% impex.exportItems( ""WorkflowDecisionTemplate"" , false );"
  965.  
  966. # ---- Extension: workflow ---- Type: WorkflowTemplate ----
  967. "#% impex.setTargetFile( ""WorkflowTemplate.csv"" );"
  968. insert_update WorkflowTemplate;pk;activationScript;active;alternativeDataSourceID;changeRecordingEnabled;code[forceWrite=true,unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];emailAddress;emailNotificationTemplate(code);errorMode(code,itemtype(code));logLevelDatabase(code,itemtype(code));logLevelFile(code,itemtype(code));logToDatabase;logToFile;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup;nodeID[forceWrite=true];owner(uid)[allownull=true,forceWrite=true];priority;removeOnExit;requestAbort;requestAbortStep;retry[allownull=true];sendEmail;sessionContextValues;sessionCurrency(isocode);sessionLanguage(isocode);sessionUser(uid);singleExecutable
  969. "#% impex.exportItems( ""WorkflowTemplate"" , false );"
  970.  
  971. # ---- Extension: promotions ---- Type: PromotionOrderChangeDeliveryModeAction ----
  972. "#% impex.setTargetFile( ""PromotionOrderChangeDeliveryModeAction.csv"" );"
  973. insert_update PromotionOrderChangeDeliveryModeAction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryMode(code)[allownull=true];guid;markedApplied[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];promotionResult(pk)
  974. "#% impex.exportItems( ""PromotionOrderChangeDeliveryModeAction"" , false );"
  975.  
  976. # ---- Extension: solrfacetsearch ---- Type: ComposedIndexedType ----
  977. "#% impex.setTargetFile( ""ComposedIndexedType.csv"" );"
  978. insert_update ComposedIndexedType;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];indexedType[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  979. "#% impex.exportItems( ""ComposedIndexedType"" , false );"
  980.  
  981. # ---- Extension: validation ---- Type: AttributeConstraint ----
  982. "#% impex.setTargetFile( ""AttributeConstraint.csv"" );"
  983. insert_update AttributeConstraint;pk;active[allownull=true];annotation[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  984. "#% impex.exportItems( ""AttributeConstraint"" , false );"
  985.  
  986. # ---- Extension: validation ---- Type: AssertFalseConstraint ----
  987. "#% impex.setTargetFile( ""AssertFalseConstraint.csv"" );"
  988. insert_update AssertFalseConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  989. "#% impex.exportItems( ""AssertFalseConstraint"" , false );"
  990.  
  991. # ---- Extension: validation ---- Type: AssertTrueConstraint ----
  992. "#% impex.setTargetFile( ""AssertTrueConstraint.csv"" );"
  993. insert_update AssertTrueConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  994. "#% impex.exportItems( ""AssertTrueConstraint"" , false );"
  995.  
  996. # ---- Extension: validation ---- Type: DecimalMaxConstraint ----
  997. "#% impex.setTargetFile( ""DecimalMaxConstraint.csv"" );"
  998. insert_update DecimalMaxConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code);value[allownull=true]
  999. "#% impex.exportItems( ""DecimalMaxConstraint"" , false );"
  1000.  
  1001. # ---- Extension: validation ---- Type: DecimalMinConstraint ----
  1002. "#% impex.setTargetFile( ""DecimalMinConstraint.csv"" );"
  1003. insert_update DecimalMinConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code);value[allownull=true]
  1004. "#% impex.exportItems( ""DecimalMinConstraint"" , false );"
  1005.  
  1006. # ---- Extension: validation ---- Type: DigitsConstraint ----
  1007. "#% impex.setTargetFile( ""DigitsConstraint.csv"" );"
  1008. insert_update DigitsConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);fraction[allownull=true];id[unique=true,allownull=true];integer[allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1009. "#% impex.exportItems( ""DigitsConstraint"" , false );"
  1010.  
  1011. # ---- Extension: validation ---- Type: FutureConstraint ----
  1012. "#% impex.setTargetFile( ""FutureConstraint.csv"" );"
  1013. insert_update FutureConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1014. "#% impex.exportItems( ""FutureConstraint"" , false );"
  1015.  
  1016. # ---- Extension: validation ---- Type: HybrisDecimalMaxConstraint ----
  1017. "#% impex.setTargetFile( ""HybrisDecimalMaxConstraint.csv"" );"
  1018. insert_update HybrisDecimalMaxConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code);value[allownull=true]
  1019. "#% impex.exportItems( ""HybrisDecimalMaxConstraint"" , false );"
  1020.  
  1021. # ---- Extension: validation ---- Type: HybrisDecimalMinConstraint ----
  1022. "#% impex.setTargetFile( ""HybrisDecimalMinConstraint.csv"" );"
  1023. insert_update HybrisDecimalMinConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code);value[allownull=true]
  1024. "#% impex.exportItems( ""HybrisDecimalMinConstraint"" , false );"
  1025.  
  1026. # ---- Extension: validation ---- Type: MaxConstraint ----
  1027. "#% impex.setTargetFile( ""MaxConstraint.csv"" );"
  1028. insert_update MaxConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code);value[allownull=true]
  1029. "#% impex.exportItems( ""MaxConstraint"" , false );"
  1030.  
  1031. # ---- Extension: validation ---- Type: MinConstraint ----
  1032. "#% impex.setTargetFile( ""MinConstraint.csv"" );"
  1033. insert_update MinConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code);value[allownull=true]
  1034. "#% impex.exportItems( ""MinConstraint"" , false );"
  1035.  
  1036. # ---- Extension: validation ---- Type: NotBlankConstraint ----
  1037. "#% impex.setTargetFile( ""NotBlankConstraint.csv"" );"
  1038. insert_update NotBlankConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1039. "#% impex.exportItems( ""NotBlankConstraint"" , false );"
  1040.  
  1041. # ---- Extension: validation ---- Type: NotEmptyConstraint ----
  1042. "#% impex.setTargetFile( ""NotEmptyConstraint.csv"" );"
  1043. insert_update NotEmptyConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1044. "#% impex.exportItems( ""NotEmptyConstraint"" , false );"
  1045.  
  1046. # ---- Extension: validation ---- Type: NotNullConstraint ----
  1047. "#% impex.setTargetFile( ""NotNullConstraint.csv"" );"
  1048. insert_update NotNullConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1049. "#% impex.exportItems( ""NotNullConstraint"" , false );"
  1050.  
  1051. # ---- Extension: validation ---- Type: NullConstraint ----
  1052. "#% impex.setTargetFile( ""NullConstraint.csv"" );"
  1053. insert_update NullConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1054. "#% impex.exportItems( ""NullConstraint"" , false );"
  1055.  
  1056. # ---- Extension: validation ---- Type: PastConstraint ----
  1057. "#% impex.setTargetFile( ""PastConstraint.csv"" );"
  1058. insert_update PastConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1059. "#% impex.exportItems( ""PastConstraint"" , false );"
  1060.  
  1061. # ---- Extension: validation ---- Type: PatternConstraint ----
  1062. "#% impex.setTargetFile( ""PatternConstraint.csv"" );"
  1063. insert_update PatternConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);flags(code,itemtype(code))[allownull=true];id[unique=true,allownull=true];languages(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;regexp[allownull=true];severity(code,itemtype(code));target;type(code)
  1064. "#% impex.exportItems( ""PatternConstraint"" , false );"
  1065.  
  1066. # ---- Extension: validation ---- Type: SizeConstraint ----
  1067. "#% impex.setTargetFile( ""SizeConstraint.csv"" );"
  1068. insert_update SizeConstraint;pk;active[allownull=true];annotation[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];descriptor(enclosingType(code),qualifier);id[unique=true,allownull=true];languages(isocode);max[allownull=true];min[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier;severity(code,itemtype(code));target;type(code)
  1069. "#% impex.exportItems( ""SizeConstraint"" , false );"
  1070.  
  1071. # ---- Extension: core ---- Type: DeliveryMode ----
  1072. "#% impex.setTargetFile( ""DeliveryMode.csv"" );"
  1073. insert_update DeliveryMode;pk;active[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];supportedPaymentModes(code);supportedPaymentModesInternal
  1074. "#% impex.exportItems( ""DeliveryMode"" , false );"
  1075.  
  1076. # ---- Extension: commerceservices ---- Type: PickUpDeliveryMode ----
  1077. "#% impex.setTargetFile( ""PickUpDeliveryMode.csv"" );"
  1078. insert_update PickUpDeliveryMode;pk;active[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];supportedMode(code,itemtype(code));supportedPaymentModes(code);supportedPaymentModesInternal
  1079. "#% impex.exportItems( ""PickUpDeliveryMode"" , false );"
  1080.  
  1081. # ---- Extension: deliveryzone ---- Type: ZoneDeliveryMode ----
  1082. "#% impex.setTargetFile( ""ZoneDeliveryMode.csv"" );"
  1083. insert_update ZoneDeliveryMode;pk;active[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];net[allownull=true];owner(pk)[allownull=true,forceWrite=true];propertyName[allownull=true];supportedPaymentModes(code);supportedPaymentModesInternal
  1084. "#% impex.exportItems( ""ZoneDeliveryMode"" , false );"
  1085.  
  1086. # ---- Extension: basecommerce ---- Type: StockLevelHistoryEntry ----
  1087. "#% impex.setTargetFile( ""StockLevelHistoryEntry.csv"" );"
  1088. insert_update StockLevelHistoryEntry;pk[unique=true];actual[allownull=true];comment;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];reserved[allownull=true];stockLevel(pk)[allownull=true,forceWrite=true];stockLevelPOS;updateDate[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];updateType(code,itemtype(code))
  1089. "#% impex.exportItems( ""StockLevelHistoryEntry"" , false );"
  1090.  
  1091. # ---- Extension: core ---- Type: UserRight ----
  1092. "#% impex.setTargetFile( ""UserRight.csv"" , true, 0, 0 );"
  1093. #SPECIAL CASE: Type UserRight will be exported with special logic (without header definition), see https://wiki.hybris.com/x/PIFvAg
  1094. "#% impex.exportItems( ""UserRight"" , false );"
  1095.  
  1096. # ---- Extension: ecrpimbackoffice ---- Type: FactoryCode ----
  1097. "#% impex.setTargetFile( ""FactoryCode.csv"" );"
  1098. insert_update FactoryCode;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];factoryNumber;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1099. "#% impex.exportItems( ""FactoryCode"" , false );"
  1100.  
  1101. # ---- Extension: catalog ---- Type: ClassificationAttributeUnit ----
  1102. "#% impex.setTargetFile( ""ClassificationAttributeUnit.csv"" );"
  1103. insert_update ClassificationAttributeUnit;pk;code[unique=true,allownull=true];conversionFactor;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];externalID;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];symbol[allownull=true];systemVersion(catalog(id),version)[forceWrite=true,unique=true,allownull=true];unitType[unique=true]
  1104. "#% impex.exportItems( ""ClassificationAttributeUnit"" , false );"
  1105.  
  1106. # ---- Extension: advancedsavedquery ---- Type: SimpleAdvancedSavedQuerySearchParameter ----
  1107. "#% impex.setTargetFile( ""SimpleAdvancedSavedQuerySearchParameter.csv"" );"
  1108. insert_update SimpleAdvancedSavedQuerySearchParameter;pk[unique=true];comparator(code,itemtype(code))[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];emptyHandling(code,itemtype(code))[allownull=true];joinAlias;lower;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];searchParameterName[allownull=true];valueType(code);wherePart(pk)[allownull=true]
  1109. "#% impex.exportItems( ""SimpleAdvancedSavedQuerySearchParameter"" , false );"
  1110.  
  1111. # ---- Extension: promotions ---- Type: ProductBundlePromotion ----
  1112. "#% impex.setTargetFile( ""ProductBundlePromotion.csv"" );"
  1113. insert_update ProductBundlePromotion;pk[unique=true];PromotionGroup(Identifier);bundlePrices(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];priority;productBanner(catalogVersion(catalog(id),version),code);restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  1114. "#% impex.exportItems( ""ProductBundlePromotion"" , false );"
  1115.  
  1116. # ---- Extension: workflow ---- Type: WorkflowDecision ----
  1117. "#% impex.setTargetFile( ""WorkflowDecision.csv"" );"
  1118. insert_update WorkflowDecision;pk;action(code);code[forceWrite=true,unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1119. "#% impex.exportItems( ""WorkflowDecision"" , false );"
  1120.  
  1121. # ---- Extension: core ---- Type: MediaContainer ----
  1122. "#% impex.setTargetFile( ""MediaContainer.csv"" );"
  1123. insert_update MediaContainer;pk;catalogVersion(catalog(id),version)[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier[unique=true,allownull=true]
  1124. "#% impex.exportItems( ""MediaContainer"" , false );"
  1125.  
  1126. # ---- Extension: basecommerce ---- Type: Consignment ----
  1127. "#% impex.setTargetFile( ""Consignment.csv"" );"
  1128. insert_update Consignment;pk[unique=true];carrier;code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryMode(code)[forceWrite=true];deliveryPointOfService(name);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];namedDeliveryDate[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];order(code)[forceWrite=true];owner(pk)[allownull=true,forceWrite=true];shippingAddress(pk)[allownull=true,forceWrite=true];shippingDate[dateformat=dd.MM.yyyy hh:mm:ss];status(code,itemtype(code))[allownull=true];trackingID;warehouse(pk)[allownull=true,forceWrite=true]
  1129. "#% impex.exportItems( ""Consignment"" , false );"
  1130.  
  1131. # ---- Extension: commerceservices ---- Type: SolrSort ----
  1132. "#% impex.setTargetFile( ""SolrSort.csv"" );"
  1133. insert_update SolrSort;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];indexedType(identifier,indexName)[unique=true,allownull=true];indexedTypePOS;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];useBoost[allownull=true]
  1134. "#% impex.exportItems( ""SolrSort"" , false );"
  1135.  
  1136. # ---- Extension: basecommerce ---- Type: WeekdayOpeningDay ----
  1137. "#% impex.setTargetFile( ""WeekdayOpeningDay.csv"" );"
  1138. insert_update WeekdayOpeningDay;pk;closingTime[dateformat=dd.MM.yyyy hh:mm:ss];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dayOfWeek(code,itemtype(code))[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];openingSchedule(code)[unique=true];openingTime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1139. "#% impex.exportItems( ""WeekdayOpeningDay"" , false );"
  1140.  
  1141. # ---- Extension: solrfacetsearch ---- Type: SolrCategoryRedirect ----
  1142. "#% impex.setTargetFile( ""SolrCategoryRedirect.csv"" );"
  1143. insert_update SolrCategoryRedirect;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];redirectItem(catalogVersion(catalog(id),version),code)[allownull=true]
  1144. "#% impex.exportItems( ""SolrCategoryRedirect"" , false );"
  1145.  
  1146. # ---- Extension: solrfacetsearch ---- Type: SolrSynonymConfig ----
  1147. "#% impex.setTargetFile( ""SolrSynonymConfig.csv"" );"
  1148. insert_update SolrSynonymConfig;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];facetSearchConfig(name);facetSearchConfigPOS;language(isocode)[allownull=true];languagePOS;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];synonymFrom[allownull=true];synonymTo
  1149. "#% impex.exportItems( ""SolrSynonymConfig"" , false );"
  1150.  
  1151. # ---- Extension: solrfacetsearch ---- Type: SolrStopWord ----
  1152. "#% impex.setTargetFile( ""SolrStopWord.csv"" );"
  1153. insert_update SolrStopWord;pk[unique=true];StopWord[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];facetSearchConfig(name);facetSearchConfigPOS;language(isocode)[allownull=true];languagePOS;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1154. "#% impex.exportItems( ""SolrStopWord"" , false );"
  1155.  
  1156. # ---- Extension: processing ---- Type: Task ----
  1157. "#% impex.setTargetFile( ""Task.csv"" );"
  1158. insert_update Task;pk[unique=true];context;contextItem(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionDate[dateformat=dd.MM.yyyy hh:mm:ss];executionHourMillis;executionTimeMillis;expirationDate[dateformat=dd.MM.yyyy hh:mm:ss];expirationTimeMillis;failed;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup;nodeId;owner(pk)[allownull=true,forceWrite=true];retry;runnerBean[allownull=true];runningOnClusterNode
  1159. "#% impex.exportItems( ""Task"" , false );"
  1160.  
  1161. # ---- Extension: processing ---- Type: DistributedProcessTransitionTask ----
  1162. "#% impex.setTargetFile( ""DistributedProcessTransitionTask.csv"" );"
  1163. insert_update DistributedProcessTransitionTask;pk[unique=true];context;contextItem(code)[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionDate[dateformat=dd.MM.yyyy hh:mm:ss];executionHourMillis;executionTimeMillis;expirationDate[dateformat=dd.MM.yyyy hh:mm:ss];expirationTimeMillis;failed;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup;nodeId;owner(pk)[allownull=true,forceWrite=true];retry;runnerBean[allownull=true];runningOnClusterNode;state(code,itemtype(code))[allownull=true,forceWrite=true]
  1164. "#% impex.exportItems( ""DistributedProcessTransitionTask"" , false );"
  1165.  
  1166. # ---- Extension: processing ---- Type: DistributedProcessWorkerTask ----
  1167. "#% impex.setTargetFile( ""DistributedProcessWorkerTask.csv"" );"
  1168. insert_update DistributedProcessWorkerTask;pk[unique=true];conditionId[allownull=true,forceWrite=true];context;contextItem(executionId,id,process(code),type(code,itemtype(code)))[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionDate[dateformat=dd.MM.yyyy hh:mm:ss];executionHourMillis;executionTimeMillis;expirationDate[dateformat=dd.MM.yyyy hh:mm:ss];expirationTimeMillis;failed;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup;nodeId;owner(pk)[allownull=true,forceWrite=true];retry;runnerBean[allownull=true];runningOnClusterNode
  1169. "#% impex.exportItems( ""DistributedProcessWorkerTask"" , false );"
  1170.  
  1171. # ---- Extension: processing ---- Type: ProcessTask ----
  1172. "#% impex.setTargetFile( ""ProcessTask.csv"" );"
  1173. insert_update ProcessTask;pk[unique=true];action[allownull=true,forceWrite=true];context;contextItem(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionDate[dateformat=dd.MM.yyyy hh:mm:ss];executionHourMillis;executionTimeMillis;expirationDate[dateformat=dd.MM.yyyy hh:mm:ss];expirationTimeMillis;failed;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup;nodeId;owner(pk)[allownull=true,forceWrite=true];process(code)[allownull=true];retry;runnerBean[allownull=true];runningOnClusterNode
  1174. "#% impex.exportItems( ""ProcessTask"" , false );"
  1175.  
  1176. # ---- Extension: processing ---- Type: ScriptingTask ----
  1177. "#% impex.setTargetFile( ""ScriptingTask.csv"" );"
  1178. insert_update ScriptingTask;pk[unique=true];context;contextItem(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionDate[dateformat=dd.MM.yyyy hh:mm:ss];executionHourMillis;executionTimeMillis;expirationDate[dateformat=dd.MM.yyyy hh:mm:ss];expirationTimeMillis;failed;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup;nodeId;owner(pk)[allownull=true,forceWrite=true];retry;runnerBean[allownull=true];runningOnClusterNode;scriptURI[allownull=true]
  1179. "#% impex.exportItems( ""ScriptingTask"" , false );"
  1180.  
  1181. # ---- Extension: processing ---- Type: TriggerTask ----
  1182. "#% impex.setTargetFile( ""TriggerTask.csv"" );"
  1183. insert_update TriggerTask;pk[unique=true];context;contextItem(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionDate[dateformat=dd.MM.yyyy hh:mm:ss];executionHourMillis;executionTimeMillis;expirationDate[dateformat=dd.MM.yyyy hh:mm:ss];expirationTimeMillis;failed;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeGroup;nodeId;owner(pk)[allownull=true,forceWrite=true];retry;runnerBean[allownull=true];runningOnClusterNode;trigger(pk)[allownull=true]
  1184. "#% impex.exportItems( ""TriggerTask"" , false );"
  1185.  
  1186. # ---- Extension: core ---- Type: Unit ----
  1187. "#% impex.setTargetFile( ""Unit.csv"" );"
  1188. insert_update Unit;pk;code[unique=true,allownull=true];conversion;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];unitType[allownull=true]
  1189. "#% impex.exportItems( ""Unit"" , false );"
  1190.  
  1191. # ---- Extension: basecommerce ---- Type: SpecialOpeningDay ----
  1192. "#% impex.setTargetFile( ""SpecialOpeningDay.csv"" );"
  1193. insert_update SpecialOpeningDay;pk;closed[allownull=true];closingTime[dateformat=dd.MM.yyyy hh:mm:ss];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];date[unique=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];openingSchedule(code)[unique=true];openingTime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1194. "#% impex.exportItems( ""SpecialOpeningDay"" , false );"
  1195.  
  1196. # ---- Extension: core ---- Type: SavedValueEntry ----
  1197. "#% impex.setTargetFile( ""SavedValueEntry.csv"" );"
  1198. insert_update SavedValueEntry;pk[unique=true];OldValueAttributeDescriptor(enclosingType(code),qualifier)[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedAttribute[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];newValue;oldValue;owner(pk)[allownull=true,forceWrite=true];parent(pk)[allownull=true,forceWrite=true]
  1199. "#% impex.exportItems( ""SavedValueEntry"" , false );"
  1200.  
  1201. # ---- Extension: catalog ---- Type: Agreement ----
  1202. "#% impex.setTargetFile( ""Agreement.csv"" );"
  1203. insert_update Agreement;pk;Catalog(id)[allownull=true];buyer(uid);buyerContact(uid);catalogVersion(catalog(id),version);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);enddate[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];id[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];startdate[dateformat=dd.MM.yyyy hh:mm:ss];supplier(uid);supplierContact(uid)
  1204. "#% impex.exportItems( ""Agreement"" , false );"
  1205.  
  1206. # ---- Extension: core ---- Type: StoredHttpSession ----
  1207. "#% impex.setTargetFile( ""StoredHttpSession.csv"" );"
  1208. insert_update StoredHttpSession;pk[unique=true];clusterId[allownull=true,forceWrite=true];contextRoot[forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];extension[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];serializedSession;sessionId[allownull=true,forceWrite=true]
  1209. "#% impex.exportItems( ""StoredHttpSession"" , false );"
  1210.  
  1211. # ---- Extension: commerceservices ---- Type: StoreLocatorFeature ----
  1212. "#% impex.setTargetFile( ""StoreLocatorFeature.csv"" );"
  1213. insert_update StoreLocatorFeature;pk;code[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];icon(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1214. "#% impex.exportItems( ""StoreLocatorFeature"" , false );"
  1215.  
  1216. # ---- Extension: core ---- Type: CartEntry ----
  1217. "#% impex.setTargetFile( ""CartEntry.csv"" );"
  1218. insert_update CartEntry;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));basePrice;calculated;chosenVendor(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryMode(code);deliveryPointOfService(name);discountValues;discountValuesInternal;entryGroupNumbers;entryNumber[unique=true];giveAway[allownull=true];info;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];namedDeliveryDate[dateformat=dd.MM.yyyy hh:mm:ss];order(code)[forceWrite=true,unique=true,allownull=true];owner(pk)[allownull=true,forceWrite=true];product(catalogVersion(catalog(id),version),code)[allownull=true];quantityStatus(code,itemtype(code));quantity[allownull=true];rejected[allownull=true];taxValues;taxValuesInternal;totalPrice;unit(code)[allownull=true]
  1219. "#% impex.exportItems( ""CartEntry"" , false );"
  1220.  
  1221. # ---- Extension: solrfacetsearch ---- Type: SolrIndexedProperty ----
  1222. "#% impex.setTargetFile( ""SolrIndexedProperty.csv"" );"
  1223. insert_update SolrIndexedProperty;pk[unique=true];categoryField;classAttributeAssignment(classificationAttribute(code,systemVersion(catalog(id),version)),classificationClass(catalogVersion(catalog(id),version),code),systemVersion(catalog(id),version));creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency[allownull=true];customFacetSortProvider;exportId;facetDisplayNameProvider;facetSort(code,itemtype(code));facetType(code,itemtype(code));facet[allownull=true];fieldValueProvider;ftsFuzzyQuery;ftsFuzzyQueryBoost;ftsFuzzyQueryFuzziness;ftsFuzzyQueryMinTermLength;ftsPhraseQuery;ftsPhraseQueryBoost;ftsPhraseQuerySlop;ftsQuery;ftsQueryBoost;ftsQueryMinTermLength;ftsWildcardQuery;ftsWildcardQueryBoost;ftsWildcardQueryMinTermLength;ftsWildcardQueryType(code,itemtype(code));includeInResponse;localized[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];multiValue[allownull=true];name[allownull=true,forceWrite=true];owner(pk)[allownull=true,forceWrite=true];priority;rangeSet(name);solrIndexedType(identifier,indexName);solrIndexedTypePOS;sortableType(code,itemtype(code));topValuesProvider;type(code,itemtype(code))[allownull=true];useForAutocomplete[allownull=true];useForHighlighting[allownull=true];useForSpellchecking[allownull=true];valueProviderParameter;valueProviderParameters();visible[allownull=true]
  1224. "#% impex.exportItems( ""SolrIndexedProperty"" , false );"
  1225.  
  1226. # ---- Extension: promotions ---- Type: PromotionOrderEntryAdjustAction ----
  1227. "#% impex.setTargetFile( ""PromotionOrderEntryAdjustAction.csv"" );"
  1228. insert_update PromotionOrderEntryAdjustAction;pk[unique=true];amount;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];guid;markedApplied[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];orderEntryNumber;orderEntryProduct(catalogVersion(catalog(id),version),code);orderEntryQuantity;owner(pk)[allownull=true,forceWrite=true];promotionResult(pk)
  1229. "#% impex.exportItems( ""PromotionOrderEntryAdjustAction"" , false );"
  1230.  
  1231. # ---- Extension: core ---- Type: DerivedMedia ----
  1232. "#% impex.setTargetFile( ""DerivedMedia.csv"" );"
  1233. insert_update DerivedMedia;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];dataPK[allownull=true];location;locationHash;media(catalogVersion(catalog(id),version),code)[allownull=true];mime;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];realFileName;size;version[allownull=true]
  1234. "#% impex.exportItems( ""DerivedMedia"" , false );"
  1235.  
  1236. # ---- Extension: core ---- Type: SavedQuery ----
  1237. "#% impex.setTargetFile( ""SavedQuery.csv"" );"
  1238. insert_update SavedQuery;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];params(value(code));paramtypes(code);query[allownull=true];resultType(code)[allownull=true]
  1239. "#% impex.exportItems( ""SavedQuery"" , false );"
  1240.  
  1241. # ---- Extension: advancedsavedquery ---- Type: AdvancedSavedQuery ----
  1242. "#% impex.setTargetFile( ""AdvancedSavedQuery.csv"" );"
  1243. insert_update AdvancedSavedQuery;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];paramtypes(code);query[allownull=true];resultType(code)[allownull=true]
  1244. "#% impex.exportItems( ""AdvancedSavedQuery"" , false );"
  1245.  
  1246. # ---- Extension: voucher ---- Type: RegularCustomerOrderQuantityRestriction ----
  1247. "#% impex.setTargetFile( ""RegularCustomerOrderQuantityRestriction.csv"" );"
  1248. insert_update RegularCustomerOrderQuantityRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];orderQuantity[allownull=true];owner(pk)[allownull=true,forceWrite=true];positive;voucher(code)[allownull=true,forceWrite=true];voucherPOS
  1249. "#% impex.exportItems( ""RegularCustomerOrderQuantityRestriction"" , false );"
  1250.  
  1251. # ---- Extension: core ---- Type: Discount ----
  1252. "#% impex.setTargetFile( ""Discount.csv"" );"
  1253. insert_update Discount;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);global[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];priority[allownull=true];value
  1254. "#% impex.exportItems( ""Discount"" , false );"
  1255.  
  1256. # ---- Extension: voucher ---- Type: PromotionVoucher ----
  1257. "#% impex.setTargetFile( ""PromotionVoucher.csv"" );"
  1258. insert_update PromotionVoucher;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);freeShipping[allownull=true];global[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];priority[allownull=true];redemptionQuantityLimitPerUser[allownull=true];redemptionQuantityLimit[allownull=true];value[allownull=true];voucherCode
  1259. "#% impex.exportItems( ""PromotionVoucher"" , false );"
  1260.  
  1261. # ---- Extension: voucher ---- Type: SerialVoucher ----
  1262. "#% impex.setTargetFile( ""SerialVoucher.csv"" );"
  1263. insert_update SerialVoucher;pk;code[forceWrite=true,unique=true,allownull=true];codes(catalogVersion(catalog(id),version),code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);freeShipping[allownull=true];global[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];priority[allownull=true];value[allownull=true]
  1264. "#% impex.exportItems( ""SerialVoucher"" , false );"
  1265.  
  1266. # ---- Extension: workflow ---- Type: WorkflowActionTemplate ----
  1267. "#% impex.setTargetFile( ""WorkflowActionTemplate.csv"" );"
  1268. insert_update WorkflowActionTemplate;pk;actionType(code,itemtype(code))[allownull=true];code[forceWrite=true,unique=true];creationType(code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];emailAddress;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(uid)[allownull=true,forceWrite=true];principalAssigned(uid)[allownull=true];rendererTemplate(code);sendEmail[allownull=true];workflow(code)[allownull=true,forceWrite=true];workflowPOS
  1269. "#% impex.exportItems( ""WorkflowActionTemplate"" , false );"
  1270.  
  1271. # ---- Extension: workflow ---- Type: AutomatedWorkflowActionTemplate ----
  1272. "#% impex.setTargetFile( ""AutomatedWorkflowActionTemplate.csv"" );"
  1273. insert_update AutomatedWorkflowActionTemplate;pk;actionType(code,itemtype(code))[allownull=true];code[forceWrite=true,unique=true];creationType(code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];emailAddress;jobClass;jobHandler;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(uid)[allownull=true,forceWrite=true];principalAssigned(uid)[allownull=true];rendererTemplate(code);sendEmail[allownull=true];workflow(code)[allownull=true,forceWrite=true];workflowPOS
  1274. "#% impex.exportItems( ""AutomatedWorkflowActionTemplate"" , false );"
  1275.  
  1276. # ---- Extension: catalog ---- Type: ProductFeature ----
  1277. "#% impex.setTargetFile( ""ProductFeature.csv"" );"
  1278. insert_update ProductFeature;pk;booleanValue;classificationAttributeAssignment(classificationAttribute(code,systemVersion(catalog(id),version)),classificationClass(catalogVersion(catalog(id),version),code),systemVersion(catalog(id),version))[forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;featurePosition;language(isocode)[forceWrite=true,unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];numberValue;owner(pk)[allownull=true,forceWrite=true];product(catalogVersion(catalog(id),version),code)[forceWrite=true,unique=true,allownull=true];productPOS;qualifier[forceWrite=true,unique=true,allownull=true];rawValue;stringValue;unit(code,systemVersion(catalog(id),version),unitType)[unique=true];valueDetails;valuePosition[unique=true];valueType;value[allownull=true]
  1279. "#% impex.exportItems( ""ProductFeature"" , false );"
  1280.  
  1281. # ---- Extension: comments ---- Type: CommentAttachment ----
  1282. "#% impex.setTargetFile( ""CommentAttachment.csv"" );"
  1283. insert_update CommentAttachment;pk[unique=true];abstractComment(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];item(pk)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1284. "#% impex.exportItems( ""CommentAttachment"" , false );"
  1285.  
  1286. # ---- Extension: solrfacetsearch ---- Type: SolrIndex ----
  1287. "#% impex.setTargetFile( ""SolrIndex.csv"" );"
  1288. insert_update SolrIndex;pk[unique=true];active[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];facetSearchConfig(name)[allownull=true,forceWrite=true];indexedType(identifier,indexName)[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];qualifier[allownull=true,forceWrite=true]
  1289. "#% impex.exportItems( ""SolrIndex"" , false );"
  1290.  
  1291. # ---- Extension: catalog ---- Type: CatalogVersionSyncCronJobHistory ----
  1292. "#% impex.setTargetFile( ""CatalogVersionSyncCronJobHistory.csv"" );"
  1293. insert_update CatalogVersionSyncCronJobHistory;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];cronJob(code);cronJobCode[allownull=true,forceWrite=true];cronJobPOS;dumpedItemsCount;endTime[dateformat=dd.MM.yyyy hh:mm:ss];failureMessage;fullSync[allownull=true];jobCode[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nodeID[allownull=true];owner(pk)[allownull=true,forceWrite=true];processedItemsCount;progress;result(code,itemtype(code));scheduled;scheduledItemsCount;startTime[forceWrite=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];status(code,itemtype(code));statusLine;userUid
  1294. "#% impex.exportItems( ""CatalogVersionSyncCronJobHistory"" , false );"
  1295.  
  1296. # ---- Extension: processing ---- Type: CompositeEntry ----
  1297. "#% impex.setTargetFile( ""CompositeEntry.csv"" );"
  1298. insert_update CompositeEntry;pk;code[unique=true,allownull=true];compositeCronJob(code);compositeCronJobPOS;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executableCronJob(code)[unique=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];triggerableJob(code)[unique=true]
  1299. "#% impex.exportItems( ""CompositeEntry"" , false );"
  1300.  
  1301. # ---- Extension: commons ---- Type: Format ----
  1302. "#% impex.setTargetFile( ""Format.csv"" );"
  1303. insert_update Format;pk;code[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];documentType(code,itemtype(code))[allownull=true];initial(catalogVersion(catalog(id),version),code)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1304. "#% impex.exportItems( ""Format"" , false );"
  1305.  
  1306. # ---- Extension: comments ---- Type: Reply ----
  1307. "#% impex.setTargetFile( ""Reply.csv"" );"
  1308. insert_update Reply;pk[unique=true];author(uid)[allownull=true,forceWrite=true];comment(code)[allownull=true,forceWrite=true];commentPOS;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];parent(pk)[forceWrite=true];parentPOS;subject;text[allownull=true]
  1309. "#% impex.exportItems( ""Reply"" , false );"
  1310.  
  1311. # ---- Extension: solrfacetsearch ---- Type: SolrIndexOperationRecord ----
  1312. "#% impex.setTargetFile( ""SolrIndexOperationRecord.csv"" );"
  1313. insert_update SolrIndexOperationRecord;pk[unique=true];clusterId[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];failedReason;finishTime[dateformat=dd.MM.yyyy hh:mm:ss];mode(code,itemtype(code))[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];solrIndexCoreRecord(coreName)[allownull=true];solrIndexCoreRecordPOS;startTime[dateformat=dd.MM.yyyy hh:mm:ss];status(code,itemtype(code))[allownull=true];threadId[allownull=true]
  1314. "#% impex.exportItems( ""SolrIndexOperationRecord"" , false );"
  1315.  
  1316. # ---- Extension: solrfacetsearch ---- Type: SolrSearchConfig ----
  1317. "#% impex.setTargetFile( ""SolrSearchConfig.csv"" );"
  1318. insert_update SolrSearchConfig;pk[unique=true];allFacetValuesInResponse;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultSortOrder;description;enableHighlighting[allownull=true];groupingProperty(pk);legacyMode;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];pageSize[allownull=true];restrictFieldsInResponse
  1319. "#% impex.exportItems( ""SolrSearchConfig"" , false );"
  1320.  
  1321. # ---- Extension: basecommerce ---- Type: OrderRefundRecordEntry ----
  1322. "#% impex.setTargetFile( ""OrderRefundRecordEntry.csv"" );"
  1323. insert_update OrderRefundRecordEntry;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expectedQuantity;failedMessage;modificationRecord(identifier)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];notes;originalVersion(pk)[allownull=true,forceWrite=true];owner(pk)[allownull=true,forceWrite=true];principal(uid);returnStatus(code,itemtype(code));status(code,itemtype(code))[allownull=true];timestamp[forceWrite=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss]
  1324. "#% impex.exportItems( ""OrderRefundRecordEntry"" , false );"
  1325.  
  1326. # ---- Extension: payment ---- Type: PaymentTransactionEntry ----
  1327. "#% impex.setTargetFile( ""PaymentTransactionEntry.csv"" );"
  1328. insert_update PaymentTransactionEntry;pk[unique=true];amount;code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];paymentTransaction(pk);requestId;requestToken;subscriptionID;time[dateformat=dd.MM.yyyy hh:mm:ss];transactionStatus;transactionStatusDetails;type(code,itemtype(code));versionID[forceWrite=true]
  1329. "#% impex.exportItems( ""PaymentTransactionEntry"" , false );"
  1330.  
  1331. # ---- Extension: backofficesolrsearch ---- Type: SolrModifiedItem ----
  1332. "#% impex.setTargetFile( ""SolrModifiedItem.csv"" );"
  1333. insert_update SolrModifiedItem;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modificationType(code,itemtype(code));modifiedPk;modifiedTypeCode;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];parent(code)
  1334. "#% impex.exportItems( ""SolrModifiedItem"" , false );"
  1335.  
  1336. # ---- Extension: solrfacetsearch ---- Type: SolrIndexConfig ----
  1337. "#% impex.setTargetFile( ""SolrIndexConfig.csv"" );"
  1338. insert_update SolrIndexConfig;pk;batchSize[allownull=true];commitMode(code,itemtype(code));creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];distributedIndexing;exportPath;ignoreErrors[allownull=true];indexMode(code,itemtype(code));legacyMode;maxBatchRetries;maxRetries;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[forceWrite=true,unique=true,allownull=true];nodeGroup;numberOfThreads[allownull=true];optimizeMode(code,itemtype(code));owner(pk)[allownull=true,forceWrite=true]
  1339. "#% impex.exportItems( ""SolrIndexConfig"" , false );"
  1340.  
  1341. # ---- Extension: core ---- Type: GenericTestItem ----
  1342. "#% impex.setTargetFile( ""GenericTestItem.csv"" );"
  1343. insert_update GenericTestItem;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1344. "#% impex.exportItems( ""GenericTestItem"" , false );"
  1345.  
  1346. # ---- Extension: commons ---- Type: JaloVelocityRenderer ----
  1347. "#% impex.setTargetFile( ""JaloVelocityRenderer.csv"" );"
  1348. insert_update JaloVelocityRenderer;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[unique=true,allownull=true];owner(pk)[allownull=true,forceWrite=true];template;translatorConfiguration(code);translatorConfigurationPOS
  1349. "#% impex.exportItems( ""JaloVelocityRenderer"" , false );"
  1350.  
  1351. # ---- Extension: paymentstandard ---- Type: StandardPaymentModeValue ----
  1352. "#% impex.setTargetFile( ""StandardPaymentModeValue.csv"" );"
  1353. insert_update StandardPaymentModeValue;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];paymentMode(code)[allownull=true,forceWrite=true];value[allownull=true]
  1354. "#% impex.exportItems( ""StandardPaymentModeValue"" , false );"
  1355.  
  1356. # ---- Extension: solrfacetsearch ---- Type: SolrSearchQuerySort ----
  1357. "#% impex.setTargetFile( ""SolrSearchQuerySort.csv"" );"
  1358. insert_update SolrSearchQuerySort;pk[unique=true];ascending[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];field;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];searchQueryTemplate(indexedType(identifier,indexName),name)[allownull=true,forceWrite=true];searchQueryTemplatePOS
  1359. "#% impex.exportItems( ""SolrSearchQuerySort"" , false );"
  1360.  
  1361. # ---- Extension: scripting ---- Type: Script ----
  1362. "#% impex.setTargetFile( ""Script.csv"" );"
  1363. insert_update Script;pk[unique=true];active[allownull=true,forceWrite=true];autodisabling;checksum;code[allownull=true,forceWrite=true];content[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];disabled;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];scriptType(code,itemtype(code))[allownull=true];version[allownull=true]
  1364. "#% impex.exportItems( ""Script"" , false );"
  1365.  
  1366. # ---- Extension: europe1 ---- Type: DiscountRow ----
  1367. "#% impex.setTargetFile( ""DiscountRow.csv"" );"
  1368. insert_update DiscountRow;pk[unique=true];asTargetPrice;catalogVersion(catalog(id),version);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);dateRange[dateformat=dd.MM.yyyy hh:mm:ss];discount(code)[allownull=true,forceWrite=true];endTime[dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];pg(code,itemtype(code))[forceWrite=true];product(catalogVersion(catalog(id),version),code)[forceWrite=true];productId[forceWrite=true];productMatchQualifier;startTime[dateformat=dd.MM.yyyy hh:mm:ss];ug(code,itemtype(code));user(uid);userMatchQualifier;value
  1369. "#% impex.exportItems( ""DiscountRow"" , false );"
  1370.  
  1371. # ---- Extension: promotions ---- Type: PromotionOrderEntryConsumed ----
  1372. "#% impex.setTargetFile( ""PromotionOrderEntryConsumed.csv"" );"
  1373. insert_update PromotionOrderEntryConsumed;pk[unique=true];adjustedUnitPrice;code;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];orderEntry(entryNumber);orderEntryNumber;owner(pk)[allownull=true,forceWrite=true];promotionResult(pk);quantity
  1374. "#% impex.exportItems( ""PromotionOrderEntryConsumed"" , false );"
  1375.  
  1376. # ---- Extension: core ---- Type: Quote ----
  1377. "#% impex.setTargetFile( ""Quote.csv"" );"
  1378. insert_update Quote;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));appliedVoucherCodes;assignee(uid);calculated;cartReference(code);code[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[allownull=true];date[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryCost;deliveryMode(code);deliveryStatus(code,itemtype(code));description;discountsIncludeDeliveryCost[allownull=true];discountsIncludePaymentCost[allownull=true];entryGroups;expirationTime[dateformat=dd.MM.yyyy hh:mm:ss];exportStatus(code,itemtype(code));globalDiscountValues;globalDiscountValuesInternal;guid;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;net[allownull=true];owner(pk)[allownull=true,forceWrite=true];paymentAddress(pk);paymentCost;paymentInfo(pk);paymentMode(code);paymentStatus(code,itemtype(code));previousDeliveryMode(code);previousEstimatedTotal;quoteDiscountValuesInternal;site(uid);state(code,itemtype(code))[allownull=true];status(code,itemtype(code));statusInfo;store(uid);subtotal;totalDiscounts;totalPrice;totalTax;totalTaxValues;totalTaxValuesInternal;user(uid)[allownull=true];version[forceWrite=true,unique=true,allownull=true]
  1379. "#% impex.exportItems( ""Quote"" , false );"
  1380.  
  1381. # ---- Extension: basecommerce ---- Type: FraudSymptomScoring ----
  1382. "#% impex.setTargetFile( ""FraudSymptomScoring.csv"" );"
  1383. insert_update FraudSymptomScoring;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];explanation;fraudReport(pk)[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[allownull=true,forceWrite=true];owner(pk)[allownull=true,forceWrite=true];score[allownull=true,forceWrite=true]
  1384. "#% impex.exportItems( ""FraudSymptomScoring"" , false );"
  1385.  
  1386. # ---- Extension: processing ---- Type: FlexibleSearchRetentionRule ----
  1387. "#% impex.setTargetFile( ""FlexibleSearchRetentionRule.csv"" );"
  1388. insert_update FlexibleSearchRetentionRule;pk;actionReference[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];queryParameters();retentionTimeSeconds;searchQuery[allownull=true]
  1389. "#% impex.exportItems( ""FlexibleSearchRetentionRule"" , false );"
  1390.  
  1391. # ---- Extension: core ---- Type: OrderEntry ----
  1392. "#% impex.setTargetFile( ""OrderEntry.csv"" );"
  1393. insert_update OrderEntry;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));basePrice;calculated;chosenVendor(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryMode(code);deliveryPointOfService(name);discountValues;discountValuesInternal;entryGroupNumbers;entryNumber[unique=true];giveAway[allownull=true];info;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];namedDeliveryDate[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID)[forceWrite=true,unique=true,allownull=true];owner(pk)[allownull=true,forceWrite=true];product(catalogVersion(catalog(id),version),code)[allownull=true];quantityStatus(code,itemtype(code));quantity[allownull=true];rejected[allownull=true];taxValues;taxValuesInternal;totalPrice;unit(code)[allownull=true]
  1394. "#% impex.exportItems( ""OrderEntry"" , false );"
  1395.  
  1396. # ---- Extension: basecommerce ---- Type: ReplacementOrderEntry ----
  1397. "#% impex.setTargetFile( ""ReplacementOrderEntry.csv"" );"
  1398. insert_update ReplacementOrderEntry;pk;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));basePrice;calculated;chosenVendor(pk);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deliveryAddress(pk);deliveryMode(code);deliveryPointOfService(name);discountValues;discountValuesInternal;entryGroupNumbers;entryNumber[unique=true];giveAway[allownull=true];info;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];namedDeliveryDate[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID)[forceWrite=true,unique=true,allownull=true];owner(pk)[allownull=true,forceWrite=true];product(catalogVersion(catalog(id),version),code)[allownull=true];quantityStatus(code,itemtype(code));quantity[allownull=true];rejected[allownull=true];taxValues;taxValuesInternal;totalPrice;unit(code)[allownull=true]
  1399. "#% impex.exportItems( ""ReplacementOrderEntry"" , false );"
  1400.  
  1401. # ---- Extension: core ---- Type: Language ----
  1402. "#% impex.setTargetFile( ""Language.csv"" );"
  1403. insert_update Language;pk;active[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];fallbackLanguages(isocode);isocode[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1404. "#% impex.exportItems( ""Language"" , false );"
  1405.  
  1406. # ---- Extension: voucher ---- Type: VoucherInvalidation ----
  1407. "#% impex.setTargetFile( ""VoucherInvalidation.csv"" );"
  1408. insert_update VoucherInvalidation;pk[unique=true];code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID)[allownull=true,forceWrite=true];owner(pk)[allownull=true,forceWrite=true];status;user(uid)[allownull=true,forceWrite=true];voucher(code)[allownull=true,forceWrite=true]
  1409. "#% impex.exportItems( ""VoucherInvalidation"" , false );"
  1410.  
  1411. # ---- Extension: basecommerce ---- Type: OrderEntryReturnRecordEntry ----
  1412. "#% impex.setTargetFile( ""OrderEntryReturnRecordEntry.csv"" );"
  1413. insert_update OrderEntryReturnRecordEntry;pk[unique=true];code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expectedQuantity;modificationRecordEntry(code)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];notes;orderEntry(entryNumber,order(code,versionID));originalOrderEntry(entryNumber,order(code,versionID));owner(pk)[allownull=true,forceWrite=true];returnedQuantity
  1414. "#% impex.exportItems( ""OrderEntryReturnRecordEntry"" , false );"
  1415.  
  1416. # ---- Extension: commons ---- Type: ParserProperty ----
  1417. "#% impex.setTargetFile( ""ParserProperty.csv"" );"
  1418. insert_update ParserProperty;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endExp;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[unique=true,allownull=true];owner(pk)[allownull=true,forceWrite=true];parserClass;startExp[unique=true,allownull=true];translatorConfiguration(code);translatorConfigurationPOS
  1419. "#% impex.exportItems( ""ParserProperty"" , false );"
  1420.  
  1421. # ---- Extension: deliveryzone ---- Type: Zone ----
  1422. "#% impex.setTargetFile( ""Zone.csv"" );"
  1423. insert_update Zone;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1424. "#% impex.exportItems( ""Zone"" , false );"
  1425.  
  1426. # ---- Extension: commerceservices ---- Type: SolrSortField ----
  1427. "#% impex.setTargetFile( ""SolrSortField.csv"" );"
  1428. insert_update SolrSortField;pk;ascending[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];fieldName[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];sort(code,indexedType(identifier,indexName))[unique=true,allownull=true];sortPOS
  1429. "#% impex.exportItems( ""SolrSortField"" , false );"
  1430.  
  1431. # ---- Extension: basecommerce ---- Type: OrderCancelRecordEntry ----
  1432. "#% impex.setTargetFile( ""OrderCancelRecordEntry.csv"" );"
  1433. insert_update OrderCancelRecordEntry;pk;cancelReason(code,itemtype(code));cancelResult(code,itemtype(code));code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];failedMessage;modificationRecord(identifier)[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];notes;originalVersion(pk)[allownull=true,forceWrite=true];owner(pk)[allownull=true,forceWrite=true];principal(uid);refusedMessage;status(code,itemtype(code))[allownull=true];timestamp[forceWrite=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss]
  1434. "#% impex.exportItems( ""OrderCancelRecordEntry"" , false );"
  1435.  
  1436. # ---- Extension: core ---- Type: BruteForceLoginDisabledAudit ----
  1437. "#% impex.setTargetFile( ""BruteForceLoginDisabledAudit.csv"" );"
  1438. insert_update BruteForceLoginDisabledAudit;pk[unique=true];changingApplication;changingUser;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];failedLogins[allownull=true,forceWrite=true];ipAddress[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];uid[allownull=true,forceWrite=true];userPK[allownull=true,forceWrite=true]
  1439. "#% impex.exportItems( ""BruteForceLoginDisabledAudit"" , false );"
  1440.  
  1441. # ---- Extension: processing ---- Type: Batch ----
  1442. "#% impex.setTargetFile( ""Batch.csv"" );"
  1443. insert_update Batch;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionId[forceWrite=true,unique=true,allownull=true];id[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];process(code)[forceWrite=true,unique=true,allownull=true];remainingWorkLoad[allownull=true,forceWrite=true];type(code,itemtype(code))[forceWrite=true,unique=true,allownull=true]
  1444. "#% impex.exportItems( ""Batch"" , false );"
  1445.  
  1446. # ---- Extension: impex ---- Type: ImportBatch ----
  1447. "#% impex.setTargetFile( ""ImportBatch.csv"" );"
  1448. insert_update ImportBatch;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionId[forceWrite=true,unique=true,allownull=true];group[allownull=true,forceWrite=true];id[forceWrite=true,unique=true,allownull=true];importContentCode[forceWrite=true];metadata[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];process(code)[forceWrite=true,unique=true,allownull=true];remainingWorkLoad[allownull=true,forceWrite=true];type(code,itemtype(code))[forceWrite=true,unique=true,allownull=true]
  1449. "#% impex.exportItems( ""ImportBatch"" , false );"
  1450.  
  1451. # ---- Extension: processing ---- Type: SimpleBatch ----
  1452. "#% impex.setTargetFile( ""SimpleBatch.csv"" );"
  1453. insert_update SimpleBatch;pk;context;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionId[forceWrite=true,unique=true,allownull=true];id[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];process(code)[forceWrite=true,unique=true,allownull=true];remainingWorkLoad[allownull=true,forceWrite=true];resultBatchId;retries[allownull=true];scriptCode;type(code,itemtype(code))[forceWrite=true,unique=true,allownull=true]
  1454. "#% impex.exportItems( ""SimpleBatch"" , false );"
  1455.  
  1456. # ---- Extension: solrfacetsearch ---- Type: SolrIndexerBatch ----
  1457. "#% impex.setTargetFile( ""SolrIndexerBatch.csv"" );"
  1458. insert_update SolrIndexerBatch;pk;context;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];executionId[forceWrite=true,unique=true,allownull=true];id[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];process(code)[forceWrite=true,unique=true,allownull=true];remainingWorkLoad[allownull=true,forceWrite=true];resultBatchId;retries[allownull=true];scriptCode;type(code,itemtype(code))[forceWrite=true,unique=true,allownull=true]
  1459. "#% impex.exportItems( ""SolrIndexerBatch"" , false );"
  1460.  
  1461. # ---- Extension: solrfacetsearch ---- Type: SolrSearchQueryTemplate ----
  1462. "#% impex.setTargetFile( ""SolrSearchQueryTemplate.csv"" );"
  1463. insert_update SolrSearchQueryTemplate;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];enableHighlighting[allownull=true];ftsQueryBuilder;ftsQueryBuilderParameters();groupFacets[allownull=true];groupLimit;groupProperty(pk);group[allownull=true];indexedType(identifier,indexName)[forceWrite=true,unique=true,allownull=true];indexedTypePOS;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[unique=true,allownull=true];owner(pk)[allownull=true,forceWrite=true];pageSize;restrictFieldsInResponse[allownull=true];showFacets[allownull=true]
  1464. "#% impex.exportItems( ""SolrSearchQueryTemplate"" , false );"
  1465.  
  1466. # ---- Extension: basecommerce ---- Type: OrderCancelRecord ----
  1467. "#% impex.setTargetFile( ""OrderCancelRecord.csv"" );"
  1468. insert_update OrderCancelRecord;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];identifier[unique=true];inProgress[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID)[allownull=true];owner(pk)[allownull=true,forceWrite=true]
  1469. "#% impex.exportItems( ""OrderCancelRecord"" , false );"
  1470.  
  1471. # ---- Extension: basecommerce ---- Type: PointOfService ----
  1472. "#% impex.setTargetFile( ""PointOfService.csv"" );"
  1473. insert_update PointOfService;pk;address(pk);baseStore(uid);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;displayName;geocodeTimestamp[dateformat=dd.MM.yyyy hh:mm:ss];latitude;longitude;mapIcon(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[forceWrite=true,unique=true,allownull=true];nearbyStoreRadius;openingSchedule(code);owner(pk)[allownull=true,forceWrite=true];storeImage(catalogVersion(catalog(id),version),qualifier);type(code,itemtype(code))[allownull=true]
  1474. "#% impex.exportItems( ""PointOfService"" , false );"
  1475.  
  1476. # ---- Extension: catalog ---- Type: AttributeValueAssignment ----
  1477. "#% impex.setTargetFile( ""AttributeValueAssignment.csv"" );"
  1478. insert_update AttributeValueAssignment;pk;attribute(code,systemVersion(catalog(id),version))[forceWrite=true,unique=true];attributeAssignment(classificationAttribute(code,systemVersion(catalog(id),version)),classificationClass(catalogVersion(catalog(id),version),code),systemVersion(catalog(id),version))[forceWrite=true,unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];externalID;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];position;systemVersion(catalog(id),version)[forceWrite=true];value(code,systemVersion(catalog(id),version))[forceWrite=true,unique=true,allownull=true]
  1479. "#% impex.exportItems( ""AttributeValueAssignment"" , false );"
  1480.  
  1481. # ---- Extension: core ---- Type: PaymentMode ----
  1482. "#% impex.setTargetFile( ""PaymentMode.csv"" );"
  1483. insert_update PaymentMode;pk;active[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];paymentInfoType(code)[allownull=true]
  1484. "#% impex.exportItems( ""PaymentMode"" , false );"
  1485.  
  1486. # ---- Extension: paymentstandard ---- Type: StandardPaymentMode ----
  1487. "#% impex.setTargetFile( ""StandardPaymentMode.csv"" );"
  1488. insert_update StandardPaymentMode;pk;active[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];net[allownull=true];owner(pk)[allownull=true,forceWrite=true];paymentInfoType(code)[allownull=true]
  1489. "#% impex.exportItems( ""StandardPaymentMode"" , false );"
  1490.  
  1491. # ---- Extension: core ---- Type: UserGroup ----
  1492. "#% impex.setTargetFile( ""UserGroup.csv"" );"
  1493. insert_update UserGroup;pk;backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;hmcXML;maxBruteForceLoginAttempts;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];profilePicture(catalogVersion(catalog(id),version),code);readableLanguages(isocode);uid[unique=true,allownull=true];userDiscountGroup(code,itemtype(code));userPriceGroup(code,itemtype(code));userTaxGroup(code,itemtype(code));writeableLanguages(isocode)
  1494. "#% impex.exportItems( ""UserGroup"" , false );"
  1495.  
  1496. # ---- Extension: backoffice ---- Type: BackofficeRole ----
  1497. "#% impex.setTargetFile( ""BackofficeRole.csv"" );"
  1498. insert_update BackofficeRole;pk;authorities;backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;hmcXML;maxBruteForceLoginAttempts;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];profilePicture(catalogVersion(catalog(id),version),code);readableLanguages(isocode);uid[unique=true,allownull=true];userDiscountGroup(code,itemtype(code));userPriceGroup(code,itemtype(code));userTaxGroup(code,itemtype(code));writeableLanguages(isocode)
  1499. "#% impex.exportItems( ""BackofficeRole"" , false );"
  1500.  
  1501. # ---- Extension: catalog ---- Type: Company ----
  1502. "#% impex.setTargetFile( ""Company.csv"" );"
  1503. insert_update Company;pk;Id;addresses(pk);backOfficeLoginDisabled;billingAddress(pk);buyerSpecificID;buyer[allownull=true];carrier[allownull=true];contact(uid);contactAddress(pk);country(isocode);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;dunsID;hmcXML;ilnID;lineOfBuisness(code,itemtype(code));manufacturer[allownull=true];maxBruteForceLoginAttempts;medias(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];profilePicture(catalogVersion(catalog(id),version),code);readableLanguages(isocode);responsibleCompany(uid);shippingAddress(pk);supplierSpecificID;supplier[allownull=true];uid[unique=true,allownull=true];unloadingAddress(pk);userDiscountGroup(code,itemtype(code));userPriceGroup(code,itemtype(code));userTaxGroup(code,itemtype(code));vatID;writeableLanguages(isocode)
  1504. "#% impex.exportItems( ""Company"" , false );"
  1505.  
  1506. # ---- Extension: commerceservices ---- Type: CustomerList ----
  1507. "#% impex.setTargetFile( ""CustomerList.csv"" );"
  1508. insert_update CustomerList;pk;additionalColumnsKeys;backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;hmcXML;implementationType;maxBruteForceLoginAttempts;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];priority;profilePicture(catalogVersion(catalog(id),version),code);readableLanguages(isocode);searchBoxEnabled;uid[unique=true,allownull=true];userDiscountGroup(code,itemtype(code));userPriceGroup(code,itemtype(code));userTaxGroup(code,itemtype(code));writeableLanguages(isocode)
  1509. "#% impex.exportItems( ""CustomerList"" , false );"
  1510.  
  1511. # ---- Extension: commerceservices ---- Type: StoreEmployeeGroup ----
  1512. "#% impex.setTargetFile( ""StoreEmployeeGroup.csv"" );"
  1513. insert_update StoreEmployeeGroup;pk;backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;hmcXML;maxBruteForceLoginAttempts;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];profilePicture(catalogVersion(catalog(id),version),code);readableLanguages(isocode);store(name);uid[unique=true,allownull=true];userDiscountGroup(code,itemtype(code));userPriceGroup(code,itemtype(code));userTaxGroup(code,itemtype(code));writeableLanguages(isocode)
  1514. "#% impex.exportItems( ""StoreEmployeeGroup"" , false );"
  1515.  
  1516. # ---- Extension: core ---- Type: TestUserGroup ----
  1517. "#% impex.setTargetFile( ""TestUserGroup.csv"" );"
  1518. insert_update TestUserGroup;pk;backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;hmcXML;maxBruteForceLoginAttempts;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];profilePicture(catalogVersion(catalog(id),version),code);readableLanguages(isocode);uid[unique=true,allownull=true];userDiscountGroup(code,itemtype(code));userPriceGroup(code,itemtype(code));userTaxGroup(code,itemtype(code));writeableLanguages(isocode)
  1519. "#% impex.exportItems( ""TestUserGroup"" , false );"
  1520.  
  1521. # ---- Extension: commerceservices ---- Type: OrgUnit ----
  1522. "#% impex.setTargetFile( ""OrgUnit.csv"" );"
  1523. insert_update OrgUnit;pk;Id;active[allownull=true];addresses(pk);backOfficeLoginDisabled;billingAddress(pk);buyerSpecificID;buyer[allownull=true];carrier[allownull=true];contact(uid);contactAddress(pk);country(isocode);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;dunsID;hmcXML;ilnID;lineOfBuisness(code,itemtype(code));manufacturer[allownull=true];maxBruteForceLoginAttempts;medias(catalogVersion(catalog(id),version),code);modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];path;profilePicture(catalogVersion(catalog(id),version),code);readableLanguages(isocode);responsibleCompany(uid);shippingAddress(pk);supplierSpecificID;supplier[allownull=true];uid[unique=true,allownull=true];unloadingAddress(pk);userDiscountGroup(code,itemtype(code));userPriceGroup(code,itemtype(code));userTaxGroup(code,itemtype(code));vatID;writeableLanguages(isocode)
  1524. "#% impex.exportItems( ""OrgUnit"" , false );"
  1525.  
  1526. # ---- Extension: commons ---- Type: RenderersProperty ----
  1527. "#% impex.setTargetFile( ""RenderersProperty.csv"" );"
  1528. insert_update RenderersProperty;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];key;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];translatorConfiguration(code);translatorConfigurationPOS;value
  1529. "#% impex.exportItems( ""RenderersProperty"" , false );"
  1530.  
  1531. # ---- Extension: promotions ---- Type: ProductOneToOnePerfectPartnerPromotion ----
  1532. "#% impex.setTargetFile( ""ProductOneToOnePerfectPartnerPromotion.csv"" );"
  1533. insert_update ProductOneToOnePerfectPartnerPromotion;pk[unique=true];PromotionGroup(Identifier);baseProduct(catalogVersion(catalog(id),version),code);bundlePrices(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];partnerProduct(catalogVersion(catalog(id),version),code);priority;productBanner(catalogVersion(catalog(id),version),code);restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  1534. "#% impex.exportItems( ""ProductOneToOnePerfectPartnerPromotion"" , false );"
  1535.  
  1536. # ---- Extension: basecommerce ---- Type: Warehouse ----
  1537. "#% impex.setTargetFile( ""Warehouse.csv"" );"
  1538. insert_update Warehouse;pk[unique=true];code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];default[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];vendor(pk)[allownull=true,forceWrite=true];vendorPOS
  1539. "#% impex.exportItems( ""Warehouse"" , false );"
  1540.  
  1541. # ---- Extension: oauth2 ---- Type: OpenIDExternalScopes ----
  1542. "#% impex.setTargetFile( ""OpenIDExternalScopes.csv"" );"
  1543. insert_update OpenIDExternalScopes;pk;clientDetailsId(clientId)[allownull=true];code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];permittedPrincipals(uid);scope
  1544. "#% impex.exportItems( ""OpenIDExternalScopes"" , false );"
  1545.  
  1546. # ---- Extension: basecommerce ---- Type: DeeplinkUrlRule ----
  1547. "#% impex.setTargetFile( ""DeeplinkUrlRule.csv"" );"
  1548. insert_update DeeplinkUrlRule;pk[unique=true];applicableType(code)[allownull=true];baseUrlPattern[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];destUrlTemplate[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];priority[allownull=true];useForward
  1549. "#% impex.exportItems( ""DeeplinkUrlRule"" , false );"
  1550.  
  1551. # ---- Extension: promotions ---- Type: ProductMultiBuyPromotion ----
  1552. "#% impex.setTargetFile( ""ProductMultiBuyPromotion.csv"" );"
  1553. insert_update ProductMultiBuyPromotion;pk[unique=true];PromotionGroup(Identifier);bundlePrices(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];priority;productBanner(catalogVersion(catalog(id),version),code);qualifyingCount;restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  1554. "#% impex.exportItems( ""ProductMultiBuyPromotion"" , false );"
  1555.  
  1556. # ---- Extension: basecommerce ---- Type: OpeningSchedule ----
  1557. "#% impex.setTargetFile( ""OpeningSchedule.csv"" );"
  1558. insert_update OpeningSchedule;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1559. "#% impex.exportItems( ""OpeningSchedule"" , false );"
  1560.  
  1561. # ---- Extension: voucher ---- Type: NewCustomerRestriction ----
  1562. "#% impex.setTargetFile( ""NewCustomerRestriction.csv"" );"
  1563. insert_update NewCustomerRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];positive[allownull=true];voucher(code)[allownull=true,forceWrite=true];voucherPOS
  1564. "#% impex.exportItems( ""NewCustomerRestriction"" , false );"
  1565.  
  1566. # ---- Extension: basecommerce ---- Type: FraudReport ----
  1567. "#% impex.setTargetFile( ""FraudReport.csv"" );"
  1568. insert_update FraudReport;pk[unique=true];code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];explanation;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];order(code,versionID);owner(pk)[allownull=true,forceWrite=true];provider;status(code,itemtype(code));timestamp[forceWrite=true,allownull=true,dateformat=dd.MM.yyyy hh:mm:ss]
  1569. "#% impex.exportItems( ""FraudReport"" , false );"
  1570.  
  1571. # ---- Extension: solrfacetsearch ---- Type: SolrIndexerQuery ----
  1572. "#% impex.setTargetFile( ""SolrIndexerQuery.csv"" );"
  1573. insert_update SolrIndexerQuery;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];identifier[forceWrite=true,unique=true,allownull=true];injectCurrentDate[allownull=true];injectCurrentTime[allownull=true];injectLastIndexTime[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];parameterProvider;query[allownull=true];solrIndexedType(identifier,indexName);solrIndexedTypePOS;type(code,itemtype(code))[allownull=true,forceWrite=true];user(uid)
  1574. "#% impex.exportItems( ""SolrIndexerQuery"" , false );"
  1575.  
  1576. # ---- Extension: basecommerce ---- Type: Campaign ----
  1577. "#% impex.setTargetFile( ""Campaign.csv"" );"
  1578. insert_update Campaign;pk;code[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];startDate[dateformat=dd.MM.yyyy hh:mm:ss]
  1579. "#% impex.exportItems( ""Campaign"" , false );"
  1580.  
  1581. # ---- Extension: processing ---- Type: ProcessTaskLog ----
  1582. "#% impex.setTargetFile( ""ProcessTaskLog.csv"" );"
  1583. insert_update ProcessTaskLog;pk[unique=true];actionId[allownull=true];clusterId[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];endDate[dateformat=dd.MM.yyyy hh:mm:ss];logMessages;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];process(code)[allownull=true];returnCode;startDate[dateformat=dd.MM.yyyy hh:mm:ss]
  1584. "#% impex.exportItems( ""ProcessTaskLog"" , false );"
  1585.  
  1586. # ---- Extension: catalog ---- Type: PreviewTicket ----
  1587. "#% impex.setTargetFile( ""PreviewTicket.csv"" );"
  1588. insert_update PreviewTicket;pk[unique=true];createdBy(uid)[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];previewCatalogVersion(catalog(id),version)[allownull=true,forceWrite=true];validTo[allownull=true,dateformat=dd.MM.yyyy hh:mm:ss]
  1589. "#% impex.exportItems( ""PreviewTicket"" , false );"
  1590.  
  1591. # ---- Extension: basecommerce ---- Type: ProductTaxCode ----
  1592. "#% impex.setTargetFile( ""ProductTaxCode.csv"" );"
  1593. insert_update ProductTaxCode;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];productCode[forceWrite=true,unique=true,allownull=true];taxArea[forceWrite=true,unique=true];taxCode[allownull=true]
  1594. "#% impex.exportItems( ""ProductTaxCode"" , false );"
  1595.  
  1596. # ---- Extension: solrfacetsearch ---- Type: SolrEndpointUrl ----
  1597. "#% impex.setTargetFile( ""SolrEndpointUrl.csv"" );"
  1598. insert_update SolrEndpointUrl;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];master[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];solrServerConfig(name);url[allownull=true]
  1599. "#% impex.exportItems( ""SolrEndpointUrl"" , false );"
  1600.  
  1601. # ---- Extension: solrfacetsearch ---- Type: SolrValueRange ----
  1602. "#% impex.setTargetFile( ""SolrValueRange.csv"" );"
  1603. insert_update SolrValueRange;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];from[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[allownull=true];owner(pk)[allownull=true,forceWrite=true];solrValueRangeSet(name)[allownull=true];solrValueRangeSetPOS;to
  1604. "#% impex.exportItems( ""SolrValueRange"" , false );"
  1605.  
  1606. # ---- Extension: comments ---- Type: Domain ----
  1607. "#% impex.setTargetFile( ""Domain.csv"" );"
  1608. insert_update Domain;pk;code[forceWrite=true,unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true]
  1609. "#% impex.exportItems( ""Domain"" , false );"
  1610.  
  1611. # ---- Extension: promotions ---- Type: ProductPerfectPartnerBundlePromotion ----
  1612. "#% impex.setTargetFile( ""ProductPerfectPartnerBundlePromotion.csv"" );"
  1613. insert_update ProductPerfectPartnerBundlePromotion;pk[unique=true];PromotionGroup(Identifier);baseProduct(catalogVersion(catalog(id),version),code);bundlePrices(pk);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];partnerProducts(catalogVersion(catalog(id),version),code);priority;productBanner(catalogVersion(catalog(id),version),code);qualifyingCount;restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  1614. "#% impex.exportItems( ""ProductPerfectPartnerBundlePromotion"" , false );"
  1615.  
  1616. # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig ----
  1617. "#% impex.setTargetFile( ""SolrFacetSearchConfig.csv"" );"
  1618. insert_update SolrFacetSearchConfig;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;document(catalogVersion(catalog(id),version),code);enabledLanguageFallbackMechanism[allownull=true];indexNamePrefix;listeners;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[forceWrite=true,unique=true,allownull=true];owner(pk)[allownull=true,forceWrite=true];solrIndexConfig(name);solrSearchConfig(pk)[allownull=true];solrServerConfig(name)
  1619. "#% impex.exportItems( ""SolrFacetSearchConfig"" , false );"
  1620.  
  1621. # ---- Extension: solrfacetsearch ---- Type: SolrURIRedirect ----
  1622. "#% impex.setTargetFile( ""SolrURIRedirect.csv"" );"
  1623. insert_update SolrURIRedirect;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];url[allownull=true]
  1624. "#% impex.exportItems( ""SolrURIRedirect"" , false );"
  1625.  
  1626. # ---- Extension: basecommerce ---- Type: BaseStore ----
  1627. "#% impex.setTargetFile( ""BaseStore.csv"" );"
  1628. insert_update BaseStore;pk;createReturnProcessCode;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];customerAllowedToIgnoreSuggestions;defaultCurrency(isocode);defaultDeliveryOrigin(name);defaultLanguage(isocode);externalTaxEnabled[allownull=true];maxRadiusForPoSSearch;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];net[allownull=true];owner(pk)[allownull=true,forceWrite=true];paymentProvider;pickupInStoreMode(code,itemtype(code));solrFacetSearchConfiguration(name);storelocatorDistanceUnit(code,itemtype(code));submitOrderProcessCode;taxGroup(code,itemtype(code));uid[unique=true,allownull=true]
  1629. "#% impex.exportItems( ""BaseStore"" , false );"
  1630.  
  1631. # ---- Extension: deliveryzone ---- Type: ZoneDeliveryModeValue ----
  1632. "#% impex.setTargetFile( ""ZoneDeliveryModeValue.csv"" );"
  1633. insert_update ZoneDeliveryModeValue;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode)[unique=true,allownull=true];deliveryMode(code)[forceWrite=true,unique=true,allownull=true];minimum[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];value[allownull=true];zone(code)[unique=true,allownull=true]
  1634. "#% impex.exportItems( ""ZoneDeliveryModeValue"" , false );"
  1635.  
  1636. # ---- Extension: core ---- Type: UserProfile ----
  1637. "#% impex.setTargetFile( ""UserProfile.csv"" );"
  1638. insert_update UserProfile;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expandInitial[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(uid)[allownull=true,forceWrite=true];readableLanguages(isocode);writableLanguages(isocode)
  1639. "#% impex.exportItems( ""UserProfile"" , false );"
  1640.  
  1641. # ---- Extension: catalog ---- Type: CatalogVersion ----
  1642. "#% impex.setTargetFile( ""CatalogVersion.csv"" );"
  1643. insert_update CatalogVersion;pk;active[allownull=true];catalog(id)[forceWrite=true,unique=true,allownull=true];categorySystemID;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultCurrency(isocode);generationDate[dateformat=dd.MM.yyyy hh:mm:ss];generatorInfo;inclAssurance[allownull=true];inclDuty[allownull=true];inclFreight[allownull=true];inclPacking[allownull=true];languages(isocode);mimeRootDirectory;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];previousUpdateVersion;rootCategories(catalogVersion(catalog(id),version),code);territories(isocode);version[unique=true,allownull=true]
  1644. "#% impex.exportItems( ""CatalogVersion"" , false );"
  1645.  
  1646. # ---- Extension: catalog ---- Type: ClassificationSystemVersion ----
  1647. "#% impex.setTargetFile( ""ClassificationSystemVersion.csv"" );"
  1648. insert_update ClassificationSystemVersion;pk;active[allownull=true];catalog(id)[forceWrite=true,unique=true,allownull=true];categorySystemID;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultCurrency(isocode);generationDate[dateformat=dd.MM.yyyy hh:mm:ss];generatorInfo;inclAssurance[allownull=true];inclDuty[allownull=true];inclFreight[allownull=true];inclPacking[allownull=true];languages(isocode);mimeRootDirectory;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];previousUpdateVersion;rootCategories(catalogVersion(catalog(id),version),code);territories(isocode);version[unique=true,allownull=true]
  1649. "#% impex.exportItems( ""ClassificationSystemVersion"" , false );"
  1650.  
  1651. # ---- Extension: commerceservices ---- Type: ConsentTemplate ----
  1652. "#% impex.setTargetFile( ""ConsentTemplate.csv"" );"
  1653. insert_update ConsentTemplate;pk[unique=true];baseSite(uid)[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];exposed;id[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];version[allownull=true]
  1654. "#% impex.exportItems( ""ConsentTemplate"" , false );"
  1655.  
  1656. # ---- Extension: core ---- Type: User ----
  1657. "#% impex.setTargetFile( ""User.csv"" );"
  1658. insert_update User;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deactivationDate[dateformat=dd.MM.yyyy hh:mm:ss];defaultPaymentAddress(pk);defaultShipmentAddress(pk);description;encodedPassword;europe1Discounts(pk);hmcLoginDisabled;lastLogin[dateformat=dd.MM.yyyy hh:mm:ss];loginDisabled[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];password;passwordAnswer;passwordEncoding;passwordQuestion;profilePicture(catalogVersion(catalog(id),version),code);retentionState(code,itemtype(code));sessionCurrency(isocode);sessionLanguage(isocode);uid[unique=true,allownull=true];userprofile(pk)
  1659. "#% impex.exportItems( ""User"" , false );"
  1660.  
  1661. # ---- Extension: core ---- Type: Customer ----
  1662. "#% impex.setTargetFile( ""Customer.csv"" );"
  1663. insert_update Customer;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];customerID;deactivationDate[dateformat=dd.MM.yyyy hh:mm:ss];defaultPaymentAddress(pk);defaultPaymentInfo(pk);defaultShipmentAddress(pk);description;encodedPassword;europe1Discounts(pk);hmcLoginDisabled;lastLogin[dateformat=dd.MM.yyyy hh:mm:ss];loginDisabled[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;originalUid;owner(pk)[allownull=true,forceWrite=true];password;passwordAnswer;passwordEncoding;passwordQuestion;previewCatalogVersions(catalog(id),version);profilePicture(catalogVersion(catalog(id),version),code);retentionState(code,itemtype(code));sessionCurrency(isocode);sessionLanguage(isocode);title(code);token;type(code,itemtype(code));uid[unique=true,allownull=true];userprofile(pk)
  1664. "#% impex.exportItems( ""Customer"" , false );"
  1665.  
  1666. # ---- Extension: core ---- Type: Employee ----
  1667. "#% impex.setTargetFile( ""Employee.csv"" );"
  1668. insert_update Employee;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deactivationDate[dateformat=dd.MM.yyyy hh:mm:ss];defaultPaymentAddress(pk);defaultShipmentAddress(pk);description;encodedPassword;europe1Discounts(pk);hmcLoginDisabled;lastLogin[dateformat=dd.MM.yyyy hh:mm:ss];loginDisabled[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];password;passwordAnswer;passwordEncoding;passwordQuestion;profilePicture(catalogVersion(catalog(id),version),code);retentionState(code,itemtype(code));sessionCurrency(isocode);sessionLanguage(isocode);uid[unique=true,allownull=true];userprofile(pk)
  1669. "#% impex.exportItems( ""Employee"" , false );"
  1670.  
  1671. # ---- Extension: core ---- Type: TestEmployee ----
  1672. "#% impex.setTargetFile( ""TestEmployee.csv"" );"
  1673. insert_update TestEmployee;pk;Europe1PriceFactory_UDG(code,itemtype(code));Europe1PriceFactory_UPG(code,itemtype(code));Europe1PriceFactory_UTG(code,itemtype(code));backOfficeLoginDisabled;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];deactivationDate[dateformat=dd.MM.yyyy hh:mm:ss];defaultPaymentAddress(pk);defaultShipmentAddress(pk);description;encodedPassword;europe1Discounts(pk);hmcLoginDisabled;lastLogin[dateformat=dd.MM.yyyy hh:mm:ss];loginDisabled[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true];password;passwordAnswer;passwordEncoding;passwordQuestion;profilePicture(catalogVersion(catalog(id),version),code);retentionState(code,itemtype(code));sessionCurrency(isocode);sessionLanguage(isocode);uid[unique=true,allownull=true];userprofile(pk)
  1674. "#% impex.exportItems( ""TestEmployee"" , false );"
  1675.  
  1676. # ---- Extension: advancedsavedquery ---- Type: WherePart ----
  1677. "#% impex.setTargetFile( ""WherePart.csv"" );"
  1678. insert_update WherePart;pk[unique=true];and[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];replacePattern[allownull=true];savedQuery(code)[allownull=true]
  1679. "#% impex.exportItems( ""WherePart"" , false );"
  1680.  
  1681. # ---- Extension: catalog ---- Type: CategoryCatalogVersionDifference ----
  1682. "#% impex.setTargetFile( ""CategoryCatalogVersionDifference.csv"" );"
  1683. insert_update CategoryCatalogVersionDifference;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];cronJob(code,maxPriceTolerance,sourceVersion(catalog(id),version),targetVersion(catalog(id),version))[forceWrite=true,unique=true,allownull=true];differenceText;differenceValue;mode(code,itemtype(code))[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];sourceCategory(catalogVersion(catalog(id),version),code)[forceWrite=true,unique=true];sourceVersion(catalog(id),version)[forceWrite=true,unique=true,allownull=true];targetCategory(catalogVersion(catalog(id),version),code)[forceWrite=true,unique=true];targetVersion(catalog(id),version)[forceWrite=true,unique=true,allownull=true]
  1684. "#% impex.exportItems( ""CategoryCatalogVersionDifference"" , false );"
  1685.  
  1686. # ---- Extension: promotions ---- Type: ProductBOGOFPromotion ----
  1687. "#% impex.setTargetFile( ""ProductBOGOFPromotion.csv"" );"
  1688. insert_update ProductBOGOFPromotion;pk[unique=true];PromotionGroup(Identifier);code[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];description;detailsURL;enabled[allownull=true];endDate[dateformat=dd.MM.yyyy hh:mm:ss];freeCount;immutableKey;immutableKeyHash;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];priority;productBanner(catalogVersion(catalog(id),version),code);qualifyingCount;restrictions(pk);startDate[dateformat=dd.MM.yyyy hh:mm:ss];title
  1689. "#% impex.exportItems( ""ProductBOGOFPromotion"" , false );"
  1690.  
  1691. # ---- Extension: oauth2 ---- Type: OAuthAccessToken ----
  1692. "#% impex.setTargetFile( ""OAuthAccessToken.csv"" );"
  1693. insert_update OAuthAccessToken;pk;authentication;authenticationId[allownull=true,forceWrite=true];client(clientId)[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];refreshToken(pk)[forceWrite=true];tokenId[unique=true,allownull=true];token[forceWrite=true];user(uid)
  1694. "#% impex.exportItems( ""OAuthAccessToken"" , false );"
  1695.  
  1696. # ---- Extension: oauth2 ---- Type: OAuthClientDetails ----
  1697. "#% impex.setTargetFile( ""OAuthClientDetails.csv"" );"
  1698. insert_update OAuthClientDetails;pk;accessTokenValiditySeconds;authorities;authorizedGrantTypes;autoApprove;clientId[forceWrite=true,unique=true,allownull=true];clientSecret;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];disabled;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];refreshTokenValiditySeconds;registeredRedirectUri;resourceIds;scope
  1699. "#% impex.exportItems( ""OAuthClientDetails"" , false );"
  1700.  
  1701. # ---- Extension: oauth2 ---- Type: OpenIDClientDetails ----
  1702. "#% impex.setTargetFile( ""OpenIDClientDetails.csv"" );"
  1703. insert_update OpenIDClientDetails;pk;accessTokenValiditySeconds;authorities;authorizedGrantTypes;autoApprove;clientId[forceWrite=true,unique=true,allownull=true];clientSecret;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];disabled;externalScopeClaimName;issuer[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];refreshTokenValiditySeconds;registeredRedirectUri;resourceIds;scope
  1704. "#% impex.exportItems( ""OpenIDClientDetails"" , false );"
  1705.  
  1706. # ---- Extension: processing ---- Type: TaskCondition ----
  1707. "#% impex.setTargetFile( ""TaskCondition.csv"" );"
  1708. insert_update TaskCondition;pk[unique=true];choice;consumed;counter;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];expirationDate[dateformat=dd.MM.yyyy hh:mm:ss];expirationTimeMillis;fulfilled;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];processedDate[dateformat=dd.MM.yyyy hh:mm:ss];task(pk);uniqueID[allownull=true]
  1709. "#% impex.exportItems( ""TaskCondition"" , false );"
  1710.  
  1711. # ---- Extension: solrfacetsearch ---- Type: SolrIndexedType ----
  1712. "#% impex.setTargetFile( ""SolrIndexedType.csv"" );"
  1713. insert_update SolrIndexedType;pk;additionalParameters();configSet;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];defaultFieldValueProvider;ftsQueryBuilder;ftsQueryBuilderParameters();groupFacets[allownull=true];groupFieldName;groupLimit;group[allownull=true];identifier[forceWrite=true,unique=true,allownull=true];identityProvider;indexName[unique=true];listeners;modelLoader;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];solrFacetSearchConfig(name);solrFacetSearchConfigPOS;solrResultConverter;type(code)[allownull=true];valuesProvider;variant[allownull=true]
  1714. "#% impex.exportItems( ""SolrIndexedType"" , false );"
  1715.  
  1716. # ---- Extension: advancedsavedquery ---- Type: TypedAdvancedSavedQuerySearchParameter ----
  1717. "#% impex.setTargetFile( ""TypedAdvancedSavedQuerySearchParameter.csv"" );"
  1718. insert_update TypedAdvancedSavedQuerySearchParameter;pk[unique=true];comparator(code,itemtype(code))[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];emptyHandling(code,itemtype(code))[allownull=true];enclosingType(code)[allownull=true];joinAlias;lower;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];typedSearchParameter(enclosingType(code),qualifier);wherePart(pk)[allownull=true]
  1719. "#% impex.exportItems( ""TypedAdvancedSavedQuerySearchParameter"" , false );"
  1720.  
  1721. # ---- Extension: advancedsavedquery ---- Type: ComposedTypeAdvancedSavedQuerySearchParameter ----
  1722. "#% impex.setTargetFile( ""ComposedTypeAdvancedSavedQuerySearchParameter.csv"" );"
  1723. insert_update ComposedTypeAdvancedSavedQuerySearchParameter;pk[unique=true];comparator(code,itemtype(code))[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];emptyHandling(code,itemtype(code))[allownull=true];joinAlias;lower;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];typedSearchParameter(enclosingType(code),qualifier);wherePart(pk)[allownull=true]
  1724. "#% impex.exportItems( ""ComposedTypeAdvancedSavedQuerySearchParameter"" , false );"
  1725.  
  1726. # ---- Extension: voucher ---- Type: ProductRestriction ----
  1727. "#% impex.setTargetFile( ""ProductRestriction.csv"" );"
  1728. insert_update ProductRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];positive[allownull=true];products(catalogVersion(catalog(id),version),code);voucher(code)[allownull=true,forceWrite=true];voucherPOS
  1729. "#% impex.exportItems( ""ProductRestriction"" , false );"
  1730.  
  1731. # ---- Extension: voucher ---- Type: ProductCategoryRestriction ----
  1732. "#% impex.setTargetFile( ""ProductCategoryRestriction.csv"" );"
  1733. insert_update ProductCategoryRestriction;pk[unique=true];categories(catalogVersion(catalog(id),version),code);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];positive[allownull=true];products(catalogVersion(catalog(id),version),code);voucher(code)[allownull=true,forceWrite=true];voucherPOS
  1734. "#% impex.exportItems( ""ProductCategoryRestriction"" , false );"
  1735.  
  1736. # ---- Extension: voucher ---- Type: ProductQuantityRestriction ----
  1737. "#% impex.setTargetFile( ""ProductQuantityRestriction.csv"" );"
  1738. insert_update ProductQuantityRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];positive[allownull=true];products(catalogVersion(catalog(id),version),code);quantity[allownull=true];unit(code)[allownull=true];voucher(code)[allownull=true,forceWrite=true];voucherPOS
  1739. "#% impex.exportItems( ""ProductQuantityRestriction"" , false );"
  1740.  
  1741. # ---- Extension: europe1 ---- Type: TaxRow ----
  1742. "#% impex.setTargetFile( ""TaxRow.csv"" );"
  1743. insert_update TaxRow;pk[unique=true];catalogVersion(catalog(id),version);creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currency(isocode);dateRange[dateformat=dd.MM.yyyy hh:mm:ss];endTime[dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];pg(code,itemtype(code))[forceWrite=true];product(catalogVersion(catalog(id),version),code)[forceWrite=true];productId[forceWrite=true];productMatchQualifier;startTime[dateformat=dd.MM.yyyy hh:mm:ss];tax(code)[allownull=true,forceWrite=true];ug(code,itemtype(code));user(uid);userMatchQualifier;value
  1744. "#% impex.exportItems( ""TaxRow"" , false );"
  1745.  
  1746. # ---- Extension: solrfacetsearch ---- Type: SolrServerConfig ----
  1747. "#% impex.setTargetFile( ""SolrServerConfig.csv"" );"
  1748. insert_update SolrServerConfig;pk;aliveCheckInterval;connectionTimeout;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];embeddedMaster[allownull=true];indexingAliveCheckInterval;indexingConnectionTimeout;indexingMaxTotalConnections;indexingMaxTotalConnectionsPerHostConfig;indexingPassword;indexingSocketTimeout;indexingTcpNoDelay[allownull=true];indexingUsername;maxTotalConnections;maxTotalConnectionsPerHostConfig;mode(code,itemtype(code))[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name[forceWrite=true,unique=true,allownull=true];numShards;owner(pk)[allownull=true,forceWrite=true];password;readTimeout;replicationFactor;socketTimeout;solrQueryMethod(code,itemtype(code));tcpNoDelay[allownull=true];useMasterNodeExclusivelyForIndexing[allownull=true];username
  1749. "#% impex.exportItems( ""SolrServerConfig"" , false );"
  1750.  
  1751. # ---- Extension: catalog ---- Type: ClassAttributeAssignment ----
  1752. "#% impex.setTargetFile( ""ClassAttributeAssignment.csv"" );"
  1753. insert_update ClassAttributeAssignment;pk;attributeType(code,itemtype(code));attributeValues(code,systemVersion(catalog(id),version));classificationAttribute(code,systemVersion(catalog(id),version))[forceWrite=true,unique=true,allownull=true];classificationClass(catalogVersion(catalog(id),version),code)[unique=true,allownull=true];comparable[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];externalID;formatDefinition;listable[allownull=true];localized[allownull=true];mandatory[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];multiValued[allownull=true];owner(pk)[allownull=true,forceWrite=true];position;range[allownull=true];searchable[allownull=true];systemVersion(catalog(id),version)[forceWrite=true,unique=true];unit(code,systemVersion(catalog(id),version),unitType);visibility(code,itemtype(code))
  1754. "#% impex.exportItems( ""ClassAttributeAssignment"" , false );"
  1755.  
  1756. # ---- Extension: basecommerce ---- Type: Vendor ----
  1757. "#% impex.setTargetFile( ""Vendor.csv"" );"
  1758. insert_update Vendor;pk[unique=true];code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1759. "#% impex.exportItems( ""Vendor"" , false );"
  1760.  
  1761. # ---- Extension: impex ---- Type: ImpexDocumentId ----
  1762. "#% impex.setTargetFile( ""ImpexDocumentId.csv"" );"
  1763. insert_update ImpexDocumentId;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];docId[allownull=true];itemPK[allownull=true];itemQualifier[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];processCode;resolved[allownull=true]
  1764. "#% impex.exportItems( ""ImpexDocumentId"" , false );"
  1765.  
  1766. # ---- Extension: promotions ---- Type: PromotionOrderAddFreeGiftAction ----
  1767. "#% impex.setTargetFile( ""PromotionOrderAddFreeGiftAction.csv"" );"
  1768. insert_update PromotionOrderAddFreeGiftAction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];freeProduct(catalogVersion(catalog(id),version),code)[allownull=true];guid;markedApplied[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];promotionResult(pk)
  1769. "#% impex.exportItems( ""PromotionOrderAddFreeGiftAction"" , false );"
  1770.  
  1771. # ---- Extension: processing ---- Type: JobSearchRestriction ----
  1772. "#% impex.setTargetFile( ""JobSearchRestriction.csv"" );"
  1773. insert_update JobSearchRestriction;pk[unique=true];code;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];job(code);jobPOS;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];query;type(code)
  1774. "#% impex.exportItems( ""JobSearchRestriction"" , false );"
  1775.  
  1776. # ---- Extension: core ---- Type: MediaFolder ----
  1777. "#% impex.setTargetFile( ""MediaFolder.csv"" );"
  1778. insert_update MediaFolder;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];path[forceWrite=true];qualifier[unique=true,allownull=true]
  1779. "#% impex.exportItems( ""MediaFolder"" , false );"
  1780.  
  1781. # ---- Extension: basecommerce ---- Type: ProductOrderLimit ----
  1782. "#% impex.setTargetFile( ""ProductOrderLimit.csv"" );"
  1783. insert_update ProductOrderLimit;pk[unique=true];code[allownull=true,forceWrite=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];intervalMaxOrdersNumber[allownull=true,forceWrite=true];intervalResolution(code,itemtype(code))[allownull=true,forceWrite=true];intervalValue[allownull=true,forceWrite=true];maxNumberPerOrder[allownull=true,forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1784. "#% impex.exportItems( ""ProductOrderLimit"" , false );"
  1785.  
  1786. # ---- Extension: processing ---- Type: DynamicProcessDefinition ----
  1787. "#% impex.setTargetFile( ""DynamicProcessDefinition.csv"" );"
  1788. insert_update DynamicProcessDefinition;pk[unique=true];active[allownull=true,forceWrite=true];checksum;code[allownull=true,forceWrite=true];content[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];version[allownull=true]
  1789. "#% impex.exportItems( ""DynamicProcessDefinition"" , false );"
  1790.  
  1791. # ---- Extension: platformbackoffice ---- Type: BackofficeSavedQuery ----
  1792. "#% impex.setTargetFile( ""BackofficeSavedQuery.csv"" );"
  1793. insert_update BackofficeSavedQuery;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];globalOperatorCode;includeSubtypes;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];queryOwner(uid)[allownull=true];searchMode;sortAsc;sortAttribute;tokenizable;typeCode[allownull=true]
  1794. "#% impex.exportItems( ""BackofficeSavedQuery"" , false );"
  1795.  
  1796. # ---- Extension: solrfacetsearch ---- Type: SolrIndexedCoresRecord ----
  1797. "#% impex.setTargetFile( ""SolrIndexedCoresRecord.csv"" );"
  1798. insert_update SolrIndexedCoresRecord;pk;coreName[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];currentIndexDataSubDirectory;indexName[allownull=true,forceWrite=true];indexTime[dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];serverMode(code,itemtype(code))
  1799. "#% impex.exportItems( ""SolrIndexedCoresRecord"" , false );"
  1800.  
  1801. # ---- Extension: core ---- Type: Region ----
  1802. "#% impex.setTargetFile( ""Region.csv"" );"
  1803. insert_update Region;pk;active[allownull=true];country(isocode)[unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];isocodeShort;isocode[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true]
  1804. "#% impex.exportItems( ""Region"" , false );"
  1805.  
  1806. # ---- Extension: basecommerce ---- Type: StockLevel ----
  1807. "#% impex.setTargetFile( ""StockLevel.csv"" );"
  1808. insert_update StockLevel;pk[unique=true];available[allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];inStockStatus(code,itemtype(code));maxPreOrder[allownull=true];maxStockLevelHistoryCount[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];nextDeliveryTime[dateformat=dd.MM.yyyy hh:mm:ss];overSelling[allownull=true];owner(pk)[allownull=true,forceWrite=true];preOrder[allownull=true];product(catalogVersion(catalog(id),version),code);productCode[allownull=true];releaseDate[dateformat=dd.MM.yyyy hh:mm:ss];reserved[allownull=true];treatNegativeAsZero[allownull=true];warehouse(pk)[allownull=true,forceWrite=true]
  1809. "#% impex.exportItems( ""StockLevel"" , false );"
  1810.  
  1811. # ---- Extension: core ---- Type: MediaFormatMapping ----
  1812. "#% impex.setTargetFile( ""MediaFormatMapping.csv"" );"
  1813. insert_update MediaFormatMapping;pk;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];mediaContext(qualifier)[unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];source(qualifier)[forceWrite=true,unique=true,allownull=true];target(qualifier)[forceWrite=true,unique=true,allownull=true]
  1814. "#% impex.exportItems( ""MediaFormatMapping"" , false );"
  1815.  
  1816. # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchKeywordRedirect ----
  1817. "#% impex.setTargetFile( ""SolrFacetSearchKeywordRedirect.csv"" );"
  1818. insert_update SolrFacetSearchKeywordRedirect;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];facetSearchConfig(name);ignoreCase[allownull=true];keyword[allownull=true];language(isocode)[allownull=true];matchType(code,itemtype(code))[allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];redirect(pk)[allownull=true]
  1819. "#% impex.exportItems( ""SolrFacetSearchKeywordRedirect"" , false );"
  1820.  
  1821. # ---- Extension: core ---- Type: UserPasswordChangeAudit ----
  1822. "#% impex.setTargetFile( ""UserPasswordChangeAudit.csv"" );"
  1823. insert_update UserPasswordChangeAudit;pk[unique=true];changingApplication;changingUser;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];encodedPassword[allownull=true,forceWrite=true];ipAddress[forceWrite=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];passwordEncoding[allownull=true];uid[allownull=true,forceWrite=true];userPK[allownull=true,forceWrite=true]
  1824. "#% impex.exportItems( ""UserPasswordChangeAudit"" , false );"
  1825.  
  1826. # ---- Extension: core ---- Type: CorsConfigurationProperty ----
  1827. "#% impex.setTargetFile( ""CorsConfigurationProperty.csv"" );"
  1828. insert_update CorsConfigurationProperty;pk;context[forceWrite=true,unique=true,allownull=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];key[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];value[allownull=true]
  1829. "#% impex.exportItems( ""CorsConfigurationProperty"" , false );"
  1830.  
  1831. # ---- Extension: comments ---- Type: Component ----
  1832. "#% impex.setTargetFile( ""Component.csv"" );"
  1833. insert_update Component;pk;code[forceWrite=true,unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];domain(code)[forceWrite=true,unique=true,allownull=true];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];name;owner(pk)[allownull=true,forceWrite=true]
  1834. "#% impex.exportItems( ""Component"" , false );"
  1835.  
  1836. # ---- Extension: commerceservices ---- Type: PromotionOrderRestriction ----
  1837. "#% impex.setTargetFile( ""PromotionOrderRestriction.csv"" );"
  1838. insert_update PromotionOrderRestriction;pk[unique=true];creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[allownull=true,forceWrite=true];promotion(pk)
  1839. "#% impex.exportItems( ""PromotionOrderRestriction"" , false );"
  1840.  
  1841. # ---- Extension: core ---- Type: TestItem ----
  1842. "#% impex.setTargetFile( ""TestItem.csv"" );"
  1843. insert_update TestItem;pk[unique=true];a;b;boolean;byte;character;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];date[dateformat=dd.MM.yyyy hh:mm:ss];double;float;integer;long;longString;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];primitiveBoolean;primitiveByte;primitiveChar;primitiveDouble;primitiveFloat;primitiveInteger;primitiveLong;primitiveShort;serializable;string;testDumpProperty;testProperty0
  1844. "#% impex.exportItems( ""TestItem"" , false );"
  1845.  
  1846. # ---- Extension: core ---- Type: TestItemType2 ----
  1847. "#% impex.setTargetFile( ""TestItemType2.csv"" );"
  1848. insert_update TestItemType2;pk[unique=true];a;b;bar;boolean;byte;character;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];date[dateformat=dd.MM.yyyy hh:mm:ss];double;float;foo;fooBar;intBar;integer;long;longString;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];primitiveBoolean;primitiveByte;primitiveChar;primitiveDouble;primitiveFloat;primitiveInteger;primitiveLong;primitiveShort;serializable;string;testDumpProperty;testProperty0;testProperty1
  1849. "#% impex.exportItems( ""TestItemType2"" , false );"
  1850.  
  1851. # ---- Extension: core ---- Type: TestItemType3 ----
  1852. "#% impex.setTargetFile( ""TestItemType3.csv"" );"
  1853. insert_update TestItemType3;pk[unique=true];a;b;bar;boolean;byte;character;creationtime[forceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss];date[dateformat=dd.MM.yyyy hh:mm:ss];double;float;foo;integer;itemTypeTwo(pk)[allownull=true];itemsTypeTwo(pk)[allownull=true];long;longString;modifiedtime[dateformat=dd.MM.yyyy hh:mm:ss];owner(pk)[forceWrite=true];primitiveBoolean;primitiveByte;primitiveChar;primitiveDouble;primitiveFloat;primitiveInteger;primitiveLong;primitiveShort;prop;prop3;serializable;string;testDumpProperty;testProperty0;testProperty1;xxx
  1854. "#% impex.exportItems( ""TestItemType3"" , false );"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement