API

Sales APIs

GET sales/order-change-requests/{salesOrderChangeRequestId}

Sales order change request details for provided identifier

HTTP method GET
URI https://api.rambase.net/sales/order-change-requests/{salesOrderChangeRequestId}
Supported formats Xml, Html, Json (ex. $format=json)
- URI parameter {salesOrderChangeRequestId} Sales order change request identifier
Integer, minimum 100000
Successful HTTP status code 200
API resource identifier 613, version 16

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.

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
<SalesOrderChangeRequest>
2
     <SalesOrderChangeRequestId
SalesOrderChangeRequestId

Sales order change request identifier

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

Status of sales order change request

Possible domain values can be found here

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

Date and time of creation

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

Date of registration

>
{Date}</RegistrationDate>
6
     <CustomersReference
CustomersReference

Customers reference. Typically a person.

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

Customers reference number. E.g. the internal sales order id the customer use in their own system.

>
{String}</CustomersReferenceNumber>
8
     <Currency
Currency

Three character code following the ISO 4217 standard

Possible domain values can be found here

>
{String}</Currency>
9
     <Note
Note

Additional information regarding the object (free text). This note might be visible to customers/suppliers.

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

The remaining quantity of the changed sales order item when this sales order change request was created.

>
{Decimal}</InitialQuantity>
11
     <CancelledQuantity
CancelledQuantity

The total cancelled quantity in this sales order change request. Cannot be higher than the initial quantity.

>
{Decimal}</CancelledQuantity>
12
     <ChangeReason
ChangeReason

States the reason why the sales order change request item was created

Possible domain values can be found here

>
{String}</ChangeReason>
13
     <ChangedSalesOrderItem
ChangedSalesOrderItem

The sales order item beeing requested for change

>
14
          <SalesOrderItemId
SalesOrderItemId

Sales order item identifier

>
{Integer}</SalesOrderItemId>
15
          <Status
Status

Status of the sales order item (0-9).

Possible domain values can be found here

>
{Integer}</Status>
16
          <RequestedDeliveryDate
RequestedDeliveryDate

The delivery date as requested by the customer.

>
{Date}</RequestedDeliveryDate>
17
          <ConfirmedDeliveryDate
ConfirmedDeliveryDate

Confirmed date of delivery. Date of which the customer can expect the arriving goods

>
{Date}</ConfirmedDeliveryDate>
18
          <CustomersReferenceNumber
CustomersReferenceNumber

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

>
{String}</CustomersReferenceNumber>
19
          <RequestedProductStructureRevision
RequestedProductStructureRevision

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

>
{String}</RequestedProductStructureRevision>
20
          <Quantity
Quantity

Number of units ordered

>
{Decimal}</Quantity>
21
          <MeasurementUnit>
22
               <MeasurementUnitId
MeasurementUnitId

Measurement unit identifier

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

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

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

Material unit reference

>
{String}</MeasurementUnitLink>
25
          </MeasurementUnit>
26
          <Price>
27
               <Currency
Currency

Three character code following the ISO 4217 standard

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

Represents the price per unit before any discounting is applied.

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

The discount for the item.

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

Final price per unit after deducting all discounts etc.

>
{Decimal}</NetPrice>
31
          </Price>
32
          <Product>
33
               <ProductId
ProductId

Product identifier

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

Name of the product

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

Type of product

Possible domain values can be found here

>
{String}</Type>
36
               <ProductLink
ProductLink

Product reference

>
{String}</ProductLink>
37
          </Product>
38
          <SalesOrder>
39
               <SalesOrderId
SalesOrderId

Sales order identifier

>
{Integer}</SalesOrderId>
40
               <CustomersReference
CustomersReference

Customers reference. Typically a person.

>
{String}</CustomersReference>
41
               <CustomersReferenceNumber
CustomersReferenceNumber

Customers reference number. E.g. the internal sales order id the customer use in their own system.

>
{String}</CustomersReferenceNumber>
42
               <SalesOrderLink
SalesOrderLink

Sales order reference

>
{String}</SalesOrderLink>
43
          </SalesOrder>
44
          <SalesOrderItemLink
SalesOrderItemLink

Reference to the sales order item.

>
{String}</SalesOrderItemLink>
45
     </ChangedSalesOrderItem>
46
     <ForwardedToSalesOrder>
47
          <SalesOrderId
SalesOrderId

Sales order identifier

>
{Integer}</SalesOrderId>
48
          <SalesOrderLink
SalesOrderLink

Sales order reference

>
{String}</SalesOrderLink>
49
     </ForwardedToSalesOrder>
50
     <Assignee
Assignee

The user who has been assigned to work with this object.

>
51
          <UserId
UserId

User identifier

>
{Integer}</UserId>
52
          <Name
Name

Name of the user

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

First name of the user

>
{String}</FirstName>
54
          <UserLink
UserLink

User reference

>
{String}</UserLink>
55
     </Assignee>
56
     <Customer>
57
          <CustomerId
CustomerId

Customer identifier

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

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

>
{String}</Name>
59
          <Firstname
Firstname

Secondary name of a company or firstname of a person

>
{String}</Firstname>
60
          <Phone
Phone

Customers main phone number

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

>
{String}</Phone>
61
          <Email
Email

Customers main email

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

>
{String}</Email>
62
          <CustomerLink
CustomerLink

Customer reference

>
{String}</CustomerLink>
63
     </Customer>
64
</SalesOrderChangeRequest>
1
{
2
     "salesOrderChangeRequest": {
3
          "salesOrderChangeRequestId
SalesOrderChangeRequestId

Sales order change request identifier

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

Status of sales order change request

Possible domain values can be found here

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

Date and time of creation

":
"{Datetime}",
6
          "registrationDate
RegistrationDate

Date of registration

":
"{Date}",
7
          "customersReference
CustomersReference

Customers reference. Typically a person.

":
"{String}",
8
          "customersReferenceNumber
CustomersReferenceNumber

Customers reference number. E.g. the internal sales order id the customer use in their own system.

":
"{String}",
9
          "currency
Currency

Three character code following the ISO 4217 standard

Possible domain values can be found here

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

Additional information regarding the object (free text). This note might be visible to customers/suppliers.

":
"{String}",
11
          "initialQuantity
InitialQuantity

The remaining quantity of the changed sales order item when this sales order change request was created.

":
"{Decimal}",
12
          "cancelledQuantity
CancelledQuantity

The total cancelled quantity in this sales order change request. Cannot be higher than the initial quantity.

":
"{Decimal}",
13
          "changeReason
ChangeReason

States the reason why the sales order change request item was created

Possible domain values can be found here

":
"{String}",
14
          "changedSalesOrderItem
ChangedSalesOrderItem

The sales order item beeing requested for change

":
{
15
               "salesOrderItemId
SalesOrderItemId

Sales order item identifier

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

Status of the sales order item (0-9).

Possible domain values can be found here

":
"{Integer}",
17
               "requestedDeliveryDate
RequestedDeliveryDate

The delivery date as requested by the customer.

":
"{Date}",
18
               "confirmedDeliveryDate
ConfirmedDeliveryDate

Confirmed date of delivery. Date of which the customer can expect the arriving goods

":
"{Date}",
19
               "customersReferenceNumber
CustomersReferenceNumber

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

":
"{String}",
20
               "requestedProductStructureRevision
RequestedProductStructureRevision

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

":
"{String}",
21
               "quantity
Quantity

Number of units ordered

":
"{Decimal}",
22
               "measurementUnit": {
23
                    "measurementUnitId
MeasurementUnitId

Measurement unit identifier

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

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

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

Material unit reference

":
"{String}"
26
               },
27
               "price": {
28
                    "currency
Currency

Three character code following the ISO 4217 standard

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

Represents the price per unit before any discounting is applied.

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

The discount for the item.

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

Final price per unit after deducting all discounts etc.

":
"{Decimal}"
32
               },
33
               "product": {
34
                    "productId
ProductId

Product identifier

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

Name of the product

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

Type of product

Possible domain values can be found here

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

Product reference

":
"{String}"
38
               },
39
               "salesOrder": {
40
                    "salesOrderId
SalesOrderId

Sales order identifier

":
"{Integer}",
41
                    "customersReference
CustomersReference

Customers reference. Typically a person.

":
"{String}",
42
                    "customersReferenceNumber
CustomersReferenceNumber

Customers reference number. E.g. the internal sales order id the customer use in their own system.

":
"{String}",
43
                    "salesOrderLink
SalesOrderLink

Sales order reference

":
"{String}"
44
               },
45
               "salesOrderItemLink
SalesOrderItemLink

Reference to the sales order item.

":
"{String}"
46
          },
47
          "forwardedToSalesOrder": {
48
               "salesOrderId
SalesOrderId

Sales order identifier

":
"{Integer}",
49
               "salesOrderLink
SalesOrderLink

Sales order reference

":
"{String}"
50
          },
51
          "assignee
Assignee

The user who has been assigned to work with this object.

":
{
52
               "userId
UserId

User identifier

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

Name of the user

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

First name of the user

":
"{String}",
55
               "userLink
UserLink

User reference

":
"{String}"
56
          },
57
          "customer": {
58
               "customerId
CustomerId

Customer identifier

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

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

":
"{String}",
60
               "firstname
Firstname

Secondary name of a company or firstname of a person

":
"{String}",
61
               "phone
Phone

Customers main phone number

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

":
"{String}",
62
               "email
Email

Customers main email

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

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

Customer reference

":
"{String}"
64
          }
65
     }
66
}

Possible error codes the response might return:

Error 102738 HTTP 404 Price list not found
Error 105969 HTTP 400 Start date is required
Error 105970 HTTP 400 End date is required