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 | ||
order |
`` | 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
TEXT |
varchar2 |
itgen_vnet_text | writable, ::self |
||
amount |
double |
itgen_vnet_amountnotinvoiced | filters on the platform, writable, ::ancestor. |
The invoice amount which is not invoiced for this sales order line | |
auto |
char |
itgen_vnet_autocreateissue | filters on the platform, writable, ::ancestor. |
Indicates if an order line of issue type will automatically be created after the order line of receipt type has been processed. | |
base |
double |
itgen_vnet_baseorderquantity | filters on the platform, writable, ::ancestor. |
The base order quantity for this line | |
billed |
double |
itgen_vnet_billedquantity | filters on the platform, writable, ::ancestor. |
The billed quantity for this line | |
branch_ |
varchar2 |
itgen_vnet_branch_description | filters on the platform, writable, ::ancestor. |
The description | |
branch_ |
varchar2 |
itgen_vnet_branch_id | filters on the platform, writable, ::ancestor. |
The id | |
commissionable |
char |
Commissionable | filters on the platform, writable, ::ancestor. |
Indicates if line is commissionable | |
completed |
char |
Completed | filters on the platform, writable, ::ancestor. |
Whether this order line is completed or not | |
custom |
datetime |
itgen_vnet_customfields_customdatetimeutc1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type DateTime - in UTC timezone | |
custom |
double |
itgen_vnet_customfields_customdec1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
double |
itgen_vnet_customfields_customdec2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
int32 |
itgen_vnet_customfields_customint1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type int | |
custom |
int32 |
itgen_vnet_customfields_customint2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type int | |
custom |
varchar2 |
itgen_vnet_customfields_customstr1 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr3 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr4 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr5 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
Any description for this order line | |
discount |
double |
itgen_vnet_discountamount | filters on the platform, writable, ::ancestor. |
The discount amount for this line | |
discount |
varchar2 |
Discount Code | filters on the platform, writable, ::ancestor. |
Code of discount applied to this line | |
discount |
double |
Discount Percent | filters on the platform, writable, ::ancestor. |
Discount percentage applied to this line | |
discount |
varchar2 |
itgen_vnet_discountsequenceid | filters on the platform, writable, ::ancestor. |
Id of discount sequence applied to this line | |
discounted |
double |
itgen_vnet_discountedunitprice | filters on the platform, writable, ::ancestor. |
The discounted unit price for this order line | |
excise |
double |
itgen_vnet_exciseduty | filters on the platform, writable, ::ancestor. |
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. | |
extended |
double |
itgen_vnet_extendedprice | filters on the platform, writable, ::ancestor. |
The extended price for this sales order line | |
external |
varchar2 |
itgen_vnet_externallink | filters on the platform, writable, ::ancestor. |
Any external link for this sales order line | |
free |
char |
Free Item | filters on the platform, writable, ::ancestor. |
Whether these item(s) are free or not | |
has |
char |
itgen_vnet_hasmanualdiscount | filters on the platform, writable, ::ancestor. |
Discount is applied manually | |
has |
char |
itgen_vnet_hasmanualprice | filters on the platform, writable, ::ancestor. |
Unit price is applied manually | |
inventory |
varchar2 |
itgen_vnet_inventoryalternateid | filters on the platform, writable, ::ancestor. |
||
inventory_ |
varchar2 |
itgen_vnet_inventory_baseunit | filters on the platform, writable, ::ancestor. |
||
inventory_ |
varchar2 |
Inventory Description | filters on the platform, writable, ::ancestor. |
The description | |
inventory_ |
varchar2 |
itgen_vnet_inventory_id | filters on the platform, writable, ::ancestor. |
The id | |
invoice |
int32 |
itgen_vnet_invoicelinenumber | filters on the platform, writable, ::ancestor. |
The line number of the original invoice to be returned | |
invoice |
varchar2 |
itgen_vnet_invoicenumber | filters on the platform, writable, ::ancestor. |
The reference number of the original invoice to be returned | |
invoice |
varchar2 |
itgen_vnet_invoicetype | filters on the platform, writable, ::ancestor. |
The invoice type of the original invoice to be returned | |
is |
char |
itgen_vnet_isrotrutdeductible | filters on the platform, writable, ::ancestor. |
||
kit |
varchar2 |
itgen_vnet_kitassembly_referencenumber | filters on the platform, writable, ::ancestor. |
||
lineId |
int32 |
Line Identifier | filters on the platform, writable, ::ancestor. |
The line number of the sales order line | |
line |
double |
itgen_vnet_linetotalbeforediscount | filters on the platform, writable, ::ancestor. |
The line total before any discounts are applied | |
line |
varchar2 |
Line Type | filters on the platform, writable, ::ancestor. |
The type of sales order line | |
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
Any note that has been applied to this order line | |
open |
char |
itgen_vnet_openline | filters on the platform, writable, ::ancestor. |
Indicates if line has quantity left to be shipped | |
open |
double |
itgen_vnet_openquantity | filters on the platform, writable, ::ancestor. |
The open quantity for this line | |
operation |
varchar2 |
Operation | filters on the platform, writable, ::ancestor. |
The type of operation the line represents to the order | |
order |
datetime |
itgen_vnet_orderdate | filters on the platform, writable, ::ancestor. |
||
overship |
double |
itgen_vnet_overshipthreshold | filters on the platform, writable, ::ancestor. |
The overship threshold value (%) | |
project |
varchar2 |
itgen_vnet_projecttaskid | filters on the platform, writable, ::ancestor. |
The project task with which this sales order line is associated | |
purchase |
varchar2 |
itgen_vnet_purchaseordersource | filters on the platform, writable, ::ancestor. |
Information about line purchase order source | |
quantity |
double |
Quantity | filters on the platform, writable, ::ancestor. |
The quantity of unit of measure this line represents | |
quantity |
double |
itgen_vnet_quantityonshipments | filters on the platform, writable, ::ancestor. |
The quantity on shipments for this line | |
reason |
varchar2 |
Reason Code | filters on the platform, writable, ::ancestor. |
The reason code | |
replacement |
double |
itgen_vnet_replacementunitcost | filters on the platform, writable, ::ancestor. |
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. | |
request |
datetime |
itgen_vnet_requestdate | filters on the platform, writable, ::ancestor. |
The request date for this order line | |
rot |
double |
itgen_vnet_rotrutdeductibleamount | filters on the platform, writable, ::ancestor. |
||
rot |
varchar2 |
itgen_vnet_rotrutitemtype_description | filters on the platform, writable, ::ancestor. |
The description | |
rot |
varchar2 |
itgen_vnet_rotrutitemtype_id | filters on the platform, writable, ::ancestor. |
The id | |
rot |
varchar2 |
itgen_vnet_rotrutworktype | filters on the platform, writable, ::ancestor. |
||
sales |
varchar2 |
itgen_vnet_salesaccountid | filters on the platform, writable, ::ancestor. |
The general ledger account this line applies to | |
sales |
varchar2 |
Sales Person Description | filters on the platform, writable, ::ancestor. |
The description | |
sales |
varchar2 |
Sales Person ID | filters on the platform, writable, ::ancestor. |
The id | |
ship |
datetime |
itgen_vnet_shipdate | filters on the platform, writable, ::ancestor. |
The expected shipping date for this order line | |
shipping |
varchar2 |
itgen_vnet_shippingrule | filters on the platform, writable, ::ancestor. |
The shipping rule code for this order line | |
sort |
int32 |
itgen_vnet_sortorder | filters on the platform, writable, ::ancestor. |
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. | |
supplier |
double |
itgen_vnet_supplierprice | filters on the platform, writable, ::ancestor. |
||
supplier_ |
varchar2 |
itgen_vnet_supplier_currencyid | filters on the platform, writable, ::ancestor. |
The currency of the supplier selected for the order line | |
supplier_ |
varchar2 |
itgen_vnet_supplier_id | filters on the platform, writable, ::ancestor. |
The id of the supplier selected for the order line | |
supplier_ |
varchar2 |
Supplier Name | filters on the platform, writable, ::ancestor. |
The name of the supplier selected for the order line | |
supplier_ |
double |
itgen_vnet_supplier_price | filters on the platform, writable, ::ancestor. |
The supplier price of the supplier selected for the order line | |
supplier_ |
varchar2 |
itgen_vnet_supplier_unitofmeasure | filters on the platform, writable, ::ancestor. |
The unit of measure used by the supplier for this line | |
tax |
varchar2 |
itgen_vnet_taxcategoryid | filters on the platform, writable, ::ancestor. |
The Tax Category Id applying to this order line | |
term |
datetime |
Term End Date | filters on the platform, writable, ::ancestor. |
The term end date for deferred revenue recognition on this order line. | |
term |
datetime |
Term Start Date | filters on the platform, writable, ::ancestor. |
The term start date for deferred revenue recognition on this order line. | |
undership |
double |
itgen_vnet_undershipthreshold | filters on the platform, writable, ::ancestor. |
The undership threshold value (%) | |
unit |
double |
Unit Cost | filters on the platform, writable, ::ancestor. |
The unit cost of items on this order line | |
unit |
varchar2 |
itgen_vnet_unitofmeasure | filters on the platform, writable, ::ancestor. |
The unit of measure (UOM) for the sales order line | |
unit |
double |
itgen_vnet_unitprice | filters on the platform, writable, ::ancestor. |
The unit price for items on this order line | |
warehouse |
varchar2 |
Warehouse ID | filters on the platform, writable, ::ancestor. |
The Site Id for items on this line | |
warehouse |
varchar2 |
itgen_vnet_warehouselocation_description | filters on the platform, writable, ::ancestor. |
The description | |
warehouse |
varchar2 |
itgen_vnet_warehouselocation_id | filters on the platform, writable, ::ancestor. |
The id |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: