COMMERCE QUERY

Orders

OrderService.PurchaseOrderItem

Norce Query API Documentation (2.0)

Norce Query API is an API based on OData V4. It is an API to fill the need for data from Norce in integration services that do not have direct access to Norce’s data and data models.

Download OpenAPI description

openapi.json

openapi.yaml

Servers

https://customer-slug.api-se.norce.tech/commerce/query/2.0/

Schemas

OrderService.QuotationCustomerAddress

Idinteger(int32)

Id. Key property.

QuotationIdinteger(int32)

QuotationId.

ClientCustomerAddressIdinteger(int32)

ClientCustomerAddressId. Nullable.

ClientCompanyAddressIdinteger(int32)

ClientCompanyAddressId. Nullable.

CustomerIdinteger(int32)

CustomerId. Nullable.

CompanyIdinteger(int32)

CompanyId. Nullable.

TypeIdinteger(int32)

TypeId.

CareOfstring

CareOf. MaxLength: 100. Nullable.

AddressLine1string

AddressLine1. MaxLength: 255. Nullable.

AddressLine2string

AddressLine2. MaxLength: 255. Nullable.

ZipCodestring

ZipCode. MaxLength: 50. Nullable.

Citystring

City. MaxLength: 50. Nullable.

Regionstring

Region. MaxLength: 50. Nullable.

CountryIdinteger(int32)

CountryId. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

CompanyNamestring

CompanyName. MaxLength: 100. Nullable.

FirstNamestring

FirstName. MaxLength: 50. Nullable.

LastNamestring

LastName. MaxLength: 50. Nullable.

CellPhoneNumberstring

CellPhoneNumber. MaxLength: 50. Nullable.

Emailstring

Email. MaxLength: 255. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

ShippingPhoneNumberstring

ShippingPhoneNumber. MaxLength: 50. Nullable.

Glnstring

Gln. MaxLength: 50. Nullable.

{
  "Id": 0,
  "QuotationId": 0,
  "ClientCustomerAddressId": 0,
  "ClientCompanyAddressId": 0,
  "CustomerId": 0,
  "CompanyId": 0,
  "TypeId": 0,
  "CareOf": "string",
  "AddressLine1": "string",
  "AddressLine2": "string",
  "ZipCode": "string",
  "City": "string",
  "Region": "string",
  "CountryId": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "CompanyName": "string",
  "FirstName": "string",
  "LastName": "string",
  "CellPhoneNumber": "string",
  "Email": "string",
  "ClientId": 0,
  "ShippingPhoneNumber": "string",
  "Gln": "string"
}

OrderService.PurchaseOrderItem

Idstring

Id. Key property.

PurchaseOrderIdstring

PurchaseOrderId.

LineNumbernumber(decimal)

LineNumber. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

WarehouseIdinteger(int32)

WarehouseId. Nullable.

LocationIdinteger(int32)

LocationId. Nullable.

QtyOrderednumber(decimal)

QtyOrdered.

CurrencyIdinteger(int32)

CurrencyId. Nullable.

VatCodeIdinteger(int32)

VatCodeId. Nullable.

PriceSalenumber(decimal)

PriceSale.

LineAmountnumber(decimal)

LineAmount. Nullable.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

ConfirmedDeliveryDatestring(date-time)

ConfirmedDeliveryDate. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

SupplierLineReferencestring

SupplierLineReference. MaxLength: 50. Nullable.

OrderTransIdstring

OrderTransId. Nullable.

TransIdstring

TransId. Nullable.

Commentstring

Comment. MaxLength: 255. Nullable.

DeliveryMarkstring

DeliveryMark. MaxLength: 255. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

RowIdstring

RowId. MaxLength: 8. Nullable.

QtyOriginallyOrderednumber(decimal)

QtyOriginallyOrdered. Nullable.

QtyDeliverednumber(decimal)

QtyDelivered. Nullable.

RequestedDeliveryDatestring(date-time)

RequestedDeliveryDate. Nullable.

OrderItemIdstring

OrderItemId. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

ClientProductSkuTypeIdinteger(int32)

ClientProductSkuTypeId. Nullable.

EndUserCodestring

EndUserCode. MaxLength: 50. Nullable.

AgreementCodestring

AgreementCode. MaxLength: 50. Nullable.

InternalCommentstring

InternalComment. MaxLength: 255. Nullable.

SupplierStatusIdinteger(int32)

SupplierStatusId. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

DeliveryNoteItemArray of objects(OrderService.DeliveryNoteItem)(OrderService.DeliveryNoteItem)

DeliveryNoteItem.

{
  "Id": "string",
  "PurchaseOrderId": "string",
  "LineNumber": 0,
  "StatusId": 0,
  "PartNo": "string",
  "ExternalPartNo": "string",
  "ProductName": "string",
  "StockUnitOfMeasurementCount": 0,
  "PriceUnitOfMeasurementCount": 0,
  "WarehouseId": 0,
  "LocationId": 0,
  "QtyOrdered": 0,
  "CurrencyId": 0,
  "VatCodeId": 0,
  "PriceSale": 0,
  "LineAmount": 0,
  "DeliveryMode": "string",
  "IsPartDelivery": true,
  "ExpectedDeliveryDate": "2019-08-24T14:15:22Z",
  "ConfirmedDeliveryDate": "2019-08-24T14:15:22Z",
  "LedgerAccount": "string",
  "Department": "string",
  "Centre": "string",
  "SupplierLineReference": "string",
  "OrderTransId": "string",
  "TransId": "string",
  "Comment": "string",
  "DeliveryMark": "string",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "RowId": "string",
  "QtyOriginallyOrdered": 0,
  "QtyDelivered": 0,
  "RequestedDeliveryDate": "2019-08-24T14:15:22Z",
  "OrderItemId": "string",
  "LineNumberString": "string",
  "ClientProductSkuTypeId": 0,
  "EndUserCode": "string",
  "AgreementCode": "string",
  "InternalComment": "string",
  "SupplierStatusId": 0,
  "ClientId": 0,
  "DeliveryNoteItem": [
    { … }
  ]
}

OrderService.DeliveryNoteItem

Idstring

Id. Key property.

DeliveryNoteIdstring

DeliveryNoteId.

LineNumbernumber(decimal)

LineNumber. Nullable.

PartNostring

PartNo. MaxLength: 50. Nullable.

ExternalPartNostring

ExternalPartNo. MaxLength: 50. Nullable.

ProductNamestring

ProductName. MaxLength: 255. Nullable.

StockUnitOfMeasurementCountnumber(decimal)

StockUnitOfMeasurementCount.

PriceUnitOfMeasurementCountnumber(decimal)

PriceUnitOfMeasurementCount.

QtyOrderednumber(decimal)

QtyOrdered.

Quantitynumber(decimal)

Quantity.

QtyBackOrderednumber(decimal)

QtyBackOrdered.

IsPartDeliveryboolean

IsPartDelivery.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

VatRatenumber(decimal)

VatRate.

ValueMstnumber(decimal)

ValueMst.

NoteTextstring

NoteText. MaxLength: 255. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdinteger(int32)

TransId.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

Updatedstring(date-time)

Updated. Nullable.

UpdatedByinteger(int32)

UpdatedBy. Nullable.

OrderItemIdstring

OrderItemId. Nullable.

PurchaseOrderItemIdstring

PurchaseOrderItemId. Nullable.

LineNumberStringstring

LineNumberString. MaxLength: 50. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

PurchaseOrderItemobject(OrderService.PurchaseOrderItem)(OrderService.PurchaseOrderItem)

{
  "Id": "string",
  "DeliveryNoteId": "string",
  "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": "string",
  "PurchaseOrderItemId": "string",
  "LineNumberString": "string",
  "ClientId": 0,
  "PurchaseOrderItem": {
    "Id": "string",
    "PurchaseOrderId": "string",
    "LineNumber": 0,
    "StatusId": 0,
    "PartNo": "string",
    "ExternalPartNo": "string",
    "ProductName": "string",
    "StockUnitOfMeasurementCount": 0,
    "PriceUnitOfMeasurementCount": 0,
    "WarehouseId": 0,
    "LocationId": 0,
    "QtyOrdered": 0,
    "CurrencyId": 0,
    "VatCodeId": 0,
    "PriceSale": 0,
    "LineAmount": 0,
    "DeliveryMode": "string",
    "IsPartDelivery": true,
    "ExpectedDeliveryDate": "2019-08-24T14:15:22Z",
    "ConfirmedDeliveryDate": "2019-08-24T14:15:22Z",
    "LedgerAccount": "string",
    "Department": "string",
    "Centre": "string",
    "SupplierLineReference": "string",
    "OrderTransId": "string",
    "TransId": "string",
    "Comment": "string",
    "DeliveryMark": "string",
    "Created": "2019-08-24T14:15:22Z",
    "CreatedBy": 0,
    "Updated": "2019-08-24T14:15:22Z",
    "UpdatedBy": 0,
    "RowId": "string",
    "QtyOriginallyOrdered": 0,
    "QtyDelivered": 0,
    "RequestedDeliveryDate": "2019-08-24T14:15:22Z",
    "OrderItemId": "string",
    "LineNumberString": "string",
    "ClientProductSkuTypeId": 0,
    "EndUserCode": "string",
    "AgreementCode": "string",
    "InternalComment": "string",
    "SupplierStatusId": 0,
    "ClientId": 0,
    "DeliveryNoteItem": [ … ]
  }
}

Orders

Operations