InquiryRows

Queryable, Introduced in version 2.30

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

Represents an inquiry row.

GUID

1C7BE577-33A8-4CAF-9F52-16595EF161EB

Required permission

Show inquiry

Properties

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

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

References Parts
EntityIdentityString String The human readable identifier of the row's entity.

  • 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 data.

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

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

References InquiryRows
DeliveryDate DateTimeOffset? The delivery date of 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's price currency.

References Currencies
Discount Decimal The discount specified on the row.
ToolId Int64? The business key identifier of the row's tool.

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 VatRates
WarehouseId Int64 The business key identifier of the row's warehouse.

References Warehouses
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's price in the company currency.
PriceInCompanyCurrencyCurrencyId Int64? The business key identifier of the company currency.

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

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

References Currencies
SetupPrice Decimal? The setup price of the row.
SetupPriceCurrencyId Int64? The business key identifier of the row's setup price currency.
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 row.

  • Quote: 1
  • Prototype: 2
  • New: 3
  • Normal: 4
  • NewRevision: 5
  • PhasingOut: 6
  • Expired: 9
  • Inactive: 99
OrderedQuantityInOrderUnit Decimal The ordered quantity of the row in the order unit.
ShowFreeTextIn Int32 Specifies which documents the free text data of the row should be projected
on.

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

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

References StatisticalGoodsCodes
PurchaseOrderId Int64? The business key identifier of the purchase order that was created as a
result of the row.

References
ExemptFromStatistics Boolean Specifies if the row should be exempted from statistics.
ParentOrderId Int64 The business key identifier of the rows parent inquiry.

References Inquiries
 Introduced in version 2.30
CodingId Int64? The business key identifier of the rows coding.

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

  • Expandable
 Introduced in version 2.33
RowIndex Int32? The index of the row.
 Introduced in version 2.54

Example

{
  "Id": 0,
  "Position": null,
  "OrderRowType": 0,
  "PartId": null,
  "EntityIdentityString": null,
  "AdditionalRowDescription": null,
  "FreeTextHtml": null,
  "FreeText": null,
  "ParentRowId": null,
  "DeliveryDate": null,
  "RevisionId": null,
  "Revision": null,
  "OrderedQuantity": 0.0,
  "Price": null,
  "PriceCurrencyId": null,
  "Discount": 0.0,
  "ToolId": null,
  "UnitId": null,
  "Unit": null,
  "VatRateId": 0,
  "WarehouseId": 0,
  "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,
  "SetupPrice": null,
  "SetupPriceCurrencyId": null,
  "ShowPrice": false,
  "PartRowType": 0,
  "LifeCycleState": 0,
  "PartStatus": null,
  "OrderedQuantityInOrderUnit": 0.0,
  "ShowFreeTextIn": 0,
  "StatisticalGoodsCodeId": null,
  "PurchaseOrderId": null,
  "ExemptFromStatistics": false,
  "ParentOrderId": 0,
  "CodingId": null,
  "Coding": null,
  "RowIndex": null
}