The database used by EMDI is Firebird SQL. Help on the SQL language used by firebird can be found at http://www.firebirdsql.org/refdocs.
You can also download the free firebird browser from the address https://sourceforge.net/projects/flamerobin/files/latest/download?source=files or DBeaver.

 

Some tables and their main fields:

Table “apouhkh”

Contains products and services.

“apouhkh”.”Aa” primary key
“apouhkh”.”Omada” connected with “omada”.”Aa” subcategory
“apouhkh”.”Monada” connected with “monades”.”Aa” main measurement unit
“apouhkh”.”Xrhsths” connected with “xrhstes”.”Aa” user id
“apouhkh”.”measureunit1″ connected with “monades”.”Aa” measurement unit 1
“apouhkh”.”measureunit2″ connected with “monades”.”Aa” measurement unit 2
“apouhkh”.”scale” [1,0] if there is a scale
“apouhkh”.”internet” [1,0] if is connected with e-shop or not
“apouhkh”.”active” [1,0] if it is active or not
“apouhkh”.”Shmeivseis” it contains notes of the product
“apouhkh”.”custom1″ custom field
“apouhkh”.”custom2″ custom field
“apouhkh”.”custom3″ custom field
“apouhkh”.”custom4″ custom field
“apouhkh”.”custom5″ custom field
“apouhkh”.”custom6″ custom field
“apouhkh”.”custom7″ custom field
“apouhkh”.”custom8″ custom field
“apouhkh”.”custom9″ custom field
“apouhkh”.”custom10″ custom field

Table “pvlhseis”

Contains sales. A complete sale consists of 1 row of table “pvlhseis” combined with 1 or more rows of the “grammes” table.

“pvlhseis”.”Aa” primary key
“pvlhseis”.”Parastatiko” connected with “eidhpar”.”Aa” document id
“pvlhseis”.”Kvdikospelath” connected with “pelates”.”Aa” main customer id
“pvlhseis”.”plhrvmh” connected with “diakanonismos”.”Aa” payment id
“pvlhseis”.”paradosh” connected with “pelates”.”Aa” second customer id
“pvlhseis”.”sxetika” connected with “pelates”.”Aa” related document id or third customer id
“pvlhseis”.”tropos” connected with “tropos”.”Aa” shipping method id
“pvlhseis”.”skopos” connected with “skopos”.”Aa” handling purpose id
“pvlhseis”.”xrhsths” connected with “xrhstes”.”Aa” user id
“pvlhseis”.”Schedulleid” connected with “rantevou”.”Aa” schedule id
“pvlhseis”.”custom” custom field
“pvlhseis”.”synolofpa_” total VAT
“pvlhseis”.”synolonpe_” total before discount
“pvlhseis”.”synolo_” total VAT excluded
“pvlhseis”.”synoloposothtas_” total quantity
“pvlhseis”.”ogkos_syn” total volume
“pvlhseis”.”embado_syn” total area
“pvlhseis”.”baros_syn” total weight
“pvlhseis”. “ajia_syn” total of additional batch
“pvlhseis”. “synolikopososto” total percentage proportionate rather than cumulative
“pvlhseis”. “loipes_” other charges total

 

 

Table “grammes”

It contains the sales lines.

“grammes”.”Aa” primary key
“grammes”.”Aapar” connected with “pvlhseis”.”Aa”
“grammes”.”Eidos” connected with “apouhkh”.”Aa” item id
“grammes”.”Monada” connected with “monada”.”Aa” measurement unit id
“grammes”.”Action” [0,1,2] shows the status of the item line in a document. It is used for delivery orders. When its value is “1”, the order has already been printed. When double click in order to reprint it becomes “0”.
“grammes”.”Type” [1,2] 1. Parent 2. Combined (Child)

Table “kinhseis”

Each line of the “grammes” can optionally be linked to 1 line of the “kinhseis” table containing the specific fields found in the Settings->Purchases/sales->Documents.

“kinhseis”.”Grammh” connected with “grammes”.”Aa”

Table “pelates”

Contains contacts, customers, suppliers.

“pelates”.”Aa” primary key (0 for the retail customer)
“pelates”.”Polh” connected with “poleis”.”Aa” city id
“pelates”.”Doy” connected with “doy”.”Aa” tax office id
“pelates”.”epaggelma” connected with “epaggelmata”.”Aa” occupation id
“pelates”.”troposplhrvmhs” connected with “diakanonismos”.”Aa” payment id
“pelates”.”taxob” [1,0] if he/she is obligated for the aggregated documents list

“pelates”.”foros” [0,1,2] if he/she is VAT obligated (normal, reduced, none)
“pelates”.”active” [1,0] if the customer is active or not

Table “rantevou”

Contains reminders and appointments.

“rantevou”.”Aa” primary key
“rantevou”.”Pelaths” connected with “pelates”.”Aa” customer id
“rantevou”.”Xrhsths” connected with “Xrhstes”.”Aa” user id
“rantevou”.”Ok” connected with “typosrantevou”.”Aa” calendar condition

Table “eidhpar”

It contains document types that exist. They can be found in Settings-> Documents.

“eidhpar”.”Aa” primary key
“eidhpar”.”tameio” connected with “tameio”.”Aa” cashier id
“eidhpar”.”xrevstiko” [0,1,2,3,4,5,6] connected with “naioxi”.”Apanthsh_xr”

0 Purchase/Import of goods
1 Sell/Export of goods
2 Receive money
3 Payment
4 None
5 Purchase/Without movement
6 Sell/Without movement

“eidhpar”.”emf_timwn” connected with “naioxi”.”apanthsh_ep”

0 No
1 Yes
2 Yes/Return
3 Only Tax

“eidhpar”.”eisagvgh” connected with “naioxi”.”apanthsh_m”
“eidhpar”.”ektypvsh” connected with “naioxi”.”apanthsh_ek”
“eidhpar”.”mefpa” connected with “naioxi”.”apanthsh_m”
“eidhpar”.”paradvsh” connected with “naioxi”.”apanthsh_p”
“eidhpar”.”troposplhrvmhs” connected with “diakanonismo”.”Aa” payment id
“eidhpar”.”shmansh” connected with “naioxi”.”apanthsh_m”
“eidhpar”.”seiriakh” connected with “naioxi”.”apanthsh_m”
“eidhpar”.”related_products” connected with “naioxi”.”apanthsh_rp”
“eidhpar”.”foros” connected with “naioxi”.”apanthsh_e”
“eidhpar”.”sygkentrvtikes” connected with “naioxi”.”apanthsh_t”