SCHEMA REFERENCES
/
Commerce Query
/
Query Products
Last updated

Query Products schemas

The Products Namespace in Norce Commerce Query has the entities and methods of all product related data.

ClientProductFlag

ProductIdinteger(int32)

ProductId. Key property.

FlagIdinteger(int32)

FlagId. Key property.

ClientIdinteger(int32)

ClientId.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Product

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

ManufacturerIdinteger(int32)

ManufacturerId.

ManufacturerPartNostring

ManufacturerPartNo. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 255. Nullable.

DefaultSubHeaderstring

DefaultSubHeader. MaxLength: 255. Nullable.

DefaultSubDescriptionstring

DefaultSubDescription. Nullable.

DefaultDescriptionHeaderstring

DefaultDescriptionHeader. MaxLength: 255. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultImagePathstring

DefaultImagePath. MaxLength: 255. Nullable.

DefaultThumbnailImagePathstring

DefaultThumbnailImagePath. MaxLength: 255. Nullable.

DefaultCampaignImagePathstring

DefaultCampaignImagePath. MaxLength: 255. Nullable.

DefaultLargeImagePathstring

DefaultLargeImagePath. MaxLength: 255. Nullable.

DefaultSynonymsstring

DefaultSynonyms. MaxLength: 500. Nullable.

SortOrderValueinteger(int32)

SortOrderValue. Nullable.

AssortmentIdinteger(int32)

AssortmentId. Nullable.

AssortmentLastUpdatedstring(date-time)

AssortmentLastUpdated. Nullable.

AssortmentLastUpdatedByinteger(int32)

AssortmentLastUpdatedBy. Nullable.

IsVariantboolean

IsVariant.

VariantIdinteger(int32)

VariantId. Nullable.

Aliasstring

Alias. MaxLength: 255. Nullable.

DefaultTitlestring

DefaultTitle. MaxLength: 255. Nullable.

DefaultTagsstring

DefaultTags. Nullable.

DefaultMetaTagsstring

DefaultMetaTags. Nullable.

DefaultMetaDescriptionstring

DefaultMetaDescription. Nullable.

HideInTopListboolean

HideInTopList. Nullable.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

InsuranceCurrencyIdinteger(int32)

InsuranceCurrencyId. Nullable.

InsuranceStartPricenumber(decimal)

InsuranceStartPrice. Nullable.

InsuranceRunningPercentagenumber(decimal)

InsuranceRunningPercentage. Nullable.

Keystring(guid)

Key.

ManufacturerPartNo2string

ManufacturerPartNo2. MaxLength: 50. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

DefaultUniqueUrlNamestring

DefaultUniqueUrlName. MaxLength: 500. Nullable.

StockDisplayBreakPointinteger(int32)

StockDisplayBreakPoint. Nullable.

IsDangerousGoodsboolean

IsDangerousGoods.

Codestring

Code. MaxLength: 50. Nullable.

IsRecurringOrderableboolean

IsRecurringOrderable. Nullable.

DefaultExternalDescriptionstring

DefaultExternalDescription. Nullable.

UnspscCodestring

UnspscCode. MaxLength: 50. Nullable.

TranslationRequestedstring(date-time)

TranslationRequested. Nullable.

TranslationRequestedByinteger(int32)

TranslationRequestedBy. Nullable.

SkusArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)

Skus.

CategoriesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCategory)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCategory)

Categories.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCulture)

Cultures.

SupplierSkusArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)

SupplierSkus.

ParametricsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametric)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametric)

Parametrics.

ParametricMultipleArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametricMultiple)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametricMultiple)

ParametricMultiple.

Variantobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Variant)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Variant)
FlagsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ClientProductFlag)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ClientProductFlag)

Flags.

FamiliesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFamily)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFamily)

Families.

AccessoriesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessory)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessory)

Accessories.

UpsellArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsell)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsell)

Upsell.

CrossellArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCrossell)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductCrossell)

Crossell.

VariantTypesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantType)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantType)

VariantTypes.

FilesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFile)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductFile)

Files.

PopularitiesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductPopularity)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductPopularity)

Popularities.

ProductRelationsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)

ProductRelations.

ProductAccessory

ProductIdinteger(int32)

ProductId. Key property.

ClientIdinteger(int32)

ClientId.

AccessoryProductIdinteger(int32)

AccessoryProductId.

TypeIdinteger(int32)

TypeId.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsAccessoryProductVariantUniqueboolean

IsAccessoryProductVariantUnique.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessoryCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductAccessoryCulture)

Cultures.

ProductAccessoryCulture

ProductIdinteger(int32)

ProductId. Key property.

AccessoryProductIdinteger(int32)

AccessoryProductId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId.

Namestring

Name. MaxLength: 255. Nullable.

SubHeaderstring

SubHeader. MaxLength: 255. Nullable.

SubDescriptionstring

SubDescription. Nullable.

DescriptionHeaderstring

DescriptionHeader. MaxLength: 255. Nullable.

Descriptionstring

Description. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductCategory

ProductIdinteger(int32)

ProductId. Key property.

CategoryIdinteger(int32)

CategoryId. Key property.

ClientIdinteger(int32)

ClientId.

IsPrimaryboolean

IsPrimary.

SortOrderinteger(int32)

SortOrder. Nullable.

ProductSortOrderinteger(int32)

ProductSortOrder. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductCrossell

ProductIdinteger(int32)

ProductId. Key property.

ClientIdinteger(int32)

ClientId.

CrossellProductIdinteger(int32)

CrossellProductId.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsCrossellProductVariantUniqueboolean

IsCrossellProductVariantUnique.

ProductCulture

ProductIdinteger(int32)

ProductId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

Namestring

Name. MaxLength: 255. Nullable.

NameLastUpdatedstring(date-time)

NameLastUpdated. Nullable.

NameLastUpdatedByinteger(int32)

NameLastUpdatedBy. Nullable.

SubHeaderstring

SubHeader. MaxLength: 255. Nullable.

SubHeaderLastUpdatedstring(date-time)

SubHeaderLastUpdated. Nullable.

SubHeaderLastUpdatedByinteger(int32)

SubHeaderLastUpdatedBy. Nullable.

SubDescriptionstring

SubDescription. Nullable.

SubDescriptionLastUpdatedstring(date-time)

SubDescriptionLastUpdated. Nullable.

SubDescriptionLastUpdatedByinteger(int32)

SubDescriptionLastUpdatedBy. Nullable.

DescriptionHeaderstring

DescriptionHeader. MaxLength: 255. Nullable.

DescriptionHeaderLastUpdatedstring(date-time)

DescriptionHeaderLastUpdated. Nullable.

DescriptionHeaderLastUpdatedByinteger(int32)

DescriptionHeaderLastUpdatedBy. Nullable.

Descriptionstring

Description. Nullable.

DescriptionLastUpdatedstring(date-time)

DescriptionLastUpdated. Nullable.

DescriptionLastUpdatedByinteger(int32)

DescriptionLastUpdatedBy. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

ThumbnailImagePathstring

ThumbnailImagePath. MaxLength: 255. Nullable.

CampaignImagePathstring

CampaignImagePath. MaxLength: 255. Nullable.

LargeImagePathstring

LargeImagePath. MaxLength: 255. Nullable.

ImageLastUpdatedstring(date-time)

ImageLastUpdated. Nullable.

ImageLastUpdatedByinteger(int32)

ImageLastUpdatedBy. Nullable.

Synonymsstring

Synonyms. MaxLength: 500. Nullable.

SynonymsLastUpdatedstring(date-time)

SynonymsLastUpdated. Nullable.

SynonymsLastUpdatedByinteger(int32)

SynonymsLastUpdatedBy. Nullable.

Titlestring

Title. MaxLength: 255. Nullable.

Tagsstring

Tags. Nullable.

MetaTagsstring

MetaTags. Nullable.

MetaDescriptionstring

MetaDescription. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

UniqueUrlNamestring

UniqueUrlName. MaxLength: 500. Nullable.

IsUniqueUrlNameManuallyMaintainedboolean

IsUniqueUrlNameManuallyMaintained.

ImageKeystring(guid)

ImageKey. Nullable.

ExternalDescriptionstring

ExternalDescription. Nullable.

ClientIdinteger(int32)

ClientId.

ProductFamily

ProductIdinteger(int32)

ProductId. Key property.

FamilyIdinteger(int32)

FamilyId. Key property.

ClientIdinteger(int32)

ClientId.

IsPrimaryboolean

IsPrimary.

SortOrderinteger(int32)

SortOrder. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductFile

Idinteger(int32)

Id. Key property.

ProductIdinteger(int32)

ProductId.

ClientIdinteger(int32)

ClientId.

FileIdinteger(int32)

FileId.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

DefaultPathstring

DefaultPath. Nullable.

DefaultThumbnailPathstring

DefaultThumbnailPath. MaxLength: 255. Nullable.

DefaultSizestring

DefaultSize. MaxLength: 50. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

FileKeystring(guid)

FileKey. Nullable.

IsVariantUniqueboolean

IsVariantUnique.

Codestring

Code. MaxLength: 255. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

ProductParametric

ProductIdinteger(int32)

ProductId. Key property.

ParametricIdinteger(int32)

ParametricId. Key property.

ClientIdinteger(int32)

ClientId.

DefaultVarcharValuestring

DefaultVarcharValue. MaxLength: 255. Nullable.

DefaultHtmlValuestring

DefaultHtmlValue. Nullable.

IntegerValueinteger(int32)

IntegerValue. Nullable.

DecimalValuenumber(decimal)

DecimalValue. Nullable.

BooleanValueboolean

BooleanValue. Nullable.

DateValuestring(date-time)

DateValue. Nullable.

ListIdinteger(int32)

ListId. Nullable.

NormalizedValuenumber(decimal)

NormalizedValue. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsVariantUniqueboolean

IsVariantUnique.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametricCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductParametricCulture)

Cultures.

ProductParametricCulture

ProductIdinteger(int32)

ProductId. Key property.

ParametricIdinteger(int32)

ParametricId. Key property.

ClientIdinteger(int32)

ClientId.

CultureCodestring

CultureCode. MaxLength: 16. Nullable.

VarcharValuestring

VarcharValue. MaxLength: 255. Nullable.

HtmlValuestring

HtmlValue. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductParametricMultiple

ProductIdinteger(int32)

ProductId. Key property.

ParametricIdinteger(int32)

ParametricId. Key property.

MultipleIdinteger(int32)

MultipleId. Key property.

ClientIdinteger(int32)

ClientId.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductPopularity

ProductIdinteger(int32)

ProductId. Key property.

SourceIdinteger(int32)

SourceId. Key property.

ClientIdinteger(int32)

ClientId.

CategoryRankinteger(int32)

CategoryRank. Nullable.

CategoryRankMaxinteger(int32)

CategoryRankMax. Nullable.

TotalRankinteger(int32)

TotalRank.

Ratingnumber(decimal)

Rating. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

Valuenumber(decimal)

Value. Nullable.

Idinteger(int32)

Id.

ApplicationIdinteger(int32)

ApplicationId. Nullable.

ProductRelation

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

ProductIdinteger(int32)

ProductId. Nullable.

RelatedProductIdinteger(int32)

RelatedProductId.

TypeIdinteger(int32)

TypeId.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsRelatedProductVariantUniqueboolean

IsRelatedProductVariantUnique.

DefaultNamestring

DefaultName. MaxLength: 255. Nullable.

DefaultSubHeaderstring

DefaultSubHeader. MaxLength: 255. Nullable.

DefaultSubDescriptionstring

DefaultSubDescription. Nullable.

DefaultDescriptionHeaderstring

DefaultDescriptionHeader. MaxLength: 255. Nullable.

DefaultDescriptionstring

DefaultDescription. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelationCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelationCulture)

Cultures.

Productobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)

ProductRelationCulture

RelationIdinteger(int32)

RelationId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId.

Namestring

Name. MaxLength: 255. Nullable.

SubHeaderstring

SubHeader. MaxLength: 255. Nullable.

SubDescriptionstring

SubDescription. Nullable.

DescriptionHeaderstring

DescriptionHeader. MaxLength: 255. Nullable.

Descriptionstring

Description. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductRelationobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductRelation)

ProductSku

PartNostring

PartNo. MaxLength: 50. Key property.

ProductIdinteger(int32)

ProductId.

ClientIdinteger(int32)

ClientId.

StatusIdinteger(int32)

StatusId.

StatusLastUpdatedstring(date-time)

StatusLastUpdated. Nullable.

StatusLastUpdatedByinteger(int32)

StatusLastUpdatedBy. Nullable.

TypeIdinteger(int32)

TypeId.

IntegrationPartNostring

IntegrationPartNo. MaxLength: 50. Nullable.

ErpNamestring

ErpName. MaxLength: 255. Nullable.

DefaultCommentstring

DefaultComment. MaxLength: 255. Nullable.

CommodityCodestring

CommodityCode. MaxLength: 50. Nullable.

EanCodestring

EanCode. MaxLength: 50. Nullable.

TrackingCodestring

TrackingCode. MaxLength: 50. Nullable.

GrossWeightnumber(decimal)

GrossWeight. Nullable.

NetWeightnumber(decimal)

NetWeight. Nullable.

FreightClassIdinteger(int32)

FreightClassId. Nullable.

UnitOfMeasurementIdinteger(int32)

UnitOfMeasurementId. Nullable.

UnitOfMeasurementCountnumber(decimal)

UnitOfMeasurementCount.

PackageIdinteger(int32)

PackageId. Nullable.

TrackingCodeTypeIdinteger(int32)

TrackingCodeTypeId. Nullable.

Urlstring

Url. MaxLength: 255. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

IsDropShipOnlyboolean

IsDropShipOnly. Nullable.

IsPublishedboolean

IsPublished.

PublishedLastUpdatedstring(date-time)

PublishedLastUpdated. Nullable.

PublishedLastUpdatedByinteger(int32)

PublishedLastUpdatedBy. Nullable.

IsBlockedboolean

IsBlocked.

BlockedLastUpdatedstring(date-time)

BlockedLastUpdated. Nullable.

