Sisujuht

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)

Query (get)

Parameter Description
token interface token (required)
get 1
what expense
number optional filter
date1 period start
date2 period end
expender 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
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

Rows

XML field SQL field Type Length UI label Description
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

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
number number int
date aeg dateTime
expender kulutaja string
comment kommentaar string
datafield1 lisa_field1 string
total summakokku decimal
expenderidnumber kulutaja_isikukood string
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
account konto string
startmileage alg_nait decimal
endmileage lopp_nait decimal
language keel string
ordinance korraldus string
extid ext_id string
intcomment sisekommentaar string
confirm kinnita int “1” - confirm document

Do not send:

Rows

XML field SQL field Type Length Mandatory UI label Description
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
sumt summa_t decimal
resource ressurss int
irn a_rn int
start r_aeg1 dateTime
end r_aeg2 dateTime
rn rn int

Approvals

Standard block – see Common sub-blocks: approvals.

Transport parameters

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

Response

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>