Show / Hide Table of Contents

    PurchaseOrderRows

    Queryable, Introduced in version 2.26

    GET https://localhost:8001/sv/001.1/api/v1/Purchase/PurchaseOrderRows
    

    Represents a purchase order row.

    GUID

    E2C7B35D-48E3-45E6-AEEC-A297943E583F
    

    Required permission

    Show purchase orders
    

    Properties

    Name Type Summary Introduced in
    Id Int64 The business key identifier of the row.
    Position Int64? The relative numeric position of the row.
    OrderRowType Int32 The type of the row.

    • Part: 1
    • Additional: 2
    • Sum: 3
    • FreeText: 4
    PartId Int64? The business key identifier of the part set for the row.

    References Parts
    Part Parts The part of the row.

    • Expandable
    EntityIdentityString String The human readable identifier of the entity subject of the row.

    • Max length is 20
    AdditionalRowDescription String The additional row description of the row.

    • Max length is 80
    FreeTextHtml String The free text row's rich text HTML row data.

    • Max length is 0
    FreeText String The free text row's raw text.

    • Max length is 0
    ParentRowId Int64? The business key identifier of the current row's parent.

    References PurchaseOrderRows
    DeliveryDate DateTimeOffset? The delivery date set for the row.
    RevisionId Int64? The business key identifier of the row's revision.

    References Revisions
    Revision Revisions The revision of the row.

    • Expandable
    OrderedQuantity Decimal The ordered quantity of the row.
    Price Decimal? The price of the row.
    PriceCurrencyId Int64? The business key identifier of the row price currency.

    References Currencies
    PriceCurrency Currencies The price currency for the row.

    • Expandable
    Introduced in version 2.30
    Discount Decimal The discount in percent set for the row.
    ToolId Int64? The business key identifier of the tool of the row.

    References Tool

    • Obsolete since version 2.48 (Replaced by Part)
    UnitId Int64? The business key identifier of the row's unit.

    References Units
    Unit Units The unit of the row.

    • Expandable
    VatRateId Int64 The business key identifier of the row's VAT rate.

    References
    VatRate VatRates The VAT rate of the row.

    • Expandable
    Introduced in version 2.30
    WarehouseId Int64 The business key identifier of the warehouse that the row belongs
    to.

    References
    Warehouse Warehouses The warehouse that the row belongs to.

    • Expandable
    Introduced in version 2.30
    WeightPerUnit Decimal? The weight per unit of the row.
    OrderDate DateTimeOffset The order date of the row.
    ConversionFactor Decimal The conversion factor of the row.
    PriceInCompanyCurrency Decimal? The row price in the company currency.
    PriceInCompanyCurrencyCurrencyId Int64? The business key identifier of the company currency.

    References Currencies
    SetupPriceInCompanyCurrency Decimal? The setup price of the row in the company currency.
    SetupPriceInCompanyCurrencyCurrencyId Int64? The business key identifier of the company currency.
    StandardPrice Decimal? The standard price of the row.
    StandardPriceCurrencyId Int64? The business key identifier of the row's standard price currency.

    References Currencies
    StandardPriceCurrency Currencies The standard price currency of the row.

    • Expandable
    Introduced in version 2.30
    SetupPrice Decimal? The setup price of the row.
    SetupPriceCurrencyId Int64? The business key identifier of the row's setup price currency.

    References Currencies
    SetupPriceCurrency Currencies The setup price currency of the row.

    • Expandable
    Introduced in version 2.30
    ShowPrice Boolean Specifies if price should be shown for the row.
    PartRowType Int32 The part row type of the row.

    • NotPartRow: 0
    • RegularRow: 1
    • SubPartRow: 2
    • SetupPriceRow: 3
    • AlloyCostRow: 4
    • PaymentPlanRow: 5
    • PackagingRow: 6
    LifeCycleState Int32 The life cycle state of the row.

    • Transient: 1
    • Persistent: 10
    • History: 20
    • RemovableCandidate: 99
    PartStatus Int32? The part status of the part at the time of row creation.

    • Quote: 1
    • Prototype: 2
    • New: 3
    • Normal: 4
    • NewRevision: 5
    • PhasingOut: 6
    • Expired: 9
    • Inactive: 99
    OrderedQuantityInOrderUnit Decimal The ordered quantity in the order unit.
    RestQuantity Decimal The rest quantity of the row.
    DeliveredQuantity Decimal The delivered quantity of the row.
    InitialDeliveryDate DateTimeOffset? The initial delivery date of the row.
    DesiredDeliveryDate DateTimeOffset? The desired delivery date of the row.
    RestQuantityInOrderUnit Decimal The rest quantity in the order unit.
    DeliveredQuantityInOrderUnit Decimal The delivered quantity in the order unit.
    CreationContext Int32 The creation context of the row.

    • OrderRegistration: 0
    • DeliveryReporting: 1
    • Invoicing: 2
    • PartialInvoicing: 3
    ShowFreeTextIn Int32 Specifies which documents the free text row data will appear on.

    • Internal: 0
    • Inquiry: 1
    • Order: 2
    • DeliverySchedule: 4

    • Bitmask
    StatisticalGoodsCodeId Int64? The business key identifier of the row's statistical goods code.

    References
    StatisticalGoodsCode StatisticalGoodsCodes The statistical goods code of the row.

    • Expandable
    Introduced in version 2.30
    RowStatus Int32 The status of the purchase order row.

    • Registered: 1
    • PurchaseOrderRowPrinted: 2
    • PartiallyDelivered: 5
    • History: 9
    Version Int32 The version of the row.
    Introduced in version 2.30
    ArrivalReporting Boolean Specifies if the row uses arrival reporting.
    Introduced in version 2.30
    ConfirmedDelayed Boolean Specifies if the row is confirmed delayed.
    Introduced in version 2.30
    DelayCommentId Int64? The business key identifier of the row's delay comment.

    References Comments
    Introduced in version 2.30
    DelayComment Comments The delay comment of the row.

    • Expandable
    Introduced in version 2.30
    DelayReasonId Int64? The business key identifier of the row's delay reason.

    References ReasonCodes
    Introduced in version 2.30
    DelayReason ReasonCodes The delay reason of the row.

    • Expandable
    Introduced in version 2.30
    CodingId Int64? The business key identifier of the row's coding.

    References coding
    Introduced in version 2.30
    Coding Codings The coding of the row.

    • Expandable
    Introduced in version 2.30
    IsConfirmed Boolean Specifies if the row is confirmed.
    Introduced in version 2.30
    ReceivingInspectionInstructionId Int64? The business key identifier of the row's receiving inspection instruction.

    References Comments
    Introduced in version 2.30
    ReceivingInspectionInstruction Comments The receiving inspection instruction of the row.

    • Expandable
    Introduced in version 2.30
    ReceivingInspectionType Int32 The receiving inspection type of the row.

    • None: 0
    • Always: 1
    • VariableInspection: 2
    Introduced in version 2.30
    ReceivingMessageId Int64? The business key identifier of the row's receiving message.

    References Comments
    Introduced in version 2.30
    ReceivingMessage Comments The receiving message of the row.

    • Expandable
    Introduced in version 2.30
    RequiredForManufacturingOrderNode Int64? The business key identifier of the manufacturing order node that requires this row.

    References ManufacturingOrderNode
    Introduced in version 2.30
    Weight Decimal The weight of the row.
    Introduced in version 2.30
    LinkedStockOrderRowId Int64? The business key identifier of the row's linked stock order row.

    References CustomerOrderRows
    Introduced in version 2.30
    LinkedSubcontractingManufacturingOrderOperation Int64? The business key identifier of the row's linked subcontracting manufacturing order operation.

    References ManufacturingOrderOperations
    Introduced in version 2.30
    OriginatingPurchaseOrderDeliveryRowId Int64? The business key identifier of the row's originating purchase order delivery row.

    References PurchaseOrderDeliveryRows
    Introduced in version 2.30
    CausingTransType Int32 The causing transaction type of the row.

    • StockBalanceRow: 0
    • ReceivedPurchaseOrder: 1
    • PurchaseOrder: 2
    • PurchaseOrderSuggestion: 3
    • ManufactureOrderNode: 4
    • ManufactureOrderNodeSuggestion: 5
    • ManufactureOrderNodeSimulation: 6
    • CustomerOrder: 7
    • SalesForecast: 8
    • CustomerOrderForecast: 9
    • MaterialRequirementFromManufactureOrderNode: 10
    • MaterialRequirementFromManufactureOrderSuggestion: 11
    • MaterialRequirementFromManufactureOrderSimulation: 12
    • Quote: 13
    • MaterialRequirementSuggestionFromQuoteSimulation: 14
    • ArrivingStockOrder: 15
    • DeliveringStockOrder: 16
    • StockOrderArrivalSuggestion: 17
    • StockOrderDeliverySuggestion: 18
    • CustomerOrderFromDeliveryTimeControl: 19
    • MaterialRequirementSuggestionFromDeliveryTimeControl: 20
    • ManufactureOrderNodeFromDeliveryTimeControl: 21
    • PurchaseOrderFromDeliveryTimeControl: 22
    • PurchaseOrderAdvice: 23
    • CustomerOrderPreliminary: 27
    • CustomerOrderRowMissingDeliveryDate: 28
    • DeliveringStockOrderPreliminary: 29
    • ServiceOrder: 30
    • ReturnTool: 33
    • WithdrawalTool: 34
    • QuotePreliminary: 35
    • QuoteMissingDeliveryDate: 36
    • SalesBlanketOrder: 40
    • PurchaseBlanketOrder: 41
    • ReturnPurchaseOrder: 42
    Introduced in version 2.30
    CausingOrderRowId Int64? The business key identifier of the order row that was the cause of this row.

    References depends on CausingTransType
    Introduced in version 2.30
    RequirementDate DateTimeOffset? The requirement date of the row.
    Introduced in version 2.30
    PreviousOrderedQuantity Decimal? The previous ordered quantity of the row.
    Introduced in version 2.30
    PreviousDeliveryDate DateTimeOffset? The previous delivery date of the row.
    Introduced in version 2.30
    SubPartParentRowId Int64? The business key identifier of the row's sub part parent row.

    References PurchaseOrderRows
    Introduced in version 2.30
    QuantityRatio Decimal? The quantity ratio of the row.
    Introduced in version 2.30
    ParentOrderId Int64 The business key identifier of the row's purchase order.

    References PurchaseOrders
    Introduced in version 2.30
    RowIndex Int32 The row index of the row.
    Introduced in version 2.30
    SumRowId Int64? The business key identifier of the row's sum row.

    References PurchaseOrderRows
    Introduced in version 2.30
    PriceOrigin Int32 The row index of the row.

    • Undefined: 0
    • UserDefined: 1
    • PriceList: 2
    • PriceListStaggered: 3
    • BusinessPartLink: 4
    • BusinessPartLinkStaggered: 5
    • StandardPrice: 6
    • PartConfiguration: 7
    • PostCalculatedAverage: 8
    • BusinessPartLinkFuturePrice: 9
    Introduced in version 2.30
    DiscountIsLockedFromAutomaticChanges Boolean Specifies if the row's discount is locked from automatic changes.
    Introduced in version 2.30
    IntrastatTransactionTypeId Int64? The business key identifier of the row's intrastat transaction type.

    References TransactionTypeIntrastats
    Introduced in version 2.30
    IntrastatTransactionType TransactionTypeIntrastats The intrastat transaction type of the row.

    • Expandable
    Introduced in version 2.30
    TariffAndServiceCodeId Int64? The business key identifier of the row's tariff and service code.

    References
    Introduced in version 2.30
    TariffAndServiceCode TariffAndServiceCodes The tariff and service code of the row.

    • Expandable
    Introduced in version 2.30
    PartConfigurationId Int64? The business key identifier of the row's part configuration.

    References PartConfiguration
    Introduced in version 2.30
    RowsGoodsLabel String The goods label of the purchase order row.

    • Max length is 80
    Introduced in version 2.46
    OrderQuantityId Int64? The business key identifier of order quantity.

    • References OrderQuantityPurchaseOrders
    Introduced in version 22.6
    OrderQuantity OrderQuantityPurchaseOrders Order quantity that holds the partial quantities.

    • Expandable
    Introduced in version 22.6
    SupplierDrawingNumber String The supplier drawing number of the purchase order row.
    Introduced in version 24.6
    SupplierRevisionNumber String The supplier revision number of the purchase order row.
    Introduced in version 24.6
    RowNotes String The note of the purchase order row.

    • Max length is 100
    Introduced in version 24.9

    Example

    {
      "Id": 0,
      "Position": null,
      "OrderRowType": 0,
      "PartId": null,
      "Part": null,
      "EntityIdentityString": null,
      "AdditionalRowDescription": null,
      "FreeTextHtml": null,
      "FreeText": null,
      "ParentRowId": null,
      "DeliveryDate": null,
      "RevisionId": null,
      "Revision": null,
      "OrderedQuantity": 0.0,
      "Price": null,
      "PriceCurrencyId": null,
      "PriceCurrency": null,
      "Discount": 0.0,
      "ToolId": null,
      "UnitId": null,
      "Unit": null,
      "VatRateId": 0,
      "VatRate": null,
      "WarehouseId": 0,
      "Warehouse": null,
      "WeightPerUnit": null,
      "OrderDate": "0001-01-01T00:00:00+00:00",
      "ConversionFactor": 0.0,
      "PriceInCompanyCurrency": null,
      "PriceInCompanyCurrencyCurrencyId": null,
      "SetupPriceInCompanyCurrency": null,
      "SetupPriceInCompanyCurrencyCurrencyId": null,
      "StandardPrice": null,
      "StandardPriceCurrencyId": null,
      "StandardPriceCurrency": null,
      "SetupPrice": null,
      "SetupPriceCurrencyId": null,
      "SetupPriceCurrency": null,
      "ShowPrice": false,
      "PartRowType": 0,
      "LifeCycleState": 0,
      "PartStatus": null,
      "OrderedQuantityInOrderUnit": 0.0,
      "RestQuantity": 0.0,
      "DeliveredQuantity": 0.0,
      "InitialDeliveryDate": null,
      "DesiredDeliveryDate": null,
      "RestQuantityInOrderUnit": 0.0,
      "DeliveredQuantityInOrderUnit": 0.0,
      "CreationContext": 0,
      "ShowFreeTextIn": 0,
      "StatisticalGoodsCodeId": null,
      "StatisticalGoodsCode": null,
      "RowStatus": 0,
      "Version": 0,
      "ArrivalReporting": false,
      "ConfirmedDelayed": false,
      "DelayCommentId": null,
      "DelayComment": null,
      "DelayReasonId": null,
      "DelayReason": null,
      "CodingId": null,
      "Coding": null,
      "IsConfirmed": false,
      "ReceivingInspectionInstructionId": null,
      "ReceivingInspectionInstruction": null,
      "ReceivingInspectionType": 0,
      "ReceivingMessageId": null,
      "ReceivingMessage": null,
      "RequiredForManufacturingOrderNode": null,
      "Weight": 0.0,
      "LinkedStockOrderRowId": null,
      "LinkedSubcontractingManufacturingOrderOperation": null,
      "OriginatingPurchaseOrderDeliveryRowId": null,
      "CausingTransType": 0,
      "CausingOrderRowId": null,
      "RequirementDate": null,
      "PreviousOrderedQuantity": null,
      "PreviousDeliveryDate": null,
      "SubPartParentRowId": null,
      "QuantityRatio": null,
      "ParentOrderId": 0,
      "RowIndex": 0,
      "SumRowId": null,
      "PriceOrigin": 0,
      "DiscountIsLockedFromAutomaticChanges": false,
      "IntrastatTransactionTypeId": null,
      "IntrastatTransactionType": null,
      "TariffAndServiceCodeId": null,
      "TariffAndServiceCode": null,
      "PartConfigurationId": null,
      "RowsGoodsLabel": null,
      "OrderQuantityId": null,
      "OrderQuantity": null,
      "SupplierDrawingNumber": null,
      "SupplierRevisionNumber": null,
      "RowNotes": null
    }
    
    In This Article
    • GUID
    • Required permission
    • Properties
    • Example
    Back to top Copyright © 2023 Monitor ERP System AB