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

      /v23.1/SaleOrderRows

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

      Get
      /v23.1/SaleOrderRows
      Security
      HTTP
      Type Bearer

      Please enter a valid token

      Query parameters
      StoreId
      integer (int32)
      SaleOrderId
      integer (int32)
      RelatedSaleOrderRowId
      integer (int32)
      ProductId
      integer (int32)
      ProductPreferredSupplierId
      integer (int32)
      Barcode
      integer (int64)
      BrandId
      integer (int32)
      MixedMatchId
      integer (int32)
      DiscountAgreementClassificationId
      integer (int32)
      QuantityPriceBreakId
      integer (int32)
      PromotionId
      integer (int32)
      OrderAtSupplierId
      integer (int32)
      VatId
      integer (int32)
      PurchaseOrderId
      integer (int32)
      PurchaseOrderRowId
      integer (int32)
      OrderedPurchaseOrderRowId
      integer (int32)
      CustomerId
      integer (int32)
      ReservationRowId
      integer (int32)
      RelatedProductsChildProductId
      integer (int32)
      SaleOrdersModifiedSinceDateTime
      string (date-time)
      RowsToReserveOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsRemainingRowsOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsDeliveredRowsOnly
      string
      Valid values[ "All", "Yes", "No" ]
      FreeStockAvailableOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsParentRowOnly
      string
      Valid values[ "All", "Yes", "No" ]
      DropshipmentRowsOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsCancelledOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsCancelledSaleOrdersOnly
      string
      Valid values[ "All", "Yes", "No" ]
      WithOpenPurchaseOrdersOnly
      string
      Valid values[ "All", "Yes", "No" ]
      SaleOrderRowId
      integer (int32)
      ConversionId
      integer (int64)
      DisplayStockSpecificStoreId
      integer (int32)
      IncludeReceivedProductFields
      boolean
      FieldsToReturn
      string
      Valid values[ "Full", "NoJoin", "ItemId" ]
      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)
      saleOrderId
      integer (int32)
      relatedSaleOrderRowId
      integer (int32)
      resendReservationRowId
      integer (int32)
      productId
      integer (int32)
      brandId
      integer (int32)
      mixedMatchId
      integer (int32)
      discountAgreementClassificationId
      integer (int32)
      quantityPriceBreakId
      integer (int32)
      promotionId
      integer (int32)
      orderAtSupplierId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      purchaseOrderRowId
      integer (int32)
      resendReasonId
      integer (int32)
      barcode
      integer (int64)
      description
      string
      amount
      number (double)
      directReservationAmount
      number (double)
      numberOfPackages
      number (double)
      qtyPerPackage
      integer (int32)
      isCancelled
      boolean
      Default"False"
      note1
      string
      note2
      string
      miscInfo
      string
      discountPrice
      number (double)
      discountPercentage
      number (double)
      discountType
      string
      Valid values[ "NotSpecified", "NoDiscount", "MixedMatchDiscount", "QuantityPriceBreakDiscount", "ManualRowPriceIncrease", "SubTotalDiscount", "PurchasePriceRaisePercentage", "ManualRowDiscount", "DiscountAgreementClassificationDiscount", "QueueBustingSale", "TransactionDiscount", "ExternalDiscount" ]
      isNoDiscounts
      boolean
      Default"False"
      isNoDiscountOnDiscount
      boolean
      Default"False"
      isSale
      boolean
      Default"False"
      isParentRow
      boolean
      Default"False"
      isDropshipment
      boolean
      Default"False"
      pcePurchasePrice
      number (double)
      basePceGrossPrice
      number (double)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      vatRequired
      boolean
      Default"False"
      totalVat
      number (double)
      loyaltyWithdrawalPrice
      number (double)
      weightedTotalNetPrice
      number (double)
      priceType
      string
      Valid values[ "NotSpecified", "PcePrice", "TotalPrice" ]
      remainingAmount
      number (double)
      deliveredAmount
      number (double)
      reservedAmount
      number (double)
      deliveryDays
      integer (int32)
      approvalNote
      string
      approvedAmount
      number (double)
      approvedDeliveryDays
      integer (int32)
      webshopRowReference
      string
      conversionId
      integer (int64)
      saleOrderNumber
      integer (int32)
      saleOrderReferenceCode
      string
      saleOrderPrintedDateTime
      string (date-time)
      saleOrderCreatedDateTime
      string (date-time)
      saleOrderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Final", "Closed" ]
      saleOrderType
      string
      Valid values[ "NotSpecified", "NormalSaleOrder", "BlanketOrder", "CreditOrder", "ResendOrder" ]
      saleOrderClassId
      integer (int32)
      saleOrderMiscInfo
      string
      saleOrderExpectedDeliveryDate
      string (date-time)
      saleOrderUtmostDeliveryDate
      string (date-time)
      saleOrderEarliestDeliveryDate
      string (date-time)
      saleOrderRequestedDeliveryDate
      string (date-time)
      saleOrderClassDescription
      string
      productDescription
      string
      customerNumber
      integer (int64)
      customerName
      string
      customerSearchText
      string
      mainBarcode
      integer (int64)
      productNumber
      integer (int64)
      productExternalCode
      string
      productInformation
      string
      plu
      integer (int32)
      productPreferredSupplierId
      integer (int32)
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      deviantInterbrancheOrdering
      boolean
      Default"False"
      brandDescription
      string
      vatDescription
      string
      vatCode
      string
      stock
      number (double)
      freeStock
      number (double)
      futureStock
      number (double)
      openSaleOrders
      number (double)
      openReservations
      number (double)
      allocatedStock
      number (double)
      orderCode
      string
      purchaseUnitCbmPerSingleUnit
      number (double)
      purchaseUnitTotalOrderedCbm
      number (double)
      calculatedPurchaseUnitConsumerUnits
      number (double)
      supplierGeneralApprovalStatus
      string
      Valid values[ "NotSpecified", "Pending", "Accepted", "Rejected" ]
      productPreferredSupplierNumber
      integer (int64)
      productPreferredSupplierName
      string
      orderAtSupplierNumber
      integer (int64)
      orderAtSupplierName
      string
      resendReasonCode
      string
      resendReasonDescription
      string
      productWeightIsoDimensionId
      integer (int32)
      productSizeIsoDimensionId
      integer (int32)
      relatedProductSetsAmount
      integer (int32)
      relatedProductPartsAmount
      integer (int32)
      receivedProductAmount
      integer (int32)
      Array of object
      object
      itemId
      integer (int32)
      createdByUserId
      integer (int32)
      createdDateTime
      string (date-time)
      lastModifiedByUserId
      integer (int32)
      lastModifiedDateTime
      string (date-time)
      companyId
      integer (int32)
      saleOrderId
      integer (int32)
      relatedSaleOrderRowId
      integer (int32)
      resendReservationRowId
      integer (int32)
      productId
      integer (int32)
      brandId
      integer (int32)
      mixedMatchId
      integer (int32)
      discountAgreementClassificationId
      integer (int32)
      quantityPriceBreakId
      integer (int32)
      promotionId
      integer (int32)
      orderAtSupplierId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      purchaseOrderRowId
      integer (int32)
      resendReasonId
      integer (int32)
      barcode
      integer (int64)
      description
      string
      amount
      number (double)
      directReservationAmount
      number (double)
      numberOfPackages
      number (double)
      qtyPerPackage
      integer (int32)
      isCancelled
      boolean
      Default"False"
      note1
      string
      note2
      string
      miscInfo
      string
      discountPrice
      number (double)
      discountPercentage
      number (double)
      discountType
      string
      Valid values[ "NotSpecified", "NoDiscount", "MixedMatchDiscount", "QuantityPriceBreakDiscount", "ManualRowPriceIncrease", "SubTotalDiscount", "PurchasePriceRaisePercentage", "ManualRowDiscount", "DiscountAgreementClassificationDiscount", "QueueBustingSale", "TransactionDiscount", "ExternalDiscount" ]
      isNoDiscounts
      boolean
      Default"False"
      isNoDiscountOnDiscount
      boolean
      Default"False"
      isSale
      boolean
      Default"False"
      isParentRow
      boolean
      Default"False"
      isDropshipment
      boolean
      Default"False"
      pcePurchasePrice
      number (double)
      basePceGrossPrice
      number (double)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      vatRequired
      boolean
      Default"False"
      totalVat
      number (double)
      loyaltyWithdrawalPrice
      number (double)
      weightedTotalNetPrice
      number (double)
      priceType
      string
      Valid values[ "NotSpecified", "PcePrice", "TotalPrice" ]
      remainingAmount
      number (double)
      deliveredAmount
      number (double)
      reservedAmount
      number (double)
      deliveryDays
      integer (int32)
      approvalNote
      string
      approvedAmount
      number (double)
      approvedDeliveryDays
      integer (int32)
      webshopRowReference
      string
      conversionId
      integer (int64)
      saleOrderNumber
      integer (int32)
      saleOrderReferenceCode
      string
      saleOrderPrintedDateTime
      string (date-time)
      saleOrderCreatedDateTime
      string (date-time)
      saleOrderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Final", "Closed" ]
      saleOrderType
      string
      Valid values[ "NotSpecified", "NormalSaleOrder", "BlanketOrder", "CreditOrder", "ResendOrder" ]
      saleOrderClassId
      integer (int32)
      saleOrderMiscInfo
      string
      saleOrderExpectedDeliveryDate
      string (date-time)
      saleOrderUtmostDeliveryDate
      string (date-time)
      saleOrderEarliestDeliveryDate
      string (date-time)
      saleOrderRequestedDeliveryDate
      string (date-time)
      saleOrderClassDescription
      string
      productDescription
      string
      customerNumber
      integer (int64)
      customerName
      string
      customerSearchText
      string
      mainBarcode
      integer (int64)
      productNumber
      integer (int64)
      productExternalCode
      string
      productInformation
      string
      plu
      integer (int32)
      productPreferredSupplierId
      integer (int32)
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      deviantInterbrancheOrdering
      boolean
      Default"False"
      brandDescription
      string
      vatDescription
      string
      vatCode
      string
      stock
      number (double)
      freeStock
      number (double)
      futureStock
      number (double)
      openSaleOrders
      number (double)
      openReservations
      number (double)
      allocatedStock
      number (double)
      orderCode
      string
      purchaseUnitCbmPerSingleUnit
      number (double)
      purchaseUnitTotalOrderedCbm
      number (double)
      calculatedPurchaseUnitConsumerUnits
      number (double)
      supplierGeneralApprovalStatus
      string
      Valid values[ "NotSpecified", "Pending", "Accepted", "Rejected" ]
      productPreferredSupplierNumber
      integer (int64)
      productPreferredSupplierName
      string
      orderAtSupplierNumber
      integer (int64)
      orderAtSupplierName
      string
      resendReasonCode
      string
      resendReasonDescription
      string
      productWeightIsoDimensionId
      integer (int32)
      productSizeIsoDimensionId
      integer (int32)
      relatedProductSetsAmount
      integer (int32)
      relatedProductPartsAmount
      integer (int32)
      receivedProductAmount
      integer (int32)
      Array of object
      object
      itemId
      integer (int32)
      createdByUserId
      integer (int32)
      createdDateTime
      string (date-time)
      lastModifiedByUserId
      integer (int32)
      lastModifiedDateTime
      string (date-time)
      companyId
      integer (int32)
      saleOrderId
      integer (int32)
      relatedSaleOrderRowId
      integer (int32)
      resendReservationRowId
      integer (int32)
      productId
      integer (int32)
      brandId
      integer (int32)
      mixedMatchId
      integer (int32)
      discountAgreementClassificationId
      integer (int32)
      quantityPriceBreakId
      integer (int32)
      promotionId
      integer (int32)
      orderAtSupplierId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      purchaseOrderRowId
      integer (int32)
      resendReasonId
      integer (int32)
      barcode
      integer (int64)
      description
      string
      amount
      number (double)
      directReservationAmount
      number (double)
      numberOfPackages
      number (double)
      qtyPerPackage
      integer (int32)
      isCancelled
      boolean
      Default"False"
      note1
      string
      note2
      string
      miscInfo
      string
      discountPrice
      number (double)
      discountPercentage
      number (double)
      discountType
      string
      Valid values[ "NotSpecified", "NoDiscount", "MixedMatchDiscount", "QuantityPriceBreakDiscount", "ManualRowPriceIncrease", "SubTotalDiscount", "PurchasePriceRaisePercentage", "ManualRowDiscount", "DiscountAgreementClassificationDiscount", "QueueBustingSale", "TransactionDiscount", "ExternalDiscount" ]
      isNoDiscounts
      boolean
      Default"False"
      isNoDiscountOnDiscount
      boolean
      Default"False"
      isSale
      boolean
      Default"False"
      isParentRow
      boolean
      Default"False"
      isDropshipment
      boolean
      Default"False"
      pcePurchasePrice
      number (double)
      basePceGrossPrice
      number (double)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      vatRequired
      boolean
      Default"False"
      totalVat
      number (double)
      loyaltyWithdrawalPrice
      number (double)
      weightedTotalNetPrice
      number (double)
      priceType
      string
      Valid values[ "NotSpecified", "PcePrice", "TotalPrice" ]
      remainingAmount
      number (double)
      deliveredAmount
      number (double)
      reservedAmount
      number (double)
      deliveryDays
      integer (int32)
      approvalNote
      string
      approvedAmount
      number (double)
      approvedDeliveryDays
      integer (int32)
      webshopRowReference
      string
      conversionId
      integer (int64)
      saleOrderNumber
      integer (int32)
      saleOrderReferenceCode
      string
      saleOrderPrintedDateTime
      string (date-time)
      saleOrderCreatedDateTime
      string (date-time)
      saleOrderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Final", "Closed" ]
      saleOrderType
      string
      Valid values[ "NotSpecified", "NormalSaleOrder", "BlanketOrder", "CreditOrder", "ResendOrder" ]
      saleOrderClassId
      integer (int32)
      saleOrderMiscInfo
      string
      saleOrderExpectedDeliveryDate
      string (date-time)
      saleOrderUtmostDeliveryDate
      string (date-time)
      saleOrderEarliestDeliveryDate
      string (date-time)
      saleOrderRequestedDeliveryDate
      string (date-time)
      saleOrderClassDescription
      string
      productDescription
      string
      customerNumber
      integer (int64)
      customerName
      string
      customerSearchText
      string
      mainBarcode
      integer (int64)
      productNumber
      integer (int64)
      productExternalCode
      string
      productInformation
      string
      plu
      integer (int32)
      productPreferredSupplierId
      integer (int32)
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      deviantInterbrancheOrdering
      boolean
      Default"False"
      brandDescription
      string
      vatDescription
      string
      vatCode
      string
      stock
      number (double)
      freeStock
      number (double)
      futureStock
      number (double)
      openSaleOrders
      number (double)
      openReservations
      number (double)
      allocatedStock
      number (double)
      orderCode
      string
      purchaseUnitCbmPerSingleUnit
      number (double)
      purchaseUnitTotalOrderedCbm
      number (double)
      calculatedPurchaseUnitConsumerUnits
      number (double)
      supplierGeneralApprovalStatus
      string
      Valid values[ "NotSpecified", "Pending", "Accepted", "Rejected" ]
      productPreferredSupplierNumber
      integer (int64)
      productPreferredSupplierName
      string
      orderAtSupplierNumber
      integer (int64)
      orderAtSupplierName
      string
      resendReasonCode
      string
      resendReasonDescription
      string
      productWeightIsoDimensionId
      integer (int32)
      productSizeIsoDimensionId
      integer (int32)
      relatedProductSetsAmount
      integer (int32)
      relatedProductPartsAmount
      integer (int32)
      receivedProductAmount
      integer (int32)
      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