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. |