COMMERCE QUERY
/
Products
/
Schemas
/
Enferno.Storm.Query.Api.DataContexts.ProductModel.ProductSkuStructureItemPriceList

Norce Query API Documentation (2.0)

Norce Query API is an API based on OData V4. It is an API to fill the need for data from Norce in integration services that do not have direct access to Norce’s data and data models.

Download OpenAPI description
openapi.json
openapi.yaml
Languages
Servers

https://customer-slug.api-se.norce.tech/commerce/query/2.0/

Schemas

Enferno.Storm.Query.Api.DataContexts.ProductModel.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.

{
  "StructurePartNo": "string",
  "PartNo": "string",
  "Code": "string",
  "ClientId": 0,
  "Value": "string",
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.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.

{
  "StructurePartNo": "string",
  "PartNo": "string",
  "PriceListId": 0,
  "QtyBreak": 0,
  "ClientId": 0,
  "ItemPriceListId": 0,
  "CurrencyId": 0,
  "PriceSale": 0,
  "PriceRuleId": 0,
  "PriceRuleValue": 0,
  "CostPurchase": 0,
  "CostUnit": 0,
  "SupplementChargePercentage": 0,
  "PriceStandard": 0,
  "PriceRecommended": 0,
  "MinimumMarginPercentage": 0,
  "IsActive": true,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "SupplementCharge": 0,
  "LimitToPriceRecommended": true
}

Enferno.Storm.Query.Api.DataContexts.ProductModel.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.

{
  "PartNo": "string",
  "PriceListId": 0,
  "QtyBreak": 0,
  "ClientId": 0,
  "CurrencyId": 0,
  "PriceSale": 0,
  "PriceSaleLastUpdated": "2019-08-24T14:15:22Z",
  "PriceSaleLastUpdatedBy": 0,
  "PriceRuleId": 0,
  "PriceRuleValue": 0,
  "CostPurchase": 0,
  "CostPurchaseLastUpdated": "2019-08-24T14:15:22Z",
  "CostPurchaseLastUpdatedBy": 0,
  "CostUnit": 0,
  "CostUnitLastUpdated": "2019-08-24T14:15:22Z",
  "CostUnitLastUpdatedBy": 0,
  "SupplementChargePercentage": 0,
  "PriceStandard": 0,
  "PriceRecommended": 0,
  "PriceRecommendedLastUpdated": "2019-08-24T14:15:22Z",
  "PriceRecommendedLastUpdatedBy": 0,
  "PricePrevious": 0,
  "PricePreviousLastUpdated": "2019-08-24T14:15:22Z",
  "PricePreviousLastUpdatedBy": 0,
  "PriceCatalog": 0,
  "PriceCatalogLastUpdated": "2019-08-24T14:15:22Z",
  "PriceCatalogLastUpdatedBy": 0,
  "IsPriceDiscountable": true,
  "ChosenSupplierId": 0,
  "ChosenSupplierPartNo": "string",
  "ChosenSupplierPriceListId": 0,
  "ChosenSupplierQtyBreak": 0,
  "IsChosenSupplierLocked": true,
  "IsActive": true,
  "StoppedDate": "2019-08-24T14:15:22Z",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "LastChecked": "2019-08-24T14:15:22Z",
  "MinimumMarginPercentage": 0,
  "PriceRuleLastUpdated": "2019-08-24T14:15:22Z",
  "PriceRuleLastUpdatedBy": 0,
  "PricingId": 0,
  "SupplementCharge": 0,
  "LimitToPriceRecommended": true,
  "IsActiveLastUpdated": "2019-08-24T14:15:22Z",
  "IsActiveLastUpdatedBy": 0,
  "Sku": {
    "PartNo": "string",
    "ProductId": 0,
    "ClientId": 0,
    "StatusId": 0,
    "StatusLastUpdated": "2019-08-24T14:15:22Z",
    "StatusLastUpdatedBy": 0,
    "TypeId": 0,
    "IntegrationPartNo": "string",
    "ErpName": "string",
    "DefaultComment": "string",
    "CommodityCode": "string",
    "EanCode": "string",
    "TrackingCode": "string",
    "GrossWeight": 0,
    "NetWeight": 0,
    "FreightClassId": 0,
    "UnitOfMeasurementId": 0,
    "UnitOfMeasurementCount": 0,
    "PackageId": 0,
    "TrackingCodeTypeId": 0,
    "Url": "string",
    "ImagePath": "string",
    "IsDropShipOnly": true,
    "IsPublished": true,
    "PublishedLastUpdated": "2019-08-24T14:15:22Z",
    "PublishedLastUpdatedBy": 0,
    "IsBlocked": true,
    "BlockedLastUpdated": "2019-08-24T14:15:22Z",
    "BlockedLastUpdatedBy": 0,
    "PopulationRuleId": 0,
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0,
    "LastChecked": "2019-08-24T14:15:22Z",
    "TrackingModeTypeId": 0,
    "IsStatusLocked": true,
    "StatusLockedDate": "2019-08-24T14:15:22Z",
    "StatusLockedBy": 0,
    "RecommendedSalesQty": 0,
    "LogisticWidth": 0,
    "LogisticHeight": 0,
    "LogisticDepth": 0,
    "IsBuyable": true,
    "BuyableLastUpdated": "2019-08-24T14:15:22Z",
    "BuyableLastUpdatedBy": 0,
    "DiscountClass": "string",
    "IsRecommendedSalesQtyFixed": true,
    "StartDate": "2019-08-24T14:15:22Z",
    "EndDate": "2019-08-24T14:15:22Z",
    "Product": { … },
    "Cultures": [ … ],
    "PriceLists": [ … ],
    "SalesAreas": [ … ],
    "OnHands": [ … ],
    "StructureItems": [ … ],
    "BestPrices": [ … ]
  },
  "Info": [
    { … }
  ]
}

Products

Operations