BasicSalesOrderAttachmentsByOrderNumber: Visma.net Financials Basic Sales Order Attachments by Order Number
read only REST
- Catalog:
VismaNet - Schema:
SalesOrderBasic - Label: Basic Sales Order Attachments 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 BasicSalesOrderAttachmentsByOrderNumber 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, ::ancestor. |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | 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. | |
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. |
||
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. | |
id |
guid |
ID | writable, id |
The ID of the attachment | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Background information collected from the system. | |
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 | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
name |
varchar2 |
Name | writable, name |
The name of the attachment. | |
note |
varchar2 |
Note | 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. | |
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. | |
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. | |
revision |
int32 |
Revision | writable, revision |
The version of the attachment. | |
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. |
||
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. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: