Fin transactions (transaction)
Fin transactions. Domain: Finance.
Output (get)
Query (get)
| Parameter | Description |
token | interface token (required) |
get | 1 |
what | transaction |
number | optional filter |
date1 | period start |
date2 | period end |
type | optional filter |
ts | changed-since (for syncing) |
| XML field | SQL field | Type | Length | UI label | Description |
number | number | int | 9 | Number | |
type | tyyp | string | 32 | Tüüp | |
date | aeg2 | dateTime | | Aeg | |
reference | viide | string | 32 | Viide | |
comment | seletus | string | 512 | Seletus | |
ts | aeg | dateTime | | | document last changed |
Rows
| XML field | SQL field | Type | Length | UI label | Description |
account | konto | string | 50 | Konto | |
object | objekt | string | 255 | Objekt | |
project | projekt | string | 32 | Projekt | |
description | sisu | string | 255 | Sisu | |
vatcode | kmkood | int | 2 | KM kood | |
currency | valuuta | string | 255 | Valuuta | |
debitamount | baas1deebet | decimal | | Deebet | |
creditamount | baas1kreedit | decimal | | Kreedit | |
date | r_aeg | dateTime | | Aeg | |
rn | rn | int | | Nr | row order number in document 1 - N |
Create: send the document.
Modify: requires
xd_update=1 and posting the
whole document. Default values (
ALT.FROM):
Mandatory fields.
| XML field | SQL field | Type | Length | Mandatory | UI label | Description |
number | number | int | 9 | yes | Number | document number/ID, mandatory; With combination of field “type” it must be unique for each document and remain same if more than one transaction of the same document is necessary |
date | aeg2 | dateTime | | | Aeg | |
reference | viide | string | 32 | | Viide | |
comment | seletus | string | 512 | | Seletus | |
type | tyyp | string | 512 | | Tüüp | ALT.: FIN |
Do not send:
Rows
| XML field | SQL field | Type | Length | Mandatory | UI label | Description |
account | konto | string | 50 | | Konto | |
object | objekt | string | 255 | | Objektid | |
description | sisu | string | 255 | | Sisu | ALT.FROM: account |
vatcode | kmkood | int | 2 | | KM kood | |
quantity | kogus | decimal | | | Kogus | |
debitamount | baas1deebet | decimal | | | Deebet | |
creditamount | baas1kreedit | decimal | | | Kreedit | |
currencydebit | valuutadeebet | decimal | | | Val. deebet | |
currencycredit | valuutakreedit | decimal | | | Val. kreedit | |
currencyrate | b1kursile | decimal | | | Kurss | ALT.FROM: ECB current published rates |
currency | valuuta | string | 255 | | Valuuta | ALT.FROM: glob.settings > 'EUR' |
date | r_aeg | dateTime | | | Aeg | |
supplier | hankija | string | 32 | | Hankija | |
customer | klient | string | 32 | | Klient | |
project | projekt | string | 32 | | Projekt | |
rn | rn | int | | | Nr | row order number in document 1 - N ALT.FROM: random |
Transport parameters
Configured on the token (interface), not sent in xmldata. PARAMETER 2 = document type.
| TYPE | CODE | PARAMETER 1 | PARAMETER 2 | DESCRIPTION |
| XML | xd_autoproject | 1 | TRANSACTION | 1 = auto-create project |
Response
docid = number of the created/updated document. Error codes: Responses and error codes.
<results>
<Result Type="0" Desc="Created" docid="100001" doctype="TRANSACTION" submit="Fin transactions"/>
</results>