GET api/DashboardData/SalesOrder/ClientId/{ClientId}/UserId/{UserId}/CustomerNumber/{CustomerNumber}/ProjectNumber/{ProjectNumber}/FromDate/{FromDate}/ToDate/{ToDate}

Get sales order dashboard data

Request Information

URI Parameters

Name	Description	Type	Additional information
ClientId		globally unique identifier	Required
UserId		globally unique identifier	Required
CustomerNumber		string	Required
ProjectNumber		string	Required
FromDate	Format: YYYY-MM-DD	date	Required
ToDate	Format: YYYY-MM-DD	date	Required

Body Parameters

None.

Response Information

Resource Description

List of type cSalesOrderReportBI_Data found in the BSPReportBICore library

Collection of cSalesOrderReportBI_Data

Name	Type	Additional information
S_ProgramNameAndVersion	string	None.
C_CompanyName	string	None.
C_CompanyAddressLine1	string	None.
C_CompanyPostCode	string	None.
C_CompanyPostOffice	string	None.
C_CompanyCountry	string	None.
C_CompanyOrgNumber	string	None.
C_CompanyPhone1	string	None.
C_CompanyFax1	string	None.
C_CompanyEmail1	string	None.
C_CompanyWeb	string	None.
H_OCOrderNumber	string	None.
H_OrderStatus	string	None.
H_ExternalOrderNumber	string	None.
H_OrderDate	date	None.
H_DeliveryDate	date	None.
H_CustomerNumber	string	None.
H_CustomerName	string	None.
H_RequisitionNumber	string	None.
H_ContactName1	string	None.
H_ProjectNumber	string	None.
H_ProjectName	string	None.
H_OrderSource	string	None.
H_EmployeeName	string	None.
H_DelTermDescription	string	None.
H_CarrierName	string	None.
H_InvoiceAddressName	string	None.
H_InvoiceAddressGLN	string	None.
H_InvoiceAddressLine1	string	None.
H_InvoiceAddressLine2	string	None.
H_InvoiceAddressPostCode	string	None.
H_InvoiceAddressPostOffice	string	None.
H_InvoiceAddressCountry	string	None.
H_DeliveryAddressName	string	None.
H_DeliveryAddressGLN	string	None.
H_DeliveryAddressLine1	string	None.
H_DeliveryAddressLine2	string	None.
H_DeliveryAddressPostCode	string	None.
H_DeliveryAddressPostOffice	string	None.
H_DeliveryAddressLongitude	decimal number	None.
H_DeliveryAddressLatitude	decimal number	None.
H_DeliveryAddressCountry	string	None.
H_UltimateCustomerAddressName	string	None.
H_UltimateCustomerAddressGLN	string	None.
H_UltimateCustomerAddressLine1	string	None.
H_UltimateCustomerAddressLine2	string	None.
H_UltimateCustomerAddressPostCode	string	None.
H_UltimateCustomerAddressPostOffice	string	None.
H_UltimateCustomerAddressCountry	string	None.
H_ShipFromAddressName	string	None.
H_ShipFromAddressGLN	string	None.
H_ShipFromAddressLine1	string	None.
H_ShipFromAddressLine2	string	None.
H_ShipFromAddressPostCode	string	None.
H_ShipFromAddressPostOffice	string	None.
H_ShipFromAddressCountry	string	None.
H_OrderReference	string	None.
H_Comment	string	None.
H_OriginalPurchaseNumber	string	None.
H_ProductOwnerName	string	None.
H_ControlWarning	boolean	None.
H_ControlWarningText	string	None.
H_WarningStatus	string	None.
H_EtdDate	date	None.
H_EtaDate	date	None.
H_EtcDate	date	None.
H_RouteNumber	string	None.
H_RouteDescription	string	None.
H_DeliveryMethodNumber	string	None.
H_DeliveryMethodName	string	None.
H_Reference	string	None.
H_CommentInternal	string	None.
H_CommentExternal	string	None.
H_CustomerPurchaseNumber	string	None.
L_EDILineNo	integer	None.
L_OrderLineNo	integer	None.
L_BuyersOrderLineNo	integer	None.
L_ERPLineSequenceNumber	integer	None.
L_ProdNumber	string	None.
L_ProdName	string	None.
L_ProdEPDNumber	string	None.
L_ProdNobbNumber	string	None.
L_ProdAltNumber1	string	None.
L_ProdBrandName	string	None.
L_ProdSize	string	None.
L_ProdColor	string	None.
L_PackingTypeDescription	string	None.
L_ExtLineComment	string	None.
L_DeliveryDate	date	None.
L_Quantity	decimal number	None.
L_ConfirmQuantity	decimal number	None.
L_ToDeliverQuantity	decimal number	None.
L_ToPickQuantity	decimal number	None.
L_PickedQuantity	decimal number	None.
L_DeliveredQuantity	decimal number	None.
L_PackageUnitNameSales	string	None.
L_PackageGTINNumber	string	None.
L_NetWeightConfirmed	decimal number	None.
L_TotNetWeight	decimal number	None.
L_ProdRecommendedRetailPrice	decimal number	None.
L_PackageQuantityBase	decimal number	None.
L_ConfirmedQuantityDevianceEDICode	string	None.
L_ConfirmedQuantityDevianceDescription	string	None.
L_AvailableToOrder	date	None.
L_QuantityBase	decimal number	None.
L_NetAmount	decimal number	None.
L_NetAmountConfirmed	decimal number	None.
L_NetAmountConfirmedWithDiscount	decimal number	None.
L_DiscountAmount	decimal number	None.
L_OverridedPrice	decimal number	None.
L_AdditionalDiscount	decimal number	None.
L_VariableQuantity	boolean	None.
L_QuantityTpak	decimal number	None.
L_Priority	string	None.
L_MainGroupNo	string	None.
L_MainGroupName	string	None.
L_IntermediateGroupNo	string	None.
L_IntermediateGroupName	string	None.
L_SubGroupNo	string	None.
L_SubGroupName	string	None.
L_PrimarySupplierNumber	string	None.
L_PrimarySupplierName	string	None.
L_ArticleLocation	string	None.
L_PackageVolume	decimal number	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "S_ProgramNameAndVersion": "sample string 1",
    "C_CompanyName": "sample string 2",
    "C_CompanyAddressLine1": "sample string 3",
    "C_CompanyPostCode": "sample string 4",
    "C_CompanyPostOffice": "sample string 5",
    "C_CompanyCountry": "sample string 6",
    "C_CompanyOrgNumber": "sample string 7",
    "C_CompanyPhone1": "sample string 8",
    "C_CompanyFax1": "sample string 9",
    "C_CompanyEmail1": "sample string 10",
    "C_CompanyWeb": "sample string 11",
    "H_OCOrderNumber": "sample string 12",
    "H_OrderStatus": "sample string 13",
    "H_ExternalOrderNumber": "sample string 14",
    "H_OrderDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_DeliveryDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_CustomerNumber": "sample string 17",
    "H_CustomerName": "sample string 18",
    "H_RequisitionNumber": "sample string 19",
    "H_ContactName1": "sample string 20",
    "H_ProjectNumber": "sample string 21",
    "H_ProjectName": "sample string 22",
    "H_OrderSource": "sample string 23",
    "H_EmployeeName": "sample string 24",
    "H_DelTermDescription": "sample string 25",
    "H_CarrierName": "sample string 26",
    "H_InvoiceAddressName": "sample string 27",
    "H_InvoiceAddressGLN": "sample string 28",
    "H_InvoiceAddressLine1": "sample string 29",
    "H_InvoiceAddressLine2": "sample string 30",
    "H_InvoiceAddressPostCode": "sample string 31",
    "H_InvoiceAddressPostOffice": "sample string 32",
    "H_InvoiceAddressCountry": "sample string 33",
    "H_DeliveryAddressName": "sample string 34",
    "H_DeliveryAddressGLN": "sample string 35",
    "H_DeliveryAddressLine1": "sample string 36",
    "H_DeliveryAddressLine2": "sample string 37",
    "H_DeliveryAddressPostCode": "sample string 38",
    "H_DeliveryAddressPostOffice": "sample string 39",
    "H_DeliveryAddressLongitude": 40.0,
    "H_DeliveryAddressLatitude": 41.0,
    "H_DeliveryAddressCountry": "sample string 42",
    "H_UltimateCustomerAddressName": "sample string 43",
    "H_UltimateCustomerAddressGLN": "sample string 44",
    "H_UltimateCustomerAddressLine1": "sample string 45",
    "H_UltimateCustomerAddressLine2": "sample string 46",
    "H_UltimateCustomerAddressPostCode": "sample string 47",
    "H_UltimateCustomerAddressPostOffice": "sample string 48",
    "H_UltimateCustomerAddressCountry": "sample string 49",
    "H_ShipFromAddressName": "sample string 50",
    "H_ShipFromAddressGLN": "sample string 51",
    "H_ShipFromAddressLine1": "sample string 52",
    "H_ShipFromAddressLine2": "sample string 53",
    "H_ShipFromAddressPostCode": "sample string 54",
    "H_ShipFromAddressPostOffice": "sample string 55",
    "H_ShipFromAddressCountry": "sample string 56",
    "H_OrderReference": "sample string 57",
    "H_Comment": "sample string 58",
    "H_OriginalPurchaseNumber": "sample string 59",
    "H_ProductOwnerName": "sample string 60",
    "H_ControlWarning": true,
    "H_ControlWarningText": "sample string 62",
    "H_WarningStatus": "sample string 63",
    "H_EtdDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_EtaDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_EtcDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_RouteNumber": "sample string 67",
    "H_RouteDescription": "sample string 68",
    "H_DeliveryMethodNumber": "sample string 69",
    "H_DeliveryMethodName": "sample string 70",
    "H_Reference": "sample string 71",
    "H_CommentInternal": "sample string 72",
    "H_CommentExternal": "sample string 73",
    "H_CustomerPurchaseNumber": "sample string 74",
    "L_EDILineNo": 75,
    "L_OrderLineNo": 76,
    "L_BuyersOrderLineNo": 77,
    "L_ERPLineSequenceNumber": 78,
    "L_ProdNumber": "sample string 79",
    "L_ProdName": "sample string 80",
    "L_ProdEPDNumber": "sample string 81",
    "L_ProdNobbNumber": "sample string 82",
    "L_ProdAltNumber1": "sample string 83",
    "L_ProdBrandName": "sample string 84",
    "L_ProdSize": "sample string 85",
    "L_ProdColor": "sample string 86",
    "L_PackingTypeDescription": "sample string 87",
    "L_ExtLineComment": "sample string 88",
    "L_DeliveryDate": "2026-06-25T16:17:19.4980889+02:00",
    "L_Quantity": 90.0,
    "L_ConfirmQuantity": 91.0,
    "L_ToDeliverQuantity": 92.0,
    "L_ToPickQuantity": 93.0,
    "L_PickedQuantity": 94.0,
    "L_DeliveredQuantity": 95.0,
    "L_PackageUnitNameSales": "sample string 96",
    "L_PackageGTINNumber": "sample string 97",
    "L_NetWeightConfirmed": 98.0,
    "L_TotNetWeight": 99.0,
    "L_ProdRecommendedRetailPrice": 100.0,
    "L_PackageQuantityBase": 101.0,
    "L_ConfirmedQuantityDevianceEDICode": "sample string 102",
    "L_ConfirmedQuantityDevianceDescription": "sample string 103",
    "L_AvailableToOrder": "2026-06-25T16:17:19.4980889+02:00",
    "L_QuantityBase": 105.0,
    "L_NetAmount": 106.0,
    "L_NetAmountConfirmed": 107.0,
    "L_NetAmountConfirmedWithDiscount": 108.0,
    "L_DiscountAmount": 109.0,
    "L_OverridedPrice": 110.0,
    "L_AdditionalDiscount": 111.0,
    "L_VariableQuantity": true,
    "L_QuantityTpak": 113.0,
    "L_Priority": "sample string 114",
    "L_MainGroupNo": "sample string 115",
    "L_MainGroupName": "sample string 116",
    "L_IntermediateGroupNo": "sample string 117",
    "L_IntermediateGroupName": "sample string 118",
    "L_SubGroupNo": "sample string 119",
    "L_SubGroupName": "sample string 120",
    "L_PrimarySupplierNumber": "sample string 121",
    "L_PrimarySupplierName": "sample string 122",
    "L_ArticleLocation": "sample string 123",
    "L_PackageVolume": 124.0
  },
  {
    "S_ProgramNameAndVersion": "sample string 1",
    "C_CompanyName": "sample string 2",
    "C_CompanyAddressLine1": "sample string 3",
    "C_CompanyPostCode": "sample string 4",
    "C_CompanyPostOffice": "sample string 5",
    "C_CompanyCountry": "sample string 6",
    "C_CompanyOrgNumber": "sample string 7",
    "C_CompanyPhone1": "sample string 8",
    "C_CompanyFax1": "sample string 9",
    "C_CompanyEmail1": "sample string 10",
    "C_CompanyWeb": "sample string 11",
    "H_OCOrderNumber": "sample string 12",
    "H_OrderStatus": "sample string 13",
    "H_ExternalOrderNumber": "sample string 14",
    "H_OrderDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_DeliveryDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_CustomerNumber": "sample string 17",
    "H_CustomerName": "sample string 18",
    "H_RequisitionNumber": "sample string 19",
    "H_ContactName1": "sample string 20",
    "H_ProjectNumber": "sample string 21",
    "H_ProjectName": "sample string 22",
    "H_OrderSource": "sample string 23",
    "H_EmployeeName": "sample string 24",
    "H_DelTermDescription": "sample string 25",
    "H_CarrierName": "sample string 26",
    "H_InvoiceAddressName": "sample string 27",
    "H_InvoiceAddressGLN": "sample string 28",
    "H_InvoiceAddressLine1": "sample string 29",
    "H_InvoiceAddressLine2": "sample string 30",
    "H_InvoiceAddressPostCode": "sample string 31",
    "H_InvoiceAddressPostOffice": "sample string 32",
    "H_InvoiceAddressCountry": "sample string 33",
    "H_DeliveryAddressName": "sample string 34",
    "H_DeliveryAddressGLN": "sample string 35",
    "H_DeliveryAddressLine1": "sample string 36",
    "H_DeliveryAddressLine2": "sample string 37",
    "H_DeliveryAddressPostCode": "sample string 38",
    "H_DeliveryAddressPostOffice": "sample string 39",
    "H_DeliveryAddressLongitude": 40.0,
    "H_DeliveryAddressLatitude": 41.0,
    "H_DeliveryAddressCountry": "sample string 42",
    "H_UltimateCustomerAddressName": "sample string 43",
    "H_UltimateCustomerAddressGLN": "sample string 44",
    "H_UltimateCustomerAddressLine1": "sample string 45",
    "H_UltimateCustomerAddressLine2": "sample string 46",
    "H_UltimateCustomerAddressPostCode": "sample string 47",
    "H_UltimateCustomerAddressPostOffice": "sample string 48",
    "H_UltimateCustomerAddressCountry": "sample string 49",
    "H_ShipFromAddressName": "sample string 50",
    "H_ShipFromAddressGLN": "sample string 51",
    "H_ShipFromAddressLine1": "sample string 52",
    "H_ShipFromAddressLine2": "sample string 53",
    "H_ShipFromAddressPostCode": "sample string 54",
    "H_ShipFromAddressPostOffice": "sample string 55",
    "H_ShipFromAddressCountry": "sample string 56",
    "H_OrderReference": "sample string 57",
    "H_Comment": "sample string 58",
    "H_OriginalPurchaseNumber": "sample string 59",
    "H_ProductOwnerName": "sample string 60",
    "H_ControlWarning": true,
    "H_ControlWarningText": "sample string 62",
    "H_WarningStatus": "sample string 63",
    "H_EtdDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_EtaDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_EtcDate": "2026-06-25T16:17:19.4980889+02:00",
    "H_RouteNumber": "sample string 67",
    "H_RouteDescription": "sample string 68",
    "H_DeliveryMethodNumber": "sample string 69",
    "H_DeliveryMethodName": "sample string 70",
    "H_Reference": "sample string 71",
    "H_CommentInternal": "sample string 72",
    "H_CommentExternal": "sample string 73",
    "H_CustomerPurchaseNumber": "sample string 74",
    "L_EDILineNo": 75,
    "L_OrderLineNo": 76,
    "L_BuyersOrderLineNo": 77,
    "L_ERPLineSequenceNumber": 78,
    "L_ProdNumber": "sample string 79",
    "L_ProdName": "sample string 80",
    "L_ProdEPDNumber": "sample string 81",
    "L_ProdNobbNumber": "sample string 82",
    "L_ProdAltNumber1": "sample string 83",
    "L_ProdBrandName": "sample string 84",
    "L_ProdSize": "sample string 85",
    "L_ProdColor": "sample string 86",
    "L_PackingTypeDescription": "sample string 87",
    "L_ExtLineComment": "sample string 88",
    "L_DeliveryDate": "2026-06-25T16:17:19.4980889+02:00",
    "L_Quantity": 90.0,
    "L_ConfirmQuantity": 91.0,
    "L_ToDeliverQuantity": 92.0,
    "L_ToPickQuantity": 93.0,
    "L_PickedQuantity": 94.0,
    "L_DeliveredQuantity": 95.0,
    "L_PackageUnitNameSales": "sample string 96",
    "L_PackageGTINNumber": "sample string 97",
    "L_NetWeightConfirmed": 98.0,
    "L_TotNetWeight": 99.0,
    "L_ProdRecommendedRetailPrice": 100.0,
    "L_PackageQuantityBase": 101.0,
    "L_ConfirmedQuantityDevianceEDICode": "sample string 102",
    "L_ConfirmedQuantityDevianceDescription": "sample string 103",
    "L_AvailableToOrder": "2026-06-25T16:17:19.4980889+02:00",
    "L_QuantityBase": 105.0,
    "L_NetAmount": 106.0,
    "L_NetAmountConfirmed": 107.0,
    "L_NetAmountConfirmedWithDiscount": 108.0,
    "L_DiscountAmount": 109.0,
    "L_OverridedPrice": 110.0,
    "L_AdditionalDiscount": 111.0,
    "L_VariableQuantity": true,
    "L_QuantityTpak": 113.0,
    "L_Priority": "sample string 114",
    "L_MainGroupNo": "sample string 115",
    "L_MainGroupName": "sample string 116",
    "L_IntermediateGroupNo": "sample string 117",
    "L_IntermediateGroupName": "sample string 118",
    "L_SubGroupNo": "sample string 119",
    "L_SubGroupName": "sample string 120",
    "L_PrimarySupplierNumber": "sample string 121",
    "L_PrimarySupplierName": "sample string 122",
    "L_ArticleLocation": "sample string 123",
    "L_PackageVolume": 124.0
  }
]