API

Sales APIs

GET system/reports/108579/result-set?projectOrderId={projectOrderId}

Sub report to REP/108563. This report shows key figures in local and sales currency for project orders item. It can simply be run for one project order only, by setting filter for this POD id (only the sequense number, like e.g "100012")

Report name Project order (POD) key figures per item
Report identifier 108579
HTTP method GET
URI https://api.rambase.net/system/reports/108579/result-set?projectOrderId={projectOrderId}
Supported formats Xml, Html, Json (ex. $format=json)
Maximum page size ($top) 80
Successful HTTP status code 200
API resource identifier 5123, version 8

The following body must be added to the request. Mouse over fieldnames for description and other useful information about the fields. Note that fields in bold are required/mandatory.

Format:
1
1

The query string is placed after the resource URL, seperated with a questionmark (?). The query string is composed of a series of query parameters with values. See the page about query parameters on how to use these parameters.

projectOrderId Integer, optional Project order reference

Minimum: 100000
$showDomainDescriptions Boolean, optional Set to "true" to include domain descriptions for fields using domain values. See the Domain values page for more information. Default value is false.
$lang String, optional Specifies the language used in the response, following the 3-letter ISO-639-1 [lll]
$access_token String, optional After successful login you get an access token which needs to be provided in all API requests. Even though it is possible to pass this token as query parameter, we recommended passing it using the HTTP request header as described in Authorization. Note that all access tokens have an expiration time.
$db String, optional Set the database/company for the request
$expand String, optional Use to include output fields that are not returned by default in the response. Accepts a comma-separated list of expandable field names. See the Expand and Select page for more information.
$select String, optional Use to define the fields to return in the response. Accepts a comma-separated list of field names. See the Expand and select page for more information.
$useMinimumVersion Integer, optional Used to run a new version of an API resource when your API client is running a deprecated API resource. See the Breaking changes page for more information.
$format String, optional Set the format of the response to use for the request. Accepted values are "xml", "html", "jsonstream", "json"
$top String, optional Specifies number of rows to return in each page. Maximum limit is specific for each API resource. Default value is 10.
$pageKey String, optional Use to navigate to first, previous, next or last page in list. Add $expand=PagingDetails to add the different keys to the response.
$filter String, optional Use to filter the result list, see the Filtering and sorting page for more information.
$orderby String, optional Use to order the result list, see the Filtering and sorting page for more information.
$inlinecount String, optional Set to "allpages" to include total number of rows in the response. Possible values are: "allpages", "none"

Read more about filters and sorting on how to use filter parameters and named filters.

AccruedPrice Decimal Accrued sales price, in sales currency. Revenues are to be understood as accrued e.g when logged hours have been approved, or when material has been confirmed as consumed.
AccruedQuantity Decimal Accrued quantity. Quantity that has been accrued is to be understood as e.g logged hours that are approved, or material has been confirmed as consumed.
AccruedSale Decimal Accrued revenues, in sales currency. Revenues are to be understood as accrued e.g if logged hours have been approved or when material has been confirmed as consumed.
Category String The category of this project order item: Material, Hours or Expenses.
ConvertedAccruedCost Decimal Accrued cost/{CUR}.
ConvertedAccruedCostPrice Decimal Accrued cost price/{CUR}.
ConvertedAccruedPrice Decimal Accrued price/{CUR}.
ConvertedAccruedSale Decimal Accrued sale/{CUR}.
ConvertedForecastCost Decimal Forecast cost/{CUR}.
ConvertedForecastPrice Decimal Forecast Price/{CUR}.
ConvertedForecastSale Decimal Forecast sale/{CUR}.
ConvertedInitialEstimatedCost Decimal Initial estimated cost/{CUR}.
ConvertedInitialEstimatedCostPrice Decimal Initial estimated cost price/{CUR}.
ConvertedInitialEstimatedPrice Decimal Initial estimated price/{CUR}.
ConvertedInitialEstimatedSale Decimal Initial estimated sale/{CUR}.
ConvertedInvoicedSale Decimal Invoiced sale/{CUR}.
ConvertedPendingCost Decimal Pending cost/{CUR}.
ConvertedPendingCostPrice Decimal Pending cost price/{CUR}.
ConvertedPendingPrice Decimal Pending price/{CUR}.
ConvertedPendingSale Decimal Pending sale/{CUR}.
ConvertedRemainingEstimatedCostPrice Decimal Remaining estimated cost price/{CUR}.
ConvertedRemainingEstimatedPrice Decimal Remaining estimated price/{CUR}.
ConvertedRemainingEstimatedSale Decimal Remaining estimated sale/{CUR}.
DepartmentId Integer Department identifier.
FinanceProjectId Integer Finance project identifier.
ForecastPrice Decimal Forecasted sales price, in sales currency. Is calculated based on remaining, pending and accrued sales price.
ForecastQuantity Decimal Forecasted quantity is an accumulated value of RemainingQty + PendingQty + AccruedQty. It's the total quantity one expect to deliver based on the situation at the moment.
ForecastSale Decimal Forecasted revenues, in sales currency. Is a sum of remaining, pending and accrued revenues.
InitialEstimatedPrice Decimal Initial estimated sales price, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.
InitialEstimatedQuantity Decimal Initial estimated quantity. Will be a copy of the forecasted value at the time the project order is activated.
InitialEstimatedSale Decimal Initial estimated revenues, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.
InvoicedSale Decimal Invoiced revenues, in sales currency.
MarkupPercent Decimal By default calculated based on cost price / sale when a PODITEM is created. Can be changed during the project, it will then recalculated prices.
PendingPrice Decimal Pending sales price, in sales currency. Revenues are to be understood as pending e.g when hours are logged, but not approved by manager (status 3), -or when the internal sales order for "Material to project order" has been created, but material has not been confirmed as consumed yet.
PendingQuantity Decimal Pending quantity. Quantity is to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.
PendingSale Decimal Pending revenues, in sales currency. Revenues are to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.
ProductId Integer Product identifier.
ProductName String Name of the product.
ProjectOrderId Integer Project order identifier.
ProjectOrderItemId Integer Project order item identifier.
RemainingEstimatedPrice Decimal Estimated sales price for the remaining quantity, in sales currency. May be adjusted during the process.
RemainingEstimatedQuantity Decimal Remaining estimated quantity is the expected remaining quantity to deliver. Will e.g be reduced when work hours are logged, but can be manually adjusted anytime.
RemainingEstimatedSale Decimal Estimated revenues for the remaining quantity, in sales currency.
Status String Status of the project order item.

Read more about filters and sorting on how to use sortable parameters

AccruedPrice Decimal Accrued sales price, in sales currency. Revenues are to be understood as accrued e.g when logged hours have been approved, or when material has been confirmed as consumed.
AccruedQuantity Decimal Accrued quantity. Quantity that has been accrued is to be understood as e.g logged hours that are approved, or material has been confirmed as consumed.
AccruedSale Decimal Accrued revenues, in sales currency. Revenues are to be understood as accrued e.g if logged hours have been approved or when material has been confirmed as consumed.
Category String The category of this project order item: Material, Hours or Expenses
ConvertedAccruedCost Decimal Accrued cost/{CUR}
ConvertedAccruedCostPrice Decimal Accrued cost price/{CUR}
ConvertedAccruedPrice Decimal Accrued price/{CUR}
ConvertedAccruedSale Decimal Accrued sale/{CUR}
ConvertedForecastCost Decimal Forecast cost/{CUR}
ConvertedForecastPrice Decimal Forecast Price/{CUR}
ConvertedForecastSale Decimal Forecast sale/{CUR}
ConvertedInitialEstimatedCost Decimal Initial estimated cost/{CUR}
ConvertedInitialEstimatedCostPrice Decimal Initial estimated cost price/{CUR}
ConvertedInitialEstimatedPrice Decimal Initial estimated price/{CUR}
ConvertedInitialEstimatedSale Decimal Initial estimated sale/{CUR}
ConvertedInvoicedSale Decimal Invoiced sale/{CUR}
ConvertedPendingCost Decimal Pending cost/{CUR}
ConvertedPendingCostPrice Decimal Pending cost price/{CUR}
ConvertedPendingPrice Decimal Pending price/{CUR}
ConvertedPendingSale Decimal Pending sale/{CUR}
ConvertedRemainingEstimatedCostPrice Decimal Remaining estimated cost price/{CUR}
ConvertedRemainingEstimatedPrice Decimal Remaining estimated price/{CUR}
ConvertedRemainingEstimatedSale Decimal Remaining estimated sale/{CUR}
DepartmentId Integer Department identifier
FinanceProjectId Integer Finance project identifier
ForecastPrice Decimal Forecasted sales price, in sales currency. Is calculated based on remaining, pending and accrued sales price.
ForecastQuantity Decimal Forecasted quantity is an accumulated value of RemainingQty + PendingQty + AccruedQty. It's the total quantity one expect to deliver based on the situation at the moment.
ForecastSale Decimal Forecasted revenues, in sales currency. Is a sum of remaining, pending and accrued revenues.
InitialEstimatedPrice Decimal Initial estimated sales price, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.
InitialEstimatedQuantity Decimal Initial estimated quantity. Will be a copy of the forecasted value at the time the project order is activated.
InitialEstimatedSale Decimal Initial estimated revenues, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.
InvoicedSale Decimal Invoiced revenues, in sales currency.
MarkupPercent Decimal By default calculated based on cost price / sale when a PODITEM is created. Can be changed during the project, it will then recalculated prices.
PendingPrice Decimal Pending sales price, in sales currency. Revenues are to be understood as pending e.g when hours are logged, but not approved by manager (status 3), -or when the internal sales order for "Material to project order" has been created, but material has not been confirmed as consumed yet.
PendingQuantity Decimal Pending quantity. Quantity is to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.
PendingSale Decimal Pending revenues, in sales currency. Revenues are to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.
ProductId Integer Product identifier
ProductName String Name of the product
ProjectOrderId Integer Project order identifier
ProjectOrderItemId Integer Project order item identifier
RemainingEstimatedPrice Decimal Estimated sales price for the remaining quantity, in sales currency. May be adjusted during the process.
RemainingEstimatedQuantity Decimal Remaining estimated quantity is the expected remaining quantity to deliver. Will e.g be reduced when work hours are logged, but can be manually adjusted anytime.
RemainingEstimatedSale Decimal Estimated revenues for the remaining quantity, in sales currency.
Status String Status of the project order item

Requesting this resource will yield the following response. Mouse over fieldnames (or fieldgroups) for descriptions and other useful information about the fields. Fields colored in grey is expandable fields.

Please note that some fields may be removed from the response, based on user roles/duties/permissions.

Format:
1
<Report>
2
     <Rows>
3
          <Row>
4
               <Status
Status

Status of the project order item

Possible domain values can be found here

>{String}</Status>
5
               <ProjectOrderItem
ProjectOrderItem

Project order item reference

>
6
                    <ProjectOrderItemId
ProjectOrderItemId

Project order item identifier

>{Integer}</ProjectOrderItemId>
7
                    <ProjectOrder
ProjectOrder

Project order reference

>
8
                         <ProjectOrderId
ProjectOrderId

Project order identifier

>{Integer}</ProjectOrderId>
9
                         <Name
Name

Name of the project order

>{String}</Name>
10
                         <ProjectOrderLink
ProjectOrderLink

Project order reference

>{String}</ProjectOrderLink>
11
                    </ProjectOrder>
12
                    <ProjectOrderItemLink
ProjectOrderItemLink

Project order item reference

>{String}</ProjectOrderItemLink>
13
               </ProjectOrderItem>
14
               <Category
Category

The category of this project order item: Material, Hours or Expenses

Possible domain values can be found here

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Category in your request URI to get this field

>{String}</Category>
15
               <Product
Product

Product reference

>
16
                    <ProductId
ProductId

Product identifier

>{Integer}</ProductId>
17
                    <Name
Name

Name of the product

>{String}</Name>
18
                    <Description
Description

Description of the product

>{String}</Description>
19
                    <ProductLink
ProductLink

Product reference

>{String}</ProductLink>
20
               </Product>
21
               <MarkupPercent
MarkupPercent

By default calculated based on cost price / sale when a PODITEM is created. Can be changed during the project, it will then recalculated prices.

>{Decimal}</MarkupPercent>
22
               <InitialEstimatedQuantity
InitialEstimatedQuantity

Initial estimated quantity. Will be a copy of the forecasted value at the time the project order is activated.

>{Decimal}</InitialEstimatedQuantity>
23
               <SalesCurrency
SalesCurrency

Sales currency for project order

>{String}</SalesCurrency>
24
               <ConvertedInitialEstimatedCostPrice
ConvertedInitialEstimatedCostPrice

Initial estimated cost price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedInitialEstimatedCostPrice in your request URI to get this field

>{Decimal}</ConvertedInitialEstimatedCostPrice>
25
               <ConvertedInitialEstimatedCost
ConvertedInitialEstimatedCost

Initial estimated cost/{CUR}

>{Decimal}</ConvertedInitialEstimatedCost>
26
               <InitialEstimatedPrice
InitialEstimatedPrice

Initial estimated sales price, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.InitialEstimatedPrice in your request URI to get this field

>{Decimal}</InitialEstimatedPrice>
27
               <InitialEstimatedSale
InitialEstimatedSale

Initial estimated revenues, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.InitialEstimatedSale in your request URI to get this field

>{Decimal}</InitialEstimatedSale>
28
               <ConvertedInitialEstimatedPrice
ConvertedInitialEstimatedPrice

Initial estimated price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedInitialEstimatedPrice in your request URI to get this field

>{Decimal}</ConvertedInitialEstimatedPrice>
29
               <ConvertedInitialEstimatedSale
ConvertedInitialEstimatedSale

Initial estimated sale/{CUR}

>{Decimal}</ConvertedInitialEstimatedSale>
30
               <RemainingEstimatedQuantity
RemainingEstimatedQuantity

Remaining estimated quantity is the expected remaining quantity to deliver. Will e.g be reduced when work hours are logged, but can be manually adjusted anytime.

>{Decimal}</RemainingEstimatedQuantity>
31
               <ConvertedRemainingEstimatedCostPrice
ConvertedRemainingEstimatedCostPrice

Remaining estimated cost price/{CUR}

>{Decimal}</ConvertedRemainingEstimatedCostPrice>
32
               <ConvertedRemainingEstimatedCost
ConvertedRemainingEstimatedCost

Remaining estimated cost/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedRemainingEstimatedCost in your request URI to get this field

>{Decimal}</ConvertedRemainingEstimatedCost>
33
               <RemainingEstimatedPrice
RemainingEstimatedPrice

Estimated sales price for the remaining quantity, in sales currency. May be adjusted during the process.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.RemainingEstimatedPrice in your request URI to get this field

>{Decimal}</RemainingEstimatedPrice>
34
               <RemainingEstimatedSale
RemainingEstimatedSale

Estimated revenues for the remaining quantity, in sales currency.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.RemainingEstimatedSale in your request URI to get this field

>{Decimal}</RemainingEstimatedSale>
35
               <ConvertedRemainingEstimatedPrice
ConvertedRemainingEstimatedPrice

Remaining estimated price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedRemainingEstimatedPrice in your request URI to get this field

>{Decimal}</ConvertedRemainingEstimatedPrice>
36
               <ConvertedRemainingEstimatedSale
ConvertedRemainingEstimatedSale

Remaining estimated sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedRemainingEstimatedSale in your request URI to get this field

>{Decimal}</ConvertedRemainingEstimatedSale>
37
               <PendingQuantity
PendingQuantity

Pending quantity. Quantity is to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.

>{Decimal}</PendingQuantity>
38
               <ConvertedPendingCostPrice
ConvertedPendingCostPrice

Pending cost price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedPendingCostPrice in your request URI to get this field

>{Decimal}</ConvertedPendingCostPrice>
39
               <ConvertedPendingCost
ConvertedPendingCost

Pending cost/{CUR}

>{Decimal}</ConvertedPendingCost>
40
               <PendingPrice
PendingPrice

Pending sales price, in sales currency. Revenues are to be understood as pending e.g when hours are logged, but not approved by manager (status 3), -or when the internal sales order for "Material to project order" has been created, but material has not been confirmed as consumed yet.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.PendingPrice in your request URI to get this field

>{Decimal}</PendingPrice>
41
               <PendingSale
PendingSale

Pending revenues, in sales currency. Revenues are to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.PendingSale in your request URI to get this field

>{Decimal}</PendingSale>
42
               <ConvertedPendingPrice
ConvertedPendingPrice

Pending price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedPendingPrice in your request URI to get this field

>{Decimal}</ConvertedPendingPrice>
43
               <ConvertedPendingSale
ConvertedPendingSale

Pending sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedPendingSale in your request URI to get this field

>{Decimal}</ConvertedPendingSale>
44
               <AccruedQuantity
AccruedQuantity

Accrued quantity. Quantity that has been accrued is to be understood as e.g logged hours that are approved, or material has been confirmed as consumed.

>{Decimal}</AccruedQuantity>
45
               <ConvertedAccruedCostPrice
ConvertedAccruedCostPrice

Accrued cost price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedAccruedCostPrice in your request URI to get this field

>{Decimal}</ConvertedAccruedCostPrice>
46
               <ConvertedAccruedCost
ConvertedAccruedCost

Accrued cost/{CUR}

>{Decimal}</ConvertedAccruedCost>
47
               <AccruedPrice
AccruedPrice

Accrued sales price, in sales currency. Revenues are to be understood as accrued e.g when logged hours have been approved, or when material has been confirmed as consumed.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.AccruedPrice in your request URI to get this field

>{Decimal}</AccruedPrice>
48
               <AccruedSale
AccruedSale

Accrued revenues, in sales currency. Revenues are to be understood as accrued e.g if logged hours have been approved or when material has been confirmed as consumed.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.AccruedSale in your request URI to get this field

>{Decimal}</AccruedSale>
49
               <ConvertedAccruedPrice
ConvertedAccruedPrice

Accrued price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedAccruedPrice in your request URI to get this field

>{Decimal}</ConvertedAccruedPrice>
50
               <ConvertedAccruedSale
ConvertedAccruedSale

Accrued sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedAccruedSale in your request URI to get this field

>{Decimal}</ConvertedAccruedSale>
51
               <ForecastQuantity
ForecastQuantity

Forecasted quantity is an accumulated value of RemainingQty + PendingQty + AccruedQty. It's the total quantity one expect to deliver based on the situation at the moment.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ForecastQuantity in your request URI to get this field

>{Decimal}</ForecastQuantity>
52
               <ConvertedForecastCost
ConvertedForecastCost

Forecast cost/{CUR}

>{Decimal}</ConvertedForecastCost>
53
               <ForecastPrice
ForecastPrice

Forecasted sales price, in sales currency. Is calculated based on remaining, pending and accrued sales price.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ForecastPrice in your request URI to get this field

>{Decimal}</ForecastPrice>
54
               <ForecastSale
ForecastSale

Forecasted revenues, in sales currency. Is a sum of remaining, pending and accrued revenues.

>{Decimal}</ForecastSale>
55
               <ConvertedForecastPrice
ConvertedForecastPrice

Forecast Price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedForecastPrice in your request URI to get this field

>{Decimal}</ConvertedForecastPrice>
56
               <ConvertedForecastSale
ConvertedForecastSale

Forecast sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedForecastSale in your request URI to get this field

>{Decimal}</ConvertedForecastSale>
57
               <InvoicedSale
InvoicedSale

Invoiced revenues, in sales currency.

>{Decimal}</InvoicedSale>
58
               <ConvertedInvoicedSale
ConvertedInvoicedSale

Invoiced sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedInvoicedSale in your request URI to get this field

>{Decimal}</ConvertedInvoicedSale>
59
               <FinanceProject
FinanceProject

The finance project related to the item. One of the system/fixed account dimensions.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

>
60
                    <FinanceProjectId
FinanceProjectId

Finance project identifier

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

>{Integer}</FinanceProjectId>
61
                    <Name
Name

Name of finance project

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

>{String}</Name>
62
                    <FinanceProjectLink
FinanceProjectLink

Finance project reference

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

>{String}</FinanceProjectLink>
63
               </FinanceProject>
64
               <Department
Department

The department related to the item. One of the system/fixed account dimensions.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

>
65
                    <DepartmentId
DepartmentId

Department identifier

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

>{Integer}</DepartmentId>
66
                    <Name
Name

Name of finance project

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

>{String}</Name>
67
                    <DepartmentLink
DepartmentLink

Finance department reference

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

>{String}</DepartmentLink>
68
               </Department>
69
               <Inspect>
70
                    <TargetApplication
TargetApplication

Application reference when inspecting a line in a report.

>{String}</TargetApplication>
71
               </Inspect>
72
          </Row>
73
     </Rows>
74
     <ColumnParameters
ColumnParameters

This field is greyed out because it is an expandable field. You have to add $expand=ColumnParameters in your request URI to get this field

>
75
          <ColumnParameter
ColumnParameter

This field is greyed out because it is an expandable field. You have to add $expand=ColumnParameters in your request URI to get this field

>
76
               <Key
Key

Key that is used in description to lookup value from COS. The key is referenced by encapsulating it in curly braces.

This field is greyed out because it is an expandable field. You have to add $expand=ColumnParameters in your request URI to get this field

>{String}</Key>
77
               <Value
Value

The value of the column parameter from COS that will be shown in the column headers referencing the column parameter key.

This field is greyed out because it is an expandable field. You have to add $expand=ColumnParameters in your request URI to get this field

>{String}</Value>
78
          </ColumnParameter>
79
     </ColumnParameters>
80
     <Paging
Paging

Detailed paging information for this list.

>
81
          <PageSize
PageSize

Number of elements in the list, as defined in $top. Default is 10.

>{Integer}</PageSize>
82
          <Position
Position

Position of the first element in the list

>{Integer}</Position>
83
          <Page
Page

Page index

>{Integer}</Page>
84
          <FirstPageKey
FirstPageKey

Page key to use for navigating to the first page in the list

This field is greyed out because it is an expandable field. You have to add $expand=PagingDetails in your request URI to get this field

>{String}</FirstPageKey>
85
          <FirstPage
FirstPage

Link to the first page in the list. $pageKey is set to FirstPageKey.

>{String}</FirstPage>
86
          <PreviousPageKey
PreviousPageKey

Page key to use for navigating to previous page in the list

This field is greyed out because it is an expandable field. You have to add $expand=PagingDetails in your request URI to get this field

>{String}</PreviousPageKey>
87
          <PreviousPage
PreviousPage

Link to the previous page in the list. $pageKey is set to PreviousPageKey.

>{String}</PreviousPage>
88
          <NextPageKey
NextPageKey

Page key to use for navigating to next page in the list

This field is greyed out because it is an expandable field. You have to add $expand=PagingDetails in your request URI to get this field

>{String}</NextPageKey>
89
          <NextPage
NextPage

Link to the next page in the list. $pageKey is set to NextPageKey.

>{String}</NextPage>
90
          <LastPageKey
LastPageKey

Page key to use for navigating to last page in the list

This field is greyed out because it is an expandable field. You have to add $expand=PagingDetails in your request URI to get this field

>{String}</LastPageKey>
91
          <LastPage
LastPage

Link to the last page in the list. $pageKey is set to LastPageKey.

>{String}</LastPage>
92
          <Size
Size

Total number of records in the list. Use $inlinecount=allpages in the request uri to include this

>{Integer}</Size>
93
     </Paging>
