Stock orders (stockorder)
Stock orders. Domain: Stock.
Output (get)
Query (get)
| Parameter | Description |
token | interface token (required) |
get | 1 |
what | stockorder |
number | optional filter |
fromstock | optional filter |
tostock | optional filter |
status | optional filter |
type | optional filter |
order | optional filter |
ts | changed-since (for syncing) |
| XML field | SQL field | Type | Length | UI label | Description |
number | number | int | 9 | 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 |
text | tekst | string | | | |
user | kasutaja | string | | | |
fromstock | laost | string | | | |
tostock | lattu | string | | | |
date | aeg | dateTime | | | |
project | projekt | string | | | |
toproject | projekti | string | | | |
fromobject | objektist | string | | | |
toobject | objekti | string | | | |
fromaccount | kontolt | string | | | |
toaccount | kontole | string | | | |
account | konto | string | | | |
status | staatus | string | | | |
lisa_field1 | lisa_field1 | string | | | |
lisa_field2 | lisa_field2 | string | | | |
lisa_field3 | lisa_field3 | string | | | |
lisa_field4 | lisa_field4 | string | | | |
lisa_field5 | lisa_field5 | string | | | |
lisa_field6 | lisa_field6 | string | | | |
lisa_field7 | lisa_field7 | string | | | |
deliverymode | lahetusviis | string | | | |
type | tyyp | string | | | |
order | tellimus | int | | | |
reqduedate | soov_tahtaeg | dateTime | | | |
ts | ts | dateTime | | | document last changed |
Rows
| XML field | SQL field | Type | Length | UI label | Description |
item | artikkel | string | | | |
qty | kogus | decimal | | | |
moved | liikunud | decimal | | | |
name | nimetus | string | | | |
sn | seerianumber | string | | | |
comment | kommentaar | string | | | |
variant | variant | string | | | |
fromstock | r_laost | string | | | |
constant1 | konstant1 | decimal | | | |
constant2 | konstant2 | decimal | | | |
constant3 | konstant3 | decimal | | | |
constant4 | konstant4 | decimal | | | |
text1 | tekst1 | string | | | |
text2 | tekst2 | string | | | |
text3 | tekst3 | string | | | |
text4 | tekst4 | string | | | |
rn | rn | int | | | |
rr | rv | int | | | |
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 | 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 |
text | tekst | string | | | | |
user | kasutaja | string | | | | |
fromstock | laost | string | | | | |
tostock | lattu | string | | | | |
date | aeg | dateTime | | | | |
project | projekt | string | | | | |
toproject | projekti | string | | | | |
fromobject | objektist | string | | | | |
toobject | objekti | string | | | | |
fromaccount | kontolt | string | | | | |
toaccount | kontole | string | | | | |
account | konto | string | | | | |
status | staatus | string | | | | |
lisa_field1 | lisa_field1 | string | | | | |
lisa_field2 | lisa_field2 | string | | | | |
lisa_field3 | lisa_field3 | string | | | | |
lisa_field4 | lisa_field4 | string | | | | |
lisa_field5 | lisa_field5 | string | | | | |
lisa_field6 | lisa_field6 | string | | | | |
lisa_field7 | lisa_field7 | string | | | | |
deliverymode | lahetusviis | string | | | | |
type | tyyp | string | | | | |
order | tellimus | int | | | | |
reqduedate | soov_tahtaeg | dateTime | | | | |
customer | kl_kood | string | 50 | | | |
customerdate | kl_aeg | dateTime | | | | |
customercontact | kl_kontakt | string | 255 | | | |
country | asumaa | string | 2 | | | |
dealtype | tehinguliik | string | 2 | | | |
text1 | tekst1 | string | 255 | | | |
text2 | tekst2 | string | 255 | | | |
intcomment | sisekommentaar | string | 255 | | | |
suletud | suletud | int | | | | |
Do not send:
Rows
| XML field | SQL field | Type | Length | Mandatory | UI label | Description |
item | artikkel | string | | | | |
qty | kogus | decimal | | | | |
moved | liikunud | decimal | | | | |
name | nimetus | string | | | | |
sn | seerianumber | string | | | | |
comment | kommentaar | string | | | | |
variant | variant | string | | | | |
fromstock | r_laost | string | | | | |
constant1 | konstant1 | decimal | | | | |
constant2 | konstant2 | decimal | | | | |
constant3 | konstant3 | decimal | | | | |
constant4 | konstant4 | decimal | | | | |
text1 | tekst1 | string | | | | |
text2 | tekst2 | string | | | | |
text3 | tekst3 | string | | | | |
text4 | tekst4 | string | | | | |
price | myygihind | decimal | | | | |
reqdelivery | soovitud_lahetusaeg | dateTime | | | | |
deliverytime | lahetusaeg | dateTime | | | | |
rn | rn | int | | | | |
rr | rv | int | | | | |
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="STOCKORDER" submit="Stock orders"/>
</results>