COMMERCE QUERY

Query API 3.0

WarehouseLocation

Query (v1)

Download OpenAPI description

openapi.json

openapi.yaml

Servers

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

Schemas

ClientWarehouseLocation

clientIdinteger(int32)

The client identifier.

warehouseIdinteger(int32)

The warehouse identifier.

locationIdinteger(int32)

The location identifier.

codestring or null[ 0 .. 50 ] characters

The code of the client warehouse location.

namestring or null[ 0 .. 50 ] characters

The name of the client warehouse location.

isStandardboolean

Indicates whether the client warehouse location is standard, only one standard location is allowed per warehouse.

isIncludedInStockCalculationboolean

Indicates whether the client warehouse location is included in stock calculation.

standardLeadTimeDayCountinteger or null(int32)

The standard lead time day count, used for calculating the expected delivery time.

freightCostnumber or null(decimal)

The freight cost, not used anymore.

upToDateTypeIdinteger(int32)

The up to date type identifier, not used anymore.

costBlockinteger or null(int32)

The cost block, not used anymore.

valueBtstring or null[ 0 .. 100 ] characters

The value bt, not used anymore.

primaryPriceListIdinteger or null(int32)

The primary price list identifier, used internally for referencing back to the price list of choice from the warehouselocation perspective, not relevant anymore.

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.

supportsReservationboolean

Indicates whether supports reservation is enabled, not currently in use.

supportsStockQueryboolean

Indicates whether supports stock query is enabled, not currently in use.

clientWarehouse(ClientWarehouse (object or null))

One of:

location(WarehouseLocation (object or null))

One of:

warehouse(Warehouse (object or null))

One of:

{
  "clientId": 0,
  "warehouseId": 0,
  "locationId": 0,
  "code": "string",
  "name": "string",
  "isStandard": true,
  "isIncludedInStockCalculation": true,
  "standardLeadTimeDayCount": 0,
  "freightCost": 0,
  "upToDateTypeId": 0,
  "costBlock": 0,
  "valueBt": "string",
  "primaryPriceListId": 0,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "supportsReservation": true,
  "supportsStockQuery": true,
  "clientWarehouse": {
    "clientId": 0,
    "warehouseId": 0,
    "typeId": 0,
    "code": "string",
    "name": "string",
    "isStandard": true,
    "standardLeadTimeDayCount": 0,
    "freightCost": 0,
    "costBlock": 0,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "locations": [ … ],
    "warehouse": { … }
  },
  "location": {
    "id": 0,
    "defaultName": "string",
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "clientWarehouseLocation": [ … ],
    "supplierProductSkuOnHand": [ … ]
  },
  "warehouse": {
    "id": 0,
    "defaultName": "string",
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "clientProductSkuOnHand": [ … ],
    "clientWarehouse": [ … ],
    "clientWarehouseLocation": [ … ],
    "supplierProductSkuOnHand": [ … ]
  }
}

WarehouseLocation

idinteger(int32)

The unique identifier of the warehouse location.

defaultNamestring[ 0 .. 50 ] charactersrequired

The default name of the warehouse location.

isActiveboolean

Indicates whether the warehouse location 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.

clientWarehouseLocationArray of objects or null(ClientWarehouseLocation)

supplierProductSkuOnHandArray of objects or null(SupplierProductSkuOnHand)

{
  "id": 0,
  "defaultName": "string",
  "isActive": true,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "clientWarehouseLocation": [
    { … }
  ],
  "supplierProductSkuOnHand": [
    { … }
  ]
}

SupplierProductSkuOnHand

partNostring or null[ 0 .. 50 ] characters

The supplier part number.

supplierIdinteger(int32)

The supplier identifier.

warehouseIdinteger(int32)

The supplier warehouse identifier.

locationIdinteger(int32)

The supplier location identifier.

onHandValuenumber(decimal)

The on hand value.

onHandLastCheckedstring or null(date-time)

The on hand last checked.

onHandLastUpdatedstring or null(date-time)

The on hand last updated.

onHandLastUpdatedByinteger or null(int32)

The on hand last updated by.

incomingValuenumber or null(decimal)

The incoming value. Optional field that can be used together with next delivery date to give a more complete picture of the stock situation.

incomingLastCheckedstring or null(date-time)

The incoming last checked.

incomingLastUpdatedstring or null(date-time)

The incoming last updated.

incomingLastUpdatedByinteger or null(int32)

The incoming last updated by.

nextDeliveryDatestring or null(date-time)

The next delivery date. Optional field that can be used together with incoming value to give a more complete picture of the stock situation.

nextDeliveryLastCheckedstring or null(date-time)

The next delivery last checked.

nextDeliveryLastUpdatedstring or null(date-time)

The next delivery last updated.

nextDeliveryLastUpdatedByinteger or null(int32)

The next delivery last updated by.

isReturnableboolean or null

Indicates whether the supplier product sku on hand is returnable. Not commonly used.

leadTimeDayCountinteger or null(int32)

The lead time day count. Indicates the number of days it takes for the end-customer to get goods delivered from this supplier.

isActiveboolean

Indicates whether the supplier product sku on hand is active.

stoppedDatestring or null(date-time)

The stopped date. Not commonly used.

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.

externalStockValuenumber or null(decimal)

The external stock value. Not commonly used.

packageValuenumber(decimal)

The package value. Not commonly used.

minimumOrderValuenumber(decimal)

The minimum order value. Not commonly used.

clientIdinteger or null(int32)

The client identifier.

locations(WarehouseLocation (object or null))

One of:

supplierProductSku(SupplierProductSku (object or null))

One of:

warehouse(Warehouse (object or null))

One of:

{
  "partNo": "string",
  "supplierId": 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,
  "isActive": true,
  "stoppedDate": "2019-08-24T14:15:22Z",
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "externalStockValue": 0,
  "packageValue": 0,
  "minimumOrderValue": 0,
  "clientId": 0,
  "locations": {
    "id": 0,
    "defaultName": "string",
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "clientWarehouseLocation": [ … ],
    "supplierProductSkuOnHand": [ … ]
  },
  "supplierProductSku": {
    "partNo": "string",
    "supplierId": 0,
    "name": "string",
    "manufacturerId": 0,
    "manufacturerCode": "string",
    "manufacturerPartNo": "string",
    "categoryId": 0,
    "categoryCode": "string",
    "commodityCode": "string",
    "eanCode": "string",
    "grossWeight": 0,
    "netWeight": 0,
    "vatCodeId": 0,
    "unitOfMeasurementId": 0,
    "unitOfMeasurementCount": 0,
    "url": "string",
    "imagePath": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "imagePathLastUpdated": "2019-08-24T14:15:22Z",
    "isUsed": true,
    "logisticWidth": 0,
    "logisticHeight": 0,
    "logisticDepth": 0,
    "clientId": 0,
    "productId": 0,
    "supplierProductSkuClient": [ … ],
    "onHands": [ … ],
    "priceLists": [ … ]
  },
  "warehouse": {
    "id": 0,
    "defaultName": "string",
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "clientProductSkuOnHand": [ … ],
    "clientWarehouse": [ … ],
    "clientWarehouseLocation": [ … ],
    "supplierProductSkuOnHand": [ … ]
  }
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations