Query Application schemas

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

ApplicationCountry

A country that are enabled for shopping from the applicationid from the header.

ApplicationId
integer <int32>

ApplicationId. Key property.

CountryId
integer <int32>

CountryId. Key property.

IsPrimary
boolean

IsPrimary.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

ApplicationCulture

A language that are enabled from the applicationid from the header.

ApplicationId
integer <int32>

ApplicationId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

IsPrimary
boolean

IsPrimary.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

ApplicationPriceList

A price list that are enabled for the applicationid from the header.

ApplicationId
integer <int32>

ApplicationId. Key property.

PriceListId
integer <int32>

PriceListId. Nullable. Key property.

IsPrimary
boolean

IsPrimary.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

IsEditable
boolean

IsEditable.

ClientId
integer <int32>

ClientId. Nullable.

IsFavorite
boolean

IsFavorite.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.PriceList> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.PriceList)

ApplicationRole

A role that can be used on the customer account.

Id
integer <int32>

Id. Key property.

ApplicationId
integer <int32>

ApplicationId. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

ReplacesApplicationRoleId
integer <int32>

ReplacesApplicationRoleId. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

IsDefault
boolean

IsDefault.

Code
string

Code. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ApplicationRoleCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ApplicationRoleCulture)

Cultures.

ApplicationRoleCulture

The language specific fields for the roles.

ApplicationRoleId
integer <int32>

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

ClientId
integer <int32>

ClientId. Nullable.

ApplicationSalesArea

A sales area (VAT region) from the applicationid from the header.

ApplicationId
integer <int32>

ApplicationId. Key property.

SalesAreaId
integer <int32>

SalesAreaId. Key property.

IsPrimary
boolean

IsPrimary.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

Category

A category on the client.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

Code
string

Code. MaxLength: 50. Nullable.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. Nullable.

DefaultSynonyms
string

DefaultSynonyms. MaxLength: 500. Nullable.

DefaultImagePath
string

DefaultImagePath. MaxLength: 255. Nullable.

UnspcCode
string

UnspcCode. MaxLength: 50. Nullable.

BusinessArea
string

BusinessArea. MaxLength: 50. Nullable.

DefaultCommodityCode
string

DefaultCommodityCode. MaxLength: 50. Nullable.

DefaultIntegrationPartNo
string

DefaultIntegrationPartNo. MaxLength: 50. Nullable.

DefaultTrackingCodeTypeId
integer <int32>

DefaultTrackingCodeTypeId. Nullable.

FreightClassId
integer <int32>

FreightClassId. Nullable.

DefaultGrossWeight
number <decimal>

DefaultGrossWeight. Nullable.

DefaultNetWeight
number <decimal>

DefaultNetWeight. Nullable.

DefaultUnitOfMeasurementId
integer <int32>

DefaultUnitOfMeasurementId. Nullable.

DefaultPackageId
integer <int32>

DefaultPackageId. Nullable.

DefaultIsReturnable
boolean

DefaultIsReturnable. Nullable.

DefaultIsDropShipOnly
boolean

DefaultIsDropShipOnly. Nullable.

InsuranceCurrencyId
integer <int32>

InsuranceCurrencyId. Nullable.

InsuranceStartPrice
number <decimal>

InsuranceStartPrice. Nullable.

InsuranceRunningPercentage
number <decimal>

InsuranceRunningPercentage. Nullable.

PopulationRuleId
integer <int32>

PopulationRuleId.

HideInTopList
boolean

HideInTopList.

PhoneNumber
string

PhoneNumber. MaxLength: 255. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

CompetitivePricingMinPercentage
number <decimal>

CompetitivePricingMinPercentage. Nullable.

CompetitivePricingTargetPercentage
number <decimal>

CompetitivePricingTargetPercentage. Nullable.

DefaultVariantGroupId
integer <int32>

DefaultVariantGroupId. Nullable.

DefaultRecommendedSalesQty
number <decimal>

DefaultRecommendedSalesQty. Nullable.

ImageKey
string <guid>

ImageKey. Nullable.

DefaultFullName
string

DefaultFullName. MaxLength: 500. Nullable.

StructureSortOrder
string

StructureSortOrder. Nullable.

DefaultStockDisplayBreakPoint
integer <int32>

DefaultStockDisplayBreakPoint. Nullable.

DefaultIsRecommendedSalesQtyFixed
boolean

DefaultIsRecommendedSalesQtyFixed. Nullable.

DefaultIsRecurringOrderable
boolean

DefaultIsRecurringOrderable. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryCulture)

Cultures.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategorySalesArea> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategorySalesArea)

SalesAreas.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryParametric> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryParametric)

Parametrics.

CategoryCulture

The language specific fields for the category.

CategoryId
integer <int32>

CategoryId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

Name
string

Name. MaxLength: 50. Nullable.

Description
string

Description. Nullable.

Synonyms
string

Synonyms. MaxLength: 500. Nullable.

ImagePath
string

ImagePath. MaxLength: 255. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

FullName
string

FullName. MaxLength: 500. Nullable.

ImageKey
string <guid>

ImageKey. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

CategoryHierarchy

A parent-child category relation.

CategoryId
integer <int32>

CategoryId. Nullable. Key property.

ParentCategoryId
integer <int32>

ParentCategoryId. Key property.

Hierarchy
integer <int32>

Hierarchy. Key property.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)
object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)

CategoryParametric

A parametric relations to a category.

CategoryId
integer <int32>

CategoryId. Key property.

ParametricId
integer <int32>

ParametricId. Key property.

ClientId
integer <int32>

ClientId.

GroupId
integer <int32>

GroupId. Nullable.

SortOrder
integer <int32>

SortOrder. Nullable.

FocusSortOrder
integer <int32>

FocusSortOrder. Nullable.

IsSecondary
boolean

IsSecondary.

IsRequired
boolean

IsRequired. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

PrioritySortOrder
integer <int32>

PrioritySortOrder. Nullable.

CategorySalesArea

A sales area (VAT region) relation to a category (if not set default on application is used).

CategoryId
integer <int32>

CategoryId. Key property.

SalesAreaId
integer <int32>

SalesAreaId. Key property.

ClientId
integer <int32>

ClientId.

VatCodeId
integer <int32>

VatCodeId.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

CategoryStructure

Not used. All categories are same structure.

Id
integer <int32>

Id. Key property.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

TypeId
integer <int32>

TypeId.

IsPrimary
boolean

IsPrimary.

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.ApplicationModel.CategoryStructureItem> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryStructureItem)

Items.

CategoryStructureItem

Parent and child information on the category.

Id
integer <int32>

Id. Key property.

StructureId
integer <int32>

StructureId.

UseCategoryName
boolean

UseCategoryName.

CategoryId
integer <int32>

CategoryId. Nullable.

StructureLevel
integer <int32>

StructureLevel.

ParentItemId
integer <int32>

ParentItemId. Nullable.

IsParent
boolean

IsParent.

IsDisplayOnly
boolean

IsDisplayOnly.

SortOrder
integer <int32>

SortOrder.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Key
string <guid>

Key.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)
object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryStructure> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryStructure)

ClientCulture

The language specific fields for the clients.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

ClientId
integer <int32>

ClientId.

IsPrimary
boolean

IsPrimary.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Collation
string

Collation. MaxLength: 128. Nullable.

ClientDivision

A physical store.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

DivisionCode
string

DivisionCode. MaxLength: 50. Nullable.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultGroupName
string

DefaultGroupName. MaxLength: 50. Nullable.

DefaultSubGroupName
string

DefaultSubGroupName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. Nullable.

DefaultImagePath
string

DefaultImagePath. MaxLength: 255. Nullable.

IsPublic
boolean

IsPublic.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Key
string <guid>

Key.

ImageKey
string <guid>

ImageKey. Nullable.

DefaultUniqueUrlName
string

DefaultUniqueUrlName. MaxLength: 100. Nullable.

Latitude
string

Latitude. Nullable.

Longitude
string

Longitude. Nullable.

EmailAddress
string

EmailAddress. MaxLength: 255. Nullable.

PhoneNumber
string

PhoneNumber. MaxLength: 50. Nullable.

FaxNumber
string

FaxNumber. MaxLength: 50. Nullable.

AddressLine1
string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2
string

AddressLine2. MaxLength: 255. Nullable.

ZipCode
string

ZipCode. MaxLength: 50. Nullable.

City
string

City. MaxLength: 50. Nullable.

Region
string

Region. MaxLength: 100. Nullable.

CountryId
integer <int32>

CountryId. Nullable.

OpenHoursWeekday
string

OpenHoursWeekday. MaxLength: 255. Nullable.

OpenHoursSaturday
string

OpenHoursSaturday. MaxLength: 255. Nullable.

OpenHoursSunday
string

OpenHoursSunday. MaxLength: 255. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionApplication> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionApplication)

Applications.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionInfo> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionInfo)

Infos.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionPriceList> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionPriceList)

PriceLists.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionWarehouse> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionWarehouse)

Warehouses.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionCulture)

Cultures.

ClientDivisionApplication

Store- application relation

DivisionId
integer <int32>

DivisionId. Key property.

ApplicationId
integer <int32>

ApplicationId. Key property.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

ClientId
integer <int32>

ClientId. Nullable.

ClientDivisionCulture

The language specific text on a physical store.

DivisionId
integer <int32>

DivisionId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

Name
string

Name. MaxLength: 50. Nullable.

GroupName
string

GroupName. MaxLength: 50. Nullable.

SubGroupName
string

SubGroupName. MaxLength: 50. Nullable.

Description
string

Description. Nullable.

ImagePath
string

ImagePath. MaxLength: 255. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

UniqueUrlName
string

UniqueUrlName. MaxLength: 100. Nullable.

IsUniqueUrlNameManuallyMaintained
boolean

IsUniqueUrlNameManuallyMaintained.

ImageKey
string <guid>

ImageKey. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

ClientDivisionInfo

Extra field information on the physical store.

DivisionId
integer <int32>

DivisionId. Key property.

TypeId
integer <int32>

TypeId. Key property.

Id
integer <int32>

Id.

Value
string

Value. Nullable.

Updated
string <date-time>

Updated.

UpdatedBy
integer <int32>

UpdatedBy.

ClientId
integer <int32>

ClientId. Nullable.

ClientDivisionPriceList

Price list related to a physical store.

DivisionId
integer <int32>

DivisionId. Key property.

PriceListId
integer <int32>

PriceListId. Key property.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

ClientId
integer <int32>

ClientId. Nullable.

ClientDivisionWarehouse

Warehouse related to physical store.

DivisionId
integer <int32>

DivisionId. Key property.

ClientId
integer <int32>

ClientId. Key property.

WarehouseId
integer <int32>

WarehouseId. Key property.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionWarehouseLocation> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionWarehouseLocation)

Locations.

ClientDivisionWarehouseLocation

Location related to physical store and warehouse.

DivisionId
integer <int32>

DivisionId. Key property.

ClientId
integer <int32>

ClientId. Key property.

WarehouseId
integer <int32>

WarehouseId. Key property.

LocationId
integer <int32>

LocationId. Key property.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

ClientManufacturer

A Manufacturer.

ManufacturerId
integer <int32>

ManufacturerId. Nullable. Key property.

ClientId
integer <int32>

ClientId.

ManufacturerCode
string

ManufacturerCode. MaxLength: 50. Nullable.

Name
string

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

UniqueUrlName
string

UniqueUrlName. MaxLength: 255. Nullable.

IsUniqueUrlNameManuallyMaintained
boolean

IsUniqueUrlNameManuallyMaintained.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Manufacturer> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Manufacturer)
object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ManufacturerInfo> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ManufacturerInfo)

ClientSalesArea

A sales area (VAT region).

SalesAreaId
integer <int32>

SalesAreaId. Key property.

ClientId
integer <int32>

ClientId.

IsPrimary
boolean

IsPrimary.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

ClientSupplier

A supplier.

SupplierId
integer <int32>

SupplierId. Nullable. Key property.

ClientId
integer <int32>

ClientId.

SupplierCodePrefix
string

SupplierCodePrefix. MaxLength: 10. Nullable.

SupplierCode
string

SupplierCode. MaxLength: 50. Nullable.

Name
string

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

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Supplier> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Supplier)
Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouse> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouse)

Warehouses.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouseLocation> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouseLocation)

WarehouseLocations.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.SupplierInfo> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.SupplierInfo)
Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierInfo> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierInfo)

Infos.

ClientSupplierInfo

Additional client speific information on the supplier, like dropship or penalty charges.

SupplierId
integer <int32>

SupplierId. Key property.

Id
integer <int32>

Id.

TypeId
integer <int32>

TypeId.

Value
string

Value. Nullable.

Updated
string <date-time>

Updated.

UpdatedBy
integer <int32>

UpdatedBy.

ClientId
integer <int32>

ClientId.

ClientSupplierWarehouse

Warehouse related to suppliers.

SupplierId
integer <int32>

SupplierId. Key property.

WarehouseId
integer <int32>

WarehouseId. Key property.

ClientId
integer <int32>

ClientId.

Name
string

Name. MaxLength: 50. Nullable.

StandardLeadTimeDayCount
integer <int32>

StandardLeadTimeDayCount. Nullable.

MinimumOrderValue
number <decimal>

MinimumOrderValue. Nullable.

MinimumOrderValueCost
number <decimal>

MinimumOrderValueCost. Nullable.

FreightCost
number <decimal>

FreightCost. Nullable.

CostBlock
integer <int32>

CostBlock. Nullable.

IsConsignment
boolean

IsConsignment. Nullable.

IncludeInStockCalculation
boolean

IncludeInStockCalculation.

TransferMethodId
integer <int32>

TransferMethodId. Nullable.

TransferMethodValue
string

TransferMethodValue. MaxLength: 255. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientSupplierWarehouseLocation

Location related to supplier and warehouse.

SupplierId
integer <int32>

SupplierId. Key property.

WarehouseId
integer <int32>

WarehouseId. Key property.

LocationId
integer <int32>

LocationId. Key property.

ClientId
integer <int32>

ClientId.

Name
string

Name. MaxLength: 50. Nullable.

StandardLeadTimeDayCount
integer <int32>

StandardLeadTimeDayCount. Nullable.

MinimumOrderValue
number <decimal>

MinimumOrderValue. Nullable.

MinimumOrderValueCost
number <decimal>

MinimumOrderValueCost. Nullable.

FreightCost
number <decimal>

FreightCost. Nullable.

CostBlock
integer <int32>

CostBlock. Nullable.

IsConsignment
boolean

IsConsignment. Nullable.

IncludeInStockCalculation
boolean

IncludeInStockCalculation. Nullable.

TransferMethodId
integer <int32>

TransferMethodId. Nullable.

TransferMethodValue
string

TransferMethodValue. MaxLength: 255. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

SupportsReservation
boolean

SupportsReservation.

SupportsStockQuery
boolean

SupportsStockQuery.

ClientWarehouse

A warehouse.

WarehouseId
integer <int32>

WarehouseId. Key property.

ClientId
integer <int32>

ClientId.

TypeId
integer <int32>

TypeId.

Code
string

Code. MaxLength: 50. Nullable.

Name
string

Name. MaxLength: 50. Nullable.

IsStandard
boolean

IsStandard.

StandardLeadTimeDayCount
integer <int32>

StandardLeadTimeDayCount. Nullable.

FreightCost
number <decimal>

FreightCost. Nullable.

CostBlock
integer <int32>

CostBlock. 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.ApplicationModel.ClientWarehouseLocation> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientWarehouseLocation)

Locations.

ClientWarehouseLocation

Location related to a warehouse.

WarehouseId
integer <int32>

WarehouseId. Key property.

LocationId
integer <int32>

LocationId. Key property.

ClientId
integer <int32>

ClientId.

Code
string

Code. MaxLength: 50. Nullable.

Name
string

Name. MaxLength: 50. Nullable.

IsStandard
boolean

IsStandard.

IsIncludedInStockCalculation
boolean

IsIncludedInStockCalculation.

StandardLeadTimeDayCount
integer <int32>

StandardLeadTimeDayCount. Nullable.

FreightCost
number <decimal>

FreightCost. Nullable.

UpToDateTypeId
integer <int32>

UpToDateTypeId.

CostBlock
integer <int32>

CostBlock. Nullable.

ValueBT
string

ValueBT. MaxLength: 100. Nullable.

PrimaryPriceListId
integer <int32>

PrimaryPriceListId. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

SupportsReservation
boolean

SupportsReservation.

SupportsStockQuery
boolean

SupportsStockQuery.

Corporation

An organisation, that can be a supplier or a manufacturer.

Id
integer <int32>

Id. Key property.

Key
string <guid>

Key.

OrganizationNo
string

OrganizationNo. MaxLength: 50. Nullable.

DefaultName
string

DefaultName. 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.ApplicationModel.Supplier> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Supplier)

Suppliers.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Manufacturer> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Manufacturer)

Manufacturers.

CurrencyClient

Currency enabled for a client with the current exchange rate.

CurrencyId
integer <int32>

CurrencyId. Key property.

ClientId
integer <int32>

ClientId.

ExchangeRate
number <decimal>

ExchangeRate. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

CustomerInfoType

Extra field on different entities. The groups are: Customer info (1), Application info (2), Division / Store info (4), Company info (6), Supplier info (7).

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

GroupId
integer <int32>

GroupId.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

SortOrder
integer <int32>

SortOrder.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CustomerInfoTypeCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CustomerInfoTypeCulture)

Cultures.

CustomerInfoTypeCulture

The language specific text on extra fields.

TypeId
integer <int32>

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

ClientId
integer <int32>

ClientId. Nullable.

Family

A product family.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

Code
string

Code. MaxLength: 50. Nullable.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. Nullable.

DefaultImagePath
string

DefaultImagePath. MaxLength: 255. Nullable.

DefaultThumbnailImagePath
string

DefaultThumbnailImagePath. MaxLength: 255. Nullable.

DefaultCampaignImagePath
string

DefaultCampaignImagePath. MaxLength: 255. Nullable.

DefaultLargeImagePath
string

DefaultLargeImagePath. MaxLength: 255. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ImageKey
string <guid>

ImageKey. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.FamilyCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.FamilyCulture)

Cultures.

