invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesOrderLinePurchaseOrderNumbersByTypeOrderIdLineId: Visma.net Financials itgen_vnet_salesorderlinepurchaseordernumbersbytypeorderidlineid_plural

read only REST

  • Catalog: NgSalesOrders
  • Schema: SalesOrders
  • Label: itgen_vnet_salesorderlinepurchaseordernumbersbytypeorderidlineid_plural

Gets a specific sales order line for a single sales order Sample request:

GET /salesorders/SO/000101/lines/1

Can only retrieve data.

Summary

Sample request:

GET /salesorders/SO/000101/lines/1

API Source

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

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

Table Columns

The columns of the table SalesOrderLinePurchaseOrderNumbersByTypeOrderIdLineId 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 filters on the platform, writable, ::ancestor.amountNotInvoiced The invoice amount which is not invoiced for this sales order line
autoCreateIssue char itgen_vnet_autocreateissue filters on the platform, 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 filters on the platform, writable, ::ancestor.baseOrderQuantity The base order quantity for this line
billedQuantity double itgen_vnet_billedquantity filters on the platform, writable, ::ancestor.billedQuantity The billed quantity for this line
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
commissionable char Commissionable filters on the platform, writable, ::ancestor.commissionable Indicates if line is commissionable
completed char Completed filters on the platform, writable, ::ancestor.completed Whether this order line is completed or not
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.
description varchar2 Description filters on the platform, writable, ::ancestor.description Any description for this order line
discountAmount double itgen_vnet_discountamount filters on the platform, writable, ::ancestor.discountAmount The discount amount for this line
discountCode varchar2 Discount Code filters on the platform, writable, ::ancestor.discountCode Code of discount applied to this line
discountPercent double Discount Percent filters on the platform, writable, ::ancestor.discountPercent Discount percentage applied to this line
discountSequenceId varchar2 itgen_vnet_discountsequenceid filters on the platform, writable, ::ancestor.discountSequenceId Id of discount sequence applied to this line
discountedUnitPrice double itgen_vnet_discountedunitprice filters on the platform, writable, ::ancestor.discountedUnitPrice The discounted unit price for this order line
exciseDuty double itgen_vnet_exciseduty filters on the platform, 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 filters on the platform, writable, ::ancestor.extendedPrice The extended price for this sales order line
externalLink varchar2 itgen_vnet_externallink filters on the platform, writable, ::ancestor.externalLink Any external link for this sales order line
freeItem char Free Item filters on the platform, writable, ::ancestor.freeItem Whether these item(s) are free or not
hasManualDiscount char itgen_vnet_hasmanualdiscount filters on the platform, writable, ::ancestor.hasManualDiscount Discount is applied manually
hasManualPrice char itgen_vnet_hasmanualprice filters on the platform, writable, ::ancestor.hasManualPrice Unit price is applied manually
inventoryAlternateId varchar2 itgen_vnet_inventoryalternateid filters on the platform, writable, ::ancestor.inventoryAlternateId
inventory_baseUnit varchar2 itgen_vnet_inventory_baseunit filters on the platform, writable, ::ancestor.inventory.baseUnit
inventory_description varchar2 Inventory Description filters on the platform, writable, ::ancestor.inventory.description The description
inventory_id varchar2 itgen_vnet_inventory_id filters on the platform, writable, ::ancestor.inventory.id The id
invoiceLineNumber int32 itgen_vnet_invoicelinenumber filters on the platform, writable, ::ancestor.invoiceLineNumber The line number of the original invoice to be returned
invoiceNumber varchar2 itgen_vnet_invoicenumber filters on the platform, writable, ::ancestor.invoiceNumber The reference number of the original invoice to be returned
invoiceType varchar2 itgen_vnet_invoicetype filters on the platform, writable, ::ancestor.invoiceType The invoice type of the original invoice to be returned
isRotRutDeductible char itgen_vnet_isrotrutdeductible filters on the platform, writable, ::ancestor.isRotRutDeductible
kitAssembly_referenceNumber varchar2 itgen_vnet_kitassembly_referencenumber filters on the platform, writable, ::ancestor.kitAssembly.referenceNumber
lineId int32 Line Identifier filters on the platform, writable, ::ancestor.lineId The line number of the sales order line
lineTotalBeforeDiscount double itgen_vnet_linetotalbeforediscount filters on the platform, writable, ::ancestor.lineTotalBeforeDiscount The line total before any discounts are applied
lineType varchar2 Line Type filters on the platform, writable, ::ancestor.lineType The type of sales order line
note varchar2 Note filters on the platform, writable, ::ancestor.note Any note that has been applied to this order line
openLine char itgen_vnet_openline filters on the platform, writable, ::ancestor.openLine Indicates if line has quantity left to be shipped
openQuantity double itgen_vnet_openquantity filters on the platform, writable, ::ancestor.openQuantity The open quantity for this line
operation varchar2 Operation filters on the platform, writable, ::ancestor.operation The type of operation the line represents to the order
orderDate datetime itgen_vnet_orderdate filters on the platform, writable, ::ancestor.orderDate
overshipThreshold double itgen_vnet_overshipthreshold filters on the platform, writable, ::ancestor.overshipThreshold The overship threshold value (%)
projectTaskId varchar2 itgen_vnet_projecttaskid filters on the platform, writable, ::ancestor.projectTaskId The project task with which this sales order line is associated
purchaseOrderSource varchar2 itgen_vnet_purchaseordersource filters on the platform, writable, ::ancestor.purchaseOrderSource Information about line purchase order source
quantity double Quantity filters on the platform, writable, ::ancestor.quantity The quantity of unit of measure this line represents
quantityOnShipments double itgen_vnet_quantityonshipments filters on the platform, writable, ::ancestor.quantityOnShipments The quantity on shipments for this line
reasonCode varchar2 Reason Code filters on the platform, writable, ::ancestor.reasonCode The reason code
replacementUnitCost double itgen_vnet_replacementunitcost filters on the platform, 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 filters on the platform, writable, ::ancestor.requestDate The request date for this order line
rotRutDeductibleAmount double itgen_vnet_rotrutdeductibleamount filters on the platform, writable, ::ancestor.rotRutDeductibleAmount
rotRutItemType_description varchar2 itgen_vnet_rotrutitemtype_description filters on the platform, writable, ::ancestor.rotRutItemType.description The description
rotRutItemType_id varchar2 itgen_vnet_rotrutitemtype_id filters on the platform, writable, ::ancestor.rotRutItemType.id The id
rotRutWorkType varchar2 itgen_vnet_rotrutworktype filters on the platform, writable, ::ancestor.rotRutWorkType
salesAccountId varchar2 itgen_vnet_salesaccountid filters on the platform, writable, ::ancestor.salesAccountId The general ledger account this line applies to
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
shipDate datetime itgen_vnet_shipdate filters on the platform, writable, ::ancestor.shipDate The expected shipping date for this order line
shippingRule varchar2 itgen_vnet_shippingrule filters on the platform, writable, ::ancestor.shippingRule The shipping rule code for this order line
sortOrder int32 itgen_vnet_sortorder filters on the platform, writable, ::ancestor.sortOrder Used to apply sort order to a set of lines
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 filters on the platform, writable, ::ancestor.supplierPrice
supplier_currencyId varchar2 itgen_vnet_supplier_currencyid filters on the platform, writable, ::ancestor.supplier.currencyId The currency of the supplier selected for the order line
supplier_id varchar2 itgen_vnet_supplier_id filters on the platform, writable, ::ancestor.supplier.id The id of the supplier selected for the order line
supplier_name varchar2 Supplier Name filters on the platform, writable, ::ancestor.supplier.name The name of the supplier selected for the order line
supplier_price double itgen_vnet_supplier_price filters on the platform, writable, ::ancestor.supplier.price The supplier price of the supplier selected for the order line
supplier_unitOfMeasure varchar2 itgen_vnet_supplier_unitofmeasure filters on the platform, writable, ::ancestor.supplier.unitOfMeasure The unit of measure used by the supplier for this line
taxCategoryId varchar2 itgen_vnet_taxcategoryid filters on the platform, writable, ::ancestor.taxCategoryId The Tax Category Id applying to this order line
termEndDate datetime Term End Date filters on the platform, writable, ::ancestor.termEndDate The term end date for deferred revenue recognition on this order line.
termStartDate datetime Term Start Date filters on the platform, writable, ::ancestor.termStartDate The term start date for deferred revenue recognition on this order line.
undershipThreshold double itgen_vnet_undershipthreshold filters on the platform, writable, ::ancestor.undershipThreshold The undership threshold value (%)
unitCost double Unit Cost filters on the platform, writable, ::ancestor.unitCost The unit cost of items on this order line
unitOfMeasure varchar2 itgen_vnet_unitofmeasure filters on the platform, writable, ::ancestor.unitOfMeasure The unit of measure (UOM) for the sales order line
unitPrice double itgen_vnet_unitprice filters on the platform, writable, ::ancestor.unitPrice The unit price for items on this order line
warehouseId varchar2 Warehouse ID filters on the platform, writable, ::ancestor.warehouseId The Site Id for items on this line
warehouseLocation_description varchar2 itgen_vnet_warehouselocation_description filters on the platform, writable, ::ancestor.warehouseLocation.description The description
warehouseLocation_id varchar2 itgen_vnet_warehouselocation_id filters on the platform, writable, ::ancestor.warehouseLocation.id The id

Release Notes

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