COMMERCE QUERY

Query API 3.0

SupplierPriceList

Query (v1)

Download OpenAPI description

openapi.json

openapi.yaml

Servers

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

Schemas

SupplierProductSkuPriceList

partNostring or null[ 0 .. 50 ] characters

The supplier part number.

supplierIdinteger(int32)

The internal identifier of the supplier.

supplierPriceListIdinteger(int32)

The supplier price list identifier.

qtyBreakinteger(int32)

The quantity break.

currencyIdinteger(int32)

The currency identifier.

costPurchasenumber or null(decimal)

The cost purchase.

costPurchaseLastCheckedstring or null(date-time)

The cost purchase last checked.

costPurchaseLastUpdatedstring or null(date-time)

The cost purchase last updated.

costPurchaseLastUpdatedByinteger or null(int32)

The cost purchase last updated by.

costPurchaseValidTostring or null(date-time)

The cost purchase valid to. Not commonly used.

priceRecommendednumber or null(decimal)

The price recommended. Can optionally be copied to the client price list.

priceRecommendedLastUpdatedstring or null(date-time)

The price recommended last updated.

priceRecommendedLastUpdatedByinteger or null(int32)

The price recommended last updated by.

priceMaxnumber or null(decimal)

The price max. Not used anymore.

priceMaxLastUpdatedstring or null(date-time)

The price max last updated. Not used anymore.

priceMaxLastUpdatedByinteger or null(int32)

The price max last updated by. Not used anymore.

priceDealernumber or null(decimal)

The price dealer. Not used anymore.

priceDealerLastUpdatedstring or null(date-time)

The price dealer last updated. Not used anymore.

priceDealerLastUpdatedByinteger or null(int32)

The price dealer last updated by. Not used anymore.

isActiveboolean

Indicates whether the supplier product sku price list is active.

isActiveLastUpdatedstring or null(date-time)

The is active last updated.

stoppedDatestring or null(date-time)

The stopped date.

isPromotionboolean or null

Indicates whether the supplier product sku price list is promotion. Not commonly used.

isFocusboolean or null

Indicates whether the supplier product sku price list is focus. Not commonly used.

priceRankinginteger or null(int32)

The price ranking. 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.

freightCostnumber or null(decimal)

The freight cost. Not commonly used.

costFeenumber or null(decimal)

The cost fee. Not commonly used.

costFeeLastUpdatedstring or null(date-time)

The cost fee last updated. Not commonly used.

costFeeLastUpdatedByinteger or null(int32)

The cost fee last updated by. Not commonly used.

discountPctnumber or null(decimal)

The discount pct. Not commonly used.

discountPctLastUpdatedstring or null(date-time)

The discount pct last updated. Not commonly used.

discountPctLastUpdatedByinteger or null(int32)

The discount pct last updated by. Not commonly used.

priceCatalognumber or null(decimal)

The price catalog. Not commonly used.

priceCatalogLastUpdatedstring or null(date-time)

The price catalog last updated. Not commonly used.

priceCatalogLastUpdatedByinteger or null(int32)

The price catalog last updated by. Not commonly used.

clientIdinteger or null(int32)

The client identifier.

priceList(SupplierPriceList (object or null))

One of:

supplierProductSku(SupplierProductSku (object or null))

One of:

{
  "partNo": "string",
  "supplierId": 0,
  "supplierPriceListId": 0,
  "qtyBreak": 0,
  "currencyId": 0,
  "costPurchase": 0,
  "costPurchaseLastChecked": "2019-08-24T14:15:22Z",
  "costPurchaseLastUpdated": "2019-08-24T14:15:22Z",
  "costPurchaseLastUpdatedBy": 0,
  "costPurchaseValidTo": "2019-08-24T14:15:22Z",
  "priceRecommended": 0,
  "priceRecommendedLastUpdated": "2019-08-24T14:15:22Z",
  "priceRecommendedLastUpdatedBy": 0,
  "priceMax": 0,
  "priceMaxLastUpdated": "2019-08-24T14:15:22Z",
  "priceMaxLastUpdatedBy": 0,
  "priceDealer": 0,
  "priceDealerLastUpdated": "2019-08-24T14:15:22Z",
  "priceDealerLastUpdatedBy": 0,
  "isActive": true,
  "isActiveLastUpdated": "2019-08-24T14:15:22Z",
  "stoppedDate": "2019-08-24T14:15:22Z",
  "isPromotion": true,
  "isFocus": true,
  "priceRanking": 0,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "freightCost": 0,
  "costFee": 0,
  "costFeeLastUpdated": "2019-08-24T14:15:22Z",
  "costFeeLastUpdatedBy": 0,
  "discountPct": 0,
  "discountPctLastUpdated": "2019-08-24T14:15:22Z",
  "discountPctLastUpdatedBy": 0,
  "priceCatalog": 0,
  "priceCatalogLastUpdated": "2019-08-24T14:15:22Z",
  "priceCatalogLastUpdatedBy": 0,
  "clientId": 0,
  "priceList": {
    "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": [ … ]
  },
  "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": [ … ]
  }
}

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": { … }
  }
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations