Stockreceipts (stockreceipt)
Stockreceipts. Domain: Purchase.
Output (get)
Query (get)
| Parameter | Description |
token | interface token (required) |
get | 1 |
what | stockreceipt |
number | optional filter |
date1 | period start |
date2 | period end |
supplier | optional filter |
confirmed | optional filter |
status | optional filter |
stock | optional filter |
ts | changed-since (for syncing) |
| XML field | SQL field | Type | Length | UI label | Description |
number | number | int | 9 | Number | |
date | aeg | dateTime | | Kuupäev | |
supplier | hankija_kood | string | 32 | Hankija | |
suppliername | hankija_nimi | string | 255 | Hankija nimi | |
purchaseorder | number_ostutellimus | int | | O.TELLIMUS | |
stock | ladu | string | 50 | Ladu | |
text | tekst | string | 255 | | |
currency | valuuta | string | 32 | Valuuta | |
currencyrate | kurssbv1 | decimal | | Kurss | |
creditaccount | konto | string | 50 | Konto | |
object | objekt | string | 255 | Objekt | |
project | projekt | string | 32 | Projekt | |
supplierinvoice | hankija_arve | string | 50 | Hankija arve | |
country | asumaa | string | 2 | Sihtriik | |
dealtype | tehinguliik | string | 2 | Tehinguliik | |
deliverymode | lahetusviis | string | 32 | Lähetusviis | |
deliveryterm | lahetustingimus | string | 32 | Läh. ting. | |
paymentterm | tingimus | string | 32 | Tingimus | |
status | staatus | string | 50 | Staatus | |
type | tyyp | string | 50 | Tüüp | |
purchaseinvoicetime | aeg_oarve | dateTime | | Ostuarve 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 | |
user | kasutaja | string | 32 | Kasutaja | |
origin | piirkonnakood | string | 32 | | |
intcomment | sisekommentaar | string | 255 | Sisekommentaar | |
confirmed | kinnitatud | int | | | “1” - confirmed document |
cu | cu | string | 32 | Viimati muutis | document last changed by |
ts | ts | dateTime | | Salvestatud | document last changed |
Rows
| XML field | SQL field | Type | Length | UI label | Description |
item | artikkel | string | 255 | Artikkel | |
qty | kogus | decimal | | Kogus | |
content | sisu | string | 255 | Nimetus | |
price | yhikuhind | decimal | | Hind | |
purchaseprice | soetushind | decimal | | Soetushind | |
serialnumber | seerianumber | string | 50 | SN | |
stock | ladu | string | 255 | | |
bestbefore | parimenne | dateTime | | Parim enne | |
origin | piirkonnakood | string | 32 | | |
project | r_projekt | string | 32 | Projekt | |
object | r_objekt | string | 255 | Objekt | |
variant | variant | string | 32 | | |
comment | r_kommentaar | string | 255 | Kommentaar | |
intcomment | r_sisekommentaar | string | 255 | Sisekommentaar | |
purchaseorder | ostutellimus | int | | Ostut. nr. | |
shelf | riiul | string | 64 | Riiul | |
orn | trn | int | | | Ostutellimuse rea number |
rn | rn | int | | Nr | row order number in document 1 - N |
rr | rv | int | | Rv | |
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 | | 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 | | | Kuupäev | ALT.FROM: current time |
supplier | hankija_kood | string | 32 | | Hankija | |
suppliername | hankija_nimi | string | 255 | | Hankija nimi | ALT.FROM: supplier |
purchaseorder | number_ostutellimus | int | | | O.TELLIMUS | |
stock | ladu | string | 50 | | Ladu | ALT.FROM: tr:para, |
text | tekst | string | 255 | | | |
currency | valuuta | string | 32 | | Valuuta | ALT.FROM: glob.settings > 'EUR' |
currencyrate | kurssbv1 | decimal | | | Kurss | ALT.FROM: ECB current published rates |
creditaccount | konto | string | 50 | | Konto | ALT.FROM: supplier > glob.settings |
object | objekt | string | 255 | | Objekt | |
project | projekt | string | 32 | | Projekt | |
supplierinvoice | hankija_arve | string | 50 | | Hankija arve | |
country | asumaa | string | 2 | | Sihtriik | ALT.FROM: supplier |
dealtype | tehinguliik | string | 2 | | Tehinguliik | ALT.FROM: supplier |
deliverymode | lahetusviis | string | 32 | | Lähetusviis | ALT.FROM: supplier |
deliveryterm | lahetustingimus | string | 32 | | Läh. ting. | |
paymentterm | tingimus | string | 32 | | Tingimus | ALT.FROM: supplier |
status | staatus | string | 50 | | Staatus | |
type | tyyp | string | 50 | | Tüüp | |
purchaseinvoicetime | aeg_oarve | dateTime | | | Ostuarve 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 | |
user | kasutaja | string | 32 | | Kasutaja | ALT.FROM: 'XML' |
origin | piirkonnakood | string | 32 | | | |
intcomment | sisekommentaar | string | 255 | | Sisekommentaar | |
supplier_class | hankija_klass | string | 50 | | | |
supplier_vatcountry | hankija_maa_tasu | int | | | | local = 0, EU = 1, export = 2 ALT.FROM: customer > 0 |
supplier_regno | hankija_regnr1 | string | 50 | | | |
supplier_vatregno | hankija_kmregnr | string | 32 | | | |
supplier_email | hankija_email | string | 255 | | | |
confirm | kinnita | int | | | | “1” - confirm document |
Do not send:
Rows
| XML field | SQL field | Type | Length | Mandatory | UI label | Description |
item | artikkel | string | 32 | | Artikkel | |
qty | kogus | decimal | | | Kogus | |
content | sisu | string | 255 | | Nimetus | ALT.FROM: item |
price | yhikuhind | decimal | | | Hind | |
purchaseprice | soetushind | decimal | | | Soetushind | |
serialnumber | seerianumber | string | 50 | | SN | |
stock | ladu | string | 255 | | Ladu | |
bestbefore | parimenne | dateTime | | | Parim enne | |
origin | piirkonnakood | string | 32 | | | |
project | r_projekt | string | 32 | | Projekt | |
object | r_objekt | string | 255 | | Objekt | |
variant | variant | string | 32 | | | |
comment | r_kommentaar | string | 255 | | Kommentaar | |
intcomment | r_sisekommentaar | string | 255 | | Sisekommentaar | |
purchaseorder | ostutellimus | int | | | | Ostutellimuse number. Kui puudub võtab algselt dokumendilt |
shelf | riiul | string | 32 | | Riiul | |
transportcost | kulu_transport | decimal | | | Transpordikulu | |
addcost | kulu_lisa | decimal | | | Lisakulu | |
orn | trn | int | | | | Ostutellimuse reanumber. Kui puudub võtab algselt dokumendilt |
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_updateconfirmed | 1 | STOCKRECEIPT | Allow modifying a confirmed document |
Response
docid = number of the created/updated document. Error codes: Responses and error codes.
<results>
<Result Type="0" Desc="Created" docid="100001" doctype="STOCKRECEIPT" submit="Stockreceipts"/>
</results>