COMMERCE QUERY

Query API 3.0

DeliveryNoteItem

Query (v1)

Download OpenAPI description

openapi.json

openapi.yaml

Servers

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

Schemas

OrderItem

idinteger(int64)

The unique identifier of the order item.

orderIdinteger(int64)

The order identifier.

lineNumbernumber(decimal)

The line number.

parentLineNumbernumber or null(decimal)

The parent line number, is the line has a relationship to another line, like a bundle or an accessory grouped together in the purchase (warrantied, services, etc.).

statusIdinteger(int32)

The status identifier, common values are Created (0), Allocation (1), Confirmed (2), Delivered (4), Invoiced (5), Cancelled (6), Partly delivered (8).

partNostring[ 0 .. 50 ] charactersrequired

The product part number.

externalPartNostring or null[ 0 .. 50 ] characters

The optional external part number, not commonly used.

productNamestring or null[ 0 .. 255 ] characters

The product name.

stockUnitOfMeasurementCountnumber(decimal)

The stock unit of measurement count, should be same as unit of measurement count on the ProductSku, commonly 1.000.

priceUnitOfMeasurementCountnumber(decimal)

The price unit of measurement count, should be same as unit of measurement count on the ProductSku, commonly 1.000.

warehouseIdinteger or null(int32)

The warehouse identifier, not used anymore.

locationIdinteger or null(int32)

The location identifier, not used anymore.

qtyOrderednumber(decimal)

The quantity ordered.

currencyIdinteger(int32)

The currency identifier.

vatRatenumber(decimal)

The VAT rate, in percent for example 25.0000 for 25%.

costUnitnumber(decimal)

The unit cost, excluding VAT when order was created.

priceSalenumber(decimal)

The price sale, unit price excluding VAT when order was created, including any discounts.

discountPercentagenumber(decimal)

The discount percentage, from promotions only, campaign price lists are not included.

discountAmountnumber(decimal)

The discount amount excluding VAT, from promotions only, campaign price lists are not included.

lineAmountnumber(decimal)

The line amount, subtotal excluding VAT (PriceSale * QtyOrdered).

deliveryModestring or null[ 0 .. 50 ] characters

The delivery mode, not commonly used.

isPartDeliveryboolean

Indicates whether the order item is part delivery, can be true if quantity ordered is partly delivered by a DeliveryNote.

expectedDeliveryDatestring or null(date-time)

The expected delivery date, not used anymore.

confirmedDeliveryDatestring or null(date-time)

The confirmed delivery date, not used anymore.

salesRepContactIdinteger or null(int32)

The sales rep contact identifier, not used anymore.

ledgerAccountstring or null[ 0 .. 50 ] characters

The ledger account, not used anymore.

departmentstring or null[ 0 .. 10 ] characters

The department, not used anymore.

centrestring or null[ 0 .. 10 ] characters

The centre, not used anymore.

transIdinteger(int64)

The trans identifier, not used anymore.

externalStatusTextstring or null[ 0 .. 255 ] characters

The external status text, 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.

lineNumberStringstring or null[ 0 .. 50 ] characters

The line number in a string format.

priceRecommendednumber or null(decimal)

The recommended price, when order was created, commonly used as reference to undiscounted price when campaign price lists are applied to SalePrice, if null check PriceStandard instead.

priceCatalognumber or null(decimal)

The price catalog, when order was created.

priceStandardnumber or null(decimal)

The Sale price from the parent price list if parent exists, when order was created, can be used as reference to undiscounted price when campaign price lists are applied to SalePrice, if PriceRecommended is null.

clientIdinteger or null(int32)

The client identifier.

deliveryNoteItemArray of objects or null(DeliveryNoteItem)

invoiceItemArray of objects or null(InvoiceItem)

order(Order (object or null))

One of:

infosArray of objects or null(OrderItemInfo)

{
  "id": 0,
  "orderId": 0,
  "lineNumber": 0,
  "parentLineNumber": 0,
  "statusId": 0,
  "partNo": "string",
  "externalPartNo": "string",
  "productName": "string",
  "stockUnitOfMeasurementCount": 0,
  "priceUnitOfMeasurementCount": 0,
  "warehouseId": 0,
  "locationId": 0,
  "qtyOrdered": 0,
  "currencyId": 0,
  "vatRate": 0,
  "costUnit": 0,
  "priceSale": 0,
  "discountPercentage": 0,
  "discountAmount": 0,
  "lineAmount": 0,
  "deliveryMode": "string",
  "isPartDelivery": true,
  "expectedDeliveryDate": "2019-08-24T14:15:22Z",
  "confirmedDeliveryDate": "2019-08-24T14:15:22Z",
  "salesRepContactId": 0,
  "ledgerAccount": "string",
  "department": "string",
  "centre": "string",
  "transId": 0,
  "externalStatusText": "string",
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "lineNumberString": "string",
  "priceRecommended": 0,
  "priceCatalog": 0,
  "priceStandard": 0,
  "clientId": 0,
  "deliveryNoteItem": [
    { … }
  ],
  "invoiceItem": [
    { … }
  ],
  "order": {
    "buyerCustomer": { … },
    "id": 0,
    "clientId": 0,
    "applicationId": 0,
    "quotationId": 0,
    "orderNo": "string",
    "orderDate": "2019-08-24T14:15:22Z",
    "buyerCompanyCode": "string",
    "buyerCompanyId": 0,
    "buyerCustomerCode": "string",
    "buyerCustomerId": 0,
    "payerCompanyCode": "string",
    "payerCompanyId": 0,
    "payerCustomerCode": "string",
    "payerCustomerId": 0,
    "resellerCompanyCode": "string",
    "resellerCompanyId": 0,
    "resellerCustomerCode": "string",
    "resellerCustomerId": 0,
    "groupCode": "string",
    "statusId": 0,
    "salesRepContactId": 0,
    "source": "string",
    "deliveryTerms": "string",
    "deliveryMode": "string",
    "deliveryDate": "2019-08-24T14:15:22Z",
    "isPartDelivery": true,
    "paymentTerms": "string",
    "currencyId": 0,
    "vatRate": 0,
    "cashDiscount": 0,
    "lineDiscount": 0,
    "freightCost": 0,
    "orderFee": 0,
    "deliveryAttention": "string",
    "deliveryCareOf": "string",
    "deliveryAddressLine1": "string",
    "deliveryAddressLine2": "string",
    "deliveryZipCode": "string",
    "deliveryCity": "string",
    "deliveryRegion": "string",
    "deliveryCountryId": 0,
    "ledgerAccount": "string",
    "department": "string",
    "centre": "string",
    "externalPurchaseNo": "string",
    "salesCode": "string",
    "deliveryMark": "string",
    "invoiceMark": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "payerCustomerInfoId": 0,
    "estimatedDeliveryTime": "2019-08-24T14:15:22Z",
    "deliveryTime": "2019-08-24T14:15:22Z",
    "buyerCustomerInfoId": 0,
    "shipToCustomerInfoId": 0,
    "externalRef": "string",
    "paymentMethodId": 0,
    "deliveryMethodId": 0,
    "orderTypeId": 0,
    "isForgotten": true,
    "forgottenBy": 0,
    "forgottenDate": "2019-08-24T14:15:22Z",
    "dropPointCustomerInfoId": 0,
    "dropPointCode": "string",
    "year": 0,
    "week": 0,
    "tmsReference": "string",
    "buyer": { … },
    "deliveryNote": [ … ],
    "dropPoint": { … },
    "invoice": [ … ],
    "infos": [ … ],
    "items": [ … ],
    "payer": { … },
    "quotation": { … },
    "shipTo": { … }
  },
  "infos": [
    { … }
  ]
}

DeliveryNoteItem

idinteger(int64)

The unique identifier of the delivery note item.

deliveryNoteIdinteger(int64)

The delivery note identifier.

lineNumbernumber or null(decimal)

The line number.

partNostring[ 0 .. 50 ] charactersrequired

The part number.

externalPartNostring or null[ 0 .. 50 ] characters

The external part number, not commonly used.

productNamestring or null[ 0 .. 255 ] characters

The product name.

stockUnitOfMeasurementCountnumber(decimal)

The stock unit of measurement count.

priceUnitOfMeasurementCountnumber(decimal)

The price unit of measurement count.

qtyOrderednumber(decimal)

The quantity ordered, should be same as on Sales Order, if not, that Sales Order has probably been modified in the ERP.

quantitynumber(decimal)

The quantity in the delivery.

qtyBackOrderednumber(decimal)

The quantity back ordered, goods not delivered yet on the sales order.

isPartDeliveryboolean

Indicates whether the delivery item has only partially fulfilled the order.

salesRepContactIdinteger or null(int32)

The sales rep contact identifier, not used anymore.

vatRatenumber(decimal)

The VAT rate, commonly not used, check invoice or the order.

valueMstnumber(decimal)

The value mst, not commonly used.

noteTextstring or null[ 0 .. 255 ] characters

The note text.

departmentstring or null[ 0 .. 10 ] characters

The department, not commonly used.

centrestring or null[ 0 .. 10 ] characters

The centre, not commonly used.

transIdinteger(int32)

The trans identifier, 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.

orderItemIdinteger or null(int64)

The order item identifier, link to the OrderItem.

purchaseOrderItemIdinteger or null(int64)

The purchase order item identifier, not used anymore.

lineNumberStringstring or null[ 0 .. 50 ] characters

The line number string.

clientIdinteger or null(int32)

The client identifier.

deliveryNote(DeliveryNote (object or null))

One of:

orderItem(OrderItem (object or null))

One of:

{
  "id": 0,
  "deliveryNoteId": 0,
  "lineNumber": 0,
  "partNo": "string",
  "externalPartNo": "string",
  "productName": "string",
  "stockUnitOfMeasurementCount": 0,
  "priceUnitOfMeasurementCount": 0,
  "qtyOrdered": 0,
  "quantity": 0,
  "qtyBackOrdered": 0,
  "isPartDelivery": true,
  "salesRepContactId": 0,
  "vatRate": 0,
  "valueMst": 0,
  "noteText": "string",
  "department": "string",
  "centre": "string",
  "transId": 0,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "orderItemId": 0,
  "purchaseOrderItemId": 0,
  "lineNumberString": "string",
  "clientId": 0,
  "deliveryNote": {
    "id": 0,
    "clientId": 0,
    "noteNo": "string",
    "supplierId": 0,
    "typeId": 0,
    "referenceOrderId": 0,
    "buyerCompanyId": 0,
    "buyerCompanyCode": "string",
    "buyerCustomerId": 0,
    "buyerCustomerCode": "string",
    "payerCompanyId": 0,
    "payerCompanyCode": "string",
    "payerCustomerId": 0,
    "payerCustomerCode": "string",
    "resellerCompanyId": 0,
    "resellerCompanyCode": "string",
    "resellerCustomerId": 0,
    "resellerCustomerCode": "string",
    "groupCode": "string",
    "deliveryName": "string",
    "deliveryAttention": "string",
    "deliveryCareOf": "string",
    "deliveryAddressLine1": "string",
    "deliveryAddressLine2": "string",
    "deliveryZipCode": "string",
    "deliveryCity": "string",
    "deliveryRegion": "string",
    "deliveryCountryId": 0,
    "deliveryDate": "2019-08-24T14:15:22Z",
    "quantity": 0,
    "volume": 0,
    "weight": 0,
    "isPrinted": true,
    "deliveryTerms": "string",
    "deliveryMode": "string",
    "source": "string",
    "deliveryMark": "string",
    "noteText": "string",
    "department": "string",
    "centre": "string",
    "shippingNo": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "deliveryAddressId": 0,
    "divisionCode": "string",
    "statusId": 0,
    "isForgotten": true,
    "forgottenBy": 0,
    "forgottenDate": "2019-08-24T14:15:22Z",
    "deliveryAddress": { … },
    "items": [ … ],
    "packages": [ … ],
    "referenceOrder": { … }
  },
  "orderItem": {
    "id": 0,
    "orderId": 0,
    "lineNumber": 0,
    "parentLineNumber": 0,
    "statusId": 0,
    "partNo": "string",
    "externalPartNo": "string",
    "productName": "string",
    "stockUnitOfMeasurementCount": 0,
    "priceUnitOfMeasurementCount": 0,
    "warehouseId": 0,
    "locationId": 0,
    "qtyOrdered": 0,
    "currencyId": 0,
    "vatRate": 0,
    "costUnit": 0,
    "priceSale": 0,
    "discountPercentage": 0,
    "discountAmount": 0,
    "lineAmount": 0,
    "deliveryMode": "string",
    "isPartDelivery": true,
    "expectedDeliveryDate": "2019-08-24T14:15:22Z",
    "confirmedDeliveryDate": "2019-08-24T14:15:22Z",
    "salesRepContactId": 0,
    "ledgerAccount": "string",
    "department": "string",
    "centre": "string",
    "transId": 0,
    "externalStatusText": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "lineNumberString": "string",
    "priceRecommended": 0,
    "priceCatalog": 0,
    "priceStandard": 0,
    "clientId": 0,
    "deliveryNoteItem": [ … ],
    "invoiceItem": [ … ],
    "order": { … },
    "infos": [ … ]
  }
}

OrderItemInfo

orderItemIdinteger(int64)

The order item identifier.

typeIdinteger(int32)

The info type identifier.

valuestringnon-emptyrequired

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.

clientIdinteger or null(int32)

The client identifier.

orderItem(OrderItem (object or null))

One of:

type(OrderInfoType (object or null))

One of:

{
  "orderItemId": 0,
  "typeId": 0,
  "value": "string",
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "clientId": 0,
  "orderItem": {
    "id": 0,
    "orderId": 0,
    "lineNumber": 0,
    "parentLineNumber": 0,
    "statusId": 0,
    "partNo": "string",
    "externalPartNo": "string",
    "productName": "string",
    "stockUnitOfMeasurementCount": 0,
    "priceUnitOfMeasurementCount": 0,
    "warehouseId": 0,
    "locationId": 0,
    "qtyOrdered": 0,
    "currencyId": 0,
    "vatRate": 0,
    "costUnit": 0,
    "priceSale": 0,
    "discountPercentage": 0,
    "discountAmount": 0,
    "lineAmount": 0,
    "deliveryMode": "string",
    "isPartDelivery": true,
    "expectedDeliveryDate": "2019-08-24T14:15:22Z",
    "confirmedDeliveryDate": "2019-08-24T14:15:22Z",
    "salesRepContactId": 0,
    "ledgerAccount": "string",
    "department": "string",
    "centre": "string",
    "transId": 0,
    "externalStatusText": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "lineNumberString": "string",
    "priceRecommended": 0,
    "priceCatalog": 0,
    "priceStandard": 0,
    "clientId": 0,
    "deliveryNoteItem": [ … ],
    "invoiceItem": [ … ],
    "order": { … },
    "infos": [ … ]
  },
  "type": {
    "id": 0,
    "clientId": 0,
    "applicationId": 0,
    "code": "string",
    "defaultName": "string",
    "defaultDescription": "string",
    "sortOrder": 0,
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "groupId": 0,
    "orderInfo": [ … ],
    "cultures": [ … ],
    "orderItemInfo": [ … ]
  }
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations