Spis treści

Projects (project)

Projects. Domain: Project.

what project
Direction Output (get), Input (put)
Endpoint POST https://login.directo.ee/xmlcore/cap_xml_direct/xmlcore.asp
Schema (output) ws_projektid.xsd
Schema (input) xml_IN_projektid.xsd

Output (get)

Query (get)

Parameter Description
token interface token (required)
get 1
what project
code optional filter
customer optional filter
supplier optional filter
orderer optional filter
contract optional filter
closed optional filter
ts changed-since (for syncing)
XML field SQL field Type Length UI label Description
code kood string 32 Kood
name nimi string 255 Nimi
manager juht string 32 Juht
object objekt string 255 objekt
type proj_tyyp string 32 Tüüp
start aeg1 dateTime Algus
end aeg2 dateTime Lõpp
customer klient_kood string 32 Kliendi kood
orderer tellija_kood string 32 Tellija kood
status staatus string 32 Staatus
closed suletud int Suletud closed = 1, open = 0
cu cu string 32 Viimane muutja document last changed by
createdts aeg_loodud dateTime Kuupäev millal dokument loodi document created
ts ts dateTime Aeg millal dokumenti viimati muudeti document last changed

Input (put)

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

Header

XML field SQL field Type Length Mandatory UI label Description
code kood string 32 yes Kood 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
name nimi string 255 Nimi
manager juht string 32 Juht
members liikmed string 2000 Liikmed
start aeg1 dateTime Algus
end aeg2 dateTime Lõpp
currency valuuta string 32 Valuuta
master master string 32 Peaprojekt
customer klient_kood string 32 Kliendi kood ALT.FROM: using “customerregno”
customerregno klient_regnr string 50 Kliendi reg.nr
customername klient_nimi string 200 Kliendi nimi ALT.FROM: customer
customercontact kl_kontakt string 100 Kl.kontakt ALT.FROM: customer
customercontactphone kl_kontakt_telefon string 64 Kliendi telefon ALT.FROM: customer
customercontactemail kl_kontakt_email string 255 Kliendi e-mail ALT.FROM: customer
supplier hankija_kood string 32 Hankija kood ALT.FROM: using “supplierregno”
supplierregno hankija_regnr string 50 Hankija reg.nr
suppliername hankija_nimi string 200 Hankija nimi ALT.FROM: supplier
suppliercontact h_kontakt string 100 H.kontakt ALT.FROM: supplier
suppliercontactphone h_kontakt_telefon string 64 Hankija telefon ALT.FROM: supplier
suppliercontactemail h_kontakt_email string 255 Hankija email ALT.FROM: supplier
memo memo string 4000 Memo or infinite (slower)
memo2 memo2 string 4000 Memo2 or infinite (slower)
plannedprofit pl_kate decimal Plan.kate
url url string 255 Url
object objekt string 255 objekt
customerinventory kl_inventar string 32 Kl. inventar
type proj_tyyp string 32 Tüüp ALT.FROM: tr.params
address1 aadress1 string 255 Tänav ALT.FROM: customer
address2 aadress2 string 255 Indeks,linn ALT.FROM: customer
address3 aadress3 string 255 Maa ALT.FROM: customer
country asumaa string 32 Asumaa ALT.FROM: customer
county maakond string 32 Maakond ALT.FROM: customer
sraccount lskonto string 32 LS konto
contract leping int Leping
orderer tellija_kood string 32 Tellija kood
orderername tellija_nimi string 255 Tellija nimi ALT.FROM: orderer
orderercontact tl_kontakt string 100 Tl.kontakt ALT.FROM: orderer
orderercontactphone tl_kontakt_telefon string 64 Tellija telefon ALT.FROM: orderer
orderercontactemail tl_kontakt_email string 255 Tellija email ALT.FROM: orderer
ordereraddress1 tellija_aadress1 string 255 Tellija tänav ALT.FROM: orderer
ordereraddress2 tellija_aadress2 string 255 Tellija Indeks, linn ALT.FROM: orderer
ordereraddress3 tellija_aadress3 string 255 Tellija maa ALT.FROM: orderer
orderercountry tellija_asumaa string 32 Tellija asumaa ALT.FROM: orderer
orderercounty tellija_maakond string 32 Tellija maakond ALT.FROM: orderer
payterm tingimus string 32 Tas.ting ALT.FROM: customer
status staatus string 32 staatus ALT.FROM: tr.params
closed suletud int suletud closed = 1, open = 0
contractend garantii decimal Garantii%
worth maksumus decimal Maksumus
costbudget summa_kulud decimal Kulude eelarve
customer_vatregno klient_kmregnumber string 32 Kliendikaardil: Km reg nr
customer_vatzone klient_maa int Kliendikaardil: Maa local = 0, EU = 1, export = 2
customer_type klient_tyyp int 32 Kliendikaardil: Tüüp
customer_class klient_klass string 32 Kliendikaardil: Klass
customer_loyaltycard klient_kliendikaart string 100 Kliendikaardil: Kliendikaart

Do not send:

Rows

XML field SQL field Type Length Mandatory UI label Description
action tegevus string 255 Tegevus ALT.FROM: item
start algus dateTime Algus
manager juht string 32 Juht
workers tegijad string 100 Tegijad
comment kommentaar string 255 Kommentaar
Preliminiaryend oletatav_lopp dateTime Oletatav valmimisaeg
done valmis int Valmis
actualend tegelik_lopp dateTime Tegelik valmimisaeg
sum summa decimal Summa
plannedtime aeg_raha1 dateTime Planeeritud
actualtime aeg_raha2 dateTime Tegelik
points punktid decimal Punktid
after peale int Peale
event event int
object objekt string 255
item r_artikkel string 32
quotation pakkumine int
costs kulud decimal Kulud
worker teostaja string 100 Teostaja
budget eelarve int
amount rea_kogus decimal
invoice arve int
text1 tekst1 string 32
text2 tekst2 string 32
constant1 konstant1 decimal Konstant1
constant2 konstant2 decimal Konstant2
rn rn int Nr row order number in document 1 - N ALT.FROM: random

Extra fields

XML field SQL field Type Length Mandatory UI label Description
code kood string 32
content sisu string 2000 Sisu
param param string 64 Parameeter

Transport parameters

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

TYPE CODE PARAMETER 1 PARAMETER 2 DESCRIPTION
XML xd_status (staatus) PROJECT Default status

Response

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

<results>
  <Result Type="0" Desc="Created" docid="100001" doctype="PROJECT" submit="Projects"/>
</results>