BlockedLastUpdatedByinteger(int32)

BlockedLastUpdatedBy. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LastCheckedstring(date-time)

LastChecked. Nullable.

TrackingModeTypeIdinteger(int32)

TrackingModeTypeId. Nullable.

IsStatusLockedboolean

IsStatusLocked.

StatusLockedDatestring(date-time)

StatusLockedDate. Nullable.

StatusLockedByinteger(int32)

StatusLockedBy. Nullable.

RecommendedSalesQtynumber(decimal)

RecommendedSalesQty. Nullable.

LogisticWidthnumber(decimal)

LogisticWidth. Nullable.

LogisticHeightnumber(decimal)

LogisticHeight. Nullable.

LogisticDepthnumber(decimal)

LogisticDepth. Nullable.

IsBuyableboolean

IsBuyable.

BuyableLastUpdatedstring(date-time)

BuyableLastUpdated. Nullable.

BuyableLastUpdatedByinteger(int32)

BuyableLastUpdatedBy. Nullable.

DiscountClassstring

DiscountClass. MaxLength: 50. Nullable.

IsRecommendedSalesQtyFixedboolean

IsRecommendedSalesQtyFixed. Nullable.

StartDatestring(date-time)

StartDate. Nullable.

EndDatestring(date-time)

EndDate. Nullable.

Productobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)
CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuCulture)

Cultures.

PriceListsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPricelist)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPricelist)

PriceLists.

SalesAreasArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuSalesArea)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuSalesArea)

SalesAreas.

OnHandsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHand)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHand)

OnHands.

StructureItemsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItem)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItem)

StructureItems.

BestPricesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuBestPrice)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuBestPrice)

BestPrices.

ProductSkuCulture

PartNostring

PartNo. MaxLength: 50. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId.

ErpNamestring

ErpName. MaxLength: 255. Nullable.

Commentstring

Comment. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductSkuOnHand

PartNostring

PartNo. MaxLength: 50. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

LocationIdinteger(int32)

LocationId. Key property.

ClientIdinteger(int32)

ClientId.

OnHandValuenumber(decimal)

OnHandValue.

OnHandLastCheckedstring(date-time)

OnHandLastChecked. Nullable.

OnHandLastUpdatedstring(date-time)

OnHandLastUpdated. Nullable.

OnHandLastUpdatedByinteger(int32)

OnHandLastUpdatedBy. Nullable.

IncomingValuenumber(decimal)

IncomingValue. Nullable.

IncomingLastCheckedstring(date-time)

IncomingLastChecked. Nullable.

IncomingLastUpdatedstring(date-time)

IncomingLastUpdated. Nullable.

IncomingLastUpdatedByinteger(int32)

IncomingLastUpdatedBy. Nullable.

NextDeliveryDatestring(date-time)

NextDeliveryDate. Nullable.

NextDeliveryLastCheckedstring(date-time)

NextDeliveryLastChecked. Nullable.

NextDeliveryLastUpdatedstring(date-time)

NextDeliveryLastUpdated. Nullable.

NextDeliveryLastUpdatedByinteger(int32)

NextDeliveryLastUpdatedBy. Nullable.

IsReturnableboolean

IsReturnable.

LeadTimeDayCountinteger(int32)

LeadTimeDayCount. Nullable.

OnOrderValuenumber(decimal)

OnOrderValue. Nullable.

MinimumValuenumber(decimal)

MinimumValue. Nullable.

MaximumValuenumber(decimal)

MaximumValue. Nullable.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ReservationValuenumber(decimal)

ReservationValue.

IsActiveLastUpdatedstring(date-time)

IsActiveLastUpdated. Nullable.

IsActiveLastUpdatedByinteger(int32)

IsActiveLastUpdatedBy. Nullable.

InfoArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHandInfo)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuOnHandInfo)

Info.

ProductSkuOnHandInfo

PartNostring

PartNo. MaxLength: 50. Key property.

WarehouseIdinteger(int32)

WarehouseId. Key property.

LocationIdinteger(int32)

LocationId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Idstring

Id.

ClientIdinteger(int32)

ClientId.

Valuestring

Value. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductSkuPriceListInfo

PartNostring

PartNo. MaxLength: 50. Key property.

PriceListIdinteger(int32)

PriceListId. Key property.

QtyBreakinteger(int32)

QtyBreak. Key property.

TypeIdinteger(int32)

TypeId. Key property.

Idstring

Id.

ClientIdinteger(int32)

ClientId.

Valuestring

Value. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductSkuPricelist

PartNostring

PartNo. MaxLength: 50. Key property.

PriceListIdinteger(int32)

PriceListId. Key property.

QtyBreakinteger(int32)

QtyBreak. Key property.

ClientIdinteger(int32)

ClientId.

CurrencyIdinteger(int32)

CurrencyId.

PriceSalenumber(decimal)

PriceSale.

PriceSaleLastUpdatedstring(date-time)

PriceSaleLastUpdated. Nullable.

PriceSaleLastUpdatedByinteger(int32)

PriceSaleLastUpdatedBy. Nullable.

PriceRuleIdinteger(int32)

PriceRuleId. Nullable.

PriceRuleValuenumber(decimal)

PriceRuleValue. Nullable.

CostPurchasenumber(decimal)

CostPurchase.

CostPurchaseLastUpdatedstring(date-time)

CostPurchaseLastUpdated. Nullable.

CostPurchaseLastUpdatedByinteger(int32)

CostPurchaseLastUpdatedBy. Nullable.

CostUnitnumber(decimal)

CostUnit.

CostUnitLastUpdatedstring(date-time)

CostUnitLastUpdated. Nullable.

CostUnitLastUpdatedByinteger(int32)

CostUnitLastUpdatedBy. Nullable.

SupplementChargePercentagenumber(decimal)

SupplementChargePercentage. Nullable.

PriceStandardnumber(decimal)

PriceStandard. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

PriceRecommendedLastUpdatedstring(date-time)

PriceRecommendedLastUpdated. Nullable.

PriceRecommendedLastUpdatedByinteger(int32)

PriceRecommendedLastUpdatedBy. Nullable.

PricePreviousnumber(decimal)

PricePrevious. Nullable.

PricePreviousLastUpdatedstring(date-time)

PricePreviousLastUpdated. Nullable.

PricePreviousLastUpdatedByinteger(int32)

PricePreviousLastUpdatedBy. Nullable.

PriceCatalognumber(decimal)

PriceCatalog. Nullable.

PriceCatalogLastUpdatedstring(date-time)

PriceCatalogLastUpdated. Nullable.

PriceCatalogLastUpdatedByinteger(int32)

PriceCatalogLastUpdatedBy. Nullable.

IsPriceDiscountableboolean

IsPriceDiscountable.

ChosenSupplierIdinteger(int32)

ChosenSupplierId. Nullable.

ChosenSupplierPartNostring

ChosenSupplierPartNo. MaxLength: 50. Nullable.

ChosenSupplierPriceListIdinteger(int32)

ChosenSupplierPriceListId. Nullable.

ChosenSupplierQtyBreakinteger(int32)

ChosenSupplierQtyBreak. Nullable.

IsChosenSupplierLockedboolean

IsChosenSupplierLocked.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

LastCheckedstring(date-time)

LastChecked. Nullable.

MinimumMarginPercentagenumber(decimal)

MinimumMarginPercentage. Nullable.

PriceRuleLastUpdatedstring(date-time)

PriceRuleLastUpdated. Nullable.

PriceRuleLastUpdatedByinteger(int32)

PriceRuleLastUpdatedBy. Nullable.

PricingIdinteger(int32)

PricingId. Nullable.

SupplementChargenumber(decimal)

SupplementCharge. Nullable.

LimitToPriceRecommendedboolean

LimitToPriceRecommended. Nullable.

IsActiveLastUpdatedstring(date-time)

IsActiveLastUpdated. Nullable.

IsActiveLastUpdatedByinteger(int32)

IsActiveLastUpdatedBy. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)
InfoArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPriceListInfo)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuPriceListInfo)

Info.

ProductSkuSalesArea

PartNostring

PartNo. MaxLength: 50. Key property.

SalesAreaIdinteger(int32)

SalesAreaId. Key property.

ClientIdinteger(int32)

ClientId.

VatCodeIdinteger(int32)

VatCodeId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductSkuStructureItem

StructurePartNostring

StructurePartNo. MaxLength: 50. Key property.

PartNostring

PartNo. MaxLength: 50. Key property.

ClientIdinteger(int32)

ClientId.

Qtynumber(decimal)

Qty.

SortOrderinteger(int32)

SortOrder. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

GroupIdinteger(int32)

GroupId. Nullable.

PriceListsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemPriceList)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemPriceList)

PriceLists.

InfoArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemInfo)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemInfo)

Info.

ItemSkuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSku)

ProductSkuStructureItemInfo

StructurePartNostring

StructurePartNo. MaxLength: 50. Key property.

PartNostring

PartNo. MaxLength: 50. Key property.

Codestring

Code. MaxLength: 50. Key property.

ClientIdinteger(int32)

ClientId.

Valuestring

Value. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

ProductSkuStructureItemPriceList

StructurePartNostring

StructurePartNo. MaxLength: 50. Key property.

PartNostring

PartNo. MaxLength: 50. Key property.

PriceListIdinteger(int32)

PriceListId. Key property.

QtyBreakinteger(int32)

QtyBreak. Key property.

ClientIdinteger(int32)

ClientId.

ItemPriceListIdinteger(int32)

ItemPriceListId.

CurrencyIdinteger(int32)

CurrencyId.

PriceSalenumber(decimal)

PriceSale.

PriceRuleIdinteger(int32)

PriceRuleId. Nullable.

PriceRuleValuenumber(decimal)

PriceRuleValue. Nullable.

CostPurchasenumber(decimal)

CostPurchase.

CostUnitnumber(decimal)

CostUnit.

SupplementChargePercentagenumber(decimal)

SupplementChargePercentage. Nullable.

PriceStandardnumber(decimal)

PriceStandard. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

MinimumMarginPercentagenumber(decimal)

MinimumMarginPercentage. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SupplementChargenumber(decimal)

SupplementCharge. Nullable.

LimitToPriceRecommendedboolean

LimitToPriceRecommended. Nullable.

ProductUpsell

ProductIdinteger(int32)

ProductId. Key property.

ClientIdinteger(int32)

ClientId.

UpsellProductIdinteger(int32)

UpsellProductId.

DefaultDescriptionstring

DefaultDescription. Nullable.

SortOrderinteger(int32)

SortOrder. Nullable.

PopulationRuleIdinteger(int32)

PopulationRuleId. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

IsProductVariantUniqueboolean

IsProductVariantUnique.

IsUpsellProductVariantUniqueboolean

IsUpsellProductVariantUnique.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsellCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductUpsellCulture)

Cultures.

ProductUpsellCulture

ProductIdinteger(int32)

ProductId. Key property.

UpsellProductIdinteger(int32)

UpsellProductId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId.

Descriptionstring

Description. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ProductVariantGroup

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.

Culturesstring

Cultures. Nullable.

ProductVariantType

ProductIdinteger(int32)

ProductId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

ClientIdinteger(int32)

ClientId.

DefaultValuestring

DefaultValue. MaxLength: 50. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantTypeCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductVariantTypeCulture)

Cultures.

ProductVariantTypeCulture

ProductIdinteger(int32)

ProductId. Key property.

TypeIdinteger(int32)

TypeId. Key property.

ClientIdinteger(int32)

ClientId.

CultureCodestring

CultureCode. MaxLength: 16. Nullable.

Valuestring

Value. MaxLength: 50. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

SupplierPriceList

Idinteger(int32)

Id. Key property.

SupplierIdinteger(int32)

SupplierId.

ManufacturerIdinteger(int32)

ManufacturerId. Nullable.

ManufacturerCodestring

ManufacturerCode. MaxLength: 50. Nullable.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

Descriptionstring

Description. MaxLength: 100. Nullable.

EndCustomerstring

EndCustomer. MaxLength: 100. Nullable.

StartDatestring(date-time)

StartDate. Nullable.

EndDatestring(date-time)

EndDate. Nullable.

TransferMethodIdinteger(int32)

TransferMethodId. Nullable.

TransferMethodValuestring

TransferMethodValue. MaxLength: 255. Nullable.

LastImportedstring(date-time)

LastImported. Nullable.

NextExpectedDatestring(date-time)

NextExpectedDate. Nullable.

IsPrimaryboolean

IsPrimary.

ParentSupplierPriceListIdinteger(int32)

ParentSupplierPriceListId. Nullable.

Contactstring

Contact. MaxLength: 50. Nullable.

Commentstring

Comment. MaxLength: 50. Nullable.

IsSpecialTermsboolean

IsSpecialTerms. Nullable.

IsManuallyMaintainedboolean

IsManuallyMaintained.

IgniteSourceIdinteger(int32)

IgniteSourceId. Nullable.

IgniteSourceLastImportedstring(date-time)

IgniteSourceLastImported. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

CurrencyIdinteger(int32)

CurrencyId. Nullable.

TraderaStockCodeSeedstring

TraderaStockCodeSeed. Nullable.

TraderaExternalStockCodeSeedstring

TraderaExternalStockCodeSeed. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

SupplierProductSku

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

Namestring

Name. MaxLength: 500. Nullable.

ManufacturerIdinteger(int32)

ManufacturerId. Nullable.

ManufacturerCodestring

ManufacturerCode. MaxLength: 50. Nullable.

ManufacturerPartNostring

ManufacturerPartNo. MaxLength: 50. Nullable.

CategoryIdinteger(int32)

CategoryId. Nullable.

CategoryCodestring

CategoryCode. MaxLength: 255. Nullable.

CommodityCodestring

CommodityCode. MaxLength: 50. Nullable.

EanCodestring

EanCode. MaxLength: 50. Nullable.

GrossWeightnumber(decimal)

GrossWeight. Nullable.

NetWeightnumber(decimal)

NetWeight. Nullable.

VatCodeIdinteger(int32)

VatCodeId. Nullable.

UnitOfMeasurementIdinteger(int32)

UnitOfMeasurementId.

UnitOfMeasurementCountnumber(decimal)

UnitOfMeasurementCount.

Urlstring

Url. MaxLength: 255. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ImagePathLastUpdatedstring(date-time)

ImagePathLastUpdated. Nullable.

IsUsedboolean

IsUsed.

LogisticWidthnumber(decimal)

LogisticWidth. Nullable.

LogisticHeightnumber(decimal)

LogisticHeight. Nullable.

LogisticDepthnumber(decimal)

LogisticDepth. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ProductIdinteger(int32)

ProductId. Nullable.

SupplierProductSkuClientArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuClient)

SupplierProductSkuClient.

OnHandsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuOnHand)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuOnHand)

OnHands.

PriceListsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuPriceList)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuPriceList)

PriceLists.

InfoArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuInfo)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSkuInfo)

Info.

SupplierProductSkuClient

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

ClientIdinteger(int32)

ClientId.

ProductIdinteger(int32)

ProductId. Nullable.

ManufacturerIdinteger(int32)

ManufacturerId. Nullable.

CategoryIdinteger(int32)

CategoryId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)
Productobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)

SupplierProductSkuInfo

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

Codestring

Code. MaxLength: 50. Key property.

Valuestring

Value. MaxLength: 255. Nullable.

Updatedstring(date-time)

Updated.

UpdatedByinteger(int32)

UpdatedBy.

SupplierProductSkuOnHand

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

WarehouseIdinteger(int32)

WarehouseId. Nullable. Key property.

LocationIdinteger(int32)

LocationId. Key property.

OnHandValuenumber(decimal)

OnHandValue.

OnHandLastCheckedstring(date-time)

OnHandLastChecked. Nullable.

OnHandLastUpdatedstring(date-time)

OnHandLastUpdated. Nullable.

OnHandLastUpdatedByinteger(int32)

OnHandLastUpdatedBy. Nullable.

IncomingValuenumber(decimal)

IncomingValue. Nullable.

IncomingLastCheckedstring(date-time)

IncomingLastChecked. Nullable.

IncomingLastUpdatedstring(date-time)

IncomingLastUpdated. Nullable.

IncomingLastUpdatedByinteger(int32)

IncomingLastUpdatedBy. Nullable.

NextDeliveryDatestring(date-time)

NextDeliveryDate. Nullable.

NextDeliveryLastCheckedstring(date-time)

NextDeliveryLastChecked. Nullable.

NextDeliveryLastUpdatedstring(date-time)

NextDeliveryLastUpdated. Nullable.

NextDeliveryLastUpdatedByinteger(int32)

NextDeliveryLastUpdatedBy. Nullable.

IsReturnableboolean

IsReturnable. Nullable.

LeadTimeDayCountinteger(int32)

LeadTimeDayCount. Nullable.

IsActiveboolean

IsActive.

StoppedDatestring(date-time)

StoppedDate. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ExternalStockValuenumber(decimal)

ExternalStockValue. Nullable.

PackageValuenumber(decimal)

PackageValue.

MinimumOrderValuenumber(decimal)

MinimumOrderValue.

ClientIdinteger(int32)

ClientId. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)
Warehouseobject(ProductService.Warehouse)(ProductService.Warehouse)
Locationsobject(ProductService.WarehouseLocation)(ProductService.WarehouseLocation)

SupplierProductSkuPriceList

PartNostring

PartNo. MaxLength: 50. Key property.

SupplierIdinteger(int32)

SupplierId. Key property.

SupplierPriceListIdinteger(int32)

SupplierPriceListId. Nullable. Key property.

QtyBreakinteger(int32)

QtyBreak. Key property.

CurrencyIdinteger(int32)

CurrencyId.

CostPurchasenumber(decimal)

CostPurchase.

CostPurchaseLastCheckedstring(date-time)

CostPurchaseLastChecked. Nullable.

CostPurchaseLastUpdatedstring(date-time)

CostPurchaseLastUpdated. Nullable.

CostPurchaseLastUpdatedByinteger(int32)

CostPurchaseLastUpdatedBy. Nullable.

CostPurchaseValidTostring(date-time)

CostPurchaseValidTo. Nullable.

PriceRecommendednumber(decimal)

PriceRecommended. Nullable.

PriceRecommendedLastUpdatedstring(date-time)

PriceRecommendedLastUpdated. Nullable.

PriceRecommendedLastUpdatedByinteger(int32)

PriceRecommendedLastUpdatedBy. Nullable.

PriceMaxnumber(decimal)

PriceMax. Nullable.

PriceMaxLastUpdatedstring(date-time)

PriceMaxLastUpdated. Nullable.

PriceMaxLastUpdatedByinteger(int32)

PriceMaxLastUpdatedBy. Nullable.

PriceDealernumber(decimal)

