---
title: "SalesOrderLineAttachments (Visma.net Financials)"
description: "Sales Order Line Attachments"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.SalesOrder.SalesOrderLineAttachments
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.SalesOrder.SalesOrderLineAttachments
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# SalesOrderLineAttachments: Visma.net Financials Sales Order Line Attachments

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `SalesOrder`
- Label: Sales Order Line Attachments

Get a range of SO 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
Change log:
2020-May:Added force pagination
Data for all Sales Orders. Response Message has StatusCode OK if GET operation succeed. 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 Orders. Response Message has StatusCode OK if GET operation succeed. OBS: End of life March 31 2026. REPLACED BY v3 ENDPOINT. SEE https://salesorder.visma.net/swagger/index.html

## API Source

- Endpoint: `/v1/salesorder`
- Operation: `get /v1/salesorder`

## 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): * '&gt;' for greater than * '&lt;' for less than * '&gt;=' for greater than or equal * '&lt;=' 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 `SalesOrderLineAttachments` 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 | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `alternateID` | `varchar2` | Alternate ID | [ ] | writable, `::ancestor.alternateID` | Alternate ID &gt; The alternate ID for the item, such as the item ID used by the customer. |
| `branchNumber_name` | `varchar2` | Branch Name | [ ] | writable, `::ancestor.branchNumber.name` | Click the magnifier. &gt; The name. |
| `branchNumber_name_2` | `varchar2` | Branch Number Name 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.branchNumber.name` | Click the magnifier. &gt; The name. |
| `branchNumber_number` | `varchar2` | Branch Number | [ ] | writable, `::ancestor.branchNumber.number` | Click the magnifier. &gt; The identifier. |
| `branchNumber_number_2` | `varchar2` | Branch Number 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.branchNumber.number` | Click the magnifier. &gt; The identifier. |
| `cancelBy` | `datetime` | Cancel by | [ ] | filters on the platform, writable, `::ancestor.::ancestor.cancelBy` | Delivery settings tab &gt; Shipping information section &gt; Cancel by &gt; 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, `::ancestor.::ancestor.canceled` | The Delivery settings tab &gt; The Shipping information section &gt; Cancelled &gt; A check box that indicates that the order has been cancelled on the date specified in Cancel by. |
| `cashAccount` | `varchar2` | Cash Account | [ ] | filters on the platform, writable, `::ancestor.::ancestor.cashAccount` | Payment settings tab &gt; Cash account |
| `cashDiscountDate` | `datetime` | Cash Discount Date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.cashDiscountDate` | Financial settings tab &gt; Financial information section &gt; Cash discount date &gt; The date when the cash discount is available for the invoice based on the credit terms. |
| `commissionAmount` | `varchar2` | Commission Amount | [ ] | filters on the platform, writable, `::ancestor.::ancestor.commissionAmount` | The Commissions tab &gt; Commission amt. &gt;	The commission amount earned by the salesperson on this document. |
| `commissionPercent` | `varchar2` | Commission Percentage | [ ] | filters on the platform, writable, `::ancestor.::ancestor.commissionPercent` | The Commissions tab &gt; Commission (%) &gt; The percentage of commission generally earned by the salesperson. |
| `commissionable` | `char` | Commissionable | [ ] | writable, `::ancestor.commissionable` | VAT code &gt; The VAT category of the goods mentioned in this line. |
| `commissionableAmount` | `varchar2` | itgen_vnet_commissionableamount | [ ] | filters on the platform, writable, `::ancestor.::ancestor.commissionableAmount` | The Commissions tab &gt; Commissionable amount	&gt; The amount used to calculate the commission. |
| `completed` | `char` | Completed | [ ] | writable, `::ancestor.completed` | Completed &gt; A check box that can be selected to indicate to the system that this line is completed. |
| `contactId` | `int32` | Contact ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.contactId` | The top part &gt; Contact &gt; The contact person of the customer. |
| `currency` | `varchar2` | Currency | [ ] | filters on the platform, writable, `::ancestor.::ancestor.currency` | The top part &gt; Currency &gt; The currency of the document. |
| `customerOrder` | `varchar2` | Customer Order | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerOrder` | The top part &gt; Customer order &gt; 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 &gt; External reference &gt; 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. |
| `customerVATZone_defaultTaxCategory_description` | `varchar2` | VAT Zone Default Tax Category Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.defaultTaxCategory.description` | Name of item/description |
| `customerVATZone_defaultTaxCategory_number` | `varchar2` | VAT Zone Default Tax Category Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.defaultTaxCategory.number` | Number of item |
| `customerVATZone_defaultVatCategory` | `varchar2` | VAT Zone Default VAT Category | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.defaultVatCategory` | Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `customerVATZone_description` | `varchar2` | VAT Zone Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.description` | Click the magnifier. The description for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `customerVATZone_errorInfo` | `varchar2` | itgen_vnet_customervatzone_errorinfo | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.errorInfo` |  |
| `customerVATZone_id` | `varchar2` | VAT Zone ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.id` | Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `customerVATZone_metadata_maxPageSize` | `int64` | itgen_vnet_customervatzone_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.metadata.maxPageSize` |  |
| `customerVATZone_metadata_totalCount` | `int64` | itgen_vnet_customervatzone_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.::ancestor.customerVATZone.metadata.totalCount` |  |
| `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 &gt; Date* &gt;  The date of the document. |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.description` | The top part &gt; Description &gt; A brief description of the document. |
| `discUnitPrice` | `double` | itgen_vnet_discunitprice | [ ] | writable, `::ancestor.discUnitPrice` | Document details tab &gt; Disc. unit price &gt; The unit price, which has been recalculated after the application of discounts. |
| `discountAmount` | `double` | itgen_vnet_discountamount | [ ] | writable, `::ancestor.discountAmount` | Document details tab &gt; Discount amount &gt; 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 &gt; Discount details tab &gt; Discount code* &gt; The code of the discount that has been applied to this line. |
| `discountPercent` | `double` | Discount Percent | [ ] | writable, `::ancestor.discountPercent` | Document details tab &gt; Discount percent &gt; 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` |  |
| `dueDate` | `datetime` | Due Date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.dueDate` | Financial settings tab &gt; Financial information section &gt; Due date &gt; The due date of the invoice according to the credit terms. |
| `emailed` | `char` | Emailed | [ ] | filters on the platform, writable, `::ancestor.::ancestor.emailed` | A check box indicating if the document is emailed |
| `errorInfo` | `varchar2` | Error Message | [ ] | filters on the platform, writable, `::ancestor.::ancestor.errorInfo` |  |
| `exchangeRate` | `double` | Exchange Rate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.exchangeRate` |  |
| `expirationDate` | `datetime` | Expiration Date | [ ] | writable, `::ancestor.expirationDate` | Expiration date &gt; The expiration date for the item with the specified lot number. |
| `extPrice` | `double` | Extended Price | [ ] | writable, `::ancestor.extPrice` | Document details tab &gt; Extended cost &gt; The extended price, which is the unit price multiplied by the quantity. |
| `externalLink` | `varchar2` | itgen_vnet_externallink | [ ] | writable, `::ancestor.externalLink` |  |
| `fobPoint_description` | `varchar2` | FOB Point Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.fobPoint.description` | Click on the magnifier. &gt; The description. |
| `fobPoint_id` | `varchar2` | FOB Point ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.fobPoint.id` | Click on the magnifier. &gt; The identifier. |
| `freeItem` | `char` | Free Item | [ ] | writable, `::ancestor.freeItem` | A check box that indicates (if selected) that the stock item specified in the row is a free item. This information is collected from the system and not visible on the sales order line. |
| `hold` | `char` | Hold | [ ] | filters on the platform, writable, `::ancestor.::ancestor.hold` | The top part &gt; Hold &gt; 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 |
| `insurance` | `char` | Insurance | [ ] | filters on the platform, writable, `::ancestor.::ancestor.insurance` | Delivery settings tab &gt; Shipping information section &gt; Insurance &gt; A check box that you select to indicate that insurance is required for this order. |
| `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 |
| `invoiceDate` | `datetime` | Invoice Date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceDate` | Financial settings tab &gt; Financial information section &gt; Invoice date&gt; The date of the invoice generated for the order. |
| `invoiceNbr` | `varchar2` | Invoice Number | [ ] | writable, `::ancestor.invoiceNbr` | The reference number of the invoice generated for this order. This number is collected from the system and not visible on the sales order line. |
| `invoiceNbr_2` | `varchar2` | itgen_vnet_invoicenbr_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceNbr` | Financial settings tab &gt; Financial information section &gt; Invoice no.&gt; The invoice number of the invoice generated for this order. |
| `invoiceSeparately` | `char` | Invoice Separately | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoiceSeparately` | Financial settings tab &gt; Financial information section &gt; Invoice separately &gt; A check box that indicating that this document is to be invoiced separately (if that is required). |
| `isRotRutDeductible` | `char` | itgen_vnet_isrotrutdeductible | [ ] | writable, `::ancestor.isRotRutDeductible` |  |
| `isRotRutDeductible_2` | `char` | Is ROTRUT Deductible 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.isRotRutDeductible` | A check box indicating if the document is Rot/rut deductible (applicable for the Swedish markets) |
| `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 &gt; Line description &gt; The description of the unit. |
| `lineNbr` | `int32` | itgen_vnet_linenbr | [ ] | writable, `::ancestor.lineNbr` | Document details tab &gt; Line no. &gt; 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 &gt; The identifier |
| `location_name` | `varchar2` | Location Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.location.name` | Click the magnifier &gt; The displayed name |
| `lotSerialNbr` | `varchar2` | itgen_vnet_lotserialnbr | [ ] | writable, `::ancestor.lotSerialNbr` | Lot/serial no. &gt; The lot or serial number of the item for returns |
| `manualDiscount` | `char` | Manual Discount | [ ] | writable, `::ancestor.manualDiscount` | Document details tab &gt; Manual discount &gt; A check box that indicates (if selected) that the discount has been applied manually. |
| `markForPO` | `char` | itgen_vnet_markforpo | [ ] | writable, `::ancestor.markForPO` | Mark for purchase order &gt; A check box that indicates (if selected) that the order line was marked for purchasing (if it has not been shipped completely). |
| `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 &gt; Icon Notes &gt; 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 &gt; Pop-up window for providing any user-defined text connected to the order. |
| `openQty` | `double` | Open Quantity | [ ] | writable, `::ancestor.openQty` | Document details tab &gt; Open qty. &gt; The quantity of the item to be shipped; that is, the total quantity minus the quantity shipped according to closed shipment documents. |
| `operation` | `varchar2` | Operation | [ ] | writable, `::ancestor.operation` | The operation to be performed in the workspace to fulfil the order. This information is collected from the system and not visible on the sales order line. |
| `orderNo` | `varchar2` | Order Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.orderNo` | The top part &gt; Order no.: &gt; The reference number of the document. |
| `orderTotal` | `double` | Order Total | [ ] | filters on the platform, writable, `::ancestor.::ancestor.orderTotal` | The top part &gt; Order total &gt; 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 &gt; Order type &gt; The type of the document, which is one of the predefined order types or a custom order type created by using the (SO201000) window. |
| `origOrderNbr` | `varchar2` | Original Order Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.origOrderNbr` | The top part &gt; Order no. &gt; The order number of the document. |
| `origOrderType` | `varchar2` | Original Order Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.origOrderType` | Mandatory field: The top part &gt; Order type* &gt; The type of the document, which is one of the predefined order types or a custom order type created by using the window SO201000. |
| `overshipThreshold` | `double` | itgen_vnet_overshipthreshold | [ ] | writable, `::ancestor.overshipThreshold` | Overship threshold (%) &gt; The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer. |
| `owner_employeeId` | `varchar2` | Owner Employee ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.owner.employeeId` | The Financial settings tab &gt; The Financial information section &gt; Owner &gt; Click the magnifier  &gt; Employee ID &gt; 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_id` | `guid` | Owner ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.owner.id` | Employee internal user ID. This is the ID of the user linked to the employee |
| `owner_name` | `varchar2` | Owner Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.owner.name` | The Financial settings tab &gt; The Financial information section &gt; Owner &gt; Click the magnifier &gt; Employee name &gt; The name of this employee. This information is retrieved from window EP203000. |
| `paymentMethod_description` | `varchar2` | Payment Method Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.paymentMethod.description` | Click on the magnifier. &gt; The description. |
| `paymentMethod_id` | `varchar2` | Payment Method ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.paymentMethod.id` | Click on the magnifier. &gt; The identifier. |
| `paymentRef` | `varchar2` | Payment Reference | [ ] | filters on the platform, writable, `::ancestor.::ancestor.paymentRef` | Payment settings tab &gt; Payment ref. |
| `poSource` | `varchar2` | PO Source | [ ] | writable, `::ancestor.poSource` | Purchase order source &gt; The purchase order source to be used to fulfill this line, which can be one of the following options: Purchase to order, Drop-shipment. |
| `postPeriod` | `varchar2` | Post Period | [ ] | filters on the platform, writable, `::ancestor.::ancestor.postPeriod` | The Financial settings tab &gt; Financial information section &gt; Post period &gt; The period to post the transactions generated by the invoice. Format MMYYYY. |
| `preferredWarehouse_description` | `varchar2` | Preferred Warehouse Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.preferredWarehouse.description` | Click on the magnifier. &gt; The description. |
| `preferredWarehouse_id` | `varchar2` | Preferred Warehouse ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.preferredWarehouse.id` | Click on the magnifier. &gt; The identifier. |
| `printDescriptionOnInvoice` | `char` | Print Description on Invoice | [ ] | filters on the platform, writable, `::ancestor.::ancestor.printDescriptionOnInvoice` | The top part &gt; Print description on invoice &gt; A check box |
| `printNoteOnExternalDocuments` | `char` | Print Note on External Documents | [ ] | filters on the platform, writable, `::ancestor.::ancestor.printNoteOnExternalDocuments` | The top part &gt; Print note on external sales documents &gt; A check box |
| `printNoteOnInternalDocuments` | `char` | Print Note on Internal Documents | [ ] | filters on the platform, writable, `::ancestor.::ancestor.printNoteOnInternalDocuments` | The top part &gt; Print line note on internal sales documents &gt; A check box |
| `priority` | `int32` | Priority | [ ] | filters on the platform, writable, `::ancestor.::ancestor.priority` | Delivery settings tab &gt; Shipping information section &gt; Priority &gt; 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. |
| `projectCD` | `varchar2` | Project Code | [ ] | filters on the platform, writable, `::ancestor.::ancestor.projectCD` | Mandatory field: The top part &gt; Project* &gt; 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. |
| `projectTask` | `int32` | Project Task | [ ] | writable, `::ancestor.projectTask` | Project task &gt; The particular task of the project with which this document is associated. |
| `projectTaskCd` | `varchar2` | itgen_vnet_projecttaskcd | [ ] | writable, `::ancestor.projectTaskCd` | Project task code &gt; The particular task code of the project with which this document is associated. |
| `qtyOnShipments` | `double` | itgen_vnet_qtyonshipments | [ ] | writable, `::ancestor.qtyOnShipments` | Document details tab &gt; Qty. on shipments &gt; 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 &gt; Quantity &gt; The quantity of the item sold, measured in the UoM. |
| `reasonCode` | `varchar2` | Reason Code | [ ] | writable, `::ancestor.reasonCode` | Reason code &gt; The reason code to be used for creation or cancellation of the order, if applicable. |
| `requestOn` | `datetime` | Request On | [ ] | filters on the platform, writable, `::ancestor.::ancestor.requestOn` | Mandatory field: The top part &gt; Requested on &gt; The date when the customer wants to receive the goods; this date provides the default values for the Requested on dates for order lines. |
| `requestedOn` | `datetime` | Requested on | [ ] | writable, `::ancestor.requestedOn` | Mandatory field: The top part  &gt; Requested on* &gt; The date when the customer wants to receive the goods. The default value is the current business date. |
| `residentialDelivery` | `char` | Residential Delivery | [ ] | filters on the platform, writable, `::ancestor.::ancestor.residentialDelivery` | Delivery settings tab &gt; Shipping information section &gt; Residential delivery &gt; A check box that you select to indicate that the shipment should be delivered to a residential area. |
| `revision` | `int32` | Revision | [ ] | writable, `revision` | The version of the attachment. |
| `salesPerson_description` | `varchar2` | Sales Person Description | [ ] | writable, `::ancestor.salesPerson.description` | Click on the magnifier. &gt; The description. |
| `salesPerson_description_2` | `varchar2` | itgen_vnet_salesperson_description_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.salesPerson.description` | Click on the magnifier. &gt; The description. |
| `salesPerson_id` | `varchar2` | Sales Person ID | [ ] | writable, `::ancestor.salesPerson.id` | Click on the magnifier. &gt; The identifier. |
| `salesPerson_id_2` | `varchar2` | itgen_vnet_salesperson_id_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.salesPerson.id` | Click on the magnifier. &gt; The identifier. |
| `saturdayDelivery` | `char` | Saturday Delivery | [ ] | filters on the platform, writable, `::ancestor.::ancestor.saturdayDelivery` | Delivery settings tab &gt; Shipping information section &gt; Saturday delivery &gt; A check box that indicates that the order may be delivered on Saturday. |
| `schedShipment` | `datetime` | Scheduled Shipment | [ ] | filters on the platform, writable, `::ancestor.::ancestor.schedShipment` | Delivery settings tab &gt; Shipping information section &gt; Sched. shipment &gt; The date when the ordered goods are scheduled to be shipped. |
| `shipComplete` | `varchar2` | Ship Complete | [ ] | writable, `::ancestor.shipComplete` | Shipping rule &gt; An option that controls whether incomplete and partial shipments for the order are allowed. (Values: Ship complete, Back order allowed, Cancel remainder) |
| `shipComplete_2` | `varchar2` | itgen_vnet_shipcomplete_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shipComplete` | Delivery settings tab &gt; Shipping information section &gt; Shipping rule &gt; An option that controls whether incomplete and partial shipments for the order are allowed. |
| `shipOn` | `datetime` | itgen_vnet_shipon | [ ] | writable, `::ancestor.shipOn` | Ship on &gt; The date when the item is to be shipped. |
| `shipSeparately` | `char` | Ship Separately | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shipSeparately` | Delivery settings tab &gt; Shipping information section &gt; Ship separately &gt; This check box indicates that the goods for the customer should be shipped separately for each sales order. |
| `shipVia_description` | `varchar2` | Ship via Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shipVia.description` | Click on the magnifier. &gt; The description. |
| `shipVia_id` | `varchar2` | Ship via ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shipVia.id` | Click on the magnifier. &gt; The identifier. |
| `shippingTerms_description` | `varchar2` | Shipping Terms Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shippingTerms.description` | Click on the magnifier. &gt; The description. |
| `shippingTerms_id` | `varchar2` | Shipping Terms ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shippingTerms.id` | Click on the magnifier. &gt; The identifier. |
| `shippingZone_description` | `varchar2` | Shipping Zone Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shippingZone.description` | Click on the magnifier. &gt; The description. |
| `shippingZone_id` | `varchar2` | Shipping Zone ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.shippingZone.id` | Click on the magnifier. &gt; The identifier. |
| `soBillingAddress_addressId` | `int32` | SO Billing Address ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.addressId` |  |
| `soBillingAddress_addressLine1` | `varchar2` | itgen_vnet_sobillingaddress_addressline1 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.addressLine1` | Address 1 &gt; The first line of the customer's/supplier's/company's/employee's contact address. |
| `soBillingAddress_addressLine2` | `varchar2` | itgen_vnet_sobillingaddress_addressline2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.addressLine2` | Address 2 &gt; The second line of the address. |
| `soBillingAddress_addressLine3` | `varchar2` | itgen_vnet_sobillingaddress_addressline3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.addressLine3` | Address 3 &gt; The third line of the address. |
| `soBillingAddress_city` | `varchar2` | itgen_vnet_sobillingaddress_city | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.city` | City &gt; The city. |
| `soBillingAddress_country_errorInfo` | `varchar2` | itgen_vnet_sobillingaddress_country_errorinfo | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.country.errorInfo` |  |
| `soBillingAddress_country_id` | `varchar2` | itgen_vnet_sobillingaddress_country_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.country.id` | Mandatory field: Country ID* &gt; The unique two-letter country ID according to international standard ISO 3166. |
| `soBillingAddress_country_metadata_maxPageSize` | `int64` | itgen_vnet_sobillingaddress_country_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.country.metadata.maxPageSize` |  |
| `soBillingAddress_country_metadata_totalCount` | `int64` | itgen_vnet_sobillingaddress_country_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.country.metadata.totalCount` |  |
| `soBillingAddress_country_name` | `varchar2` | itgen_vnet_sobillingaddress_country_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.country.name` | Mandatory field: Country name* &gt; The complete name of the country. |
| `soBillingAddress_county_id` | `varchar2` | itgen_vnet_sobillingaddress_county_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.county.id` | Click the magnifier &gt; The identifier |
| `soBillingAddress_county_name` | `varchar2` | itgen_vnet_sobillingaddress_county_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.county.name` | Click the magnifier &gt; The displayed name |
| `soBillingAddress_overrideAddress` | `char` | itgen_vnet_sobillingaddress_overrideaddress | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.overrideAddress` | Override address &gt; A check box indicating that you want to override the default address information. |
| `soBillingAddress_postalCode` | `varchar2` | itgen_vnet_sobillingaddress_postalcode | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingAddress.postalCode` | Postcode &gt; The postcode. |
| `soBillingContact_attention` | `varchar2` | itgen_vnet_sobillingcontact_attention | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.attention` | Attention &gt; 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. |
| `soBillingContact_contactId` | `int32` | itgen_vnet_sobillingcontact_contactid | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.contactId` |  |
| `soBillingContact_email` | `varchar2` | itgen_vnet_sobillingcontact_email | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.email` | Email &gt; The email address of the customer/supplier/company as a business entity. |
| `soBillingContact_fax` | `varchar2` | itgen_vnet_sobillingcontact_fax | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.fax` | Fax &gt; The fax number. |
| `soBillingContact_name` | `varchar2` | itgen_vnet_sobillingcontact_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.name` | Name &gt; The legal name of to appear on the documents. |
| `soBillingContact_overrideContact` | `char` | itgen_vnet_sobillingcontact_overridecontact | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.overrideContact` | Override contact &gt; A check box indicating that you want to override the default contact information. |
| `soBillingContact_phone1` | `varchar2` | itgen_vnet_sobillingcontact_phone1 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.phone1` | Phone 1 &gt; The default phone number. |
| `soBillingContact_phone2` | `varchar2` | itgen_vnet_sobillingcontact_phone2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.phone2` | Phone 2 &gt; An additional phone number. |
| `soBillingContact_web` | `varchar2` | itgen_vnet_sobillingcontact_web | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soBillingContact.web` | Web &gt; The website of the company, if one exists. |
| `soShippingAddress_addressId` | `int32` | itgen_vnet_soshippingaddress_addressid | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.addressId` |  |
| `soShippingAddress_addressLine1` | `varchar2` | itgen_vnet_soshippingaddress_addressline1 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.addressLine1` | Address 1 &gt; The first line of the customer's/supplier's/company's/employee's contact address. |
| `soShippingAddress_addressLine2` | `varchar2` | itgen_vnet_soshippingaddress_addressline2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.addressLine2` | Address 2 &gt; The second line of the address. |
| `soShippingAddress_addressLine3` | `varchar2` | itgen_vnet_soshippingaddress_addressline3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.addressLine3` | Address 3 &gt; The third line of the address. |
| `soShippingAddress_city` | `varchar2` | itgen_vnet_soshippingaddress_city | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.city` | City &gt; The city. |
| `soShippingAddress_country_errorInfo` | `varchar2` | itgen_vnet_soshippingaddress_country_errorinfo | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.country.errorInfo` |  |
| `soShippingAddress_country_id` | `varchar2` | itgen_vnet_soshippingaddress_country_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.country.id` | Mandatory field: Country ID* &gt; The unique two-letter country ID according to international standard ISO 3166. |
| `soShippingAddress_country_metadata_maxPageSize` | `int64` | itgen_vnet_soshippingaddress_country_metadata_maxpagesize | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.country.metadata.maxPageSize` |  |
| `soShippingAddress_country_metadata_totalCount` | `int64` | itgen_vnet_soshippingaddress_country_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.country.metadata.totalCount` |  |
| `soShippingAddress_country_name` | `varchar2` | itgen_vnet_soshippingaddress_country_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.country.name` | Mandatory field: Country name* &gt; The complete name of the country. |
| `soShippingAddress_county_id` | `varchar2` | itgen_vnet_soshippingaddress_county_id | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.county.id` | Click the magnifier &gt; The identifier |
| `soShippingAddress_county_name` | `varchar2` | itgen_vnet_soshippingaddress_county_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.county.name` | Click the magnifier &gt; The displayed name |
| `soShippingAddress_overrideAddress` | `char` | itgen_vnet_soshippingaddress_overrideaddress | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.overrideAddress` | Override address &gt; A check box indicating that you want to override the default address information. |
| `soShippingAddress_postalCode` | `varchar2` | itgen_vnet_soshippingaddress_postalcode | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingAddress.postalCode` | Postcode &gt; The postcode. |
| `soShippingContact_attention` | `varchar2` | itgen_vnet_soshippingcontact_attention | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.attention` | Attention &gt; 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. |
| `soShippingContact_contactId` | `int32` | itgen_vnet_soshippingcontact_contactid | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.contactId` |  |
| `soShippingContact_email` | `varchar2` | itgen_vnet_soshippingcontact_email | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.email` | Email &gt; The email address of the customer/supplier/company as a business entity. |
| `soShippingContact_fax` | `varchar2` | itgen_vnet_soshippingcontact_fax | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.fax` | Fax &gt; The fax number. |
| `soShippingContact_name` | `varchar2` | itgen_vnet_soshippingcontact_name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.name` | Name &gt; The legal name of to appear on the documents. |
| `soShippingContact_overrideContact` | `char` | itgen_vnet_soshippingcontact_overridecontact | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.overrideContact` | Override contact &gt; A check box indicating that you want to override the default contact information. |
| `soShippingContact_phone1` | `varchar2` | itgen_vnet_soshippingcontact_phone1 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.phone1` | Phone 1 &gt; The default phone number. |
| `soShippingContact_phone2` | `varchar2` | itgen_vnet_soshippingcontact_phone2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.phone2` | Phone 2 &gt; An additional phone number. |
| `soShippingContact_web` | `varchar2` | itgen_vnet_soshippingcontact_web | [ ] | filters on the platform, writable, `::ancestor.::ancestor.soShippingContact.web` | Web &gt; The website of the company, if one exists. |
| `sortOrder` | `int32` | itgen_vnet_sortorder | [ ] | writable, `::ancestor.sortOrder` | Document details tab &gt; Line order &gt; 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 &gt; Status &gt; 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. |
| `subaccount_active` | `char` | Sub Account Active 2 | [ ] | writable, `::ancestor.subaccount.active` |  |
| `subaccount_description` | `varchar2` | Subaccount Description | [ ] | writable, `::ancestor.subaccount.description` | Click on the magnifier. &gt; The description. |
| `subaccount_id` | `varchar2` | Subaccount ID | [ ] | writable, `::ancestor.subaccount.id` | Click on the magnifier. &gt; The identifier. |
| `taxCategory` | `varchar2` | Tax Category | [ ] | writable, `::ancestor.taxCategory` | VAT code &gt; The VAT category of the goods mentioned in this line. |
| `taxTotal` | `double` | Tax Total | [ ] | filters on the platform, writable, `::ancestor.::ancestor.taxTotal` | The top part &gt; VAT total &gt; The total amount of tax paid on the document. |
| `taxTotalInBaseCurrency` | `double` | itgen_vnet_taxtotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.::ancestor.taxTotalInBaseCurrency` |  |
| `terms_description` | `varchar2` | Terms Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.terms.description` | Click on the magnifier. &gt; The description. |
| `terms_id` | `varchar2` | Terms ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.terms.id` | Click on the magnifier. &gt; The identifier. |
| `transactionType_description` | `varchar2` | Transaction Type Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.transactionType.description` | Click on the magnifier. &gt; The description. |
| `transactionType_id` | `int32` | Transaction Type ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.transactionType.id` | Click on the magnifier. &gt; The identifier. |
| `unbilledAmount` | `double` | itgen_vnet_unbilledamount | [ ] | writable, `::ancestor.unbilledAmount` | Document details tab &gt; Amount not yet invoiced &gt; The amount of cancelled shipments and cancelled remainders. |
| `undershipThreshold` | `double` | itgen_vnet_undershipthreshold | [ ] | writable, `::ancestor.undershipThreshold` | Undership threshold (%) &gt; The minimal percentage of goods shipped (with respect to the ordered quantity) to consider the order shipped completely. |
| `unitCost` | `double` | Unit Cost | [ ] | writable, `::ancestor.unitCost` | Document details tab &gt; Unit Cost &gt; The cost of the unit on the sales order. |
| `unitPrice` | `double` | itgen_vnet_unitprice | [ ] | writable, `::ancestor.unitPrice` | Document details tab &gt; Unit price &gt; 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 &gt; UoM* &gt; 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 &gt; VAT exempt total &gt; 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 &gt; VAT taxable total &gt; 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. &gt; The description. |
| `warehouse_id` | `varchar2` | Warehouse ID | [ ] | writable, `::ancestor.warehouse.id` | Click on the magnifier. &gt; The identifier. |



## Release Notes

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

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

