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.

 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
}