PriceDealer. Nullable.

PriceDealerLastUpdatedstring(date-time)

PriceDealerLastUpdated. Nullable.

PriceDealerLastUpdatedByinteger(int32)

PriceDealerLastUpdatedBy. Nullable.

IsActiveboolean

IsActive.

IsActiveLastUpdatedstring(date-time)

IsActiveLastUpdated. Nullable.

StoppedDatestring(date-time)

StoppedDate. Nullable.

IsPromotionboolean

IsPromotion. Nullable.

IsFocusboolean

IsFocus. Nullable.

PriceRankinginteger(int32)

PriceRanking. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

FreightCostnumber(decimal)

FreightCost. Nullable.

CostFeenumber(decimal)

CostFee. Nullable.

CostFeeLastUpdatedstring(date-time)

CostFeeLastUpdated. Nullable.

CostFeeLastUpdatedByinteger(int32)

CostFeeLastUpdatedBy. Nullable.

DiscountPctnumber(decimal)

DiscountPct. Nullable.

DiscountPctLastUpdatedstring(date-time)

DiscountPctLastUpdated. Nullable.

DiscountPctLastUpdatedByinteger(int32)

DiscountPctLastUpdatedBy. Nullable.

PriceCatalognumber(decimal)

PriceCatalog. Nullable.

PriceCatalogLastUpdatedstring(date-time)

PriceCatalogLastUpdated. Nullable.

PriceCatalogLastUpdatedByinteger(int32)

PriceCatalogLastUpdatedBy. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

Skuobject(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)(Enferno.Storm.Query.Api.DataContexts.ProductModel.SupplierProductSku)
PriceListobject(ProductService.SupplierPriceList)(ProductService.SupplierPriceList)

Variant

Idinteger(int32)

Id. Key property.

ClientIdinteger(int32)

ClientId.

DefaultNamestring

DefaultName. MaxLength: 255. Nullable.

DefaultImagePathstring

DefaultImagePath. MaxLength: 255. Nullable.

DefaultThumbnailImagePathstring

DefaultThumbnailImagePath. MaxLength: 255. Nullable.

DefaultCampaignImagePathstring

DefaultCampaignImagePath. MaxLength: 255. Nullable.

DefaultLargeImagePathstring

DefaultLargeImagePath. MaxLength: 255. Nullable.

GroupIdinteger(int32)

GroupId. Nullable.

Aliasstring

Alias. MaxLength: 255. Nullable.

DefaultTitlestring

DefaultTitle. MaxLength: 255. Nullable.

DefaultTagsstring

DefaultTags. Nullable.

DefaultMetaTagsstring

DefaultMetaTags. Nullable.

DefaultMetaDescriptionstring

DefaultMetaDescription. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

ImageKeystring(guid)

ImageKey. Nullable.

Codestring

Code. MaxLength: 50. Nullable.

DefaultUniqueUrlNamestring

DefaultUniqueUrlName. MaxLength: 500. Nullable.

Keystring(guid)

Key.

CulturesArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.VariantCulture)(Enferno.Storm.Query.Api.DataContexts.ProductModel.VariantCulture)

Cultures.

ProductsArray of objects(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)(Enferno.Storm.Query.Api.DataContexts.ProductModel.Product)

Products.

VariantGroupobject(ProductService.ProductVariantGroup)(ProductService.ProductVariantGroup)

VariantCulture

VariantIdinteger(int32)

VariantId. Key property.

CultureCodestring

CultureCode. MaxLength: 16. Key property.

ClientIdinteger(int32)

ClientId. Key property.

Namestring

Name. MaxLength: 255. Nullable.

ImagePathstring

ImagePath. MaxLength: 255. Nullable.

ThumbnailImagePathstring

ThumbnailImagePath. MaxLength: 255. Nullable.

CampaignImagePathstring

CampaignImagePath. MaxLength: 255. Nullable.

LargeImagePathstring

LargeImagePath. MaxLength: 255. Nullable.

Titlestring

Title. MaxLength: 255. Nullable.

Tagsstring

Tags. Nullable.

MetaTagsstring

MetaTags. Nullable.

MetaDescriptionstring

MetaDescription. Nullable.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

UniqueUrlNamestring

UniqueUrlName. MaxLength: 500. Nullable.

IsUniqueUrlNameManuallyMaintainedboolean

IsUniqueUrlNameManuallyMaintained.

ImageKeystring(guid)

ImageKey. Nullable.

NameLastUpdatedstring(date-time)

NameLastUpdated. Nullable.

NameLastUpdatedByinteger(int32)

NameLastUpdatedBy. Nullable.

Warehouse

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

WarehouseLocation

Idinteger(int32)

Id. Key property.

DefaultNamestring

DefaultName. MaxLength: 50. Nullable.

IsActiveboolean

IsActive.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

Previous page
Next page