Purchaseorders (purchaseorder)

Purchaseorders. Domain: Purchase.


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

Output (get)

Query (get)

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

XML field	SQL field	Type	Length	UI label	Description
`number`	number	int	9	Arve	document number/ID
`supplier`	hankija_kood	string
`payterm`	tingimus	string
`suppliername`	hankija_nimi	string
`country`	asumaa	string
`date`	aeg	dateTime
`comment`	kommentaar	string
`intcomment`	sisekommentaar	string
`order`	tellimus	int
`delivery`	lahetusaeg	dateTime
`delterm`	lahetustingimus	string
`stock`	ladu	string
`vatregion`	maa	int
`language`	keel	string
`status`	staatus	string
`type`	tyyp	string
`sum`	summa	decimal		Kokku
`total`	summakokku	decimal		Tasuda
`object`	objekt	string	255	Objekt
`project`	projekt	string	32	Projekt
`closed`	suletud	int	9	Suletud
`user`	kasutaja	string	32
`datafield1`	lisa_field1	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
`tolerance`	viga	int
`confirmed`	kinnitatud	int
`ts`	ts	dateTime			document last changed

Rows

XML field	SQL field	Type
`code`	kood	string
`unit`	yhik	string
`qty`	kogus	decimal
`name`	nimi	string
`arrivaltime`	saabumisaeg	dateTime
`comment`	r_kommentaar	string
`intcomment`	r_sisekommentaar	string
`constant1`	konstant1	decimal
`constant2`	konstant2	decimal
`constant3`	konstant3	decimal
`constant4`	konstant4	decimal
`project`	r_projekt	string
`oid`	oid	int
`price`	yhikuhind	decimal
`receivedqty1`	saadud1	decimal
`receivedqty2`	saadud2	decimal
`initialqty`	kogus_alg	decimal
`object`	r_objekt	string
`rn`	rn	int

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 can be modified only when xd_updateconfirmed=1; otherwise the response is 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	Ostutellimus	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
`supplier`	hankija_kood	string
`payterm`	tingimus	string
`suppliername`	hankija_nimi	string
`country`	asumaa	string
`date`	aeg	dateTime
`comment`	kommentaar	string
`intcomment`	sisekommentaar	string
`order`	tellimus	int
`receivedate`	lahetusaeg	dateTime
`deliveryterm`	lahetustingimus	string
`stock`	ladu	string
`vatregion`	maa	int
`language`	keel	string
`supplier_regno`	hankija_regnr1	string
`supplier_class`	hankija_klass	string
`user`	kasutaja	string
`type`	tyyp	string	50		Tüüp
`status`	staatus	string	50		Staatus
`datafield1`	lisa_field1	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
`address1`	aadress1	string	255		!
`address2`	aadress2	string	255		!
`address3`	aadress3	string	255		!
`stockaddress1`	laduaadress1	string	255		!
`stockaddress2`	laduaadress2	string	255		!
`stockaddress3`	laduaadress3	string	255		!
`phone`	telefon	string	100		Telefon
`tolerance`	viga	int
`delivermode`	lahetusviis	string	32		Lähetusviis
`origin`	piirkonnakood	string	32		Päritolu
`dealtype`	tehinguliik	string	2
`bankaccount`	pangakonto	string	50
`reference`	viide	string	32
`currency`	valuuta	string	32		Valuuta	ALT.FROM: supplier > glob.settings > 'EUR'
`object`	objekt	string	255
`project`	projekt	string	32
`fax`	faks	string	100
`email`	email	string	255
`closed`	suletud	int
`confirm`	kinnita	int

Do not send:

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

Rows

XML field	SQL field	Type
`code`	kood	string
`unit`	yhik	string
`price`	yhikuhind	decimal
`qty`	kogus	decimal
`name`	nimi	string
`receivedate`	saabumisaeg	dateTime
`comment`	r_kommentaar	string
`intcomment`	r_sisekommentaar	string
`constant1`	konstant1	decimal
`constant2`	konstant2	decimal
`constant3`	konstant3	decimal
`constant4`	konstant4	decimal
`tekst1`	tekst1	string
`tekst2`	tekst2	string
`tekst3`	tekst3	string
`tekst4`	tekst4	string
`project`	r_projekt	string
`stock`	r_ladu	string
`purchaseprice`	soetushind	string
`object`	r_objekt	string
`variant`	variant	string
`received1`	saadud1	decimal
`received2`	saadud2	decimal
`origin`	piirkonnakood	string
`rr`	rv	int
`rn`	rn	int

Transport parameters

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

TYPE	CODE	PARAMETER 1	PARAMETER 2	DESCRIPTION
XML	`xd_updateconfirmed`	1	PURCHASEORDER	Allow modifying a confirmed document

Response

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

<results>
  <Result Type="0" Desc="Created" docid="100001" doctype="PURCHASEORDER" submit="Purchaseorders"/>
</results>

Directo help

Table of Contents

Purchaseorders (purchaseorder)

Output (get)

Query (get)

Header

Rows

Input (put)

Header

Rows

Transport parameters

Response