TransferOrderByTypeOrderId: Visma.net Financials itgen_vnet_transferorderbytypeorderid_plural
read only REST
- Catalog:
NgSalesOrders - Schema:
TransferOrders - Label: itgen_vnet_transferorderbytypeorderid_plural
Gets information about a single transfer order A transfer order moves goods from the source warehouse of each line to the destination warehouse of the order. The API exposes no customer, prices, discounts or taxes for it. In storage the customer is the business account of the branch that owns the destination warehouse.
Sample request:
GET /transferorders/TR/000100?expand=lines
Can only retrieve data.
Summary
A transfer order moves goods from the source warehouse of each line to the destination warehouse of the order. The API exposes no customer, prices, discounts or taxes for it. In storage the customer is the business account of the branch that owns the destination warehouse.
Sample request:
GET /transferorders/TR/000100?expand=lines
API Source
- Endpoint:
/api/v3/TransferOrders/{type}/{orderId} - Operation:
get /api/v3/TransferOrders/{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 transfer order to get | ||
type |
`` | The transfer order type, TR or a custom order type derived from it |
Table Columns
The columns of the table TransferOrderByTypeOrderId 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, billing. |
The city | |
billing_ |
varchar2 |
itgen_vnet_billing_address_country_id | filters on the platform, writable, billing. |
The id | |
billing_ |
varchar2 |
itgen_vnet_billing_address_country_name | filters on the platform, writable, billing. |
The name | |
billing_ |
varchar2 |
itgen_vnet_billing_address_county_id | filters on the platform, writable, billing. |
The id | |
billing_ |
varchar2 |
itgen_vnet_billing_address_county_name | filters on the platform, writable, billing. |
The name | |
billing_ |
int32 |
itgen_vnet_billing_address_id | filters on the platform, writable, billing. |
The address id | |
billing_ |
varchar2 |
itgen_vnet_billing_address_line1 | filters on the platform, writable, billing. |
Address line 1 | |
billing_ |
varchar2 |
itgen_vnet_billing_address_line2 | filters on the platform, writable, billing. |
Address line 2 | |
billing_ |
varchar2 |
itgen_vnet_billing_address_line3 | filters on the platform, writable, billing. |
Address line 3 | |
billing_ |
char |
itgen_vnet_billing_address_overridesdefault | filters on the platform, writable, billing. |
Whether this address overrides the default address | |
billing_ |
varchar2 |
itgen_vnet_billing_address_postalcode | filters on the platform, writable, billing. |
The postal code | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_attention | filters on the platform, writable, billing. |
Any attention for the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_email | filters on the platform, writable, billing. |
The e-mail address of the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_fax | filters on the platform, writable, billing. |
The fax number of the contact | |
billing_ |
int32 |
itgen_vnet_billing_contact_id | filters on the platform, writable, billing. |
The id of the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_name | filters on the platform, writable, billing. |
The name of the contact | |
billing_ |
char |
itgen_vnet_billing_contact_overridesdefault | filters on the platform, writable, billing. |
Whether this overrides the default contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_phone1 | filters on the platform, writable, billing. |
The phone number of the contact | |
billing_ |
varchar2 |
itgen_vnet_billing_contact_phone2 | filters on the platform, writable, billing. |
The secondary phone number of the contact | |
branch_ |
varchar2 |
itgen_vnet_branch_description | filters on the platform, writable, branch. |
The description | |
branch_ |
varchar2 |
itgen_vnet_branch_id | filters on the platform, writable, branch. |
The id | |
cancel |
datetime |
Cancel by | filters on the platform, writable, cancel |
The cancel date for the order | |
created |
varchar2 |
itgen_vnet_createdby | filters on the platform, writable, created |
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, currency |
The currency of the order. Read only. | |
currency |
double |
itgen_vnet_currencyrate | filters on the platform, writable, currency |
The currency rate of the order. Read only. | |
custom |
datetime |
itgen_vnet_customfields_customdatetimeutc1 | filters on the platform, writable, custom |
A free custom colum of type DateTime - in UTC timezone | |
custom |
double |
itgen_vnet_customfields_customdec1 | filters on the platform, writable, custom |
A free custom colum of type decimal with max 4 decimals. | |
custom |
double |
itgen_vnet_customfields_customdec2 | filters on the platform, writable, custom |
A free custom colum of type decimal with max 4 decimals. | |
custom |
int32 |
itgen_vnet_customfields_customint1 | filters on the platform, writable, custom |
A free custom colum of type int | |
custom |
int32 |
itgen_vnet_customfields_customint2 | filters on the platform, writable, custom |
A free custom colum of type int | |
custom |
varchar2 |
itgen_vnet_customfields_customstr1 | filters on the platform, writable, custom |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr2 | filters on the platform, writable, custom |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr3 | filters on the platform, writable, custom |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr4 | filters on the platform, writable, custom |
A free custom colum of type string with max length 100. | |
custom |
varchar2 |
itgen_vnet_customfields_customstr5 | filters on the platform, writable, custom |
A free custom colum of type string with max length 100. | |
date |
datetime |
Date | filters on the platform, writable, date |
Date the order was submitted | |
description |
varchar2 |
Description | filters on the platform, writable, description |
Description of the order | |
destination |
varchar2 |
itgen_vnet_destinationwarehouse_description | filters on the platform, writable, destination |
The description | |
destination |
varchar2 |
itgen_vnet_destinationwarehouse_id | filters on the platform, writable, destination |
The id | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
Date the order was last modified | |
note |
varchar2 |
Note | filters on the platform, writable, note |
Any notes on the order | |
order |
varchar2 |
itgen_vnet_orderid | filters on the platform, writable, order |
The unique identifier of the order | |
order |
double |
Order Quantity | filters on the platform, writable, order |
The total quantity of inventory items in the order | |
owner_ |
varchar2 |
Owner ID | filters on the platform, writable, owner. |
The identifier of the employee | |
owner_ |
varchar2 |
Owner Internal ID | filters on the platform, writable, owner. |
The internal unique identifier of the employee | |
request |
datetime |
Request On | filters on the platform, writable, request |
Date the order was requested | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_city | filters on the platform, writable, shipping. |
The city | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_country_id | filters on the platform, writable, shipping. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_country_name | filters on the platform, writable, shipping. |
The name | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_county_id | filters on the platform, writable, shipping. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_county_name | filters on the platform, writable, shipping. |
The name | |
shipping_ |
int32 |
itgen_vnet_shipping_address_id | filters on the platform, writable, shipping. |
The address id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_line1 | filters on the platform, writable, shipping. |
Address line 1 | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_line2 | filters on the platform, writable, shipping. |
Address line 2 | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_line3 | filters on the platform, writable, shipping. |
Address line 3 | |
shipping_ |
char |
itgen_vnet_shipping_address_overridesdefault | filters on the platform, writable, shipping. |
Whether this address overrides the default address | |
shipping_ |
varchar2 |
itgen_vnet_shipping_address_postalcode | filters on the platform, writable, shipping. |
The postal code | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_attention | filters on the platform, writable, shipping. |
Any attention for the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_email | filters on the platform, writable, shipping. |
The e-mail address of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_fax | filters on the platform, writable, shipping. |
The fax number of the contact | |
shipping_ |
int32 |
itgen_vnet_shipping_contact_id | filters on the platform, writable, shipping. |
The id of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_name | filters on the platform, writable, shipping. |
The name of the contact | |
shipping_ |
char |
itgen_vnet_shipping_contact_overridesdefault | filters on the platform, writable, shipping. |
Whether this overrides the default contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_phone1 | filters on the platform, writable, shipping. |
The phone number of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_contact_phone2 | filters on the platform, writable, shipping. |
The secondary phone number of the contact | |
shipping_ |
varchar2 |
itgen_vnet_shipping_fobpoint_description | filters on the platform, writable, shipping. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_fobpoint_id | filters on the platform, writable, shipping. |
The id | |
shipping_ |
char |
itgen_vnet_shipping_insurance | filters on the platform, writable, shipping. |
Whether insurance applies to this shipping | |
shipping_ |
varchar2 |
itgen_vnet_shipping_intrastattransactiontype_description | filters on the platform, writable, shipping. |
The description | |
shipping_ |
int32 |
itgen_vnet_shipping_intrastattransactiontype_id | filters on the platform, writable, shipping. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_preferredwarehouse_description | filters on the platform, writable, shipping. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_preferredwarehouse_id | filters on the platform, writable, shipping. |
The id | |
shipping_ |
int32 |
itgen_vnet_shipping_priority | filters on the platform, writable, shipping. |
Priority of the order | |
shipping_ |
char |
itgen_vnet_shipping_residentialdelivery | filters on the platform, writable, shipping. |
Whether this is residential delivery | |
shipping_ |
varchar2 |
itgen_vnet_shipping_rule | filters on the platform, writable, shipping. |
The shipping rule | |
shipping_ |
char |
itgen_vnet_shipping_saturdaydelivery | filters on the platform, writable, shipping. |
Whether this is a saturday delivery | |
shipping_ |
datetime |
itgen_vnet_shipping_scheduleddate | filters on the platform, writable, shipping. |
The shipping scheduled date | |
shipping_ |
char |
itgen_vnet_shipping_shipseparately | filters on the platform, writable, shipping. |
Whether this order can/is shipped separately | |
shipping_ |
varchar2 |
itgen_vnet_shipping_shipvia_description | filters on the platform, writable, shipping. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_shipvia_id | filters on the platform, writable, shipping. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_terms_description | filters on the platform, writable, shipping. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_terms_id | filters on the platform, writable, shipping. |
The id | |
shipping_ |
varchar2 |
itgen_vnet_shipping_zone_description | filters on the platform, writable, shipping. |
The description | |
shipping_ |
varchar2 |
itgen_vnet_shipping_zone_id | filters on the platform, writable, shipping. |
The id | |
status_ |
char |
itgen_vnet_status_cancelled | filters on the platform, writable, status. |
Whether this order is in a cancelled state | |
status_ |
varchar2 |
itgen_vnet_status_description | filters on the platform, writable, status. |
The status name for the order | |
status_ |
char |
itgen_vnet_status_hold | filters on the platform, writable, status. |
Whether this order is in a held state | |
type |
varchar2 |
Type | filters on the platform, writable, type |
The transfer order type code, TR or a custom order type derived from it |
|
version |
blob |
itgen_vnet_version | filters on the platform, writable, version |
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: