COMMERCE QUERY
/
Query API 3.0
/
Schemas
/
Address

Query (v1)

Download OpenAPI description
openapi.json
openapi.yaml
Languages
Servers

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

Schemas

DeliveryNote

idinteger(int64)

The unique identifier of the delivery note.

clientIdinteger(int32)

The client identifier.

noteNostring[ 0 .. 50 ] charactersrequired

The note number from the ERP or WMS.

supplierIdinteger or null(int32)

The supplier identifier, not commonly used.

typeIdinteger(int32)

The type identifier, Order Delivery (1).

referenceOrderIdinteger(int64)

The reference order identifier, link to the Order.

buyerCompanyIdinteger or null(int32)

The buyer company identifier, not used anymore, check Order for customer information.

buyerCompanyCodestring or null[ 0 .. 50 ] characters

The buyer company code, not used anymore, check Order for customer information.

buyerCustomerIdinteger or null(int32)

The buyer customer identifier, not used anymore, check Order for customer information.

buyerCustomerCodestring or null[ 0 .. 50 ] characters

The buyer customer code, not used anymore, check Order for customer information.

payerCompanyIdinteger or null(int32)

The payer company identifier, not used anymore, check Order for customer information.

payerCompanyCodestring or null[ 0 .. 50 ] characters

The payer company code, not used anymore, check Order for customer information.

payerCustomerIdinteger or null(int32)

The payer customer identifier, not used anymore, check Order for customer information.

payerCustomerCodestring or null[ 0 .. 50 ] characters

The payer customer code, not used anymore, check Order for customer information.

resellerCompanyIdinteger or null(int32)

The reseller company identifier, not used anymore, check Order for customer information.

resellerCompanyCodestring or null[ 0 .. 50 ] characters

The reseller company code, not used anymore, check Order for customer information.

resellerCustomerIdinteger or null(int32)

The reseller customer identifier, not used anymore, check Order for customer information.

resellerCustomerCodestring or null[ 0 .. 50 ] characters

The reseller customer code, not used anymore, check Order for customer information.

groupCodestring or null[ 0 .. 50 ] characters

The group code, not used anymore.

deliveryNamestring or null[ 0 .. 100 ] characters

The delivery name, commonly the customer name.

deliveryAttentionstring or null[ 0 .. 100 ] characters

The delivery attention.

deliveryCareOfstring or null[ 0 .. 100 ] characters

The delivery care of.

deliveryAddressLine1string or null[ 0 .. 255 ] characters

The delivery address line1.

deliveryAddressLine2string or null[ 0 .. 255 ] characters

The delivery address line2.

deliveryZipCodestring or null[ 0 .. 50 ] characters

The delivery zip code.

deliveryCitystring or null[ 0 .. 50 ] characters

The delivery city.

deliveryRegionstring or null[ 0 .. 100 ] characters

The delivery region.

deliveryCountryIdinteger or null(int32)

The delivery country identifier.

deliveryDatestring or null(date-time)

The delivery date.

quantitynumber or null(decimal)

The quantity.

volumenumber or null(decimal)

The volume.

weightnumber or null(decimal)

The weight.

isPrintedboolean

Indicates whether the delivery note is printed, not used anymore.

deliveryTermsstring or null[ 0 .. 10 ] characters

The delivery terms.

deliveryModestring or null[ 0 .. 50 ] characters

The delivery mode.

sourcestring or null[ 0 .. 255 ] characters

The source.

deliveryMarkstring or null[ 0 .. 255 ] characters

The delivery mark.

noteTextstring or null[ 0 .. 255 ] characters

The note text.

departmentstring or null[ 0 .. 10 ] characters

The department.

centrestring or null[ 0 .. 10 ] characters

The centre.

shippingNostring or null[ 0 .. 50 ] characters

The shipping number.

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.

deliveryAddressIdinteger or null(int64)

The delivery address identifier.

divisionCodestring or null[ 0 .. 50 ] characters

The division code.

statusIdinteger(int32)

The status identifier, Delivered (4), Partly Delivered (8).

isForgottenboolean

Indicates whether the delivery note is forgotten.

forgottenByinteger or null(int32)

The forgotten by.

forgottenDatestring or null(date-time)

The forgotten date.

deliveryAddress(Address (object or null))
One of:
itemsArray of objects or null(DeliveryNoteItem)
packagesArray of objects or null(DeliveryNotePackage)
referenceOrder(Order (object or null))
One of:
{
  "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": {
    "id": 0,
    "typeId": 0,
    "name": "string",
    "attention": "string",
    "careOf": "string",
    "line1": "string",
    "line2": "string",
    "zipCode": "string",
    "city": "string",
    "region": "string",
    "countryId": 0,
    "emailAddress": "string",
    "phoneNumber": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "rowid": "string",
    "clientId": 0,
    "shippingPhoneNumber": "string",
    "gln": "string",
    "deliveryNote": [ … ],
    "invoice": [ … ]
  },
  "items": [
    { … }
  ],
  "packages": [
    { … }
  ],
  "referenceOrder": {
    "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": { … }
  }
}

Address

idinteger(int64)

The unique identifier of the address.

typeIdinteger or null(int32)

The type identifier.

namestring or null[ 0 .. 100 ] characters

The name of the address.

attentionstring or null[ 0 .. 100 ] characters

The attention.

careOfstring or null[ 0 .. 100 ] characters

The care of.

line1string or null[ 0 .. 255 ] characters

The first line of the address.

line2string or null[ 0 .. 255 ] characters

The second line of the address.

zipCodestring or null[ 0 .. 50 ] characters

The zip code.

citystring or null[ 0 .. 50 ] characters

The city.

regionstring or null[ 0 .. 50 ] characters

The region.

countryIdinteger or null(int32)

The country identifier.

emailAddressstring or null[ 0 .. 255 ] characters

The email address.

phoneNumberstring or null[ 0 .. 50 ] characters

The phone number.

createdstring(date-time)

The date and time the record was created.

createdByinteger(int32)

The identifier of the user who created the record.

rowidstring(byte)non-emptyrequired

The rowid, used for concurrency checks.

clientIdinteger or null(int32)

The client identifier.

shippingPhoneNumberstring or null[ 0 .. 50 ] characters

The shipping phone number.

glnstring or null[ 0 .. 50 ] characters

The GLN.

deliveryNoteArray of objects or null(DeliveryNote)
invoiceArray of objects or null(Invoice)
{
  "id": 0,
  "typeId": 0,
  "name": "string",
  "attention": "string",
  "careOf": "string",
  "line1": "string",
  "line2": "string",
  "zipCode": "string",
  "city": "string",
  "region": "string",
  "countryId": 0,
  "emailAddress": "string",
  "phoneNumber": "string",
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "rowid": "string",
  "clientId": 0,
  "shippingPhoneNumber": "string",
  "gln": "string",
  "deliveryNote": [
    { … }
  ],
  "invoice": [
    { … }
  ]
}

Invoice

idinteger(int64)

The unique identifier of the invoice.

clientIdinteger(int32)

The client identifier.

invoiceNostring[ 0 .. 50 ] charactersrequired

The invoice number, from the ERP system.

typeIdinteger(int32)

The type identifier, sales order invoice (1).

referenceOrderIdinteger(int64)

The reference order identifier, links to the Sales Order.

referenceNoPspstring or null[ 0 .. 50 ] characters

The reference number, PSP reference.

buyerCompanyIdinteger or null(int32)

The buyer company identifier.

buyerCustomerIdinteger or null(int32)

The buyer customer identifier.

payerCompanyIdinteger or null(int32)

The payer company identifier.

payerCustomerIdinteger or null(int32)

The payer customer identifier.

resellerCompanyIdinteger or null(int32)

The reseller company identifier, not commonly used.

resellerCustomerIdinteger or null(int32)

The reseller customer identifier, not commonly used.

groupCodestring or null[ 0 .. 50 ] characters

The group code, not commonly used.

deliveryDatestring or null(date-time)

The delivery date.

invoiceDatestring(date-time)

The invoice date.

invoiceDueDatestring or null(date-time)

The invoice due date.

salesRepContactIdinteger or null(int32)

The sales rep contact identifier, not used anymore.

sourcestring or null[ 0 .. 255 ] characters

The source of the order the invoice is referencing, 'WEB' is reserved for orders coming through Norce shopping and checkout processes.

quantitynumber(decimal)

The quantity, total quantity of items in the invoice.

volumenumber or null(decimal)

The volume.

weightnumber or null(decimal)

The weight.

currencyIdinteger(int32)

The currency identifier.

currencyRatenumber(decimal)

The currency rate, used for converting the invoice amount to the base currency.

cashDiscountnumber or null(decimal)

The cash discount.

cashDiscountDatestring or null(date-time)

The cash discount date.

sumLineDiscountnumber or null(decimal)

The sum line discount.

freightCostnumber or null(decimal)

The freight cost.

invoiceFeenumber or null(decimal)

The invoice fee.

costValuenumber or null(decimal)

The cost value.

salesBalancenumber or null(decimal)

The sales balance.

invoiceAmountnumber or null(decimal)

The invoice amount, total amount of the invoice, including VAT.

invoiceRoundOffnumber or null(decimal)

The invoice round off.

vatDutiable1number or null(decimal)

The first VAT dutiable amount.

vatDutiable2number or null(decimal)

The second VAT dutiable amount.

vatDutiable3number or null(decimal)

The third VAT dutiable amount.

vat1number or null(decimal)

The first VAT dutiable rate.

vat2number or null(decimal)

The second VAT dutiable rate.

vat3number or null(decimal)

The third VAT dutiable rate.

vatRoundOffnumber or null(decimal)

The vat round off.

vatnumber or null(decimal)

The VAT amount.

invoiceNamestring or null[ 0 .. 255 ] characters

The invoice name, commonly customer name.

invoiceAttentionstring or null[ 0 .. 100 ] characters

The invoice attention.

invoiceCareOfstring or null[ 0 .. 100 ] characters

The invoice care of.

invoiceAddressLine1string or null[ 0 .. 255 ] characters

The invoice address line1.

invoiceAddressLine2string or null[ 0 .. 255 ] characters

The invoice address line2.

invoiceZipCodestring or null[ 0 .. 50 ] characters

The invoice zip code.

invoiceCitystring or null[ 0 .. 50 ] characters

The invoice city.

invoiceRegionstring or null[ 0 .. 100 ] characters

The invoice region.

invoiceCountryIdinteger or null(int32)

The invoice country identifier.

ledgerVoucherstring or null[ 0 .. 50 ] characters

The ledger voucher, not used anymore.

departmentstring or null[ 0 .. 10 ] characters

The department, not commonly used.

centrestring or null[ 0 .. 10 ] characters

The centre, not commonly used.

noteTextstring or null[ 0 .. 255 ] characters

The note text.

lastInvoiceForOrderboolean or null

Indicates whether this is the last invoice for the order, and if the payment capture logic can close the transaction at the PSP.

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.

invoiceAddressIdinteger or null(int64)

The invoice address identifier.

paymentMethodIdinteger or null(int32)

The payment method identifier.

deliveryMethodIdinteger or null(int32)

The delivery method identifier.

isDebitboolean or null

Indicates whether the invoice is debit, false when the invoice is credit and should trigger a payment credit integration.

creditedInvoiceIdinteger or null(int64)

The credited invoice identifier.

commentstring or null[ 0 .. 250 ] characters

A comment or note.

isForgottenboolean

Indicates whether the invoice is forgotten, not commonly used.

forgottenByinteger or null(int32)

The forgotten by, not commonly used.

forgottenDatestring or null(date-time)

The forgotten date, not commonly used.

aggregatedInvoiceCodestring or null[ 0 .. 100 ] characters

The aggregated invoice code, grouping multiple invoices together.

paymentMethodCodestring or null[ 0 .. 50 ] characters

The payment method code.

paymentMethodNamestring or null[ 0 .. 50 ] characters

The payment method name.

invoiceGlnstring or null[ 0 .. 50 ] characters

The invoice GLN.

creditedInvoiceInvoice (object)
One of:
object Invoice Recursive
inverseCreditedInvoiceArray of objects or null(Invoice)
address(Address (object or null))
One of:
itemsArray of objects or null(InvoiceItem)
referenceOrder(Order (object or null))
One of:
{
  "id": 0,
  "clientId": 0,
  "invoiceNo": "string",
  "typeId": 0,
  "referenceOrderId": 0,
  "referenceNoPsp": "string",
  "buyerCompanyId": 0,
  "buyerCustomerId": 0,
  "payerCompanyId": 0,
  "payerCustomerId": 0,
  "resellerCompanyId": 0,
  "resellerCustomerId": 0,
  "groupCode": "string",
  "deliveryDate": "2019-08-24T14:15:22Z",
  "invoiceDate": "2019-08-24T14:15:22Z",
  "invoiceDueDate": "2019-08-24T14:15:22Z",
  "salesRepContactId": 0,
  "source": "string",
  "quantity": 0,
  "volume": 0,
  "weight": 0,
  "currencyId": 0,
  "currencyRate": 0,
  "cashDiscount": 0,
  "cashDiscountDate": "2019-08-24T14:15:22Z",
  "sumLineDiscount": 0,
  "freightCost": 0,
  "invoiceFee": 0,
  "costValue": 0,
  "salesBalance": 0,
  "invoiceAmount": 0,
  "invoiceRoundOff": 0,
  "vatDutiable1": 0,
  "vatDutiable2": 0,
  "vatDutiable3": 0,
  "vat1": 0,
  "vat2": 0,
  "vat3": 0,
  "vatRoundOff": 0,
  "vat": 0,
  "invoiceName": "string",
  "invoiceAttention": "string",
  "invoiceCareOf": "string",
  "invoiceAddressLine1": "string",
  "invoiceAddressLine2": "string",
  "invoiceZipCode": "string",
  "invoiceCity": "string",
  "invoiceRegion": "string",
  "invoiceCountryId": 0,
  "ledgerVoucher": "string",
  "department": "string",
  "centre": "string",
  "noteText": "string",
  "lastInvoiceForOrder": true,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "invoiceAddressId": 0,
  "paymentMethodId": 0,
  "deliveryMethodId": 0,
  "isDebit": true,
  "creditedInvoiceId": 0,
  "comment": "string",
  "isForgotten": true,
  "forgottenBy": 0,
  "forgottenDate": "2019-08-24T14:15:22Z",
  "aggregatedInvoiceCode": "string",
  "paymentMethodCode": "string",
  "paymentMethodName": "string",
  "invoiceGln": "string",
  "creditedInvoice": {},
  "inverseCreditedInvoice": [
    {}
  ],
  "address": {
    "id": 0,
    "typeId": 0,
    "name": "string",
    "attention": "string",
    "careOf": "string",
    "line1": "string",
    "line2": "string",
    "zipCode": "string",
    "city": "string",
    "region": "string",
    "countryId": 0,
    "emailAddress": "string",
    "phoneNumber": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "rowid": "string",
    "clientId": 0,
    "shippingPhoneNumber": "string",
    "gln": "string",
    "deliveryNote": [ … ],
    "invoice": [ … ]
  },
  "items": [
    { … }
  ],
  "referenceOrder": {
    "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": { … }
  }
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations