invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesOrderCommissionsViaOrderByTypeOrderId: Visma.net Financials itgen_vnet_salesordercommissionsviaorderbytypeorderid_plural

read only REST

  • Catalog: NgSalesOrders
  • Schema: SalesOrders
  • Label: itgen_vnet_salesordercommissionsviaorderbytypeorderid_plural

Gets information about a single sales order The expand query parameter corresponds to sections in the Visma.net.ERP.SalesOrders.Api.Dto.SalesOrder.SalesOrderDto. If an expand value is not specified it will not be filled and returned in the response object.

Sample request:

GET /salesorders/SO/000100?expand=customer,payment

GET /salesorders/SO/000100?expand=lines,linefees

Can only retrieve data.

Summary

The expand query parameter corresponds to sections in the Visma.net.ERP.SalesOrders.Api.Dto.SalesOrder.SalesOrderDto. If an expand value is not specified it will not be filled and returned in the response object.

Sample request:

GET /salesorders/SO/000100?expand=customer,payment

GET /salesorders/SO/000100?expand=lines,linefees

API Source

  • Endpoint: /api/v3/SalesOrders/{type}/{orderId}
  • Operation: get /api/v3/SalesOrders/{type}/{orderId}

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
orderId `` The id of the sales order to get
type `` The type of sales order to get

Table Columns

The columns of the table SalesOrderCommissionsViaOrderByTypeOrderId 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.
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
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.
currencyId varchar2 Currency ID filters on the platform, writable, ::ancestor.currencyId CurrencyId 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.
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 Date the order was submitted
description varchar2 Description filters on the platform, writable, ::ancestor.description Description of 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 Date the order was last modified Unless a specific time zone offset is included (e.g. '2012-12-24T00:00:00+02:00'), the passed date is considered to be in the UTC time zone.
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 unique identifier of the order
orderQty double Order Quantity filters on the platform, writable, ::ancestor.orderQty The total quantity of inventory items in 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 Date the order was requested
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
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_cancelled char itgen_vnet_status_cancelled filters on the platform, writable, ::ancestor.status.cancelled Whether this order is in a cancelled state
status_description varchar2 itgen_vnet_status_description filters on the platform, writable, ::ancestor.status.description The status name for the order
status_hold char itgen_vnet_status_hold filters on the platform, writable, ::ancestor.status.hold Whether this order is in a held state
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 code for the sales 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: