Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -------------------------------------------------------
- # # used 'header validation mode' during script generation was: import_strict
- "#% impex.setLocale( new Locale( ""en"" , """" ) );"
- # -------------------------------------------------------
- # ---- Extension: core ---- Type: Link ----
- "#% impex.setTargetFile( ""Link.csv"" );"
- 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]
- "#% impex.exportItems( ""Link"" , false );"
- # ---- Extension: core ---- Type: ProductMediaLink ----
- "#% impex.setTargetFile( ""ProductMediaLink.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductMediaLink"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2CurrencyRelation ----
- "#% impex.setTargetFile( ""SolrFacetSearchConfig2CurrencyRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrFacetSearchConfig2CurrencyRelation"" , false );"
- # ---- Extension: commerceservices ---- Type: BaseStore2CountryRel ----
- "#% impex.setTargetFile( ""BaseStore2CountryRel.csv"" );"
- 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]
- "#% impex.exportItems( ""BaseStore2CountryRel"" , false );"
- # ---- Extension: commerceservices ---- Type: BaseStore2WarehouseRel ----
- "#% impex.setTargetFile( ""BaseStore2WarehouseRel.csv"" );"
- 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]
- "#% impex.exportItems( ""BaseStore2WarehouseRel"" , false );"
- # ---- Extension: comments ---- Type: ComponentWritePrincipalRelation ----
- "#% impex.setTargetFile( ""ComponentWritePrincipalRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ComponentWritePrincipalRelation"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowActionItemAttachmentRelation ----
- "#% impex.setTargetFile( ""WorkflowActionItemAttachmentRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowActionItemAttachmentRelation"" , false );"
- # ---- Extension: commerceservices ---- Type: StoreLocation2StoreLocatorFeature ----
- "#% impex.setTargetFile( ""StoreLocation2StoreLocatorFeature.csv"" );"
- 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]
- "#% impex.exportItems( ""StoreLocation2StoreLocatorFeature"" , false );"
- # ---- Extension: comments ---- Type: ComponentReadPrincipalRelation ----
- "#% impex.setTargetFile( ""ComponentReadPrincipalRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ComponentReadPrincipalRelation"" , false );"
- # ---- Extension: catalog ---- Type: SyncJob2LangRel ----
- "#% impex.setTargetFile( ""SyncJob2LangRel.csv"" );"
- 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]
- "#% impex.exportItems( ""SyncJob2LangRel"" , false );"
- # ---- Extension: commerceservices ---- Type: BaseStore2CurrencyRel ----
- "#% impex.setTargetFile( ""BaseStore2CurrencyRel.csv"" );"
- 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]
- "#% impex.exportItems( ""BaseStore2CurrencyRel"" , false );"
- # ---- Extension: validation ---- Type: ConstraintGroup2AbstractConstraintRelation ----
- "#% impex.setTargetFile( ""ConstraintGroup2AbstractConstraintRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ConstraintGroup2AbstractConstraintRelation"" , false );"
- # ---- Extension: catalog ---- Type: SyncJob2TypeRel ----
- "#% impex.setTargetFile( ""SyncJob2TypeRel.csv"" );"
- 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]
- "#% impex.exportItems( ""SyncJob2TypeRel"" , false );"
- # ---- Extension: processing ---- Type: CronJobPendingStepsRelation ----
- "#% impex.setTargetFile( ""CronJobPendingStepsRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CronJobPendingStepsRelation"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexedProperty2SolrValueRangeSetRelation ----
- "#% impex.setTargetFile( ""SolrIndexedProperty2SolrValueRangeSetRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexedProperty2SolrValueRangeSetRelation"" , false );"
- # ---- Extension: basecommerce ---- Type: StoresForCMSSite ----
- "#% impex.setTargetFile( ""StoresForCMSSite.csv"" );"
- 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]
- "#% impex.exportItems( ""StoresForCMSSite"" , false );"
- # ---- Extension: promotions ---- Type: ProductPromotionRelation ----
- "#% impex.setTargetFile( ""ProductPromotionRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductPromotionRelation"" , false );"
- # ---- Extension: catalog ---- Type: Principal2ReadableCatalogVersionRelation ----
- "#% impex.setTargetFile( ""Principal2ReadableCatalogVersionRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""Principal2ReadableCatalogVersionRelation"" , false );"
- # ---- Extension: comments ---- Type: CommentItemRelation ----
- "#% impex.setTargetFile( ""CommentItemRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CommentItemRelation"" , false );"
- # ---- Extension: commerceservices ---- Type: QuoteToNotificationRel ----
- "#% impex.setTargetFile( ""QuoteToNotificationRel.csv"" );"
- 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]
- "#% impex.exportItems( ""QuoteToNotificationRel"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowActionOrderingRelation ----
- "#% impex.setTargetFile( ""WorkflowActionOrderingRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowActionOrderingRelation"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2LanguageRelation ----
- "#% impex.setTargetFile( ""SolrFacetSearchConfig2LanguageRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrFacetSearchConfig2LanguageRelation"" , false );"
- # ---- Extension: catalog ---- Type: Principal2WriteableCatalogVersionRelation ----
- "#% impex.setTargetFile( ""Principal2WriteableCatalogVersionRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""Principal2WriteableCatalogVersionRelation"" , false );"
- # ---- Extension: basecommerce ---- Type: HistoryDocumentRelation ----
- "#% impex.setTargetFile( ""HistoryDocumentRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""HistoryDocumentRelation"" , false );"
- # ---- Extension: catalog ---- Type: CategoryMediaRelation ----
- "#% impex.setTargetFile( ""CategoryMediaRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CategoryMediaRelation"" , false );"
- # ---- Extension: catalog ---- Type: Category2PrincipalRelation ----
- "#% impex.setTargetFile( ""Category2PrincipalRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""Category2PrincipalRelation"" , false );"
- # ---- Extension: processing ---- Type: CronJobProcessedStepsRelation ----
- "#% impex.setTargetFile( ""CronJobProcessedStepsRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CronJobProcessedStepsRelation"" , false );"
- # ---- Extension: basecommerce ---- Type: ProductDeliveryModeRelation ----
- "#% impex.setTargetFile( ""ProductDeliveryModeRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductDeliveryModeRelation"" , false );"
- # ---- Extension: catalog ---- Type: SyncItemJob2Principal ----
- "#% impex.setTargetFile( ""SyncItemJob2Principal.csv"" );"
- 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]
- "#% impex.exportItems( ""SyncItemJob2Principal"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowActionLinkRelation ----
- "#% impex.setTargetFile( ""WorkflowActionLinkRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowActionLinkRelation"" , false );"
- # ---- Extension: basecommerce ---- Type: CatalogsForBaseStores ----
- "#% impex.setTargetFile( ""CatalogsForBaseStores.csv"" );"
- 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]
- "#% impex.exportItems( ""CatalogsForBaseStores"" , false );"
- # ---- Extension: comments ---- Type: CommentWatcherRelation ----
- "#% impex.setTargetFile( ""CommentWatcherRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CommentWatcherRelation"" , false );"
- # ---- Extension: commons ---- Type: Format2ComTypRel ----
- "#% impex.setTargetFile( ""Format2ComTypRel.csv"" );"
- 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]
- "#% impex.exportItems( ""Format2ComTypRel"" , false );"
- # ---- Extension: platformbackoffice ---- Type: BackofficeSavedQuery2UserGroupRelation ----
- "#% impex.setTargetFile( ""BackofficeSavedQuery2UserGroupRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""BackofficeSavedQuery2UserGroupRelation"" , false );"
- # ---- Extension: comments ---- Type: ComponentRemovePrincipalRelation ----
- "#% impex.setTargetFile( ""ComponentRemovePrincipalRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ComponentRemovePrincipalRelation"" , false );"
- # ---- Extension: commerceservices ---- Type: BaseStore2DeliveryModeRel ----
- "#% impex.setTargetFile( ""BaseStore2DeliveryModeRel.csv"" );"
- 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]
- "#% impex.exportItems( ""BaseStore2DeliveryModeRel"" , false );"
- # ---- Extension: validation ---- Type: ComposedType2CoverageConstraintGroupRelation ----
- "#% impex.setTargetFile( ""ComposedType2CoverageConstraintGroupRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ComposedType2CoverageConstraintGroupRelation"" , false );"
- # ---- Extension: commerceservices ---- Type: BaseStore2LanguageRel ----
- "#% impex.setTargetFile( ""BaseStore2LanguageRel.csv"" );"
- 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]
- "#% impex.exportItems( ""BaseStore2LanguageRel"" , false );"
- # ---- Extension: catalog ---- Type: DependentCatalogVersionSyncJobRelation ----
- "#% impex.setTargetFile( ""DependentCatalogVersionSyncJobRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""DependentCatalogVersionSyncJobRelation"" , false );"
- # ---- Extension: catalog ---- Type: CategoryProductRelation ----
- "#% impex.setTargetFile( ""CategoryProductRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CategoryProductRelation"" , false );"
- # ---- Extension: deliveryzone ---- Type: ZoneCountryRelation ----
- "#% impex.setTargetFile( ""ZoneCountryRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ZoneCountryRelation"" , false );"
- # ---- Extension: comments ---- Type: CommentAssigneeRelation ----
- "#% impex.setTargetFile( ""CommentAssigneeRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CommentAssigneeRelation"" , false );"
- # ---- Extension: catalog ---- Type: Category2KeywordRelation ----
- "#% impex.setTargetFile( ""Category2KeywordRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""Category2KeywordRelation"" , false );"
- # ---- Extension: catalog ---- Type: Product2KeywordRelation ----
- "#% impex.setTargetFile( ""Product2KeywordRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""Product2KeywordRelation"" , false );"
- # ---- Extension: commerceservices ---- Type: PromotionRestriction2OrderRel ----
- "#% impex.setTargetFile( ""PromotionRestriction2OrderRel.csv"" );"
- 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]
- "#% impex.exportItems( ""PromotionRestriction2OrderRel"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2SolrValueRangeSetRelation ----
- "#% impex.setTargetFile( ""SolrFacetSearchConfig2SolrValueRangeSetRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrFacetSearchConfig2SolrValueRangeSetRelation"" , false );"
- # ---- Extension: basecommerce ---- Type: StockLevelProductRelation ----
- "#% impex.setTargetFile( ""StockLevelProductRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""StockLevelProductRelation"" , false );"
- # ---- Extension: catalog ---- Type: CategoryCategoryRelation ----
- "#% impex.setTargetFile( ""CategoryCategoryRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CategoryCategoryRelation"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig2CatalogVersionRelation ----
- "#% impex.setTargetFile( ""SolrFacetSearchConfig2CatalogVersionRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrFacetSearchConfig2CatalogVersionRelation"" , false );"
- # ---- Extension: comments ---- Type: ComponentCreatePrincipalRelation ----
- "#% impex.setTargetFile( ""ComponentCreatePrincipalRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ComponentCreatePrincipalRelation"" , false );"
- # ---- Extension: commerceservices ---- Type: PoS2WarehouseRel ----
- "#% impex.setTargetFile( ""PoS2WarehouseRel.csv"" );"
- 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]
- "#% impex.exportItems( ""PoS2WarehouseRel"" , false );"
- # ---- Extension: commons ---- Type: Format2MedForRel ----
- "#% impex.setTargetFile( ""Format2MedForRel.csv"" );"
- 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]
- "#% impex.exportItems( ""Format2MedForRel"" , false );"
- # ---- Extension: core ---- Type: OrderDiscountRelation ----
- "#% impex.setTargetFile( ""OrderDiscountRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderDiscountRelation"" , false );"
- # ---- Extension: basecommerce ---- Type: ProductVendorRelation ----
- "#% impex.setTargetFile( ""ProductVendorRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductVendorRelation"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowTemplate2PrincipalRelation ----
- "#% impex.setTargetFile( ""WorkflowTemplate2PrincipalRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowTemplate2PrincipalRelation"" , false );"
- # ---- Extension: promotions ---- Type: CategoryPromotionRelation ----
- "#% impex.setTargetFile( ""CategoryPromotionRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""CategoryPromotionRelation"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowActionTemplateLinkTemplateRelation ----
- "#% impex.setTargetFile( ""WorkflowActionTemplateLinkTemplateRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowActionTemplateLinkTemplateRelation"" , false );"
- # ---- Extension: core ---- Type: PrincipalGroupRelation ----
- "#% impex.setTargetFile( ""PrincipalGroupRelation.csv"" );"
- 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]
- "#% impex.exportItems( ""PrincipalGroupRelation"" , false );"
- # ---- Extension: core ---- Type: GenericItem ----
- "#% impex.setTargetFile( ""GenericItem.csv"" );"
- 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]
- "#% impex.exportItems( ""GenericItem"" , false );"
- # ---- Extension: core ---- Type: SystemSetupAudit ----
- "#% impex.setTargetFile( ""SystemSetupAudit.csv"" );"
- 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]
- "#% impex.exportItems( ""SystemSetupAudit"" , false );"
- # ---- Extension: backofficesolrsearch ---- Type: BackofficeIndexedTypeToSolrFacetSearchConfig ----
- "#% impex.setTargetFile( ""BackofficeIndexedTypeToSolrFacetSearchConfig.csv"" );"
- 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]
- "#% impex.exportItems( ""BackofficeIndexedTypeToSolrFacetSearchConfig"" , false );"
- # ---- Extension: commons ---- Type: JaloTranslatorConfiguration ----
- "#% impex.setTargetFile( ""JaloTranslatorConfiguration.csv"" );"
- 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]
- "#% impex.exportItems( ""JaloTranslatorConfiguration"" , false );"
- # ---- Extension: ecrpimbackoffice ---- Type: TdsIngredient ----
- "#% impex.setTargetFile( ""TdsIngredient.csv"" );"
- 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
- "#% impex.exportItems( ""TdsIngredient"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowAction ----
- "#% impex.setTargetFile( ""WorkflowAction.csv"" );"
- 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
- "#% impex.exportItems( ""WorkflowAction"" , false );"
- # ---- Extension: basecommerce ---- Type: RefundEntry ----
- "#% impex.setTargetFile( ""RefundEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""RefundEntry"" , false );"
- # ---- Extension: impex ---- Type: ImportBatchContent ----
- "#% impex.setTargetFile( ""ImportBatchContent.csv"" );"
- 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]
- "#% impex.exportItems( ""ImportBatchContent"" , false );"
- # ---- Extension: impex ---- Type: DistributedImportSplitErrorDump ----
- "#% impex.setTargetFile( ""DistributedImportSplitErrorDump.csv"" );"
- 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]
- "#% impex.exportItems( ""DistributedImportSplitErrorDump"" , false );"
- # ---- Extension: basecommerce ---- Type: ConsignmentEntry ----
- "#% impex.setTargetFile( ""ConsignmentEntry.csv"" );"
- 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
- "#% impex.exportItems( ""ConsignmentEntry"" , false );"
- # ---- Extension: core ---- Type: BruteForceLoginAttempts ----
- "#% impex.setTargetFile( ""BruteForceLoginAttempts.csv"" );"
- 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]
- "#% impex.exportItems( ""BruteForceLoginAttempts"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexerQueryParameter ----
- "#% impex.setTargetFile( ""SolrIndexerQueryParameter.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexerQueryParameter"" , false );"
- # ---- Extension: promotions ---- Type: PromotionResult ----
- "#% impex.setTargetFile( ""PromotionResult.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionResult"" , false );"
- # ---- Extension: core ---- Type: Order ----
- "#% impex.setTargetFile( ""Order.csv"" );"
- 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]
- "#% impex.exportItems( ""Order"" , false );"
- # ---- Extension: basecommerce ---- Type: ReplacementOrder ----
- "#% impex.setTargetFile( ""ReplacementOrder.csv"" );"
- 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]
- "#% impex.exportItems( ""ReplacementOrder"" , false );"
- # ---- Extension: catalog ---- Type: ProductReference ----
- "#% impex.setTargetFile( ""ProductReference.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductReference"" , false );"
- # ---- Extension: oauth2 ---- Type: OAuthRefreshToken ----
- "#% impex.setTargetFile( ""OAuthRefreshToken.csv"" );"
- 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]
- "#% impex.exportItems( ""OAuthRefreshToken"" , false );"
- # ---- Extension: catalog ---- Type: ProductCatalogVersionDifference ----
- "#% impex.setTargetFile( ""ProductCatalogVersionDifference.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductCatalogVersionDifference"" , false );"
- # ---- Extension: voucher ---- Type: OrderRestriction ----
- "#% impex.setTargetFile( ""OrderRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""OrderRestriction"" , false );"
- # ---- Extension: promotions ---- Type: PromotionNullAction ----
- "#% impex.setTargetFile( ""PromotionNullAction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionNullAction"" , false );"
- # ---- Extension: core ---- Type: Media ----
- "#% impex.setTargetFile( ""Media.csv"" );"
- 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
- "#% impex.exportItems( ""Media"" , false );"
- # ---- Extension: basecommerce ---- Type: BarcodeMedia ----
- "#% impex.setTargetFile( ""BarcodeMedia.csv"" );"
- 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
- "#% impex.exportItems( ""BarcodeMedia"" , false );"
- # ---- Extension: catalog ---- Type: CatalogUnawareMedia ----
- "#% impex.setTargetFile( ""CatalogUnawareMedia.csv"" );"
- 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
- "#% impex.exportItems( ""CatalogUnawareMedia"" , false );"
- # ---- Extension: catalog ---- Type: CatalogVersionSyncScheduleMedia ----
- "#% impex.setTargetFile( ""CatalogVersionSyncScheduleMedia.csv"" );"
- 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
- "#% impex.exportItems( ""CatalogVersionSyncScheduleMedia"" , false );"
- # ---- Extension: commons ---- Type: Document ----
- "#% impex.setTargetFile( ""Document.csv"" );"
- 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
- "#% impex.exportItems( ""Document"" , false );"
- # ---- Extension: auditreportservices ---- Type: AuditReportData ----
- "#% impex.setTargetFile( ""AuditReportData.csv"" );"
- 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
- "#% impex.exportItems( ""AuditReportData"" , false );"
- # ---- Extension: commons ---- Type: VelocityFormatter ----
- "#% impex.setTargetFile( ""VelocityFormatter.csv"" );"
- 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
- "#% impex.exportItems( ""VelocityFormatter"" , false );"
- # ---- Extension: commons ---- Type: XMLTransformFormatter ----
- "#% impex.setTargetFile( ""XMLTransformFormatter.csv"" );"
- 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
- "#% impex.exportItems( ""XMLTransformFormatter"" , false );"
- # ---- Extension: commons ---- Type: CustomOrder2XML ----
- "#% impex.setTargetFile( ""CustomOrder2XML.csv"" );"
- 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
- "#% impex.exportItems( ""CustomOrder2XML"" , false );"
- # ---- Extension: commons ---- Type: FOPFormatter ----
- "#% impex.setTargetFile( ""FOPFormatter.csv"" );"
- 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
- "#% impex.exportItems( ""FOPFormatter"" , false );"
- # ---- Extension: europe1 ---- Type: GlobalDiscountRow ----
- "#% impex.setTargetFile( ""GlobalDiscountRow.csv"" );"
- 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
- "#% impex.exportItems( ""GlobalDiscountRow"" , false );"
- # ---- Extension: basecommerce ---- Type: ReturnRequest ----
- "#% impex.setTargetFile( ""ReturnRequest.csv"" );"
- 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
- "#% impex.exportItems( ""ReturnRequest"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrProductRedirect ----
- "#% impex.setTargetFile( ""SolrProductRedirect.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrProductRedirect"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderCancelConfig ----
- "#% impex.setTargetFile( ""OrderCancelConfig.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderCancelConfig"" , false );"
- # ---- Extension: processing ---- Type: BusinessProcess ----
- "#% impex.setTargetFile( ""BusinessProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""BusinessProcess"" , false );"
- # ---- Extension: basecommerce ---- Type: ConsignmentProcess ----
- "#% impex.setTargetFile( ""ConsignmentProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""ConsignmentProcess"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderProcess ----
- "#% impex.setTargetFile( ""OrderProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""OrderProcess"" , false );"
- # ---- Extension: commerceservices ---- Type: QuoteProcess ----
- "#% impex.setTargetFile( ""QuoteProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""QuoteProcess"" , false );"
- # ---- Extension: basecommerce ---- Type: ReturnProcess ----
- "#% impex.setTargetFile( ""ReturnProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""ReturnProcess"" , false );"
- # ---- Extension: commerceservices ---- Type: StoreFrontProcess ----
- "#% impex.setTargetFile( ""StoreFrontProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""StoreFrontProcess"" , false );"
- # ---- Extension: commerceservices ---- Type: StoreFrontCustomerProcess ----
- "#% impex.setTargetFile( ""StoreFrontCustomerProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""StoreFrontCustomerProcess"" , false );"
- # ---- Extension: commerceservices ---- Type: ForgottenPasswordProcess ----
- "#% impex.setTargetFile( ""ForgottenPasswordProcess.csv"" );"
- 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)
- "#% impex.exportItems( ""ForgottenPasswordProcess"" , false );"
- # ---- Extension: platformbackoffice ---- Type: BackofficeSearchCondition ----
- "#% impex.setTargetFile( ""BackofficeSearchCondition.csv"" );"
- 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)
- "#% impex.exportItems( ""BackofficeSearchCondition"" , false );"
- # ---- Extension: basecommerce ---- Type: BaseSite ----
- "#% impex.setTargetFile( ""BaseSite.csv"" );"
- 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]
- "#% impex.exportItems( ""BaseSite"" , false );"
- # ---- Extension: catalog ---- Type: Keyword ----
- "#% impex.setTargetFile( ""Keyword.csv"" );"
- 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]
- "#% impex.exportItems( ""Keyword"" , false );"
- # ---- Extension: catalog ---- Type: ClassificationKeyword ----
- "#% impex.setTargetFile( ""ClassificationKeyword.csv"" );"
- 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]
- "#% impex.exportItems( ""ClassificationKeyword"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderReturnRecord ----
- "#% impex.setTargetFile( ""OrderReturnRecord.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderReturnRecord"" , false );"
- # ---- Extension: core ---- Type: Product ----
- "#% impex.setTargetFile( ""Product.csv"" );"
- 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
- "#% impex.exportItems( ""Product"" , false );"
- # ---- Extension: basecommerce ---- Type: GenericVariantProduct ----
- "#% impex.setTargetFile( ""GenericVariantProduct.csv"" );"
- 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
- "#% impex.exportItems( ""GenericVariantProduct"" , false );"
- # ---- Extension: ecrpimbackoffice ---- Type: TdsIngredientVariant ----
- "#% impex.setTargetFile( ""TdsIngredientVariant.csv"" );"
- 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
- "#% impex.exportItems( ""TdsIngredientVariant"" , false );"
- # ---- Extension: catalog ---- Type: ItemSyncTimestamp ----
- "#% impex.setTargetFile( ""ItemSyncTimestamp.csv"" );"
- 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]
- "#% impex.exportItems( ""ItemSyncTimestamp"" , false );"
- # ---- Extension: promotions ---- Type: OrderThresholdChangeDeliveryModePromotion ----
- "#% impex.setTargetFile( ""OrderThresholdChangeDeliveryModePromotion.csv"" );"
- 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
- "#% impex.exportItems( ""OrderThresholdChangeDeliveryModePromotion"" , false );"
- # ---- Extension: impex ---- Type: ExternalImportKey ----
- "#% impex.setTargetFile( ""ExternalImportKey.csv"" );"
- 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]
- "#% impex.exportItems( ""ExternalImportKey"" , false );"
- # ---- Extension: core ---- Type: SavedValues ----
- "#% impex.setTargetFile( ""SavedValues.csv"" );"
- 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]
- "#% impex.exportItems( ""SavedValues"" , false );"
- # ---- Extension: processing ---- Type: DistributedProcess ----
- "#% impex.setTargetFile( ""DistributedProcess.csv"" );"
- 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]
- "#% impex.exportItems( ""DistributedProcess"" , false );"
- # ---- Extension: impex ---- Type: DistributedImportProcess ----
- "#% impex.setTargetFile( ""DistributedImportProcess.csv"" );"
- 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]
- "#% impex.exportItems( ""DistributedImportProcess"" , false );"
- # ---- Extension: processing ---- Type: SimpleDistributedProcess ----
- "#% impex.setTargetFile( ""SimpleDistributedProcess.csv"" );"
- 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]
- "#% impex.exportItems( ""SimpleDistributedProcess"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexerDistributedProcess ----
- "#% impex.setTargetFile( ""SolrIndexerDistributedProcess.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexerDistributedProcess"" , false );"
- # ---- Extension: catalog ---- Type: Catalog ----
- "#% impex.setTargetFile( ""Catalog.csv"" );"
- 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
- "#% impex.exportItems( ""Catalog"" , false );"
- # ---- Extension: catalog ---- Type: ClassificationSystem ----
- "#% impex.setTargetFile( ""ClassificationSystem.csv"" );"
- 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
- "#% impex.exportItems( ""ClassificationSystem"" , false );"
- # ---- Extension: comments ---- Type: CommentUserSetting ----
- "#% impex.setTargetFile( ""CommentUserSetting.csv"" );"
- 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]
- "#% impex.exportItems( ""CommentUserSetting"" , false );"
- # ---- Extension: customerreview ---- Type: CustomerReview ----
- "#% impex.setTargetFile( ""CustomerReview.csv"" );"
- 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]
- "#% impex.exportItems( ""CustomerReview"" , false );"
- # ---- Extension: basecommerce ---- Type: DeeplinkUrl ----
- "#% impex.setTargetFile( ""DeeplinkUrl.csv"" );"
- 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]
- "#% impex.exportItems( ""DeeplinkUrl"" , false );"
- # ---- Extension: core ---- Type: Tax ----
- "#% impex.setTargetFile( ""Tax.csv"" );"
- 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
- "#% impex.exportItems( ""Tax"" , false );"
- # ---- Extension: core ---- Type: Title ----
- "#% impex.setTargetFile( ""Title.csv"" );"
- 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]
- "#% impex.exportItems( ""Title"" , false );"
- # ---- Extension: core ---- Type: PaymentInfo ----
- "#% impex.setTargetFile( ""PaymentInfo.csv"" );"
- 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]
- "#% impex.exportItems( ""PaymentInfo"" , false );"
- # ---- Extension: core ---- Type: AdvancePaymentInfo ----
- "#% impex.setTargetFile( ""AdvancePaymentInfo.csv"" );"
- 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]
- "#% impex.exportItems( ""AdvancePaymentInfo"" , false );"
- # ---- Extension: core ---- Type: CreditCardPaymentInfo ----
- "#% impex.setTargetFile( ""CreditCardPaymentInfo.csv"" );"
- 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]
- "#% impex.exportItems( ""CreditCardPaymentInfo"" , false );"
- # ---- Extension: core ---- Type: DebitPaymentInfo ----
- "#% impex.setTargetFile( ""DebitPaymentInfo.csv"" );"
- 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]
- "#% impex.exportItems( ""DebitPaymentInfo"" , false );"
- # ---- Extension: core ---- Type: InvoicePaymentInfo ----
- "#% impex.setTargetFile( ""InvoicePaymentInfo.csv"" );"
- 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]
- "#% impex.exportItems( ""InvoicePaymentInfo"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexOperation ----
- "#% impex.setTargetFile( ""SolrIndexOperation.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexOperation"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowActionComment ----
- "#% impex.setTargetFile( ""WorkflowActionComment.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowActionComment"" , false );"
- # ---- Extension: processing ---- Type: CronJobHistory ----
- "#% impex.setTargetFile( ""CronJobHistory.csv"" );"
- 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
- "#% impex.exportItems( ""CronJobHistory"" , false );"
- # ---- Extension: core ---- Type: MediaContext ----
- "#% impex.setTargetFile( ""MediaContext.csv"" );"
- 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]
- "#% impex.exportItems( ""MediaContext"" , false );"
- # ---- Extension: promotions ---- Type: PromotionGroup ----
- "#% impex.setTargetFile( ""PromotionGroup.csv"" );"
- 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]
- "#% impex.exportItems( ""PromotionGroup"" , false );"
- # ---- Extension: voucher ---- Type: UserRestriction ----
- "#% impex.setTargetFile( ""UserRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""UserRestriction"" , false );"
- # ---- Extension: promotions ---- Type: OrderThresholdFreeVoucherPromotion ----
- "#% impex.setTargetFile( ""OrderThresholdFreeVoucherPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""OrderThresholdFreeVoucherPromotion"" , false );"
- # ---- Extension: payment ---- Type: PaymentTransaction ----
- "#% impex.setTargetFile( ""PaymentTransaction.csv"" );"
- 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]
- "#% impex.exportItems( ""PaymentTransaction"" , false );"
- # ---- Extension: core ---- Type: AuditReportConfig ----
- "#% impex.setTargetFile( ""AuditReportConfig.csv"" );"
- 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]
- "#% impex.exportItems( ""AuditReportConfig"" , false );"
- # ---- Extension: validation ---- Type: ConstraintGroup ----
- "#% impex.setTargetFile( ""ConstraintGroup.csv"" );"
- 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]
- "#% impex.exportItems( ""ConstraintGroup"" , false );"
- # ---- Extension: validation ---- Type: CoverageConstraintGroup ----
- "#% impex.setTargetFile( ""CoverageConstraintGroup.csv"" );"
- 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]
- "#% impex.exportItems( ""CoverageConstraintGroup"" , false );"
- # ---- Extension: core ---- Type: IndexTestItem ----
- "#% impex.setTargetFile( ""IndexTestItem.csv"" );"
- 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]
- "#% impex.exportItems( ""IndexTestItem"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowItemAttachment ----
- "#% impex.setTargetFile( ""WorkflowItemAttachment.csv"" );"
- 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
- "#% impex.exportItems( ""WorkflowItemAttachment"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrQueryAggregatedStats ----
- "#% impex.setTargetFile( ""SolrQueryAggregatedStats.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrQueryAggregatedStats"" , false );"
- # ---- Extension: core ---- Type: QuoteEntry ----
- "#% impex.setTargetFile( ""QuoteEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""QuoteEntry"" , false );"
- # ---- Extension: comments ---- Type: Comment ----
- "#% impex.setTargetFile( ""Comment.csv"" );"
- 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]
- "#% impex.exportItems( ""Comment"" , false );"
- # ---- Extension: comments ---- Type: CommentType ----
- "#% impex.setTargetFile( ""CommentType.csv"" );"
- 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]
- "#% impex.exportItems( ""CommentType"" , false );"
- # ---- Extension: promotions ---- Type: PromotionUserRestriction ----
- "#% impex.setTargetFile( ""PromotionUserRestriction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionUserRestriction"" , false );"
- # ---- Extension: processing ---- Type: BusinessProcessParameter ----
- "#% impex.setTargetFile( ""BusinessProcessParameter.csv"" );"
- 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]
- "#% impex.exportItems( ""BusinessProcessParameter"" , false );"
- # ---- Extension: core ---- Type: Cart ----
- "#% impex.setTargetFile( ""Cart.csv"" );"
- 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]
- "#% impex.exportItems( ""Cart"" , false );"
- # ---- Extension: basecommerce ---- Type: ReplacementEntry ----
- "#% impex.setTargetFile( ""ReplacementEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""ReplacementEntry"" , false );"
- # ---- Extension: promotions ---- Type: PromotionQuantityAndPricesRow ----
- "#% impex.setTargetFile( ""PromotionQuantityAndPricesRow.csv"" );"
- 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]
- "#% impex.exportItems( ""PromotionQuantityAndPricesRow"" , false );"
- # ---- Extension: processing ---- Type: AfterRetentionCleanupRule ----
- "#% impex.setTargetFile( ""AfterRetentionCleanupRule.csv"" );"
- 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]
- "#% impex.exportItems( ""AfterRetentionCleanupRule"" , false );"
- # ---- Extension: core ---- Type: Address ----
- "#% impex.setTargetFile( ""Address.csv"" );"
- 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
- "#% impex.exportItems( ""Address"" , false );"
- # ---- Extension: oauth2 ---- Type: OAuthAuthorizationCode ----
- "#% impex.setTargetFile( ""OAuthAuthorizationCode.csv"" );"
- 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]
- "#% impex.exportItems( ""OAuthAuthorizationCode"" , false );"
- # ---- Extension: commons ---- Type: RendererTemplate ----
- "#% impex.setTargetFile( ""RendererTemplate.csv"" );"
- 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]
- "#% impex.exportItems( ""RendererTemplate"" , false );"
- # ---- Extension: auditreportservices ---- Type: AuditReportTemplate ----
- "#% impex.setTargetFile( ""AuditReportTemplate.csv"" );"
- 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]
- "#% impex.exportItems( ""AuditReportTemplate"" , false );"
- # ---- Extension: core ---- Type: Currency ----
- "#% impex.setTargetFile( ""Currency.csv"" );"
- 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]
- "#% impex.exportItems( ""Currency"" , false );"
- # ---- Extension: promotions ---- Type: OrderThresholdPerfectPartnerPromotion ----
- "#% impex.setTargetFile( ""OrderThresholdPerfectPartnerPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""OrderThresholdPerfectPartnerPromotion"" , false );"
- # ---- Extension: promotions ---- Type: ProductPerfectPartnerPromotion ----
- "#% impex.setTargetFile( ""ProductPerfectPartnerPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductPerfectPartnerPromotion"" , false );"
- # ---- Extension: catalog ---- Type: ClassificationAttributeValue ----
- "#% impex.setTargetFile( ""ClassificationAttributeValue.csv"" );"
- 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]
- "#% impex.exportItems( ""ClassificationAttributeValue"" , false );"
- # ---- Extension: promotions ---- Type: ProductFixedPricePromotion ----
- "#% impex.setTargetFile( ""ProductFixedPricePromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductFixedPricePromotion"" , false );"
- # ---- Extension: core ---- Type: Country ----
- "#% impex.setTargetFile( ""Country.csv"" );"
- 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]
- "#% impex.exportItems( ""Country"" , false );"
- # ---- Extension: catalog ---- Type: Category ----
- "#% impex.setTargetFile( ""Category.csv"" );"
- 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)
- "#% impex.exportItems( ""Category"" , false );"
- # ---- Extension: catalog ---- Type: ClassificationClass ----
- "#% impex.setTargetFile( ""ClassificationClass.csv"" );"
- 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)
- "#% impex.exportItems( ""ClassificationClass"" , false );"
- # ---- Extension: catalog ---- Type: ConfigurationCategory ----
- "#% impex.setTargetFile( ""ConfigurationCategory.csv"" );"
- 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)
- "#% impex.exportItems( ""ConfigurationCategory"" , false );"
- # ---- Extension: basecommerce ---- Type: VariantCategory ----
- "#% impex.setTargetFile( ""VariantCategory.csv"" );"
- 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)
- "#% impex.exportItems( ""VariantCategory"" , false );"
- # ---- Extension: basecommerce ---- Type: VariantValueCategory ----
- "#% impex.setTargetFile( ""VariantValueCategory.csv"" );"
- 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)
- "#% impex.exportItems( ""VariantValueCategory"" , false );"
- # ---- Extension: voucher ---- Type: RegularCustomerOrderTotalRestriction ----
- "#% impex.setTargetFile( ""RegularCustomerOrderTotalRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""RegularCustomerOrderTotalRestriction"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderHistoryEntry ----
- "#% impex.setTargetFile( ""OrderHistoryEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderHistoryEntry"" , false );"
- # ---- Extension: voucher ---- Type: DateRestriction ----
- "#% impex.setTargetFile( ""DateRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""DateRestriction"" , false );"
- # ---- Extension: promotions ---- Type: OrderThresholdFreeGiftPromotion ----
- "#% impex.setTargetFile( ""OrderThresholdFreeGiftPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""OrderThresholdFreeGiftPromotion"" , false );"
- # ---- Extension: commerceservices ---- Type: Consent ----
- "#% impex.setTargetFile( ""Consent.csv"" );"
- 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]
- "#% impex.exportItems( ""Consent"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrSearchQueryProperty ----
- "#% impex.setTargetFile( ""SolrSearchQueryProperty.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrSearchQueryProperty"" , false );"
- # ---- Extension: core ---- Type: MediaFormat ----
- "#% impex.setTargetFile( ""MediaFormat.csv"" );"
- 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]
- "#% impex.exportItems( ""MediaFormat"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrValueRangeSet ----
- "#% impex.setTargetFile( ""SolrValueRangeSet.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrValueRangeSet"" , false );"
- # ---- Extension: core ---- Type: AbstractContactInfo ----
- "#% impex.setTargetFile( ""AbstractContactInfo.csv"" );"
- 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
- "#% impex.exportItems( ""AbstractContactInfo"" , false );"
- # ---- Extension: core ---- Type: PhoneContactInfo ----
- "#% impex.setTargetFile( ""PhoneContactInfo.csv"" );"
- 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
- "#% impex.exportItems( ""PhoneContactInfo"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderEntryCancelRecordEntry ----
- "#% impex.setTargetFile( ""OrderEntryCancelRecordEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderEntryCancelRecordEntry"" , false );"
- # ---- Extension: europe1 ---- Type: PriceRow ----
- "#% impex.setTargetFile( ""PriceRow.csv"" );"
- 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
- "#% impex.exportItems( ""PriceRow"" , false );"
- # ---- Extension: catalog ---- Type: ClassificationAttribute ----
- "#% impex.setTargetFile( ""ClassificationAttribute.csv"" );"
- 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]
- "#% impex.exportItems( ""ClassificationAttribute"" , false );"
- # ---- Extension: promotions ---- Type: PromotionProductRestriction ----
- "#% impex.setTargetFile( ""PromotionProductRestriction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionProductRestriction"" , false );"
- # ---- Extension: promotions ---- Type: PromotionPriceRow ----
- "#% impex.setTargetFile( ""PromotionPriceRow.csv"" );"
- 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]
- "#% impex.exportItems( ""PromotionPriceRow"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderReplacementRecordEntry ----
- "#% impex.setTargetFile( ""OrderReplacementRecordEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderReplacementRecordEntry"" , false );"
- # ---- Extension: promotions ---- Type: PromotionOrderAdjustTotalAction ----
- "#% impex.setTargetFile( ""PromotionOrderAdjustTotalAction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionOrderAdjustTotalAction"" , false );"
- # ---- Extension: promotions ---- Type: OrderThresholdDiscountPromotion ----
- "#% impex.setTargetFile( ""OrderThresholdDiscountPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""OrderThresholdDiscountPromotion"" , false );"
- # ---- Extension: promotions ---- Type: ProductPercentageDiscountPromotion ----
- "#% impex.setTargetFile( ""ProductPercentageDiscountPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductPercentageDiscountPromotion"" , false );"
- # ---- Extension: processing ---- Type: SimpleAction ----
- "#% impex.setTargetFile( ""SimpleAction.csv"" );"
- 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]
- "#% impex.exportItems( ""SimpleAction"" , false );"
- # ---- Extension: validation ---- Type: TypeConstraint ----
- "#% impex.setTargetFile( ""TypeConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""TypeConstraint"" , false );"
- # ---- Extension: validation ---- Type: DynamicConstraint ----
- "#% impex.setTargetFile( ""DynamicConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""DynamicConstraint"" , false );"
- # ---- Extension: validation ---- Type: XorNullReferenceConstraint ----
- "#% impex.setTargetFile( ""XorNullReferenceConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""XorNullReferenceConstraint"" , false );"
- # ---- Extension: oauth2 ---- Type: BruteForceOAuthDisabledAudit ----
- "#% impex.setTargetFile( ""BruteForceOAuthDisabledAudit.csv"" );"
- 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]
- "#% impex.exportItems( ""BruteForceOAuthDisabledAudit"" , false );"
- # ---- Extension: promotions ---- Type: ProductSteppedMultiBuyPromotion ----
- "#% impex.setTargetFile( ""ProductSteppedMultiBuyPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductSteppedMultiBuyPromotion"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowDecisionTemplate ----
- "#% impex.setTargetFile( ""WorkflowDecisionTemplate.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowDecisionTemplate"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowTemplate ----
- "#% impex.setTargetFile( ""WorkflowTemplate.csv"" );"
- 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
- "#% impex.exportItems( ""WorkflowTemplate"" , false );"
- # ---- Extension: promotions ---- Type: PromotionOrderChangeDeliveryModeAction ----
- "#% impex.setTargetFile( ""PromotionOrderChangeDeliveryModeAction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionOrderChangeDeliveryModeAction"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: ComposedIndexedType ----
- "#% impex.setTargetFile( ""ComposedIndexedType.csv"" );"
- 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]
- "#% impex.exportItems( ""ComposedIndexedType"" , false );"
- # ---- Extension: validation ---- Type: AttributeConstraint ----
- "#% impex.setTargetFile( ""AttributeConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""AttributeConstraint"" , false );"
- # ---- Extension: validation ---- Type: AssertFalseConstraint ----
- "#% impex.setTargetFile( ""AssertFalseConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""AssertFalseConstraint"" , false );"
- # ---- Extension: validation ---- Type: AssertTrueConstraint ----
- "#% impex.setTargetFile( ""AssertTrueConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""AssertTrueConstraint"" , false );"
- # ---- Extension: validation ---- Type: DecimalMaxConstraint ----
- "#% impex.setTargetFile( ""DecimalMaxConstraint.csv"" );"
- 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]
- "#% impex.exportItems( ""DecimalMaxConstraint"" , false );"
- # ---- Extension: validation ---- Type: DecimalMinConstraint ----
- "#% impex.setTargetFile( ""DecimalMinConstraint.csv"" );"
- 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]
- "#% impex.exportItems( ""DecimalMinConstraint"" , false );"
- # ---- Extension: validation ---- Type: DigitsConstraint ----
- "#% impex.setTargetFile( ""DigitsConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""DigitsConstraint"" , false );"
- # ---- Extension: validation ---- Type: FutureConstraint ----
- "#% impex.setTargetFile( ""FutureConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""FutureConstraint"" , false );"
- # ---- Extension: validation ---- Type: HybrisDecimalMaxConstraint ----
- "#% impex.setTargetFile( ""HybrisDecimalMaxConstraint.csv"" );"
- 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]
- "#% impex.exportItems( ""HybrisDecimalMaxConstraint"" , false );"
- # ---- Extension: validation ---- Type: HybrisDecimalMinConstraint ----
- "#% impex.setTargetFile( ""HybrisDecimalMinConstraint.csv"" );"
- 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]
- "#% impex.exportItems( ""HybrisDecimalMinConstraint"" , false );"
- # ---- Extension: validation ---- Type: MaxConstraint ----
- "#% impex.setTargetFile( ""MaxConstraint.csv"" );"
- 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]
- "#% impex.exportItems( ""MaxConstraint"" , false );"
- # ---- Extension: validation ---- Type: MinConstraint ----
- "#% impex.setTargetFile( ""MinConstraint.csv"" );"
- 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]
- "#% impex.exportItems( ""MinConstraint"" , false );"
- # ---- Extension: validation ---- Type: NotBlankConstraint ----
- "#% impex.setTargetFile( ""NotBlankConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""NotBlankConstraint"" , false );"
- # ---- Extension: validation ---- Type: NotEmptyConstraint ----
- "#% impex.setTargetFile( ""NotEmptyConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""NotEmptyConstraint"" , false );"
- # ---- Extension: validation ---- Type: NotNullConstraint ----
- "#% impex.setTargetFile( ""NotNullConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""NotNullConstraint"" , false );"
- # ---- Extension: validation ---- Type: NullConstraint ----
- "#% impex.setTargetFile( ""NullConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""NullConstraint"" , false );"
- # ---- Extension: validation ---- Type: PastConstraint ----
- "#% impex.setTargetFile( ""PastConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""PastConstraint"" , false );"
- # ---- Extension: validation ---- Type: PatternConstraint ----
- "#% impex.setTargetFile( ""PatternConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""PatternConstraint"" , false );"
- # ---- Extension: validation ---- Type: SizeConstraint ----
- "#% impex.setTargetFile( ""SizeConstraint.csv"" );"
- 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)
- "#% impex.exportItems( ""SizeConstraint"" , false );"
- # ---- Extension: core ---- Type: DeliveryMode ----
- "#% impex.setTargetFile( ""DeliveryMode.csv"" );"
- 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
- "#% impex.exportItems( ""DeliveryMode"" , false );"
- # ---- Extension: commerceservices ---- Type: PickUpDeliveryMode ----
- "#% impex.setTargetFile( ""PickUpDeliveryMode.csv"" );"
- 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
- "#% impex.exportItems( ""PickUpDeliveryMode"" , false );"
- # ---- Extension: deliveryzone ---- Type: ZoneDeliveryMode ----
- "#% impex.setTargetFile( ""ZoneDeliveryMode.csv"" );"
- 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
- "#% impex.exportItems( ""ZoneDeliveryMode"" , false );"
- # ---- Extension: basecommerce ---- Type: StockLevelHistoryEntry ----
- "#% impex.setTargetFile( ""StockLevelHistoryEntry.csv"" );"
- 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))
- "#% impex.exportItems( ""StockLevelHistoryEntry"" , false );"
- # ---- Extension: core ---- Type: UserRight ----
- "#% impex.setTargetFile( ""UserRight.csv"" , true, 0, 0 );"
- #SPECIAL CASE: Type UserRight will be exported with special logic (without header definition), see https://wiki.hybris.com/x/PIFvAg
- "#% impex.exportItems( ""UserRight"" , false );"
- # ---- Extension: ecrpimbackoffice ---- Type: FactoryCode ----
- "#% impex.setTargetFile( ""FactoryCode.csv"" );"
- 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]
- "#% impex.exportItems( ""FactoryCode"" , false );"
- # ---- Extension: catalog ---- Type: ClassificationAttributeUnit ----
- "#% impex.setTargetFile( ""ClassificationAttributeUnit.csv"" );"
- 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]
- "#% impex.exportItems( ""ClassificationAttributeUnit"" , false );"
- # ---- Extension: advancedsavedquery ---- Type: SimpleAdvancedSavedQuerySearchParameter ----
- "#% impex.setTargetFile( ""SimpleAdvancedSavedQuerySearchParameter.csv"" );"
- 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]
- "#% impex.exportItems( ""SimpleAdvancedSavedQuerySearchParameter"" , false );"
- # ---- Extension: promotions ---- Type: ProductBundlePromotion ----
- "#% impex.setTargetFile( ""ProductBundlePromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductBundlePromotion"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowDecision ----
- "#% impex.setTargetFile( ""WorkflowDecision.csv"" );"
- 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]
- "#% impex.exportItems( ""WorkflowDecision"" , false );"
- # ---- Extension: core ---- Type: MediaContainer ----
- "#% impex.setTargetFile( ""MediaContainer.csv"" );"
- 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]
- "#% impex.exportItems( ""MediaContainer"" , false );"
- # ---- Extension: basecommerce ---- Type: Consignment ----
- "#% impex.setTargetFile( ""Consignment.csv"" );"
- 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]
- "#% impex.exportItems( ""Consignment"" , false );"
- # ---- Extension: commerceservices ---- Type: SolrSort ----
- "#% impex.setTargetFile( ""SolrSort.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrSort"" , false );"
- # ---- Extension: basecommerce ---- Type: WeekdayOpeningDay ----
- "#% impex.setTargetFile( ""WeekdayOpeningDay.csv"" );"
- 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]
- "#% impex.exportItems( ""WeekdayOpeningDay"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrCategoryRedirect ----
- "#% impex.setTargetFile( ""SolrCategoryRedirect.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrCategoryRedirect"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrSynonymConfig ----
- "#% impex.setTargetFile( ""SolrSynonymConfig.csv"" );"
- 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
- "#% impex.exportItems( ""SolrSynonymConfig"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrStopWord ----
- "#% impex.setTargetFile( ""SolrStopWord.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrStopWord"" , false );"
- # ---- Extension: processing ---- Type: Task ----
- "#% impex.setTargetFile( ""Task.csv"" );"
- 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
- "#% impex.exportItems( ""Task"" , false );"
- # ---- Extension: processing ---- Type: DistributedProcessTransitionTask ----
- "#% impex.setTargetFile( ""DistributedProcessTransitionTask.csv"" );"
- 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]
- "#% impex.exportItems( ""DistributedProcessTransitionTask"" , false );"
- # ---- Extension: processing ---- Type: DistributedProcessWorkerTask ----
- "#% impex.setTargetFile( ""DistributedProcessWorkerTask.csv"" );"
- 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
- "#% impex.exportItems( ""DistributedProcessWorkerTask"" , false );"
- # ---- Extension: processing ---- Type: ProcessTask ----
- "#% impex.setTargetFile( ""ProcessTask.csv"" );"
- 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
- "#% impex.exportItems( ""ProcessTask"" , false );"
- # ---- Extension: processing ---- Type: ScriptingTask ----
- "#% impex.setTargetFile( ""ScriptingTask.csv"" );"
- 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]
- "#% impex.exportItems( ""ScriptingTask"" , false );"
- # ---- Extension: processing ---- Type: TriggerTask ----
- "#% impex.setTargetFile( ""TriggerTask.csv"" );"
- 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]
- "#% impex.exportItems( ""TriggerTask"" , false );"
- # ---- Extension: core ---- Type: Unit ----
- "#% impex.setTargetFile( ""Unit.csv"" );"
- 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]
- "#% impex.exportItems( ""Unit"" , false );"
- # ---- Extension: basecommerce ---- Type: SpecialOpeningDay ----
- "#% impex.setTargetFile( ""SpecialOpeningDay.csv"" );"
- 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]
- "#% impex.exportItems( ""SpecialOpeningDay"" , false );"
- # ---- Extension: core ---- Type: SavedValueEntry ----
- "#% impex.setTargetFile( ""SavedValueEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""SavedValueEntry"" , false );"
- # ---- Extension: catalog ---- Type: Agreement ----
- "#% impex.setTargetFile( ""Agreement.csv"" );"
- 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)
- "#% impex.exportItems( ""Agreement"" , false );"
- # ---- Extension: core ---- Type: StoredHttpSession ----
- "#% impex.setTargetFile( ""StoredHttpSession.csv"" );"
- 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]
- "#% impex.exportItems( ""StoredHttpSession"" , false );"
- # ---- Extension: commerceservices ---- Type: StoreLocatorFeature ----
- "#% impex.setTargetFile( ""StoreLocatorFeature.csv"" );"
- 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]
- "#% impex.exportItems( ""StoreLocatorFeature"" , false );"
- # ---- Extension: core ---- Type: CartEntry ----
- "#% impex.setTargetFile( ""CartEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""CartEntry"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexedProperty ----
- "#% impex.setTargetFile( ""SolrIndexedProperty.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexedProperty"" , false );"
- # ---- Extension: promotions ---- Type: PromotionOrderEntryAdjustAction ----
- "#% impex.setTargetFile( ""PromotionOrderEntryAdjustAction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionOrderEntryAdjustAction"" , false );"
- # ---- Extension: core ---- Type: DerivedMedia ----
- "#% impex.setTargetFile( ""DerivedMedia.csv"" );"
- 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]
- "#% impex.exportItems( ""DerivedMedia"" , false );"
- # ---- Extension: core ---- Type: SavedQuery ----
- "#% impex.setTargetFile( ""SavedQuery.csv"" );"
- 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]
- "#% impex.exportItems( ""SavedQuery"" , false );"
- # ---- Extension: advancedsavedquery ---- Type: AdvancedSavedQuery ----
- "#% impex.setTargetFile( ""AdvancedSavedQuery.csv"" );"
- 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]
- "#% impex.exportItems( ""AdvancedSavedQuery"" , false );"
- # ---- Extension: voucher ---- Type: RegularCustomerOrderQuantityRestriction ----
- "#% impex.setTargetFile( ""RegularCustomerOrderQuantityRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""RegularCustomerOrderQuantityRestriction"" , false );"
- # ---- Extension: core ---- Type: Discount ----
- "#% impex.setTargetFile( ""Discount.csv"" );"
- 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
- "#% impex.exportItems( ""Discount"" , false );"
- # ---- Extension: voucher ---- Type: PromotionVoucher ----
- "#% impex.setTargetFile( ""PromotionVoucher.csv"" );"
- 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
- "#% impex.exportItems( ""PromotionVoucher"" , false );"
- # ---- Extension: voucher ---- Type: SerialVoucher ----
- "#% impex.setTargetFile( ""SerialVoucher.csv"" );"
- 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]
- "#% impex.exportItems( ""SerialVoucher"" , false );"
- # ---- Extension: workflow ---- Type: WorkflowActionTemplate ----
- "#% impex.setTargetFile( ""WorkflowActionTemplate.csv"" );"
- 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
- "#% impex.exportItems( ""WorkflowActionTemplate"" , false );"
- # ---- Extension: workflow ---- Type: AutomatedWorkflowActionTemplate ----
- "#% impex.setTargetFile( ""AutomatedWorkflowActionTemplate.csv"" );"
- 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
- "#% impex.exportItems( ""AutomatedWorkflowActionTemplate"" , false );"
- # ---- Extension: catalog ---- Type: ProductFeature ----
- "#% impex.setTargetFile( ""ProductFeature.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductFeature"" , false );"
- # ---- Extension: comments ---- Type: CommentAttachment ----
- "#% impex.setTargetFile( ""CommentAttachment.csv"" );"
- 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]
- "#% impex.exportItems( ""CommentAttachment"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndex ----
- "#% impex.setTargetFile( ""SolrIndex.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndex"" , false );"
- # ---- Extension: catalog ---- Type: CatalogVersionSyncCronJobHistory ----
- "#% impex.setTargetFile( ""CatalogVersionSyncCronJobHistory.csv"" );"
- 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
- "#% impex.exportItems( ""CatalogVersionSyncCronJobHistory"" , false );"
- # ---- Extension: processing ---- Type: CompositeEntry ----
- "#% impex.setTargetFile( ""CompositeEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""CompositeEntry"" , false );"
- # ---- Extension: commons ---- Type: Format ----
- "#% impex.setTargetFile( ""Format.csv"" );"
- 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]
- "#% impex.exportItems( ""Format"" , false );"
- # ---- Extension: comments ---- Type: Reply ----
- "#% impex.setTargetFile( ""Reply.csv"" );"
- 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]
- "#% impex.exportItems( ""Reply"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexOperationRecord ----
- "#% impex.setTargetFile( ""SolrIndexOperationRecord.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexOperationRecord"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrSearchConfig ----
- "#% impex.setTargetFile( ""SolrSearchConfig.csv"" );"
- 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
- "#% impex.exportItems( ""SolrSearchConfig"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderRefundRecordEntry ----
- "#% impex.setTargetFile( ""OrderRefundRecordEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderRefundRecordEntry"" , false );"
- # ---- Extension: payment ---- Type: PaymentTransactionEntry ----
- "#% impex.setTargetFile( ""PaymentTransactionEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""PaymentTransactionEntry"" , false );"
- # ---- Extension: backofficesolrsearch ---- Type: SolrModifiedItem ----
- "#% impex.setTargetFile( ""SolrModifiedItem.csv"" );"
- 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)
- "#% impex.exportItems( ""SolrModifiedItem"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexConfig ----
- "#% impex.setTargetFile( ""SolrIndexConfig.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexConfig"" , false );"
- # ---- Extension: core ---- Type: GenericTestItem ----
- "#% impex.setTargetFile( ""GenericTestItem.csv"" );"
- 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]
- "#% impex.exportItems( ""GenericTestItem"" , false );"
- # ---- Extension: commons ---- Type: JaloVelocityRenderer ----
- "#% impex.setTargetFile( ""JaloVelocityRenderer.csv"" );"
- 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
- "#% impex.exportItems( ""JaloVelocityRenderer"" , false );"
- # ---- Extension: paymentstandard ---- Type: StandardPaymentModeValue ----
- "#% impex.setTargetFile( ""StandardPaymentModeValue.csv"" );"
- 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]
- "#% impex.exportItems( ""StandardPaymentModeValue"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrSearchQuerySort ----
- "#% impex.setTargetFile( ""SolrSearchQuerySort.csv"" );"
- 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
- "#% impex.exportItems( ""SolrSearchQuerySort"" , false );"
- # ---- Extension: scripting ---- Type: Script ----
- "#% impex.setTargetFile( ""Script.csv"" );"
- 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]
- "#% impex.exportItems( ""Script"" , false );"
- # ---- Extension: europe1 ---- Type: DiscountRow ----
- "#% impex.setTargetFile( ""DiscountRow.csv"" );"
- 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
- "#% impex.exportItems( ""DiscountRow"" , false );"
- # ---- Extension: promotions ---- Type: PromotionOrderEntryConsumed ----
- "#% impex.setTargetFile( ""PromotionOrderEntryConsumed.csv"" );"
- 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
- "#% impex.exportItems( ""PromotionOrderEntryConsumed"" , false );"
- # ---- Extension: core ---- Type: Quote ----
- "#% impex.setTargetFile( ""Quote.csv"" );"
- 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]
- "#% impex.exportItems( ""Quote"" , false );"
- # ---- Extension: basecommerce ---- Type: FraudSymptomScoring ----
- "#% impex.setTargetFile( ""FraudSymptomScoring.csv"" );"
- 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]
- "#% impex.exportItems( ""FraudSymptomScoring"" , false );"
- # ---- Extension: processing ---- Type: FlexibleSearchRetentionRule ----
- "#% impex.setTargetFile( ""FlexibleSearchRetentionRule.csv"" );"
- 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]
- "#% impex.exportItems( ""FlexibleSearchRetentionRule"" , false );"
- # ---- Extension: core ---- Type: OrderEntry ----
- "#% impex.setTargetFile( ""OrderEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderEntry"" , false );"
- # ---- Extension: basecommerce ---- Type: ReplacementOrderEntry ----
- "#% impex.setTargetFile( ""ReplacementOrderEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""ReplacementOrderEntry"" , false );"
- # ---- Extension: core ---- Type: Language ----
- "#% impex.setTargetFile( ""Language.csv"" );"
- 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]
- "#% impex.exportItems( ""Language"" , false );"
- # ---- Extension: voucher ---- Type: VoucherInvalidation ----
- "#% impex.setTargetFile( ""VoucherInvalidation.csv"" );"
- 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]
- "#% impex.exportItems( ""VoucherInvalidation"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderEntryReturnRecordEntry ----
- "#% impex.setTargetFile( ""OrderEntryReturnRecordEntry.csv"" );"
- 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
- "#% impex.exportItems( ""OrderEntryReturnRecordEntry"" , false );"
- # ---- Extension: commons ---- Type: ParserProperty ----
- "#% impex.setTargetFile( ""ParserProperty.csv"" );"
- 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
- "#% impex.exportItems( ""ParserProperty"" , false );"
- # ---- Extension: deliveryzone ---- Type: Zone ----
- "#% impex.setTargetFile( ""Zone.csv"" );"
- 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]
- "#% impex.exportItems( ""Zone"" , false );"
- # ---- Extension: commerceservices ---- Type: SolrSortField ----
- "#% impex.setTargetFile( ""SolrSortField.csv"" );"
- 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
- "#% impex.exportItems( ""SolrSortField"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderCancelRecordEntry ----
- "#% impex.setTargetFile( ""OrderCancelRecordEntry.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderCancelRecordEntry"" , false );"
- # ---- Extension: core ---- Type: BruteForceLoginDisabledAudit ----
- "#% impex.setTargetFile( ""BruteForceLoginDisabledAudit.csv"" );"
- 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]
- "#% impex.exportItems( ""BruteForceLoginDisabledAudit"" , false );"
- # ---- Extension: processing ---- Type: Batch ----
- "#% impex.setTargetFile( ""Batch.csv"" );"
- 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]
- "#% impex.exportItems( ""Batch"" , false );"
- # ---- Extension: impex ---- Type: ImportBatch ----
- "#% impex.setTargetFile( ""ImportBatch.csv"" );"
- 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]
- "#% impex.exportItems( ""ImportBatch"" , false );"
- # ---- Extension: processing ---- Type: SimpleBatch ----
- "#% impex.setTargetFile( ""SimpleBatch.csv"" );"
- 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]
- "#% impex.exportItems( ""SimpleBatch"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexerBatch ----
- "#% impex.setTargetFile( ""SolrIndexerBatch.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexerBatch"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrSearchQueryTemplate ----
- "#% impex.setTargetFile( ""SolrSearchQueryTemplate.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrSearchQueryTemplate"" , false );"
- # ---- Extension: basecommerce ---- Type: OrderCancelRecord ----
- "#% impex.setTargetFile( ""OrderCancelRecord.csv"" );"
- 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]
- "#% impex.exportItems( ""OrderCancelRecord"" , false );"
- # ---- Extension: basecommerce ---- Type: PointOfService ----
- "#% impex.setTargetFile( ""PointOfService.csv"" );"
- 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]
- "#% impex.exportItems( ""PointOfService"" , false );"
- # ---- Extension: catalog ---- Type: AttributeValueAssignment ----
- "#% impex.setTargetFile( ""AttributeValueAssignment.csv"" );"
- 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]
- "#% impex.exportItems( ""AttributeValueAssignment"" , false );"
- # ---- Extension: core ---- Type: PaymentMode ----
- "#% impex.setTargetFile( ""PaymentMode.csv"" );"
- 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]
- "#% impex.exportItems( ""PaymentMode"" , false );"
- # ---- Extension: paymentstandard ---- Type: StandardPaymentMode ----
- "#% impex.setTargetFile( ""StandardPaymentMode.csv"" );"
- 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]
- "#% impex.exportItems( ""StandardPaymentMode"" , false );"
- # ---- Extension: core ---- Type: UserGroup ----
- "#% impex.setTargetFile( ""UserGroup.csv"" );"
- 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)
- "#% impex.exportItems( ""UserGroup"" , false );"
- # ---- Extension: backoffice ---- Type: BackofficeRole ----
- "#% impex.setTargetFile( ""BackofficeRole.csv"" );"
- 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)
- "#% impex.exportItems( ""BackofficeRole"" , false );"
- # ---- Extension: catalog ---- Type: Company ----
- "#% impex.setTargetFile( ""Company.csv"" );"
- 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)
- "#% impex.exportItems( ""Company"" , false );"
- # ---- Extension: commerceservices ---- Type: CustomerList ----
- "#% impex.setTargetFile( ""CustomerList.csv"" );"
- 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)
- "#% impex.exportItems( ""CustomerList"" , false );"
- # ---- Extension: commerceservices ---- Type: StoreEmployeeGroup ----
- "#% impex.setTargetFile( ""StoreEmployeeGroup.csv"" );"
- 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)
- "#% impex.exportItems( ""StoreEmployeeGroup"" , false );"
- # ---- Extension: core ---- Type: TestUserGroup ----
- "#% impex.setTargetFile( ""TestUserGroup.csv"" );"
- 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)
- "#% impex.exportItems( ""TestUserGroup"" , false );"
- # ---- Extension: commerceservices ---- Type: OrgUnit ----
- "#% impex.setTargetFile( ""OrgUnit.csv"" );"
- 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)
- "#% impex.exportItems( ""OrgUnit"" , false );"
- # ---- Extension: commons ---- Type: RenderersProperty ----
- "#% impex.setTargetFile( ""RenderersProperty.csv"" );"
- 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
- "#% impex.exportItems( ""RenderersProperty"" , false );"
- # ---- Extension: promotions ---- Type: ProductOneToOnePerfectPartnerPromotion ----
- "#% impex.setTargetFile( ""ProductOneToOnePerfectPartnerPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductOneToOnePerfectPartnerPromotion"" , false );"
- # ---- Extension: basecommerce ---- Type: Warehouse ----
- "#% impex.setTargetFile( ""Warehouse.csv"" );"
- 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
- "#% impex.exportItems( ""Warehouse"" , false );"
- # ---- Extension: oauth2 ---- Type: OpenIDExternalScopes ----
- "#% impex.setTargetFile( ""OpenIDExternalScopes.csv"" );"
- 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
- "#% impex.exportItems( ""OpenIDExternalScopes"" , false );"
- # ---- Extension: basecommerce ---- Type: DeeplinkUrlRule ----
- "#% impex.setTargetFile( ""DeeplinkUrlRule.csv"" );"
- 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
- "#% impex.exportItems( ""DeeplinkUrlRule"" , false );"
- # ---- Extension: promotions ---- Type: ProductMultiBuyPromotion ----
- "#% impex.setTargetFile( ""ProductMultiBuyPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductMultiBuyPromotion"" , false );"
- # ---- Extension: basecommerce ---- Type: OpeningSchedule ----
- "#% impex.setTargetFile( ""OpeningSchedule.csv"" );"
- 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]
- "#% impex.exportItems( ""OpeningSchedule"" , false );"
- # ---- Extension: voucher ---- Type: NewCustomerRestriction ----
- "#% impex.setTargetFile( ""NewCustomerRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""NewCustomerRestriction"" , false );"
- # ---- Extension: basecommerce ---- Type: FraudReport ----
- "#% impex.setTargetFile( ""FraudReport.csv"" );"
- 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]
- "#% impex.exportItems( ""FraudReport"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexerQuery ----
- "#% impex.setTargetFile( ""SolrIndexerQuery.csv"" );"
- 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)
- "#% impex.exportItems( ""SolrIndexerQuery"" , false );"
- # ---- Extension: basecommerce ---- Type: Campaign ----
- "#% impex.setTargetFile( ""Campaign.csv"" );"
- 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]
- "#% impex.exportItems( ""Campaign"" , false );"
- # ---- Extension: processing ---- Type: ProcessTaskLog ----
- "#% impex.setTargetFile( ""ProcessTaskLog.csv"" );"
- 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]
- "#% impex.exportItems( ""ProcessTaskLog"" , false );"
- # ---- Extension: catalog ---- Type: PreviewTicket ----
- "#% impex.setTargetFile( ""PreviewTicket.csv"" );"
- 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]
- "#% impex.exportItems( ""PreviewTicket"" , false );"
- # ---- Extension: basecommerce ---- Type: ProductTaxCode ----
- "#% impex.setTargetFile( ""ProductTaxCode.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductTaxCode"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrEndpointUrl ----
- "#% impex.setTargetFile( ""SolrEndpointUrl.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrEndpointUrl"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrValueRange ----
- "#% impex.setTargetFile( ""SolrValueRange.csv"" );"
- 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
- "#% impex.exportItems( ""SolrValueRange"" , false );"
- # ---- Extension: comments ---- Type: Domain ----
- "#% impex.setTargetFile( ""Domain.csv"" );"
- 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]
- "#% impex.exportItems( ""Domain"" , false );"
- # ---- Extension: promotions ---- Type: ProductPerfectPartnerBundlePromotion ----
- "#% impex.setTargetFile( ""ProductPerfectPartnerBundlePromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductPerfectPartnerBundlePromotion"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchConfig ----
- "#% impex.setTargetFile( ""SolrFacetSearchConfig.csv"" );"
- 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)
- "#% impex.exportItems( ""SolrFacetSearchConfig"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrURIRedirect ----
- "#% impex.setTargetFile( ""SolrURIRedirect.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrURIRedirect"" , false );"
- # ---- Extension: basecommerce ---- Type: BaseStore ----
- "#% impex.setTargetFile( ""BaseStore.csv"" );"
- 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]
- "#% impex.exportItems( ""BaseStore"" , false );"
- # ---- Extension: deliveryzone ---- Type: ZoneDeliveryModeValue ----
- "#% impex.setTargetFile( ""ZoneDeliveryModeValue.csv"" );"
- 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]
- "#% impex.exportItems( ""ZoneDeliveryModeValue"" , false );"
- # ---- Extension: core ---- Type: UserProfile ----
- "#% impex.setTargetFile( ""UserProfile.csv"" );"
- 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)
- "#% impex.exportItems( ""UserProfile"" , false );"
- # ---- Extension: catalog ---- Type: CatalogVersion ----
- "#% impex.setTargetFile( ""CatalogVersion.csv"" );"
- 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]
- "#% impex.exportItems( ""CatalogVersion"" , false );"
- # ---- Extension: catalog ---- Type: ClassificationSystemVersion ----
- "#% impex.setTargetFile( ""ClassificationSystemVersion.csv"" );"
- 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]
- "#% impex.exportItems( ""ClassificationSystemVersion"" , false );"
- # ---- Extension: commerceservices ---- Type: ConsentTemplate ----
- "#% impex.setTargetFile( ""ConsentTemplate.csv"" );"
- 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]
- "#% impex.exportItems( ""ConsentTemplate"" , false );"
- # ---- Extension: core ---- Type: User ----
- "#% impex.setTargetFile( ""User.csv"" );"
- 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)
- "#% impex.exportItems( ""User"" , false );"
- # ---- Extension: core ---- Type: Customer ----
- "#% impex.setTargetFile( ""Customer.csv"" );"
- 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)
- "#% impex.exportItems( ""Customer"" , false );"
- # ---- Extension: core ---- Type: Employee ----
- "#% impex.setTargetFile( ""Employee.csv"" );"
- 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)
- "#% impex.exportItems( ""Employee"" , false );"
- # ---- Extension: core ---- Type: TestEmployee ----
- "#% impex.setTargetFile( ""TestEmployee.csv"" );"
- 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)
- "#% impex.exportItems( ""TestEmployee"" , false );"
- # ---- Extension: advancedsavedquery ---- Type: WherePart ----
- "#% impex.setTargetFile( ""WherePart.csv"" );"
- 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]
- "#% impex.exportItems( ""WherePart"" , false );"
- # ---- Extension: catalog ---- Type: CategoryCatalogVersionDifference ----
- "#% impex.setTargetFile( ""CategoryCatalogVersionDifference.csv"" );"
- 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]
- "#% impex.exportItems( ""CategoryCatalogVersionDifference"" , false );"
- # ---- Extension: promotions ---- Type: ProductBOGOFPromotion ----
- "#% impex.setTargetFile( ""ProductBOGOFPromotion.csv"" );"
- 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
- "#% impex.exportItems( ""ProductBOGOFPromotion"" , false );"
- # ---- Extension: oauth2 ---- Type: OAuthAccessToken ----
- "#% impex.setTargetFile( ""OAuthAccessToken.csv"" );"
- 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)
- "#% impex.exportItems( ""OAuthAccessToken"" , false );"
- # ---- Extension: oauth2 ---- Type: OAuthClientDetails ----
- "#% impex.setTargetFile( ""OAuthClientDetails.csv"" );"
- 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
- "#% impex.exportItems( ""OAuthClientDetails"" , false );"
- # ---- Extension: oauth2 ---- Type: OpenIDClientDetails ----
- "#% impex.setTargetFile( ""OpenIDClientDetails.csv"" );"
- 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
- "#% impex.exportItems( ""OpenIDClientDetails"" , false );"
- # ---- Extension: processing ---- Type: TaskCondition ----
- "#% impex.setTargetFile( ""TaskCondition.csv"" );"
- 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]
- "#% impex.exportItems( ""TaskCondition"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexedType ----
- "#% impex.setTargetFile( ""SolrIndexedType.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrIndexedType"" , false );"
- # ---- Extension: advancedsavedquery ---- Type: TypedAdvancedSavedQuerySearchParameter ----
- "#% impex.setTargetFile( ""TypedAdvancedSavedQuerySearchParameter.csv"" );"
- 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]
- "#% impex.exportItems( ""TypedAdvancedSavedQuerySearchParameter"" , false );"
- # ---- Extension: advancedsavedquery ---- Type: ComposedTypeAdvancedSavedQuerySearchParameter ----
- "#% impex.setTargetFile( ""ComposedTypeAdvancedSavedQuerySearchParameter.csv"" );"
- 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]
- "#% impex.exportItems( ""ComposedTypeAdvancedSavedQuerySearchParameter"" , false );"
- # ---- Extension: voucher ---- Type: ProductRestriction ----
- "#% impex.setTargetFile( ""ProductRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""ProductRestriction"" , false );"
- # ---- Extension: voucher ---- Type: ProductCategoryRestriction ----
- "#% impex.setTargetFile( ""ProductCategoryRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""ProductCategoryRestriction"" , false );"
- # ---- Extension: voucher ---- Type: ProductQuantityRestriction ----
- "#% impex.setTargetFile( ""ProductQuantityRestriction.csv"" );"
- 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
- "#% impex.exportItems( ""ProductQuantityRestriction"" , false );"
- # ---- Extension: europe1 ---- Type: TaxRow ----
- "#% impex.setTargetFile( ""TaxRow.csv"" );"
- 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
- "#% impex.exportItems( ""TaxRow"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrServerConfig ----
- "#% impex.setTargetFile( ""SolrServerConfig.csv"" );"
- 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
- "#% impex.exportItems( ""SolrServerConfig"" , false );"
- # ---- Extension: catalog ---- Type: ClassAttributeAssignment ----
- "#% impex.setTargetFile( ""ClassAttributeAssignment.csv"" );"
- 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))
- "#% impex.exportItems( ""ClassAttributeAssignment"" , false );"
- # ---- Extension: basecommerce ---- Type: Vendor ----
- "#% impex.setTargetFile( ""Vendor.csv"" );"
- 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]
- "#% impex.exportItems( ""Vendor"" , false );"
- # ---- Extension: impex ---- Type: ImpexDocumentId ----
- "#% impex.setTargetFile( ""ImpexDocumentId.csv"" );"
- 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]
- "#% impex.exportItems( ""ImpexDocumentId"" , false );"
- # ---- Extension: promotions ---- Type: PromotionOrderAddFreeGiftAction ----
- "#% impex.setTargetFile( ""PromotionOrderAddFreeGiftAction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionOrderAddFreeGiftAction"" , false );"
- # ---- Extension: processing ---- Type: JobSearchRestriction ----
- "#% impex.setTargetFile( ""JobSearchRestriction.csv"" );"
- 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)
- "#% impex.exportItems( ""JobSearchRestriction"" , false );"
- # ---- Extension: core ---- Type: MediaFolder ----
- "#% impex.setTargetFile( ""MediaFolder.csv"" );"
- 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]
- "#% impex.exportItems( ""MediaFolder"" , false );"
- # ---- Extension: basecommerce ---- Type: ProductOrderLimit ----
- "#% impex.setTargetFile( ""ProductOrderLimit.csv"" );"
- 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]
- "#% impex.exportItems( ""ProductOrderLimit"" , false );"
- # ---- Extension: processing ---- Type: DynamicProcessDefinition ----
- "#% impex.setTargetFile( ""DynamicProcessDefinition.csv"" );"
- 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]
- "#% impex.exportItems( ""DynamicProcessDefinition"" , false );"
- # ---- Extension: platformbackoffice ---- Type: BackofficeSavedQuery ----
- "#% impex.setTargetFile( ""BackofficeSavedQuery.csv"" );"
- 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]
- "#% impex.exportItems( ""BackofficeSavedQuery"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrIndexedCoresRecord ----
- "#% impex.setTargetFile( ""SolrIndexedCoresRecord.csv"" );"
- 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))
- "#% impex.exportItems( ""SolrIndexedCoresRecord"" , false );"
- # ---- Extension: core ---- Type: Region ----
- "#% impex.setTargetFile( ""Region.csv"" );"
- 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]
- "#% impex.exportItems( ""Region"" , false );"
- # ---- Extension: basecommerce ---- Type: StockLevel ----
- "#% impex.setTargetFile( ""StockLevel.csv"" );"
- 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]
- "#% impex.exportItems( ""StockLevel"" , false );"
- # ---- Extension: core ---- Type: MediaFormatMapping ----
- "#% impex.setTargetFile( ""MediaFormatMapping.csv"" );"
- 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]
- "#% impex.exportItems( ""MediaFormatMapping"" , false );"
- # ---- Extension: solrfacetsearch ---- Type: SolrFacetSearchKeywordRedirect ----
- "#% impex.setTargetFile( ""SolrFacetSearchKeywordRedirect.csv"" );"
- 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]
- "#% impex.exportItems( ""SolrFacetSearchKeywordRedirect"" , false );"
- # ---- Extension: core ---- Type: UserPasswordChangeAudit ----
- "#% impex.setTargetFile( ""UserPasswordChangeAudit.csv"" );"
- 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]
- "#% impex.exportItems( ""UserPasswordChangeAudit"" , false );"
- # ---- Extension: core ---- Type: CorsConfigurationProperty ----
- "#% impex.setTargetFile( ""CorsConfigurationProperty.csv"" );"
- 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]
- "#% impex.exportItems( ""CorsConfigurationProperty"" , false );"
- # ---- Extension: comments ---- Type: Component ----
- "#% impex.setTargetFile( ""Component.csv"" );"
- 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]
- "#% impex.exportItems( ""Component"" , false );"
- # ---- Extension: commerceservices ---- Type: PromotionOrderRestriction ----
- "#% impex.setTargetFile( ""PromotionOrderRestriction.csv"" );"
- 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)
- "#% impex.exportItems( ""PromotionOrderRestriction"" , false );"
- # ---- Extension: core ---- Type: TestItem ----
- "#% impex.setTargetFile( ""TestItem.csv"" );"
- 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
- "#% impex.exportItems( ""TestItem"" , false );"
- # ---- Extension: core ---- Type: TestItemType2 ----
- "#% impex.setTargetFile( ""TestItemType2.csv"" );"
- 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
- "#% impex.exportItems( ""TestItemType2"" , false );"
- # ---- Extension: core ---- Type: TestItemType3 ----
- "#% impex.setTargetFile( ""TestItemType3.csv"" );"
- 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
- "#% impex.exportItems( ""TestItemType3"" , false );"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement