---
title: "SalesOrderCommissions (Visma.net Financials)"
description: "itgen_vnet_salesordercommissions_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/NgSalesOrders.SalesOrders.SalesOrderCommissions
original: https://documentation.invantive.eu/en/datamodels/vismanet/NgSalesOrders.SalesOrders.SalesOrderCommissions
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# SalesOrderCommissions: Visma.net Financials itgen_vnet_salesordercommissions_plural

`read only` `REST`

- Catalog: `NgSalesOrders`
- Schema: `SalesOrders`
- Label: itgen_vnet_salesordercommissions_plural

Gets a paged list with sales orders of any type.
Sample requests:
            
`GET /salesorders`
            
`GET /salesorders?customerId=10000&status=Open&pageSize=10`
            
`GET /salesorders?orderBy=lastModified%20asc`
            
`GET /salesorders?expand=all&pageSize=100`
            
When any `expand` value is specified, the effective maximum `pageSize` is `100`.

Can only retrieve data.

## Summary

Sample requests:
            
`GET /salesorders`
            
`GET /salesorders?customerId=10000&status=Open&pageSize=10`
            
`GET /salesorders?orderBy=lastModified%20asc`
            
`GET /salesorders?expand=all&pageSize=100`
            
When any `expand` value is specified, the effective maximum `pageSize` is `100`.

## API Source

- Endpoint: `/api/v3/SalesOrders`
- Operation: `get /api/v3/SalesOrders`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 294 |
| 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 |
|---|---|:---:|---|---|
| `customerId` | `` | [ ] |  | The customer for which to retrieve orders. If omitted or empty, orders for all customers are included |
| `modifiedSince` | `` | [ ] |  | A date/time value for filtering when a sales order last changed. Unless a specific time zone offset is included (e.g. '2012-12-24T12:15:14+02:00'), the date is considered to be in the UTC time zone. |
| `status` | `` | [ ] |  | The order status to include in the result. If omitted or empty, orders with any status are included. |

## Table Columns

The columns of the table `SalesOrderCommissions` 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. |
| `amount` | `double` | Amount | [ ] | writable, `amount` | The commission amount |
| `billing_address_city` | `varchar2` | itgen_vnet_billing_address_city | [ ] | filters on the platform, writable, `::ancestor.billing.address.city` | The city |
| `billing_address_country_id` | `varchar2` | itgen_vnet_billing_address_country_id | [ ] | filters on the platform, writable, `::ancestor.billing.address.country.id` | The id |
| `billing_address_country_name` | `varchar2` | itgen_vnet_billing_address_country_name | [ ] | filters on the platform, writable, `::ancestor.billing.address.country.name` | The name |
| `billing_address_county_id` | `varchar2` | itgen_vnet_billing_address_county_id | [ ] | filters on the platform, writable, `::ancestor.billing.address.county.id` | The id |
| `billing_address_county_name` | `varchar2` | itgen_vnet_billing_address_county_name | [ ] | filters on the platform, writable, `::ancestor.billing.address.county.name` | The name |
| `billing_address_id` | `int32` | itgen_vnet_billing_address_id | [ ] | filters on the platform, writable, `::ancestor.billing.address.id` | The address id |
| `billing_address_line1` | `varchar2` | itgen_vnet_billing_address_line1 | [ ] | filters on the platform, writable, `::ancestor.billing.address.line1` | Address line 1 |
| `billing_address_line2` | `varchar2` | itgen_vnet_billing_address_line2 | [ ] | filters on the platform, writable, `::ancestor.billing.address.line2` | Address line 2 |
| `billing_address_line3` | `varchar2` | itgen_vnet_billing_address_line3 | [ ] | filters on the platform, writable, `::ancestor.billing.address.line3` | Address line 3 |
| `billing_address_overridesDefault` | `char` | itgen_vnet_billing_address_overridesdefault | [ ] | filters on the platform, writable, `::ancestor.billing.address.overridesDefault` | Whether this address overrides the default address |
| `billing_address_postalCode` | `varchar2` | itgen_vnet_billing_address_postalcode | [ ] | filters on the platform, writable, `::ancestor.billing.address.postalCode` | The postal code |
| `billing_contact_attention` | `varchar2` | itgen_vnet_billing_contact_attention | [ ] | filters on the platform, writable, `::ancestor.billing.contact.attention` | Any attention for the contact |
| `billing_contact_email` | `varchar2` | itgen_vnet_billing_contact_email | [ ] | filters on the platform, writable, `::ancestor.billing.contact.email` | The e-mail address of the contact |
| `billing_contact_fax` | `varchar2` | itgen_vnet_billing_contact_fax | [ ] | filters on the platform, writable, `::ancestor.billing.contact.fax` | The fax number of the contact |
| `billing_contact_id` | `int32` | itgen_vnet_billing_contact_id | [ ] | filters on the platform, writable, `::ancestor.billing.contact.id` | The id of the contact |
| `billing_contact_name` | `varchar2` | itgen_vnet_billing_contact_name | [ ] | filters on the platform, writable, `::ancestor.billing.contact.name` | The name of the contact |
| `billing_contact_overridesDefault` | `char` | itgen_vnet_billing_contact_overridesdefault | [ ] | filters on the platform, writable, `::ancestor.billing.contact.overridesDefault` | Whether this overrides the default contact |
| `billing_contact_phone1` | `varchar2` | itgen_vnet_billing_contact_phone1 | [ ] | filters on the platform, writable, `::ancestor.billing.contact.phone1` | The phone number of the contact |
| `billing_contact_phone2` | `varchar2` | itgen_vnet_billing_contact_phone2 | [ ] | filters on the platform, writable, `::ancestor.billing.contact.phone2` | The secondary phone number of the contact |
| `branch_description` | `varchar2` | itgen_vnet_branch_description | [ ] | filters on the platform, writable, `::ancestor.branch.description` | The description |
| `branch_id` | `varchar2` | itgen_vnet_branch_id | [ ] | filters on the platform, writable, `::ancestor.branch.id` | The id |
| `c_links` | `varchar2` | itgen_vnet_c_links | [ ] | writable | Links applicable for the dto The JSON text of the nested object. |
| `cancelBy` | `datetime` | Cancel by | [ ] | filters on the platform, writable, `::ancestor.cancelBy` | The cancel date for the order |
| `commissionableAmount` | `double` | itgen_vnet_commissionableamount | [ ] | writable, `commissionableAmount` | The order's commissionable amount |
| `createdBy` | `varchar2` | itgen_vnet_createdby | [ ] | filters on the platform, writable, `::ancestor.createdBy` | The user name of the creator of the order. If the order was created by an API call this field will be null or empty. |
| `currency` | `varchar2` | Currency | [ ] | filters on the platform, writable, `::ancestor.currency` | The currency id for the order |
| `currencyRate` | `double` | itgen_vnet_currencyrate | [ ] | filters on the platform, writable, `::ancestor.currencyRate` | The currency rate of the order. To calculate the order amount in base currency, take the order amount and multiply with the currencyRate. |
| `customFields_customDateTimeUtc1` | `datetime` | itgen_vnet_customfields_customdatetimeutc1 | [ ] | filters on the platform, writable, `::ancestor.customFields.customDateTimeUtc1` | A free custom colum of type DateTime - in UTC timezone |
| `customFields_customDec1` | `double` | itgen_vnet_customfields_customdec1 | [ ] | filters on the platform, writable, `::ancestor.customFields.customDec1` | A free custom colum of type decimal with max 4 decimals. |
| `customFields_customDec2` | `double` | itgen_vnet_customfields_customdec2 | [ ] | filters on the platform, writable, `::ancestor.customFields.customDec2` | A free custom colum of type decimal with max 4 decimals. |
| `customFields_customInt1` | `int32` | itgen_vnet_customfields_customint1 | [ ] | filters on the platform, writable, `::ancestor.customFields.customInt1` | A free custom colum of type int |
| `customFields_customInt2` | `int32` | itgen_vnet_customfields_customint2 | [ ] | filters on the platform, writable, `::ancestor.customFields.customInt2` | A free custom colum of type int |
| `customFields_customStr1` | `varchar2` | itgen_vnet_customfields_customstr1 | [ ] | filters on the platform, writable, `::ancestor.customFields.customStr1` | A free custom colum of type string with max length 100. |
| `customFields_customStr2` | `varchar2` | itgen_vnet_customfields_customstr2 | [ ] | filters on the platform, writable, `::ancestor.customFields.customStr2` | A free custom colum of type string with max length 100. |
| `customFields_customStr3` | `varchar2` | itgen_vnet_customfields_customstr3 | [ ] | filters on the platform, writable, `::ancestor.customFields.customStr3` | A free custom colum of type string with max length 100. |
| `customFields_customStr4` | `varchar2` | itgen_vnet_customfields_customstr4 | [ ] | filters on the platform, writable, `::ancestor.customFields.customStr4` | A free custom colum of type string with max length 100. |
| `customFields_customStr5` | `varchar2` | itgen_vnet_customfields_customstr5 | [ ] | filters on the platform, writable, `::ancestor.customFields.customStr5` | A free custom colum of type string with max length 100. |
| `customerId` | `varchar2` | itgen_vnet_customerid | [ ] | filters on the platform, writable, `::ancestor.customerId` | The customer Id for the order (a.k.a CustomerCd) |
| `customerName` | `varchar2` | itgen_vnet_customername | [ ] | filters on the platform, writable, `::ancestor.customerName` | The name of the customer as it appears on the order |
| `customerOrder` | `varchar2` | Customer Order | [ ] | filters on the platform, writable, `::ancestor.customerOrder` | The customer order link |
| `customerRefNo` | `varchar2` | Customer Reference Number | [ ] | filters on the platform, writable, `::ancestor.customerRefNo` | The order reference number of the customer |
| `customer_contactId` | `int32` | itgen_vnet_customer_contactid | [ ] | filters on the platform, writable, `::ancestor.customer.contactId` | The contact id for the customer |
| `customer_id` | `varchar2` | itgen_vnet_customer_id | [ ] | filters on the platform, writable, `::ancestor.customer.id` | The unique id of the the customer |
| `customer_internalId` | `int32` | Customer Internal ID | [ ] | filters on the platform, writable, `::ancestor.customer.internalId` | An internal unique id of the customer |
| `customer_location_corporateId` | `varchar2` | itgen_vnet_customer_location_corporateid | [ ] | filters on the platform, writable, `::ancestor.customer.location.corporateId` | The corporate id of the location |
| `customer_location_countryId` | `varchar2` | itgen_vnet_customer_location_countryid | [ ] | filters on the platform, writable, `::ancestor.customer.location.countryId` | The country code of the location |
| `customer_location_gln` | `varchar2` | itgen_vnet_customer_location_gln | [ ] | filters on the platform, writable, `::ancestor.customer.location.gln` | The global localization number of the location |
| `customer_location_id` | `varchar2` | itgen_vnet_customer_location_id | [ ] | filters on the platform, writable, `::ancestor.customer.location.id` | Location id |
| `customer_location_internalId` | `int32` | itgen_vnet_customer_location_internalid | [ ] | filters on the platform, writable, `::ancestor.customer.location.internalId` | An internal id of the customer location |
| `customer_location_name` | `varchar2` | itgen_vnet_customer_location_name | [ ] | filters on the platform, writable, `::ancestor.customer.location.name` | Location description |
| `customer_location_taxRegistrationId` | `varchar2` | itgen_vnet_customer_location_taxregistrationid | [ ] | filters on the platform, writable, `::ancestor.customer.location.taxRegistrationId` | The tax registration id of the location |
| `customer_location_warehouseId` | `varchar2` | itgen_vnet_customer_location_warehouseid | [ ] | filters on the platform, writable, `::ancestor.customer.location.warehouseId` | The site id of the location |
| `customer_name` | `varchar2` | Customer Name | [ ] | filters on the platform, writable, `::ancestor.customer.name` | The customer name |
| `customer_order` | `varchar2` | itgen_vnet_customer_order | [ ] | filters on the platform, writable, `::ancestor.customer.order` | The customer order text |
| `customer_refNo` | `varchar2` | itgen_vnet_customer_refno | [ ] | filters on the platform, writable, `::ancestor.customer.refNo` | The customer ref number text |
| `customer_taxZone_description` | `varchar2` | itgen_vnet_customer_taxzone_description | [ ] | filters on the platform, writable, `::ancestor.customer.taxZone.description` | The description |
| `customer_taxZone_id` | `varchar2` | itgen_vnet_customer_taxzone_id | [ ] | filters on the platform, writable, `::ancestor.customer.taxZone.id` | The id |
| `date` | `datetime` | Date | [ ] | filters on the platform, writable, `::ancestor.date` |  |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `::ancestor.description` | Any description on the order |
| `emailed` | `char` | Emailed | [ ] | filters on the platform, writable, `::ancestor.emailed` | Indicates if the document was emailed |
| `financialInformation_cashDiscountDate` | `datetime` | itgen_vnet_financialinformation_cashdiscountdate | [ ] | filters on the platform, writable, `::ancestor.financialInformation.cashDiscountDate` |  |
| `financialInformation_dueDate` | `datetime` | itgen_vnet_financialinformation_duedate | [ ] | filters on the platform, writable, `::ancestor.financialInformation.dueDate` |  |
| `financialInformation_invoiceDate` | `datetime` | itgen_vnet_financialinformation_invoicedate | [ ] | filters on the platform, writable, `::ancestor.financialInformation.invoiceDate` |  |
| `financialInformation_invoiceId` | `varchar2` | itgen_vnet_financialinformation_invoiceid | [ ] | filters on the platform, writable, `::ancestor.financialInformation.invoiceId` | The id of the invoice issued for the order |
| `financialInformation_invoiceSeparately` | `char` | itgen_vnet_financialinformation_invoiceseparately | [ ] | filters on the platform, writable, `::ancestor.financialInformation.invoiceSeparately` | Whether the order should be invoiced separately |
| `financialInformation_postPeriod` | `varchar2` | itgen_vnet_financialinformation_postperiod | [ ] | filters on the platform, writable, `::ancestor.financialInformation.postPeriod` | The post period for the invoice |
| `financialInformation_terms_description` | `varchar2` | itgen_vnet_financialinformation_terms_description | [ ] | filters on the platform, writable, `::ancestor.financialInformation.terms.description` | The description |
| `financialInformation_terms_id` | `varchar2` | itgen_vnet_financialinformation_terms_id | [ ] | filters on the platform, writable, `::ancestor.financialInformation.terms.id` | The id |
| `freight_amount` | `double` | itgen_vnet_freight_amount | [ ] | filters on the platform, writable, `::ancestor.freight.amount` | The amounts calculated based on the ship terms. /// |
| `freight_amountInBaseCurrency` | `double` | itgen_vnet_freight_amountinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.freight.amountInBaseCurrency` | The amounts calculated based on the ship terms in base currency of the order. |
| `freight_cost` | `double` | itgen_vnet_freight_cost | [ ] | filters on the platform, writable, `::ancestor.freight.cost` | The freight cost calculated for the sales order, |
| `freight_costInBaseCurrency` | `double` | itgen_vnet_freight_costinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.freight.costInBaseCurrency` | The freight cost calculated for the sales order in base currency. |
| `freight_premiumAmount` | `double` | itgen_vnet_freight_premiumamount | [ ] | filters on the platform, writable, `::ancestor.freight.premiumAmount` | The additional freight charges for handling the order. |
| `freight_premiumAmountInBaseCurrency` | `double` | itgen_vnet_freight_premiumamountinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.freight.premiumAmountInBaseCurrency` | The additional freight charges in base currency for handling the order. |
| `freight_taxCategoryId` | `varchar2` | itgen_vnet_freight_taxcategoryid | [ ] | filters on the platform, writable, `::ancestor.freight.taxCategoryId` | The tax category that applies to the freight amount. By default, it is the tax category associated with the ship via code selected for the order. |
| `freight_volume` | `double` | itgen_vnet_freight_volume | [ ] | filters on the platform, writable, `::ancestor.freight.volume` |  |
| `freight_weight` | `double` | itgen_vnet_freight_weight | [ ] | filters on the platform, writable, `::ancestor.freight.weight` |  |
| `isRotRutDeductible` | `char` | itgen_vnet_isrotrutdeductible | [ ] | filters on the platform, writable, `::ancestor.isRotRutDeductible` | Whether the order is ROT/RUT deductible |
| `lastModified` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `::ancestor.lastModified` | The date and time the order was last modified |
| `location` | `varchar2` | itgen_vnet_location | [ ] | filters on the platform, writable, `::ancestor.location` | The customer location for this order |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable, `::ancestor.note` | Any notes on the order |
| `orderId` | `varchar2` | itgen_vnet_orderid | [ ] | filters on the platform, writable, `::ancestor.orderId` | The order id (a.k.a OrderCd) for the order |
| `orderQty` | `double` | Order Quantity | [ ] | filters on the platform, writable, `::ancestor.orderQty` | The total number of items on the order |
| `orderTotal` | `double` | Order Total | [ ] | filters on the platform, writable, `::ancestor.orderTotal` | The total amount on the order |
| `origin__links` | `varchar2` | itgen_vnet_origin__links | [ ] | writable | Links applicable for the dto The JSON text of the nested object. |
| `origin_orderId` | `varchar2` | itgen_vnet_origin_orderid | [ ] | filters on the platform, writable, `::ancestor.origin.orderId` | The unique id of the origin order |
| `origin_orderType` | `varchar2` | itgen_vnet_origin_ordertype | [ ] | filters on the platform, writable, `::ancestor.origin.orderType` | The order type code for the origin order |
| `originalOrderId` | `varchar2` | itgen_vnet_originalorderid | [ ] | filters on the platform, writable, `::ancestor.originalOrderId` | The unique identifier of the original order |
| `originalOrderType` | `varchar2` | itgen_vnet_originalordertype | [ ] | filters on the platform, writable, `::ancestor.originalOrderType` | The type code for the original sales order |
| `owner_id` | `varchar2` | Owner ID | [ ] | filters on the platform, writable, `::ancestor.owner.id` | The identifier of the employee |
| `owner_internalId` | `varchar2` | Owner Internal ID | [ ] | filters on the platform, writable, `::ancestor.owner.internalId` | The internal unique identifier of the employee |
| `parentCustomer_id` | `varchar2` | itgen_vnet_parentcustomer_id | [ ] | filters on the platform, writable, `::ancestor.parentCustomer.id` | The unique id of the the customer |
| `parentCustomer_internalId` | `int32` | itgen_vnet_parentcustomer_internalid | [ ] | filters on the platform, writable, `::ancestor.parentCustomer.internalId` | An internal unique id of the customer |
| `parentCustomer_name` | `varchar2` | itgen_vnet_parentcustomer_name | [ ] | filters on the platform, writable, `::ancestor.parentCustomer.name` | The customer name |
| `paymentSettings_cashAccountId` | `varchar2` | itgen_vnet_paymentsettings_cashaccountid | [ ] | filters on the platform, writable, `::ancestor.paymentSettings.cashAccountId` | The cash account to use |
| `paymentSettings_paymentMethod_description` | `varchar2` | itgen_vnet_paymentsettings_paymentmethod_description | [ ] | filters on the platform, writable, `::ancestor.paymentSettings.paymentMethod.description` | The description |
| `paymentSettings_paymentMethod_id` | `varchar2` | itgen_vnet_paymentsettings_paymentmethod_id | [ ] | filters on the platform, writable, `::ancestor.paymentSettings.paymentMethod.id` | The id |
| `paymentSettings_paymentReference` | `varchar2` | itgen_vnet_paymentsettings_paymentreference | [ ] | filters on the platform, writable, `::ancestor.paymentSettings.paymentReference` | The payment reference |
| `percent` | `double` | itgen_vnet_percent | [ ] | writable, `percent` | The commission percent |
| `print_descriptionOnInvoice` | `char` | itgen_vnet_print_descriptiononinvoice | [ ] | filters on the platform, writable, `::ancestor.print.descriptionOnInvoice` | Set to true to print description on the invoice |
| `print_noteOnExternalDocuments` | `char` | itgen_vnet_print_noteonexternaldocuments | [ ] | filters on the platform, writable, `::ancestor.print.noteOnExternalDocuments` | Set to true to print note on external documents |
| `print_noteOnInternalDocuments` | `char` | itgen_vnet_print_noteoninternaldocuments | [ ] | filters on the platform, writable, `::ancestor.print.noteOnInternalDocuments` | Set to true to print note on internal documents |
| `project_description` | `varchar2` | Project Description | [ ] | filters on the platform, writable, `::ancestor.project.description` | The description |
| `project_id` | `varchar2` | Project ID | [ ] | filters on the platform, writable, `::ancestor.project.id` | The id |
| `project_internalId` | `int32` | itgen_vnet_project_internalid | [ ] | filters on the platform, writable, `::ancestor.project.internalId` | An internal unique identifier of the project |
| `requestOn` | `datetime` | Request On | [ ] | filters on the platform, writable, `::ancestor.requestOn` |  |
| `rotRut_apartment` | `varchar2` | itgen_vnet_rotrut_apartment | [ ] | filters on the platform, writable, `::ancestor.rotRut.apartment` | The apartment reference |
| `rotRut_distributedAmount` | `double` | itgen_vnet_rotrut_distributedamount | [ ] | filters on the platform, writable, `::ancestor.rotRut.distributedAmount` | The total amount distributed among the specified personal IDs |
| `rotRut_distributedAutomatically` | `char` | itgen_vnet_rotrut_distributedautomatically | [ ] | filters on the platform, writable, `::ancestor.rotRut.distributedAutomatically` | Whether the ROT/RUT is distributed automatically |
| `rotRut_estate` | `varchar2` | itgen_vnet_rotrut_estate | [ ] | filters on the platform, writable, `::ancestor.rotRut.estate` | The estate reference |
| `rotRut_materialCostAmount` | `double` | itgen_vnet_rotrut_materialcostamount | [ ] | filters on the platform, writable, `::ancestor.rotRut.materialCostAmount` | Cost amount for lines with inventory ROT/RUT item type Material |
| `rotRut_organizationNumber` | `varchar2` | itgen_vnet_rotrut_organizationnumber | [ ] | filters on the platform, writable, `::ancestor.rotRut.organizationNumber` | The organization number |
| `rotRut_otherCostAmount` | `double` | itgen_vnet_rotrut_othercostamount | [ ] | filters on the platform, writable, `::ancestor.rotRut.otherCostAmount` | Cost amount for lines with inventory ROT/RUT item type OtherCost |
| `rotRut_totalDeductableAmount` | `double` | itgen_vnet_rotrut_totaldeductableamount | [ ] | filters on the platform, writable, `::ancestor.rotRut.totalDeductableAmount` | The total amount that is tax deductable |
| `rotRut_type` | `varchar2` | itgen_vnet_rotrut_type | [ ] | filters on the platform, writable, `::ancestor.rotRut.type` | The type of ROT/RUT |
| `rotRut_workPriceAmount` | `double` | itgen_vnet_rotrut_workpriceamount | [ ] | filters on the platform, writable, `::ancestor.rotRut.workPriceAmount` | Price amount for lines with inventory ROT/RUT item type Service |
| `salesPersonId` | `varchar2` | Sales Person ID | [ ] | writable, `salesPersonId` | The id of the sales person that gets the commision |
| `salesPerson_description` | `varchar2` | Sales Person Description | [ ] | filters on the platform, writable, `::ancestor.salesPerson.description` | The description |
| `salesPerson_id` | `varchar2` | Sales Person ID | [ ] | filters on the platform, writable, `::ancestor.salesPerson.id` | The id |
| `shippingScheduledDate` | `datetime` | itgen_vnet_shippingscheduleddate | [ ] | filters on the platform, writable, `::ancestor.shippingScheduledDate` |  |
| `shipping_address_city` | `varchar2` | itgen_vnet_shipping_address_city | [ ] | filters on the platform, writable, `::ancestor.shipping.address.city` | The city |
| `shipping_address_country_id` | `varchar2` | itgen_vnet_shipping_address_country_id | [ ] | filters on the platform, writable, `::ancestor.shipping.address.country.id` | The id |
| `shipping_address_country_name` | `varchar2` | itgen_vnet_shipping_address_country_name | [ ] | filters on the platform, writable, `::ancestor.shipping.address.country.name` | The name |
| `shipping_address_county_id` | `varchar2` | itgen_vnet_shipping_address_county_id | [ ] | filters on the platform, writable, `::ancestor.shipping.address.county.id` | The id |
| `shipping_address_county_name` | `varchar2` | itgen_vnet_shipping_address_county_name | [ ] | filters on the platform, writable, `::ancestor.shipping.address.county.name` | The name |
| `shipping_address_id` | `int32` | itgen_vnet_shipping_address_id | [ ] | filters on the platform, writable, `::ancestor.shipping.address.id` | The address id |
| `shipping_address_line1` | `varchar2` | itgen_vnet_shipping_address_line1 | [ ] | filters on the platform, writable, `::ancestor.shipping.address.line1` | Address line 1 |
| `shipping_address_line2` | `varchar2` | itgen_vnet_shipping_address_line2 | [ ] | filters on the platform, writable, `::ancestor.shipping.address.line2` | Address line 2 |
| `shipping_address_line3` | `varchar2` | itgen_vnet_shipping_address_line3 | [ ] | filters on the platform, writable, `::ancestor.shipping.address.line3` | Address line 3 |
| `shipping_address_overridesDefault` | `char` | itgen_vnet_shipping_address_overridesdefault | [ ] | filters on the platform, writable, `::ancestor.shipping.address.overridesDefault` | Whether this address overrides the default address |
| `shipping_address_postalCode` | `varchar2` | itgen_vnet_shipping_address_postalcode | [ ] | filters on the platform, writable, `::ancestor.shipping.address.postalCode` | The postal code |
| `shipping_contact_attention` | `varchar2` | itgen_vnet_shipping_contact_attention | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.attention` | Any attention for the contact |
| `shipping_contact_email` | `varchar2` | itgen_vnet_shipping_contact_email | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.email` | The e-mail address of the contact |
| `shipping_contact_fax` | `varchar2` | itgen_vnet_shipping_contact_fax | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.fax` | The fax number of the contact |
| `shipping_contact_id` | `int32` | itgen_vnet_shipping_contact_id | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.id` | The id of the contact |
| `shipping_contact_name` | `varchar2` | itgen_vnet_shipping_contact_name | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.name` | The name of the contact |
| `shipping_contact_overridesDefault` | `char` | itgen_vnet_shipping_contact_overridesdefault | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.overridesDefault` | Whether this overrides the default contact |
| `shipping_contact_phone1` | `varchar2` | itgen_vnet_shipping_contact_phone1 | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.phone1` | The phone number of the contact |
| `shipping_contact_phone2` | `varchar2` | itgen_vnet_shipping_contact_phone2 | [ ] | filters on the platform, writable, `::ancestor.shipping.contact.phone2` | The secondary phone number of the contact |
| `shipping_fobPoint_description` | `varchar2` | itgen_vnet_shipping_fobpoint_description | [ ] | filters on the platform, writable, `::ancestor.shipping.fobPoint.description` | The description |
| `shipping_fobPoint_id` | `varchar2` | itgen_vnet_shipping_fobpoint_id | [ ] | filters on the platform, writable, `::ancestor.shipping.fobPoint.id` | The id |
| `shipping_insurance` | `char` | itgen_vnet_shipping_insurance | [ ] | filters on the platform, writable, `::ancestor.shipping.insurance` | Whether insurance applies to this shipping |
| `shipping_intrastatTransactionType_description` | `varchar2` | itgen_vnet_shipping_intrastattransactiontype_description | [ ] | filters on the platform, writable, `::ancestor.shipping.intrastatTransactionType.description` | The description |
| `shipping_intrastatTransactionType_id` | `int32` | itgen_vnet_shipping_intrastattransactiontype_id | [ ] | filters on the platform, writable, `::ancestor.shipping.intrastatTransactionType.id` | The id |
| `shipping_preferredWarehouse_description` | `varchar2` | itgen_vnet_shipping_preferredwarehouse_description | [ ] | filters on the platform, writable, `::ancestor.shipping.preferredWarehouse.description` | The description |
| `shipping_preferredWarehouse_id` | `varchar2` | itgen_vnet_shipping_preferredwarehouse_id | [ ] | filters on the platform, writable, `::ancestor.shipping.preferredWarehouse.id` | The id |
| `shipping_priority` | `int32` | itgen_vnet_shipping_priority | [ ] | filters on the platform, writable, `::ancestor.shipping.priority` | Priority of the order |
| `shipping_residentialDelivery` | `char` | itgen_vnet_shipping_residentialdelivery | [ ] | filters on the platform, writable, `::ancestor.shipping.residentialDelivery` | Whether this is residential delivery |
| `shipping_rule` | `varchar2` | itgen_vnet_shipping_rule | [ ] | filters on the platform, writable, `::ancestor.shipping.rule` | The shipping rule |
| `shipping_saturdayDelivery` | `char` | itgen_vnet_shipping_saturdaydelivery | [ ] | filters on the platform, writable, `::ancestor.shipping.saturdayDelivery` | Whether this is a saturday delivery |
| `shipping_scheduledDate` | `datetime` | itgen_vnet_shipping_scheduleddate | [ ] | filters on the platform, writable, `::ancestor.shipping.scheduledDate` | The shipping scheduled date |
| `shipping_shipSeparately` | `char` | itgen_vnet_shipping_shipseparately | [ ] | filters on the platform, writable, `::ancestor.shipping.shipSeparately` | Whether this order can/is shipped separately |
| `shipping_shipVia_description` | `varchar2` | itgen_vnet_shipping_shipvia_description | [ ] | filters on the platform, writable, `::ancestor.shipping.shipVia.description` | The description |
| `shipping_shipVia_id` | `varchar2` | itgen_vnet_shipping_shipvia_id | [ ] | filters on the platform, writable, `::ancestor.shipping.shipVia.id` | The id |
| `shipping_terms_description` | `varchar2` | itgen_vnet_shipping_terms_description | [ ] | filters on the platform, writable, `::ancestor.shipping.terms.description` | The description |
| `shipping_terms_id` | `varchar2` | itgen_vnet_shipping_terms_id | [ ] | filters on the platform, writable, `::ancestor.shipping.terms.id` | The id |
| `shipping_zone_description` | `varchar2` | itgen_vnet_shipping_zone_description | [ ] | filters on the platform, writable, `::ancestor.shipping.zone.description` | The description |
| `shipping_zone_id` | `varchar2` | itgen_vnet_shipping_zone_id | [ ] | filters on the platform, writable, `::ancestor.shipping.zone.id` | The id |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `::ancestor.status` | The current status of the order |
| `statusDetails_cancelled` | `char` | itgen_vnet_statusdetails_cancelled | [ ] | filters on the platform, writable, `::ancestor.statusDetails.cancelled` | Whether this order is in a cancelled state |
| `statusDetails_description` | `varchar2` | itgen_vnet_statusdetails_description | [ ] | filters on the platform, writable, `::ancestor.statusDetails.description` | The status name for the order |
| `statusDetails_hold` | `char` | itgen_vnet_statusdetails_hold | [ ] | filters on the platform, writable, `::ancestor.statusDetails.hold` | Whether this order is in a held state |
| `taxTotal` | `double` | Tax Total | [ ] | filters on the platform, writable, `::ancestor.taxTotal` | The tax total |
| `totals_costTotal` | `double` | itgen_vnet_totals_costtotal | [ ] | filters on the platform, writable, `::ancestor.totals.costTotal` | The total of the costs on the lines of the sales order. How the `costTotal` is calculated is dependent on the option `useReplacementCostForMarginAndProfit`. If this option is `true` the `costTotal` will be calculated based on the `replacementUnitCost`. If this option is `false`, the `costTotal` will be calculate based on `unitCost` |
| `totals_costTotalInBaseCurrency` | `double` | itgen_vnet_totals_costtotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.costTotalInBaseCurrency` | The total of the costs on the lines of the sales order in base currency. |
| `totals_discountTotal` | `double` | itgen_vnet_totals_discounttotal | [ ] | filters on the platform, writable, `::ancestor.totals.discountTotal` | The discount total |
| `totals_discountTotalInBaseCurrency` | `double` | itgen_vnet_totals_discounttotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.discountTotalInBaseCurrency` | The discount total in base currency |
| `totals_exciseDutyTotal` | `double` | itgen_vnet_totals_excisedutytotal | [ ] | filters on the platform, writable, `::ancestor.totals.exciseDutyTotal` | The sum of excise duty for the lines |
| `totals_exciseDutyTotalInBaseCurrency` | `double` | itgen_vnet_totals_excisedutytotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.exciseDutyTotalInBaseCurrency` | The sum of excise duty for the lines in base currency |
| `totals_freightCost` | `double` | itgen_vnet_totals_freightcost | [ ] | filters on the platform, writable, `::ancestor.totals.freightCost` | The freight cost calculated for the sales order. Not applicable for transfer order types. |
| `totals_freightCostInBaseCurrency` | `double` | itgen_vnet_totals_freightcostinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.freightCostInBaseCurrency` | The freight cost calculated for the sales order in base currency. Not applicable for transfer order types. |
| `totals_freightTotal` | `double` | itgen_vnet_totals_freighttotal | [ ] | filters on the platform, writable, `::ancestor.totals.freightTotal` | The freight amount calculated in accordance with the shipping terms. Not applicable for transfer order types. |
| `totals_freightTotalInBaseCurrency` | `double` | itgen_vnet_totals_freighttotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.freightTotalInBaseCurrency` | The freight amount calculated in accordance with the shipping terms in base currency. Not applicable for transfer order types. |
| `totals_orderTotal` | `double` | itgen_vnet_totals_ordertotal | [ ] | filters on the platform, writable, `::ancestor.totals.orderTotal` | The order total |
| `totals_orderTotalInBaseCurrency` | `double` | itgen_vnet_totals_ordertotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.orderTotalInBaseCurrency` | The order total in base currency |
| `totals_paymentTotal` | `double` | itgen_vnet_totals_paymenttotal | [ ] | filters on the platform, writable, `::ancestor.totals.paymentTotal` | The total amount of payments connected to the order in the order currency |
| `totals_paymentTotalInBaseCurrency` | `double` | itgen_vnet_totals_paymenttotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.paymentTotalInBaseCurrency` | The total amount of payments connected to the order in the base currency |
| `totals_taxExemptTotal` | `double` | itgen_vnet_totals_taxexempttotal | [ ] | filters on the platform, writable, `::ancestor.totals.taxExemptTotal` | The VAT exempt total |
| `totals_taxExemptTotalInBaseCurrency` | `double` | itgen_vnet_totals_taxexempttotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.taxExemptTotalInBaseCurrency` | The VAT exempt total in base currency |
| `totals_taxTotal` | `double` | itgen_vnet_totals_taxtotal | [ ] | filters on the platform, writable, `::ancestor.totals.taxTotal` | The tax total |
| `totals_taxTotalInBaseCurrency` | `double` | itgen_vnet_totals_taxtotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.taxTotalInBaseCurrency` | The tax total in base currency |
| `totals_taxableTotal` | `double` | itgen_vnet_totals_taxabletotal | [ ] | filters on the platform, writable, `::ancestor.totals.taxableTotal` | The VAT taxable total |
| `totals_taxableTotalInBaseCurrency` | `double` | itgen_vnet_totals_taxabletotalinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.taxableTotalInBaseCurrency` | The VAT taxable in base currency |
| `totals_unbilledAmount` | `double` | itgen_vnet_totals_unbilledamount | [ ] | filters on the platform, writable, `::ancestor.totals.unbilledAmount` | The sum of unbilled amounts for the lines |
| `totals_unbilledAmountInBaseCurrency` | `double` | itgen_vnet_totals_unbilledamountinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.unbilledAmountInBaseCurrency` | The sum of unbilled amounts for the lines in base currency |
| `totals_unshippedAmount` | `double` | itgen_vnet_totals_unshippedamount | [ ] | filters on the platform, writable, `::ancestor.totals.unshippedAmount` | The sum of unshipped amounts for the lines |
| `totals_unshippedAmountInBaseCurrency` | `double` | itgen_vnet_totals_unshippedamountinbasecurrency | [ ] | filters on the platform, writable, `::ancestor.totals.unshippedAmountInBaseCurrency` | The sum of unshipped amounts for the lines in base currency |
| `type` | `varchar2` | Type | [ ] | filters on the platform, writable, `::ancestor.type` | The type of the order |
| `useReplacementCostForMarginAndProfit` | `char` | itgen_vnet_usereplacementcostformarginandprofit | [ ] | filters on the platform, writable, `::ancestor.useReplacementCostForMarginAndProfit` | When this option is set to `true`, the `costTotal` of the order will be calculated based on `replacementUnitCost`. If option is set to `false`, the `costTotal` will be calculated based on `unitCost` |
| `version` | `blob` | itgen_vnet_version | [ ] | filters on the platform, writable, `::ancestor.version` | An internal order version used for detecting concurrent updates to an order |



## 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)

