SalesOrderDiscountsViaOrderByTypeOrderId: Visma.net Financials itgen_vnet_salesorderdiscountsviaorderbytypeorderid_plural
read only REST
- Catalog:
NgSalesOrders - Schema:
SalesOrders - Label: itgen_vnet_salesorderdiscountsviaorderbytypeorderid_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 SalesOrderDiscountsViaOrderByTypeOrderId 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. | |
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 | |
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 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 | 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_ |
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 | filters on the platform, writable, ::ancestor. |
Description of the order | |
discount |
double |
itgen_vnet_discountamount | writable, discount |
The amount of the discount | |
discount |
varchar2 |
itgen_vnet_discountid | writable, discount |
The identifier of the discount applied to the order | |
discount |
double |
Discount Percent | writable, discount |
The discount percent, if the discount is defined to be calculated as a percentage | |
discount |
varchar2 |
itgen_vnet_discountsequenceid | writable, discount |
The identifier of the discount sequence of the discount ID applied to the order | |
discountable |
double |
itgen_vnet_discountableamount | writable, discountable |
The amount used as a base for discount calculation if the discount is based on amount. | |
discountable |
double |
itgen_vnet_discountablequantity | writable, discountable |
The quantity used as a base for discount calculation if the discount is based on quantity. | |
emailed |
char |
Emailed | filters on the platform, writable, ::ancestor. |
Indicates if the document was emailed | |
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 |
double |
itgen_vnet_freeitemquantity | writable, free |
The quantity of the free item. Used to set the quantity for the order line generate by a free item discount | |
free |
varchar2 |
itgen_vnet_freeitem_description | writable, free |
The description | |
free |
varchar2 |
itgen_vnet_freeitem_id | writable, free |
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_ismanual | writable, is |
Indicates that the discount has been applied manually | |
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. |
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. | |
manual |
int32 |
itgen_vnet_manualorderindex | writable, manual |
The number of discount line set for the order | |
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 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 | |
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 |
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. |
Date the order was requested | |
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 |
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_ |
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 | |
skip |
char |
itgen_vnet_skipdiscount | writable, skip |
Indicates if the discount has been cancelled for the order and is not applicable | |
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 | |
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, type |
The type of discount whose sequence was applied to the document(Group or Document) | |
type_2 |
varchar2 |
itgen_vnet_type_2 | filters on the platform, writable, ::ancestor. |
The type code for the sales 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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: