CustomerOrderRows

Queryable, Introduced in version 2.18

GET https://localhost:8001/sv/001.1/api/v1/Sales/CustomerOrderRows

Represents a customer order row.

GUID

65969D1D-6139-4C75-8EA2-1A271448674A

Required permission

Show customer 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 CustomerOrderRows
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.
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
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 VatRates
WarehouseId Int64 The business key identifier of the warehouse that the row belongs
to.

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

References Currencies
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
CustomerCommitmentLevel Int32 The customer commitment level of the row.

  • FixedOrder: 1
  • Manufacture: 2
  • BuyMaterial: 3
  • Forecast: 4
PickingQuantity Decimal? The picking quantity of the row.
AlternatePreparationCode String The alternate preparation code of the row.

  • Max length is 200
Storage String The storage specified by the row.

  • Max length is 35
ShowFreeTextIn Int32 Specifies which documents the free text row data will appear on.

  • None: 0
  • Quote: 1
  • Acknowledgement: 2
  • DeliveryNote: 4
  • Invoice: 8
  • ProFormaInvoice: 16

  • Bitmask
CreateManufacturingOrder Boolean Specifies if a manufacturing order should be created for the row.
CreatePurchaseOrder Boolean Specifies if a purchase order should be created for the row.
LinkedPurchaseOrderRowId Int64? The business key identifier of the row's linked purchase order row.
LinkedManufacturingOrderId Int64? The business key identifier of the row's linked manufacturing order.

References ManufacturingOrders
LinkedWithdrawalReservationId Int64? The business key identifier of the row's linked withdrawal reservation.

References PartWithdrawalReservation.
PlannedDateOfArrival DateTimeOffset? The planned date of arrival specified by the row.

  • Obsolete since version 24.3 (Unavailable)
BacklogAmount Decimal The backlog amount on the row.
StatisticalGoodsCodeId Int64? The business key identifier of the row's statistical goods code.

References StatisticalGoodsCodes
RowStatus Int32 The status of the customer order row.

  • OrderConfirmationPrinted: 1
  • DeliveryNotePrinted: 2

  • Bitmask
ParentOrderId Int64 The business key identifier of the rows parent order.

References CustomerOrders
 Introduced in version 2.27
Dock String The dock for the row (EDI).

  • Max length is 35
 Introduced in version 2.28
DockName String The dock description for the row (EDI).

  • Max length is 80
 Introduced in version 2.28
KanbanNumber String The kanban number for the row (EDI).

  • Max length is 80
 Introduced in version 2.28
CustomerOrderRowPosition String The customer's order row position for the row.

  • Max length is 15
 Introduced in version 2.30
ReferenceNumberManufacturing String The reference number for manufacturing for the row.

  • Max length is 80
 Introduced in version 2.30
ReferenceNumberDelivery String The reference number for delivery for the row.

  • Max length is 80
 Introduced in version 2.30
ShowDeliveryDate Boolean Specifies if the delivery date is shown on the row
 Introduced in version 2.30
CreatedFrom Int32 Specifies what the row was created from.

  • Client: 0
  • M2M: 1
  • EDI: 2
  • DeliverySchedule: 3
  • DeliveryScheduleCallOff: 4
 Introduced in version 2.30
FixedAssetId Int64? The business key identifier of the rows fixed asset.

 Introduced in version 2.30
LinkedStockOrderRowId Int64? The business key identifier of the rows linked stock order row.

References PurchaseOrderRows
 Introduced in version 2.30
LinkedStockOrderRow PurchaseOrderRows The linked stock order row for the row.

  • Expandable
 Introduced in version 2.30
NewFinishDate DateTimeOffset? The new finish date for the row.
 Introduced in version 2.30
TransferStatus Int32 The transfer status for the row.

  • None: 0
  • Partial: 1
  • Fully: 2
 Introduced in version 2.30
TransferProfileId Int64? The business key identifier of the rows transfer profile.

 Introduced in version 2.30
OrderNumberInRemoteCompany String The order number in remote company for the row.

  • Max length is 15
 Introduced in version 2.30
PositionInRemoteCompany Int64? The position in remote company for the row.
 Introduced in version 2.30
CodingId Int64? The business key identifier of the rows coding.

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

  • Expandable
 Introduced in version 2.33
PaymentPlanRowId Int64? The business key identifier of the rows customer order payment plan row.

References CustomerOrderPaymentPlanRow
 Introduced in version 2.30
IsCreditedPaymentPlanRow Boolean Specifies if the row is a credited payment plan row.
 Introduced in version 2.30
IsIncludedInPaymentPlan Boolean Specifies if the row is included in payment plan.
 Introduced in version 2.30
Status Int32 The status of the customer order.

  • NotInitialized: 0
  • Registered: 1
  • OrderConfirmationPrinted: 2
  • CanNotConfirmDeliveryTime: 3
  • DeliveryNotePrinted: 4
  • PartiallyDelivered: 5
  • History: 9
 Introduced in version 2.30
ProformaStatus Int32 The status of the row's proforma invoice.

  • None: 0
  • ApprovedForPrint: 1
  • Printed: 2
 Introduced in version 2.30
ProformaNumber Int64? The proforma number of the row.
 Introduced in version 2.30
SubPartParentRowId Int64? The business key identifier of the sub part row's parent row.

References CustomerOrderRows
 Introduced in version 2.30
QuantityRatio Decimal? The quantity ratio of the row.
 Introduced in version 2.30
RowIndex Int32? The index of the row.
 Introduced in version 2.30
SumRowId Int64? The business key identifier of the row's sum row.

References CustomerOrderRows
 Introduced in version 2.30
PriceOrigin Int32? The price origin 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
PriceOriginPriceListId Int64? The business key identifier of the row's original pricelist.

References PriceList
 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 rows goods label specified by the row.

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

 Introduced in version 22.6
OrderQuantity OrderQuantityCustomerOrders Order quantity that holds the partial quantities.

  • Expandable
 Introduced in version 22.6
CustomerOrderTransferRowIdentifier Guid? The customer order transfer row identifier.
 Introduced in version 23.2
PartConfigurationIdInRemoteCompany Int64? The business key identifier of the row's part configuration in the remote company.

 Introduced in version 23.2
PriceLockedFromAutomaticChanges Boolean? Specifies if the rows price is locked from automatic changes.
 Introduced in version 24.2
SerialNumberInformation SerialNumberOrderRowInformation[] The serial number information of customer order row
References SerialNumberOrderRowInformation

  • Expandable
 Introduced in version 24.4
DiscountRows CustomerOrderOrderRowDiscounts[] The discount rows for the row.

  • Expandable
 Introduced in version 24.8
ComparativePrice Decimal? The comparative price for the row.
 Introduced in version 25.2
ComparativePriceCurrencyId Int64? The business key identifier of the row's comparative price currency.

 Introduced in version 25.2

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,
  "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,
  "RestQuantity": 0.0,
  "DeliveredQuantity": 0.0,
  "InitialDeliveryDate": null,
  "DesiredDeliveryDate": null,
  "RestQuantityInOrderUnit": 0.0,
  "DeliveredQuantityInOrderUnit": 0.0,
  "CreationContext": 0,
  "CustomerCommitmentLevel": 0,
  "PickingQuantity": null,
  "AlternatePreparationCode": null,
  "Storage": null,
  "ShowFreeTextIn": 0,
  "CreateManufacturingOrder": false,
  "CreatePurchaseOrder": false,
  "LinkedPurchaseOrderRowId": null,
  "LinkedManufacturingOrderId": null,
  "LinkedWithdrawalReservationId": null,
  "PlannedDateOfArrival": null,
  "BacklogAmount": 0.0,
  "StatisticalGoodsCodeId": null,
  "RowStatus": 0,
  "ParentOrderId": 0,
  "Dock": null,
  "DockName": null,
  "KanbanNumber": null,
  "CustomerOrderRowPosition": null,
  "ReferenceNumberManufacturing": null,
  "ReferenceNumberDelivery": null,
  "ShowDeliveryDate": false,
  "CreatedFrom": 0,
  "FixedAssetId": null,
  "LinkedStockOrderRowId": null,
  "LinkedStockOrderRow": null,
  "NewFinishDate": null,
  "TransferStatus": 0,
  "TransferProfileId": null,
  "OrderNumberInRemoteCompany": null,
  "PositionInRemoteCompany": null,
  "CodingId": null,
  "Coding": null,
  "PaymentPlanRowId": null,
  "IsCreditedPaymentPlanRow": false,
  "IsIncludedInPaymentPlan": false,
  "Status": 0,
  "ProformaStatus": 0,
  "ProformaNumber": null,
  "SubPartParentRowId": null,
  "QuantityRatio": null,
  "RowIndex": null,
  "SumRowId": null,
  "PriceOrigin": null,
  "PriceOriginPriceListId": null,
  "DiscountIsLockedFromAutomaticChanges": false,
  "IntrastatTransactionTypeId": null,
  "IntrastatTransactionType": null,
  "TariffAndServiceCodeId": null,
  "TariffAndServiceCode": null,
  "PartConfigurationId": null,
  "RowsGoodsLabel": null,
  "OrderQuantityId": null,
  "OrderQuantity": null,
  "CustomerOrderTransferRowIdentifier": null,
  "PartConfigurationIdInRemoteCompany": null,
  "PriceLockedFromAutomaticChanges": null,
  "SerialNumberInformation": null,
  "DiscountRows": null,
  "ComparativePrice": null,
  "ComparativePriceCurrencyId": null
}