COMMERCE QUERY

Query API 3.0

ClientProductSkuSalesArea

Query (v1)

Download OpenAPI description

openapi.json

openapi.yaml

Servers

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

Schemas

SupplierPriceList

idinteger(int32)

The unique identifier of the supplier price list.

supplierIdinteger(int32)

The supplier identifier.

manufacturerIdinteger or null(int32)

The manufacturer identifier. If the supplier is a manufacturer as well, not used anymore.

manufacturerCodestring or null[ 0 .. 50 ] characters

The manufacturer code. If the supplier is a manufacturer as well, not used anymore.

defaultNamestring[ 0 .. 50 ] charactersrequired

The default name of the supplier price list.

codestring or null[ 0 .. 50 ] characters

The code of the supplier price list.

descriptionstring or null[ 0 .. 100 ] characters

The description of the supplier price list.

endCustomerstring or null[ 0 .. 100 ] characters

The end customer. A free text field that can be used to specify an end customer for the supplier price list. Can be used when the price list is a supplier specific agreement. But not commonly used.

startDatestring or null(date-time)

The start date. Not used anymore.

endDatestring or null(date-time)

The end date. Not used anymore.

transferMethodIdinteger or null(int32)

The transfer method identifier. Not used anymore.

transferMethodValuestring or null[ 0 .. 255 ] characters

The transfer method value. Not used anymore.

lastImportedstring or null(date-time)

The last imported. Not used anymore.

nextExpectedDatestring or null(date-time)

The next expected date. Not used anymore.

isPrimaryboolean

Indicates whether the supplier price list is primary. A supplier can have multiple price lists, but only one primary price list. The primary price list is the one that is used for the supplier when no specific price list is specified. Not commonly used.

parentSupplierPriceListIdinteger or null(int32)

The parent supplier price list identifier. Not used anymore.

contactstring or null[ 0 .. 50 ] characters

The contact. Not commonly used.

commentstring or null[ 0 .. 50 ] characters

A comment or note. Not commonly used.

isSpecialTermsboolean or null

Indicates whether the supplier price list is special terms. Not commonly used.

isManuallyMaintainedboolean

Indicates whether the supplier price list is manually maintained. Not used anymore.

igniteSourceIdinteger or null(int32)

The ignite source identifier. Not used anymore.

igniteSourceLastImportedstring or null(date-time)

The ignite source last imported. Not used 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.

currencyIdinteger or null(int32)

The currency identifier.

traderaStockCodeSeedstring or null

The tradera stock code seed. Not used anymore.

traderaExternalStockCodeSeedstring or null

The tradera external stock code seed. Not used anymore.

clientIdinteger or null(int32)

The client identifier.

supplierProductSkuPriceListArray of objects or null(SupplierProductSkuPriceList)

{
  "id": 0,
  "supplierId": 0,
  "manufacturerId": 0,
  "manufacturerCode": "string",
  "defaultName": "string",
  "code": "string",
  "description": "string",
  "endCustomer": "string",
  "startDate": "2019-08-24T14:15:22Z",
  "endDate": "2019-08-24T14:15:22Z",
  "transferMethodId": 0,
  "transferMethodValue": "string",
  "lastImported": "2019-08-24T14:15:22Z",
  "nextExpectedDate": "2019-08-24T14:15:22Z",
  "isPrimary": true,
  "parentSupplierPriceListId": 0,
  "contact": "string",
  "comment": "string",
  "isSpecialTerms": true,
  "isManuallyMaintained": true,
  "igniteSourceId": 0,
  "igniteSourceLastImported": "2019-08-24T14:15:22Z",
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "currencyId": 0,
  "traderaStockCodeSeed": "string",
  "traderaExternalStockCodeSeed": "string",
  "clientId": 0,
  "supplierProductSkuPriceList": [
    { … }
  ]
}

ClientProductSkuSalesArea

partNostring or null[ 0 .. 50 ] characters

The part number.

clientIdinteger(int32)

The client identifier.

salesAreaIdinteger(int32)

The sales area identifier.

vatCodeIdinteger or null(int32)

The vat code identifier.

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.

clientProductSku(ClientProductSku (object or null))

One of:

{
  "partNo": "string",
  "clientId": 0,
  "salesAreaId": 0,
  "vatCodeId": 0,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "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": { … }
  }
}

ClientProductSkuStructureItem

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.

qtynumber(decimal)

The quantity of the child item in the structure.

sortOrderinteger or null(int32)

The sort order for display purposes.

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.

groupIdinteger or null(int32)

The group identifier, used to group configuration items, not currently in use.

itemSku(ClientProductSku (object or null))

One of:

infoArray of objects or null(ClientProductSkuStructureItemInfo)

priceListsArray of objects or null(ClientProductSkuStructureItemPriceList)

{
  "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": {
    "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": { … }
  },
  "info": [
    { … }
  ],
  "priceLists": [
    { … }
  ]
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations