GET api/ReportFormData/SalesOrder/ClientId/{ClientId}/UserId/{UserId}/PurchaseOrderId/{PurchaseOrderId}
Get SalesOrder data for report based on PurchaseOrderId (PurchaseOrder and SalesOrder must be connected)
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| ClientId | globally unique identifier |
Required |
|
| UserId | globally unique identifier |
Required |
|
| PurchaseOrderId | globally unique identifier |
Required |
Body Parameters
None.
Response Information
Resource Description
List of type cFreightBillReportBI_Data found in the BSPReportBICore library
Collection of cSalesOrderReportBI_Data| Name | Description | 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. |
|
| 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. |
|
| 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. |
|
| L_PackageVolume | decimal number |
None. |
|
| H_CommentInternal | string |
None. |
|
| H_CommentExternal | string |
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-25T11:34:58.3439918+02:00",
"H_DeliveryDate": "2026-06-25T11:34:58.3439918+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",
"L_EDILineNo": 61,
"L_OrderLineNo": 62,
"L_BuyersOrderLineNo": 63,
"L_ERPLineSequenceNumber": 64,
"L_ProdNumber": "sample string 65",
"L_ProdName": "sample string 66",
"L_ProdEPDNumber": "sample string 67",
"L_ProdNobbNumber": "sample string 68",
"L_ProdAltNumber1": "sample string 69",
"L_ProdBrandName": "sample string 70",
"L_ProdSize": "sample string 71",
"L_ProdColor": "sample string 72",
"L_PackingTypeDescription": "sample string 73",
"L_ExtLineComment": "sample string 74",
"L_DeliveryDate": "2026-06-25T11:34:58.3439918+02:00",
"L_Quantity": 76.0,
"L_ConfirmQuantity": 77.0,
"L_ToDeliverQuantity": 78.0,
"L_ToPickQuantity": 79.0,
"L_PickedQuantity": 80.0,
"L_DeliveredQuantity": 81.0,
"L_PackageUnitNameSales": "sample string 82",
"L_PackageGTINNumber": "sample string 83",
"L_NetWeightConfirmed": 84.0,
"L_TotNetWeight": 85.0,
"L_ProdRecommendedRetailPrice": 86.0,
"L_PackageQuantityBase": 87.0,
"L_ConfirmedQuantityDevianceEDICode": "sample string 88",
"L_ConfirmedQuantityDevianceDescription": "sample string 89",
"L_AvailableToOrder": "2026-06-25T11:34:58.3439918+02:00",
"L_QuantityBase": 91.0,
"L_NetAmount": 92.0,
"L_NetAmountConfirmed": 93.0,
"L_NetAmountConfirmedWithDiscount": 94.0,
"L_DiscountAmount": 95.0,
"L_OverridedPrice": 96.0,
"L_AdditionalDiscount": 97.0,
"L_VariableQuantity": true,
"L_QuantityTpak": 99.0,
"L_Priority": "sample string 100",
"L_MainGroupNo": "sample string 101",
"L_MainGroupName": "sample string 102",
"L_IntermediateGroupNo": "sample string 103",
"L_IntermediateGroupName": "sample string 104",
"L_SubGroupNo": "sample string 105",
"L_SubGroupName": "sample string 106",
"L_PrimarySupplierNumber": "sample string 107",
"L_PrimarySupplierName": "sample string 108",
"L_ArticleLocation": "sample string 109",
"H_ControlWarning": true,
"H_ControlWarningText": "sample string 111",
"H_WarningStatus": "sample string 112",
"H_EtdDate": "2026-06-25T11:34:58.3439918+02:00",
"H_EtaDate": "2026-06-25T11:34:58.3439918+02:00",
"H_EtcDate": "2026-06-25T11:34:58.3439918+02:00",
"H_RouteNumber": "sample string 116",
"H_RouteDescription": "sample string 117",
"H_DeliveryMethodNumber": "sample string 118",
"H_DeliveryMethodName": "sample string 119",
"H_Reference": "sample string 120",
"L_PackageVolume": 121.0,
"H_CommentInternal": "sample string 122",
"H_CommentExternal": "sample string 123"
},
{
"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-25T11:34:58.3439918+02:00",
"H_DeliveryDate": "2026-06-25T11:34:58.3439918+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",
"L_EDILineNo": 61,
"L_OrderLineNo": 62,
"L_BuyersOrderLineNo": 63,
"L_ERPLineSequenceNumber": 64,
"L_ProdNumber": "sample string 65",
"L_ProdName": "sample string 66",
"L_ProdEPDNumber": "sample string 67",
"L_ProdNobbNumber": "sample string 68",
"L_ProdAltNumber1": "sample string 69",
"L_ProdBrandName": "sample string 70",
"L_ProdSize": "sample string 71",
"L_ProdColor": "sample string 72",
"L_PackingTypeDescription": "sample string 73",
"L_ExtLineComment": "sample string 74",
"L_DeliveryDate": "2026-06-25T11:34:58.3439918+02:00",
"L_Quantity": 76.0,
"L_ConfirmQuantity": 77.0,
"L_ToDeliverQuantity": 78.0,
"L_ToPickQuantity": 79.0,
"L_PickedQuantity": 80.0,
"L_DeliveredQuantity": 81.0,
"L_PackageUnitNameSales": "sample string 82",
"L_PackageGTINNumber": "sample string 83",
"L_NetWeightConfirmed": 84.0,
"L_TotNetWeight": 85.0,
"L_ProdRecommendedRetailPrice": 86.0,
"L_PackageQuantityBase": 87.0,
"L_ConfirmedQuantityDevianceEDICode": "sample string 88",
"L_ConfirmedQuantityDevianceDescription": "sample string 89",
"L_AvailableToOrder": "2026-06-25T11:34:58.3439918+02:00",
"L_QuantityBase": 91.0,
"L_NetAmount": 92.0,
"L_NetAmountConfirmed": 93.0,
"L_NetAmountConfirmedWithDiscount": 94.0,
"L_DiscountAmount": 95.0,
"L_OverridedPrice": 96.0,
"L_AdditionalDiscount": 97.0,
"L_VariableQuantity": true,
"L_QuantityTpak": 99.0,
"L_Priority": "sample string 100",
"L_MainGroupNo": "sample string 101",
"L_MainGroupName": "sample string 102",
"L_IntermediateGroupNo": "sample string 103",
"L_IntermediateGroupName": "sample string 104",
"L_SubGroupNo": "sample string 105",
"L_SubGroupName": "sample string 106",
"L_PrimarySupplierNumber": "sample string 107",
"L_PrimarySupplierName": "sample string 108",
"L_ArticleLocation": "sample string 109",
"H_ControlWarning": true,
"H_ControlWarningText": "sample string 111",
"H_WarningStatus": "sample string 112",
"H_EtdDate": "2026-06-25T11:34:58.3439918+02:00",
"H_EtaDate": "2026-06-25T11:34:58.3439918+02:00",
"H_EtcDate": "2026-06-25T11:34:58.3439918+02:00",
"H_RouteNumber": "sample string 116",
"H_RouteDescription": "sample string 117",
"H_DeliveryMethodNumber": "sample string 118",
"H_DeliveryMethodName": "sample string 119",
"H_Reference": "sample string 120",
"L_PackageVolume": 121.0,
"H_CommentInternal": "sample string 122",
"H_CommentExternal": "sample string 123"
}
]