SCHEMA REFERENCES
/
Commerce Query
/
Query Core
Last updated

Query Core schemas

The Core Namespace in Norce Commerce Query has the entities and methods of all the different settings for all clients. This data can preferrably be cached for longer times.

Application

Represents an application in Norce.

Idinteger(int32)

Id. Key property.

Keystring(guid)

Key.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Urlstring

Url. MaxLength: 255. Nullable.

CmsUrlstring

CmsUrl. MaxLength: 255. Nullable.

SalesUrlstring

SalesUrl. MaxLength: 255. Nullable.

SenderEmailAddressstring

SenderEmailAddress. MaxLength: 255. Nullable.

HostClientIdinteger(int32)

HostClientId.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

UrlMatchstring

UrlMatch. MaxLength: 4000. Nullable.

ParentIdinteger(int32)

ParentId. Nullable.

ImageKeystring

ImageKey. MaxLength: 50. Nullable.

ProductUrlstring

ProductUrl. MaxLength: 255. Nullable.

Clientobject(Enferno.Storm.Query.Api.DataContexts.StormCore.Client)(Enferno.Storm.Query.Api.DataContexts.StormCore.Client)

Client

Idinteger(int32)

Id. Key property.

Keystring(guid)

Key.

HostIdinteger(int32)

HostId.

CorporationIdinteger(int32)

CorporationId.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientHostobject(Enferno.Storm.Query.Api.DataContexts.StormCore.ClientHost)(Enferno.Storm.Query.Api.DataContexts.StormCore.ClientHost)
ApplicationsArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.Application)(Enferno.Storm.Query.Api.DataContexts.StormCore.Application)

Applications.

ClientHost

Idinteger(int32)

Id. Key property.

Keystring(guid)

Key.

ClientIdinteger(int32)

ClientId.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientsArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.Client)(Enferno.Storm.Query.Api.DataContexts.StormCore.Client)

Clients.

Country

Idinteger(int32)

Id. Key property.

Codestring

Code. MaxLength: 3. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

PhoneAreaCodeinteger(int32)

PhoneAreaCode. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.CountryCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.CountryCulture)

Cultures.

CountryCulture

CountryIdinteger(int32)

CountryId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Currency

Idinteger(int32)

Id. Key property.

Codestring

Code. MaxLength: 3. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

ExchangeRatenumber(decimal)

ExchangeRate.

DefaultPrefixstring

DefaultPrefix. MaxLength: 10. Nullable.

DefaultSuffixstring

DefaultSuffix. MaxLength: 10. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.CurrencyCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.CurrencyCulture)

Cultures.

CurrencyCulture

CurrencyIdinteger(int32)

CurrencyId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Prefixstring

Prefix. MaxLength: 10. Nullable.

Suffixstring

Suffix. MaxLength: 10. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

DeliveryMethod

Idinteger(int32)

Id. Key property.

DeliveryServiceIdinteger(int32)

DeliveryServiceId. Nullable.

DeliveryMethodTypeIdinteger(int32)

DeliveryMethodTypeId. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultLogoPathstring

DefaultLogoPath. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

DefaultLogoKeystring(guid)

DefaultLogoKey. Nullable.

DeliveryServiceobject(Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryService)(Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryService)
DeliveryMethodTypeobject(Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryMethodType)(Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryMethodType)

DeliveryMethodType

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultLogoPathstring

DefaultLogoPath. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

DefaultLogoKeystring(guid)

DefaultLogoKey. Nullable.

DeliveryService

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultLogoPathstring

DefaultLogoPath. MaxLength: 255. Nullable.

TrackingUrlstring

TrackingUrl. MaxLength: 500. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

DefaultLogoKeystring(guid)

DefaultLogoKey. Nullable.

File

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

TypeIdinteger(int32)

TypeId.

DefaultPixelWidthinteger(int32)

DefaultPixelWidth. Nullable.

DefaultPixelHeightinteger(int32)

DefaultPixelHeight. Nullable.

DefaultMaxSizeinteger(int32)

DefaultMaxSize. Nullable.

DefaultThumbnailPixelWidthinteger(int32)

DefaultThumbnailPixelWidth. Nullable.

DefaultThumbnailPixelHeightinteger(int32)

DefaultThumbnailPixelHeight. Nullable.

DefaultThumbnailMaxSizeinteger(int32)

DefaultThumbnailMaxSize. Nullable.

IsHiddenboolean

IsHidden.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.FileCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.FileCulture)

Cultures.

Typeobject(Enferno.Storm.Query.Api.DataContexts.StormCore.FileType)(Enferno.Storm.Query.Api.DataContexts.StormCore.FileType)

FileCulture

FileIdinteger(int32)

FileId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

FileType

Idinteger(int32)

Id. Key property.

Extensionstring

Extension. MaxLength: 50. Nullable.

MimeTypestring

MimeType. MaxLength: 100. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

FilesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.File)(Enferno.Storm.Query.Api.DataContexts.StormCore.File)

Files.

KpiOrder

Idinteger(int32)

Id. Key property.

Datestring(date-time)

Date.

ClientIdinteger(int32)

ClientId.

ApplicationIdinteger(int32)

ApplicationId.

PaymentServiceIdinteger(int32)

PaymentServiceId.

PaymentMethodIdinteger(int32)

PaymentMethodId.

Sourcestring

Source. MaxLength: 50. Nullable.

CurrencyIdinteger(int32)

CurrencyId.

CurrencyRatenumber(decimal)

CurrencyRate.

NoOfOrdersinteger(int32)

NoOfOrders.

NoOfOrderLinesinteger(int32)

NoOfOrderLines.

CostPurchaseExVATnumber(decimal)

CostPurchaseExVAT.

OrderValueExVATnumber(decimal)

OrderValueExVAT.

OrderValueIncVATnumber(decimal)

OrderValueIncVAT.

Fxnumber(decimal)

Fx.

TotalMarginnumber(decimal)

TotalMargin.

CompanyDiscountnumber(decimal)

CompanyDiscount.

NoOfAppliedPromotionsinteger(int32)

NoOfAppliedPromotions.

TotalDiscountPromotionsnumber(decimal)

TotalDiscountPromotions.

PaymentMethod

Idinteger(int32)

Id. Key property.

PaymentMethodTypeIdinteger(int32)

PaymentMethodTypeId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

LogoPathstring

LogoPath. MaxLength: 500. Nullable.

SortOrderinteger(int32)

SortOrder.

IsPartialPaymentboolean

IsPartialPayment.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

LogoKeystring(guid)

LogoKey. Nullable.

ProductInfoTypeGroup

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.ProductInfoTypeGroupCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.ProductInfoTypeGroupCulture)

Cultures.

ProductInfoTypeGroupCulture

GroupIdinteger(int32)

GroupId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RecurringOrderScheduleFrequency

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleFrequencyCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleFrequencyCulture)

Cultures.

RecurringOrderScheduleFrequencyCulture

FrequencyIdinteger(int32)

FrequencyId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RecurringOrderScheduleMonthlyInterval

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalCulture)

Cultures.

RecurringOrderScheduleMonthlyIntervalCulture

IntervalIdinteger(int32)

IntervalId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RecurringOrderScheduleMonthlyIntervalValue

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalValueCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalValueCulture)

Cultures.

RecurringOrderScheduleMonthlyIntervalValueCulture

ValueIdinteger(int32)

ValueId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RecurringOrderStatus

StatusIdinteger(int32)

StatusId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RecurringOrderStatusCulture

StatusIdinteger(int32)

StatusId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SalesArea

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

DefaultCurrencyIdinteger(int32)

DefaultCurrencyId.

DefaultVatCodeIdinteger(int32)

DefaultVatCodeId.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.SalesAreaCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.SalesAreaCulture)

Cultures.

SalesAreaCulture

SalesAreaIdinteger(int32)

SalesAreaId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SkuStatus

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.SkuStatusCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.SkuStatusCulture)

Cultures.

SkuStatusCulture

StatusIdinteger(int32)

StatusId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

VatCode

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

Valuenumber(decimal)

Value.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.StormCore.VatCodeCulture)(Enferno.Storm.Query.Api.DataContexts.StormCore.VatCodeCulture)

Cultures.

VatCodeCulture

VatCodeIdinteger(int32)

VatCodeId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Previous page
Next page