Movements (movement)
Movements. Domain: Stock.
Output (get)
Query (get)
| Parameter | Description |
token | interface token (required) |
get | 1 |
what | movement |
number | optional filter |
fromstock | optional filter |
tostock | optional filter |
confirmed | optional filter |
ts | changed-since (for syncing) |
| XML field | SQL field | Type | Length | UI label | Description |
number | number | int | 9 | | 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 |
date | aeg | dateTime | | Aeg | |
fromstock | laost | string | 64 | Laost | |
tostock | lattu | string | 64 | Lattu | |
datafield1 | lisa_field1 | string | 255 | Lisaväli 1 | |
datafield2 | lisa_field2 | string | 255 | Lisaväli 2 | |
datafield3 | lisa_field3 | string | 255 | Lisaväli 3 | |
datafield4 | lisa_field4 | string | 255 | Lisaväli 4 | |
datafield5 | lisa_field5 | string | 255 | Lisaväli 5 | |
datafield6 | lisa_field6 | string | 255 | Lisaväli 6 | |
datafield7 | lisa_field7 | string | 255 | Lisaväli 7 | |
status | liik_staatus | string | 100 | Staatus | |
order | tellimus | int | 9 | Tell. nr. | |
productionorder | tootmistellimus | int | 9 | Tootmistellimus | |
customer | kl_kood | string | 64 | Klient | |
intcommetn | sisekommentaar | string | 510 | Sisekommentaar | |
comment | tekst | string | 510 | Tekst | |
type | liik_tyyp | string | 100 | 1 | Tüüp¦ |
deliverymethod | lahetusviis | string | 255 | Lähetusviis | |
duedate | kl_aeg | dateTime | | Tähtaeg | |
project | projekt | string | 64 | Projektist | |
user | kasutaja | string | | | |
toproject | projekti | string | 64 | Projekti | |
deliveryterm | lahetustingimus | string | 64 | Läh. ting. | |
contact | kl_kontakt | string | 510 | Kontaktisik | |
parentmovement | liikumine | int | | | |
stockorder | laotellimus | int | 9 | Laotellimus | |
confirmed | kinnitatud | int | | | “1” - confirm document |
ts | ts | dateTime | | | document last changed |
Rows
| XML field | SQL field | Type | Length | UI label | Description |
item | artikkel | string | 64 | Artikkel | |
qty | kogus | decimal | | Soovitud | |
receivedqty | kogus_saadud | decimal | | Saadud | |
serialnumber | seerianumber | string | 50 | SN/Mudel | |
fromshelf | r_riiulist | string | 64 | Riiulist | |
toshelf | r_riiulisse | string | 64 | Riiulisse | |
comment | kommentaar | string | 510 | Kommentaar | |
project | r_projekt | string | 64 | Projekt | |
variant | variant | string | 64 | | |
toproject | r_projekti | string | 64 | Projekti | |
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; It must be unique for each document and remain same if more than one transaction of the same document is necessary |
date | aeg | dateTime | | | Aeg | |
datafield1 | lisa_field1 | string | 255 | | Lisaväli 1 | |
datafield2 | lisa_field2 | string | 255 | | Lisaväli 2 | |
datafield3 | lisa_field3 | string | 255 | | Lisaväli 3 | |
datafield4 | lisa_field4 | string | 255 | | Lisaväli 4 | |
datafield5 | lisa_field5 | string | 255 | | Lisaväli 5 | |
datafield6 | lisa_field6 | string | 255 | | Lisaväli 6 | |
datafield7 | lisa_field7 | string | 255 | | Lisaväli 7 | |
status | staatus | string | 50 | | Staatus | |
fromstock | laost | string | 64 | | Laost | |
tostock | lattu | string | 64 | | Lattu | |
confirm | kinnita | int | | | | “1” - confirm document |
project | projekt | string | 64 | | Projekt | |
toproject | projekti | string | 64 | | Projekti | |
customer | kl_kood | string | 64 | | Klient | |
contact | kl_kontakt | string | 510 | | Kontaktisik | |
duedate | kl_aeg | dateTime | | | Tähtaeg | |
deliveryterm | lahetustingimus | string | 64 | | Läh. ting. | |
deliverymethod | lahetusviis | string | 64 | | Lähetusviis | |
order | tellimus | int | | | Tell. nr. | |
productionorder | tootmistellimus | int | | | Tootmistellimus | |
comment | tekst | string | 510 | | Tekst | |
type | liik_tyyp | string | 100 | | Tüüp | |
user | kasutaja | string | | | | |
parentmovement | liikumine | int | | | | |
stockorder | laotellimus | int | 9 | | Laotellimus | |
text1 | tekst1 | string | | | | |
text2 | tekst2 | string | | | | |
Do not send:
Rows
| XML field | SQL field | Type | Length | Mandatory | UI label | Description |
item | artikkel | string | 32 | | Artikkel | |
qty | kogus | decimal | | | Soovitud | |
receivedqty | kogus_saadud | decimal | | | Saadud | |
serialnumber | seerianumber | string | 50 | | SN/Mudel | |
variant | variant | string | 64 | | | |
fromshelf | r_riiulist | string | 64 | | Riiulist | |
toshelf | r_riiulisse | string | 64 | | Riiulisse | |
comment | kommentaar | string | 510 | | Kommentaar | |
project | r_projekt | string | 64 | | Projektist | |
toproject | r_projekti | string | 64 | | Projekti | |
rn | rn | int | | | Nr | row order number in document 1 - N |
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="MOVEMENT" submit="Movements"/>
</results>