Import travel expense tripexpense.nv | Netvisor support pages

Resource: tripexpense.nv

HTTP-method: POST

Request:

Level	Element name	Type and length	Occurs	Description	Example
Root	root	Aggr.	1
1	tripexpense	Aggr	1
2	header	String	1	Header of the invoice	Trip expense
2	description	String	0...1	Free description for invoice
2	customlines	Aggr.	0...1
3	customline	Aggr.	1...n
4	employeeidentifier	String	1	Identifier of the employee, either number, finnish personal identifier or netvisorkey	140785-xxxx
Attr.	type	String	0...1	Type of identifier number or finnishpersonalidentifier	finnishpersonalidentifier
4	ratio	String	1	Type of Expense HTTP-header X-Netvisor-Interface-Language=FI affects to the name of ratio	Majoituskulut
Attr.	type	String	1	Type of identifier name	name
4	amount	Numeric	1	Amount of expense	1,00
4	customlineunitprice	Numeric	1	Unit price of the expense	150,00
Attr.	iso4217currencycode	String	0...1	Currency used	EUR
Attr.	currencyrate	Numeric	0...1	Currency exchange rate
4	vatpercentage	Numeric	0...1	VAT percentage	24
4	linedescription	String	1	Description of the line	Hotel bill
4	begindate	Date	1	Begin date	2018-10-05
4	enddate	Date	1	End date	2018-10-05
4	crmprocessidentifier	String	0...1	Identifier of a related CRM process
4	customeridentifier	String	0...1	Netvisor ID or customer code	NV#123456
Attr.	type	String	0...1	Type of identifier, netvisor or customer	customer
4	expenseaccountnumber	Numeric	0...1	Expense account number	1701
4	linestatus	String	0...1	Travel line status. Different statuses are open (unfinished), confirmed (acknowledged), contentsupervisiored (travel expense rows with factual verification performed), accepted (approved) and paid.	Paid
4	dimension	Aggr.	0...n
5	dimensionname	String	1	Dimension header. If the header can't be found in system, Netvisor will create it	Project
5	dimensionitem	String	1	Dimension item. If the item can't be found in system, Netvisor will create it	Payroll
Attr.	fatherid	Numeric	0...1
4	tripexpenseattachments	Aggr.	0...1
5	tripexpenseattachment	Aggr.	1...n
6	mimetype	String	1	MIME-Type of the attachment	Application/Pdf
6	attachmentdescription	String	1	Description	Description
6	filename	String	1	File name	Description.pdf
6	documentdata	String	1	Attachment data as Base64 encoded string	BwgHBgoICAgLCgoLDhg...
2	travellines	Aggr.	0...1
3	travelline	Aggr.	1...n
4	employeeidentifier	String	1	Identifier of the employee, either number or personal identification number	140785-xxyy
Attr.	type	String	0...1	type of identifier used, number or finnishpersonalidentifier	finnishpersonalidentifier
4	traveltype	String	1	Type of travel, allowed values: car, car_with_trailer, car_with_caravan, car_with_heavy_cargo, car_with_big_machinery, car_with_dog, car_travel_in_rough_terrain, motorboat_max_50hp, motorboat_over_50hp, snowmobile, atv, motorbike, moped, other, carbenefit	car
4	passengeramount	Numeric	1	Amount of passenger	1
4	kilometeramount	Numeric	1	Kilometers travelled	252,00
4	unitprice	Numeric	0...1	Price of a single unit, if not given will be retrieved from Netvisor based on mileage type.	5,50
4	linedescription	String	1	Description of the line
4	traveldate	Date	1	Date of travel	2014-10-03
4	routedescription	String	1	Description of the route
4	crmprocessidentifier	String	0...1	Identifier of related CRM process
4	customeridentifier	String	0...1	Identifier of customer, either id or number
Attr.	type	String	0...1	Type of identifier, netvisor or customer
4	linestatus	String	0...1	Travel line status. Different statuses are open (unfinished), confirmed (acknowledged), contentsupervisiored (travel expense rows with factual verification performed), accepted (approved) and paid.	Paid
4	dimension	Aggr.	0...n
5	dimensionname	String	1	Dimension header. If the header can't be found in system, Netvisor will create it	Project
5	dimensionitem	String	1	Dimension item. If the item can't be found in system, Netvisor will create it	Payroll
Attr.	fatherid	Numeric	0...1
4	tripexpenseattachments	Aggr.	0...1
5	tripexpenseattachment	Aggr.	1...n
6	mimetype	String	1	MIME type of the attachment	Application/pdf
6	attachmentdescription	String	1	Description
6	filename	String	1	File name
6	documentdata	String	1	Attachment as base64-encoded string
2	dailycompensationlines	Aggr.	0...1
3	dailycompensationline	Aggr.	1...n
4	employeeidentifier	String	1	Identifier of the employee, either number or personal identifier	140785-xxxx
Attr.	type	String	0...1	type of identifier, number tai finnishpersonalidentifier	finnishpersonalidentifier
4	compensationtype	String	1	Type of compensation, domesticfull, domestichalf tai foreign	domesticfull
4	amount	Numeric	1	Amount of compensation	1
4	unitprice	Numeric	0...1	Price of compensation, if not given, will be retrieved from Netvisor based on compensations's type	500,00
4	linedescription	String	1		Day in Helsinki
4	timeofdeparture	Date and time	1	Date of departure, must include time	2012-04-04 08:00:00.000
4	returntime	Date and time	1	Date of departure, must include time	2012-04-04 16:00:00.000
4	crmprocessidentifier	String	0...1		NV#123456
4	customeridentifier	String	0...1	Identifier of customer, either id or number
Attr.	type	String	0...1	Type if identifeir used, either netvisor tai customer	netvisor
4	linestatus	String	0...1	Travel line status. Different statuses are open (unfinished), confirmed (acknowledged), contentsupervisiored (travel expense rows with factual verification performed), accepted (approved) and paid.	Paid
4	dimension	Aggr.	0...n
5	dimensionname	String	1	Dimension header. If the header can't be found in system, Netvisor will create it	Project
5	dimensionitem	String	1	Dimension item. If thitem can't be found in system, Netvisor will create it	Payroll
Attr.	fatherid	Numeric	0...1
4	tripexpenseattachments	Aggr.	0...1
5	tripexpenseattachment	Aggr.	1...n
6	mimetype	String	1	MIME type of the attachment
6	attachmentdescription	String	1	Description
6	filename	String	1	File name
6	documentdata	String	1	Attachment as base64-encoded string