Purchase invoices (purchase)

Purchase invoices. Domain: Purchase.


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

Output (get)

Query (get)

Parameter	Description
`token`	interface token (required)
`get`	1
`what`	purchase
`number`	optional filter
`date1`	period start
`date2`	period end
`supplier`	optional filter
`confirmed`	optional filter
`status`	optional filter
`ts`	changed-since (for syncing)

XML field	SQL field	Type	Length	UI label	Description
`number`	number	int	9	Number
`date`	aeg	dateTime		Kuupäev
`duedate`	tas_aeg	dateTime		Tas. aeg
`sum`	summa	decimal		Tasuda	sum with vat
`supplierinvoiceno`	hankija_arve	string	255	Hankija arve
`paymentterm`	tingimus	string	32	Tas. ting.
`supplier`	hankija_kood	string	32	Hankija
`suppliername`	hankija_nimi	string	255
`bankaccount`	pangakonto	string	50	Arveldusarve
`currency`	valuuta	string	32	Valuuta
`currencyrate`	kurssbv1	decimal		Kurss
`vatzone`	maa	int		KM Maa (peidetud väli)	local = 0, EU = 1, export = 2
`comment`	kommentaar	string	255	Kommentaar
`vat`	arvestatudkm	decimal		KM kokku
`object`	objekt	string	255	Objekt
`project`	projekt	string	32	Projekt
`datafield1`	lisa_field1	string	255
`datafield2`	lisa_field2	string	255
`datafield3`	lisa_field3	string	255
`datafield4`	lisa_field4	string	255
`datafield5`	lisa_field5	string	255
`datafield6`	lisa_field6	string	255
`datafield7`	lisa_field7	string	255
`intcomment`	sisekommentaar	string	255	Sisekommentaar
`confirmed`	kinnitatud	int		Olek
`ts`	ts	dateTime			document last changed

Rows

XML field	SQL field	Type	Length	UI label
`account`	konto	string	32	Konto
`object`	objekt	string	255	Objekt
`quantity`	kogus	decimal		Kogus
`name`	sisu	string	255	Sisu
`linetotalwovat`	summa	decimal		Summa
`vatcode`	kmkood	int		KMK
`project`	projekt	string	32	Projekt
`vatsum`	km	decimal		KM
`rn`	rn	int		Nr

Input (put)

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).

Header

XML field	SQL field	Type	Length	Mandatory	UI label	Description
`number`	number	int	9	yes	Number	document number/ID, mandatory; It must be unique for each document and remain same if more than one transaction of the same document is necessary
`date`	aeg	dateTime			Arve aeg	ALT.FROM: current time
`duedate`	tas_aeg	dateTime			Tas. aeg
`sum`	summa	decimal			Tasuda	sum with vat
`supplierinvoiceno`	hankija_arve	string	255		Hankija arve
`paymentterm`	tingimus	string	32		Tas. ting.	ALT.FROM: supplier
`suppliercode`	hankija_kood	string	32		Hankija
`suppliername`	hankija_nimi	string	255			ALT.FROM: supplier
`bankaccount`	pangakonto	string	50			UIArveldusarve¦¦ ALT.FROM: supplier
`reference`	viide	string	32		Viitenumber	ALT.FROM: supplier
`transactiontime`	kande_aeg	dateTime			Op. aeg
`creditaccount`	kred_konto	string	50		Kred. konto	ALT.FROM: supplier > glob.settings
`factoring`	arve_tasub	string	50		Arve tasub
`currency`	valuuta	string	32		Valuuta	ALT.FROM: glob.settings > 'EUR'
`currencyrate`	kurssbv1	decimal			Kurss	ALT.FROM: ECB current published rates
`vatzone`	maa	int			KM Maa (peidetud väli)	local = 0, EU = 1, export = 2 ALT.FROM: supplier > 0
`comment`	kommentaar	string	255		Kommentaar
`vat`	arvestatudkm	decimal			KM kokku
`object`	objekt	string	255		Objekt	ALT.FROM: supplier > tr.params
`bankcode`	pangakood	string	50		Pangakood
`creditpurchase`	kredost	int			Kred. ost
`purchaseorder`	ostutellimus	int			Ostutellimus
`project`	projekt	string	32		Projekt
`email`	email	string	255		meil	ALT.FROM: supplier
`stockreceipt`	sissetulek	int			Sissetulek
`country`	asumaa	string	2		Saatjariik	ALT.FROM: supplier
`prepayment`	ettemaks	decimal			Ettemaks
`status`	staatus	string	50		Staatus
`type`	tyyp	string	50		Tüüp
`dividedsum`	jagatav_summa	decimal			Jagatav summa
`vatdate`	km_aeg	dateTime			KM aeg	ALT.FROM: date > current time
`reclamation`	reklamatsioon	decimal			Reklamatsioon
`reclamationcomment`	rekl_selgitus	string	255		Rekl. selgitus
`asset`	inventar	string	32		Inventar
`datafield1`	lisa_field1	string	255
`datafield2`	lisa_field2	string	255
`datafield3`	lisa_field3	string	255
`datafield4`	lisa_field4	string	255
`datafield5`	lisa_field5	string	255
`datafield6`	lisa_field6	string	255
`datafield7`	lisa_field7	string	255
`intcomment`	sisekommentaar	string	255		Sisekommentaar
`supplier_class`	hankija_klass	string	50		Klass
`supplier_vatcountry`	hankija_maa_tasu	int			KM-maa	local = 0, EU = 1, export = 2 ALT.FROM: customer > 0
`supplier_regno`	hankija_regnr1	string	50		Reg nr 1
`supplier_vatregno`	hankija_kmregnr	string	32		Km reg nr
`supplier_type`	hankija_tyyp	string	9		Tüüp
`confirm`	kinnita	int			Olek	“1” - confirm document

Do not send:

session_id – for internal use at Directo side, do not send this field!

Rows

XML field	SQL field	Type	Length	UI label	Description
`account`	konto	string	32	Konto
`object`	objekt	string	255	Objekt	ALT.FROM: project
`name`	sisu	string	255	Sisu	ALT.FROM: account
`linetotalwovat`	summa	decimal		Summa
`vatcode`	kmkood	int		KMK	ALT.FROM: supplier > account > object
`project`	projekt	string	32	Projekt
`customer`	klient_kood	string	32	Klient
`item`	artikkel	string	32	Artikkel
`quantity`	kogus	decimal		Kogus
`date1`	r_aeg1	dateTime		Algus
`date2`	r_aeg2	dateTime		Lõpp
`contract`	leping	int		Leping
`user`	kasutaja	string	32	Kasutaja
`oid`	oid	int		OID
`orderrn`	trn	int
`asset`	r_inventar	string	32	Inventar
`price`	myygihind	decimal		Müügihind
`constant1`	konstant1	decimal
`constant2`	konstant2	decimal
`constant3`	konstant3	decimal
`constant4`	konstant4	decimal
`text1`	tekst1	string	32
`text2`	tekst2	string	32
`text3`	tekst3	string	32
`text4`	tekst4	string	32
`intcomment`	r_sisekommentaar	string	255	Sisekommentaar
`vatsum`	km	decimal		KM
`rn`	rn	int		Nr

Attachments

Standard block – see Common sub-blocks: attachments.

Transport parameters

Configured on the token (interface), not sent in xmldata. PARAMETER 2 = document type.

TYPE	CODE	PARAMETER 1	PARAMETER 2	DESCRIPTION
XML	`xd_autosupplier`	1	PURCHASE	Auto-create linked supplier
XML	`xd_update`	0	PURCHASE	Allow update when no linked documents
XML	`xd_object`	VEEB	PURCHASE	Default object if not sent
XML	`xd_confirm`	0	PURCHASE	Auto-confirm document; also via XML field confirm

Response

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

<results>
  <Result Type="0" Desc="Created" docid="100001" doctype="PURCHASE" submit="Purchase invoices"/>
</results>