Execute SQL on sales after product selection

Each time a product is selected (while issuing a document), it is possible to execute SQL code.

This is set in Settings-> Purchase/Sales-> Documents-> SQL Run

After the user has selected a product, the variables sent by EMDI to the SQL code are:

:aa Document line number “pvlhseis”. “aa”
:cd Document type line number “eidhpar”. “aa”
:rd Related document “eidhpar”. “parallhlo”
:pd Parent document “eidhpar”. “Koino”
:cl Client line number “pelates”.”aa” or “pvlhseis”. “kvdikospelath”
:bl Delivery customer line number “pvlhseis”. “Delivery”
:as command line number “pvlhseis”. “assignor”
:re relevant Document line number “pvlhseis”. “Sxetiko”

:pi product line number “grammes”.”Eidos”
:li Document line number “grammes”. “aa”

: pc Item code “grammes”. ”KvdikosEidoys”
: pn Item description “grammes”. ”PerigrafhEidoys”
: pw Weight “grammes”. ”baros_”
: pp Position “grammes”. ”uesh_”
: pr Portion “grammes”. ” meridasx_ ”
: ps Verse“ grammes ”.” stixossx_ ”
: pe Start date“ grammes ”.” enarjh_ ”
: pl Expiry date“ grammes ”.” kinhseis_ ”
:pq product quantity “grammes”.”Posothta”

EMDI receives content from the variables and defines it accordingly:

im_expired -> expiration date “kinhseis”.”Lhjh”
im_position -> position “kinhseis”.”Uesh”
im_portion -> portion “grammes”.”meridasx_”
im_move -> move “grammes”.”stixossx_”
im_price -> Value excl. VAT   “grammes”.”Timh”
im_quantity -> Quantity “grammes”.”Posothta”
im_description -> Product description  “grammes”.”PerigrafhEidoys”
im_discount -> Discount rate “grammes”.”Ekptvsh”

im_message -> Opens an informational message
im_messagw -> Opens a warning message