Login
      Contents x
      /v23.1/ReservationRows
      • 05 Jun 2024
      • 4 Minutes to read
      • Contributors
      • Print
      • Dark
        Light
      • PDF
      Contents

      /v23.1/ReservationRows

      • Updated on 05 Jun 2024
      • 4 Minutes to read
      • Contributors
      • Print
      • Dark
        Light
      • PDF
      Article summary

      Get
      /v23.1/ReservationRows
      Security
      HTTP
      Type Bearer

      Please enter a valid token

      Query parameters
      StoreId
      integer (int32)
      ReservationId
      integer (int32)
      SaleOrderRowId
      integer (int32)
      TaskId
      integer (int32)
      Source
      string
      Valid values[ "NotSpecified", "ReceivedProducts" ]
      LogisticsStatus
      array of string
      ReceivedProductId
      integer (int32)
      SaleOrderId
      integer (int32)
      CustomerId
      integer (int32)
      ProductId
      integer (int32)
      TransportTypeId
      integer (int32)
      IsNoHeaderOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsDeliveredRowsOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsCancelledReservationsOnly
      string
      Valid values[ "All", "Yes", "No" ]
      OpenSaleOrdersOnly
      string
      Valid values[ "All", "Yes", "No" ]
      ExactOrderPickingOnly
      string
      Valid values[ "All", "Yes", "No" ]
      SourceSpecified
      string
      Valid values[ "All", "Yes", "No" ]
      ExcludeFromPickingOnly
      string
      Valid values[ "All", "Yes", "No" ]
      OpenReservationsOnly
      string
      Valid values[ "All", "Yes", "No" ]
      ReadyForGuidedPickingOnly
      string
      Valid values[ "All", "Yes", "No" ]
      OrderPickingCarrierId
      integer (int32)
      TrackTraceCode
      string
      ConversionId
      integer (int64)
      FieldsToReturn
      string
      Valid values[ "Full", "NoJoin", "ItemId" ]
      Offset
      integer (int32)
      RecordCount
      integer (int32)
      ItemId
      integer (int32)
      IncludeItemId
      integer (int32)
      ExcludeItemId
      integer (int32)
      ModifiedSinceDateTime
      string (date-time)
      Responses
      200

      Success

      Array of object
      object
      itemId
      integer (int32)
      createdByUserId
      integer (int32)
      createdDateTime
      string (date-time)
      lastModifiedByUserId
      integer (int32)
      lastModifiedDateTime
      string (date-time)
      companyId
      integer (int32)
      reservationId
      integer (int32)
      saleOrderRowId
      integer (int32)
      taskId
      integer (int32)
      source
      string
      Valid values[ "NotSpecified", "ReceivedProducts" ]
      receivedProductId
      integer (int32)
      amount
      number (double)
      discountPrice
      number (double)
      discountPercentage
      number (double)
      discountType
      string
      Valid values[ "NotSpecified", "NoDiscount", "MixedMatchDiscount", "QuantityPriceBreakDiscount", "ManualRowPriceIncrease", "SubTotalDiscount", "PurchasePriceRaisePercentage", "ManualRowDiscount", "DiscountAgreementClassificationDiscount", "QueueBustingSale", "TransactionDiscount", "ExternalDiscount" ]
      mixedMatchId
      integer (int32)
      discountAgreementClassificationId
      integer (int32)
      quantityPriceBreakId
      integer (int32)
      promotionId
      integer (int32)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      totalVat
      number (double)
      priceType
      string
      Valid values[ "NotSpecified", "PcePrice", "TotalPrice" ]
      reservationDateTime
      string (date-time)
      trackTraceCode
      string
      returnedAmount
      number (double)
      pickedAmount
      number (double)
      checkedAmount
      number (double)
      excludeFromPicking
      boolean
      Default"False"
      conversionId
      integer (int64)
      storeId
      integer (int32)
      reservationStatus
      string
      Valid values[ "NotSpecified", "Open", "Printed", "ClosedByCashSale", "ClosedByInvoiceSale", "OrderPickingComplete", "OrderPickingInProgress", "OrderPickingVerified" ]
      reservationNumber
      integer (int32)
      plannedDeliveryDate
      string (date-time)
      saleOrderTransportTypeId
      integer (int32)
      saleOrderCustomerId
      integer (int32)
      customerDebtorId
      integer (int32)
      saleOrderDebtorId
      integer (int32)
      saleOrderNumber
      integer (int32)
      saleOrderId
      integer (int32)
      saleOrderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Final", "Closed" ]
      saleOrderType
      string
      Valid values[ "NotSpecified", "NormalSaleOrder", "BlanketOrder", "CreditOrder", "ResendOrder" ]
      saleOrderClassId
      integer (int32)
      saleOrderExpectedDeliveryDate
      string (date-time)
      saleOrderUtmostDeliveryDate
      string (date-time)
      saleOrderReferenceCode
      string
      saleOrderClassDescription
      string
      saleOrderConceptOrderModus
      string
      Valid values[ "NotSpecified", "None", "NotRequired", "Required" ]
      orderPickPrintWhenDeliveryPlanned
      boolean
      Default"False"
      orderPickPrintWaitDaysBeforeDelivery
      integer (int32)
      pcePurchasePrice
      number (double)
      saleOrderAmount
      number (double)
      productId
      integer (int32)
      saleOrderParentRow
      boolean
      Default"False"
      webshopRowReference
      string
      costCenterId
      integer (int32)
      freeStock
      number (double)
      productNumber
      integer (int64)
      productDescription
      string
      locationClassId
      integer (int32)
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      productExternalCode
      string
      mainBarcode
      integer (int64)
      relatedProductsType
      string
      Valid values[ "NoRelatedProducts", "SaleOnRelatedProducts", "AddRelatedProducts", "ArticleComposition" ]
      productCategoryPickupLocationId
      integer (int32)
      productCategoryDepartmentId
      integer (int32)
      cashRegisterGroupId
      integer (int32)
      digitalGiftCard
      boolean
      Default"False"
      giftCardTypeId
      integer (int32)
      customerNumber
      integer (int64)
      customerName
      string
      isMaintainStock
      boolean
      Default"False"
      defaultStoreLocationId
      integer (int32)
      storeProductPickupLocationId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      storeLocation
      string
      warehouseLocation
      string
      Array of object
      object
      itemId
      integer (int32)
      createdByUserId
      integer (int32)
      createdDateTime
      string (date-time)
      lastModifiedByUserId
      integer (int32)
      lastModifiedDateTime
      string (date-time)
      companyId
      integer (int32)
      reservationId
      integer (int32)
      saleOrderRowId
      integer (int32)
      taskId
      integer (int32)
      source
      string
      Valid values[ "NotSpecified", "ReceivedProducts" ]
      receivedProductId
      integer (int32)
      amount
      number (double)
      discountPrice
      number (double)
      discountPercentage
      number (double)
      discountType
      string
      Valid values[ "NotSpecified", "NoDiscount", "MixedMatchDiscount", "QuantityPriceBreakDiscount", "ManualRowPriceIncrease", "SubTotalDiscount", "PurchasePriceRaisePercentage", "ManualRowDiscount", "DiscountAgreementClassificationDiscount", "QueueBustingSale", "TransactionDiscount", "ExternalDiscount" ]
      mixedMatchId
      integer (int32)
      discountAgreementClassificationId
      integer (int32)
      quantityPriceBreakId
      integer (int32)
      promotionId
      integer (int32)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      totalVat
      number (double)
      priceType
      string
      Valid values[ "NotSpecified", "PcePrice", "TotalPrice" ]
      reservationDateTime
      string (date-time)
      trackTraceCode
      string
      returnedAmount
      number (double)
      pickedAmount
      number (double)
      checkedAmount
      number (double)
      excludeFromPicking
      boolean
      Default"False"
      conversionId
      integer (int64)
      storeId
      integer (int32)
      reservationStatus
      string
      Valid values[ "NotSpecified", "Open", "Printed", "ClosedByCashSale", "ClosedByInvoiceSale", "OrderPickingComplete", "OrderPickingInProgress", "OrderPickingVerified" ]
      reservationNumber
      integer (int32)
      plannedDeliveryDate
      string (date-time)
      saleOrderTransportTypeId
      integer (int32)
      saleOrderCustomerId
      integer (int32)
      customerDebtorId
      integer (int32)
      saleOrderDebtorId
      integer (int32)
      saleOrderNumber
      integer (int32)
      saleOrderId
      integer (int32)
      saleOrderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Final", "Closed" ]
      saleOrderType
      string
      Valid values[ "NotSpecified", "NormalSaleOrder", "BlanketOrder", "CreditOrder", "ResendOrder" ]
      saleOrderClassId
      integer (int32)
      saleOrderExpectedDeliveryDate
      string (date-time)
      saleOrderUtmostDeliveryDate
      string (date-time)
      saleOrderReferenceCode
      string
      saleOrderClassDescription
      string
      saleOrderConceptOrderModus
      string
      Valid values[ "NotSpecified", "None", "NotRequired", "Required" ]
      orderPickPrintWhenDeliveryPlanned
      boolean
      Default"False"
      orderPickPrintWaitDaysBeforeDelivery
      integer (int32)
      pcePurchasePrice
      number (double)
      saleOrderAmount
      number (double)
      productId
      integer (int32)
      saleOrderParentRow
      boolean
      Default"False"
      webshopRowReference
      string
      costCenterId
      integer (int32)
      freeStock
      number (double)
      productNumber
      integer (int64)
      productDescription
      string
      locationClassId
      integer (int32)
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      productExternalCode
      string
      mainBarcode
      integer (int64)
      relatedProductsType
      string
      Valid values[ "NoRelatedProducts", "SaleOnRelatedProducts", "AddRelatedProducts", "ArticleComposition" ]
      productCategoryPickupLocationId
      integer (int32)
      productCategoryDepartmentId
      integer (int32)
      cashRegisterGroupId
      integer (int32)
      digitalGiftCard
      boolean
      Default"False"
      giftCardTypeId
      integer (int32)
      customerNumber
      integer (int64)
      customerName
      string
      isMaintainStock
      boolean
      Default"False"
      defaultStoreLocationId
      integer (int32)
      storeProductPickupLocationId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      storeLocation
      string
      warehouseLocation
      string
      Array of object
      object
      itemId
      integer (int32)
      createdByUserId
      integer (int32)
      createdDateTime
      string (date-time)
      lastModifiedByUserId
      integer (int32)
      lastModifiedDateTime
      string (date-time)
      companyId
      integer (int32)
      reservationId
      integer (int32)
      saleOrderRowId
      integer (int32)
      taskId
      integer (int32)
      source
      string
      Valid values[ "NotSpecified", "ReceivedProducts" ]
      receivedProductId
      integer (int32)
      amount
      number (double)
      discountPrice
      number (double)
      discountPercentage
      number (double)
      discountType
      string
      Valid values[ "NotSpecified", "NoDiscount", "MixedMatchDiscount", "QuantityPriceBreakDiscount", "ManualRowPriceIncrease", "SubTotalDiscount", "PurchasePriceRaisePercentage", "ManualRowDiscount", "DiscountAgreementClassificationDiscount", "QueueBustingSale", "TransactionDiscount", "ExternalDiscount" ]
      mixedMatchId
      integer (int32)
      discountAgreementClassificationId
      integer (int32)
      quantityPriceBreakId
      integer (int32)
      promotionId
      integer (int32)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      totalVat
      number (double)
      priceType
      string
      Valid values[ "NotSpecified", "PcePrice", "TotalPrice" ]
      reservationDateTime
      string (date-time)
      trackTraceCode
      string
      returnedAmount
      number (double)
      pickedAmount
      number (double)
      checkedAmount
      number (double)
      excludeFromPicking
      boolean
      Default"False"
      conversionId
      integer (int64)
      storeId
      integer (int32)
      reservationStatus
      string
      Valid values[ "NotSpecified", "Open", "Printed", "ClosedByCashSale", "ClosedByInvoiceSale", "OrderPickingComplete", "OrderPickingInProgress", "OrderPickingVerified" ]
      reservationNumber
      integer (int32)
      plannedDeliveryDate
      string (date-time)
      saleOrderTransportTypeId
      integer (int32)
      saleOrderCustomerId
      integer (int32)
      customerDebtorId
      integer (int32)
      saleOrderDebtorId
      integer (int32)
      saleOrderNumber
      integer (int32)
      saleOrderId
      integer (int32)
      saleOrderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Final", "Closed" ]
      saleOrderType
      string
      Valid values[ "NotSpecified", "NormalSaleOrder", "BlanketOrder", "CreditOrder", "ResendOrder" ]
      saleOrderClassId
      integer (int32)
      saleOrderExpectedDeliveryDate
      string (date-time)
      saleOrderUtmostDeliveryDate
      string (date-time)
      saleOrderReferenceCode
      string
      saleOrderClassDescription
      string
      saleOrderConceptOrderModus
      string
      Valid values[ "NotSpecified", "None", "NotRequired", "Required" ]
      orderPickPrintWhenDeliveryPlanned
      boolean
      Default"False"
      orderPickPrintWaitDaysBeforeDelivery
      integer (int32)
      pcePurchasePrice
      number (double)
      saleOrderAmount
      number (double)
      productId
      integer (int32)
      saleOrderParentRow
      boolean
      Default"False"
      webshopRowReference
      string
      costCenterId
      integer (int32)
      freeStock
      number (double)
      productNumber
      integer (int64)
      productDescription
      string
      locationClassId
      integer (int32)
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      productExternalCode
      string
      mainBarcode
      integer (int64)
      relatedProductsType
      string
      Valid values[ "NoRelatedProducts", "SaleOnRelatedProducts", "AddRelatedProducts", "ArticleComposition" ]
      productCategoryPickupLocationId
      integer (int32)
      productCategoryDepartmentId
      integer (int32)
      cashRegisterGroupId
      integer (int32)
      digitalGiftCard
      boolean
      Default"False"
      giftCardTypeId
      integer (int32)
      customerNumber
      integer (int64)
      customerName
      string
      isMaintainStock
      boolean
      Default"False"
      defaultStoreLocationId
      integer (int32)
      storeProductPickupLocationId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      storeLocation
      string
      warehouseLocation
      string
      401

      Unauthorized

      object
      type
      string
      message
      string
      stackTrace
      string
      object
      type
      string
      message
      string
      stackTrace
      string
      object
      type
      string
      message
      string
      stackTrace
      string
      403

      Forbidden

      object
      type
      string
      message
      string
      stackTrace
      string
      object
      type
      string
      message
      string
      stackTrace
      string
      object
      type
      string
      message
      string
      stackTrace
      string
      404

      Not Found

      object
      type
      string
      message
      string
      stackTrace
      string
      object
      type
      string
      message
      string
      stackTrace
      string
      object
      type
      string
      message
      string
      stackTrace
      string
      Was this article helpful?
      What's Next
      Change password!
      Changing your password will log you out immediately. Use the new password to log back in.
      Change profile
      Success!
      First name must have atleast 2 characters. Numbers and special characters are not allowed.
      Last name must have atleast 1 characters. Numbers and special characters are not allowed.
      Enter a valid email
      Enter a valid password
      Your profile has been successfully updated.
      Logout