SCHEMA REFERENCES
/
Commerce Query
/
Query Application
Last updated

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.

ApplicationIdinteger(int32)

ApplicationId. Key property.

CountryIdinteger(int32)

CountryId. Key property.

IsPrimaryboolean

IsPrimary.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ApplicationCulture

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

ApplicationIdinteger(int32)

ApplicationId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

IsPrimaryboolean

IsPrimary.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ApplicationPriceList

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

ApplicationIdinteger(int32)

ApplicationId. Key property.

PriceListIdinteger(int32)

PriceListId. Nullable. Key property.

IsPrimaryboolean

IsPrimary.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsEditableboolean

IsEditable.

ClientIdinteger(int32)

ClientId. Nullable.

IsFavoriteboolean

IsFavorite.

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

Idinteger(int32)

Id. Key property.

ApplicationIdinteger(int32)

ApplicationId. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

ReplacesApplicationRoleIdinteger(int32)

ReplacesApplicationRoleId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsDefaultboolean

IsDefault.

Codestring

Code. MaxLength: 50. Nullable.

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

ApplicationRoleIdinteger(int32)

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

ClientIdinteger(int32)

ClientId. Nullable.

ApplicationSalesArea

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

ApplicationIdinteger(int32)

ApplicationId. Key property.

SalesAreaIdinteger(int32)

SalesAreaId. Key property.

IsPrimaryboolean

IsPrimary.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

Category

A category on the client.

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

Codestring

Code. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultSynonymsstring

DefaultSynonyms. MaxLength: 500. Nullable.

DefaultImagePathstring

DefaultImagePath. MaxLength: 255. Nullable.

UnspcCodestring

UnspcCode. MaxLength: 50. Nullable.

BusinessAreastring

BusinessArea. MaxLength: 50. Nullable.

DefaultCommodityCodestring

DefaultCommodityCode. MaxLength: 50. Nullable.

DefaultIntegrationPartNostring

DefaultIntegrationPartNo. MaxLength: 50. Nullable.

DefaultTrackingCodeTypeIdinteger(int32)

DefaultTrackingCodeTypeId. Nullable.

FreightClassIdinteger(int32)

FreightClassId. Nullable.

DefaultGrossWeightnumber(decimal)

DefaultGrossWeight. Nullable.

DefaultNetWeightnumber(decimal)

DefaultNetWeight. Nullable.

DefaultUnitOfMeasurementIdinteger(int32)

DefaultUnitOfMeasurementId. Nullable.

DefaultPackageIdinteger(int32)

DefaultPackageId. Nullable.

DefaultIsReturnableboolean

DefaultIsReturnable. Nullable.

DefaultIsDropShipOnlyboolean

DefaultIsDropShipOnly. Nullable.

InsuranceCurrencyIdinteger(int32)

InsuranceCurrencyId. Nullable.

InsuranceStartPricenumber(decimal)

InsuranceStartPrice. Nullable.

InsuranceRunningPercentagenumber(decimal)

InsuranceRunningPercentage. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId.

HideInTopListboolean

HideInTopList.

PhoneNumberstring

PhoneNumber. MaxLength: 255. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CompetitivePricingMinPercentagenumber(decimal)

CompetitivePricingMinPercentage. Nullable.

CompetitivePricingTargetPercentagenumber(decimal)

CompetitivePricingTargetPercentage. Nullable.

DefaultVariantGroupIdinteger(int32)

DefaultVariantGroupId. Nullable.

DefaultRecommendedSalesQtynumber(decimal)

DefaultRecommendedSalesQty. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

DefaultFullNamestring

DefaultFullName. MaxLength: 500. Nullable.

StructureSortOrderstring

StructureSortOrder. Nullable.

DefaultStockDisplayBreakPointinteger(int32)

DefaultStockDisplayBreakPoint. Nullable.

DefaultIsRecommendedSalesQtyFixedboolean

DefaultIsRecommendedSalesQtyFixed. Nullable.

DefaultIsRecurringOrderableboolean

DefaultIsRecurringOrderable. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryCulture)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryCulture)

Cultures.

SalesAreasArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategorySalesArea)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategorySalesArea)

SalesAreas.

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

CategoryIdinteger(int32)

CategoryId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. Nullable.

Synonymsstring

Synonyms. MaxLength: 500. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

FullNamestring

FullName. MaxLength: 500. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

CategoryHierarchy

A parent-child category relation.

CategoryIdinteger(int32)

CategoryId. Nullable. Key property.

ParentCategoryIdinteger(int32)

ParentCategoryId. Key property.

Hierarchyinteger(int32)

Hierarchy. Key property.

Categoryobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)
ParentCategoryobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)

CategoryParametric

A parametric relations to a category.

CategoryIdinteger(int32)

CategoryId. Key property.

ParametricIdinteger(int32)

ParametricId. Key property.

ClientIdinteger(int32)

ClientId.

GroupIdinteger(int32)

GroupId. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

FocusSortOrderinteger(int32)

FocusSortOrder. Nullable.

IsSecondaryboolean

IsSecondary.

IsRequiredboolean

IsRequired. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

PrioritySortOrderinteger(int32)

PrioritySortOrder. Nullable.

CategorySalesArea

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

CategoryIdinteger(int32)

CategoryId. Key property.

SalesAreaIdinteger(int32)

SalesAreaId. Key property.

ClientIdinteger(int32)

ClientId.

VatCodeIdinteger(int32)

VatCodeId.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CategoryStructure

Not used. All categories are same structure.

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

TypeIdinteger(int32)

TypeId.

IsPrimaryboolean

IsPrimary.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

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

Idinteger(int32)

Id. Key property.

StructureIdinteger(int32)

StructureId.

UseCategoryNameboolean

UseCategoryName.

CategoryIdinteger(int32)

CategoryId. Nullable.

StructureLevelinteger(int32)

StructureLevel.

ParentItemIdinteger(int32)

ParentItemId. Nullable.

IsParentboolean

IsParent.

IsDisplayOnlyboolean

IsDisplayOnly.

SortOrderinteger(int32)

SortOrder.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Keystring(guid)

Key.

Categoryobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Category)
Structureobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryStructure)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.CategoryStructure)

ClientCulture

The language specific fields for the clients.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId.

IsPrimaryboolean

IsPrimary.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Collationstring

Collation. MaxLength: 128. Nullable.

ClientDivision

A physical store.

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

DivisionCodestring

DivisionCode. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultGroupNamestring

DefaultGroupName. MaxLength: 50. Nullable.

DefaultSubGroupNamestring

DefaultSubGroupName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultImagePathstring

DefaultImagePath. MaxLength: 255. Nullable.

IsPublicboolean

IsPublic.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Keystring(guid)

Key.

ImageKeystring(guid)

ImageKey. Nullable.

DefaultUniqueUrlNamestring

DefaultUniqueUrlName. MaxLength: 100. Nullable.

Latitudestring

Latitude. Nullable.

Longitudestring

Longitude. Nullable.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

FaxNumberstring

FaxNumber. MaxLength: 50. Nullable.

AddressLine1string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2string

AddressLine2. MaxLength: 255. Nullable.

ZipCodestring

ZipCode. MaxLength: 50. Nullable.

Citystring

City. MaxLength: 50. Nullable.

Regionstring

Region. MaxLength: 100. Nullable.

CountryIdinteger(int32)

CountryId. Nullable.

OpenHoursWeekdaystring

OpenHoursWeekday. MaxLength: 255. Nullable.

OpenHoursSaturdaystring

OpenHoursSaturday. MaxLength: 255. Nullable.

OpenHoursSundaystring

OpenHoursSunday. MaxLength: 255. Nullable.

ApplicationsArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionApplication)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionApplication)

Applications.

InfosArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionInfo)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionInfo)

Infos.

PriceListsArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionPriceList)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionPriceList)

PriceLists.

WarehousesArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionWarehouse)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionWarehouse)

Warehouses.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionCulture)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientDivisionCulture)

Cultures.

ClientDivisionApplication

Store- application relation

DivisionIdinteger(int32)

DivisionId. Key property.

ApplicationIdinteger(int32)

ApplicationId. Key property.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

ClientDivisionCulture

The language specific text on a physical store.

DivisionIdinteger(int32)

DivisionId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

GroupNamestring

GroupName. MaxLength: 50. Nullable.

SubGroupNamestring

SubGroupName. MaxLength: 50. Nullable.

Descriptionstring

Description. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

UniqueUrlNamestring

UniqueUrlName. MaxLength: 100. Nullable.

IsUniqueUrlNameManuallyMaintainedboolean

IsUniqueUrlNameManuallyMaintained.

ImageKeystring(guid)

ImageKey. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ClientDivisionInfo

Extra field information on the physical store.

DivisionIdinteger(int32)

DivisionId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Idinteger(int32)

Id.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

ClientDivisionPriceList

Price list related to a physical store.

DivisionIdinteger(int32)

DivisionId. Key property.

PriceListIdinteger(int32)

PriceListId. Key property.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

ClientIdinteger(int32)

ClientId. Nullable.

ClientDivisionWarehouse

Warehouse related to physical store.

DivisionIdinteger(int32)

DivisionId. Key property.

ClientIdinteger(int32)

ClientId. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

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

DivisionIdinteger(int32)

DivisionId. Key property.

ClientIdinteger(int32)

ClientId. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

LocationIdinteger(int32)

LocationId. Key property.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

ClientManufacturer

A Manufacturer.

ManufacturerIdinteger(int32)

ManufacturerId. Nullable. Key property.

ClientIdinteger(int32)

ClientId.

ManufacturerCodestring

ManufacturerCode. MaxLength: 50. Nullable.

Namestring

Name. MaxLength: 100. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

UniqueUrlNamestring

UniqueUrlName. MaxLength: 255. Nullable.

IsUniqueUrlNameManuallyMaintainedboolean

IsUniqueUrlNameManuallyMaintained.

Manufacturerobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Manufacturer)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Manufacturer)
Infoobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ManufacturerInfo)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ManufacturerInfo)

ClientSalesArea

A sales area (VAT region).

SalesAreaIdinteger(int32)

SalesAreaId. Key property.

ClientIdinteger(int32)

ClientId.

IsPrimaryboolean

IsPrimary.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

ClientSupplier

A supplier.

SupplierIdinteger(int32)

SupplierId. Nullable. Key property.

ClientIdinteger(int32)

ClientId.

SupplierCodePrefixstring

SupplierCodePrefix. MaxLength: 10. Nullable.

SupplierCodestring

SupplierCode. MaxLength: 50. Nullable.

Namestring

Name. MaxLength: 100. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Supplierobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Supplier)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Supplier)
WarehousesArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouse)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouse)

Warehouses.

WarehouseLocationsArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouseLocation)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientSupplierWarehouseLocation)

WarehouseLocations.

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

SupplierIdinteger(int32)

SupplierId. Key property.

Idinteger(int32)

Id.

TypeIdinteger(int32)

TypeId.

Valuestring

Value. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ClientIdinteger(int32)

ClientId.

ClientSupplierWarehouse

Warehouse related to suppliers.

SupplierIdinteger(int32)

SupplierId. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

ClientIdinteger(int32)

ClientId.

Namestring

Name. MaxLength: 50. Nullable.

StandardLeadTimeDayCountinteger(int32)

StandardLeadTimeDayCount. Nullable.

MinimumOrderValuenumber(decimal)

MinimumOrderValue. Nullable.

MinimumOrderValueCostnumber(decimal)

MinimumOrderValueCost. Nullable.

FreightCostnumber(decimal)

FreightCost. Nullable.

CostBlockinteger(int32)

CostBlock. Nullable.

IsConsignmentboolean

IsConsignment. Nullable.

IncludeInStockCalculationboolean

IncludeInStockCalculation.

TransferMethodIdinteger(int32)

TransferMethodId. Nullable.

TransferMethodValuestring

TransferMethodValue. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientSupplierWarehouseLocation

Location related to supplier and warehouse.

SupplierIdinteger(int32)

SupplierId. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

LocationIdinteger(int32)

LocationId. Key property.

ClientIdinteger(int32)

ClientId.

Namestring

Name. MaxLength: 50. Nullable.

StandardLeadTimeDayCountinteger(int32)

StandardLeadTimeDayCount. Nullable.

MinimumOrderValuenumber(decimal)

MinimumOrderValue. Nullable.

MinimumOrderValueCostnumber(decimal)

MinimumOrderValueCost. Nullable.

FreightCostnumber(decimal)

FreightCost. Nullable.

CostBlockinteger(int32)

CostBlock. Nullable.

IsConsignmentboolean

IsConsignment. Nullable.

IncludeInStockCalculationboolean

IncludeInStockCalculation. Nullable.

TransferMethodIdinteger(int32)

TransferMethodId. Nullable.

TransferMethodValuestring

TransferMethodValue. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SupportsReservationboolean

SupportsReservation.

SupportsStockQueryboolean

SupportsStockQuery.

ClientWarehouse

A warehouse.

WarehouseIdinteger(int32)

WarehouseId. Key property.

ClientIdinteger(int32)

ClientId.

TypeIdinteger(int32)

TypeId.

Codestring

Code. MaxLength: 50. Nullable.

Namestring

Name. MaxLength: 50. Nullable.

IsStandardboolean

IsStandard.

StandardLeadTimeDayCountinteger(int32)

StandardLeadTimeDayCount. Nullable.

FreightCostnumber(decimal)

FreightCost. Nullable.

CostBlockinteger(int32)

CostBlock. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LocationsArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientWarehouseLocation)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ClientWarehouseLocation)

Locations.

ClientWarehouseLocation

Location related to a warehouse.

WarehouseIdinteger(int32)

WarehouseId. Key property.

LocationIdinteger(int32)

LocationId. Key property.

ClientIdinteger(int32)

ClientId.

Codestring

Code. MaxLength: 50. Nullable.

Namestring

Name. MaxLength: 50. Nullable.

IsStandardboolean

IsStandard.

IsIncludedInStockCalculationboolean

IsIncludedInStockCalculation.

StandardLeadTimeDayCountinteger(int32)

StandardLeadTimeDayCount. Nullable.

FreightCostnumber(decimal)

FreightCost. Nullable.

UpToDateTypeIdinteger(int32)

UpToDateTypeId.

CostBlockinteger(int32)

CostBlock. Nullable.

ValueBTstring

ValueBT. MaxLength: 100. Nullable.

PrimaryPriceListIdinteger(int32)

PrimaryPriceListId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SupportsReservationboolean

SupportsReservation.

SupportsStockQueryboolean

SupportsStockQuery.

Corporation

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

Idinteger(int32)

Id. Key property.

Keystring(guid)

Key.

OrganizationNostring

OrganizationNo. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 100. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SuppliersArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Supplier)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.Supplier)

Suppliers.

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

CurrencyIdinteger(int32)

CurrencyId. Key property.

ClientIdinteger(int32)

ClientId.

ExchangeRatenumber(decimal)

ExchangeRate. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(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).

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

GroupIdinteger(int32)

GroupId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

SortOrderinteger(int32)

SortOrder.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

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

TypeIdinteger(int32)

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

ClientIdinteger(int32)

ClientId. Nullable.

Family

A product family.

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

Codestring

Code. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultImagePathstring

DefaultImagePath. MaxLength: 255. Nullable.

DefaultThumbnailImagePathstring

DefaultThumbnailImagePath. MaxLength: 255. Nullable.

DefaultCampaignImagePathstring

DefaultCampaignImagePath. MaxLength: 255. Nullable.

DefaultLargeImagePathstring

DefaultLargeImagePath. MaxLength: 255. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

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

FamilyIdinteger(int32)

FamilyId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

ThumbnailImagePathstring

ThumbnailImagePath. MaxLength: 255. Nullable.

CampaignImagePathstring

CampaignImagePath. MaxLength: 255. Nullable.

LargeImagePathstring

LargeImagePath. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

FileInfo

File type information, like code and id.

FileIdinteger(int32)

FileId. Key property.

ClientIdinteger(int32)

ClientId.

Codestring

Code. MaxLength: 50. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

Manufacturer

A manufacturer, with the corporation relation.

Idinteger(int32)

Id. Key property.

CorporationIdinteger(int32)

CorporationId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Keystring(guid)

Key.

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

ManufacturerIdinteger(int32)

ManufacturerId. Key property.

ClientIdinteger(int32)

ClientId.

Prefixstring

Prefix. MaxLength: 50. Nullable.

Websitestring

Website. MaxLength: 255. Nullable.

LogoPathstring

LogoPath. MaxLength: 255. Nullable.

AssortmentIdinteger(int32)

AssortmentId. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId.

DefaultSupportUrlstring

DefaultSupportUrl. MaxLength: 255. Nullable.

DefaultSupportEmailAddressstring

DefaultSupportEmailAddress. MaxLength: 255. Nullable.

DefaultSupportPhoneNumberstring

DefaultSupportPhoneNumber. MaxLength: 500. Nullable.

DefaultSupportAvailableHoursstring

DefaultSupportAvailableHours. Nullable.

DefaultSupportPolicystring

DefaultSupportPolicy. Nullable.

DefaultSupportDescriptionstring

DefaultSupportDescription. Nullable.

DefaultInternalSupportUrlstring

DefaultInternalSupportUrl. MaxLength: 255. Nullable.

DefaultInternalSupportEmailAddressstring

DefaultInternalSupportEmailAddress. MaxLength: 255. Nullable.

DefaultInternalSupportPhoneNumberstring

DefaultInternalSupportPhoneNumber. MaxLength: 500. Nullable.

DefaultInternalSupportAvailableHoursstring

DefaultInternalSupportAvailableHours. Nullable.

DefaultInternalSupportPolicystring

DefaultInternalSupportPolicy. Nullable.

DefaultInternalSupportDescriptionstring

DefaultInternalSupportDescription. Nullable.

Aliasstring

Alias. MaxLength: 255. Nullable.

DefaultTitlestring

DefaultTitle. MaxLength: 255. Nullable.

DefaultTagsstring

DefaultTags. Nullable.

DefaultMetaTagsstring

DefaultMetaTags. Nullable.

DefaultMetaDescriptionstring

DefaultMetaDescription. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LogoKeystring(guid)

LogoKey. Nullable.

OrderInfoType

Use Shopping info type instead.

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

ApplicationIdinteger(int32)

ApplicationId.

Codestring

Code. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

GroupIdinteger(int32)

GroupId.

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

TypeIdinteger(int32)

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

ClientIdinteger(int32)

ClientId. Nullable.

Parametric

Parametric with default information and more.

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

DefaultUomstring

DefaultUom. MaxLength: 50. Nullable.

TypeIdinteger(int32)

TypeId.

HasListValuesboolean

HasListValues.

HasMultipleValuesboolean

HasMultipleValues.

IsVariantTypeboolean

IsVariantType.

IsRequiredboolean

IsRequired.

IsHiddenboolean

IsHidden.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

CodeListKeystring

CodeListKey. MaxLength: 50. Nullable.

IsReadOnlyboolean

IsReadOnly.

Editorstring

Editor. MaxLength: 16. Nullable.

IsFavoriteboolean

IsFavorite.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricCulture)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ParametricCulture)

Cultures.

ParametricCulture

The language specific text on parametrics.

ParametricIdinteger(int32)

ParametricId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Uomstring

Uom. MaxLength: 50. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ParametricList

List items for parametrics of type list.

Idinteger(int32)

Id. Key property.

ParametricIdinteger(int32)

ParametricId.

DefaultVarcharValuestring

DefaultVarcharValue. MaxLength: 255. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

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

ListIdinteger(int32)

ListId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

VarcharValuestring

VarcharValue. MaxLength: 255. Nullable.

Descriptionstring

Description. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ParametricMultiple

List items for parametrics of type multiple list.

Idinteger(int32)

Id. Key property.

ParametricIdinteger(int32)

ParametricId.

DefaultValuestring

DefaultValue. MaxLength: 255. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

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

MultipleIdinteger(int32)

MultipleId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Valuestring

Value. MaxLength: 255. Nullable.

Descriptionstring

Description. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

PriceList

A price list, see PriceListClient for client specific information.

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

Agreementstring

Agreement. MaxLength: 50. Nullable.

StartDatestring(date-time)

StartDate. Nullable.

EndDatestring(date-time)

EndDate. Nullable.

IsPublicboolean

IsPublic.

IsLimitedToStockboolean

IsLimitedToStock.

IsBidboolean

IsBid.

IsStakoboolean

IsStako.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

PriceListClient

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

PriceListIdinteger(int32)

PriceListId. Nullable. Key property.

ClientIdinteger(int32)

ClientId.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

Agreementstring

Agreement. MaxLength: 50. Nullable.

StartDatestring(date-time)

StartDate. Nullable.

EndDatestring(date-time)

EndDate. Nullable.

CurrencyIdinteger(int32)

CurrencyId.

DefaultPriceRuleIdinteger(int32)

DefaultPriceRuleId. Nullable.

DefaultPriceRuleValuenumber(decimal)

DefaultPriceRuleValue. Nullable.

DefaultSupplementChargePercentagenumber(decimal)

DefaultSupplementChargePercentage.

DefaultKickbackPercentagenumber(decimal)

DefaultKickbackPercentage. Nullable.

DefaultMinimumProductMarginPercentagenumber(decimal)

DefaultMinimumProductMarginPercentage. Nullable.

ParentPriceListIdinteger(int32)

ParentPriceListId. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId.

ChosenWarehouseIdinteger(int32)

ChosenWarehouseId. Nullable.

ChosenLocationIdinteger(int32)

ChosenLocationId. Nullable.

IsErpUpdateableboolean

IsErpUpdateable.

IsErpIntegratedboolean

IsErpIntegrated.

IsPrimaryboolean

IsPrimary.

IsPublicboolean

IsPublic. Nullable.

IsLimitedToStockboolean

IsLimitedToStock. Nullable.

IsBidboolean

IsBid. Nullable.

IsStakoboolean

IsStako. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

TypeIdinteger(int32)

TypeId.

ImageExtensionstring

ImageExtension. MaxLength: 16. Nullable.

DefaultSupplementChargenumber(decimal)

DefaultSupplementCharge. Nullable.

DefaultLimitToPriceRecommendedboolean

DefaultLimitToPriceRecommended. Nullable.

IsVirtualboolean

IsVirtual.

SalesAreaIdinteger(int32)

SalesAreaId. Nullable.

InheritStructureCalculationRuleinteger(int32)

InheritStructureCalculationRule.

PriceListobject(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).

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

TypeIdinteger(int32)

TypeId.

GroupIdinteger(int32)

GroupId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsManuallyEditableboolean

IsManuallyEditable.

SortOrderinteger(int32)

SortOrder. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagCulture)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagCulture)

Cultures.

Groupobject(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagGroup)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.ProductFlagGroup)

ProductFlagCulture

The language specific text on Product flag.

FlagIdinteger(int32)

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

ClientIdinteger(int32)

ClientId. Nullable.

ProductFlagGroup

A product flag group.

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsMultipleChoiceboolean

IsMultipleChoice.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsDisplayboolean

IsDisplay.

IsFavoriteboolean

IsFavorite.

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

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.

ClientIdinteger(int32)

ClientId. Nullable.

ProductInfoType

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

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

GroupIdinteger(int32)

GroupId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

SortOrderinteger(int32)

SortOrder.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

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

TypeIdinteger(int32)

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

ClientIdinteger(int32)

ClientId. Nullable.

ProductRelationType

A client specified type for product relation.

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

Codestring

Code. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

IsBidirectionalboolean

IsBidirectional.

IsActiveboolean

IsActive.

SortOrderinteger(int32)

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

Cultures.

ProductRelationTypeCulture

The language specific text on product relation types.

TypeIdinteger(int32)

TypeId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId.

Namestring

Name. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 500. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ShoppingInfoType

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

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

GroupIdinteger(int32)

GroupId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

DataTypestring

DataType. MaxLength: 50. Nullable.

DefaultValuestring

DefaultValue. Nullable.

SortOrderinteger(int32)

SortOrder.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

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

TypeIdinteger(int32)

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

ClientIdinteger(int32)

ClientId. Nullable.

Supplier

A supplier. See Client supplier for client specific information.

Idinteger(int32)

Id. Key property.

CorporationIdinteger(int32)

CorporationId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Keystring(guid)

Key.

SecretKeystring(guid)

SecretKey.

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

CategorySupplierIdinteger(int32)

CategorySupplierId. Key property.

Codestring

Code. Nullable.

CategoryIdinteger(int32)

CategoryId. Nullable.

CategoryNamestring

CategoryName. Nullable.

ProductCountinteger(int32)

ProductCount. Nullable.

IsMappedboolean

IsMapped.

ClientIdinteger(int32)

ClientId.

SupplierIdinteger(int32)

SupplierId.

IsActiveboolean

IsActive.

SupplierInfo

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

SupplierIdinteger(int32)

SupplierId. Key property.

ClientIdinteger(int32)

ClientId.

AccountNostring

AccountNo. MaxLength: 50. Nullable.

Websitestring

Website. MaxLength: 255. Nullable.

LogoPathstring

LogoPath. MaxLength: 255. Nullable.

PhoneNumberstring

PhoneNumber. MaxLength: 50. Nullable.

FaxNumberstring

FaxNumber. MaxLength: 50. Nullable.

EmailAddressstring

EmailAddress. MaxLength: 255. Nullable.

LastDocumentImportedstring(date-time)

LastDocumentImported. Nullable.

IsChosenSupplierEnabledboolean

IsChosenSupplierEnabled.

ChosenSupplierSupplementChargePercentagenumber(decimal)

ChosenSupplierSupplementChargePercentage.

HasPriceListboolean

HasPriceList.

IsPurchaseIntegratedboolean

IsPurchaseIntegrated. Nullable.

PurchaseCutoffstring

PurchaseCutoff. MaxLength: 255. Nullable.

CurrencyIdinteger(int32)

CurrencyId. Nullable.

PoDeliveryMethodIdinteger(int32)

PoDeliveryMethodId. Nullable.

DeliveryMethodIdinteger(int32)

DeliveryMethodId. Nullable.

PaymentTermIdinteger(int32)

PaymentTermId. Nullable.

PaymentTermValuestring

PaymentTermValue. MaxLength: 50. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId.

ErrorCommunicationTypeIdinteger(int32)

ErrorCommunicationTypeId. Nullable.

ErrorCommunicationValuestring

ErrorCommunicationValue. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LogoKeystring(guid)

LogoKey. Nullable.

IsPurchaseManualboolean

IsPurchaseManual. Nullable.

AutoMapManufacturersboolean

AutoMapManufacturers. Nullable.

AutoCreateManufacturersboolean

AutoCreateManufacturers. Nullable.

AutoMapCategoriesboolean

AutoMapCategories. Nullable.

ChosenSupplierFreeFreightLimitnumber(decimal)

ChosenSupplierFreeFreightLimit. Nullable.

ChosenSupplierFreightCostnumber(decimal)

ChosenSupplierFreightCost. Nullable.

ChosenSupplierSupplementChargenumber(decimal)

ChosenSupplierSupplementCharge. Nullable.

IsDropShipEnabledboolean

IsDropShipEnabled.

DropShipAllowBackOrdersboolean

DropShipAllowBackOrders.

DropShipFreeFreightLimitnumber(decimal)

DropShipFreeFreightLimit. Nullable.

DropShipFreightCostnumber(decimal)

DropShipFreightCost. Nullable.

DropShipLogisticCostnumber(decimal)

DropShipLogisticCost. Nullable.

DropShipSupplementChargenumber(decimal)

DropShipSupplementCharge. Nullable.

DropShipSupplementChargePercentagenumber(decimal)

DropShipSupplementChargePercentage. Nullable.

IsRealTimeCheckEnabledboolean

IsRealTimeCheckEnabled.

InternalInformationstring

InternalInformation. Nullable.

IntegrationMaxAllowedPriceDiffPctPerRownumber(decimal)

IntegrationMaxAllowedPriceDiffPctPerRow. Nullable.

IntegrationMaxAllowedPriceDiffPerUniqueItemnumber(decimal)

IntegrationMaxAllowedPriceDiffPerUniqueItem. Nullable.

IsSynchronouslyIntegratedboolean

IsSynchronouslyIntegrated.

DefaultPoDeliveryMethodCodestring

DefaultPoDeliveryMethodCode. MaxLength: 50. Nullable.

ChosenSupplierPenaltyChargenumber(decimal)

ChosenSupplierPenaltyCharge. Nullable.

ChosenSupplierPenaltyChargePercentagenumber(decimal)

ChosenSupplierPenaltyChargePercentage. Nullable.

SupplierManufacturerMapping

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

ManufacturerSupplierIdinteger(int32)

ManufacturerSupplierId. Key property.

ClientIdinteger(int32)

ClientId.

SupplierIdinteger(int32)

SupplierId.

Codestring

Code. Nullable.

ProductCountinteger(int32)

ProductCount.

IsActiveboolean

IsActive.

VariantGroup

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

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

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.

Codestring

Code. MaxLength: 50. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantGroupCulture)(Enferno.Storm.Query.Api.DataContexts.ApplicationModel.VariantGroupCulture)

Cultures.

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

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.

ClientIdinteger(int32)

ClientId. Nullable.

VariantGroupType

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

GroupIdinteger(int32)

GroupId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

SortOrderinteger(int32)

SortOrder.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

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

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. MaxLength: 500. Nullable.

ParametricIdinteger(int32)

ParametricId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

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

TypeIdinteger(int32)

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

ClientIdinteger(int32)

ClientId. Nullable.

Previous page
Next page