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 |
|---|---|---|---|---|
order |
`` | 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_ |
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 | writable, ::ancestor. |
The invoice amount which is not invoiced for this sales order line | |
auto |
char |
itgen_vnet_autocreateissue | 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 | writable, ::ancestor. |
The base order quantity for this line | |
billed |
double |
itgen_vnet_billedquantity | writable, ::ancestor. |
The billed quantity for this line | |
billing_ |
varchar2 |
itgen_vnet_billing_address_city | filters on the platform, writable, ::ancestor. |
The city | |
billing_ |
varchar2 |
itgen_vnet_billing_address_country_id | filters on the platform, writable, ::ancestor. |
The id | |
billing_ |
varchar2 |
itgen_vnet_billing_address_country_name | filters on the platform, writable, ::ancestor. |
The name | |
billing_ |
varchar2 |
itgen_vnet_billing_address_county_id | filters on the platform, writable, ::ancestor. |
The id | |
billing_ |
varchar2 |
itgen_vnet_billing_address_county_name | filters on the platform, writable, ::ancestor. |
The name | |
billing_ |
int32 |
itgen_vnet_billing_address_id | filters on the platform, writable, ::ancestor. |
The address id | |
billing_ |
varchar2 |
itgen_vnet_billing_address_line1 | filters on the platform, writable, ::ancestor. |
Address line 1 | |
billing_ |
varchar2 |
itgen_vnet_billing_address_line2 | filters on the platform, writable, ::ancestor. |
Address line 2 | |
billing_ |
varchar2 |
itgen_vnet_billing_address_line3 | filters on the platform, writable, ::ancestor. |
Address line 3 | |
billing_ |
char |
itgen_vnet_billing_address_overridesdefault | filters on the platform, writable, ::ancestor. |
Whether this address overrides the default address | |
billing_ |
varchar2 |
itgen_vnet_billing_address_postalcode | filters on the platform, writable, ::ancestor. |
The postal code | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_attention | filters on the platform, writable, ::ancestor. |
Any attention for the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_email | filters on the platform, writable, ::ancestor. |
The e-mail address of the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_fax | filters on the platform, writable, ::ancestor. |
The fax number of the contact | |
billing_ |
int32 |
itgen_vnet_billing_contact_id | filters on the platform, writable, ::ancestor. |
The id of the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_name | filters on the platform, writable, ::ancestor. |
The name of the contact | |
billing_ |
char |
itgen_vnet_billing_contact_overridesdefault | filters on the platform, writable, ::ancestor. |
Whether this overrides the default contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_phone1 | filters on the platform, writable, ::ancestor. |
The phone number of the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_phone2 | filters on the platform, writable, ::ancestor. |
The secondary phone number of the contact | |
branch_ |
varchar2 |
itgen_vnet_branch_description | writable, ::ancestor. |
The description | |
branch_ |
varchar2 |
itgen_vnet_branch_description_2 | filters on the platform, writable, ::ancestor. |
The description | |
branch_ |
varchar2 |
itgen_vnet_branch_id | writable, ::ancestor. |
The id | |
branch_ |
varchar2 |
itgen_vnet_branch_id_2 | filters on the platform, writable, ::ancestor. |
The id | |
cancel |
datetime |
Cancel by | filters on the platform, writable, ::ancestor. |
The cancel date for the order | |
commissionable |
char |
Commissionable | writable, ::ancestor. |
Indicates if line is commissionable | |
completed |
char |
Completed | writable, ::ancestor. |
Whether this order line is completed or not | |
created |
varchar2 |
itgen_vnet_createdby | filters on the platform, writable, ::ancestor. |
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. | |
currency |
varchar2 |
Currency ID | filters on the platform, writable, ::ancestor. |
CurrencyId for the order. | |
currency |
double |
itgen_vnet_currencyrate | filters on the platform, writable, ::ancestor. |
The currency rate of the order. To calculate the order amount in base currency, take the order amount and multiply with the currencyRate. | |
custom |
datetime |
itgen_vnet_customfields_customdatetimeutc1 | writable, ::ancestor. |
A free custom colum of type DateTime - in UTC timezone | |
custom |
datetime |
itgen_vnet_customfields_customdatetimeutc1_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type DateTime - in UTC timezone | |
custom |
double |
itgen_vnet_customfields_customdec1 | writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
double |
itgen_vnet_customfields_customdec1_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
double |
itgen_vnet_customfields_customdec2 | writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
double |
itgen_vnet_customfields_customdec2_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type decimal with max 4 decimals. | |
custom |
int32 |
itgen_vnet_customfields_customint1 | writable, ::ancestor. |
A free custom colum of type int | |
custom |
int32 |
itgen_vnet_customfields_customint1_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type int | |
custom |
int32 |
itgen_vnet_customfields_customint2 | writable, ::ancestor. |
A free custom colum of type int | |
custom |
int32 |
itgen_vnet_customfields_customint2_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type int | |
custom |
varchar2 |
itgen_vnet_customfields_customstr1 | writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr1_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr2 | writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr2_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr3 | writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr3_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr4 | writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr4_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr5 | writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr5_2 | filters on the platform, writable, ::ancestor. |
A free custom colum of type string with max length 100. | |
customer_ |
int32 |
itgen_vnet_customer_contactid | filters on the platform, writable, ::ancestor. |
The contact id for the customer | |
customer_ |
varchar2 |
itgen_vnet_customer_id | filters on the platform, writable, ::ancestor. |
The unique id of the the customer | |
customer_ |
int32 |
Customer Internal ID | filters on the platform, writable, ::ancestor. |
An internal unique id of the customer | |
customer_ |
varchar2 |
itgen_vnet_customer_location_corporateid | filters on the platform, writable, ::ancestor. |
The corporate id of the location | |
customer_ |
varchar2 |
itgen_vnet_customer_location_countryid | filters on the platform, writable, ::ancestor. |
The country code of the location | |
customer_ |
varchar2 |
itgen_vnet_customer_location_gln | filters on the platform, writable, ::ancestor. |
The global localization number of the location | |
customer_ |
varchar2 |
itgen_vnet_customer_location_id | filters on the platform, writable, ::ancestor. |
Location id | |
customer_ |
int32 |
itgen_vnet_customer_location_internalid | filters on the platform, writable, ::ancestor. |
An internal id of the customer location | |
customer_ |
varchar2 |
itgen_vnet_customer_location_name | filters on the platform, writable, ::ancestor. |
Location description | |
customer_ |
varchar2 |
itgen_vnet_customer_location_taxregistrationid | filters on the platform, writable, ::ancestor. |
The tax registration id of the location | |
customer_ |
varchar2 |
itgen_vnet_customer_location_warehouseid | filters on the platform, writable, ::ancestor. |
The site id of the location | |
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, ::ancestor. |
The customer name | |
customer_ |
varchar2 |
itgen_vnet_customer_order | filters on the platform, writable, ::ancestor. |
The customer order text | |
customer_ |
varchar2 |
itgen_vnet_customer_refno | filters on the platform, writable, ::ancestor. |
The customer ref number text | |
customer_ |
varchar2 |
itgen_vnet_customer_taxzone_description | filters on the platform, writable, ::ancestor. |
The description | |
customer_ |
varchar2 |
itgen_vnet_customer_taxzone_id | filters on the platform, writable, ::ancestor. |
The id | |
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
Date the order was submitted | |
description |
varchar2 |
Description | writable, ::ancestor. |
Any description for this order line | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
Description of the order | |
discount |
double |
itgen_vnet_discountamount | writable, ::ancestor. |
The discount amount for this line | |
discount |
varchar2 |
Discount Code | writable, ::ancestor. |
Code of discount applied to this line | |
discount |
double |
Discount Percent | writable, ::ancestor. |
Discount percentage applied to this line | |
discount |
varchar2 |
itgen_vnet_discountsequenceid | writable, ::ancestor. |
Id of discount sequence applied to this line | |
discounted |
double |
itgen_vnet_discountedunitprice | writable, ::ancestor. |
The discounted unit price for this order line | |
emailed |
char |
Emailed | filters on the platform, writable, ::ancestor. |
Indicates if the document was emailed | |
excise |
double |
itgen_vnet_exciseduty | 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 | writable, ::ancestor. |
The extended price for this sales order line | |
external |
varchar2 |
itgen_vnet_externallink | writable, ::ancestor. |
Any external link for this sales order line | |
financial |
datetime |
itgen_vnet_financialinformation_cashdiscountdate | filters on the platform, writable, ::ancestor. |
||
financial |
datetime |
itgen_vnet_financialinformation_duedate | filters on the platform, writable, ::ancestor. |
||
financial |
datetime |
itgen_vnet_financialinformation_invoicedate | filters on the platform, writable, ::ancestor. |
||
financial |
varchar2 |
itgen_vnet_financialinformation_invoiceid | filters on the platform, writable, ::ancestor. |
The id of the invoice issued for the order | |
financial |
char |
itgen_vnet_financialinformation_invoiceseparately | filters on the platform, writable, ::ancestor. |
Whether the order should be invoiced separately | |
financial |
varchar2 |
itgen_vnet_financialinformation_postperiod | filters on the platform, writable, ::ancestor. |
The post period for the invoice | |
financial |
varchar2 |
itgen_vnet_financialinformation_terms_description | filters on the platform, writable, ::ancestor. |
The description | |
financial |
varchar2 |
itgen_vnet_financialinformation_terms_id | filters on the platform, writable, ::ancestor. |
The id | |
free |
char |
Free Item | writable, ::ancestor. |
Whether these item(s) are free or not | |
freight_ |
double |
itgen_vnet_freight_amount | filters on the platform, writable, ::ancestor. |
The amounts calculated based on the ship terms. /// | |
freight_ |
double |
itgen_vnet_freight_amountinbasecurrency | filters on the platform, writable, ::ancestor. |
The amounts calculated based on the ship terms in base currency of the order. | |
freight_ |
double |
itgen_vnet_freight_cost | filters on the platform, writable, ::ancestor. |
The freight cost calculated for the sales order, | |
freight_ |
double |
itgen_vnet_freight_costinbasecurrency | filters on the platform, writable, ::ancestor. |
The freight cost calculated for the sales order in base currency. | |
freight_ |
double |
itgen_vnet_freight_premiumamount | filters on the platform, writable, ::ancestor. |
The additional freight charges for handling the order. | |
freight_ |
double |
itgen_vnet_freight_premiumamountinbasecurrency | filters on the platform, writable, ::ancestor. |
The additional freight charges in base currency for handling the order. | |
freight_ |
varchar2 |
itgen_vnet_freight_taxcategoryid | filters on the platform, writable, ::ancestor. |
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_ |
double |
itgen_vnet_freight_volume | filters on the platform, writable, ::ancestor. |
||
freight_ |
double |
itgen_vnet_freight_weight | filters on the platform, writable, ::ancestor. |
||
has |
char |
itgen_vnet_hasmanualdiscount | writable, ::ancestor. |
Discount is applied manually | |
has |
char |
itgen_vnet_hasmanualprice | writable, ::ancestor. |
Unit price is applied manually | |
inventory |
varchar2 |
itgen_vnet_inventoryalternateid | writable, ::ancestor. |
||
inventory_ |
varchar2 |
itgen_vnet_inventory_baseunit | writable, ::ancestor. |
||
inventory_ |
varchar2 |
Inventory Description | writable, ::ancestor. |
The description | |
inventory_ |
varchar2 |
itgen_vnet_inventory_id | writable, ::ancestor. |
The id | |
invoice |
int32 |
itgen_vnet_invoicelinenumber | writable, ::ancestor. |
The line number of the original invoice to be returned | |
invoice |
varchar2 |
itgen_vnet_invoicenumber | writable, ::ancestor. |
The reference number of the original invoice to be returned | |
invoice |
varchar2 |
itgen_vnet_invoicetype | writable, ::ancestor. |
The invoice type of the original invoice to be returned | |
is |
char |
itgen_vnet_isrotrutdeductible | writable, ::ancestor. |
||
is |
char |
Is ROTRUT Deductible 2 | filters on the platform, writable, ::ancestor. |
Whether the order is ROT/RUT deductible | |
kit |
varchar2 |
itgen_vnet_kitassembly_referencenumber | writable, ::ancestor. |
||
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
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. |
The line number of the sales order line | |
line |
double |
itgen_vnet_linetotalbeforediscount | writable, ::ancestor. |
The line total before any discounts are applied | |
line |
varchar2 |
Line Type | writable, ::ancestor. |
The type of sales order line | |
note |
varchar2 |
Note | writable, ::ancestor. |
Any note that has been applied to this order line | |
note_2 |
varchar2 |
Note 2 | filters on the platform, writable, ::ancestor. |
Any notes on the order | |
open |
char |
itgen_vnet_openline | writable, ::ancestor. |
Indicates if line has quantity left to be shipped | |
open |
double |
itgen_vnet_openquantity | writable, ::ancestor. |
The open quantity for this line | |
operation |
varchar2 |
Operation | writable, ::ancestor. |
The type of operation the line represents to the order | |
order |
datetime |
itgen_vnet_orderdate | writable, ::ancestor. |
||
order |
varchar2 |
itgen_vnet_orderid | filters on the platform, writable, ::ancestor. |
The unique identifier of the order | |
order |
double |
Order Quantity | filters on the platform, writable, ::ancestor. |
The total quantity of inventory items in the order | |
origin_ |
varchar2 |
itgen_vnet_origin__links | writable | Links applicable for the dto The JSON text of the nested object. | |
origin_ |
varchar2 |
itgen_vnet_origin_orderid | filters on the platform, writable, ::ancestor. |
The unique id of the origin order | |
origin_ |
varchar2 |
itgen_vnet_origin_ordertype | filters on the platform, writable, ::ancestor. |
The order type code for the origin order | |
original |
varchar2 |
itgen_vnet_originalorderid | filters on the platform, writable, ::ancestor. |
The unique identifier of the original order | |
original |
varchar2 |
itgen_vnet_originalordertype | filters on the platform, writable, ::ancestor. |
The type code for the original sales order | |
overship |
double |
itgen_vnet_overshipthreshold | writable, ::ancestor. |
The overship threshold value (%) | |
owner_ |
varchar2 |
Owner ID | filters on the platform, writable, ::ancestor. |
The identifier of the employee | |
owner_ |
varchar2 |
Owner Internal ID | filters on the platform, writable, ::ancestor. |
The internal unique identifier of the employee | |
parent |
varchar2 |
itgen_vnet_parentcustomer_id | filters on the platform, writable, ::ancestor. |
The unique id of the the customer | |
parent |
int32 |
itgen_vnet_parentcustomer_internalid | filters on the platform, writable, ::ancestor. |
An internal unique id of the customer | |
parent |
varchar2 |
itgen_vnet_parentcustomer_name | filters on the platform, writable, ::ancestor. |
The customer name | |
payment |
varchar2 |
itgen_vnet_paymentsettings_cashaccountid | filters on the platform, writable, ::ancestor. |
The cash account to use | |
payment |
varchar2 |
itgen_vnet_paymentsettings_paymentmethod_description | filters on the platform, writable, ::ancestor. |
The description | |
payment |
varchar2 |
itgen_vnet_paymentsettings_paymentmethod_id | filters on the platform, writable, ::ancestor. |
The id | |
payment |
varchar2 |
itgen_vnet_paymentsettings_paymentreference | filters on the platform, writable, ::ancestor. |
The payment reference | |
print_ |
char |
itgen_vnet_print_descriptiononinvoice | filters on the platform, writable, ::ancestor. |
Set to true to print description on the invoice | |
print_ |
char |
itgen_vnet_print_noteonexternaldocuments | filters on the platform, writable, ::ancestor. |
Set to true to print note on external documents | |
print_ |
char |
itgen_vnet_print_noteoninternaldocuments | filters on the platform, writable, ::ancestor. |
Set to true to print note on internal documents | |
project |
varchar2 |
itgen_vnet_projecttaskid | writable, ::ancestor. |
The project task with which this sales order line is associated | |
project_ |
varchar2 |
Project Description | filters on the platform, writable, ::ancestor. |
The description | |
project_ |
varchar2 |
Project ID | filters on the platform, writable, ::ancestor. |
The id | |
project_ |
int32 |
itgen_vnet_project_internalid | filters on the platform, writable, ::ancestor. |
An internal unique identifier of the project | |
purchase |
varchar2 |
itgen_vnet_purchaseordersource | writable, ::ancestor. |
Information about line purchase order source | |
quantity |
double |
Quantity | writable, ::ancestor. |
The quantity of unit of measure this line represents | |
quantity |
double |
itgen_vnet_quantityonshipments | writable, ::ancestor. |
The quantity on shipments for this line | |
reason |
varchar2 |
Reason Code | writable, ::ancestor. |
The reason code | |
replacement |
double |
itgen_vnet_replacementunitcost | 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 | writable, ::ancestor. |
The request date for this order line | |
request |
datetime |
Request On | filters on the platform, writable, ::ancestor. |
Date the order was requested | |
rot |
double |
itgen_vnet_rotrutdeductibleamount | writable, ::ancestor. |
||
rot |
varchar2 |
itgen_vnet_rotrutitemtype_description | writable, ::ancestor. |
The description | |
rot |
varchar2 |
itgen_vnet_rotrutitemtype_id | writable, ::ancestor. |
The id | |
rot |
varchar2 |
itgen_vnet_rotrutworktype | writable, ::ancestor. |
||
rot |
varchar2 |
itgen_vnet_rotrut_apartment | filters on the platform, writable, ::ancestor. |
The apartment reference | |
rot |
double |
itgen_vnet_rotrut_distributedamount | filters on the platform, writable, ::ancestor. |
The total amount distributed among the specified personal IDs | |
rot |
char |
itgen_vnet_rotrut_distributedautomatically | filters on the platform, writable, ::ancestor. |
Whether the ROT/RUT is distributed automatically | |
rot |
varchar2 |
itgen_vnet_rotrut_estate | filters on the platform, writable, ::ancestor. |
The estate reference | |
rot |
double |
itgen_vnet_rotrut_materialcostamount | filters on the platform, writable, ::ancestor. |
Cost amount for lines with inventory ROT/RUT item type Material | |
rot |
varchar2 |
itgen_vnet_rotrut_organizationnumber | filters on the platform, writable, ::ancestor. |
The organization number | |
rot |
double |
itgen_vnet_rotrut_othercostamount | filters on the platform, writable, ::ancestor. |
Cost amount for lines with inventory ROT/RUT item type OtherCost | |
rot |
double |
itgen_vnet_rotrut_totaldeductableamount | filters on the platform, writable, ::ancestor. |
The total amount that is tax deductable | |
rot |
varchar2 |
itgen_vnet_rotrut_type | filters on the platform, writable, ::ancestor. |
The type of ROT/RUT | |
rot |
double |
itgen_vnet_rotrut_workpriceamount | filters on the platform, writable, ::ancestor. |
Price amount for lines with inventory ROT/RUT item type Service | |
sales |
varchar2 |
itgen_vnet_salesaccountid | writable, ::ancestor. |
The general ledger account this line applies to | |
sales |
varchar2 |
Sales Person Description | writable, ::ancestor. |
The description | |
sales |
varchar2 |
itgen_vnet_salesperson_description_2 | filters on the platform, writable, ::ancestor. |
The description | |
sales |
varchar2 |
Sales Person ID | writable, ::ancestor. |
The id | |
sales |
varchar2 |
itgen_vnet_salesperson_id_2 | filters on the platform, writable, ::ancestor. |
The id | |
ship |
datetime |
itgen_vnet_shipdate | writable, ::ancestor. |
The expected shipping date for this order line | |
shipping |
varchar2 |
itgen_vnet_shippingrule | writable, ::ancestor. |
The shipping rule code for this order line | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_city | filters on the platform, writable, ::ancestor. |
The city | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_country_id | filters on the platform, writable, ::ancestor. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_country_name | filters on the platform, writable, ::ancestor. |
The name | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_county_id | filters on the platform, writable, ::ancestor. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_county_name | filters on the platform, writable, ::ancestor. |
The name | |
shipping_ |
int32 |
itgen_vnet_shipping_address_id | filters on the platform, writable, ::ancestor. |
The address id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_line1 | filters on the platform, writable, ::ancestor. |
Address line 1 | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_line2 | filters on the platform, writable, ::ancestor. |
Address line 2 | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_line3 | filters on the platform, writable, ::ancestor. |
Address line 3 | |
shipping_ |
char |
itgen_vnet_shipping_address_overridesdefault | filters on the platform, writable, ::ancestor. |
Whether this address overrides the default address | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_postalcode | filters on the platform, writable, ::ancestor. |
The postal code | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_attention | filters on the platform, writable, ::ancestor. |
Any attention for the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_email | filters on the platform, writable, ::ancestor. |
The e-mail address of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_fax | filters on the platform, writable, ::ancestor. |
The fax number of the contact | |
shipping_ |
int32 |
itgen_vnet_shipping_contact_id | filters on the platform, writable, ::ancestor. |
The id of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_name | filters on the platform, writable, ::ancestor. |
The name of the contact | |
shipping_ |
char |
itgen_vnet_shipping_contact_overridesdefault | filters on the platform, writable, ::ancestor. |
Whether this overrides the default contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_phone1 | filters on the platform, writable, ::ancestor. |
The phone number of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_phone2 | filters on the platform, writable, ::ancestor. |
The secondary phone number of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_fobpoint_description | filters on the platform, writable, ::ancestor. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_fobpoint_id | filters on the platform, writable, ::ancestor. |
The id | |
shipping_ |
char |
itgen_vnet_shipping_insurance | filters on the platform, writable, ::ancestor. |
Whether insurance applies to this shipping | |
shipping_ |
varchar2 |
itgen_vnet_shipping_intrastattransactiontype_description | filters on the platform, writable, ::ancestor. |
The description | |
shipping_ |
int32 |
itgen_vnet_shipping_intrastattransactiontype_id | filters on the platform, writable, ::ancestor. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_preferredwarehouse_description | filters on the platform, writable, ::ancestor. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_preferredwarehouse_id | filters on the platform, writable, ::ancestor. |
The id | |
shipping_ |
int32 |
itgen_vnet_shipping_priority | filters on the platform, writable, ::ancestor. |
Priority of the order | |
shipping_ |
char |
itgen_vnet_shipping_residentialdelivery | filters on the platform, writable, ::ancestor. |
Whether this is residential delivery | |
shipping_ |
varchar2 |
itgen_vnet_shipping_rule | filters on the platform, writable, ::ancestor. |
The shipping rule | |
shipping_ |
char |
itgen_vnet_shipping_saturdaydelivery | filters on the platform, writable, ::ancestor. |
Whether this is a saturday delivery | |
shipping_ |
datetime |
itgen_vnet_shipping_scheduleddate | filters on the platform, writable, ::ancestor. |
The shipping scheduled date | |
shipping_ |
char |
itgen_vnet_shipping_shipseparately | filters on the platform, writable, ::ancestor. |
Whether this order can/is shipped separately | |
shipping_ |
varchar2 |
itgen_vnet_shipping_shipvia_description | filters on the platform, writable, ::ancestor. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_shipvia_id | filters on the platform, writable, ::ancestor. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_terms_description | filters on the platform, writable, ::ancestor. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_terms_id | filters on the platform, writable, ::ancestor. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_zone_description | filters on the platform, writable, ::ancestor. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_zone_id | filters on the platform, writable, ::ancestor. |
The id | |
sort |
int32 |
itgen_vnet_sortorder | writable, ::ancestor. |
Used to apply sort order to a set of lines | |
status_ |
char |
itgen_vnet_status_cancelled | filters on the platform, writable, ::ancestor. |
Whether this order is in a cancelled state | |
status_ |
varchar2 |
itgen_vnet_status_description | filters on the platform, writable, ::ancestor. |
The status name for the order | |
status_ |
char |
itgen_vnet_status_hold | filters on the platform, writable, ::ancestor. |
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. | |
supplier |
double |
itgen_vnet_supplierprice | writable, ::ancestor. |
||
supplier_ |
varchar2 |
itgen_vnet_supplier_currencyid | writable, ::ancestor. |
The currency of the supplier selected for the order line | |
supplier_ |
varchar2 |
itgen_vnet_supplier_id | writable, ::ancestor. |
The id of the supplier selected for the order line | |
supplier_ |
varchar2 |
Supplier Name | writable, ::ancestor. |
The name of the supplier selected for the order line | |
supplier_ |
double |
itgen_vnet_supplier_price | writable, ::ancestor. |
The supplier price of the supplier selected for the order line | |
supplier_ |
varchar2 |
itgen_vnet_supplier_unitofmeasure | writable, ::ancestor. |
The unit of measure used by the supplier for this line | |
tax |
varchar2 |
itgen_vnet_taxcategoryid | writable, ::ancestor. |
The Tax Category Id applying to this order line | |
term |
datetime |
Term End Date | writable, ::ancestor. |
The term end date for deferred revenue recognition on this order line. | |
term |
datetime |
Term Start Date | writable, ::ancestor. |
The term start date for deferred revenue recognition on this order line. | |
totals_ |
double |
itgen_vnet_totals_costtotal | filters on the platform, writable, ::ancestor. |
The total of the costs on the lines of the sales order. How the cost is calculated is dependent on the option use. If this option is true the cost will be calculated based on the replacement. If this option is false, the cost will be calculate based on unit |
|
totals_ |
double |
itgen_vnet_totals_costtotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The total of the costs on the lines of the sales order in base currency. | |
totals_ |
double |
itgen_vnet_totals_discounttotal | filters on the platform, writable, ::ancestor. |
The discount total | |
totals_ |
double |
itgen_vnet_totals_discounttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The discount total in base currency | |
totals_ |
double |
itgen_vnet_totals_excisedutytotal | filters on the platform, writable, ::ancestor. |
The sum of excise duty for the lines | |
totals_ |
double |
itgen_vnet_totals_excisedutytotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The sum of excise duty for the lines in base currency | |
totals_ |
double |
itgen_vnet_totals_freightcost | filters on the platform, writable, ::ancestor. |
The freight cost calculated for the sales order. Not applicable for transfer order types. | |
totals_ |
double |
itgen_vnet_totals_freightcostinbasecurrency | filters on the platform, writable, ::ancestor. |
The freight cost calculated for the sales order in base currency. Not applicable for transfer order types. | |
totals_ |
double |
itgen_vnet_totals_freighttotal | filters on the platform, writable, ::ancestor. |
The freight amount calculated in accordance with the shipping terms. Not applicable for transfer order types. | |
totals_ |
double |
itgen_vnet_totals_freighttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The freight amount calculated in accordance with the shipping terms in base currency. Not applicable for transfer order types. | |
totals_ |
double |
itgen_vnet_totals_ordertotal | filters on the platform, writable, ::ancestor. |
The order total | |
totals_ |
double |
itgen_vnet_totals_ordertotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The order total in base currency | |
totals_ |
double |
itgen_vnet_totals_paymenttotal | filters on the platform, writable, ::ancestor. |
The total amount of payments connected to the order in the order currency | |
totals_ |
double |
itgen_vnet_totals_paymenttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The total amount of payments connected to the order in the base currency | |
totals_ |
double |
itgen_vnet_totals_taxexempttotal | filters on the platform, writable, ::ancestor. |
The VAT exempt total | |
totals_ |
double |
itgen_vnet_totals_taxexempttotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The VAT exempt total in base currency | |
totals_ |
double |
itgen_vnet_totals_taxtotal | filters on the platform, writable, ::ancestor. |
The tax total | |
totals_ |
double |
itgen_vnet_totals_taxtotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The tax total in base currency | |
totals_ |
double |
itgen_vnet_totals_taxabletotal | filters on the platform, writable, ::ancestor. |
The VAT taxable total | |
totals_ |
double |
itgen_vnet_totals_taxabletotalinbasecurrency | filters on the platform, writable, ::ancestor. |
The VAT taxable in base currency | |
totals_ |
double |
itgen_vnet_totals_unbilledamount | filters on the platform, writable, ::ancestor. |
The sum of unbilled amounts for the lines | |
totals_ |
double |
itgen_vnet_totals_unbilledamountinbasecurrency | filters on the platform, writable, ::ancestor. |
The sum of unbilled amounts for the lines in base currency | |
totals_ |
double |
itgen_vnet_totals_unshippedamount | filters on the platform, writable, ::ancestor. |
The sum of unshipped amounts for the lines | |
totals_ |
double |
itgen_vnet_totals_unshippedamountinbasecurrency | filters on the platform, writable, ::ancestor. |
The sum of unshipped amounts for the lines in base currency | |
type |
varchar2 |
Type | filters on the platform, writable, ::ancestor. |
The type code for the sales order | |
undership |
double |
itgen_vnet_undershipthreshold | writable, ::ancestor. |
The undership threshold value (%) | |
unit |
double |
Unit Cost | writable, ::ancestor. |
The unit cost of items on this order line | |
unit |
varchar2 |
itgen_vnet_unitofmeasure | writable, ::ancestor. |
The unit of measure (UOM) for the sales order line | |
unit |
double |
itgen_vnet_unitprice | writable, ::ancestor. |
The unit price for items on this order line | |
use |
char |
itgen_vnet_usereplacementcostformarginandprofit | filters on the platform, writable, ::ancestor. |
When this option is set to true, the cost of the order will be calculated based on replacement. If option is set to false, the cost will be calculated based on unit |
|
version |
blob |
itgen_vnet_version | filters on the platform, writable, ::ancestor. |
An internal order version used for detecting concurrent updates to an order | |
warehouse |
varchar2 |
Warehouse ID | writable, ::ancestor. |
The Site Id for items on this line | |
warehouse |
varchar2 |
itgen_vnet_warehouselocation_description | writable, ::ancestor. |
The description | |
warehouse |
varchar2 |
itgen_vnet_warehouselocation_id | writable, ::ancestor. |
The id |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: