API

Sales APIs

GET sales/invoices/{salesInvoiceId}/items/{itemId}

Details about a specific item of an invoice

HTTP method GET
URI https://api.rambase.net/sales/invoices/{salesInvoiceId}/items/{itemId}
Supported formats Xml, Html, Json (ex. $format=json)
- URI parameter {salesInvoiceId} Sales invoice identifier
Integer, minimum 100000
- URI parameter {itemId} Item-/line-number of the invoice
Integer, minimum 1
Custom fields Custom fields supported
Successful HTTP status code 200
API resource identifier 2363, version 29

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.

$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
$format String, optional Set the format of the response to use for the request. Accepted values are "xml", "html", "jsonstream", "json"
$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.
$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.
$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.
$showCustomFields Boolean, optional Set to "true" to include custom fields. Default value is false.

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

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

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
<SalesInvoiceItem>
2
     <SalesInvoiceItemId
SalesInvoiceItemId

Item-/line-number of the invoice

>{Integer}</SalesInvoiceItemId>
3
     <Status
Status

Status code of the the invoice item

Possible domain values can be found here

>{Integer}</Status>
4
     <CreatedAt
CreatedAt

Date and time of creation

>{Datetime}</CreatedAt>
5
     <LineNumber
LineNumber

Line- or sequence number of the item. The LineNumber is used for sorting items in applications, prints, reports etc.

>{Integer}</LineNumber>
6
     <CustomersReferenceNumber
CustomersReferenceNumber

Customers item reference number. Typically to the customers internal system.

>{String}</CustomersReferenceNumber>
7
     <CustomersProductName
CustomersProductName

Customers internal name of the product. Retrieved from the product.

>{String}</CustomersProductName>
8
     <EquivalentProductName
EquivalentProductName

Name of product with equivalent behavior and attributes. Can be used for same purpose.

>{String}</EquivalentProductName>
9
     <ProductDescription
ProductDescription

Description of the item. If not specified, the description is by default copied from the product.

>{String}</ProductDescription>
10
     <Note
Note

Additional information regarding the item (free text). Might be visible to customers/suppliers.

>{String}</Note>
11
     <GrossMargin
GrossMargin

Gross margin of the item.

>{Decimal}</GrossMargin>
12
     <VATPercent
VATPercent

Value added tax percent

>{Decimal}</VATPercent>
13
     <DiscountPercent
DiscountPercent

The discount in percent for this item.

>{Decimal}</DiscountPercent>
14
     <Quantity
Quantity

Quantity of sales invoice item

>{Decimal}</Quantity>
15
     <DeliveryDate
DeliveryDate

The date on which the supply of goods or services was made or completed.

>{Date}</DeliveryDate>
16
     <CountryOfOriginCode
CountryOfOriginCode

Two-character code (ISO 3166) identifying the default country where the product is produced. This value is inherrited from the assigned goods reception(s). If not country of origin is specified for the goods reception(s), country of origin is retrieved from the product. If assigned to multiple goods receptions with different origin, the field will be empty.

>{String}</CountryOfOriginCode>
17
     <EndCustomer
EndCustomer

End customer

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

>
18
          <CustomerId
CustomerId

Customer identifier

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

>{Integer}</CustomerId>
19
          <Name
Name

Name of customer (name of company or surname/familyname/lastname of a person)

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

>{String}</Name>
20
          <FirstName
FirstName

Secondary name of a company or firstname of a person

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

>{String}</FirstName>
21
          <VATRegistrationNumber
VATRegistrationNumber

Unique number assigned by the relevant tax authority to identify a party for use in relation to value added tax (VAT).

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

>{String}</VATRegistrationNumber>
22
          <CustomerLink
CustomerLink

Customer reference

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

>{String}</CustomerLink>
23
     </EndCustomer>
24
     <RequestedProductRevision>
25
          <Revision
Revision

The revision will typically be a major change, as opposed to minor changes stored in the version of the product structure.

>{String}</Revision>
26
     </RequestedProductRevision>
27
     <ExchangeRateFluctuation>
28
          <Currency
Currency

Three character code following the ISO 4217 standard

>{String}</Currency>
29
          <Amount
Amount

Represents the exchange rate fluctuation amount

>{Decimal}</Amount>
30
          <Percent
Percent

The percent of change that resulted in fluctuation price change

>{Decimal}</Percent>
31
     </ExchangeRateFluctuation>
32
     <Price>
33
          <Currency
Currency

Three character code following the ISO 4217 standard

>{String}</Currency>
34
          <GrossPrice
GrossPrice

Represents the price per unit before any discounting is applied.

>{Decimal}</GrossPrice>
35
          <Discount
Discount

The discount for the item.

>{Decimal}</Discount>
36
          <NetPrice
NetPrice

Final price per unit after deducting all discounts etc.

>{Decimal}</NetPrice>
37
     </Price>
38
     <PriceConverted
PriceConverted

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

>
39
          <Currency
Currency

Three character code following the ISO 4217 standard

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

>{String}</Currency>
40
          <GrossPrice
GrossPrice

Represents the price per unit before any discounting is applied.

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

>{Decimal}</GrossPrice>
41
          <NetPrice
NetPrice

Final price per unit after deducting all discounts.

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

>{Decimal}</NetPrice>
42
     </PriceConverted>
43
     <Totals>
44
          <Currency
Currency

Three character code following the ISO 4217 standard

>{String}</Currency>
45
          <GrossAmount
GrossAmount

Represents the item amount before any discounts etc. is applied.

>{Decimal}</GrossAmount>
46
          <DiscountAmount
DiscountAmount

The items discount amount.

>{Decimal}</DiscountAmount>
47
          <NetAmount
NetAmount

Final item amount after deducting all discounts etc.

>{Decimal}</NetAmount>
48
     </Totals>
49
     <TotalsConverted
TotalsConverted

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

>
50
          <Currency
Currency

Three character code following the ISO 4217 standard

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

>{String}</Currency>
51
          <GrossAmount
GrossAmount

Total gross amount in company currency.

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

>{Decimal}</GrossAmount>
52
          <NetAmount
NetAmount

Total net amount in company currency.

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

>{Decimal}</NetAmount>
53
     </TotalsConverted>
54
     <Seller
Seller

Reference to the seller of the item

>
55
          <EmployeeId
EmployeeId

Employee identifier

>{Integer}</EmployeeId>
56
          <FirstName
FirstName

First name of employee

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

>{String}</FirstName>
57
          <LastName
LastName

Last name of employee

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

>{String}</LastName>
58
          <EmployeeLink
EmployeeLink

Employee reference

>{String}</EmployeeLink>
59
     </Seller>
60
     <MeasurementUnit>
61
          <MeasurementUnitId
MeasurementUnitId

Measurement unit identifier

>{Integer}</MeasurementUnitId>
62
          <Unit
Unit

Measurement unit (ex. mm, km, dl, kg)

>{String}</Unit>
63
          <MeasurementUnitLink
MeasurementUnitLink

Material unit reference

>{String}</MeasurementUnitLink>
64
     </MeasurementUnit>
65
     <Product>
66
          <ProductId
ProductId

Product identifier

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

Name of the product

>{String}</Name>
68
          <Type
Type

Type of product

Possible domain values can be found here

>{String}</Type>
69
          <CustomField1
CustomField1

Custom field for grouping, sorting, categorizing and other purposes.

>{String}</CustomField1>
70
          <CustomField2
CustomField2

Custom field for grouping, sorting, categorizing and other purposes.

>{String}</CustomField2>
71
          <Manufacturer>
72
               <ManufacturerId
ManufacturerId

Manufacturer identifier

>{Integer}</ManufacturerId>
73
               <Name
Name

Company name of the manufacturer.

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

>{String}</Name>
74
               <ShortName
ShortName

Shortname/code of the manufacturer

>{String}</ShortName>
75
               <ManufacturerLink
ManufacturerLink

Manufacturer reference

>{String}</ManufacturerLink>
76
          </Manufacturer>
77
          <ProductClassification>
78
               <ProductClassificationId
ProductClassificationId

Product classification identifier

>{String}</ProductClassificationId>
79
               <ProductClassificationLink
ProductClassificationLink

Product classification reference

>{String}</ProductClassificationLink>
80
          </ProductClassification>
81
          <ProductLink
ProductLink

Product reference

>{String}</ProductLink>
82
     </Product>
83
     <LandedCost>
84
          <PurchaseCurrency
PurchaseCurrency

Purchase currency is the currency this product normally is purchased in. This is also the base currency used in the gross margin calculation. By default the purchase currency is retrieved from the product.

Possible domain values can be found here

>{String}</PurchaseCurrency>
85
          <PurchasePrice
PurchasePrice

Purchase price for each unit

>{Decimal}</PurchasePrice>
86
          <Freight
Freight

Estimated freight cost of getting each unit in stock. Used for calculating landed cost.

>{Decimal}</Freight>
87
          <Duty
Duty

Duty cost of getting each unit in stock. Used for calculating landed cost.

>{Decimal}</Duty>
88
          <Charge
Charge

Other costs of getting each unit in stock. Used for calculating landed cost.

>{Decimal}</Charge>
89
          <GrossPrice
GrossPrice

Total cost (landed cost or true cost) of getting each unit in stock, including purchase price, duties, charges, freight etc.

>{Decimal}</GrossPrice>
90
          <PurchaseExchangeRate
PurchaseExchangeRate

Exchange rate between document currency and purchase currency. Used in landed cost calculations.

>{Decimal}</PurchaseExchangeRate>
91
          <IsDerivedFromUserInput
IsDerivedFromUserInput

True if landed cost is derived from manual user input. Landed cost can only be manually updated for products without assignments

>{Boolean}</IsDerivedFromUserInput>
92
          <IsDerivedFromPreferredPurchasePrice
IsDerivedFromPreferredPurchasePrice

True if the landed cost for this item is derived from preferred purchase price. This means that parts (or all) of the item has not reserved goods in stock, nor incoming goods (supplier backlog or production backlog).

>{Boolean}</IsDerivedFromPreferredPurchasePrice>
93
          <IsDerivedFromAssignedSupplierBacklog
IsDerivedFromAssignedSupplierBacklog

True if landed cost for this item is derived from assigned supplier backlog. This means that the item has reserved incoming goods (supplier backlog or production backlog).

>{Boolean}</IsDerivedFromAssignedSupplierBacklog>
94
          <IsDerivedFromAssignedStock
IsDerivedFromAssignedStock

True if landed cost for this item is derived from assigned stock. This means that the item has reserved goods in stock.

>{Boolean}</IsDerivedFromAssignedStock>
95
          <DerivedFrom>
96
               <PurchaseQuoteItemId
PurchaseQuoteItemId

Purchase quote item identifier

>{Integer}</PurchaseQuoteItemId>
97
               <PurchaseQuote>
98
                    <Database
Database

Database of the object

>{String}</Database>
99
                    <PurchaseQuoteId
PurchaseQuoteId

Purchase quote identifier

>{Integer}</PurchaseQuoteId>
100
                    <PurchaseQuoteLink
PurchaseQuoteLink

Purchase quote reference

>{String}</PurchaseQuoteLink>
101
               </PurchaseQuote>
102
               <PurchaseQuoteItemLink
PurchaseQuoteItemLink

Purchase quote item link

>{String}</PurchaseQuoteItemLink>
103
          </DerivedFrom>
104
     </LandedCost>
105
     <LandedCostConverted
LandedCostConverted

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

>
106
          <Currency
Currency

Three character code following the ISO 4217 standard

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

>{String}</Currency>
107
          <PurchasePrice
PurchasePrice

Purchase price in sales currency.

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

>{Decimal}</PurchasePrice>
108
          <Freight
Freight

Freigth cost in sales currency.

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

>{Decimal}</Freight>
109
          <Duty
Duty

Duty costs in sales currency.

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

>{Decimal}</Duty>
110
          <Charge
Charge

Other cost in sales currency

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

>{Decimal}</Charge>
111
          <GrossPrice
GrossPrice

Total cost (landed cost or true cost) in sales currency

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

>{Decimal}</GrossPrice>
112
     </LandedCostConverted>
113
     <Accounting
Accounting

Accounting details for the item, including fixed/system dimensions. For all dimensions, see seperate resource.

>
114
          <VATCodeDefinition>
115
               <VATCode
VATCode

Code that determines VAT rules used for VAT calculations.

>{String}</VATCode>
116
               <Description
Description

Description of VAT Code definition

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

>{String}</Description>
117
          </VATCodeDefinition>
118
          <GeneralLedgerAccount>
119
               <GeneralLedgerAccountId
GeneralLedgerAccountId

General ledger account identifier

>{Integer}</GeneralLedgerAccountId>
120
               <GeneralLedgerAccountLink
GeneralLedgerAccountLink

General ledger account reference

>{String}</GeneralLedgerAccountLink>
121
          </GeneralLedgerAccount>
122
          <Department
Department

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

>
123
               <DepartmentId
DepartmentId

Department identifier

>{Integer}</DepartmentId>
124
               <DepartmentLink
DepartmentLink

Finance department reference

>{String}</DepartmentLink>
125
          </Department>
126
          <FinanceProject
FinanceProject

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

>
127
               <FinanceProjectId
FinanceProjectId

Finance project identifier

>{Integer}</FinanceProjectId>
128
               <FinanceProjectLink
FinanceProjectLink

Finance project reference

>{String}</FinanceProjectLink>
129
          </FinanceProject>
130
          <Asset
Asset

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

>
131
               <AssetId
AssetId

Asset identifier

>{Integer}</AssetId>
132
               <AssetLink
AssetLink

Asset reference

>{String}</AssetLink>
133
          </Asset>
134
          <CustomDimensions
CustomDimensions

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

>
135
               <Dimension
Dimension

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

>
136
                    <Value
Value

Value for this dimension defintion.

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

>{String}</Value>
137
                    <Description
Description

Description of the dimension value.

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

>{String}</Description>
138
                    <DimensionDefinition
DimensionDefinition

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

>
139
                         <DimensionDefinitionId
DimensionDefinitionId

Dimension identifier

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

>{Integer}</DimensionDefinitionId>
140
                         <Name
Name

Name of dimension

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

>{String}</Name>
141
                         <DimensionDefinitionLink
DimensionDefinitionLink

Dimension reference

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

>{String}</DimensionDefinitionLink>
142
                    </DimensionDefinition>
143
               </Dimension>
144
          </CustomDimensions>
145
     </Accounting>
146
     <ForwardedFrom
ForwardedFrom

The preceding/previous/source item.

>
147
          <ForwardedFromItem>
148
               <ItemId
ItemId

Identifier of the object

>{Integer}</ItemId>
149
               <Object>
150
                    <ObjectId
ObjectId

Identifier of the object

>{Integer}</ObjectId>
151
                    <ObjectType
ObjectType

Type of object

>{String}</ObjectType>
152
                    <ObjectLink
ObjectLink

API reference to the object

>{String}</ObjectLink>
153
               </Object>
154
               <RamBaseKey
RamBaseKey

Internal RamBase identifier of the object/item

>{String}</RamBaseKey>
155
               <ItemLink
ItemLink

API reference to the item

>{String}</ItemLink>
156
          </ForwardedFromItem>
157
     </ForwardedFrom>
158
     <InitialSalesOrderItem
InitialSalesOrderItem

Reference to the initial/first/original sales order item in the document flow for this item.

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

>
159
          <SalesOrderItemId
SalesOrderItemId

Sales order item identifier

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

>{Integer}</SalesOrderItemId>
160
          <SalesOrder
SalesOrder

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

>
161
               <SalesOrderId
SalesOrderId

Sales order identifier

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

>{Integer}</SalesOrderId>
162
               <RegistrationDate
RegistrationDate

Date of registration

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

>{Date}</RegistrationDate>
163
               <SalesOrderLink
SalesOrderLink

Sales order reference

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

>{String}</SalesOrderLink>
164
          </SalesOrder>
165
          <SalesOrderItemLink
SalesOrderItemLink

Reference to the sales order item.

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

>{String}</SalesOrderItemLink>
166
     </InitialSalesOrderItem>
167
     <HighlightedNotification
HighlightedNotification

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

>
168
          <NotificationId
NotificationId

Notification identifier

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

>{Integer}</NotificationId>
169
          <Status
Status

Status of the notification

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

>{Integer}</Status>
170
          <CreatedAt
CreatedAt

Date and time of creation

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

>{Datetime}</CreatedAt>
171
          <Message
Message

The message from the notification definition, expanded with parameters.

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

>{String}</Message>
172
          <TranslatedMessage
TranslatedMessage

The translated message from the notification definition, expanded with parameters.

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

>{String}</TranslatedMessage>
173
          <NotificationType
NotificationType

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

>
174
               <NotificationTypeId
NotificationTypeId

Notification type identifier

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

