SalesOrderV2ByNumber: Visma.net Financials itgen_vnet_salesorderv2bynumber_plural
read only REST
- Catalog:
VismaNet - Schema:
SalesOrderV2 - Label: itgen_vnet_salesorderv2bynumber_plural
Get a specific SO Order Data for a single Sales Order. OBS: End of life March 31 2026. REPLACED BY v3 ENDPOINT. SEE https://salesorder.visma.net/swagger/index.html
Can only retrieve data.
Summary
Data for a single Sales Order. OBS: End of life March 31 2026. REPLACED BY v3 ENDPOINT. SEE https://salesorder.visma.net/swagger/index.html
API Source
- Endpoint:
/v2/salesorder/{orderNbr} - Operation:
get /v2/salesorder/{orderNbr}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
order |
`` | Identifies the Sales Order Number |
Table Columns
The columns of the table SalesOrderV2ByNumber are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
branch |
varchar2 |
Branch Name | filters on the platform, writable, branch |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | filters on the platform, writable, branch |
Click the magnifier. > The identifier. | |
cancel |
datetime |
Cancel by | filters on the platform, writable, cancel |
Delivery settings tab > Shipping information section > Cancel by > The date when the order should be cancelled if the Back order allowed option has been selected in the Shipping rule field. | |
canceled |
char |
Canceled | filters on the platform, writable, canceled |
The Delivery settings tab > The Shipping information section > Cancelled > A check box that indicates that the order has been cancelled on the date specified in Cancel by. | |
cash |
varchar2 |
Cash Account | filters on the platform, writable, cash |
Payment settings tab > Cash account | |
cash |
datetime |
Cash Discount Date | filters on the platform, writable, cash |
Financial settings tab > Financial information section > Cash discount date > The date when the cash discount is available for the invoice based on the credit terms. | |
commission |
varchar2 |
Commission Amount | filters on the platform, writable, commission |
The Commissions tab > Commission amt. > The commission amount earned by the salesperson on this document. | |
commission |
varchar2 |
Commission Percentage | filters on the platform, writable, commission |
The Commissions tab > Commission (%) > The percentage of commission generally earned by the salesperson. | |
commissionable |
varchar2 |
itgen_vnet_commissionableamount | filters on the platform, writable, commissionable |
The Commissions tab > Commissionable amount > The amount used to calculate the commission. | |
contact |
int32 |
Contact ID | filters on the platform, writable, contact |
The top part > Contact > The contact person of the customer. | |
currency |
varchar2 |
Currency | filters on the platform, writable, currency |
The top part > Currency > The currency of the document. | |
customer |
varchar2 |
Customer Order | filters on the platform, writable, customer |
The top part > Customer order > The reference number of the original customer document that the sales order is based on. | |
customer |
varchar2 |
Customer Reference Number | filters on the platform, writable, customer |
The top part > External reference > The reference number of the sales order in a third-party application if Visma.net Financials is integrated with such an application and imports the sales orders from it. | |
customer |
varchar2 |
VAT Zone Default Tax Category Description | filters on the platform, writable, customer |
Name of item/description | |
customer |
varchar2 |
VAT Zone Default Tax Category Number | filters on the platform, writable, customer |
Number of item | |
customer |
varchar2 |
VAT Zone Default VAT Category | filters on the platform, writable, customer |
Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window. | |
customer |
varchar2 |
VAT Zone Description | filters on the platform, writable, customer |
Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window. | |
customer |
varchar2 |
itgen_vnet_customervatzone_errorinfo | filters on the platform, writable, customer |
||
customer |
varchar2 |
VAT Zone ID | filters on the platform, writable, customer |
Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window. | |
customer |
int64 |
itgen_vnet_customervatzone_metadata_maxpagesize | filters on the platform, writable, customer |
||
customer |
int64 |
itgen_vnet_customervatzone_metadata_totalcount | filters on the platform, writable, customer |
||
customer_ |
int32 |
Customer Internal ID | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, customer. |
The name of the particular destination of the selected type. | |
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, customer. |
The identifier of the particular destination of the selected type. | |
date |
datetime |
Date | filters on the platform, writable, date |
Mandatory field: The top part > Date* > The date of the document. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The top part > Description > A brief description of the document. | |
discount |
double |
Discount Total | filters on the platform, writable, discount |
||
discount |
double |
itgen_vnet_discounttotalinbasecurrency | filters on the platform, writable, discount |
||
due |
datetime |
Due Date | filters on the platform, writable, due |
Financial settings tab > Financial information section > Due date > The due date of the invoice according to the credit terms. | |
emailed |
char |
Emailed | filters on the platform, writable, emailed |
A check box indicating if the document is emailed | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
exchange |
double |
Exchange Rate | filters on the platform, writable, exchange |
||
fob |
varchar2 |
FOB Point Description | filters on the platform, writable, fob |
Click on the magnifier. > The description. | |
fob |
varchar2 |
FOB Point ID | filters on the platform, writable, fob |
Click on the magnifier. > The identifier. | |
hold |
char |
Hold | filters on the platform, writable, hold |
The top part > Hold > A check box that you select if the document is on hold and should not be processed further at this time. | |
insurance |
char |
Insurance | filters on the platform, writable, insurance |
Delivery settings tab > Shipping information section > Insurance > A check box that you select to indicate that insurance is required for this order. | |
invoice |
datetime |
Invoice Date | filters on the platform, writable, invoice |
Financial settings tab > Financial information section > Invoice date> The date of the invoice generated for the order. | |
invoice |
varchar2 |
Invoice Number | filters on the platform, writable, invoice |
Financial settings tab > Financial information section > Invoice no.> The invoice number of the invoice generated for this order. | |
invoice |
char |
Invoice Separately | filters on the platform, writable, invoice |
Financial settings tab > Financial information section > Invoice separately > A check box that indicating that this document is to be invoiced separately (if that is required). | |
is |
char |
itgen_vnet_isrotrutdeductible | filters on the platform, writable, is |
A check box indicating if the document is Rot/rut deductible (applicable for the Swedish markets) | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
Background information collected from the system. | |
location_ |
varchar2 |
Location Country ID | filters on the platform, writable, location. |
Location*. | |
location_ |
varchar2 |
Location ID | filters on the platform, writable, location. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | filters on the platform, writable, location. |
Click the magnifier > The displayed name | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
note |
varchar2 |
Note | filters on the platform, writable, note |
Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the order. | |
order |
varchar2 |
Order Number | filters on the platform, writable, order |
The top part > Order no.: > The reference number of the document. | |
order |
double |
Order Total | filters on the platform, writable, order |
The top part > Order total > The total amount of the document, which is calculated as follows: Line Total + Misc.Charges + Freight + Premium Freight – Discount Total+ Tax Total | |
order |
double |
itgen_vnet_ordertotalinbasecurrency | filters on the platform, writable, order |
||
order |
varchar2 |
Order Type | filters on the platform, writable, order |
Mandatory field: The top part > Order type > The type of the document, which is one of the predefined order types or a custom order type created by using the (SO201000) window. | |
orig |
varchar2 |
Original Order Number | filters on the platform, writable, orig |
The top part > Order no. > The order number of the document. | |
orig |
varchar2 |
Original Order Type | filters on the platform, writable, orig |
Mandatory field: The top part > Order type* > The type of the document, which is one of the predefined order types or a custom order type created by using the window SO201000. | |
owner_ |
varchar2 |
Owner Employee ID | filters on the platform, writable, owner. |
The Financial settings tab > The Financial information section > Owner > Click the magnifier > Employee ID > The unique identifier, which is assigned to the employee in accordance with the configuration of the EMPLOYEEsegmented key. This information is retrieved from window EP203000. | |
owner_ |
guid |
Owner ID | filters on the platform, writable, owner. |
Employee internal user ID. This is the ID of the user linked to the employee | |
owner_ |
varchar2 |
Owner Name | filters on the platform, writable, owner. |
The Financial settings tab > The Financial information section > Owner > Click the magnifier > Employee name > The name of this employee. This information is retrieved from window EP203000. | |
payment |
varchar2 |
Payment Method Description | filters on the platform, writable, payment |
Click on the magnifier. > The description. | |
payment |
varchar2 |
Payment Method ID | filters on the platform, writable, payment |
Click on the magnifier. > The identifier. | |
payment |
varchar2 |
Payment Reference | filters on the platform, writable, payment |
Payment settings tab > Payment ref. | |
post |
varchar2 |
Post Period | filters on the platform, writable, post |
The Financial settings tab > Financial information section > Post period > The period to post the transactions generated by the invoice. Format MMYYYY. | |
preferred |
varchar2 |
Preferred Warehouse Description | filters on the platform, writable, preferred |
Click on the magnifier. > The description. | |
preferred |
varchar2 |
Preferred Warehouse ID | filters on the platform, writable, preferred |
Click on the magnifier. > The identifier. | |
print |
char |
Print Description on Invoice | filters on the platform, writable, print |
The top part > Print description on invoice > A check box | |
print |
char |
Print Note on External Documents | filters on the platform, writable, print |
The top part > Print note on external sales documents > A check box | |
print |
char |
Print Note on Internal Documents | filters on the platform, writable, print |
The top part > Print line note on internal sales documents > A check box | |
priority |
int32 |
Priority | filters on the platform, writable, priority |
Delivery settings tab > Shipping information section > Priority > Field only for informational purposes. The level of priority for processing order of this customer, as specified for the customer on the Shipping settings tab on the AR303000 window. | |
project |
varchar2 |
Project Code | filters on the platform, writable, project |
Mandatory field: The top part > Project* > The field consists of Project ID and Project description. Project ID: The identifier for the project with which this document is associated, or the code indicating that this document is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. | |
request |
datetime |
Request On | filters on the platform, writable, request |
Mandatory field: The top part > Requested on > The date when the customer wants to receive the goods; this date provides the default values for the Requested on dates for order lines. | |
residential |
char |
Residential Delivery | filters on the platform, writable, residential |
Delivery settings tab > Shipping information section > Residential delivery > A check box that you select to indicate that the shipment should be delivered to a residential area. | |
sales |
varchar2 |
Sales Person Description | filters on the platform, writable, sales |
Click on the magnifier. > The description. | |
sales |
varchar2 |
Sales Person ID | filters on the platform, writable, sales |
Click on the magnifier. > The identifier. | |
saturday |
char |
Saturday Delivery | filters on the platform, writable, saturday |
Delivery settings tab > Shipping information section > Saturday delivery > A check box that indicates that the order may be delivered on Saturday. | |
sched |
datetime |
Scheduled Shipment | filters on the platform, writable, sched |
Delivery settings tab > Shipping information section > Sched. shipment > The date when the ordered goods are scheduled to be shipped. | |
ship |
varchar2 |
Ship Complete | filters on the platform, writable, ship |
Delivery settings tab > Shipping information section > Shipping rule > An option that controls whether incomplete and partial shipments for the order are allowed. | |
ship |
char |
Ship Separately | filters on the platform, writable, ship |
Delivery settings tab > Shipping information section > Ship separately > This check box indicates that the goods for the customer should be shipped separately for each sales order. | |
ship |
varchar2 |
Ship via Description | filters on the platform, writable, ship |
Click on the magnifier. > The description. | |
ship |
varchar2 |
Ship via ID | filters on the platform, writable, ship |
Click on the magnifier. > The identifier. | |
shipping |
varchar2 |
Shipping Terms Description | filters on the platform, writable, shipping |
Click on the magnifier. > The description. | |
shipping |
varchar2 |
Shipping Terms ID | filters on the platform, writable, shipping |
Click on the magnifier. > The identifier. | |
shipping |
varchar2 |
Shipping Zone Description | filters on the platform, writable, shipping |
Click on the magnifier. > The description. | |
shipping |
varchar2 |
Shipping Zone ID | filters on the platform, writable, shipping |
Click on the magnifier. > The identifier. | |
so |
int32 |
SO Billing Address ID | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_sobillingaddress_addressline1 | filters on the platform, writable, so |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_addressline2 | filters on the platform, writable, so |
Address 2 > The second line of the address. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_addressline3 | filters on the platform, writable, so |
Address 3 > The third line of the address. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_city | filters on the platform, writable, so |
City > The city. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_country_errorinfo | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_sobillingaddress_country_id | filters on the platform, writable, so |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
so |
int64 |
itgen_vnet_sobillingaddress_country_metadata_maxpagesize | filters on the platform, writable, so |
||
so |
int64 |
itgen_vnet_sobillingaddress_country_metadata_totalcount | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_sobillingaddress_country_name | filters on the platform, writable, so |
Mandatory field: Country name* > The complete name of the country. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_county_id | filters on the platform, writable, so |
Click the magnifier > The identifier | |
so |
varchar2 |
itgen_vnet_sobillingaddress_county_name | filters on the platform, writable, so |
Click the magnifier > The displayed name | |
so |
char |
itgen_vnet_sobillingaddress_overrideaddress | filters on the platform, writable, so |
Override address > A check box indicating that you want to override the default address information. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_postalcode | filters on the platform, writable, so |
Postcode > The postcode. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_attention | filters on the platform, writable, so |
Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. | |
so |
int32 |
itgen_vnet_sobillingcontact_contactid | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_sobillingcontact_email | filters on the platform, writable, so |
Email > The email address of the customer/supplier/company as a business entity. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_fax | filters on the platform, writable, so |
Fax > The fax number. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_name | filters on the platform, writable, so |
Name > The legal name of to appear on the documents. | |
so |
char |
itgen_vnet_sobillingcontact_overridecontact | filters on the platform, writable, so |
Override contact > A check box indicating that you want to override the default contact information. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_phone1 | filters on the platform, writable, so |
Phone 1 > The default phone number. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_phone2 | filters on the platform, writable, so |
Phone 2 > An additional phone number. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_web | filters on the platform, writable, so |
Web > The website of the company, if one exists. | |
so |
int32 |
itgen_vnet_soshippingaddress_addressid | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_soshippingaddress_addressline1 | filters on the platform, writable, so |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_addressline2 | filters on the platform, writable, so |
Address 2 > The second line of the address. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_addressline3 | filters on the platform, writable, so |
Address 3 > The third line of the address. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_city | filters on the platform, writable, so |
City > The city. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_country_errorinfo | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_soshippingaddress_country_id | filters on the platform, writable, so |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
so |
int64 |
itgen_vnet_soshippingaddress_country_metadata_maxpagesize | filters on the platform, writable, so |
||
so |
int64 |
itgen_vnet_soshippingaddress_country_metadata_totalcount | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_soshippingaddress_country_name | filters on the platform, writable, so |
Mandatory field: Country name* > The complete name of the country. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_county_id | filters on the platform, writable, so |
Click the magnifier > The identifier | |
so |
varchar2 |
itgen_vnet_soshippingaddress_county_name | filters on the platform, writable, so |
Click the magnifier > The displayed name | |
so |
char |
itgen_vnet_soshippingaddress_overrideaddress | filters on the platform, writable, so |
Override address > A check box indicating that you want to override the default address information. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_postalcode | filters on the platform, writable, so |
Postcode > The postcode. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_attention | filters on the platform, writable, so |
Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. | |
so |
int32 |
itgen_vnet_soshippingcontact_contactid | filters on the platform, writable, so |
||
so |
varchar2 |
itgen_vnet_soshippingcontact_email | filters on the platform, writable, so |
Email > The email address of the customer/supplier/company as a business entity. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_fax | filters on the platform, writable, so |
Fax > The fax number. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_name | filters on the platform, writable, so |
Name > The legal name of to appear on the documents. | |
so |
char |
itgen_vnet_soshippingcontact_overridecontact | filters on the platform, writable, so |
Override contact > A check box indicating that you want to override the default contact information. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_phone1 | filters on the platform, writable, so |
Phone 1 > The default phone number. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_phone2 | filters on the platform, writable, so |
Phone 2 > An additional phone number. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_web | filters on the platform, writable, so |
Web > The website of the company, if one exists. | |
status |
varchar2 |
Status | filters on the platform, writable, status |
The top part > Status > The status of the document, which can be one of the following options: On hold, Credit hold, Pending aååroval, Rejected, Open, Cancelled, Shipping, Back order, Invoiced, Completed. | |
tax |
double |
Tax Total | filters on the platform, writable, tax |
The top part > VAT total > The total amount of tax paid on the document. | |
tax |
double |
itgen_vnet_taxtotalinbasecurrency | filters on the platform, writable, tax |
||
terms_ |
varchar2 |
Terms Description | filters on the platform, writable, terms. |
Click on the magnifier. > The description. | |
terms_ |
varchar2 |
Terms ID | filters on the platform, writable, terms. |
Click on the magnifier. > The identifier. | |
transaction |
varchar2 |
Transaction Type Description | filters on the platform, writable, transaction |
Click on the magnifier. > The description. | |
transaction |
int32 |
Transaction Type ID | filters on the platform, writable, transaction |
Click on the magnifier. > The identifier. | |
vat |
double |
VAT Exempt Total | filters on the platform, writable, vat |
The top part > VAT exempt total > The document total that is exempt from VAT. | |
vat |
double |
itgen_vnet_vatexempttotalinbasecurrency | filters on the platform, writable, vat |
||
vat |
double |
VAT Taxable Total | filters on the platform, writable, vat |
The top part > VAT taxable total > The document total that is subject to VAT. | |
vat |
double |
itgen_vnet_vattaxabletotalinbasecurrency | filters on the platform, writable, vat |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: