COMMERCE QUERY

Query API 3.0

ProductInfoType

Query (v1)

Download OpenAPI description

openapi.json

openapi.yaml

Servers

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

Schemas

ClientProductSkuOnHandInfo

idinteger(int64)

The unique identifier of the client product sku on hand info type.

partNostring[ 0 .. 50 ] charactersrequired

The part number.

clientIdinteger(int32)

The client identifier.

warehouseIdinteger(int32)

The warehouse identifier.

locationIdinteger(int32)

The location identifier.

typeIdinteger(int32)

The type identifier.

valuestring[ 0 .. 255 ] charactersrequired

The value.

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.

clientProductSkuOnHand(ClientProductSkuOnHand (object or null))

One of:

type(ProductInfoType (object or null))

One of:

{
  "id": 0,
  "partNo": "string",
  "clientId": 0,
  "warehouseId": 0,
  "locationId": 0,
  "typeId": 0,
  "value": "string",
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "clientProductSkuOnHand": {
    "partNo": "string",
    "clientId": 0,
    "warehouseId": 0,
    "locationId": 0,
    "onHandValue": 0,
    "onHandLastChecked": "2019-08-24T14:15:22Z",
    "onHandLastUpdated": "2019-08-24T14:15:22Z",
    "onHandLastUpdatedBy": 0,
    "incomingValue": 0,
    "incomingLastChecked": "2019-08-24T14:15:22Z",
    "incomingLastUpdated": "2019-08-24T14:15:22Z",
    "incomingLastUpdatedBy": 0,
    "nextDeliveryDate": "2019-08-24T14:15:22Z",
    "nextDeliveryLastChecked": "2019-08-24T14:15:22Z",
    "nextDeliveryLastUpdated": "2019-08-24T14:15:22Z",
    "nextDeliveryLastUpdatedBy": 0,
    "isReturnable": true,
    "leadTimeDayCount": 0,
    "onOrderValue": 0,
    "minimumValue": 0,
    "maximumValue": 0,
    "isActive": true,
    "stoppedDate": "2019-08-24T14:15:22Z",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "reservationValue": 0,
    "isActiveLastUpdated": "2019-08-24T14:15:22Z",
    "isActiveLastUpdatedBy": 0,
    "clientProductSku": { … },
    "info": [ … ],
    "warehouse": { … }
  },
  "type": {
    "id": 0,
    "clientId": 0,
    "groupId": 0,
    "defaultName": "string",
    "defaultDescription": "string",
    "sortOrder": 0,
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "code": "string",
    "clientProductSkuOnHandInfo": [ … ],
    "clientProductSkuPriceListInfo": [ … ],
    "cultures": [ … ]
  }
}

ProductInfoType

idinteger(int32)

The unique identifier of the product info type.

clientIdinteger(int32)

The client identifier.

groupIdinteger(int32)

The info type group identifier, OnHandInfo (2), PriceListInfo (3).

defaultNamestring[ 0 .. 50 ] charactersrequired

The default name of the product info type.

defaultDescriptionstring or null[ 0 .. 500 ] characters

The default description of the product info type.

sortOrderinteger(int32)

The sort order for display purposes.

isActiveboolean

Indicates whether the product info type 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.

codestring or null[ 0 .. 50 ] characters

The code of the product info type.

clientProductSkuOnHandInfoArray of objects or null(ClientProductSkuOnHandInfo)

clientProductSkuPriceListInfoArray of objects or null(ClientProductSkuPriceListInfo)

culturesArray of objects or null(ProductInfoTypeCulture)

{
  "id": 0,
  "clientId": 0,
  "groupId": 0,
  "defaultName": "string",
  "defaultDescription": "string",
  "sortOrder": 0,
  "isActive": true,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "code": "string",
  "clientProductSkuOnHandInfo": [
    { … }
  ],
  "clientProductSkuPriceListInfo": [
    { … }
  ],
  "cultures": [
    { … }
  ]
}

ClientProductSkuPriceListInfo

idinteger(int64)

The unique identifier of the client product sku price list info type.

partNostring[ 0 .. 50 ] charactersrequired

The part number.

clientIdinteger(int32)

The client identifier.

priceListIdinteger(int32)

The price list identifier.

qtyBreakinteger(int32)

The quantity break.

typeIdinteger(int32)

The type identifier.

valuestring[ 0 .. 255 ] charactersrequired

The value.

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.

clientProductSkuPriceList(ClientProductSkuPriceList (object or null))

One of:

type(ProductInfoType (object or null))

One of:

{
  "id": 0,
  "partNo": "string",
  "clientId": 0,
  "priceListId": 0,
  "qtyBreak": 0,
  "typeId": 0,
  "value": "string",
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "clientProductSkuPriceList": {
    "partNo": "string",
    "clientId": 0,
    "priceListId": 0,
    "qtyBreak": 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": { … },
    "info": [ … ],
    "priceList": { … }
  },
  "type": {
    "id": 0,
    "clientId": 0,
    "groupId": 0,
    "defaultName": "string",
    "defaultDescription": "string",
    "sortOrder": 0,
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "code": "string",
    "clientProductSkuOnHandInfo": [ … ],
    "clientProductSkuPriceListInfo": [ … ],
    "cultures": [ … ]
  }
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations