Price formula rows. Domain: Sales.
| what | priceformularow |
|---|---|
| Direction | Output (get), Input (put) |
| Endpoint | POST https://login.directo.ee/xmlcore/cap_xml_direct/xmlcore.asp |
| Schema (output) | ws_hinnavalemid.xsd |
| Schema (input) | xml_IN_hinnavalemid.xsd |
| Parameter | Description |
|---|---|
token | interface token (required) |
get | 1 |
what | priceformularow |
class | optional filter |
code | optional filter |
type | optional filter |
barcode | optional filter |
supplier | optional filter |
supplieritem | optional filter |
closed | optional filter |
ts | changed-since (for syncing) |
| XML field | SQL field | Type | Length | UI label | Description |
|---|---|---|---|---|---|
code | kood | string | 32 | Kood | |
class | klass | string | 32 | Klass | |
item | artikkel | string | 32 | Artikkel | |
type | mida | int | 1 | Mõjub | |
decimalplaces | kohad | int | 1 | Kohta | |
discount | ale | decimal | ALE | ||
supplier | hankija | string | 32 | Hankija | |
project | projekt | string | 32 | (header) | |
date1 | aeg1 | dateTime | Aeg1 | ||
date2 | aeg2 | dateTime | Aeg2 | ||
rounding | ymardus | decimal | Korrektsioon | ||
discountqty | ale_kogus | decimal | Alates kogusest | ||
data | data | string | 32 | Art.lisaväli | |
datacontent | datasisu | string | 4000 | Sisu | |
uuid | row_id | int | Directo unique id for editing rows | ||
ts | ts | dateTime | document last changed |
xd_update=1 and posting the whole document. Default values (ALT.FROM): Mandatory fields.
Type=14).| XML field | SQL field | Type | Length | Mandatory | UI label | Description |
|---|---|---|---|---|---|---|
project | projekt | string | 32 | |||
code | kood | string | 32 | yes | Kood | 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 |
name | nimi | string | 255 | Nimi (header) | ||
text1 | tekst1 | string | 255 | |||
text2 | tekst2 | string | 255 | |||
currency | valuuta | string | ||||
object | objekt | string | ||||
order | so | int |
Do not send:
session_id – for internal use at Directo side, do not send this field!| XML field | SQL field | Type | Length | Mandatory | UI label | Description |
|---|---|---|---|---|---|---|
class | klass | string | 32 | Klass | ||
item | artikkel | string | 32 | Artikkel | ||
name | nimi | string | 255 | Nimi (row) | ||
type | mida | int | 1 | Mõjub | ||
decimalplaces | kohad | int | 1 | Kohta | ||
discount | ale | decimal | ALE | |||
supplier | hankija | string | 32 | Hankija | ||
data | data | string | 32 | Art.lisaväli | ||
datacontent | datasisu | string | 4000 | Sisu | ||
date1 | aeg1 | dateTime | Aeg1 | |||
date2 | aeg2 | dateTime | Aeg2 | |||
time1 | kell1 | time | Kell1 | |||
time2 | kell2 | time | Kell2 | |||
rounding | ymardus | decimal | Korrektsioon | |||
discountqty | ale_kogus | decimal | Alates kogusest | |||
recipe | retsept | string | 32 | |||
rowproject | r_projekt | string | 32 | |||
rowobject | r_objekt | string | 255 | |||
variant | variant | string | 32 | Variant | ||
rn | rn | int | Nr | row order number in document 1 - N ALT.FROM: random | ||
uuid | row_id | int | Directo unique id for editing rows |
Component-specific; add from the source wiki if this component has parameters.
docid = number of the created/updated document. Error codes: Responses and error codes.
<results> <Result Type="0" Desc="Created" docid="100001" doctype="PRICEFORMULAROW" submit="Price formula rows"/> </results>