94
</Report>
1
{
2
     "report": {
3
          "rows": [
4
               {
5
                    "status
Status

Status of the project order item

Possible domain values can be found here

": "{String}",
6
                    "projectOrderItem
ProjectOrderItem

Project order item reference

": {
7
                         "projectOrderItemId
ProjectOrderItemId

Project order item identifier

": "{Integer}",
8
                         "projectOrder
ProjectOrder

Project order reference

": {
9
                              "projectOrderId
ProjectOrderId

Project order identifier

": "{Integer}",
10
                              "name
Name

Name of the project order

": "{String}",
11
                              "projectOrderLink
ProjectOrderLink

Project order reference

": "{String}"
12
                         },
13
                         "projectOrderItemLink
ProjectOrderItemLink

Project order item reference

": "{String}"
14
                    },
15
                    "category
Category

The category of this project order item: Material, Hours or Expenses

Possible domain values can be found here

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Category in your request URI to get this field

": "{String}",
16
                    "product
Product

Product reference

": {
17
                         "productId
ProductId

Product identifier

": "{Integer}",
18
                         "name
Name

Name of the product

": "{String}",
19
                         "description
Description

Description of the product

": "{String}",
20
                         "productLink
ProductLink

Product reference

": "{String}"
21
                    },
22
                    "markupPercent
MarkupPercent

By default calculated based on cost price / sale when a PODITEM is created. Can be changed during the project, it will then recalculated prices.

": "{Decimal}",
23
                    "initialEstimatedQuantity
InitialEstimatedQuantity

Initial estimated quantity. Will be a copy of the forecasted value at the time the project order is activated.

": "{Decimal}",
24
                    "salesCurrency
SalesCurrency

Sales currency for project order

": "{String}",
25
                    "convertedInitialEstimatedCostPrice
ConvertedInitialEstimatedCostPrice

Initial estimated cost price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedInitialEstimatedCostPrice in your request URI to get this field

": "{Decimal}",
26
                    "convertedInitialEstimatedCost
ConvertedInitialEstimatedCost

Initial estimated cost/{CUR}

": "{Decimal}",
27
                    "initialEstimatedPrice
InitialEstimatedPrice

Initial estimated sales price, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.InitialEstimatedPrice in your request URI to get this field

": "{Decimal}",
28
                    "initialEstimatedSale
InitialEstimatedSale

Initial estimated revenues, in sales currency. Will be a copy of the forecasted value at the time the project order is activated.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.InitialEstimatedSale in your request URI to get this field

": "{Decimal}",
29
                    "convertedInitialEstimatedPrice
ConvertedInitialEstimatedPrice

Initial estimated price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedInitialEstimatedPrice in your request URI to get this field

": "{Decimal}",
30
                    "convertedInitialEstimatedSale
ConvertedInitialEstimatedSale

Initial estimated sale/{CUR}

": "{Decimal}",
31
                    "remainingEstimatedQuantity
RemainingEstimatedQuantity

Remaining estimated quantity is the expected remaining quantity to deliver. Will e.g be reduced when work hours are logged, but can be manually adjusted anytime.

": "{Decimal}",
32
                    "convertedRemainingEstimatedCostPrice
ConvertedRemainingEstimatedCostPrice

Remaining estimated cost price/{CUR}

": "{Decimal}",
33
                    "convertedRemainingEstimatedCost
ConvertedRemainingEstimatedCost

Remaining estimated cost/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedRemainingEstimatedCost in your request URI to get this field

": "{Decimal}",
34
                    "remainingEstimatedPrice
RemainingEstimatedPrice

Estimated sales price for the remaining quantity, in sales currency. May be adjusted during the process.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.RemainingEstimatedPrice in your request URI to get this field

": "{Decimal}",
35
                    "remainingEstimatedSale
RemainingEstimatedSale

Estimated revenues for the remaining quantity, in sales currency.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.RemainingEstimatedSale in your request URI to get this field

": "{Decimal}",
36
                    "convertedRemainingEstimatedPrice
ConvertedRemainingEstimatedPrice

Remaining estimated price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedRemainingEstimatedPrice in your request URI to get this field

": "{Decimal}",
37
                    "convertedRemainingEstimatedSale
ConvertedRemainingEstimatedSale

Remaining estimated sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedRemainingEstimatedSale in your request URI to get this field

": "{Decimal}",
38
                    "pendingQuantity
PendingQuantity

Pending quantity. Quantity is to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.

": "{Decimal}",
39
                    "convertedPendingCostPrice
ConvertedPendingCostPrice

Pending cost price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedPendingCostPrice in your request URI to get this field

": "{Decimal}",
40
                    "convertedPendingCost
ConvertedPendingCost

Pending cost/{CUR}

": "{Decimal}",
41
                    "pendingPrice
PendingPrice

Pending sales price, in sales currency. Revenues are to be understood as pending e.g when hours are logged, but not approved by manager (status 3), -or when the internal sales order for "Material to project order" has been created, but material has not been confirmed as consumed yet.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.PendingPrice in your request URI to get this field

": "{Decimal}",
42
                    "pendingSale
PendingSale

Pending revenues, in sales currency. Revenues are to be understood as pending e.g if hours are logged, but yet not approved by manager (status 3), or when the internal sales order for "Material to project order" has been created, but material is not confirmed as consumed yet.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.PendingSale in your request URI to get this field

": "{Decimal}",
43
                    "convertedPendingPrice
ConvertedPendingPrice

Pending price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedPendingPrice in your request URI to get this field

": "{Decimal}",
44
                    "convertedPendingSale
ConvertedPendingSale

Pending sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedPendingSale in your request URI to get this field

": "{Decimal}",
45
                    "accruedQuantity
AccruedQuantity

Accrued quantity. Quantity that has been accrued is to be understood as e.g logged hours that are approved, or material has been confirmed as consumed.

": "{Decimal}",
46
                    "convertedAccruedCostPrice
ConvertedAccruedCostPrice

Accrued cost price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedAccruedCostPrice in your request URI to get this field

": "{Decimal}",
47
                    "convertedAccruedCost
ConvertedAccruedCost

Accrued cost/{CUR}

": "{Decimal}",
48
                    "accruedPrice
AccruedPrice

Accrued sales price, in sales currency. Revenues are to be understood as accrued e.g when logged hours have been approved, or when material has been confirmed as consumed.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.AccruedPrice in your request URI to get this field

": "{Decimal}",
49
                    "accruedSale
AccruedSale

Accrued revenues, in sales currency. Revenues are to be understood as accrued e.g if logged hours have been approved or when material has been confirmed as consumed.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.AccruedSale in your request URI to get this field

": "{Decimal}",
50
                    "convertedAccruedPrice
ConvertedAccruedPrice

Accrued price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedAccruedPrice in your request URI to get this field

": "{Decimal}",
51
                    "convertedAccruedSale
ConvertedAccruedSale

Accrued sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedAccruedSale in your request URI to get this field

": "{Decimal}",
52
                    "forecastQuantity
ForecastQuantity

Forecasted quantity is an accumulated value of RemainingQty + PendingQty + AccruedQty. It's the total quantity one expect to deliver based on the situation at the moment.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ForecastQuantity in your request URI to get this field

": "{Decimal}",
53
                    "convertedForecastCost
ConvertedForecastCost

Forecast cost/{CUR}

": "{Decimal}",
54
                    "forecastPrice
ForecastPrice

Forecasted sales price, in sales currency. Is calculated based on remaining, pending and accrued sales price.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ForecastPrice in your request URI to get this field

": "{Decimal}",
55
                    "forecastSale
ForecastSale

Forecasted revenues, in sales currency. Is a sum of remaining, pending and accrued revenues.

": "{Decimal}",
56
                    "convertedForecastPrice
ConvertedForecastPrice

Forecast Price/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedForecastPrice in your request URI to get this field

": "{Decimal}",
57
                    "convertedForecastSale
ConvertedForecastSale

Forecast sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedForecastSale in your request URI to get this field

": "{Decimal}",
58
                    "invoicedSale
InvoicedSale

Invoiced revenues, in sales currency.

": "{Decimal}",
59
                    "convertedInvoicedSale
ConvertedInvoicedSale

Invoiced sale/{CUR}

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.ConvertedInvoicedSale in your request URI to get this field

": "{Decimal}",
60
                    "financeProject
FinanceProject

The finance project related to the item. One of the system/fixed account dimensions.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

": {
61
                         "financeProjectId
FinanceProjectId

Finance project identifier

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

": "{Integer}",
62
                         "name
Name

Name of finance project

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

": "{String}",
63
                         "financeProjectLink
FinanceProjectLink

Finance project reference

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.FinanceProject in your request URI to get this field

": "{String}"
64
                    },
65
                    "department
Department

The department related to the item. One of the system/fixed account dimensions.

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

": {
66
                         "departmentId
DepartmentId

Department identifier

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

": "{Integer}",
67
                         "name
Name

Name of finance project

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

": "{String}",
68
                         "departmentLink
DepartmentLink

Finance department reference

This field is greyed out because it is an expandable field. You have to add $expand=Rows.Row.Department in your request URI to get this field

": "{String}"
69
                    },
70
                    "inspect": {
71
                         "targetApplication
TargetApplication

Application reference when inspecting a line in a report.

": "{String}"
72
                    }
73
               }
74
          ],
75
          "columnParameters
ColumnParameters

This field is greyed out because it is an expandable field. You have to add $expand=ColumnParameters in your request URI to get this field

": [
76
               {
77
                    "key
Key

Key that is used in description to lookup value from COS. The key is referenced by encapsulating it in curly braces.

This field is greyed out because it is an expandable field. You have to add $expand=ColumnParameters in your request URI to get this field

": "{String}",
78
                    "value
Value

The value of the column parameter from COS that will be shown in the column headers referencing the column parameter key.

This field is greyed out because it is an expandable field. You have to add $expand=ColumnParameters in your request URI to get this field

": "{String}"
79
               }
80
          ]
81
     }
82
}

List of available operations/actions for this resource.
See the operations documentation for more information about API operations.

Possible error codes the response might return:

Error 104920 HTTP 400 Log text is required
Error 104921 HTTP 400 Invalid log category
Error 101281 HTTP 400 Too many {0} parameters. Maximum is {1}.
Error 100175 HTTP 400 To date must be equal to, or later than from date.
Error 105710 HTTP 400 Invalid output type