SalesOrderLinesV2ByOrderNumber: Visma.net Financials itgen_vnet_salesorderlinesv2byordernumber_plural
read only REST
- Catalog:
VismaNet - Schema:
SalesOrderV2 - Label: itgen_vnet_salesorderlinesv2byordernumber_plural
Get a specific SO Order Data for a single Sales Order. OBS: End of life March 31 2026. REPLACED BY v3 ENDPOINT. SEE https://salesorder.visma.net/swagger/index.html
Can only retrieve data.
Summary
Data for a single Sales Order. OBS: End of life March 31 2026. REPLACED BY v3 ENDPOINT. SEE https://salesorder.visma.net/swagger/index.html
API Source
- Endpoint:
/v2/salesorder/{orderNbr} - Operation:
get /v2/salesorder/{orderNbr}
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 |
|---|---|---|---|---|
order |
`` | Identifies the Sales Order Number |
Table Columns
The columns of the table SalesOrderLinesV2ByOrderNumber 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. | |
alternate |
varchar2 |
Alternate ID | writable, alternate |
Alternate ID > The alternate ID for the item, such as the item ID used by the customer. | |
branch |
varchar2 |
Branch Name | writable, branch |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number Name 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
branch |
varchar2 |
Branch Number | writable, branch |
Click the magnifier. > The identifier. | |
branch |
varchar2 |
Branch Number 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
cancel |
datetime |
Cancel by | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Cancel by > The date when the order should be cancelled if the Back order allowed option has been selected in the Shipping rule field. | |
canceled |
char |
Canceled | filters on the platform, writable, ::ancestor. |
The Delivery settings tab > The Shipping information section > Cancelled > A check box that indicates that the order has been cancelled on the date specified in Cancel by. | |
cash |
varchar2 |
Cash Account | filters on the platform, writable, ::ancestor. |
Payment settings tab > Cash account | |
cash |
datetime |
Cash Discount Date | filters on the platform, writable, ::ancestor. |
Financial settings tab > Financial information section > Cash discount date > The date when the cash discount is available for the invoice based on the credit terms. | |
commission |
varchar2 |
Commission Amount | filters on the platform, writable, ::ancestor. |
The Commissions tab > Commission amt. > The commission amount earned by the salesperson on this document. | |
commission |
varchar2 |
Commission Percentage | filters on the platform, writable, ::ancestor. |
The Commissions tab > Commission (%) > The percentage of commission generally earned by the salesperson. | |
commissionable |
char |
Commissionable | writable, commissionable |
VAT code > The VAT category of the goods mentioned in this line. | |
commissionable |
varchar2 |
itgen_vnet_commissionableamount | filters on the platform, writable, ::ancestor. |
The Commissions tab > Commissionable amount > The amount used to calculate the commission. | |
completed |
char |
Completed | writable, completed |
Completed > A check box that can be selected to indicate to the system that this line is completed. | |
contact |
int32 |
Contact ID | filters on the platform, writable, ::ancestor. |
The top part > Contact > The contact person of the customer. | |
currency |
varchar2 |
Currency | filters on the platform, writable, ::ancestor. |
The top part > Currency > The currency of the document. | |
customer |
varchar2 |
Customer Order | filters on the platform, writable, ::ancestor. |
The top part > Customer order > The reference number of the original customer document that the sales order is based on. | |
customer |
varchar2 |
Customer Reference Number | filters on the platform, writable, ::ancestor. |
The top part > External reference > The reference number of the sales order in a third-party application if Visma.net Financials is integrated with such an application and imports the sales orders from it. | |
customer |
varchar2 |
VAT Zone Default Tax Category Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
customer |
varchar2 |
VAT Zone Default Tax Category Number | filters on the platform, writable, ::ancestor. |
Number of item | |
customer |
varchar2 |
VAT Zone Default VAT Category | filters on the platform, writable, ::ancestor. |
Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window. | |
customer |
varchar2 |
VAT Zone Description | filters on the platform, writable, ::ancestor. |
Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window. | |
customer |
varchar2 |
itgen_vnet_customervatzone_errorinfo | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
VAT Zone ID | filters on the platform, writable, ::ancestor. |
Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window. | |
customer |
int64 |
itgen_vnet_customervatzone_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
customer |
int64 |
itgen_vnet_customervatzone_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
customer_ |
int32 |
Customer Internal ID | filters on the platform, writable, ::ancestor. |
||
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, ::ancestor. |
The name of the particular destination of the selected type. | |
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, ::ancestor. |
The identifier of the particular destination of the selected type. | |
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Date* > The date of the document. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The top part > Description > A brief description of the document. | |
disc |
double |
itgen_vnet_discunitprice | writable, disc |
Document details tab > Disc. unit price > The unit price, which has been recalculated after the application of discounts. | |
discount |
double |
itgen_vnet_discountamount | writable, discount |
Document details tab > Discount amount > The amount of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item). | |
discount |
varchar2 |
Discount Code | writable, discount |
Mandatory field: Document details tab > Discount details tab > Discount code* > The code of the discount that has been applied to this line. | |
discount |
double |
Discount Percent | writable, discount |
Document details tab > Discount percent > The percent of the line-level discount that has been applied manually or automatically to this line item (if the item is not a free item). | |
discount |
double |
Discount Total | filters on the platform, writable, ::ancestor. |
||
discount |
double |
itgen_vnet_discounttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
due |
datetime |
Due Date | filters on the platform, writable, ::ancestor. |
Financial settings tab > Financial information section > Due date > The due date of the invoice according to the credit terms. | |
emailed |
char |
Emailed | filters on the platform, writable, ::ancestor. |
A check box indicating if the document is emailed | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
exchange |
double |
Exchange Rate | filters on the platform, writable, ::ancestor. |
||
expiration |
datetime |
Expiration Date | writable, expiration |
Expiration date > The expiration date for the item with the specified lot number. | |
ext |
double |
Extended Price | writable, ext |
Document details tab > Extended cost > The extended price, which is the unit price multiplied by the quantity. | |
external |
varchar2 |
itgen_vnet_externallink | writable, external |
||
fob |
varchar2 |
FOB Point Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
fob |
varchar2 |
FOB Point ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
free |
char |
Free Item | writable, free |
A check box that indicates (if selected) that the stock item specified in the row is a free item. This information is collected from the system and not visible on the sales order line. | |
hold |
char |
Hold | filters on the platform, writable, ::ancestor. |
The top part > Hold > A check box that you select if the document is on hold and should not be processed further at this time. | |
insurance |
char |
Insurance | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Insurance > A check box that you select to indicate that insurance is required for this order. | |
inventory_ |
varchar2 |
Inventory Description | writable, inventory. |
Name of item/description | |
inventory_ |
varchar2 |
Inventory Number | writable, inventory. |
Number of item | |
invoice |
datetime |
Invoice Date | filters on the platform, writable, ::ancestor. |
Financial settings tab > Financial information section > Invoice date> The date of the invoice generated for the order. | |
invoice |
varchar2 |
Invoice Number | writable, invoice |
The reference number of the invoice generated for this order. This number is collected from the system and not visible on the sales order line. | |
invoice |
varchar2 |
itgen_vnet_invoicenbr_2 | filters on the platform, writable, ::ancestor. |
Financial settings tab > Financial information section > Invoice no.> The invoice number of the invoice generated for this order. | |
invoice |
char |
Invoice Separately | filters on the platform, writable, ::ancestor. |
Financial settings tab > Financial information section > Invoice separately > A check box that indicating that this document is to be invoiced separately (if that is required). | |
is |
char |
itgen_vnet_isrotrutdeductible | writable, is |
||
is |
char |
Is ROTRUT Deductible 2 | filters on the platform, writable, ::ancestor. |
A check box indicating if the document is Rot/rut deductible (applicable for the Swedish markets) | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Background information collected from the system. | |
line |
varchar2 |
Line Description | writable, line |
Document details tab > Line description > The description of the unit. | |
line |
int32 |
itgen_vnet_linenbr | writable, line |
Document details tab > Line no. > The line number of the document. | |
location_ |
varchar2 |
Location Country ID | filters on the platform, writable, ::ancestor. |
Location*. | |
location_ |
varchar2 |
Location ID | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
lot |
varchar2 |
itgen_vnet_lotserialnbr | writable, lot |
Lot/serial no. > The lot or serial number of the item for returns | |
manual |
char |
Manual Discount | writable, manual |
Document details tab > Manual discount > A check box that indicates (if selected) that the discount has been applied manually. | |
mark |
char |
itgen_vnet_markforpo | writable, mark |
Mark for purchase order > A check box that indicates (if selected) that the order line was marked for purchasing (if it has not been shipped completely). | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
Tables in tab > Icon Notes > Pop-up window for providing any user-defined text connected to the order. | |
note_2 |
varchar2 |
Note 2 | filters on the platform, writable, ::ancestor. |
Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the order. | |
open |
double |
Open Quantity | writable, open |
Document details tab > Open qty. > The quantity of the item to be shipped; that is, the total quantity minus the quantity shipped according to closed shipment documents. | |
operation |
varchar2 |
Operation | writable, operation |
The operation to be performed in the workspace to fulfil the order. This information is collected from the system and not visible on the sales order line. | |
order |
varchar2 |
Order Number | filters on the platform, writable, ::ancestor. |
The top part > Order no.: > The reference number of the document. | |
order |
double |
Order Total | filters on the platform, writable, ::ancestor. |
The top part > Order total > The total amount of the document, which is calculated as follows: Line Total + Misc.Charges + Freight + Premium Freight – Discount Total+ Tax Total | |
order |
double |
itgen_vnet_ordertotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
order |
varchar2 |
Order Type | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Order type > The type of the document, which is one of the predefined order types or a custom order type created by using the (SO201000) window. | |
orig |
varchar2 |
Original Order Number | filters on the platform, writable, ::ancestor. |
The top part > Order no. > The order number of the document. | |
orig |
varchar2 |
Original Order Type | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Order type* > The type of the document, which is one of the predefined order types or a custom order type created by using the window SO201000. | |
overship |
double |
itgen_vnet_overshipthreshold | writable, overship |
Overship threshold (%) > The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer. | |
owner_ |
varchar2 |
Owner Employee ID | filters on the platform, writable, ::ancestor. |
The Financial settings tab > The Financial information section > Owner > Click the magnifier > Employee ID > The unique identifier, which is assigned to the employee in accordance with the configuration of the EMPLOYEEsegmented key. This information is retrieved from window EP203000. | |
owner_ |
guid |
Owner ID | filters on the platform, writable, ::ancestor. |
Employee internal user ID. This is the ID of the user linked to the employee | |
owner_ |
varchar2 |
Owner Name | filters on the platform, writable, ::ancestor. |
The Financial settings tab > The Financial information section > Owner > Click the magnifier > Employee name > The name of this employee. This information is retrieved from window EP203000. | |
payment |
varchar2 |
Payment Method Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
payment |
varchar2 |
Payment Method ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
payment |
varchar2 |
Payment Reference | filters on the platform, writable, ::ancestor. |
Payment settings tab > Payment ref. | |
po |
varchar2 |
PO Source | writable, po |
Purchase order source > The purchase order source to be used to fulfill this line, which can be one of the following options: Purchase to order, Drop-shipment. | |
post |
varchar2 |
Post Period | filters on the platform, writable, ::ancestor. |
The Financial settings tab > Financial information section > Post period > The period to post the transactions generated by the invoice. Format MMYYYY. | |
preferred |
varchar2 |
Preferred Warehouse Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
preferred |
varchar2 |
Preferred Warehouse ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
print |
char |
Print Description on Invoice | filters on the platform, writable, ::ancestor. |
The top part > Print description on invoice > A check box | |
print |
char |
Print Note on External Documents | filters on the platform, writable, ::ancestor. |
The top part > Print note on external sales documents > A check box | |
print |
char |
Print Note on Internal Documents | filters on the platform, writable, ::ancestor. |
The top part > Print line note on internal sales documents > A check box | |
priority |
int32 |
Priority | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Priority > Field only for informational purposes. The level of priority for processing order of this customer, as specified for the customer on the Shipping settings tab on the AR303000 window. | |
project |
varchar2 |
Project Code | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Project* > The field consists of Project ID and Project description. Project ID: The identifier for the project with which this document is associated, or the code indicating that this document is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) window. | |
project |
int32 |
Project Task | writable, project |
Project task > The particular task of the project with which this document is associated. | |
project |
varchar2 |
itgen_vnet_projecttaskcd | writable, project |
Project task code > The particular task code of the project with which this document is associated. | |
qty |
double |
itgen_vnet_qtyonshipments | writable, qty |
Document details tab > Qty. on shipments > A read-only column that displays the quantity of the stock item being prepared for shipment and already shipped for this order. | |
quantity |
double |
Quantity | writable, quantity |
Document details tab > Quantity > The quantity of the item sold, measured in the UoM. | |
reason |
varchar2 |
Reason Code | writable, reason |
Reason code > The reason code to be used for creation or cancellation of the order, if applicable. | |
request |
datetime |
Request On | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Requested on > The date when the customer wants to receive the goods; this date provides the default values for the Requested on dates for order lines. | |
requested |
datetime |
Requested on | writable, requested |
Mandatory field: The top part > Requested on* > The date when the customer wants to receive the goods. The default value is the current business date. | |
residential |
char |
Residential Delivery | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Residential delivery > A check box that you select to indicate that the shipment should be delivered to a residential area. | |
sales |
varchar2 |
Sales Person Description | writable, sales |
Click on the magnifier. > The description. | |
sales |
varchar2 |
itgen_vnet_salesperson_description_2 | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
sales |
varchar2 |
Sales Person ID | writable, sales |
Click on the magnifier. > The identifier. | |
sales |
varchar2 |
itgen_vnet_salesperson_id_2 | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
saturday |
char |
Saturday Delivery | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Saturday delivery > A check box that indicates that the order may be delivered on Saturday. | |
sched |
datetime |
Scheduled Shipment | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Sched. shipment > The date when the ordered goods are scheduled to be shipped. | |
ship |
varchar2 |
Ship Complete | writable, ship |
Shipping rule > An option that controls whether incomplete and partial shipments for the order are allowed. (Values: Ship complete, Back order allowed, Cancel remainder) | |
ship |
varchar2 |
itgen_vnet_shipcomplete_2 | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Shipping rule > An option that controls whether incomplete and partial shipments for the order are allowed. | |
shipOn |
datetime |
itgen_vnet_shipon | writable, shipOn |
Ship on > The date when the item is to be shipped. | |
ship |
char |
Ship Separately | filters on the platform, writable, ::ancestor. |
Delivery settings tab > Shipping information section > Ship separately > This check box indicates that the goods for the customer should be shipped separately for each sales order. | |
ship |
varchar2 |
Ship via Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
ship |
varchar2 |
Ship via ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
shipping |
varchar2 |
Shipping Terms Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
shipping |
varchar2 |
Shipping Terms ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
shipping |
varchar2 |
Shipping Zone Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
shipping |
varchar2 |
Shipping Zone ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
so |
int32 |
SO Billing Address ID | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_sobillingaddress_addressline1 | filters on the platform, writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_addressline2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_addressline3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_city | filters on the platform, writable, ::ancestor. |
City > The city. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_country_errorinfo | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_sobillingaddress_country_id | filters on the platform, writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
so |
int64 |
itgen_vnet_sobillingaddress_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
so |
int64 |
itgen_vnet_sobillingaddress_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_sobillingaddress_country_name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_county_id | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
so |
varchar2 |
itgen_vnet_sobillingaddress_county_name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
so |
char |
itgen_vnet_sobillingaddress_overrideaddress | filters on the platform, writable, ::ancestor. |
Override address > A check box indicating that you want to override the default address information. | |
so |
varchar2 |
itgen_vnet_sobillingaddress_postalcode | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_attention | filters on the platform, writable, ::ancestor. |
Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. | |
so |
int32 |
itgen_vnet_sobillingcontact_contactid | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_sobillingcontact_email | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
so |
char |
itgen_vnet_sobillingcontact_overridecontact | filters on the platform, writable, ::ancestor. |
Override contact > A check box indicating that you want to override the default contact information. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_phone1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_phone2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
so |
varchar2 |
itgen_vnet_sobillingcontact_web | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
so |
int32 |
itgen_vnet_soshippingaddress_addressid | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_soshippingaddress_addressline1 | filters on the platform, writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_addressline2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_addressline3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_city | filters on the platform, writable, ::ancestor. |
City > The city. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_country_errorinfo | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_soshippingaddress_country_id | filters on the platform, writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
so |
int64 |
itgen_vnet_soshippingaddress_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
so |
int64 |
itgen_vnet_soshippingaddress_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_soshippingaddress_country_name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_county_id | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
so |
varchar2 |
itgen_vnet_soshippingaddress_county_name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
so |
char |
itgen_vnet_soshippingaddress_overrideaddress | filters on the platform, writable, ::ancestor. |
Override address > A check box indicating that you want to override the default address information. | |
so |
varchar2 |
itgen_vnet_soshippingaddress_postalcode | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_attention | filters on the platform, writable, ::ancestor. |
Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. | |
so |
int32 |
itgen_vnet_soshippingcontact_contactid | filters on the platform, writable, ::ancestor. |
||
so |
varchar2 |
itgen_vnet_soshippingcontact_email | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
so |
char |
itgen_vnet_soshippingcontact_overridecontact | filters on the platform, writable, ::ancestor. |
Override contact > A check box indicating that you want to override the default contact information. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_phone1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_phone2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
so |
varchar2 |
itgen_vnet_soshippingcontact_web | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
sort |
int32 |
itgen_vnet_sortorder | writable, sort |
Document details tab > Line order > The order number of the document line. The system regenerates this number automatically when you reorder the lines in the table. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
The top part > Status > The status of the document, which can be one of the following options: On hold, Credit hold, Pending aååroval, Rejected, Open, Cancelled, Shipping, Back order, Invoiced, Completed. | |
subaccount_ |
char |
Sub Account Active 2 | writable, subaccount. |
||
subaccount_ |
varchar2 |
Subaccount Description | writable, subaccount. |
Click on the magnifier. > The description. | |
subaccount_ |
varchar2 |
Subaccount ID | writable, subaccount. |
Click on the magnifier. > The identifier. | |
tax |
varchar2 |
Tax Category | writable, tax |
VAT code > The VAT category of the goods mentioned in this line. | |
tax |
double |
Tax Total | filters on the platform, writable, ::ancestor. |
The top part > VAT total > The total amount of tax paid on the document. | |
tax |
double |
itgen_vnet_taxtotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
terms_ |
varchar2 |
Terms Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
terms_ |
varchar2 |
Terms ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
transaction |
varchar2 |
Transaction Type Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
transaction |
int32 |
Transaction Type ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
unbilled |
double |
itgen_vnet_unbilledamount | writable, unbilled |
Document details tab > Amount not yet invoiced > The amount of cancelled shipments and cancelled remainders. | |
undership |
double |
itgen_vnet_undershipthreshold | writable, undership |
Undership threshold (%) > The minimal percentage of goods shipped (with respect to the ordered quantity) to consider the order shipped completely. | |
unit |
double |
Unit Cost | writable, unit |
Document details tab > Unit Cost > The cost of the unit on the sales order. | |
unit |
double |
itgen_vnet_unitprice | writable, unit |
Document details tab > Unit price > The price of the unit on the sales order. | |
unit |
double |
itgen_vnet_unitpriceinbasecurrency | writable, unit |
||
uom |
varchar2 |
Unit of Measure | writable, uom |
Mandatory field: Document details tab > UoM* > The unit of measure (UoM) used for the item with this item ID. | |
vat |
double |
VAT Exempt Total | filters on the platform, writable, ::ancestor. |
The top part > VAT exempt total > The document total that is exempt from VAT. | |
vat |
double |
itgen_vnet_vatexempttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
vat |
double |
VAT Taxable Total | filters on the platform, writable, ::ancestor. |
The top part > VAT taxable total > The document total that is subject to VAT. | |
vat |
double |
itgen_vnet_vattaxabletotalinbasecurrency | filters on the platform, writable, ::ancestor. |
||
warehouse_ |
varchar2 |
Warehouse Description | writable, warehouse. |
Click on the magnifier. > The description. | |
warehouse_ |
varchar2 |
Warehouse ID | writable, warehouse. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: