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.
| Id | integer <int32> Id. Key property. |
| Key | string <guid> Key. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Url | string Url. MaxLength: 255. Nullable. |
| CmsUrl | string CmsUrl. MaxLength: 255. Nullable. |
| SalesUrl | string SalesUrl. MaxLength: 255. Nullable. |
| SenderEmailAddress | string SenderEmailAddress. MaxLength: 255. Nullable. |
| HostClientId | integer <int32> HostClientId. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| UrlMatch | string UrlMatch. MaxLength: 4000. Nullable. |
| ParentId | integer <int32> ParentId. Nullable. |
| ImageKey | string ImageKey. MaxLength: 50. Nullable. |
| ProductUrl | string ProductUrl. MaxLength: 255. Nullable. |
object <Enferno.Storm.Query.Api.DataContexts.StormCore.Client> (Enferno.Storm.Query.Api.DataContexts.StormCore.Client) |
Client
| Id | integer <int32> Id. Key property. |
| Key | string <guid> Key. |
| HostId | integer <int32> HostId. |
| CorporationId | integer <int32> CorporationId. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
object <Enferno.Storm.Query.Api.DataContexts.StormCore.ClientHost> (Enferno.Storm.Query.Api.DataContexts.StormCore.ClientHost) | |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.Application> (Enferno.Storm.Query.Api.DataContexts.StormCore.Application) Applications. |
ClientHost
| Id | integer <int32> Id. Key property. |
| Key | string <guid> Key. |
| ClientId | integer <int32> ClientId. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.Client> (Enferno.Storm.Query.Api.DataContexts.StormCore.Client) Clients. |
Country
| Id | integer <int32> Id. Key property. |
| Code | string Code. MaxLength: 3. Nullable. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| PhoneAreaCode | integer <int32> PhoneAreaCode. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.CountryCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.CountryCulture) Cultures. |
CountryCulture
| CountryId | integer <int32> CountryId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Currency
| Id | integer <int32> Id. Key property. |
| Code | string Code. MaxLength: 3. Nullable. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| ExchangeRate | number <decimal> ExchangeRate. |
| DefaultPrefix | string DefaultPrefix. MaxLength: 10. Nullable. |
| DefaultSuffix | string DefaultSuffix. MaxLength: 10. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.CurrencyCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.CurrencyCulture) Cultures. |
CurrencyCulture
| CurrencyId | integer <int32> CurrencyId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Prefix | string Prefix. MaxLength: 10. Nullable. |
| Suffix | string Suffix. MaxLength: 10. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
DeliveryMethod
| Id | integer <int32> Id. Key property. |
| DeliveryServiceId | integer <int32> DeliveryServiceId. Nullable. |
| DeliveryMethodTypeId | integer <int32> DeliveryMethodTypeId. Nullable. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. Nullable. |
| DefaultLogoPath | string DefaultLogoPath. MaxLength: 255. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| DefaultLogoKey | string <guid> DefaultLogoKey. Nullable. |
object <Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryService> (Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryService) | |
object <Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryMethodType> (Enferno.Storm.Query.Api.DataContexts.StormCore.DeliveryMethodType) |
DeliveryMethodType
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. Nullable. |
| DefaultLogoPath | string DefaultLogoPath. MaxLength: 255. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| DefaultLogoKey | string <guid> DefaultLogoKey. Nullable. |
DeliveryService
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. Nullable. |
| DefaultLogoPath | string DefaultLogoPath. MaxLength: 255. Nullable. |
| TrackingUrl | string TrackingUrl. MaxLength: 500. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
| DefaultLogoKey | string <guid> DefaultLogoKey. Nullable. |
File
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| TypeId | integer <int32> TypeId. |
| DefaultPixelWidth | integer <int32> DefaultPixelWidth. Nullable. |
| DefaultPixelHeight | integer <int32> DefaultPixelHeight. Nullable. |
| DefaultMaxSize | integer <int32> DefaultMaxSize. Nullable. |
| DefaultThumbnailPixelWidth | integer <int32> DefaultThumbnailPixelWidth. Nullable. |
| DefaultThumbnailPixelHeight | integer <int32> DefaultThumbnailPixelHeight. Nullable. |
| DefaultThumbnailMaxSize | integer <int32> DefaultThumbnailMaxSize. Nullable. |
| IsHidden | boolean IsHidden. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.FileCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.FileCulture) Cultures. | |
object <Enferno.Storm.Query.Api.DataContexts.StormCore.FileType> (Enferno.Storm.Query.Api.DataContexts.StormCore.FileType) |
FileCulture
| FileId | integer <int32> FileId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
FileType
| Id | integer <int32> Id. Key property. |
| Extension | string Extension. MaxLength: 50. Nullable. |
| MimeType | string MimeType. MaxLength: 100. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.File> (Enferno.Storm.Query.Api.DataContexts.StormCore.File) Files. |
KpiOrder
| Id | integer <int32> Id. Key property. |
| Date | string <date-time> Date. |
| ClientId | integer <int32> ClientId. |
| ApplicationId | integer <int32> ApplicationId. |
| PaymentServiceId | integer <int32> PaymentServiceId. |
| PaymentMethodId | integer <int32> PaymentMethodId. |
| Source | string Source. MaxLength: 50. Nullable. |
| CurrencyId | integer <int32> CurrencyId. |
| CurrencyRate | number <decimal> CurrencyRate. |
| NoOfOrders | integer <int32> NoOfOrders. |
| NoOfOrderLines | integer <int32> NoOfOrderLines. |
| CostPurchaseExVAT | number <decimal> CostPurchaseExVAT. |
| OrderValueExVAT | number <decimal> OrderValueExVAT. |
| OrderValueIncVAT | number <decimal> OrderValueIncVAT. |
| Fx | number <decimal> Fx. |
| TotalMargin | number <decimal> TotalMargin. |
| CompanyDiscount | number <decimal> CompanyDiscount. |
| NoOfAppliedPromotions | integer <int32> NoOfAppliedPromotions. |
| TotalDiscountPromotions | number <decimal> TotalDiscountPromotions. |
PaymentMethod
| Id | integer <int32> Id. Key property. |
| PaymentMethodTypeId | integer <int32> PaymentMethodTypeId. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. Nullable. |
| LogoPath | string LogoPath. MaxLength: 500. Nullable. |
| SortOrder | integer <int32> SortOrder. |
| IsPartialPayment | boolean IsPartialPayment. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| LogoKey | string <guid> LogoKey. Nullable. |
ProductInfoTypeGroup
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.ProductInfoTypeGroupCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.ProductInfoTypeGroupCulture) Cultures. |
ProductInfoTypeGroupCulture
| GroupId | integer <int32> GroupId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
RecurringOrderScheduleFrequency
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleFrequencyCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleFrequencyCulture) Cultures. |
RecurringOrderScheduleFrequencyCulture
| FrequencyId | integer <int32> FrequencyId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
RecurringOrderScheduleMonthlyInterval
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalCulture) Cultures. |
RecurringOrderScheduleMonthlyIntervalCulture
| IntervalId | integer <int32> IntervalId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
RecurringOrderScheduleMonthlyIntervalValue
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalValueCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.RecurringOrderScheduleMonthlyIntervalValueCulture) Cultures. |
RecurringOrderScheduleMonthlyIntervalValueCulture
| ValueId | integer <int32> ValueId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
RecurringOrderStatus
| StatusId | integer <int32> StatusId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
RecurringOrderStatusCulture
| StatusId | integer <int32> StatusId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
SalesArea
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| DefaultCurrencyId | integer <int32> DefaultCurrencyId. |
| DefaultVatCodeId | integer <int32> DefaultVatCodeId. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.SalesAreaCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.SalesAreaCulture) Cultures. |
SalesAreaCulture
| SalesAreaId | integer <int32> SalesAreaId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
SkuStatus
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.SkuStatusCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.SkuStatusCulture) Cultures. |
SkuStatusCulture
| StatusId | integer <int32> StatusId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
VatCode
| Id | integer <int32> Id. Key property. |
| DefaultName | string DefaultName. MaxLength: 50. Nullable. |
| DefaultDescription | string DefaultDescription. MaxLength: 500. Nullable. |
| Value | number <decimal> Value. |
| IsActive | boolean IsActive. |
| Created | string <date-time> Created. |
| CreatedBy | integer <int32> CreatedBy. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |
Array of objects <Enferno.Storm.Query.Api.DataContexts.StormCore.VatCodeCulture> (Enferno.Storm.Query.Api.DataContexts.StormCore.VatCodeCulture) Cultures. |
VatCodeCulture
| VatCodeId | integer <int32> VatCodeId. Key property. |
| CultureCode | string CultureCode. MaxLength: 16. Key property. |
| Name | string Name. MaxLength: 50. Nullable. |
| Description | string Description. MaxLength: 500. Nullable. |
| Updated | string <date-time> Updated. Nullable. |
| UpdatedBy | integer <int32> UpdatedBy. Nullable. |