Skip to content
COMMERCE QUERY
/
Orders
/
/
OrderService.InvoiceItem

Storm Query API Documentation (2.0)

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

Download OpenAPI description
openapi.json
openapi.yaml
Languages
Servers
https://customer-slug.api-se.norce.tech/commerce/query/2.0/

Schemas

Schemas

Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransaction

TransactionNostring

TransactionNo. MaxLength: 50. Nullable.

Idstring

Id. Key property.

TransactionDatestring(date-time)

TransactionDate.

WarehouseCodestring

WarehouseCode. MaxLength: 50. Nullable.

LocationCodestring

LocationCode. MaxLength: 50. Nullable.

Typestring

Type. MaxLength: 50. Nullable.

OrderNostring

OrderNo. MaxLength: 50. Nullable.

PurchaseOrderNostring

PurchaseOrderNo. MaxLength: 50. Nullable.

DeliveryNoteNostring

DeliveryNoteNo. MaxLength: 50. Nullable.

ExternalReferencestring

ExternalReference. MaxLength: 50. Nullable.

ReasonCodestring

ReasonCode. MaxLength: 50. Nullable.

Commentstring

Comment. MaxLength: 500. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy.

ItemsArray of objects(Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem)(Enferno.Storm.Query.Api.DataContexts.OrderModel.WarehouseTransactionItem)

Items.

{
  "TransactionNo": "string",
  "Id": "string",
  "TransactionDate": "2019-08-24T14:15:22Z",
  "WarehouseCode": "string",
  "LocationCode": "string",
  "Type": "string",
  "OrderNo": "string",
  "PurchaseOrderNo": "string",
  "DeliveryNoteNo": "string",
  "ExternalReference": "string",
  "ReasonCode": "string",
  "Comment": "string",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Items": [
    { … }
  ]
}

OrderService.InvoiceItem

Idstring

Id. Key property.

InvoiceIdstring

InvoiceId.

LineNumbernumber(decimal)

LineNumber. Nullable.

StatusIdinteger(int32)

StatusId. Nullable.

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.

Quantityinteger(int32)

Quantity.

CurrencyIdinteger(int32)

CurrencyId.

VatRatenumber(decimal)

VatRate.

CostUnitnumber(decimal)

CostUnit.

PriceSalenumber(decimal)

PriceSale.

DiscountPercentagenumber(decimal)

DiscountPercentage.

DiscountAmountnumber(decimal)

DiscountAmount.

LineAmountnumber(decimal)

LineAmount.

DeliveryModestring

DeliveryMode. MaxLength: 50. Nullable.

IsPartDeliveryboolean

IsPartDelivery.

DeliveryDatestring(date-time)

DeliveryDate. Nullable.

SalesRepContactIdinteger(int32)

SalesRepContactId. Nullable.

LedgerAccountstring

LedgerAccount. MaxLength: 50. Nullable.

Departmentstring

Department. MaxLength: 10. Nullable.

Centrestring

Centre. MaxLength: 10. Nullable.

TransIdstring

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.

PriceUnitnumber(decimal)

PriceUnit. Nullable.

Quantity2number(decimal)

Quantity2. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

OrderItemobject(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)(Enferno.Storm.Query.Api.DataContexts.OrderModel.OrderItem)
{
  "Id": "string",
  "InvoiceId": "string",
  "LineNumber": 0,
  "StatusId": 0,
  "PartNo": "string",
  "ExternalPartNo": "string",
  "ProductName": "string",
  "StockUnitOfMeasurementCount": 0,
  "PriceUnitOfMeasurementCount": 0,
  "WarehouseId": 0,
  "LocationId": 0,
  "Quantity": 0,
  "CurrencyId": 0,
  "VatRate": 0,
  "CostUnit": 0,
  "PriceSale": 0,
  "DiscountPercentage": 0,
  "DiscountAmount": 0,
  "LineAmount": 0,
  "DeliveryMode": "string",
  "IsPartDelivery": true,
  "DeliveryDate": "2019-08-24T14:15:22Z",
  "SalesRepContactId": 0,
  "LedgerAccount": "string",
  "Department": "string",
  "Centre": "string",
  "TransId": "string",
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "UpdatedBy": 0,
  "OrderItemId": "string",
  "PurchaseOrderItemId": "string",
  "LineNumberString": "string",
  "PriceUnit": 0,
  "Quantity2": 0,
  "ClientId": 0,
  "OrderItem": {
    "Id": "string",
    "OrderId": "string",
    "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": "string",
    "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,
    "InvoiceItem": [ … ],
    "Infos": [ … ]
  }
}

OrderService.QuotationItem

Idinteger(int32)

Id. Key property.

QuotationIdinteger(int32)

QuotationId.

LineNumberinteger(int32)

LineNumber.

CustomerLineCodestring

CustomerLineCode. MaxLength: 50. Nullable.

StatusIdinteger(int32)

StatusId.

PartNostring

PartNo. MaxLength: 50. Nullable.

ProductNameWhenCreatedstring

ProductNameWhenCreated. MaxLength: 255. Nullable.

BundlePartnostring

BundlePartno. MaxLength: 50. Nullable.

BundleTypeIdinteger(int32)

BundleTypeId. Nullable.

Qtyinteger(int32)

Qty.

OnHandWhenCreatedinteger(int32)

OnHandWhenCreated. Nullable.

PriceSalenumber(decimal)

PriceSale. Nullable.

PriceSaleWhenCreatednumber(decimal)

PriceSaleWhenCreated. Nullable.

PriceListIdinteger(int32)

PriceListId.

PatternIdinteger(int32)

PatternId. Nullable.

VatCodeinteger(int32)

VatCode. Nullable.

VatValuenumber(decimal)

VatValue. Nullable.

PromotionIdSeedstring

PromotionIdSeed. MaxLength: 50. Nullable.

CampaignIdinteger(int32)

CampaignId. Nullable.

SearchStringstring

SearchString. MaxLength: 50. Nullable.

CategoryItemIdinteger(int32)

CategoryItemId. Nullable.

ParentPartnoIdstring

ParentPartnoId. MaxLength: 50. Nullable.

ParentLineNumberinteger(int32)

ParentLineNumber. Nullable.

Commentstring

Comment. MaxLength: 255. Nullable.

ExternalDatastring

ExternalData. Nullable.

RefererIdinteger(int32)

RefererId. Nullable.

RefererUrlstring

RefererUrl. MaxLength: 255. Nullable.

PriceResellernumber(decimal)

PriceReseller. Nullable.

IsLockedboolean

IsLocked. Nullable.

TotalPriceSaleExVatnumber(decimal)

TotalPriceSaleExVat. Nullable.

TotalPriceSaleIncVatnumber(decimal)

TotalPriceSaleIncVat. Nullable.

Createdstring(date-time)

Created.

CreatedByinteger(int32)

CreatedBy. Nullable.

Updatedstring(date-time)

Updated. Nullable.

ExpectedDeliveryDatestring(date-time)

ExpectedDeliveryDate. Nullable.

RequirementPromotionIdSeedstring

RequirementPromotionIdSeed. MaxLength: 255. Nullable.

IsPriceManualboolean

IsPriceManual. Nullable.

Qty2number(decimal)

Qty2. Nullable.

ClientIdinteger(int32)

ClientId. Nullable.

InfosArray of objects(OrderService.QuotationItemInfo)(OrderService.QuotationItemInfo)

Infos.

{
  "Id": 0,
  "QuotationId": 0,
  "LineNumber": 0,
  "CustomerLineCode": "string",
  "StatusId": 0,
  "PartNo": "string",
  "ProductNameWhenCreated": "string",
  "BundlePartno": "string",
  "BundleTypeId": 0,
  "Qty": 0,
  "OnHandWhenCreated": 0,
  "PriceSale": 0,
  "PriceSaleWhenCreated": 0,
  "PriceListId": 0,
  "PatternId": 0,
  "VatCode": 0,
  "VatValue": 0,
  "PromotionIdSeed": "string",
  "CampaignId": 0,
  "SearchString": "string",
  "CategoryItemId": 0,
  "ParentPartnoId": "string",
  "ParentLineNumber": 0,
  "Comment": "string",
  "ExternalData": "string",
  "RefererId": 0,
  "RefererUrl": "string",
  "PriceReseller": 0,
  "IsLocked": true,
  "TotalPriceSaleExVat": 0,
  "TotalPriceSaleIncVat": 0,
  "Created": "2019-08-24T14:15:22Z",
  "CreatedBy": 0,
  "Updated": "2019-08-24T14:15:22Z",
  "ExpectedDeliveryDate": "2019-08-24T14:15:22Z",
  "RequirementPromotionIdSeed": "string",
  "IsPriceManual": true,
  "Qty2": 0,
  "ClientId": 0,
  "Infos": [
    { … }
  ]
}

Orders

Operations