invantive documentation
Invantive Support ForumsLog In / Sign Up

TransferOrderLineAttachmentsByTypeOrderId: Visma.net Financials itgen_vnet_transferorderlineattachmentsbytypeorderid_plural

read only REST

  • Catalog: NgSalesOrders
  • Schema: TransferOrders
  • Label: itgen_vnet_transferorderlineattachmentsbytypeorderid_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
orderId `` 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 TransferOrderLineAttachmentsByTypeOrderId 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_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
baseOrderQuantity double itgen_vnet_baseorderquantity writable, ::ancestor.baseOrderQuantity The base order quantity for this line
billing_address_city varchar2 itgen_vnet_billing_address_city filters on the platform, writable, ::ancestor.::ancestor.billing.address.city The city
billing_address_country_id varchar2 itgen_vnet_billing_address_country_id filters on the platform, writable, ::ancestor.::ancestor.billing.address.country.id The id
billing_address_country_name varchar2 itgen_vnet_billing_address_country_name filters on the platform, writable, ::ancestor.::ancestor.billing.address.country.name The name
billing_address_county_id varchar2 itgen_vnet_billing_address_county_id filters on the platform, writable, ::ancestor.::ancestor.billing.address.county.id The id
billing_address_county_name varchar2 itgen_vnet_billing_address_county_name filters on the platform, writable, ::ancestor.::ancestor.billing.address.county.name The name
billing_address_id int32 itgen_vnet_billing_address_id filters on the platform, writable, ::ancestor.::ancestor.billing.address.id The address id
billing_address_line1 varchar2 itgen_vnet_billing_address_line1 filters on the platform, writable, ::ancestor.::ancestor.billing.address.line1 Address line 1
billing_address_line2 varchar2 itgen_vnet_billing_address_line2 filters on the platform, writable, ::ancestor.::ancestor.billing.address.line2 Address line 2
billing_address_line3 varchar2 itgen_vnet_billing_address_line3 filters on the platform, writable, ::ancestor.::ancestor.billing.address.line3 Address line 3
billing_address_overridesDefault char itgen_vnet_billing_address_overridesdefault filters on the platform, writable, ::ancestor.::ancestor.billing.address.overridesDefault Whether this address overrides the default address
billing_address_postalCode varchar2 itgen_vnet_billing_address_postalcode filters on the platform, writable, ::ancestor.::ancestor.billing.address.postalCode The postal code
billing_contact_attention varchar2 itgen_vnet_billing_contact_attention filters on the platform, writable, ::ancestor.::ancestor.billing.contact.attention Any attention for the contact
billing_contact_email varchar2 itgen_vnet_billing_contact_email filters on the platform, writable, ::ancestor.::ancestor.billing.contact.email The e-mail address of the contact
billing_contact_fax varchar2 itgen_vnet_billing_contact_fax filters on the platform, writable, ::ancestor.::ancestor.billing.contact.fax The fax number of the contact
billing_contact_id int32 itgen_vnet_billing_contact_id filters on the platform, writable, ::ancestor.::ancestor.billing.contact.id The id of the contact
billing_contact_name varchar2 itgen_vnet_billing_contact_name filters on the platform, writable, ::ancestor.::ancestor.billing.contact.name The name of the contact
billing_contact_overridesDefault char itgen_vnet_billing_contact_overridesdefault filters on the platform, writable, ::ancestor.::ancestor.billing.contact.overridesDefault Whether this overrides the default contact
billing_contact_phone1 varchar2 itgen_vnet_billing_contact_phone1 filters on the platform, writable, ::ancestor.::ancestor.billing.contact.phone1 The phone number of the contact
billing_contact_phone2 varchar2 itgen_vnet_billing_contact_phone2 filters on the platform, writable, ::ancestor.::ancestor.billing.contact.phone2 The secondary phone number of the contact
branch_description varchar2 itgen_vnet_branch_description filters on the platform, writable, ::ancestor.::ancestor.branch.description The description
branch_id varchar2 itgen_vnet_branch_id filters on the platform, writable, ::ancestor.::ancestor.branch.id The id
cancelBy datetime Cancel by filters on the platform, writable, ::ancestor.::ancestor.cancelBy The cancel date for the order
comment varchar2 itgen_vnet_comment writable, comment Comment of the latest file revision
completed char Completed writable, ::ancestor.completed Whether the line is completed
createdBy varchar2 itgen_vnet_createdby writable, createdBy First and last name of the user who uploaded the file; null when the user is unknown
createdBy_2 varchar2 itgen_vnet_createdby_2 filters on the platform, writable, ::ancestor.::ancestor.createdBy 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.
creationTime datetime itgen_vnet_creationtime writable, creationTime Date and time the file was uploaded
currencyId varchar2 Currency ID filters on the platform, writable, ::ancestor.::ancestor.currencyId The currency of the order. Read only.
currencyRate double itgen_vnet_currencyrate filters on the platform, writable, ::ancestor.::ancestor.currencyRate The currency rate of the order. Read only.
customFields_customDateTimeUtc1 datetime itgen_vnet_customfields_customdatetimeutc1 writable, ::ancestor.customFields.customDateTimeUtc1 A free custom colum of type DateTime - in UTC timezone
customFields_customDateTimeUtc1_2 datetime itgen_vnet_customfields_customdatetimeutc1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customDateTimeUtc1 A free custom colum of type DateTime - in UTC timezone
customFields_customDec1 double itgen_vnet_customfields_customdec1 writable, ::ancestor.customFields.customDec1 A free custom colum of type decimal with max 4 decimals.
customFields_customDec1_2 double itgen_vnet_customfields_customdec1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customDec1 A free custom colum of type decimal with max 4 decimals.
customFields_customDec2 double itgen_vnet_customfields_customdec2 writable, ::ancestor.customFields.customDec2 A free custom colum of type decimal with max 4 decimals.
customFields_customDec2_2 double itgen_vnet_customfields_customdec2_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customDec2 A free custom colum of type decimal with max 4 decimals.
customFields_customInt1 int32 itgen_vnet_customfields_customint1 writable, ::ancestor.customFields.customInt1 A free custom colum of type int
customFields_customInt1_2 int32 itgen_vnet_customfields_customint1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customInt1 A free custom colum of type int
customFields_customInt2 int32 itgen_vnet_customfields_customint2 writable, ::ancestor.customFields.customInt2 A free custom colum of type int
customFields_customInt2_2 int32 itgen_vnet_customfields_customint2_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customInt2 A free custom colum of type int
customFields_customStr1 varchar2 itgen_vnet_customfields_customstr1 writable, ::ancestor.customFields.customStr1 A free custom colum of type string with max length 100.
customFields_customStr1_2 varchar2 itgen_vnet_customfields_customstr1_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr1 A free custom colum of type string with max length 100.
customFields_customStr2 varchar2 itgen_vnet_customfields_customstr2 writable, ::ancestor.customFields.customStr2 A free custom colum of type string with max length 100.
customFields_customStr2_2 varchar2 itgen_vnet_customfields_customstr2_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr2 A free custom colum of type string with max length 100.
customFields_customStr3 varchar2 itgen_vnet_customfields_customstr3 writable, ::ancestor.customFields.customStr3 A free custom colum of type string with max length 100.
customFields_customStr3_2 varchar2 itgen_vnet_customfields_customstr3_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr3 A free custom colum of type string with max length 100.
customFields_customStr4 varchar2 itgen_vnet_customfields_customstr4 writable, ::ancestor.customFields.customStr4 A free custom colum of type string with max length 100.
customFields_customStr4_2 varchar2 itgen_vnet_customfields_customstr4_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr4 A free custom colum of type string with max length 100.
customFields_customStr5 varchar2 itgen_vnet_customfields_customstr5 writable, ::ancestor.customFields.customStr5 A free custom colum of type string with max length 100.
customFields_customStr5_2 varchar2 itgen_vnet_customfields_customstr5_2 filters on the platform, writable, ::ancestor.::ancestor.customFields.customStr5 A free custom colum of type string with max length 100.
date datetime Date filters on the platform, writable, ::ancestor.::ancestor.date Date the order was submitted
description varchar2 Description writable, ::ancestor.description The description of the line
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.::ancestor.description Description of the order
destinationWarehouse_description varchar2 itgen_vnet_destinationwarehouse_description filters on the platform, writable, ::ancestor.::ancestor.destinationWarehouse.description The description
destinationWarehouse_id varchar2 itgen_vnet_destinationwarehouse_id filters on the platform, writable, ::ancestor.::ancestor.destinationWarehouse.id The id
externalLink varchar2 itgen_vnet_externallink writable, ::ancestor.externalLink An external link attached to the line
fileSize int32 itgen_vnet_filesize writable, fileSize Size of the latest file revision in kilobytes, rounded up
id guid ID writable, id
includeOnOrderEmail char itgen_vnet_includeonorderemail writable, includeOnOrderEmail Whether the attachment is included when the order is sent by email
inventoryAlternateId varchar2 itgen_vnet_inventoryalternateid writable, ::ancestor.inventoryAlternateId The alternate id of the inventory item
inventory_baseUnit varchar2 itgen_vnet_inventory_baseunit writable, ::ancestor.inventory.baseUnit
inventory_description varchar2 Inventory Description writable, ::ancestor.inventory.description The description
inventory_id varchar2 itgen_vnet_inventory_id writable, ::ancestor.inventory.id The id
lastModified datetime Last Modified filters on the platform, writable, ::ancestor.::ancestor.lastModified Date the order was last modified
lineId int32 Line Identifier writable, ::ancestor.lineId The line number of the transfer order line
lineType varchar2 Line Type writable, ::ancestor.lineType The type of transfer order line. A non-stock item is stored as a miscellaneous line.
name varchar2 Name writable, name
note varchar2 Note writable, ::ancestor.note Any notes on the line
note_2 varchar2 Note 2 filters on the platform, writable, ::ancestor.::ancestor.note Any notes on the order
openQuantity double itgen_vnet_openquantity writable, ::ancestor.openQuantity The quantity that is not shipped yet
operation varchar2 Operation writable, ::ancestor.operation The type of operation the line represents to the order
orderId varchar2 itgen_vnet_orderid filters on the platform, writable, ::ancestor.::ancestor.orderId The unique identifier of the order
orderQty double Order Quantity filters on the platform, writable, ::ancestor.::ancestor.orderQty The total quantity of inventory items in the order
overshipThreshold double itgen_vnet_overshipthreshold writable, ::ancestor.overshipThreshold The overship threshold value (%)
owner_id varchar2 Owner ID filters on the platform, writable, ::ancestor.::ancestor.owner.id The identifier of the employee
owner_internalId varchar2 Owner Internal ID filters on the platform, writable, ::ancestor.::ancestor.owner.internalId The internal unique identifier of the employee
purchaseOrderSource varchar2 itgen_vnet_purchaseordersource writable, ::ancestor.purchaseOrderSource The purchase order source of a line marked for purchase order: purchaseToOrder or dropShip
quantity double Quantity writable, ::ancestor.quantity The quantity of unit of measure this line represents
quantityOnShipments double itgen_vnet_quantityonshipments writable, ::ancestor.quantityOnShipments The quantity on shipments
reasonCode varchar2 Reason Code writable, ::ancestor.reasonCode The reason code of the line
requestDate datetime itgen_vnet_requestdate writable, ::ancestor.requestDate The date the line is requested
requestOn datetime Request On filters on the platform, writable, ::ancestor.::ancestor.requestOn Date the order was requested
revision int32 Revision writable, revision
salesAccountId varchar2 itgen_vnet_salesaccountid writable, ::ancestor.salesAccountId The sales account of the line
shipDate datetime itgen_vnet_shipdate writable, ::ancestor.shipDate The date the line is scheduled to ship
shippingRule varchar2 itgen_vnet_shippingrule writable, ::ancestor.shippingRule The shipping rule of the line
shipping_address_city varchar2 itgen_vnet_shipping_address_city filters on the platform, writable, ::ancestor.::ancestor.shipping.address.city The city
shipping_address_country_id varchar2 itgen_vnet_shipping_address_country_id filters on the platform, writable, ::ancestor.::ancestor.shipping.address.country.id The id
shipping_address_country_name varchar2 itgen_vnet_shipping_address_country_name filters on the platform, writable, ::ancestor.::ancestor.shipping.address.country.name The name
shipping_address_county_id varchar2 itgen_vnet_shipping_address_county_id filters on the platform, writable, ::ancestor.::ancestor.shipping.address.county.id The id
shipping_address_county_name varchar2 itgen_vnet_shipping_address_county_name filters on the platform, writable, ::ancestor.::ancestor.shipping.address.county.name The name
shipping_address_id int32 itgen_vnet_shipping_address_id filters on the platform, writable, ::ancestor.::ancestor.shipping.address.id The address id
shipping_address_line1 varchar2 itgen_vnet_shipping_address_line1 filters on the platform, writable, ::ancestor.::ancestor.shipping.address.line1 Address line 1
shipping_address_line2 varchar2 itgen_vnet_shipping_address_line2 filters on the platform, writable, ::ancestor.::ancestor.shipping.address.line2 Address line 2
shipping_address_line3 varchar2 itgen_vnet_shipping_address_line3 filters on the platform, writable, ::ancestor.::ancestor.shipping.address.line3 Address line 3
shipping_address_overridesDefault char itgen_vnet_shipping_address_overridesdefault filters on the platform, writable, ::ancestor.::ancestor.shipping.address.overridesDefault Whether this address overrides the default address
shipping_address_postalCode varchar2 itgen_vnet_shipping_address_postalcode filters on the platform, writable, ::ancestor.::ancestor.shipping.address.postalCode The postal code
shipping_contact_attention varchar2 itgen_vnet_shipping_contact_attention filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.attention Any attention for the contact
shipping_contact_email varchar2 itgen_vnet_shipping_contact_email filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.email The e-mail address of the contact
shipping_contact_fax varchar2 itgen_vnet_shipping_contact_fax filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.fax The fax number of the contact
shipping_contact_id int32 itgen_vnet_shipping_contact_id filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.id The id of the contact
shipping_contact_name varchar2 itgen_vnet_shipping_contact_name filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.name The name of the contact
shipping_contact_overridesDefault char itgen_vnet_shipping_contact_overridesdefault filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.overridesDefault Whether this overrides the default contact
shipping_contact_phone1 varchar2 itgen_vnet_shipping_contact_phone1 filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.phone1 The phone number of the contact
shipping_contact_phone2 varchar2 itgen_vnet_shipping_contact_phone2 filters on the platform, writable, ::ancestor.::ancestor.shipping.contact.phone2 The secondary phone number of the contact
shipping_fobPoint_description varchar2 itgen_vnet_shipping_fobpoint_description filters on the platform, writable, ::ancestor.::ancestor.shipping.fobPoint.description The description
shipping_fobPoint_id varchar2 itgen_vnet_shipping_fobpoint_id filters on the platform, writable, ::ancestor.::ancestor.shipping.fobPoint.id The id
shipping_insurance char itgen_vnet_shipping_insurance filters on the platform, writable, ::ancestor.::ancestor.shipping.insurance Whether insurance applies to this shipping
shipping_intrastatTransactionType_description varchar2 itgen_vnet_shipping_intrastattransactiontype_description filters on the platform, writable, ::ancestor.::ancestor.shipping.intrastatTransactionType.description The description
shipping_intrastatTransactionType_id int32 itgen_vnet_shipping_intrastattransactiontype_id filters on the platform, writable, ::ancestor.::ancestor.shipping.intrastatTransactionType.id The id
shipping_preferredWarehouse_description varchar2 itgen_vnet_shipping_preferredwarehouse_description filters on the platform, writable, ::ancestor.::ancestor.shipping.preferredWarehouse.description The description
shipping_preferredWarehouse_id varchar2 itgen_vnet_shipping_preferredwarehouse_id filters on the platform, writable, ::ancestor.::ancestor.shipping.preferredWarehouse.id The id
shipping_priority int32 itgen_vnet_shipping_priority filters on the platform, writable, ::ancestor.::ancestor.shipping.priority Priority of the order
shipping_residentialDelivery char itgen_vnet_shipping_residentialdelivery filters on the platform, writable, ::ancestor.::ancestor.shipping.residentialDelivery Whether this is residential delivery
shipping_rule varchar2 itgen_vnet_shipping_rule filters on the platform, writable, ::ancestor.::ancestor.shipping.rule The shipping rule
shipping_saturdayDelivery char itgen_vnet_shipping_saturdaydelivery filters on the platform, writable, ::ancestor.::ancestor.shipping.saturdayDelivery Whether this is a saturday delivery
shipping_scheduledDate datetime itgen_vnet_shipping_scheduleddate filters on the platform, writable, ::ancestor.::ancestor.shipping.scheduledDate The shipping scheduled date
shipping_shipSeparately char itgen_vnet_shipping_shipseparately filters on the platform, writable, ::ancestor.::ancestor.shipping.shipSeparately Whether this order can/is shipped separately
shipping_shipVia_description varchar2 itgen_vnet_shipping_shipvia_description filters on the platform, writable, ::ancestor.::ancestor.shipping.shipVia.description The description
shipping_shipVia_id varchar2 itgen_vnet_shipping_shipvia_id filters on the platform, writable, ::ancestor.::ancestor.shipping.shipVia.id The id
shipping_terms_description varchar2 itgen_vnet_shipping_terms_description filters on the platform, writable, ::ancestor.::ancestor.shipping.terms.description The description
shipping_terms_id varchar2 itgen_vnet_shipping_terms_id filters on the platform, writable, ::ancestor.::ancestor.shipping.terms.id The id
shipping_zone_description varchar2 itgen_vnet_shipping_zone_description filters on the platform, writable, ::ancestor.::ancestor.shipping.zone.description The description
shipping_zone_id varchar2 itgen_vnet_shipping_zone_id filters on the platform, writable, ::ancestor.::ancestor.shipping.zone.id The id
sortOrder int32 itgen_vnet_sortorder writable, ::ancestor.sortOrder Used to apply sort order to a set of lines
status_cancelled char itgen_vnet_status_cancelled filters on the platform, writable, ::ancestor.::ancestor.status.cancelled Whether this order is in a cancelled state
status_description varchar2 itgen_vnet_status_description filters on the platform, writable, ::ancestor.::ancestor.status.description The status name for the order
status_hold char itgen_vnet_status_hold filters on the platform, writable, ::ancestor.::ancestor.status.hold Whether this order is in a held state
subaccount varchar2 Sub Account writable The subaccount of the line, by segment The JSON text of the nested object.
supplier_currencyId varchar2 itgen_vnet_supplier_currencyid writable, ::ancestor.supplier.currencyId The currency of the supplier selected for the order line
supplier_id varchar2 itgen_vnet_supplier_id writable, ::ancestor.supplier.id The id of the supplier selected for the order line
supplier_name varchar2 Supplier Name writable, ::ancestor.supplier.name The name of the supplier selected for the order line
supplier_price double itgen_vnet_supplier_price writable, ::ancestor.supplier.price The supplier price of the supplier selected for the order line
supplier_unitOfMeasure varchar2 itgen_vnet_supplier_unitofmeasure writable, ::ancestor.supplier.unitOfMeasure The unit of measure used by the supplier for this line
type varchar2 Type filters on the platform, writable, ::ancestor.::ancestor.type The transfer order type code, TR or a custom order type derived from it
undershipThreshold double itgen_vnet_undershipthreshold writable, ::ancestor.undershipThreshold The undership threshold value (%)
unitOfMeasure varchar2 itgen_vnet_unitofmeasure writable, ::ancestor.unitOfMeasure The unit of measure (UOM) for the transfer order line
version blob itgen_vnet_version filters on the platform, writable, ::ancestor.::ancestor.version An internal order version used for detecting concurrent updates to an order
warehouseId varchar2 Warehouse ID writable, ::ancestor.warehouseId The source warehouse the goods are transferred from
warehouseLocation_description varchar2 itgen_vnet_warehouselocation_description writable, ::ancestor.warehouseLocation.description The description
warehouseLocation_id varchar2 itgen_vnet_warehouselocation_id writable, ::ancestor.warehouseLocation.id The id

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: