COMMERCE QUERY

Query API 3.0

ClientProductSkuStructureItemPriceList

Query (v1)

Download OpenAPI description

openapi.json

openapi.yaml

Servers

https://norcecommerce.api-se.norce.tech/commerce/query/3.0/

Schemas

ClientProductSkuStructureItemInfo

clientIdinteger(int32)

The client identifier.

structurePartNostring or null[ 0 .. 50 ] characters

The structure part number, the parent part number.

partNostring or null[ 0 .. 50 ] characters

The part number, the child part number.

codestring or null[ 0 .. 50 ] characters

The code of the client product sku structure item info.

valuestring[ 0 .. 255 ] charactersrequired

The value.

updatedstring(date-time)

The date and time the record was last updated.

updatedByinteger(int32)

The identifier of the user who last updated the record.

clientProductSkuStructureItem(ClientProductSkuStructureItem (object or null))

One of:

{
  "clientId": 0,
  "structurePartNo": "string",
  "partNo": "string",
  "code": "string",
  "value": "string",
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "clientProductSkuStructureItem": {
    "structurePartNo": "string",
    "clientId": 0,
    "partNo": "string",
    "qty": 0,
    "sortOrder": 0,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "groupId": 0,
    "itemSku": { … },
    "info": [ … ],
    "priceLists": [ … ]
  }
}

ClientProductSkuStructureItemPriceList

structurePartNostring or null[ 0 .. 50 ] characters

The structure part number, the parent part number.

clientIdinteger(int32)

The client identifier.

partNostring or null[ 0 .. 50 ] characters

The part number, the child part number.

priceListIdinteger(int32)

The price list identifier.

qtyBreakinteger(int32)

The quantity break.

itemPriceListIdinteger(int32)

The item price list identifier, should be same as the price list identifier.

currencyIdinteger(int32)

The currency identifier.

priceSalenumber or null(decimal)

The price sale, the calculated item sale price.

priceRuleIdinteger or null(int32)

The price rule identifier.

priceRuleValuenumber or null(decimal)

The price rule value.

costPurchasenumber or null(decimal)

The cost purchase, from the item's own price list record.

costUnitnumber or null(decimal)

The cost unit, from the item's own price list record.

supplementChargePercentagenumber or null(decimal)

The supplement charge percentage.

priceStandardnumber or null(decimal)

The price standard, from the item's own price list record.

priceRecommendednumber or null(decimal)

The price recommended, from the item's own price list record.

minimumMarginPercentagenumber or null(decimal)

The minimum margin percentage.

isActiveboolean

Indicates whether the client product sku structure item price list is active.

createdstring(date-time)

The date and time the record was created.

createdByinteger(int32)

The identifier of the user who created the record.

updatedstring or null(date-time)

The date and time the record was last updated.

updatedByinteger or null(int32)

The identifier of the user who last updated the record.

supplementChargenumber or null(decimal)

The supplement charge.

limitToPriceRecommendedboolean or null

Indicates whether limit to price recommended is enabled.

clientProductSkuStructureItem(ClientProductSkuStructureItem (object or null))

One of:

{
  "structurePartNo": "string",
  "clientId": 0,
  "partNo": "string",
  "priceListId": 0,
  "qtyBreak": 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,
  "clientProductSkuStructureItem": {
    "structurePartNo": "string",
    "clientId": 0,
    "partNo": "string",
    "qty": 0,
    "sortOrder": 0,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "groupId": 0,
    "itemSku": { … },
    "info": [ … ],
    "priceLists": [ … ]
  }
}

ClientProductSkuBestPrice

idinteger(int32)

The unique identifier of the client product sku best price.

partNostring[ 0 .. 50 ] charactersrequired

The part number.

applicationIdinteger(int32)

The application identifier.

qtyBreakinteger(int32)

The quantity break.

clientIdinteger(int32)

The client identifier.

priceListIdinteger(int32)

The price list identifier.

currencyIdinteger(int32)

The currency identifier.

priceSalenumber(decimal)

The price sale.

timeStampstring(date-time)

The time stamp.

clientProductSku(ClientProductSku (object or null))

One of:

{
  "id": 0,
  "partNo": "string",
  "applicationId": 0,
  "qtyBreak": 0,
  "clientId": 0,
  "priceListId": 0,
  "currencyId": 0,
  "priceSale": 0,
  "timeStamp": "2019-08-24T14:15:22Z",
  "clientProductSku": {
    "partNo": "string",
    "clientId": 0,
    "productId": 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",
    "cultures": [ … ],
    "onHands": [ … ],
    "priceLists": [ … ],
    "salesAreas": [ … ],
    "structureItems": [ … ],
    "bestPrices": [ … ],
    "product": { … }
  }
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations