invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesOrderLinePurchaseOrderNumbersViaOrderByTypeOrderId: Visma.net Financials itgen_vnet_salesorderlinepurchaseordernumbersviaorderbytypeorderid_plural

read only REST

  • Catalog: NgSalesOrders
  • Schema: SalesOrders
  • Label: itgen_vnet_salesorderlinepurchaseordernumbersviaorderbytypeorderid_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 SalesOrderLinePurchaseOrderNumbersViaOrderByTypeOrderId 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.
TEXT varchar2 itgen_vnet_text writable, ::self
amountNotInvoiced double itgen_vnet_amountnotinvoiced writable, ::ancestor.amountNotInvoiced The invoice amount which is not invoiced for this sales order line
autoCreateIssue char itgen_vnet_autocreateissue writable, ::ancestor.autoCreateIssue Indicates if an order line of issue type will automatically be created after the order line of receipt type has been processed.
baseOrderQuantity double itgen_vnet_baseorderquantity writable, ::ancestor.baseOrderQuantity The base order quantity for this line
billedQuantity double itgen_vnet_billedquantity writable, ::ancestor.billedQuantity The billed quantity for this line
billing_address_city varchar2 itgen_vnet_billing_address_city filters on the platform, writable, ::ancestor.::ancestor.billing.address.city The city
billing_address_country_id varchar2 itgen_vnet_billing_address_country_id filters on the platform, writable, ::ancestor.::ancestor.billing.address.country.id The id
billing_address_country_name varchar2 itgen_vnet_billing_address_country_name filters on the platform, writable, ::ancestor.::ancestor.billing.address.country.name The name
billing_address_county_id varchar2 itgen_vnet_billing_address_county_id filters on the platform, writable, ::ancestor.::ancestor.billing.address.county.id The id
billing_address_county_name varchar2 itgen_vnet_billing_address_county_name filters on the platform, writable, ::ancestor.::ancestor.billing.address.county.name The name
billing_address_id int32 itgen_vnet_billing_address_id filters on the platform, writable, ::ancestor.::ancestor.billing.address.id The address id
billing_address_line1 varchar2 itgen_vnet_billing_address_line1 filters on the platform, writable, ::ancestor.::ancestor.billing.address.line1 Address line 1
billing_address_line2 varchar2 itgen_vnet_billing_address_line2 filters on the platform, writable, ::ancestor.::ancestor.billing.address.line2 Address line 2
billing_address_line3 varchar2 itgen_vnet_billing_address_line3 filters on the platform, writable, ::ancestor.::ancestor.billing.address.line3 Address line 3
billing_address_overridesDefault char itgen_vnet_billing_address_overridesdefault filters on the platform, writable, ::ancestor.::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.::ancestor.billing.address.postalCode The postal code
billing_contact_attention varchar2 itgen_vnet_billing_contact_attention filters on the platform, writable, ::ancestor.::ancestor.billing.contact.attention Any attention for the contact
billing_contact_email varchar2 itgen_vnet_billing_contact_email filters on the platform, writable, ::ancestor.::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.::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.::ancestor.billing.contact.id The id of the contact
billing_contact_name varchar2 itgen_vnet_billing_contact_name filters on the platform, writable, ::ancestor.::ancestor.billing.contact.name The name of the contact
billing_contact_overridesDefault char itgen_vnet_billing_contact_overridesdefault filters on the platform, writable, ::ancestor.::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.::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.::ancestor.billing.contact.phone2 The secondary phone number of the contact
branch_description varchar2 itgen_vnet_branch_description writable, ::ancestor.branch.description The description
branch_description_2 varchar2 itgen_vnet_branch_description_2 filters on the platform, writable, ::ancestor.::ancestor.branch.description The description
branch_id varchar2 itgen_vnet_branch_id writable, ::ancestor.branch.id The id
branch_id_2 varchar2 itgen_vnet_branch_id_2 filters on the platform, writable, ::ancestor.::ancestor.branch.id The id
cancelBy datetime Cancel by filters on the platform, writable, ::ancestor.::ancestor.cancelBy The cancel date for the order
commissionable char Commissionable writable, ::ancestor.commissionable Indicates if line is commissionable
completed char Completed writable, ::ancestor.completed Whether this order line is completed or not
createdBy varchar2 itgen_vnet_createdby filters on the platform, writable, ::ancestor.::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.::ancestor.currencyId CurrencyId for the order.
currencyRate double itgen_vnet_currencyrate filters on the platform, writable, ::ancestor.::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 writable, ::ancestor.customFields.customDateTimeUtc1 A free custom colum of type DateTime - in UTC timezone
customFields_customDateTimeUtc1_2 datetime itgen_vnet_customfields_customdatetimeutc1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customDateTimeUtc1 A free custom colum of type DateTime - in UTC timezone
customFields_customDec1 double itgen_vnet_customfields_customdec1 writable, ::ancestor.customFields.customDec1 A free custom colum of type decimal with max 4 decimals.
customFields_customDec1_2 double itgen_vnet_customfields_customdec1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customDec1 A free custom colum of type decimal with max 4 decimals.
customFields_customDec2 double itgen_vnet_customfields_customdec2 writable, ::ancestor.customFields.customDec2 A free custom colum of type decimal with max 4 decimals.
customFields_customDec2_2 double itgen_vnet_customfields_customdec2_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customDec2 A free custom colum of type decimal with max 4 decimals.
customFields_customInt1 int32 itgen_vnet_customfields_customint1 writable, ::ancestor.customFields.customInt1 A free custom colum of type int
customFields_customInt1_2 int32 itgen_vnet_customfields_customint1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customInt1 A free custom colum of type int
customFields_customInt2 int32 itgen_vnet_customfields_customint2 writable, ::ancestor.customFields.customInt2 A free custom colum of type int
customFields_customInt2_2 int32 itgen_vnet_customfields_customint2_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customInt2 A free custom colum of type int
customFields_customStr1 varchar2 itgen_vnet_customfields_customstr1 writable, ::ancestor.customFields.customStr1 A free custom colum of type string with max length 100.
customFields_customStr1_2 varchar2 itgen_vnet_customfields_customstr1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr1 A free custom colum of type string with max length 100.
customFields_customStr2 varchar2 itgen_vnet_customfields_customstr2 writable, ::ancestor.customFields.customStr2 A free custom colum of type string with max length 100.
customFields_customStr2_2 varchar2 itgen_vnet_customfields_customstr2_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr2 A free custom colum of type string with max length 100.
customFields_customStr3 varchar2 itgen_vnet_customfields_customstr3 writable, ::ancestor.customFields.customStr3 A free custom colum of type string with max length 100.
customFields_customStr3_2 varchar2 itgen_vnet_customfields_customstr3_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr3 A free custom colum of type string with max length 100.
customFields_customStr4 varchar2 itgen_vnet_customfields_customstr4 writable, ::ancestor.customFields.customStr4 A free custom colum of type string with max length 100.
customFields_customStr4_2 varchar2 itgen_vnet_customfields_customstr4_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr4 A free custom colum of type string with max length 100.
customFields_customStr5 varchar2 itgen_vnet_customfields_customstr5 writable, ::ancestor.customFields.customStr5 A free custom colum of type string with max length 100.
customFields_customStr5_2 varchar2 itgen_vnet_customfields_customstr5_2 filters on the platform, writable, ::ancestor.::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.::ancestor.customer.contactId The contact id for the customer
customer_id varchar2 itgen_vnet_customer_id filters on the platform, writable, ::ancestor.::ancestor.customer.id The unique id of the the customer
customer_internalId int32 Customer Internal ID filters on the platform, writable, ::ancestor.::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.::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.::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.::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.::ancestor.customer.location.id Location id
customer_location_internalId int32 itgen_vnet_customer_location_internalid filters on the platform, writable, ::ancestor.::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.::ancestor.customer.location.name Location description
customer_location_taxRegistrationId varchar2 itgen_vnet_customer_location_taxregistrationid filters on the platform, writable, ::ancestor.::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.::ancestor.customer.location.warehouseId The site id of the location
customer_name varchar2 Customer Name filters on the platform, writable, ::ancestor.::ancestor.customer.name The customer name
customer_order varchar2 itgen_vnet_customer_order filters on the platform, writable, ::ancestor.::ancestor.customer.order The customer order text
customer_refNo varchar2 itgen_vnet_customer_refno filters on the platform, writable, ::ancestor.::ancestor.customer.refNo The customer ref number text
customer_taxZone_description varchar2 itgen_vnet_customer_taxzone_description filters on the platform, writable, ::ancestor.::ancestor.customer.taxZone.description The description
customer_taxZone_id varchar2 itgen_vnet_customer_taxzone_id filters on the platform, writable, ::ancestor.::ancestor.customer.taxZone.id The id
date datetime Date filters on the platform, writable, ::ancestor.::ancestor.date Date the order was submitted
description varchar2 Description writable, ::ancestor.description Any description for this order line
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.::ancestor.description Description of the order
discountAmount double itgen_vnet_discountamount writable, ::ancestor.discountAmount The discount amount for this line
discountCode varchar2 Discount Code writable, ::ancestor.discountCode Code of discount applied to this line
discountPercent double Discount Percent writable, ::ancestor.discountPercent Discount percentage applied to this line
discountSequenceId varchar2 itgen_vnet_discountsequenceid writable, ::ancestor.discountSequenceId Id of discount sequence applied to this line
discountedUnitPrice double itgen_vnet_discountedunitprice writable, ::ancestor.discountedUnitPrice The discounted unit price for this order line
emailed char Emailed filters on the platform, writable, ::ancestor.::ancestor.emailed Indicates if the document was emailed
exciseDuty double itgen_vnet_exciseduty writable, ::ancestor.exciseDuty The excise duty amount for this line, aggregated from the line's fees. Like the individual fee amounts this is an unsigned magnitude; see each fee's sales/return factor for the direction.
extendedPrice double itgen_vnet_extendedprice writable, ::ancestor.extendedPrice The extended price for this sales order line
externalLink varchar2 itgen_vnet_externallink writable, ::ancestor.externalLink Any external link for this sales order line
financialInformation_cashDiscountDate datetime itgen_vnet_financialinformation_cashdiscountdate filters on the platform, writable, ::ancestor.::ancestor.financialInformation.cashDiscountDate
financialInformation_dueDate datetime itgen_vnet_financialinformation_duedate filters on the platform, writable, ::ancestor.::ancestor.financialInformation.dueDate
financialInformation_invoiceDate datetime itgen_vnet_financialinformation_invoicedate filters on the platform, writable, ::ancestor.::ancestor.financialInformation.invoiceDate
financialInformation_invoiceId varchar2 itgen_vnet_financialinformation_invoiceid filters on the platform, writable, ::ancestor.::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.::ancestor.financialInformation.invoiceSeparately Whether the order should be invoiced separately
financialInformation_postPeriod varchar2 itgen_vnet_financialinformation_postperiod filters on the platform, writable, ::ancestor.::ancestor.financialInformation.postPeriod The post period for the invoice
financialInformation_terms_description varchar2 itgen_vnet_financialinformation_terms_description filters on the platform, writable, ::ancestor.::ancestor.financialInformation.terms.description The description
financialInformation_terms_id varchar2 itgen_vnet_financialinformation_terms_id filters on the platform, writable, ::ancestor.::ancestor.financialInformation.terms.id The id
freeItem char Free Item writable, ::ancestor.freeItem Whether these item(s) are free or not
freight_amount double itgen_vnet_freight_amount filters on the platform, writable, ::ancestor.::ancestor.freight.amount The amounts calculated based on the ship terms. ///
freight_amountInBaseCurrency double itgen_vnet_freight_amountinbasecurrency filters on the platform, writable, ::ancestor.::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.::ancestor.freight.cost The freight cost calculated for the sales order,
freight_costInBaseCurrency double itgen_vnet_freight_costinbasecurrency filters on the platform, writable, ::ancestor.::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.::ancestor.freight.premiumAmount The additional freight charges for handling the order.
freight_premiumAmountInBaseCurrency double itgen_vnet_freight_premiumamountinbasecurrency filters on the platform, writable, ::ancestor.::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.::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.::ancestor.freight.volume
freight_weight double itgen_vnet_freight_weight filters on the platform, writable, ::ancestor.::ancestor.freight.weight
hasManualDiscount char itgen_vnet_hasmanualdiscount writable, ::ancestor.hasManualDiscount Discount is applied manually
hasManualPrice char itgen_vnet_hasmanualprice writable, ::ancestor.hasManualPrice Unit price is applied manually
inventoryAlternateId varchar2 itgen_vnet_inventoryalternateid writable, ::ancestor.inventoryAlternateId
inventory_baseUnit varchar2 itgen_vnet_inventory_baseunit writable, ::ancestor.inventory.baseUnit
inventory_description varchar2 Inventory Description writable, ::ancestor.inventory.description The description
inventory_id varchar2 itgen_vnet_inventory_id writable, ::ancestor.inventory.id The id
invoiceLineNumber int32 itgen_vnet_invoicelinenumber writable, ::ancestor.invoiceLineNumber The line number of the original invoice to be returned
invoiceNumber varchar2 itgen_vnet_invoicenumber writable, ::ancestor.invoiceNumber The reference number of the original invoice to be returned
invoiceType varchar2 itgen_vnet_invoicetype writable, ::ancestor.invoiceType The invoice type of the original invoice to be returned
isRotRutDeductible char itgen_vnet_isrotrutdeductible writable, ::ancestor.isRotRutDeductible
isRotRutDeductible_2 char Is ROTRUT Deductible 2 filters on the platform, writable, ::ancestor.::ancestor.isRotRutDeductible Whether the order is ROT/RUT deductible
kitAssembly_referenceNumber varchar2 itgen_vnet_kitassembly_referencenumber writable, ::ancestor.kitAssembly.referenceNumber
lastModified datetime Last Modified filters on the platform, writable, ::ancestor.::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.
lineId int32 Line Identifier writable, ::ancestor.lineId The line number of the sales order line
lineTotalBeforeDiscount double itgen_vnet_linetotalbeforediscount writable, ::ancestor.lineTotalBeforeDiscount The line total before any discounts are applied
lineType varchar2 Line Type writable, ::ancestor.lineType The type of sales order line
note varchar2 Note writable, ::ancestor.note Any note that has been applied to this order line
note_2 varchar2 Note 2 filters on the platform, writable, ::ancestor.::ancestor.note Any notes on the order
openLine char itgen_vnet_openline writable, ::ancestor.openLine Indicates if line has quantity left to be shipped
openQuantity double itgen_vnet_openquantity writable, ::ancestor.openQuantity The open quantity for this line
operation varchar2 Operation writable, ::ancestor.operation The type of operation the line represents to the order
orderDate datetime itgen_vnet_orderdate writable, ::ancestor.orderDate
orderId varchar2 itgen_vnet_orderid filters on the platform, writable, ::ancestor.::ancestor.orderId The unique identifier of the order
orderQty double Order Quantity filters on the platform, writable, ::ancestor.::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.::ancestor.origin.orderId The unique id of the origin order
origin_orderType varchar2 itgen_vnet_origin_ordertype filters on the platform, writable, ::ancestor.::ancestor.origin.orderType The order type code for the origin order
originalOrderId varchar2 itgen_vnet_originalorderid filters on the platform, writable, ::ancestor.::ancestor.originalOrderId The unique identifier of the original order
originalOrderType varchar2 itgen_vnet_originalordertype filters on the platform, writable, ::ancestor.::ancestor.originalOrderType The type code for the original sales order
overshipThreshold double itgen_vnet_overshipthreshold writable, ::ancestor.overshipThreshold The overship threshold value (%)
owner_id varchar2 Owner ID filters on the platform, writable, ::ancestor.::ancestor.owner.id The identifier of the employee
owner_internalId varchar2 Owner Internal ID filters on the platform, writable, ::ancestor.::ancestor.owner.internalId The internal unique identifier of the employee
parentCustomer_id varchar2 itgen_vnet_parentcustomer_id filters on the platform, writable, ::ancestor.::ancestor.parentCustomer.id The unique id of the the customer
parentCustomer_internalId int32 itgen_vnet_parentcustomer_internalid filters on the platform, writable, ::ancestor.::ancestor.parentCustomer.internalId An internal unique id of the customer
parentCustomer_name varchar2 itgen_vnet_parentcustomer_name filters on the platform, writable, ::ancestor.::ancestor.parentCustomer.name The customer name
paymentSettings_cashAccountId varchar2 itgen_vnet_paymentsettings_cashaccountid filters on the platform, writable, ::ancestor.::ancestor.paymentSettings.cashAccountId The cash account to use
paymentSettings_paymentMethod_description varchar2 itgen_vnet_paymentsettings_paymentmethod_description filters on the platform, writable, ::ancestor.::ancestor.paymentSettings.paymentMethod.description The description
paymentSettings_paymentMethod_id varchar2 itgen_vnet_paymentsettings_paymentmethod_id filters on the platform, writable, ::ancestor.::ancestor.paymentSettings.paymentMethod.id The id
paymentSettings_paymentReference varchar2 itgen_vnet_paymentsettings_paymentreference filters on the platform, writable, ::ancestor.::ancestor.paymentSettings.paymentReference The payment reference
print_descriptionOnInvoice char itgen_vnet_print_descriptiononinvoice filters on the platform, writable, ::ancestor.::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.::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.::ancestor.print.noteOnInternalDocuments Set to true to print note on internal documents
projectTaskId varchar2 itgen_vnet_projecttaskid writable, ::ancestor.projectTaskId The project task with which this sales order line is associated
project_description varchar2 Project Description filters on the platform, writable, ::ancestor.::ancestor.project.description The description
project_id varchar2 Project ID filters on the platform, writable, ::ancestor.::ancestor.project.id The id
project_internalId int32 itgen_vnet_project_internalid filters on the platform, writable, ::ancestor.::ancestor.project.internalId An internal unique identifier of the project
purchaseOrderSource varchar2 itgen_vnet_purchaseordersource writable, ::ancestor.purchaseOrderSource Information about line purchase order source
quantity double Quantity writable, ::ancestor.quantity The quantity of unit of measure this line represents
quantityOnShipments double itgen_vnet_quantityonshipments writable, ::ancestor.quantityOnShipments The quantity on shipments for this line
reasonCode varchar2 Reason Code writable, ::ancestor.reasonCode The reason code
replacementUnitCost double itgen_vnet_replacementunitcost writable, ::ancestor.replacementUnitCost The replacement unit cost of an item. This is set based on the supplier price. If no supplier price found, the last price of the item's default supplier will be used. If no default supplier is set, the last cost of the item will be used.
requestDate datetime itgen_vnet_requestdate writable, ::ancestor.requestDate The request date for this order line
requestOn datetime Request On filters on the platform, writable, ::ancestor.::ancestor.requestOn Date the order was requested
rotRutDeductibleAmount double itgen_vnet_rotrutdeductibleamount writable, ::ancestor.rotRutDeductibleAmount
rotRutItemType_description varchar2 itgen_vnet_rotrutitemtype_description writable, ::ancestor.rotRutItemType.description The description
rotRutItemType_id varchar2 itgen_vnet_rotrutitemtype_id writable, ::ancestor.rotRutItemType.id The id
rotRutWorkType varchar2 itgen_vnet_rotrutworktype writable, ::ancestor.rotRutWorkType
rotRut_apartment varchar2 itgen_vnet_rotrut_apartment filters on the platform, writable, ::ancestor.::ancestor.rotRut.apartment The apartment reference
rotRut_distributedAmount double itgen_vnet_rotrut_distributedamount filters on the platform, writable, ::ancestor.::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.::ancestor.rotRut.distributedAutomatically Whether the ROT/RUT is distributed automatically
rotRut_estate varchar2 itgen_vnet_rotrut_estate filters on the platform, writable, ::ancestor.::ancestor.rotRut.estate The estate reference
rotRut_materialCostAmount double itgen_vnet_rotrut_materialcostamount filters on the platform, writable, ::ancestor.::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.::ancestor.rotRut.organizationNumber The organization number
rotRut_otherCostAmount double itgen_vnet_rotrut_othercostamount filters on the platform, writable, ::ancestor.::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.::ancestor.rotRut.totalDeductableAmount The total amount that is tax deductable
rotRut_type varchar2 itgen_vnet_rotrut_type filters on the platform, writable, ::ancestor.::ancestor.rotRut.type The type of ROT/RUT
rotRut_workPriceAmount double itgen_vnet_rotrut_workpriceamount filters on the platform, writable, ::ancestor.::ancestor.rotRut.workPriceAmount Price amount for lines with inventory ROT/RUT item type Service
salesAccountId varchar2 itgen_vnet_salesaccountid writable, ::ancestor.salesAccountId The general ledger account this line applies to
salesPerson_description varchar2 Sales Person Description writable, ::ancestor.salesPerson.description The description
salesPerson_description_2 varchar2 itgen_vnet_salesperson_description_2 filters on the platform, writable, ::ancestor.::ancestor.salesPerson.description The description
salesPerson_id varchar2 Sales Person ID writable, ::ancestor.salesPerson.id The id
salesPerson_id_2 varchar2 itgen_vnet_salesperson_id_2 filters on the platform, writable, ::ancestor.::ancestor.salesPerson.id The id
shipDate datetime itgen_vnet_shipdate writable, ::ancestor.shipDate The expected shipping date for this order line
shippingRule varchar2 itgen_vnet_shippingrule writable, ::ancestor.shippingRule The shipping rule code for this order line
shipping_address_city varchar2 itgen_vnet_shipping_address_city filters on the platform, writable, ::ancestor.::ancestor.shipping.address.city The city
shipping_address_country_id varchar2 itgen_vnet_shipping_address_country_id filters on the platform, writable, ::ancestor.::ancestor.shipping.address.country.id The id
shipping_address_country_name varchar2 itgen_vnet_shipping_address_country_name filters on the platform, writable, ::ancestor.::ancestor.shipping.address.country.name The name
shipping_address_county_id varchar2 itgen_vnet_shipping_address_county_id filters on the platform, writable, ::ancestor.::ancestor.shipping.address.county.id The id
shipping_address_county_name varchar2 itgen_vnet_shipping_address_county_name filters on the platform, writable, ::ancestor.::ancestor.shipping.address.county.name The name
shipping_address_id int32 itgen_vnet_shipping_address_id filters on the platform, writable, ::ancestor.::ancestor.shipping.address.id The address id
shipping_address_line1 varchar2 itgen_vnet_shipping_address_line1 filters on the platform, writable, ::ancestor.::ancestor.shipping.address.line1 Address line 1
shipping_address_line2 varchar2 itgen_vnet_shipping_address_line2 filters on the platform, writable, ::ancestor.::ancestor.shipping.address.line2 Address line 2
shipping_address_line3 varchar2 itgen_vnet_shipping_address_line3 filters on the platform, writable, ::ancestor.::ancestor.shipping.address.line3 Address line 3
shipping_address_overridesDefault char itgen_vnet_shipping_address_overridesdefault filters on the platform, writable, ::ancestor.::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.::ancestor.shipping.address.postalCode The postal code
shipping_contact_attention varchar2 itgen_vnet_shipping_contact_attention filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.attention Any attention for the contact
shipping_contact_email varchar2 itgen_vnet_shipping_contact_email filters on the platform, writable, ::ancestor.::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.::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.::ancestor.shipping.contact.id The id of the contact
shipping_contact_name varchar2 itgen_vnet_shipping_contact_name filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.name The name of the contact
shipping_contact_overridesDefault char itgen_vnet_shipping_contact_overridesdefault filters on the platform, writable, ::ancestor.::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.::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.::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.::ancestor.shipping.fobPoint.description The description
shipping_fobPoint_id varchar2 itgen_vnet_shipping_fobpoint_id filters on the platform, writable, ::ancestor.::ancestor.shipping.fobPoint.id The id
shipping_insurance char itgen_vnet_shipping_insurance filters on the platform, writable, ::ancestor.::ancestor.shipping.insurance Whether insurance applies to this shipping
shipping_intrastatTransactionType_description varchar2 itgen_vnet_shipping_intrastattransactiontype_description filters on the platform, writable, ::ancestor.::ancestor.shipping.intrastatTransactionType.description The description
shipping_intrastatTransactionType_id int32 itgen_vnet_shipping_intrastattransactiontype_id filters on the platform, writable, ::ancestor.::ancestor.shipping.intrastatTransactionType.id The id
shipping_preferredWarehouse_description varchar2 itgen_vnet_shipping_preferredwarehouse_description filters on the platform, writable, ::ancestor.::ancestor.shipping.preferredWarehouse.description The description
shipping_preferredWarehouse_id varchar2 itgen_vnet_shipping_preferredwarehouse_id filters on the platform, writable, ::ancestor.::ancestor.shipping.preferredWarehouse.id The id
shipping_priority int32 itgen_vnet_shipping_priority filters on the platform, writable, ::ancestor.::ancestor.shipping.priority Priority of the order
shipping_residentialDelivery char itgen_vnet_shipping_residentialdelivery filters on the platform, writable, ::ancestor.::ancestor.shipping.residentialDelivery Whether this is residential delivery
shipping_rule varchar2 itgen_vnet_shipping_rule filters on the platform, writable, ::ancestor.::ancestor.shipping.rule The shipping rule
shipping_saturdayDelivery char itgen_vnet_shipping_saturdaydelivery filters on the platform, writable, ::ancestor.::ancestor.shipping.saturdayDelivery Whether this is a saturday delivery
shipping_scheduledDate datetime itgen_vnet_shipping_scheduleddate filters on the platform, writable, ::ancestor.::ancestor.shipping.scheduledDate The shipping scheduled date
shipping_shipSeparately char itgen_vnet_shipping_shipseparately filters on the platform, writable, ::ancestor.::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.::ancestor.shipping.shipVia.description The description
shipping_shipVia_id varchar2 itgen_vnet_shipping_shipvia_id filters on the platform, writable, ::ancestor.::ancestor.shipping.shipVia.id The id
shipping_terms_description varchar2 itgen_vnet_shipping_terms_description filters on the platform, writable, ::ancestor.::ancestor.shipping.terms.description The description
shipping_terms_id varchar2 itgen_vnet_shipping_terms_id filters on the platform, writable, ::ancestor.::ancestor.shipping.terms.id The id
shipping_zone_description varchar2 itgen_vnet_shipping_zone_description filters on the platform, writable, ::ancestor.::ancestor.shipping.zone.description The description
shipping_zone_id varchar2 itgen_vnet_shipping_zone_id filters on the platform, writable, ::ancestor.::ancestor.shipping.zone.id The id
sortOrder int32 itgen_vnet_sortorder writable, ::ancestor.sortOrder Used to apply sort order to a set of lines
status_cancelled char itgen_vnet_status_cancelled filters on the platform, writable, ::ancestor.::ancestor.status.cancelled Whether this order is in a cancelled state
status_description varchar2 itgen_vnet_status_description filters on the platform, writable, ::ancestor.::ancestor.status.description The status name for the order
status_hold char itgen_vnet_status_hold filters on the platform, writable, ::ancestor.::ancestor.status.hold Whether this order is in a held state
subaccount varchar2 Sub Account writable The general ledger subaccount this line applies to The JSON text of the nested object.
supplierPrice double itgen_vnet_supplierprice writable, ::ancestor.supplierPrice
supplier_currencyId varchar2 itgen_vnet_supplier_currencyid writable, ::ancestor.supplier.currencyId The currency of the supplier selected for the order line
supplier_id varchar2 itgen_vnet_supplier_id writable, ::ancestor.supplier.id The id of the supplier selected for the order line
supplier_name varchar2 Supplier Name writable, ::ancestor.supplier.name The name of the supplier selected for the order line
supplier_price double itgen_vnet_supplier_price writable, ::ancestor.supplier.price The supplier price of the supplier selected for the order line
supplier_unitOfMeasure varchar2 itgen_vnet_supplier_unitofmeasure writable, ::ancestor.supplier.unitOfMeasure The unit of measure used by the supplier for this line
taxCategoryId varchar2 itgen_vnet_taxcategoryid writable, ::ancestor.taxCategoryId The Tax Category Id applying to this order line
termEndDate datetime Term End Date writable, ::ancestor.termEndDate The term end date for deferred revenue recognition on this order line.
termStartDate datetime Term Start Date writable, ::ancestor.termStartDate The term start date for deferred revenue recognition on this order line.
totals_costTotal double itgen_vnet_totals_costtotal filters on the platform, writable, ::ancestor.::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.::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.::ancestor.totals.discountTotal The discount total
totals_discountTotalInBaseCurrency double itgen_vnet_totals_discounttotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.totals.discountTotalInBaseCurrency The discount total in base currency
totals_exciseDutyTotal double itgen_vnet_totals_excisedutytotal filters on the platform, writable, ::ancestor.::ancestor.totals.exciseDutyTotal The sum of excise duty for the lines
totals_exciseDutyTotalInBaseCurrency double itgen_vnet_totals_excisedutytotalinbasecurrency filters on the platform, writable, ::ancestor.::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.::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.::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.::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.::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.::ancestor.totals.orderTotal The order total
totals_orderTotalInBaseCurrency double itgen_vnet_totals_ordertotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.totals.orderTotalInBaseCurrency The order total in base currency
totals_paymentTotal double itgen_vnet_totals_paymenttotal filters on the platform, writable, ::ancestor.::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.::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.::ancestor.totals.taxExemptTotal The VAT exempt total
totals_taxExemptTotalInBaseCurrency double itgen_vnet_totals_taxexempttotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.totals.taxExemptTotalInBaseCurrency The VAT exempt total in base currency
totals_taxTotal double itgen_vnet_totals_taxtotal filters on the platform, writable, ::ancestor.::ancestor.totals.taxTotal The tax total
totals_taxTotalInBaseCurrency double itgen_vnet_totals_taxtotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.totals.taxTotalInBaseCurrency The tax total in base currency
totals_taxableTotal double itgen_vnet_totals_taxabletotal filters on the platform, writable, ::ancestor.::ancestor.totals.taxableTotal The VAT taxable total
totals_taxableTotalInBaseCurrency double itgen_vnet_totals_taxabletotalinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.totals.taxableTotalInBaseCurrency The VAT taxable in base currency
totals_unbilledAmount double itgen_vnet_totals_unbilledamount filters on the platform, writable, ::ancestor.::ancestor.totals.unbilledAmount The sum of unbilled amounts for the lines
totals_unbilledAmountInBaseCurrency double itgen_vnet_totals_unbilledamountinbasecurrency filters on the platform, writable, ::ancestor.::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.::ancestor.totals.unshippedAmount The sum of unshipped amounts for the lines
totals_unshippedAmountInBaseCurrency double itgen_vnet_totals_unshippedamountinbasecurrency filters on the platform, writable, ::ancestor.::ancestor.totals.unshippedAmountInBaseCurrency The sum of unshipped amounts for the lines in base currency
type varchar2 Type filters on the platform, writable, ::ancestor.::ancestor.type The type code for the sales order
undershipThreshold double itgen_vnet_undershipthreshold writable, ::ancestor.undershipThreshold The undership threshold value (%)
unitCost double Unit Cost writable, ::ancestor.unitCost The unit cost of items on this order line
unitOfMeasure varchar2 itgen_vnet_unitofmeasure writable, ::ancestor.unitOfMeasure The unit of measure (UOM) for the sales order line
unitPrice double itgen_vnet_unitprice writable, ::ancestor.unitPrice The unit price for items on this order line
useReplacementCostForMarginAndProfit char itgen_vnet_usereplacementcostformarginandprofit filters on the platform, writable, ::ancestor.::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.::ancestor.version An internal order version used for detecting concurrent updates to an order
warehouseId varchar2 Warehouse ID writable, ::ancestor.warehouseId The Site Id for items on this line
warehouseLocation_description varchar2 itgen_vnet_warehouselocation_description writable, ::ancestor.warehouseLocation.description The description
warehouseLocation_id varchar2 itgen_vnet_warehouselocation_id writable, ::ancestor.warehouseLocation.id The id

Release Notes

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