Sales APIs
Creates a new customer
HTTP method | POST |
URI | https://api.rambase.net/sales/customers |
Supported formats | Xml, Html, Json (ex. $format=json) |
Custom fields | Custom fields supported |
Successful HTTP status code | 201 |
API resource identifier | 1820, version 21 |
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.
Name
Required/mandatory field
Name of customer (name of company or surname/familyname/lastname of a person)
>{String}</Name>IsCompany
Indicator if a customer is private entity or a company
Default value: False
This field is optional.
>{Boolean}</IsCompany>FirstName
Secondary name of a company or firstname of a person
This field is optional.
>{String}</FirstName>PreferredLanguage
Preferred language for the customer. Is used in prints etc.
Applicable domain values can be found here
Input must match the following regular expression pattern: ^[a-z]{3}$
This field is optional.
>{String}</PreferredLanguage>Website
Customers website/homepage/webpage
This field is optional.
>{String}</Website>Phone
Customers main phone number
This field is optional.
>{String}</Phone>Fax
Customers main fax number
This field is optional.
>{String}</Fax>Customers main email
Input must match the following regular expression pattern: ^\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$
This field is optional.
>{String}</Email>ExternalReference
External customer reference/identifier. Can be used in external systems.
This field is optional.
>{String}</ExternalReference>InternalNote
Internal note/notice of the customer. Should not be visible to the customer.
This field is optional.
>{String}</InternalNote>IsRelatedBusinessEntity
Identify if a customer is related business entity to the company
Default value: False
This field is optional.
>{Boolean}</IsRelatedBusinessEntity>LegalEntityIdentifier
The customers unique enterprise/organization number.
This field is optional.
>{String}</LegalEntityIdentifier>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 optional.
>{String}</VATRegistrationNumber>Currencies
Currencies used by the customer
This field is optional.
>Currency
This field is optional.
>CurrencyCode
Three character code following the ISO 4217 standard
Applicable domain values can be found here
This field is optional.
>{String}</CurrencyCode>Sales
This field is optional.
>SalesDistrict
A geographic district for which an individual salesperson or sales team holds responsibility
Applicable domain values can be found here
This field is optional.
>{String}</SalesDistrict>Sector
The sector the customer belongs to.
Applicable domain values can be found here
This field is optional.
>{String}</Sector>MarketSegment
Market segment of the customer
Applicable domain values can be found here
This field is optional.
>{String}</MarketSegment>MinimumGrossMargin
The minimum gross margin in percent for the customer
Minimum value: 0
Maximum value: 99
This field is optional.
>{Decimal}</MinimumGrossMargin>VATHandling
Specifies how value added tax (VAT) should be calculated. Either always include VAT, always exclude VAT or use standard/default VAT rules.
Applicable domain values can be found here
This field is optional.
>{String}</VATHandling>WarrantyPeriod
Agreement of default warranty period in months
Minimum value: 0
This field is optional.
>{Integer}</WarrantyPeriod>FeeAmount
This is an amount, in the companies local currency, that by default will be added as fee when a sales order is created for this customer.
Minimum value: 0
This field is optional.
>{Decimal}</FeeAmount>VolumePriceAgreement
Special price agreement related to the quantity beeing ordered.
Applicable domain values can be found here
This field is optional.
>{String}</VolumePriceAgreement>ExchangeRateFluctuationAgreement
When a sales order is issued, RamBase stores the current exchange rate and the currency the product normally is purchased in. The exchange rate might have changed when the invoice is issued. The exchange rate fluctuation agreement specifies how to handle these differences. The agreement has the format AAA/BBB, where AAA is a percentage of the total invoice, and BBB is the exchange rate fluctuation percentage. E.g. 100/3.0 means that if the rate of exchange on the date a sales order is forwarded to an invoice has changed more than +/- 3% from the rate of exchange, 100% of the invoice amount will be adjusted.
Applicable domain values can be found here
This field is optional.
>{String}</ExchangeRateFluctuationAgreement>SalesAssistant
Reference to the employee who is sales assistant for the customer.
This field is optional.
>EmployeeId
Employee identifier
Minimum value: 100
This field is optional.
>{Integer}</EmployeeId>AccountManager
Reference to the employee who is responsible for the management of sales, and relationship with the customer.
This field is optional.
>EmployeeId
Employee identifier
Minimum value: 100
This field is optional.
>{Integer}</EmployeeId>Shipment
This field is optional.
>OnlyShipEntireSalesOrders
True if all items of a sales order should be shipped together. The items of a sales order should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
This field is optional.
>{Boolean}</OnlyShipEntireSalesOrders>OnlyShipEntireSalesOrderItems
True if the total quantity of a sales order item always should be shipped together. The quantity should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
This field is optional.
>{Boolean}</OnlyShipEntireSalesOrderItems>ShipBasedOnConfirmedDeliveryDate
If true, will sheduled shipping date on each item be calculated based on confirmed date rather than requested date.
This field is optional.
>{Boolean}</ShipBasedOnConfirmedDeliveryDate>FreightForEachShipment
If unchecked there will only be calculated freight on one shipping advice if the particular sales order has serveral shipments.
Default value: False
This field is optional.
>{Boolean}</FreightForEachShipment>ShippingDay
Specifies when the goods should be shipped. This is used to calculate the scheduled shipping date for each item.
Applicable domain values can be found here
This field is optional.
>{String}</ShippingDay>ConsolidateShippingAdvices
If true, sales orders will be consolidated when creating shipping advices via the "Prepare for picking" process the . If false, each sales order will result in seperate shipping advice. The field to use when consolidating is specified in the ShippingAdviceConsolidationField.
This field is optional.
>{Boolean}</ConsolidateShippingAdvices>ShippingAdviceConsolidationField
Field to use when consolidating sales order items into shipping advices in the "Prepare for picking" process.
Applicable domain values can be found here
This field is optional.
>{String}</ShippingAdviceConsolidationField>ShippingAdviceItemSortBy
Items in consolidated shipping advices will be sorted by this fields when they are created in the 'Prepare for picking' process
Applicable domain values can be found here
This field is optional.
>{String}</ShippingAdviceItemSortBy>RequireApprovalIfOverdue
True if shipments need approval if there are sales invoices with overdue amount. Default value is retireved from setting: DefaultCreateValueCUSFieldDUEAPPROVE
This field is optional.
>{Boolean}</RequireApprovalIfOverdue>SpecialHandling
This field is optional.
>SpecialHandlingId
The special handling code used for this customer.
Minimum value: 0
This field is optional.
>{Integer}</SpecialHandlingId>Invoicing
This field is optional.
>InterestRate
Interest rate used for sales invoices past duedate
Minimum value: 0
Maximum value: 1000
This field is optional.
>{Decimal}</InterestRate>InterestFeeAmount
Fixed interest fee used for the customer.
Minimum value: 0
This field is optional.
>{Decimal}</InterestFeeAmount>SalesInvoiceConsolidation
Specifies whether or how often shipping advices that origins from this sales order will be consolidated when creating sales invoices.
Applicable domain values can be found here
This field is optional.
>{String}</SalesInvoiceConsolidation>SalesInvoiceConsolidationField
Field name to group by when consolidating shipping advice items into sales invoices.
Applicable domain values can be found here
This field is optional.
>{String}</SalesInvoiceConsolidationField>SalesInvoiceItemSortBy
Field name to sort by when creating sales invoice items.
Applicable domain values can be found here
This field is optional.
>{String}</SalesInvoiceItemSortBy>SendReminders
Set to false if reminder are not be sent to this customer. Default value is retireved from setting: DefaultCreateValueCUSFieldREMINDER
This field is optional.
>{Boolean}</SendReminders>Payment
This field is optional.
>PaymentMethod
Default payment method for the customer
Applicable domain values can be found here
This field is optional.
>{String}</PaymentMethod>Accounting
This field is optional.
>CreditLimit
The maximum amount that the customer may charge on a credit card or borrow from a financial institution.
Minimum value: 0
This field is optional.
>{Decimal}</CreditLimit>CreditInsuranceAmount
Credit amount insured for the customer
Minimum value: 0
This field is optional.
>{Decimal}</CreditInsuranceAmount>CreditInsuranceCompany
Insurance company used by the customer for credit insurance
This field is optional.
>{String}</CreditInsuranceCompany>Name
Required/mandatory field
Name of customer (name of company or surname/familyname/lastname of a person)
": "{String}",IsCompany
Indicator if a customer is private entity or a company
Default value: False
This field is optional.
": "{Boolean}",FirstName
Secondary name of a company or firstname of a person
This field is optional.
": "{String}",PreferredLanguage
Preferred language for the customer. Is used in prints etc.
Applicable domain values can be found here
Input must match the following regular expression pattern: ^[a-z]{3}$
This field is optional.
": "{String}",Website
Customers website/homepage/webpage
This field is optional.
": "{String}",Phone
Customers main phone number
This field is optional.
": "{String}",Fax
Customers main fax number
This field is optional.
": "{String}",Customers main email
Input must match the following regular expression pattern: ^\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$
This field is optional.
": "{String}",ExternalReference
External customer reference/identifier. Can be used in external systems.
This field is optional.
": "{String}",InternalNote
Internal note/notice of the customer. Should not be visible to the customer.
This field is optional.
": "{String}",IsRelatedBusinessEntity
Identify if a customer is related business entity to the company
Default value: False
This field is optional.
": "{Boolean}",LegalEntityIdentifier
The customers unique enterprise/organization number.
This field is optional.
": "{String}",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 optional.
": "{String}",Currencies
Currencies used by the customer
This field is optional.
": [CurrencyCode
Three character code following the ISO 4217 standard
Applicable domain values can be found here
This field is optional.
": "{String}"Sales
This field is optional.
": {SalesDistrict
A geographic district for which an individual salesperson or sales team holds responsibility
Applicable domain values can be found here
This field is optional.
": "{String}",Sector
The sector the customer belongs to.
Applicable domain values can be found here
This field is optional.
": "{String}",MarketSegment
Market segment of the customer
Applicable domain values can be found here
This field is optional.
": "{String}",MinimumGrossMargin
The minimum gross margin in percent for the customer
Minimum value: 0
Maximum value: 99
This field is optional.
": "{Decimal}",VATHandling
Specifies how value added tax (VAT) should be calculated. Either always include VAT, always exclude VAT or use standard/default VAT rules.
Applicable domain values can be found here
This field is optional.
": "{String}",WarrantyPeriod
Agreement of default warranty period in months
Minimum value: 0
This field is optional.
": "{Integer}",FeeAmount
This is an amount, in the companies local currency, that by default will be added as fee when a sales order is created for this customer.
Minimum value: 0
This field is optional.
": "{Decimal}",VolumePriceAgreement
Special price agreement related to the quantity beeing ordered.
Applicable domain values can be found here
This field is optional.
": "{String}",ExchangeRateFluctuationAgreement
When a sales order is issued, RamBase stores the current exchange rate and the currency the product normally is purchased in. The exchange rate might have changed when the invoice is issued. The exchange rate fluctuation agreement specifies how to handle these differences. The agreement has the format AAA/BBB, where AAA is a percentage of the total invoice, and BBB is the exchange rate fluctuation percentage. E.g. 100/3.0 means that if the rate of exchange on the date a sales order is forwarded to an invoice has changed more than +/- 3% from the rate of exchange, 100% of the invoice amount will be adjusted.
Applicable domain values can be found here
This field is optional.
": "{String}",SalesAssistant
Reference to the employee who is sales assistant for the customer.
This field is optional.
": {EmployeeId
Employee identifier
Minimum value: 100
This field is optional.
": "{Integer}"AccountManager
Reference to the employee who is responsible for the management of sales, and relationship with the customer.
This field is optional.
": {EmployeeId
Employee identifier
Minimum value: 100
This field is optional.
": "{Integer}"Shipment
This field is optional.
": {OnlyShipEntireSalesOrders
True if all items of a sales order should be shipped together. The items of a sales order should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
This field is optional.
": "{Boolean}",OnlyShipEntireSalesOrderItems
True if the total quantity of a sales order item always should be shipped together. The quantity should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
This field is optional.
": "{Boolean}",ShipBasedOnConfirmedDeliveryDate
If true, will sheduled shipping date on each item be calculated based on confirmed date rather than requested date.
This field is optional.
": "{Boolean}",FreightForEachShipment
If unchecked there will only be calculated freight on one shipping advice if the particular sales order has serveral shipments.
Default value: False
This field is optional.
": "{Boolean}",ShippingDay
Specifies when the goods should be shipped. This is used to calculate the scheduled shipping date for each item.
Applicable domain values can be found here
This field is optional.
": "{String}",ConsolidateShippingAdvices
If true, sales orders will be consolidated when creating shipping advices via the "Prepare for picking" process the . If false, each sales order will result in seperate shipping advice. The field to use when consolidating is specified in the ShippingAdviceConsolidationField.
This field is optional.
": "{Boolean}",ShippingAdviceConsolidationField
Field to use when consolidating sales order items into shipping advices in the "Prepare for picking" process.
Applicable domain values can be found here
This field is optional.
": "{String}",ShippingAdviceItemSortBy
Items in consolidated shipping advices will be sorted by this fields when they are created in the 'Prepare for picking' process
Applicable domain values can be found here
This field is optional.
": "{String}",RequireApprovalIfOverdue
True if shipments need approval if there are sales invoices with overdue amount. Default value is retireved from setting: DefaultCreateValueCUSFieldDUEAPPROVE
This field is optional.
": "{Boolean}",SpecialHandling
This field is optional.
": {SpecialHandlingId
The special handling code used for this customer.
Minimum value: 0
This field is optional.
": "{Integer}"Invoicing
This field is optional.
": {InterestRate
Interest rate used for sales invoices past duedate
Minimum value: 0
Maximum value: 1000
This field is optional.
": "{Decimal}",InterestFeeAmount
Fixed interest fee used for the customer.
Minimum value: 0
This field is optional.
": "{Decimal}",SalesInvoiceConsolidation
Specifies whether or how often shipping advices that origins from this sales order will be consolidated when creating sales invoices.
Applicable domain values can be found here
This field is optional.
": "{String}",SalesInvoiceConsolidationField
Field name to group by when consolidating shipping advice items into sales invoices.
Applicable domain values can be found here
This field is optional.
": "{String}",SalesInvoiceItemSortBy
Field name to sort by when creating sales invoice items.
Applicable domain values can be found here
This field is optional.
": "{String}",SendReminders
Set to false if reminder are not be sent to this customer. Default value is retireved from setting: DefaultCreateValueCUSFieldREMINDER
This field is optional.
": "{Boolean}"Payment
This field is optional.
": {PaymentMethod
Default payment method for the customer
Applicable domain values can be found here
This field is optional.
": "{String}"Accounting
This field is optional.
": {CreditLimit
The maximum amount that the customer may charge on a credit card or borrow from a financial institution.
Minimum value: 0
This field is optional.
": "{Decimal}",CreditInsuranceAmount
Credit amount insured for the customer
Minimum value: 0
This field is optional.
": "{Decimal}",CreditInsuranceCompany
Insurance company used by the customer for credit insurance
This field is optional.
": "{String}"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.
$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 |
$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. |
$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] |
$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.
Please note that some fields may be removed from the response, based on user roles/duties/permissions.
CustomerId
Customer identifier
>{Integer}</CustomerId>Status
Status of the customer. 1:New, 2:Pending internal approvement, 4:Active, 9:Obsolete
Possible domain values can be found here
>{Integer}</Status>Name
Name of customer (name of company or surname/familyname/lastname of a person)
>{String}</Name>IsCompany
Indicator if a customer is private entity or a company
>{Boolean}</IsCompany>FirstName
Secondary name of a company or firstname of a person
>{String}</FirstName>PreferredLanguage
Preferred language for the customer. Is used in prints etc.
Possible domain values can be found here
>{String}</PreferredLanguage>Website
Customers website/homepage/webpage
>{String}</Website>Phone
Customers main phone number
>{String}</Phone>Fax
Customers main fax number
>{String}</Fax>Customers main email
>{String}</Email>ExternalReference
External customer reference/identifier. Can be used in external systems.
>{String}</ExternalReference>InternalNote
Internal note/notice of the customer. Should not be visible to the customer.
>{String}</InternalNote>IsRelatedBusinessEntity
Identify if a customer is related business entity to the company
>{Boolean}</IsRelatedBusinessEntity>LegalEntityIdentifier
The customers unique enterprise/organization number.
>{String}</LegalEntityIdentifier>VATRegistrationNumber
Unique number assigned by the relevant tax authority to identify a party for use in relation to value added tax (VAT).
>{String}</VATRegistrationNumber>EORINumber
An EORI (Economic Operator Registration and Identification number) number is required of any party intending to import into the EU or export from the EU.
>{String}</EORINumber>Classification
Classification of the customer
Possible domain values can be found here
>{String}</Classification>UpdatedAt
Date and time of update
>{Datetime}</UpdatedAt>CreatedAt
Date and time of creation
>{Datetime}</CreatedAt>CreatedBy
The employee (might be RamBase-server) that created the customer
>UserId
User identifier
>{Integer}</UserId>Name
Name of the user
>{String}</Name>FirstName
First name of the user
>{String}</FirstName>UserLink
User reference
>{String}</UserLink>Code
Intercompany database the customer belongs to.
>{String}</Code>Currencies
Currencies used by the customer
>CurrencyCode
Three character code following the ISO 4217 standard
Possible domain values can be found here
>{String}</CurrencyCode>Currency
Three character code following the ISO 4217 standard
>{String}</Currency>BacklogAmount
Total amount of sales orders, excluding value added tax, that not yet has been fulfilled.
>{Decimal}</BacklogAmount>BacklogAmountIncludingVAT
Total amount of sales orders, including value added tax, that not yet has been fulfilled
>{Decimal}</BacklogAmountIncludingVAT>SalesDistrict
A geographic district for which an individual salesperson or sales team holds responsibility
Possible domain values can be found here
>{String}</SalesDistrict>Sector
The sector the customer belongs to.
Possible domain values can be found here
>{String}</Sector>MarketSegment
Market segment of the customer
Possible domain values can be found here
>{String}</MarketSegment>MinimumGrossMargin
The minimum gross margin in percent for the customer
>{Decimal}</MinimumGrossMargin>VATHandling
Specifies how value added tax (VAT) should be calculated. Either always include VAT, always exclude VAT or use standard/default VAT rules.
Possible domain values can be found here
>{String}</VATHandling>WarrantyPeriod
Agreement of default warranty period in months
>{Integer}</WarrantyPeriod>FeeAmount
This is an amount, in the companies local currency, that by default will be added as fee when a sales order is created for this customer.
>{Decimal}</FeeAmount>VolumePriceAgreement
Special price agreement related to the quantity beeing ordered.
Possible domain values can be found here
>{String}</VolumePriceAgreement>ExchangeRateFluctuationAgreement
When a sales order is issued, RamBase stores the current exchange rate and the currency the product normally is purchased in. The exchange rate might have changed when the invoice is issued. The exchange rate fluctuation agreement specifies how to handle these differences. The agreement has the format AAA/BBB, where AAA is a percentage of the total invoice, and BBB is the exchange rate fluctuation percentage. E.g. 100/3.0 means that if the rate of exchange on the date a sales order is forwarded to an invoice has changed more than +/- 3% from the rate of exchange, 100% of the invoice amount will be adjusted.
Possible domain values can be found here
>{String}</ExchangeRateFluctuationAgreement>BlockSalesOrderRegistration
True if sales orders for this customer should be blocked/denied/rejected registration. A notification of type "Stop" will also be added to sales orders for this customer.
>{Boolean}</BlockSalesOrderRegistration>BlockSalesQuoteRegistration
True if sales quotes for this customer should be blocked/denied/rejected registration. A notification of type "Stop" will also be added to sales quotes for this customer.
>{Boolean}</BlockSalesQuoteRegistration>LatestSalesOrderDate
Date of latest sales order or sales order request registration.
>{Date}</LatestSalesOrderDate>PriceListId
Price list identifier
>{Integer}</PriceListId>Name
Name of the price list
>{String}</Name>PriceListLink
Price list reference
>{String}</PriceListLink>SalesAssistant
Reference to the employee who is sales assistant for the customer.
>EmployeeId
Employee identifier
>{Integer}</EmployeeId>LastName
Last name of employee
>{String}</LastName>FirstName
First name of employee
>{String}</FirstName>EmployeeLink
Employee reference
>{String}</EmployeeLink>AccountManager
Reference to the employee who is responsible for the management of sales, and relationship with the customer.
>EmployeeId
Employee identifier
>{Integer}</EmployeeId>LastName
Last name of employee
>{String}</LastName>FirstName
First name of employee
>{String}</FirstName>EmployeeLink
Employee reference
>{String}</EmployeeLink>CustomerLegalEntityId
Customer legal entity identifier
>{Integer}</CustomerLegalEntityId>CustomerLegalEntityLink
Reference to customer legal entity
>{String}</CustomerLegalEntityLink>DeliveryTerms
Default delivery terms for the customer. The delivery terms is based on the Incoterms rules from ICC (International Chamber of Commerce).
Possible domain values can be found here
>{String}</DeliveryTerms>DeliveryTermPlace
Named place related to delivery terms (Incoterms)
>{String}</DeliveryTermPlace>OnlyShipEntireSalesOrders
True if all items of a sales order should be shipped together. The items of a sales order should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
>{Boolean}</OnlyShipEntireSalesOrders>OnlyShipEntireSalesOrderItems
True if the total quantity of a sales order item always should be shipped together. The quantity should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
>{Boolean}</OnlyShipEntireSalesOrderItems>AvoidMultipleShipmentsOnSameDate
True if all items of a sales order with the same sheduled delivery date should be shipped together. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
>{Boolean}</AvoidMultipleShipmentsOnSameDate>ShipBasedOnConfirmedDeliveryDate
If true, will sheduled shipping date on each item be calculated based on confirmed date rather than requested date.
>{Boolean}</ShipBasedOnConfirmedDeliveryDate>FreightForEachShipment
If unchecked there will only be calculated freight on one shipping advice if the particular sales order has serveral shipments.
>{Boolean}</FreightForEachShipment>ShippingDay
Specifies when the goods should be shipped. This is used to calculate the scheduled shipping date for each item.
Possible domain values can be found here
>{String}</ShippingDay>ConsolidateShippingAdvices
If true, sales orders will be consolidated when creating shipping advices via the "Prepare for picking" process the . If false, each sales order will result in seperate shipping advice. The field to use when consolidating is specified in the ShippingAdviceConsolidationField.
>{Boolean}</ConsolidateShippingAdvices>ShippingAdviceConsolidationField
Field to use when consolidating sales order items into shipping advices in the "Prepare for picking" process.
Possible domain values can be found here
>{String}</ShippingAdviceConsolidationField>ShippingAdviceItemSortBy
Items in consolidated shipping advices will be sorted by this fields when they are created in the 'Prepare for picking' process
Possible domain values can be found here
>{String}</ShippingAdviceItemSortBy>RequireApprovalIfOverdue
True if shipments need approval if there are sales invoices with overdue amount. Default value is retireved from setting: DefaultCreateValueCUSFieldDUEAPPROVE
>{Boolean}</RequireApprovalIfOverdue>BlockShipping
True if shipping advices for this customer should be blocked/denied/rejected registration. A notification of type "Stop" will also be added to shipping advices for this customer.
>{Boolean}</BlockShipping>SpecialHandlingId
The special handling code used for this customer.
>{Integer}</SpecialHandlingId>SpecialHandlingLink
The special handling code used for this customer.
>{String}</SpecialHandlingLink>ShippingServiceId
Shipping service identifier
>{Integer}</ShippingServiceId>Name
Name of shipping service
>CarrierId
Carrier identifier
>{Integer}</CarrierId>Name
Name of carrier
>{String}</Name>CarrierLink
Carrier reference
>{String}</CarrierLink>ShippingServiceLink
Shipping service reference
>{String}</ShippingServiceLink>AddressId
Address identifier
>{Integer}</AddressId>Attention
Attention note.
>{String}</Attention>AddressLine1
First address line
>{String}</AddressLine1>AddressLine2
Second address line
>{String}</AddressLine2>PostalCode
Postalcode/Postcode/ZIP
>{String}</PostalCode>City
City/town/village
>{String}</City>Region
Region/province/state
>{String}</Region>CountryCode
Two-character code (ISO 3166) identifying the country.
>{String}</CountryCode>Country
English name of country.
>{String}</Country>AddressLink
Address reference
>{String}</AddressLink>Currency
Three character code following the ISO 4217 standard
>{String}</Currency>InterestRate
Interest rate used for sales invoices past duedate
>{Decimal}</InterestRate>InterestFeeAmount
Fixed interest fee used for the customer.
>{Decimal}</InterestFeeAmount>SalesInvoiceConsolidation
Specifies whether or how often shipping advices that origins from this sales order will be consolidated when creating sales invoices.
Possible domain values can be found here
>{String}</SalesInvoiceConsolidation>SalesInvoiceConsolidationField
Field name to group by when consolidating shipping advice items into sales invoices.
Possible domain values can be found here
>{String}</SalesInvoiceConsolidationField>SalesInvoiceItemSortBy
Field name to sort by when creating sales invoice items.
Possible domain values can be found here
>{String}</SalesInvoiceItemSortBy>SendReminders
Set to false if reminder are not be sent to this customer. Default value is retireved from setting: DefaultCreateValueCUSFieldREMINDER
>{Boolean}</SendReminders>LatestSalesInvoiceDate
Date last sales invoice was registered.
>{Date}</LatestSalesInvoiceDate>SendToFactoring
Identify which customer, invoices ands credit notes, will be send to factoring
>AddressId
Address identifier
>{Integer}</AddressId>Attention
Attention note.
>{String}</Attention>AddressLine1
First address line
>{String}</AddressLine1>AddressLine2
Second address line
>{String}</AddressLine2>PostalCode
Postalcode/Postcode/ZIP
>{String}</PostalCode>City
City/town/village
>{String}</City>Region
Region/province/state
>{String}</Region>CountryCode
Two-character code (ISO 3166) identifying the country.
>{String}</CountryCode>Country
English name of country.
>{String}</Country>AddressLink
Address reference
>{String}</AddressLink>PaymentTerms
Default payment terms to use in new documents.
Possible domain values can be found here
>{String}</PaymentTerms>PaymentMethod
Default payment method for the customer
Possible domain values can be found here
>{String}</PaymentMethod>LatestPaymentDate
Date last payment was registered
>{Date}</LatestPaymentDate>Currency
Three character code following the ISO 4217 standard
>{String}</Currency>Balance
Total balance for the customer, without value added tax
>{Decimal}</Balance>BalanceIncludingVAT
Total balance for the customer. Positive amount indicates how much the customer owes. Negative amount indicates that the customer has a credit balance.
>{Decimal}</BalanceIncludingVAT>BillingYTDAmount
Total amount of invoices and credit notes that has been invoiced this year (to current date)
>{Decimal}</BillingYTDAmount>OverdueAmount
Total amount of unpaid invoices which has passed due date
>{Decimal}</OverdueAmount>CreditLimit
The maximum amount that the customer may charge on a credit card or borrow from a financial institution.
>{Decimal}</CreditLimit>CreditInsuranceAmount
Credit amount insured for the customer
>{Decimal}</CreditInsuranceAmount>CreditInsuranceCompany
Insurance company used by the customer for credit insurance
>{String}</CreditInsuranceCompany>FeePercent
The commission paid by the customer when purchasing LOTs
>{Decimal}</FeePercent>LatestBidDate
Last date the customer placed a bid.
>{Date}</LatestBidDate>Supplier
Every customer in auction companies has a cross-reference to a supplier.
>SupplierId
RamBase supplier identifier
>{Integer}</SupplierId>SupplierLink
Supplier reference
>{String}</SupplierLink>TotalBalance
Sum of customer and cross referenced supplier balances
>{Decimal}</TotalBalance>TotalOverdueAmount
Sum of customer and cross referenced supplier overdued amounts
>{Decimal}</TotalOverdueAmount>SpecialHandlingId
The special handling code used for service.
>{Integer}</SpecialHandlingId>SpecialHandlingLink
The special handling code used for service.
>{String}</SpecialHandlingLink>CustomerId
Customer identifier
": "{Integer}",Status
Status of the customer. 1:New, 2:Pending internal approvement, 4:Active, 9:Obsolete
Possible domain values can be found here
": "{Integer}",Name
Name of customer (name of company or surname/familyname/lastname of a person)
": "{String}",IsCompany
Indicator if a customer is private entity or a company
": "{Boolean}",FirstName
Secondary name of a company or firstname of a person
": "{String}",PreferredLanguage
Preferred language for the customer. Is used in prints etc.
Possible domain values can be found here
": "{String}",Website
Customers website/homepage/webpage
": "{String}",Phone
Customers main phone number
": "{String}",Fax
Customers main fax number
": "{String}",Customers main email
": "{String}",ExternalReference
External customer reference/identifier. Can be used in external systems.
": "{String}",InternalNote
Internal note/notice of the customer. Should not be visible to the customer.
": "{String}",IsRelatedBusinessEntity
Identify if a customer is related business entity to the company
": "{Boolean}",LegalEntityIdentifier
The customers unique enterprise/organization number.
": "{String}",VATRegistrationNumber
Unique number assigned by the relevant tax authority to identify a party for use in relation to value added tax (VAT).
": "{String}",EORINumber
An EORI (Economic Operator Registration and Identification number) number is required of any party intending to import into the EU or export from the EU.
": "{String}",Classification
Classification of the customer
Possible domain values can be found here
": "{String}",UpdatedAt
Date and time of update
": "{Datetime}",CreatedAt
Date and time of creation
": "{Datetime}",CreatedBy
The employee (might be RamBase-server) that created the customer
": {UserId
User identifier
": "{Integer}",Name
Name of the user
": "{String}",FirstName
First name of the user
": "{String}",UserLink
User reference
": "{String}"Code
Intercompany database the customer belongs to.
": "{String}"Currencies
Currencies used by the customer
": [CurrencyCode
Three character code following the ISO 4217 standard
Possible domain values can be found here
": "{String}"Currency
Three character code following the ISO 4217 standard
": "{String}",BacklogAmount
Total amount of sales orders, excluding value added tax, that not yet has been fulfilled.
": "{Decimal}",BacklogAmountIncludingVAT
Total amount of sales orders, including value added tax, that not yet has been fulfilled
": "{Decimal}",SalesDistrict
A geographic district for which an individual salesperson or sales team holds responsibility
Possible domain values can be found here
": "{String}",Sector
The sector the customer belongs to.
Possible domain values can be found here
": "{String}",MarketSegment
Market segment of the customer
Possible domain values can be found here
": "{String}",MinimumGrossMargin
The minimum gross margin in percent for the customer
": "{Decimal}",VATHandling
Specifies how value added tax (VAT) should be calculated. Either always include VAT, always exclude VAT or use standard/default VAT rules.
Possible domain values can be found here
": "{String}",WarrantyPeriod
Agreement of default warranty period in months
": "{Integer}",FeeAmount
This is an amount, in the companies local currency, that by default will be added as fee when a sales order is created for this customer.
": "{Decimal}",VolumePriceAgreement
Special price agreement related to the quantity beeing ordered.
Possible domain values can be found here
": "{String}",ExchangeRateFluctuationAgreement
When a sales order is issued, RamBase stores the current exchange rate and the currency the product normally is purchased in. The exchange rate might have changed when the invoice is issued. The exchange rate fluctuation agreement specifies how to handle these differences. The agreement has the format AAA/BBB, where AAA is a percentage of the total invoice, and BBB is the exchange rate fluctuation percentage. E.g. 100/3.0 means that if the rate of exchange on the date a sales order is forwarded to an invoice has changed more than +/- 3% from the rate of exchange, 100% of the invoice amount will be adjusted.
Possible domain values can be found here
": "{String}",BlockSalesOrderRegistration
True if sales orders for this customer should be blocked/denied/rejected registration. A notification of type "Stop" will also be added to sales orders for this customer.
": "{Boolean}",BlockSalesQuoteRegistration
True if sales quotes for this customer should be blocked/denied/rejected registration. A notification of type "Stop" will also be added to sales quotes for this customer.
": "{Boolean}",LatestSalesOrderDate
Date of latest sales order or sales order request registration.
": "{Date}",PriceListId
Price list identifier
": "{Integer}",Name
Name of the price list
": "{String}",PriceListLink
Price list reference
": "{String}"SalesAssistant
Reference to the employee who is sales assistant for the customer.
": {EmployeeId
Employee identifier
": "{Integer}",LastName
Last name of employee
": "{String}",FirstName
First name of employee
": "{String}",EmployeeLink
Employee reference
": "{String}"AccountManager
Reference to the employee who is responsible for the management of sales, and relationship with the customer.
": {EmployeeId
Employee identifier
": "{Integer}",LastName
Last name of employee
": "{String}",FirstName
First name of employee
": "{String}",EmployeeLink
Employee reference
": "{String}"CustomerLegalEntityId
Customer legal entity identifier
": "{Integer}",CustomerLegalEntityLink
Reference to customer legal entity
": "{String}"DeliveryTerms
Default delivery terms for the customer. The delivery terms is based on the Incoterms rules from ICC (International Chamber of Commerce).
Possible domain values can be found here
": "{String}",DeliveryTermPlace
Named place related to delivery terms (Incoterms)
": "{String}",OnlyShipEntireSalesOrders
True if all items of a sales order should be shipped together. The items of a sales order should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
": "{Boolean}",OnlyShipEntireSalesOrderItems
True if the total quantity of a sales order item always should be shipped together. The quantity should never be split into several shipments. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
": "{Boolean}",AvoidMultipleShipmentsOnSameDate
True if all items of a sales order with the same sheduled delivery date should be shipped together. If sales order is forwarded to shipping advice by bulk handling, this will be controlled by RamBase. Manually forward requires that the users controls this themselves.
": "{Boolean}",ShipBasedOnConfirmedDeliveryDate
If true, will sheduled shipping date on each item be calculated based on confirmed date rather than requested date.
": "{Boolean}",FreightForEachShipment
If unchecked there will only be calculated freight on one shipping advice if the particular sales order has serveral shipments.
": "{Boolean}",ShippingDay
Specifies when the goods should be shipped. This is used to calculate the scheduled shipping date for each item.
Possible domain values can be found here
": "{String}",ConsolidateShippingAdvices
If true, sales orders will be consolidated when creating shipping advices via the "Prepare for picking" process the . If false, each sales order will result in seperate shipping advice. The field to use when consolidating is specified in the ShippingAdviceConsolidationField.
": "{Boolean}",ShippingAdviceConsolidationField
Field to use when consolidating sales order items into shipping advices in the "Prepare for picking" process.
Possible domain values can be found here
": "{String}",ShippingAdviceItemSortBy
Items in consolidated shipping advices will be sorted by this fields when they are created in the 'Prepare for picking' process
Possible domain values can be found here
": "{String}",RequireApprovalIfOverdue
True if shipments need approval if there are sales invoices with overdue amount. Default value is retireved from setting: DefaultCreateValueCUSFieldDUEAPPROVE
": "{Boolean}",BlockShipping
True if shipping advices for this customer should be blocked/denied/rejected registration. A notification of type "Stop" will also be added to shipping advices for this customer.
": "{Boolean}",SpecialHandlingId
The special handling code used for this customer.
": "{Integer}",SpecialHandlingLink
The special handling code used for this customer.
": "{String}"ShippingServiceId
Shipping service identifier
": "{Integer}",Name
Name of shipping service
": {CarrierId
Carrier identifier
": "{Integer}",Name
Name of carrier
": "{String}",CarrierLink
Carrier reference
": "{String}"ShippingServiceLink
Shipping service reference
": "{String}",AddressId
Address identifier
": "{Integer}",Attention
Attention note.
": "{String}",AddressLine1
First address line
": "{String}",AddressLine2
Second address line
": "{String}",PostalCode
Postalcode/Postcode/ZIP
": "{String}",City
City/town/village
": "{String}",Region
Region/province/state
": "{String}",CountryCode
Two-character code (ISO 3166) identifying the country.
": "{String}",Country
English name of country.
": "{String}",AddressLink
Address reference
": "{String}"Currency
Three character code following the ISO 4217 standard
": "{String}",InterestRate
Interest rate used for sales invoices past duedate
": "{Decimal}",InterestFeeAmount
Fixed interest fee used for the customer.
": "{Decimal}",SalesInvoiceConsolidation
Specifies whether or how often shipping advices that origins from this sales order will be consolidated when creating sales invoices.
Possible domain values can be found here
": "{String}",SalesInvoiceConsolidationField
Field name to group by when consolidating shipping advice items into sales invoices.
Possible domain values can be found here
": "{String}",SalesInvoiceItemSortBy
Field name to sort by when creating sales invoice items.
Possible domain values can be found here
": "{String}",SendReminders
Set to false if reminder are not be sent to this customer. Default value is retireved from setting: DefaultCreateValueCUSFieldREMINDER
": "{Boolean}",LatestSalesInvoiceDate
Date last sales invoice was registered.
": "{Date}",SendToFactoring
Identify which customer, invoices ands credit notes, will be send to factoring
": {AddressId
Address identifier
": "{Integer}",Attention
Attention note.
": "{String}",AddressLine1
First address line
": "{String}",AddressLine2
Second address line
": "{String}",PostalCode
Postalcode/Postcode/ZIP
": "{String}",City
City/town/village
": "{String}",Region
Region/province/state
": "{String}",CountryCode
Two-character code (ISO 3166) identifying the country.
": "{String}",Country
English name of country.
": "{String}",AddressLink
Address reference
": "{String}"PaymentTerms
Default payment terms to use in new documents.
Possible domain values can be found here
": "{String}",PaymentMethod
Default payment method for the customer
Possible domain values can be found here
": "{String}",LatestPaymentDate
Date last payment was registered
": "{Date}"Currency
Three character code following the ISO 4217 standard
": "{String}",Balance
Total balance for the customer, without value added tax
": "{Decimal}",BalanceIncludingVAT
Total balance for the customer. Positive amount indicates how much the customer owes. Negative amount indicates that the customer has a credit balance.
": "{Decimal}",BillingYTDAmount
Total amount of invoices and credit notes that has been invoiced this year (to current date)
": "{Decimal}",OverdueAmount
Total amount of unpaid invoices which has passed due date
": "{Decimal}",CreditLimit
The maximum amount that the customer may charge on a credit card or borrow from a financial institution.
": "{Decimal}",CreditInsuranceAmount
Credit amount insured for the customer
": "{Decimal}",CreditInsuranceCompany
Insurance company used by the customer for credit insurance
": "{String}",FeePercent
The commission paid by the customer when purchasing LOTs
": "{Decimal}",LatestBidDate
Last date the customer placed a bid.
": "{Date}",Supplier
Every customer in auction companies has a cross-reference to a supplier.
": {SupplierId
RamBase supplier identifier
": "{Integer}",SupplierLink
Supplier reference
": "{String}"TotalBalance
Sum of customer and cross referenced supplier balances
": "{Decimal}",TotalOverdueAmount
Sum of customer and cross referenced supplier overdued amounts
": "{Decimal}"SpecialHandlingId
The special handling code used for service.
": "{Integer}",SpecialHandlingLink
The special handling code used for service.
": "{String}"
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 101015 HTTP 404 | Permission not found |
Error 101086 HTTP 400 | Missing required argument {0} for description |
Error 101087 HTTP 400 | Description argument/result mismatch |
Error 104177 HTTP 400 | Output object definition is not active |
Error 101965 HTTP 400 | Contact is not valid for this customer |
Error 101964 HTTP 400 | Customer ID is not valid for this output condition |
Error 100038 HTTP 400 | Invalid language: {0} |
Error 100200 HTTP 404 | Special handling code not found |
Error 102751 HTTP 400 | Selected pricelist is not active |
Error 102939 HTTP 400 | Customer can not be blocked for orders before active bids are deleted |