Expenses (expense)

Expenses. Domain: Finance.


what	`expense`
Direction	Output (get), Input (put)
Endpoint	`POST https://login.directo.ee/xmlcore/cap_xml_direct/xmlcore.asp`
Schema (output)	ws_kulutused.xsd
Schema (input)	xml_IN_kulutused.xsd

Output (get)

XML field	SQL field	Type	Length	UI label	Description
`number`	number	int
`date`	aeg	dateTime
`expender`	kulutaja	string
`comment`	kommentaar	string
`source_id`	lisa_field1	string
`total`	summakokku	decimal
`expendername`	nimi	string
`user`	kasutaja	string
`transactiondate`	kande_aeg	dateTime
`confirmer`	kinnitaja	string
`currency`	valuuta	string
`currencyrate`	kurssbv1	decimal
`VAT`	kmkokku	decimal
`type`	tyyp	string
`object`	objekt	string
`project`	projekt	string
`asset`	inventar	string
`customer`	klient_kood	string
`customername`	klient_nimi	string
`status`	staatus	string
`datafield2`	lisa_field2	string
`datafield3`	lisa_field3	string
`datafield4`	lisa_field4	string
`datafield5`	lisa_field5	string
`datafield6`	lisa_field6	string
`datafield7`	lisa_field7	string
`start`	alates	dateTime
`end`	kuni	dateTime
`country`	asumaa	string
`city`	linn	string
`cu`	cu	string	32	Viimati muutis	document last changed by
`ts`	ts	dateTime			document last changed

XML field	SQL field	Type
`date`	aeg	dateTime
`documentnumber`	dokument	string
`supplier`	hankija_kood	string
`suppliername`	hankija_nimi	string
`account`	konto	string
`object`	objekt	string
`project`	projekt	string
`description`	selgitus	string
`currency`	r_valuuta	string
`currencyrate`	r_kurss	decimal
`qty`	kogus	decimal
`price`	hind	decimal
`total`	summa	decimal
`totalwithvat`	rskm	decimal
`vatcode`	kmkood	string
`type`	tyyp	string
`item`	artikkel	string
`VAT`	reakm	decimal
`route`	marsruut	string
`customer`	klient_kood	string
`customername`	klient_nimi	string
`mileage`	vahemaa	decimal
`purpose`	otstarve	string
`rn`	rn	int

Create: send the document. Modify: requires xd_update=1 and posting the whole document. Default values (ALT.FROM): Mandatory fields.

A confirmed document cannot be modified (response Type=14).
Confirmation can be controlled via the XML field confirm (in addition to xd_confirm).

Do not send:

Component-specific; add from the source wiki if this component has parameters.

docid = number of the created/updated document. Error codes: Responses and error codes.

<results>
  <Result Type="0" Desc="Created" docid="100001" doctype="EXPENSE" submit="Expenses"/>
</results>