>{String}</NotificationTypeId>
175
               <Category
Category

Category of notification type (warning, information etc)

Possible domain values can be found here

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

>{String}</Category>
176
               <NotificationTypeLink
NotificationTypeLink

Notification type reference

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

>{String}</NotificationTypeLink>
177
          </NotificationType>
178
          <NotificationLink
NotificationLink

Notification reference

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

>{String}</NotificationLink>
179
     </HighlightedNotification>
180
     <ProjectOrderItem
ProjectOrderItem

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

>
181
          <ProjectOrderItemId
ProjectOrderItemId

Project order item identifier

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

>{Integer}</ProjectOrderItemId>
182
          <ProjectOrderItemLink
ProjectOrderItemLink

Reference to the project order item.

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

>{String}</ProjectOrderItemLink>
183
     </ProjectOrderItem>
184
     <ProjectOrder
ProjectOrder

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

>
185
          <ProjectOrderId
ProjectOrderId

Project order identifier

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

>{Integer}</ProjectOrderId>
186
          <ProjectOrderLink
ProjectOrderLink

Project order reference

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

>{String}</ProjectOrderLink>
187
     </ProjectOrder>
188
     <RecurringInvoicePeriod
RecurringInvoicePeriod

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

>
189
          <RecurringInvoicePeriodId
RecurringInvoicePeriodId

Recurring invoice period identifier

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

>{Integer}</RecurringInvoicePeriodId>
190
          <Period
Period

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

>
191
               <StartDate
StartDate

Start date of an invoice period.

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

>{Date}</StartDate>
192
               <EndDate
EndDate

End date of an invoice period

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

>{Date}</EndDate>
193
          </Period>
194
          <RecurringInvoicePeriodLink
RecurringInvoicePeriodLink

Recurring invoice period reference

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

>{Docref-customlink}</RecurringInvoicePeriodLink>
195
     </RecurringInvoicePeriod>
196
</SalesInvoiceItem>
1
{
2
     "salesInvoiceItem": {
3
          "salesInvoiceItemId
SalesInvoiceItemId

Item-/line-number of the invoice

": "{Integer}",
4
          "status
Status

Status code of the the invoice item

Possible domain values can be found here

": "{Integer}",
5
          "createdAt
CreatedAt

Date and time of creation

": "{Datetime}",
6
          "lineNumber
LineNumber

Line- or sequence number of the item. The LineNumber is used for sorting items in applications, prints, reports etc.

": "{Integer}",
7
          "customersReferenceNumber
CustomersReferenceNumber

Customers item reference number. Typically to the customers internal system.

": "{String}",
8
          "customersProductName
CustomersProductName

Customers internal name of the product. Retrieved from the product.

": "{String}",
9
          "equivalentProductName
EquivalentProductName

Name of product with equivalent behavior and attributes. Can be used for same purpose.

": "{String}",
10
          "productDescription
ProductDescription

Description of the item. If not specified, the description is by default copied from the product.

": "{String}",
11
          "note
Note

Additional information regarding the item (free text). Might be visible to customers/suppliers.

": "{String}",
12
          "grossMargin
GrossMargin

Gross margin of the item.

": "{Decimal}",
13
          "vATPercent
VATPercent

Value added tax percent

": "{Decimal}",
14
          "discountPercent
DiscountPercent

The discount in percent for this item.

": "{Decimal}",
15
          "quantity
Quantity

Quantity of sales invoice item

": "{Decimal}",
16
          "deliveryDate
DeliveryDate

The date on which the supply of goods or services was made or completed.

": "{Date}",
17
          "countryOfOriginCode
CountryOfOriginCode

Two-character code (ISO 3166) identifying the default country where the product is produced. This value is inherrited from the assigned goods reception(s). If not country of origin is specified for the goods reception(s), country of origin is retrieved from the product. If assigned to multiple goods receptions with different origin, the field will be empty.

": "{String}",
18
          "endCustomer
EndCustomer

End customer

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

": {
19
               "customerId
CustomerId

Customer identifier

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

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

Name of customer (name of company or surname/familyname/lastname of a person)

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

": "{String}",
21
               "firstName
FirstName

Secondary name of a company or firstname of a person

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

": "{String}",
22
               "vATRegistrationNumber
VATRegistrationNumber

Unique number assigned by the relevant tax authority to identify a party for use in relation to value added tax (VAT).

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

": "{String}",
23
               "customerLink
CustomerLink

Customer reference

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

": "{String}"
24
          },
25
          "requestedProductRevision": {
26
               "revision
Revision

The revision will typically be a major change, as opposed to minor changes stored in the version of the product structure.

": "{String}"
27
          },
28
          "exchangeRateFluctuation": {
29
               "currency
Currency

Three character code following the ISO 4217 standard

": "{String}",
30
               "amount
Amount

Represents the exchange rate fluctuation amount

": "{Decimal}",
31
               "percent
Percent

The percent of change that resulted in fluctuation price change

": "{Decimal}"
32
          },
33
          "price": {
34
               "currency
Currency

Three character code following the ISO 4217 standard

": "{String}",
35
               "grossPrice
GrossPrice

Represents the price per unit before any discounting is applied.

": "{Decimal}",
36
               "discount
Discount

The discount for the item.

": "{Decimal}",
37
               "netPrice
NetPrice

Final price per unit after deducting all discounts etc.

": "{Decimal}"
38
          },
39
          "priceConverted
PriceConverted

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

": {
40
               "currency
Currency

Three character code following the ISO 4217 standard

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

": "{String}",
41
               "grossPrice
GrossPrice

Represents the price per unit before any discounting is applied.

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

": "{Decimal}",
42
               "netPrice
NetPrice

Final price per unit after deducting all discounts.

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

": "{Decimal}"
43
          },
44
          "totals": {
45
               "currency
Currency

Three character code following the ISO 4217 standard

": "{String}",
46
               "grossAmount
GrossAmount

Represents the item amount before any discounts etc. is applied.

": "{Decimal}",
47
               "discountAmount
DiscountAmount

The items discount amount.

": "{Decimal}",
48
               "netAmount
NetAmount

Final item amount after deducting all discounts etc.

": "{Decimal}"
49
          },
50
          "totalsConverted
TotalsConverted

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

": {
51
               "currency
Currency

Three character code following the ISO 4217 standard

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

": "{String}",
52
               "grossAmount
GrossAmount

Total gross amount in company currency.

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

": "{Decimal}",
53
               "netAmount
NetAmount

Total net amount in company currency.

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

": "{Decimal}"
54
          },
55
          "seller
Seller

Reference to the seller of the item

": {
56
               "employeeId
EmployeeId

Employee identifier

": "{Integer}",
57
               "firstName
FirstName

First name of employee

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

": "{String}",
58
               "lastName
LastName

Last name of employee

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

": "{String}",
59
               "employeeLink
EmployeeLink

Employee reference

": "{String}"
60
          },
61
          "measurementUnit": {
62
               "measurementUnitId
MeasurementUnitId

Measurement unit identifier

": "{Integer}",
63
               "unit
Unit

Measurement unit (ex. mm, km, dl, kg)

": "{String}",
64
               "measurementUnitLink
MeasurementUnitLink

Material unit reference

": "{String}"
65
          },
66
          "product": {
67
               "productId
ProductId

Product identifier

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

Name of the product

": "{String}",
69
               "type
Type

Type of product

Possible domain values can be found here

": "{String}",
70
               "customField1
CustomField1

Custom field for grouping, sorting, categorizing and other purposes.

": "{String}",
71
               "customField2
CustomField2

Custom field for grouping, sorting, categorizing and other purposes.

": "{String}",
72
               "manufacturer": {
73
                    "manufacturerId
ManufacturerId

Manufacturer identifier

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

Company name of the manufacturer.

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

": "{String}",
75
                    "shortName
ShortName

Shortname/code of the manufacturer

": "{String}",
76
                    "manufacturerLink
ManufacturerLink

Manufacturer reference

": "{String}"
77
               },
78
               "productClassification": {
79
                    "productClassificationId
ProductClassificationId

Product classification identifier

": "{String}",
80
                    "productClassificationLink
ProductClassificationLink

Product classification reference

": "{String}"
81
               },
82
               "productLink
ProductLink

Product reference

": "{String}"
83
          },
84
          "landedCost": {
85
               "purchaseCurrency
PurchaseCurrency

Purchase currency is the currency this product normally is purchased in. This is also the base currency used in the gross margin calculation. By default the purchase currency is retrieved from the product.

Possible domain values can be found here

": "{String}",
86
               "purchasePrice
PurchasePrice

Purchase price for each unit

": "{Decimal}",
87
               "freight
Freight

Estimated freight cost of getting each unit in stock. Used for calculating landed cost.

": "{Decimal}",
88
               "duty
Duty

Duty cost of getting each unit in stock. Used for calculating landed cost.

": "{Decimal}",
89
               "charge
Charge

Other costs of getting each unit in stock. Used for calculating landed cost.

": "{Decimal}",
90
               "grossPrice
GrossPrice

Total cost (landed cost or true cost) of getting each unit in stock, including purchase price, duties, charges, freight etc.

": "{Decimal}",
91
               "purchaseExchangeRate
PurchaseExchangeRate

Exchange rate between document currency and purchase currency. Used in landed cost calculations.

": "{Decimal}",
92
               "isDerivedFromUserInput
IsDerivedFromUserInput

True if landed cost is derived from manual user input. Landed cost can only be manually updated for products without assignments

": "{Boolean}",
93
               "isDerivedFromPreferredPurchasePrice
IsDerivedFromPreferredPurchasePrice

True if the landed cost for this item is derived from preferred purchase price. This means that parts (or all) of the item has not reserved goods in stock, nor incoming goods (supplier backlog or production backlog).

": "{Boolean}",
94
               "isDerivedFromAssignedSupplierBacklog
IsDerivedFromAssignedSupplierBacklog

True if landed cost for this item is derived from assigned supplier backlog. This means that the item has reserved incoming goods (supplier backlog or production backlog).

": "{Boolean}",
95
               "isDerivedFromAssignedStock
IsDerivedFromAssignedStock

True if landed cost for this item is derived from assigned stock. This means that the item has reserved goods in stock.

": "{Boolean}",
96
               "derivedFrom": {
97
                    "purchaseQuoteItemId
PurchaseQuoteItemId

Purchase quote item identifier

": "{Integer}",
98
                    "purchaseQuote": {
99
                         "database
Database

Database of the object

": "{String}",
100
                         "purchaseQuoteId
PurchaseQuoteId

Purchase quote identifier

": "{Integer}",
101
                         "purchaseQuoteLink
PurchaseQuoteLink

Purchase quote reference

": "{String}"
102
                    },
103
                    "purchaseQuoteItemLink
PurchaseQuoteItemLink

Purchase quote item link

": "{String}"
104
               }
105
          },
106
          "landedCostConverted
LandedCostConverted

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

": {
107
               "currency
Currency

Three character code following the ISO 4217 standard

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

": "{String}",
108
               "purchasePrice
PurchasePrice

Purchase price in sales currency.

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

": "{Decimal}",
109
               "freight
Freight

Freigth cost in sales currency.

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

": "{Decimal}",
110
               "duty
Duty

Duty costs in sales currency.

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

": "{Decimal}",
111
               "charge
Charge

Other cost in sales currency

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

": "{Decimal}",
112
               "grossPrice
GrossPrice

Total cost (landed cost or true cost) in sales currency

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

": "{Decimal}"
113
          },
114
          "accounting
Accounting

Accounting details for the item, including fixed/system dimensions. For all dimensions, see seperate resource.

": {
115
               "vATCodeDefinition": {
116
                    "vATCode
VATCode

Code that determines VAT rules used for VAT calculations.

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

Description of VAT Code definition

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

": "{String}"
118
               },
119
               "generalLedgerAccount": {
120
                    "generalLedgerAccountId
GeneralLedgerAccountId

General ledger account identifier

": "{Integer}",
121
                    "generalLedgerAccountLink
GeneralLedgerAccountLink

General ledger account reference

": "{String}"
122
               },
123
               "department
Department

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

": {
124
                    "departmentId
DepartmentId

Department identifier

": "{Integer}",
125
                    "departmentLink
DepartmentLink

Finance department reference

": "{String}"
126
               },
127
               "financeProject
FinanceProject

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

": {
128
                    "financeProjectId
FinanceProjectId

Finance project identifier

": "{Integer}",
129
                    "financeProjectLink
FinanceProjectLink

Finance project reference

": "{String}"
130
               },
131
               "asset
Asset

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

": {
132
                    "assetId
AssetId

Asset identifier

": "{Integer}",
133
                    "assetLink
AssetLink

Asset reference

": "{String}"
134
               },
135
               "customDimensions
CustomDimensions

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

": [
136
                    {
137
                         "value
Value

Value for this dimension defintion.

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

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

Description of the dimension value.

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

": "{String}",
139
                         "dimensionDefinition
DimensionDefinition

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

": {
140
                              "dimensionDefinitionId
DimensionDefinitionId

Dimension identifier

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

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

Name of dimension

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

": "{String}",
142
                              "dimensionDefinitionLink
DimensionDefinitionLink

Dimension reference

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

": "{String}"
143
                         }
144
                    }
145
               ]
146
          },
147
          "forwardedFrom
ForwardedFrom

The preceding/previous/source item.

": {
148
               "forwardedFromItem": {
149
                    "itemId
ItemId

Identifier of the object

": "{Integer}",
150
                    "object": {
151
                         "objectId
ObjectId

Identifier of the object

": "{Integer}",
152
                         "objectType
ObjectType

Type of object

": "{String}",
153
                         "objectLink
ObjectLink

API reference to the object

": "{String}"
154
                    },
155
                    "ramBaseKey
RamBaseKey

Internal RamBase identifier of the object/item

": "{String}",
156
                    "itemLink
ItemLink

API reference to the item

": "{String}"
157
               }
158
          },
159
          "initialSalesOrderItem
InitialSalesOrderItem

Reference to the initial/first/original sales order item in the document flow for this item.

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

": {
160
               "salesOrderItemId
SalesOrderItemId

Sales order item identifier

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

": "{Integer}",
161
               "salesOrder
SalesOrder

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

": {
162
                    "salesOrderId
SalesOrderId

Sales order identifier

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

": "{Integer}",
163
                    "registrationDate
RegistrationDate

Date of registration

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

": "{Date}",
164
                    "salesOrderLink
SalesOrderLink

Sales order reference

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

": "{String}"
165
               },
166
               "salesOrderItemLink
SalesOrderItemLink

Reference to the sales order item.

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

": "{String}"
167
          },
168
          "highlightedNotification
HighlightedNotification

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

": {
169
               "notificationId
NotificationId

Notification identifier

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

": "{Integer}",
170
               "status
Status

Status of the notification

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

": "{Integer}",
171
               "createdAt
CreatedAt

Date and time of creation

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

": "{Datetime}",
172
               "message
Message

The message from the notification definition, expanded with parameters.

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

": "{String}",
173
               "translatedMessage
TranslatedMessage

The translated message from the notification definition, expanded with parameters.

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

": "{String}",
174
               "notificationType
NotificationType

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

": {
175
                    "notificationTypeId
NotificationTypeId

Notification type identifier

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

": "{String}",
176
                    "category
Category

Category of notification type (warning, information etc)

Possible domain values can be found here

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

": "{String}",
177
                    "notificationTypeLink
NotificationTypeLink

Notification type reference

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

": "{String}"
178
               },
179
               "notificationLink
NotificationLink

Notification reference

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

": "{String}"
180
          },
181
          "projectOrderItem
ProjectOrderItem

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

": {
182
               "projectOrderItemId
ProjectOrderItemId

Project order item identifier

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

": "{Integer}",
183
               "projectOrderItemLink
ProjectOrderItemLink

Reference to the project order item.

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

": "{String}"
184
          },
185
          "projectOrder
ProjectOrder

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

": {
186
               "projectOrderId
ProjectOrderId

Project order identifier

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

": "{Integer}",
187
               "projectOrderLink
ProjectOrderLink

Project order reference

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

": "{String}"
188
          },
189
          "recurringInvoicePeriod
RecurringInvoicePeriod

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

": {
190
               "recurringInvoicePeriodId
RecurringInvoicePeriodId

Recurring invoice period identifier

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

": "{Integer}",
191
               "period
Period

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

": {
192
                    "startDate
StartDate

Start date of an invoice period.

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

": "{Date}",
193
                    "endDate
EndDate

End date of an invoice period

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

": "{Date}"
194
               },
195
               "recurringInvoicePeriodLink
RecurringInvoicePeriodLink

Recurring invoice period reference

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

": "{Docref-customlink}"
196
          }
197
     }
198
}

Possible error codes the response might return:

Error 102738 HTTP 404 Price list not found
Error 101420 HTTP 404 Setting definition not found