FamilyCulture

The language specific text on product family.

FamilyId
integer <int32>

FamilyId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

Name
string

Name. MaxLength: 50. Nullable.

Description
string

Description. Nullable.

ImagePath
string

ImagePath. MaxLength: 255. Nullable.

ThumbnailImagePath
string

ThumbnailImagePath. MaxLength: 255. Nullable.

CampaignImagePath
string

CampaignImagePath. MaxLength: 255. Nullable.

LargeImagePath
string

LargeImagePath. MaxLength: 255. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ImageKey
string <guid>

ImageKey. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

FileInfo

File type information, like code and id.

FileId
integer <int32>

FileId. Key property.

ClientId
integer <int32>

ClientId.

Code
string

Code. MaxLength: 50. Nullable.

SortOrder
integer <int32>

SortOrder. Nullable.

Updated
string <date-time>

Updated.

UpdatedBy
integer <int32>

UpdatedBy.

Manufacturer

A manufacturer, with the corporation relation.

Id
integer <int32>

Id. Key property.

CorporationId
integer <int32>

CorporationId. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Key
string <guid>

Key.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Corporation> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Corporation)
Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientManufacturer> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientManufacturer)

ClientManufacturers.

ManufacturerInfo

Additional client speific information on the manufacturer.

ManufacturerId
integer <int32>

ManufacturerId. Key property.

ClientId
integer <int32>

ClientId.

Prefix
string

Prefix. MaxLength: 50. Nullable.

Website
string

Website. MaxLength: 255. Nullable.

LogoPath
string

LogoPath. MaxLength: 255. Nullable.

AssortmentId
integer <int32>

AssortmentId. Nullable.

PopulationRuleId
integer <int32>

PopulationRuleId.

DefaultSupportUrl
string

DefaultSupportUrl. MaxLength: 255. Nullable.

DefaultSupportEmailAddress
string

DefaultSupportEmailAddress. MaxLength: 255. Nullable.

DefaultSupportPhoneNumber
string

DefaultSupportPhoneNumber. MaxLength: 500. Nullable.

DefaultSupportAvailableHours
string

DefaultSupportAvailableHours. Nullable.

DefaultSupportPolicy
string

DefaultSupportPolicy. Nullable.

DefaultSupportDescription
string

DefaultSupportDescription. Nullable.

DefaultInternalSupportUrl
string

DefaultInternalSupportUrl. MaxLength: 255. Nullable.

DefaultInternalSupportEmailAddress
string

DefaultInternalSupportEmailAddress. MaxLength: 255. Nullable.

DefaultInternalSupportPhoneNumber
string

DefaultInternalSupportPhoneNumber. MaxLength: 500. Nullable.

DefaultInternalSupportAvailableHours
string

DefaultInternalSupportAvailableHours. Nullable.

DefaultInternalSupportPolicy
string

DefaultInternalSupportPolicy. Nullable.

DefaultInternalSupportDescription
string

DefaultInternalSupportDescription. Nullable.

Alias
string

Alias. MaxLength: 255. Nullable.

DefaultTitle
string

DefaultTitle. MaxLength: 255. Nullable.

DefaultTags
string

DefaultTags. Nullable.

DefaultMetaTags
string

DefaultMetaTags. Nullable.

DefaultMetaDescription
string

DefaultMetaDescription. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

LogoKey
string <guid>

LogoKey. Nullable.

OrderInfoType

Use Shopping info type instead.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

ApplicationId
integer <int32>

ApplicationId.

Code
string

Code. MaxLength: 50. Nullable.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

SortOrder
integer <int32>

SortOrder. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

GroupId
integer <int32>

GroupId.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.OrderInfoTypeCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.OrderInfoTypeCulture)

Cultures.

OrderInfoTypeCulture

The language specific text on extra fields.

TypeId
integer <int32>

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

ClientId
integer <int32>

ClientId. Nullable.

Parametric

Parametric with default information and more.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

DefaultUom
string

DefaultUom. MaxLength: 50. Nullable.

TypeId
integer <int32>

TypeId.

HasListValues
boolean

HasListValues.

HasMultipleValues
boolean

HasMultipleValues.

IsVariantType
boolean

IsVariantType.

IsRequired
boolean

IsRequired.

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.

Code
string

Code. MaxLength: 50. Nullable.

CodeListKey
string

CodeListKey. MaxLength: 50. Nullable.

IsReadOnly
boolean

IsReadOnly.

Editor
string

Editor. MaxLength: 16. Nullable.

IsFavorite
boolean

IsFavorite.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricCulture)

Cultures.

ParametricCulture

The language specific text on parametrics.

ParametricId
integer <int32>

ParametricId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

Name
string

Name. MaxLength: 50. Nullable.

Description
string

Description. MaxLength: 500. Nullable.

Uom
string

Uom. MaxLength: 50. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

ParametricList

List items for parametrics of type list.

Id
integer <int32>

Id. Key property.

ParametricId
integer <int32>

ParametricId.

DefaultVarcharValue
string

DefaultVarcharValue. MaxLength: 255. Nullable.

DefaultDescription
string

DefaultDescription. Nullable.

SortOrder
integer <int32>

SortOrder. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

ImageKey
string <guid>

ImageKey. Nullable.

ImagePath
string

ImagePath. MaxLength: 255. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricListCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricListCulture)

Cultures.

ParametricListCulture

The language specific text on parametrics list items.

ListId
integer <int32>

ListId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

VarcharValue
string

VarcharValue. MaxLength: 255. Nullable.

Description
string

Description. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

ParametricMultiple

List items for parametrics of type multiple list.

Id
integer <int32>

Id. Key property.

ParametricId
integer <int32>

ParametricId.

DefaultValue
string

DefaultValue. MaxLength: 255. Nullable.

DefaultDescription
string

DefaultDescription. Nullable.

SortOrder
integer <int32>

SortOrder. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

ImageKey
string <guid>

ImageKey. Nullable.

ImagePath
string

ImagePath. MaxLength: 255. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricMultipleCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricMultipleCulture)

Cultures.

ParametricMultipleCulture

The language specific text on parametrics multiple list items.

MultipleId
integer <int32>

MultipleId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

Value
string

Value. MaxLength: 255. Nullable.

Description
string

Description. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

PriceList

A price list, see PriceListClient for client specific information.

Id
integer <int32>

Id. Key property.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. Nullable.

Agreement
string

Agreement. MaxLength: 50. Nullable.

StartDate
string <date-time>

StartDate. Nullable.

EndDate
string <date-time>

EndDate. Nullable.

IsPublic
boolean

IsPublic.

IsLimitedToStock
boolean

IsLimitedToStock.

IsBid
boolean

IsBid.

IsStako
boolean

IsStako.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

PriceListClient

A price list, with information like code (agreement), start and end date, parent, salesarea and more.

PriceListId
integer <int32>

PriceListId. Nullable. Key property.

ClientId
integer <int32>

ClientId.

Name
string

Name. MaxLength: 50. Nullable.

Description
string

Description. Nullable.

ImagePath
string

ImagePath. MaxLength: 255. Nullable.

Agreement
string

Agreement. MaxLength: 50. Nullable.

StartDate
string <date-time>

StartDate. Nullable.

EndDate
string <date-time>

EndDate. Nullable.

CurrencyId
integer <int32>

CurrencyId.

DefaultPriceRuleId
integer <int32>

DefaultPriceRuleId. Nullable.

DefaultPriceRuleValue
number <decimal>

DefaultPriceRuleValue. Nullable.

DefaultSupplementChargePercentage
number <decimal>

DefaultSupplementChargePercentage.

DefaultKickbackPercentage
number <decimal>

DefaultKickbackPercentage. Nullable.

DefaultMinimumProductMarginPercentage
number <decimal>

DefaultMinimumProductMarginPercentage. Nullable.

ParentPriceListId
integer <int32>

ParentPriceListId. Nullable.

PopulationRuleId
integer <int32>

PopulationRuleId.

ChosenWarehouseId
integer <int32>

ChosenWarehouseId. Nullable.

ChosenLocationId
integer <int32>

ChosenLocationId. Nullable.

IsErpUpdateable
boolean

IsErpUpdateable.

IsErpIntegrated
boolean

IsErpIntegrated.

IsPrimary
boolean

IsPrimary.

IsPublic
boolean

IsPublic. Nullable.

IsLimitedToStock
boolean

IsLimitedToStock. Nullable.

IsBid
boolean

IsBid. Nullable.

IsStako
boolean

IsStako. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ImageKey
string <guid>

ImageKey. Nullable.

TypeId
integer <int32>

TypeId.

ImageExtension
string

ImageExtension. MaxLength: 16. Nullable.

DefaultSupplementCharge
number <decimal>

DefaultSupplementCharge. Nullable.

DefaultLimitToPriceRecommended
boolean

DefaultLimitToPriceRecommended. Nullable.

IsVirtual
boolean

IsVirtual.

SalesAreaId
integer <int32>

SalesAreaId. Nullable.

InheritStructureCalculationRule
integer <int32>

InheritStructureCalculationRule.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.PriceList> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.PriceList)

ProductFlag

A product flag. Types are Product flag (1), Variant flag (2).

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

TypeId
integer <int32>

TypeId.

GroupId
integer <int32>

GroupId.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

IsManuallyEditable
boolean

IsManuallyEditable.

SortOrder
integer <int32>

SortOrder. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagCulture)

Cultures.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagGroup> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagGroup)

ProductFlagCulture

The language specific text on Product flag.

FlagId
integer <int32>

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

ClientId
integer <int32>

ClientId. Nullable.

ProductFlagGroup

A product flag group.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

IsMultipleChoice
boolean

IsMultipleChoice.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

IsDisplay
boolean

IsDisplay.

IsFavorite
boolean

IsFavorite.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagGroupCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagGroupCulture)

Cultures.

ProductFlagGroupCulture

The language specific text on Product flag group.

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.

ClientId
integer <int32>

ClientId. Nullable.

ProductInfoType

Extra field on different product entities. Groups are Onhand info (2) and Pricelist info (3).

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

GroupId
integer <int32>

GroupId.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

SortOrder
integer <int32>

SortOrder.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductInfoTypeCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductInfoTypeCulture)

Cultures.

ProductInfoTypeCulture

The language specific text on extra fields.

TypeId
integer <int32>

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

ClientId
integer <int32>

ClientId. Nullable.

ProductRelationType

A client specified type for product relation.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

Code
string

Code. MaxLength: 50. Nullable.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

IsBidirectional
boolean

IsBidirectional.

IsActive
boolean

IsActive.

SortOrder
integer <int32>

SortOrder. 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.ApplicationModel.ProductRelationTypeCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductRelationTypeCulture)

Cultures.

ProductRelationTypeCulture

The language specific text on product relation types.

TypeId
integer <int32>

TypeId. Key property.

CultureCode
string

CultureCode. MaxLength: 16. Key property.

ClientId
integer <int32>

ClientId.

Name
string

Name. MaxLength: 50. Nullable.

Description
string

Description. MaxLength: 500. Nullable.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ShoppingInfoType

Extra field on the basket entities. The groups are: Basket info (1), Basket item info (2).

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

GroupId
integer <int32>

GroupId.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

DataType
string

DataType. MaxLength: 50. Nullable.

DefaultValue
string

DefaultValue. Nullable.

SortOrder
integer <int32>

SortOrder.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ShoppingInfoTypeCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ShoppingInfoTypeCulture)

Cultures.

ShoppingInfoTypeCulture

The language specific text on extra fields.

TypeId
integer <int32>

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

ClientId
integer <int32>

ClientId. Nullable.

Supplier

A supplier. See Client supplier for client specific information.

Id
integer <int32>

Id. Key property.

CorporationId
integer <int32>

CorporationId. Nullable.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Key
string <guid>

Key.

SecretKey
string <guid>

SecretKey.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Corporation> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Corporation)
Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplier> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplier)

ClientSuppliers.

SupplierCategoryMapping

A mapping rule between supplier category and a category on the Client.

CategorySupplierId
integer <int32>

CategorySupplierId. Key property.

Code
string

Code. Nullable.

CategoryId
integer <int32>

CategoryId. Nullable.

CategoryName
string

CategoryName. Nullable.

ProductCount
integer <int32>

ProductCount. Nullable.

IsMapped
boolean

IsMapped.

ClientId
integer <int32>

ClientId.

SupplierId
integer <int32>

SupplierId.

IsActive
boolean

IsActive.

SupplierInfo

More information on the supplier, like integration information and settings.

SupplierId
integer <int32>

SupplierId. Key property.

ClientId
integer <int32>

ClientId.

AccountNo
string

AccountNo. MaxLength: 50. Nullable.

Website
string

Website. MaxLength: 255. Nullable.

LogoPath
string

LogoPath. MaxLength: 255. Nullable.

PhoneNumber
string

PhoneNumber. MaxLength: 50. Nullable.

FaxNumber
string

FaxNumber. MaxLength: 50. Nullable.

EmailAddress
string

EmailAddress. MaxLength: 255. Nullable.

LastDocumentImported
string <date-time>

LastDocumentImported. Nullable.

IsChosenSupplierEnabled
boolean

IsChosenSupplierEnabled.

ChosenSupplierSupplementChargePercentage
number <decimal>

ChosenSupplierSupplementChargePercentage.

HasPriceList
boolean

HasPriceList.

IsPurchaseIntegrated
boolean

IsPurchaseIntegrated. Nullable.

PurchaseCutoff
string

PurchaseCutoff. MaxLength: 255. Nullable.

CurrencyId
integer <int32>

CurrencyId. Nullable.

PoDeliveryMethodId
integer <int32>

PoDeliveryMethodId. Nullable.

DeliveryMethodId
integer <int32>

DeliveryMethodId. Nullable.

PaymentTermId
integer <int32>

PaymentTermId. Nullable.

PaymentTermValue
string

PaymentTermValue. MaxLength: 50. Nullable.

PopulationRuleId
integer <int32>

PopulationRuleId.

ErrorCommunicationTypeId
integer <int32>

ErrorCommunicationTypeId. Nullable.

ErrorCommunicationValue
string

ErrorCommunicationValue. MaxLength: 255. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

LogoKey
string <guid>

LogoKey. Nullable.

IsPurchaseManual
boolean

IsPurchaseManual. Nullable.

AutoMapManufacturers
boolean

AutoMapManufacturers. Nullable.

AutoCreateManufacturers
boolean

AutoCreateManufacturers. Nullable.

AutoMapCategories
boolean

AutoMapCategories. Nullable.

ChosenSupplierFreeFreightLimit
number <decimal>

ChosenSupplierFreeFreightLimit. Nullable.

ChosenSupplierFreightCost
number <decimal>

ChosenSupplierFreightCost. Nullable.

ChosenSupplierSupplementCharge
number <decimal>

ChosenSupplierSupplementCharge. Nullable.

IsDropShipEnabled
boolean

IsDropShipEnabled.

DropShipAllowBackOrders
boolean

DropShipAllowBackOrders.

DropShipFreeFreightLimit
number <decimal>

DropShipFreeFreightLimit. Nullable.

DropShipFreightCost
number <decimal>

DropShipFreightCost. Nullable.

DropShipLogisticCost
number <decimal>

DropShipLogisticCost. Nullable.

DropShipSupplementCharge
number <decimal>

DropShipSupplementCharge. Nullable.

DropShipSupplementChargePercentage
number <decimal>

DropShipSupplementChargePercentage. Nullable.

IsRealTimeCheckEnabled
boolean

IsRealTimeCheckEnabled.

InternalInformation
string

InternalInformation. Nullable.

IntegrationMaxAllowedPriceDiffPctPerRow
number <decimal>

IntegrationMaxAllowedPriceDiffPctPerRow. Nullable.

IntegrationMaxAllowedPriceDiffPerUniqueItem
number <decimal>

IntegrationMaxAllowedPriceDiffPerUniqueItem. Nullable.

IsSynchronouslyIntegrated
boolean

IsSynchronouslyIntegrated.

DefaultPoDeliveryMethodCode
string

DefaultPoDeliveryMethodCode. MaxLength: 50. Nullable.

ChosenSupplierPenaltyCharge
number <decimal>

ChosenSupplierPenaltyCharge. Nullable.

ChosenSupplierPenaltyChargePercentage
number <decimal>

ChosenSupplierPenaltyChargePercentage. Nullable.

SupplierManufacturerMapping

A mapping rule between supplier manufacturer and a manufacturer on the Client.

ManufacturerSupplierId
integer <int32>

ManufacturerSupplierId. Key property.

ClientId
integer <int32>

ClientId.

SupplierId
integer <int32>

SupplierId.

Code
string

Code. Nullable.

ProductCount
integer <int32>

ProductCount.

IsActive
boolean

IsActive.

VariantGroup

A definition of a variant grouping (Variant type in the admin ui).

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

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.

Code
string

Code. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantGroupCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantGroupCulture)

Cultures.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantGroupType> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantGroupType)

GroupTypes.

VariantGroupCulture

The language specific text on Variant group.

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.

ClientId
integer <int32>

ClientId. Nullable.

VariantGroupType

Relation between the variant group and variant type, has sort order.

GroupId
integer <int32>

GroupId. Key property.

TypeId
integer <int32>

TypeId. Key property.

SortOrder
integer <int32>

SortOrder.

IsActive
boolean

IsActive.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

ClientId
integer <int32>

ClientId. Nullable.

object <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantType> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantType)

VariantType

Each dimension on a variant group. Has the relation to the Parametric.

Id
integer <int32>

Id. Key property.

ClientId
integer <int32>

ClientId.

DefaultName
string

DefaultName. MaxLength: 50. Nullable.

DefaultDescription
string

DefaultDescription. MaxLength: 500. Nullable.

ParametricId
integer <int32>

ParametricId. Nullable.

Created
string <date-time>

Created.

CreatedBy
integer <int32>

CreatedBy.

Updated
string <date-time>

Updated. Nullable.

UpdatedBy
integer <int32>

UpdatedBy. Nullable.

Code
string

Code. MaxLength: 50. Nullable.

Array of objects <Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantTypeCulture> (Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantTypeCulture)

Cultures.

VariantTypeCulture

The language specific text on Variant type.

TypeId
integer <int32>

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

ClientId
integer <int32>

ClientId. Nullable.