BasicSalesOrderLinesByOrderNumber: Visma.net Financials Basic Sales Order Lines by Order Number
read only REST
- Catalog:
VismaNet - Schema:
SalesOrderBasic - Label: Basic Sales Order Lines by Order Number
Get a specific SO Order Data for a single Sales Order Basic. 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 Basic. OBS: End of life March 31 2026. REPLACED BY v3 ENDPOINT. SEE https://salesorder.visma.net/swagger/index.html
API Source
- Endpoint:
/v1/salesorderbasic/{orderNbr} - Operation:
get /v1/salesorderbasic/{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 BasicSalesOrderLinesByOrderNumber 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 | writable, branch |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number Name 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | writable, branch |
Click the magnifier. > The identifier. | |
branch |
varchar2 |
Branch Number 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
contact |
int32 |
Contact ID | filters on the platform, writable, ::ancestor. |
The top part > Contact > The contact person of the customer. | |
currency |
varchar2 |
Currency | filters on the platform, writable, ::ancestor. |
The top part > Currency > The currency of the document. | |
customer |
varchar2 |
Customer Order | filters on the platform, writable, ::ancestor. |
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, ::ancestor. |
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_ |
int32 |
Customer Internal ID | filters on the platform, writable, ::ancestor. |
||
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, ::ancestor. |
The name of the particular destination of the selected type. | |
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, ::ancestor. |
The identifier of the particular destination of the selected type. | |
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Date* > The date of the document. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The top part > Description > A brief description of the document. | |
disc |
double |
itgen_vnet_discunitprice | writable, disc |
Document details tab > Disc. unit price > The unit price, which has been recalculated after the application of discounts. | |
discount |
double |
itgen_vnet_discountamount | writable, discount |
Document details tab > Discount amount > The amount of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item). | |
discount |
varchar2 |
Discount Code | writable, discount |
Mandatory field: Document details tab > Discount details tab > Discount code* > The code of the discount that has been applied to this line. | |
discount |
double |
Discount Percent | writable, discount |
Document details tab > Discount percent > The percent of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item). | |
discount |
double |
Discount Total | filters on the platform, writable, ::ancestor. |
||
discount |
double |
itgen_vnet_discounttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
exchange |
double |
Exchange Rate | filters on the platform, writable, ::ancestor. |
||
ext |
double |
Extended Price | writable, ext |
Document details tab > Extended cost > The extended price, which is the unit price multiplied by the quantity. | |
hold |
char |
Hold | filters on the platform, writable, ::ancestor. |
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. | |
inventory_ |
varchar2 |
Inventory Description | writable, inventory. |
Name of item/description | |
inventory_ |
varchar2 |
Inventory Number | writable, inventory. |
Number of item | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Background information collected from the system. | |
line |
varchar2 |
Line Description | writable, line |
Document details tab > Line description > The description of the unit. | |
line |
int32 |
itgen_vnet_linenbr | writable, line |
Document details tab > Line no. > The line number of the document. | |
location_ |
varchar2 |
Location Country ID | filters on the platform, writable, ::ancestor. |
Location*. | |
location_ |
varchar2 |
Location ID | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
manual |
char |
Manual Discount | writable, manual |
Document details tab > Manual discount > A check box that indicates (if selected) that the discount has been applied manually. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
Tables in tab > Icon Notes > Pop-up window for providing any user-defined text connected to the order. | |
note_2 |
varchar2 |
Note 2 | filters on the platform, writable, ::ancestor. |
Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the order. | |
open |
double |
Open Quantity | writable, open |
Document details tab > Open qty. > The quantity of the item to be shipped; that is, the total quantity minus the quantity shipped according to closed shipment documents. | |
order |
varchar2 |
Order Number | filters on the platform, writable, ::ancestor. |
The top part > Order no.: > The reference number of the document. | |
order |
double |
Order Total | filters on the platform, writable, ::ancestor. |
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, ::ancestor. |
||
order |
varchar2 |
Order Type | filters on the platform, writable, ::ancestor. |
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. | |
qty |
double |
itgen_vnet_qtyonshipments | writable, qty |
Document details tab > Qty. on shipments > A read-only column that displays the quantity of the stock item being prepared for shipment and already shipped for this order. | |
quantity |
double |
Quantity | writable, quantity |
Document details tab > Quantity > The quantity of the item sold, measured in the UoM. | |
request |
datetime |
Request On | filters on the platform, writable, ::ancestor. |
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. | |
sort |
int32 |
itgen_vnet_sortorder | writable, sort |
Document details tab > Line order > The order number of the document line. The system regenerates this number automatically when you reorder the lines in the table. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
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, ::ancestor. |
The top part > VAT total > The total amount of tax paid on the document. | |
tax |
double |
itgen_vnet_taxtotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
unbilled |
double |
itgen_vnet_unbilledamount | writable, unbilled |
Document details tab > Amount not yet invoiced > The amount of cancelled shipments and cancelled remainders. | |
unit |
double |
Unit Cost | writable, unit |
Document details tab > Unit Cost > The cost of the unit on the sales order. | |
unit |
double |
itgen_vnet_unitprice | writable, unit |
Document details tab > Unit price > The price of the unit on the sales order. | |
unit |
double |
itgen_vnet_unitpriceinbasecurrency | writable, unit |
||
uom |
varchar2 |
Unit of Measure | writable, uom |
Mandatory field: Document details tab > UoM* > The unit of measure (UoM) used for the item with this item ID. | |
vat |
double |
VAT Exempt Total | filters on the platform, writable, ::ancestor. |
The top part > VAT exempt total > The document total that is exempt from VAT. | |
vat |
double |
itgen_vnet_vatexempttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
vat |
double |
VAT Taxable Total | filters on the platform, writable, ::ancestor. |
The top part > VAT taxable total > The document total that is subject to VAT. | |
vat |
double |
itgen_vnet_vattaxabletotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
warehouse_ |
varchar2 |
Warehouse Description | writable, warehouse. |
Click on the magnifier. > The description. | |
warehouse_ |
varchar2 |
Warehouse ID | writable, warehouse. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: