invantive documentation
Invantive Support ForumsLog In / Sign Up

BasicSalesOrderLineAttachments: Visma.net Financials Basic Sales Order Line Attachments

read only REST

  • Catalog: VismaNet
  • Schema: SalesOrderBasic
  • Label: Basic Sales Order Line Attachments

Get a range of Sale Orders - ScreenId=SO301000 Request page size must be lower or equal to the allowed max page size which is returned as part of the metadata information. If requested page size is greater than allowed max page size, request will be limited to max page size Data for all 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 all 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
  • Operation: get /v1/salesorderbasic

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
greaterThanValue `` Filter on Order no. greater than value.
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
orderType `` Filter by Order type.
showNotes `` Set to true to include notes.
status `` Select to filter on status on order. (Values: Open, Hold, CreditHold, Completed, Cancelled, BackOrder, Shipping, Invoiced, PendingApproval, Voided)

Table Columns

The columns of the table BasicSalesOrderLineAttachments 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_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
branchNumber_name varchar2 Branch Name writable, ::ancestor.branchNumber.name Click the magnifier. > The name.
branchNumber_name_2 varchar2 Branch Number Name 2 filters on the platform, writable, ::ancestor.::ancestor.branchNumber.name Click the magnifier. > The name.
branchNumber_number varchar2 Branch Number writable, ::ancestor.branchNumber.number Click the magnifier. > The identifier.
branchNumber_number_2 varchar2 Branch Number 2 filters on the platform, writable, ::ancestor.::ancestor.branchNumber.number Click the magnifier. > The identifier.
contactId int32 Contact ID filters on the platform, writable, ::ancestor.::ancestor.contactId The top part > Contact > The contact person of the customer.
currency varchar2 Currency filters on the platform, writable, ::ancestor.::ancestor.currency The top part > Currency > The currency of the document.
customerOrder varchar2 Customer Order filters on the platform, writable, ::ancestor.::ancestor.customerOrder The top part > Customer order > The reference number of the original customer document that the sales order is based on.
customerRefNo varchar2 Customer Reference Number filters on the platform, writable, ::ancestor.::ancestor.customerRefNo 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_internalId int32 Customer Internal ID filters on the platform, writable, ::ancestor.::ancestor.customer.internalId
customer_name varchar2 Customer Name filters on the platform, writable, ::ancestor.::ancestor.customer.name The name of the particular destination of the selected type.
customer_number varchar2 Customer Number filters on the platform, writable, ::ancestor.::ancestor.customer.number The identifier of the particular destination of the selected type.
date datetime Date filters on the platform, writable, ::ancestor.::ancestor.date Mandatory field: The top part > Date* > The date of the document.
description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.description The top part > Description > A brief description of the document.
discUnitPrice double itgen_vnet_discunitprice writable, ::ancestor.discUnitPrice Document details tab > Disc. unit price > The unit price, which has been recalculated after the application of discounts.
discountAmount double itgen_vnet_discountamount writable, ::ancestor.discountAmount 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).
discountCode varchar2 Discount Code writable, ::ancestor.discountCode Mandatory field: Document details tab > Discount details tab > Discount code* > The code of the discount that has been applied to this line.
discountPercent double Discount Percent writable, ::ancestor.discountPercent 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).
discountTotal double Discount Total filters on the platform, writable, ::ancestor.::ancestor.discountTotal
discountTotalInBaseCurrency double itgen_vnet_discounttotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.discountTotalInBaseCurrency
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.::ancestor.errorInfo
exchangeRate double Exchange Rate filters on the platform, writable, ::ancestor.::ancestor.exchangeRate
extPrice double Extended Price writable, ::ancestor.extPrice 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.::ancestor.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.
id guid ID writable, id The ID of the attachment
inventory_description varchar2 Inventory Description writable, ::ancestor.inventory.description Name of item/description
inventory_number varchar2 Inventory Number writable, ::ancestor.inventory.number Number of item
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.::ancestor.lastModifiedDateTime Background information collected from the system.
lineDescription varchar2 Line Description writable, ::ancestor.lineDescription Document details tab > Line description > The description of the unit.
lineNbr int32 itgen_vnet_linenbr writable, ::ancestor.lineNbr Document details tab > Line no. > The line number of the document.
location_countryId varchar2 Location Country ID filters on the platform, writable, ::ancestor.::ancestor.location.countryId Location*.
location_id varchar2 Location ID filters on the platform, writable, ::ancestor.::ancestor.location.id Click the magnifier > The identifier
location_name varchar2 Location Name filters on the platform, writable, ::ancestor.::ancestor.location.name Click the magnifier > The displayed name
manualDiscount char Manual Discount writable, ::ancestor.manualDiscount Document details tab > Manual discount > A check box that indicates (if selected) that the discount has been applied manually.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, ::ancestor.::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, ::ancestor.::ancestor.metadata.totalCount
name varchar2 Name writable, name The name of the attachment.
note varchar2 Note writable, ::ancestor.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.::ancestor.note Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the order.
openQty double Open Quantity writable, ::ancestor.openQty 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.
orderNo varchar2 Order Number filters on the platform, writable, ::ancestor.::ancestor.orderNo The top part > Order no.: > The reference number of the document.
orderTotal double Order Total filters on the platform, writable, ::ancestor.::ancestor.orderTotal 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
orderTotalInBaseCurrency double itgen_vnet_ordertotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.orderTotalInBaseCurrency
orderType varchar2 Order Type filters on the platform, writable, ::ancestor.::ancestor.orderType 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.
qtyOnShipments double itgen_vnet_qtyonshipments writable, ::ancestor.qtyOnShipments 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, ::ancestor.quantity Document details tab > Quantity > The quantity of the item sold, measured in the UoM.
requestOn datetime Request On filters on the platform, writable, ::ancestor.::ancestor.requestOn 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.
sortOrder int32 itgen_vnet_sortorder writable, ::ancestor.sortOrder 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.::ancestor.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.
taxTotal double Tax Total filters on the platform, writable, ::ancestor.::ancestor.taxTotal The top part > VAT total > The total amount of tax paid on the document.
taxTotalInBaseCurrency double itgen_vnet_taxtotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.taxTotalInBaseCurrency
unbilledAmount double itgen_vnet_unbilledamount writable, ::ancestor.unbilledAmount Document details tab > Amount not yet invoiced > The amount of cancelled shipments and cancelled remainders.
unitCost double Unit Cost writable, ::ancestor.unitCost Document details tab > Unit Cost > The cost of the unit on the sales order.
unitPrice double itgen_vnet_unitprice writable, ::ancestor.unitPrice Document details tab > Unit price > The price of the unit on the sales order.
unitPriceInBaseCurrency double itgen_vnet_unitpriceinbasecurrency writable, ::ancestor.unitPriceInBaseCurrency
uom varchar2 Unit of Measure writable, ::ancestor.uom Mandatory field: Document details tab > UoM* > The unit of measure (UoM) used for the item with this item ID.
vatExemptTotal double VAT Exempt Total filters on the platform, writable, ::ancestor.::ancestor.vatExemptTotal The top part > VAT exempt total > The document total that is exempt from VAT.
vatExemptTotalInBaseCurrency double itgen_vnet_vatexempttotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.vatExemptTotalInBaseCurrency
vatTaxableTotal double VAT Taxable Total filters on the platform, writable, ::ancestor.::ancestor.vatTaxableTotal The top part > VAT taxable total > The document total that is subject to VAT.
vatTaxableTotalInBaseCurrency double itgen_vnet_vattaxabletotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.vatTaxableTotalInBaseCurrency
warehouse_description varchar2 Warehouse Description writable, ::ancestor.warehouse.description Click on the magnifier. > The description.
warehouse_id varchar2 Warehouse ID writable, ::ancestor.warehouse.id Click on the magnifier. > The identifier.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: