SalesOrderRotRutDistributions: Visma.net Financials itgen_vnet_salesorderrotrutdistributions_plural
read only REST
- Catalog:
NgSalesOrders - Schema:
SalesOrders - Label: itgen_vnet_salesorderrotrutdistributions_plural
Gets a paged list with sales orders of any type. Sample requests:
GET /salesorders
GET /salesorders?customerId=10000&status=Open&pageSize=10
GET /salesorders?orderBy=lastModified%20asc
GET /salesorders?expand=all&pageSize=100
When any expand value is specified, the effective maximum pageSize is 100.
Can only retrieve data.
Summary
Sample requests:
GET /salesorders
GET /salesorders?customerId=10000&status=Open&pageSize=10
GET /salesorders?orderBy=lastModified%20asc
GET /salesorders?expand=all&pageSize=100
When any expand value is specified, the effective maximum pageSize is 100.
API Source
- Endpoint:
/api/v3/SalesOrders - Operation:
get /api/v3/SalesOrders
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 |
|---|---|---|---|---|
customer |
`` | The customer for which to retrieve orders. If omitted or empty, orders for all customers are included | ||
modified |
`` | A date/time value for filtering when a sales order last changed. Unless a specific time zone offset is included (e.g. '2012-12-24T12:15:14+02:00'), the date is considered to be in the UTC time zone. | ||
status |
`` | The order status to include in the result. If omitted or empty, orders with any status are included. |
Table Columns
The columns of the table SalesOrderRotRutDistributions 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. | |
amount |
double |
Amount | writable, amount |
The amount | |
apartment |
varchar2 |
itgen_vnet_apartment | writable, ::ancestor. |
The apartment reference | |
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 | filters on the platform, writable, ::ancestor. |
The description | |
branch_ |
varchar2 |
itgen_vnet_branch_id | filters on the platform, writable, ::ancestor. |
The id | |
c_ |
varchar2 |
itgen_vnet_c_links | writable | Links applicable for the dto The JSON text of the nested object. | |
cancel |
datetime |
Cancel by | filters on the platform, writable, ::ancestor. |
The cancel date for the order | |
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 | filters on the platform, writable, ::ancestor. |
The currency id 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 | 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. | |
customer |
varchar2 |
itgen_vnet_customerid | filters on the platform, writable, ::ancestor. |
The customer Id for the order (a.k.a CustomerCd) | |
customer |
varchar2 |
itgen_vnet_customername | filters on the platform, writable, ::ancestor. |
The name of the customer as it appears on the order | |
customer |
varchar2 |
Customer Order | filters on the platform, writable, ::ancestor. |
The customer order link | |
customer |
varchar2 |
Customer Reference Number | filters on the platform, writable, ::ancestor. |
The order reference number of the customer | |
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. |
||
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
Any description on the order | |
distributed |
double |
Distributed Amount | writable, ::ancestor. |
The total amount distributed among the specified personal IDs | |
distributed |
char |
itgen_vnet_distributedautomatically | writable, ::ancestor. |
Whether the ROT/RUT is distributed automatically | |
emailed |
char |
Emailed | filters on the platform, writable, ::ancestor. |
Indicates if the document was emailed | |
estate |
varchar2 |
Estate | writable, ::ancestor. |
The estate reference | |
extra |
char |
Extra | writable, extra |
Whether this is extra or not | |
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 | |
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. |
||
is |
char |
itgen_vnet_isrotrutdeductible | filters on the platform, writable, ::ancestor. |
Whether the order is ROT/RUT deductible | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
The date and time the order was last modified | |
lineId |
int32 |
Line Identifier | writable, lineId |
Reference to the order line | |
location |
varchar2 |
itgen_vnet_location | filters on the platform, writable, ::ancestor. |
The customer location for this order | |
material |
double |
itgen_vnet_materialcostamount | writable, ::ancestor. |
Cost amount for lines with inventory ROT/RUT item type Material | |
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
Any notes on the order | |
order |
varchar2 |
itgen_vnet_orderid | filters on the platform, writable, ::ancestor. |
The order id (a.k.a OrderCd) for the order | |
order |
double |
Order Quantity | filters on the platform, writable, ::ancestor. |
The total number of items on the order | |
order |
double |
Order Total | filters on the platform, writable, ::ancestor. |
The total amount on the order | |
organization |
varchar2 |
Organisation Number | writable, ::ancestor. |
The organization number | |
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 | |
other |
double |
itgen_vnet_othercostamount | writable, ::ancestor. |
Cost amount for lines with inventory ROT/RUT item type OtherCost | |
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 | |
personal |
varchar2 |
Personal ID | writable, personal |
The personal id | |
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 |
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 | |
request |
datetime |
Request On | filters on the platform, writable, ::ancestor. |
||
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 | |
shipping |
datetime |
itgen_vnet_shippingscheduleddate | filters on the platform, writable, ::ancestor. |
||
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 | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
The current status of the order | |
status |
char |
itgen_vnet_statusdetails_cancelled | filters on the platform, writable, ::ancestor. |
Whether this order is in a cancelled state | |
status |
varchar2 |
itgen_vnet_statusdetails_description | filters on the platform, writable, ::ancestor. |
The status name for the order | |
status |
char |
itgen_vnet_statusdetails_hold | filters on the platform, writable, ::ancestor. |
Whether this order is in a held state | |
tax |
double |
Tax Total | filters on the platform, writable, ::ancestor. |
The tax total | |
total |
double |
itgen_vnet_totaldeductableamount | writable, ::ancestor. |
The total amount that is tax deductable | |
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 | writable, ::ancestor. |
The type of ROT/RUT | |
type_2 |
varchar2 |
itgen_vnet_type_2 | filters on the platform, writable, ::ancestor. |
The type of the order | |
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 | |
work |
double |
itgen_vnet_workpriceamount | writable, ::ancestor. |
Price amount for lines with inventory ROT/RUT item type Service |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: