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

      /v23.1/PurchaseOrderRows

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

      Get
      /v23.1/PurchaseOrderRows
      Security
      HTTP
      Type Bearer

      Please enter a valid token

      Query parameters
      StoreId
      integer (int32)
      PurchaseOrderId
      integer (int32)
      ProductId
      integer (int32)
      SupplierId
      integer (int32)
      AutoFillOrdersOnly
      string
      Valid values[ "All", "Yes", "No" ]
      DisplayOpenRowsOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsDisplayStatusNew
      string
      Valid values[ "All", "Yes", "No" ]
      IsFinalOnly
      string
      Valid values[ "All", "Yes", "No" ]
      IsConfirmedOnly
      string
      Valid values[ "All", "Yes", "No" ]
      DeliveryAmount
      string
      Valid values[ "NotSpecified", "OnlyLessThanOrdered", "OnlyMoreThanOrdered", "LessOrMoreThanOrdered" ]
      CreatedDateFrom
      string (date-time)
      CreatedDateTo
      string (date-time)
      ConfirmationStatus
      string
      Valid values[ "NotSpecified", "Changes", "Pending", "NotAccepted", "Accepted" ]
      PeriodDays
      integer (int32)
      RowsEqualAcceptedOnly
      string
      Valid values[ "All", "Yes", "No" ]
      RowsWithConfirmationFreeInfoOnly
      string
      Valid values[ "All", "Yes", "No" ]
      PurchaseOrderModifiedSinceDateTime
      string (date-time)
      OrderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Approved", "Final", "Closed" ]
      SaleOrderRowId
      integer (int32)
      ReceivedPoductsHeaderId
      integer (int32)
      IncludeCalculatedFields
      boolean
      ConversionId
      integer (int64)
      DisplayStockSpecificStoreId
      integer (int32)
      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)
      purchaseOrderId
      integer (int32)
      productId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      brandId
      integer (int32)
      orderCode
      string
      consumerBarcode
      integer (int64)
      purchaseUnitBarcode
      integer (int64)
      originalRequestedSaleConsumerUnits
      number (double)
      requestedSaleConsumerUnits
      number (double)
      purchaseUnitAmount
      number (double)
      purchaseUnitDimensionId
      integer (int32)
      purchaseUnitPackageId
      integer (int32)
      purchaseContentUnitDimensionId
      integer (int32)
      purchaseContentUnitPackageId
      integer (int32)
      orderMultiplier
      number (double)
      minimumOrderQuantity
      number (double)
      purchasePriceType
      string
      Valid values[ "NotSpecified", "PurchaseUnit", "PurchaseContentUnit", "ConsumerUnit" ]
      purchaseUnitToPurchaseContentUnitFactor
      number (double)
      purchaseContentUnitToConsumerUnitFactor
      number (double)
      cbmPerSingleUnit
      number (double)
      purchasePricePerAmount
      number (double)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      weightedTotalNetPrice
      number (double)
      orderDiscountPercentage
      number (double)
      discountPrice
      number (double)
      isNetPrice
      boolean
      Default"False"
      expectedDeliveryDate
      string (date-time)
      note
      string
      miscInfo
      string
      confirmationStatus
      string
      Valid values[ "NotSpecified", "Changes", "Pending", "NotAccepted", "Accepted" ]
      confirmationAmount
      number (double)
      confirmationAmountMeasureUnit
      string
      confirmationFreeInfo
      string
      isCancelled
      boolean
      Default"False"
      calculatedConsumerUnits
      number (double)
      assignedBlanketConsumerUnits
      number (double)
      expectedDeliveryDays
      integer (int32)
      conversionId
      integer (int64)
      productDescription
      string
      note1
      string
      note2
      string
      note3
      string
      note4
      string
      alternateDescription
      string
      mainBarcode
      integer (int64)
      salePrice
      number (double)
      productNumber
      integer (int64)
      productExternalCode
      string
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      productInformation
      string
      vatDescription
      string
      brandDescription
      string
      subBrandDescription
      string
      colorExternalCode
      string
      purchaseUnitDimensionShortDescription
      string
      purchaseUnitPackageShortDescription
      string
      purchaseContentUnitDimensionShortDescription
      string
      purchaseContentUnitPackageShortDescription
      string
      purchaseInfoDescription
      string
      purchaseOrderNumber
      integer (int32)
      orderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Approved", "Final", "Closed" ]
      purchaseOrderReference
      string
      purchaseOrderExpectedDeliveryDate
      string (date-time)
      orderSentDate
      string (date-time)
      supplierDescription
      string
      supplierNumber
      integer (int64)
      purchaseOrderSupplierDescription
      string
      createdByUser
      string
      isProductCancelled
      boolean
      Default"False"
      openSaleOrders
      number (double)
      openReservations
      number (double)
      allocatedStock
      number (double)
      stock
      number (double)
      freeStock
      number (double)
      futureStock
      number (double)
      minimumStock
      number (double)
      maximumStock
      number (double)
      orderMethod
      string
      Valid values[ "NotSpecified", "ByStock", "ByPeriodSale", "NoAutoOrder" ]
      calculatedMinStock
      number (double)
      calculatedMaxStock
      number (double)
      manualMinMaxStock
      boolean
      Default"False"
      limitCalculatedMinStock
      number (double)
      limitCalculatedMaxStock
      number (double)
      purchaseStatusCode
      string
      purchaseStatusDescription
      string
      hasAlternativesAtCurrentSupplier
      boolean
      Default"False"
      hasAlternativesAtOtherSupplier
      boolean
      Default"False"
      highestInterbrancheFreeStock
      number (double)
      totalStock
      integer (int32)
      hasAlternativesAtCurrentAndOtherSupplier
      boolean
      Default"False"
      totalUnitsReceived
      number (double)
      saleOrdersOrderedQty
      number (double)
      reservationsQty
      number (double)
      Array of object
      object
      itemId
      integer (int32)
      createdByUserId
      integer (int32)
      createdDateTime
      string (date-time)
      lastModifiedByUserId
      integer (int32)
      lastModifiedDateTime
      string (date-time)
      companyId
      integer (int32)
      purchaseOrderId
      integer (int32)
      productId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      brandId
      integer (int32)
      orderCode
      string
      consumerBarcode
      integer (int64)
      purchaseUnitBarcode
      integer (int64)
      originalRequestedSaleConsumerUnits
      number (double)
      requestedSaleConsumerUnits
      number (double)
      purchaseUnitAmount
      number (double)
      purchaseUnitDimensionId
      integer (int32)
      purchaseUnitPackageId
      integer (int32)
      purchaseContentUnitDimensionId
      integer (int32)
      purchaseContentUnitPackageId
      integer (int32)
      orderMultiplier
      number (double)
      minimumOrderQuantity
      number (double)
      purchasePriceType
      string
      Valid values[ "NotSpecified", "PurchaseUnit", "PurchaseContentUnit", "ConsumerUnit" ]
      purchaseUnitToPurchaseContentUnitFactor
      number (double)
      purchaseContentUnitToConsumerUnitFactor
      number (double)
      cbmPerSingleUnit
      number (double)
      purchasePricePerAmount
      number (double)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      weightedTotalNetPrice
      number (double)
      orderDiscountPercentage
      number (double)
      discountPrice
      number (double)
      isNetPrice
      boolean
      Default"False"
      expectedDeliveryDate
      string (date-time)
      note
      string
      miscInfo
      string
      confirmationStatus
      string
      Valid values[ "NotSpecified", "Changes", "Pending", "NotAccepted", "Accepted" ]
      confirmationAmount
      number (double)
      confirmationAmountMeasureUnit
      string
      confirmationFreeInfo
      string
      isCancelled
      boolean
      Default"False"
      calculatedConsumerUnits
      number (double)
      assignedBlanketConsumerUnits
      number (double)
      expectedDeliveryDays
      integer (int32)
      conversionId
      integer (int64)
      productDescription
      string
      note1
      string
      note2
      string
      note3
      string
      note4
      string
      alternateDescription
      string
      mainBarcode
      integer (int64)
      salePrice
      number (double)
      productNumber
      integer (int64)
      productExternalCode
      string
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      productInformation
      string
      vatDescription
      string
      brandDescription
      string
      subBrandDescription
      string
      colorExternalCode
      string
      purchaseUnitDimensionShortDescription
      string
      purchaseUnitPackageShortDescription
      string
      purchaseContentUnitDimensionShortDescription
      string
      purchaseContentUnitPackageShortDescription
      string
      purchaseInfoDescription
      string
      purchaseOrderNumber
      integer (int32)
      orderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Approved", "Final", "Closed" ]
      purchaseOrderReference
      string
      purchaseOrderExpectedDeliveryDate
      string (date-time)
      orderSentDate
      string (date-time)
      supplierDescription
      string
      supplierNumber
      integer (int64)
      purchaseOrderSupplierDescription
      string
      createdByUser
      string
      isProductCancelled
      boolean
      Default"False"
      openSaleOrders
      number (double)
      openReservations
      number (double)
      allocatedStock
      number (double)
      stock
      number (double)
      freeStock
      number (double)
      futureStock
      number (double)
      minimumStock
      number (double)
      maximumStock
      number (double)
      orderMethod
      string
      Valid values[ "NotSpecified", "ByStock", "ByPeriodSale", "NoAutoOrder" ]
      calculatedMinStock
      number (double)
      calculatedMaxStock
      number (double)
      manualMinMaxStock
      boolean
      Default"False"
      limitCalculatedMinStock
      number (double)
      limitCalculatedMaxStock
      number (double)
      purchaseStatusCode
      string
      purchaseStatusDescription
      string
      hasAlternativesAtCurrentSupplier
      boolean
      Default"False"
      hasAlternativesAtOtherSupplier
      boolean
      Default"False"
      highestInterbrancheFreeStock
      number (double)
      totalStock
      integer (int32)
      hasAlternativesAtCurrentAndOtherSupplier
      boolean
      Default"False"
      totalUnitsReceived
      number (double)
      saleOrdersOrderedQty
      number (double)
      reservationsQty
      number (double)
      Array of object
      object
      itemId
      integer (int32)
      createdByUserId
      integer (int32)
      createdDateTime
      string (date-time)
      lastModifiedByUserId
      integer (int32)
      lastModifiedDateTime
      string (date-time)
      companyId
      integer (int32)
      purchaseOrderId
      integer (int32)
      productId
      integer (int32)
      vatId
      integer (int32)
      vatPercentage
      number (double)
      brandId
      integer (int32)
      orderCode
      string
      consumerBarcode
      integer (int64)
      purchaseUnitBarcode
      integer (int64)
      originalRequestedSaleConsumerUnits
      number (double)
      requestedSaleConsumerUnits
      number (double)
      purchaseUnitAmount
      number (double)
      purchaseUnitDimensionId
      integer (int32)
      purchaseUnitPackageId
      integer (int32)
      purchaseContentUnitDimensionId
      integer (int32)
      purchaseContentUnitPackageId
      integer (int32)
      orderMultiplier
      number (double)
      minimumOrderQuantity
      number (double)
      purchasePriceType
      string
      Valid values[ "NotSpecified", "PurchaseUnit", "PurchaseContentUnit", "ConsumerUnit" ]
      purchaseUnitToPurchaseContentUnitFactor
      number (double)
      purchaseContentUnitToConsumerUnitFactor
      number (double)
      cbmPerSingleUnit
      number (double)
      purchasePricePerAmount
      number (double)
      pceGrossPrice
      number (double)
      pceNetPrice
      number (double)
      totalGrossPrice
      number (double)
      totalNetPrice
      number (double)
      weightedTotalNetPrice
      number (double)
      orderDiscountPercentage
      number (double)
      discountPrice
      number (double)
      isNetPrice
      boolean
      Default"False"
      expectedDeliveryDate
      string (date-time)
      note
      string
      miscInfo
      string
      confirmationStatus
      string
      Valid values[ "NotSpecified", "Changes", "Pending", "NotAccepted", "Accepted" ]
      confirmationAmount
      number (double)
      confirmationAmountMeasureUnit
      string
      confirmationFreeInfo
      string
      isCancelled
      boolean
      Default"False"
      calculatedConsumerUnits
      number (double)
      assignedBlanketConsumerUnits
      number (double)
      expectedDeliveryDays
      integer (int32)
      conversionId
      integer (int64)
      productDescription
      string
      note1
      string
      note2
      string
      note3
      string
      note4
      string
      alternateDescription
      string
      mainBarcode
      integer (int64)
      salePrice
      number (double)
      productNumber
      integer (int64)
      productExternalCode
      string
      productType
      string
      Valid values[ "NotSpecified", "Default", "Giftcard", "Kitchen", "ProductGroup", "Consignation", "FreeEntry", "Collection", "ShippingCosts", "CashOnDelivery" ]
      productInformation
      string
      vatDescription
      string
      brandDescription
      string
      subBrandDescription
      string
      colorExternalCode
      string
      purchaseUnitDimensionShortDescription
      string
      purchaseUnitPackageShortDescription
      string
      purchaseContentUnitDimensionShortDescription
      string
      purchaseContentUnitPackageShortDescription
      string
      purchaseInfoDescription
      string
      purchaseOrderNumber
      integer (int32)
      orderStatus
      string
      Valid values[ "NotSpecified", "New", "EntryCompleted", "EntryVerified", "Approved", "Final", "Closed" ]
      purchaseOrderReference
      string
      purchaseOrderExpectedDeliveryDate
      string (date-time)
      orderSentDate
      string (date-time)
      supplierDescription
      string
      supplierNumber
      integer (int64)
      purchaseOrderSupplierDescription
      string
      createdByUser
      string
      isProductCancelled
      boolean
      Default"False"
      openSaleOrders
      number (double)
      openReservations
      number (double)
      allocatedStock
      number (double)
      stock
      number (double)
      freeStock
      number (double)
      futureStock
      number (double)
      minimumStock
      number (double)
      maximumStock
      number (double)
      orderMethod
      string
      Valid values[ "NotSpecified", "ByStock", "ByPeriodSale", "NoAutoOrder" ]
      calculatedMinStock
      number (double)
      calculatedMaxStock
      number (double)
      manualMinMaxStock
      boolean
      Default"False"
      limitCalculatedMinStock
      number (double)
      limitCalculatedMaxStock
      number (double)
      purchaseStatusCode
      string
      purchaseStatusDescription
      string
      hasAlternativesAtCurrentSupplier
      boolean
      Default"False"
      hasAlternativesAtOtherSupplier
      boolean
      Default"False"
      highestInterbrancheFreeStock
      number (double)
      totalStock
      integer (int32)
      hasAlternativesAtCurrentAndOtherSupplier
      boolean
      Default"False"
      totalUnitsReceived
      number (double)
      saleOrdersOrderedQty
      number (double)
      reservationsQty
      number (double)
      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