The database used by EMDI is Firebird SQL. Help on the SQL language used by Firebird is at http://www.firebirdsql.org/refdocs. You can also download a free Firebird editor from IBExpert or DBeaver.
Warning! Tables and fields must be enclosed in double quotation marks.
| Database tables | |||
| Table | Field | Description | Type |
| “pelates” | Contains contacts, customers, suppliers | ||
| “pelates” | “pelates”.”Aa” | Line ID | integer – Primary key |
| “pelates” | “pelates”.”Kvdikos” | Code/ID | varchar(30) |
| “pelates” | “pelates”.”Onoma” | Name | varchar(30) |
| “pelates” | “pelates”.”Epiueto” | Surname | varchar(40) |
| “pelates” | “pelates”.”Dieyuynsh” | Address | varchar(40) |
| “pelates” | “pelates”.”Perioxh” | Region | varchar(30) |
| “pelates” | “pelates”.”Tk” | Post code | varchar(10) |
| “pelates” | “pelates”.”Thlefvno” | Telephone | varchar(60) |
| “pelates” | “pelates”.”Kinhto” | Mobile | varchar(60) |
| “pelates” | “pelates”.”Fax” | Fax | varchar(60) |
| “pelates” | “pelates”.”Email” | varchar(100) | |
| “pelates” | “pelates”.”Url” | URL | varchar(50) |
| “pelates” | “pelates”.”Epvnymia” | Company | varchar(70) |
| “pelates” | “pelates”.”Afm” | VAT number | varchar(15) |
| “pelates” | “pelates”.”Doy” | Tax office, connected with “doy”.”Aa” | smallint |
| “pelates” | “pelates”.”Hmeromhnia” | Signup Date | date |
| “pelates” | “pelates”.”Eidosp” | Relation, connected with “sxeseis”.”Aa” | smallint |
| “pelates” | “pelates”.”custom1″ | Custom field 1 | varchar(30) |
| “pelates” | “pelates”.”custom2″ | Custom field 2 | varchar(30) |
| “pelates” | “pelates”.”custom3″ | Custom field 3 | varchar(30) |
| “pelates” | “pelates”.”custom4″ | Custom field 4 | varchar(30) |
| “pelates” | “pelates”.”custom5″ | Custom field 5 | varchar(30) |
| “pelates” | “pelates”.”custom6″ | Custom field 6 | varchar(30) |
| “pelates” | “pelates”.”custom7″ | Custom field 7 | varchar(30) |
| “pelates” | “pelates”.”custom8″ | Custom field 8 | varchar(30) |
| “pelates” | “pelates”.”custom9″ | Custom field 9 | varchar(30) |
| “pelates” | “pelates”.”custom10″ | Custom field 10 | varchar(30) |
| “pelates” | “pelates”.”custom11″ | Custom field 11 | varchar(30) |
| “pelates” | “pelates”.”custom12″ | Custom field 12 | varchar(30) |
| “pelates” | “pelates”.”custom13″ | Custom field 13 | varchar(30) |
| “pelates” | “pelates”.”custom14″ | Custom field 14 | varchar(30) |
| “pelates” | “pelates”.”custom15″ | Custom field 15 | varchar(30) |
| “pelates” | “pelates”.”custom16″ | Custom field 16 | varchar(30) |
| “pelates” | “pelates”.”custom17″ | Custom field 17 | varchar(30) |
| “pelates” | “pelates”.”custom18″ | Custom field 18 | varchar(30) |
| “pelates” | “pelates”.”custom19″ | Custom field 19 | varchar(30) |
| “pelates” | “pelates”.”custom20″ | Custom field 20 | varchar(30) |
| “pelates” | “pelates”.”Tu” | P.O. BOX / Floor | varchar(10) |
| “pelates” | “pelates”.”Polh” | City/County, connected with “poleis”.”Aa” | integer |
| “pelates” | “pelates”.”Kentriko” | Main customer or contact (Line ID), connected with “pelates”.”Aa” | integer |
| “pelates” | “pelates”.”Epaggelma” | Occupation (Line ID), connected with “epaggelmata”.”Aa” | smallint |
| “pelates” | “pelates”.”Xrhsths” | User associated with the client (Line ID), connected with “xrhstes”.”Aa” | smallint |
| “pelates” | “pelates”.”Shmeivseis” | Notes | memo |
| “pelates” | “pelates”.”Ypoloipo” | Balance | float |
| “pelates” | “pelates”.”Ekptvseis” | Price list (Line ID), connected with “ekptvseis”.”Aa” | smallint |
| “pelates” | “pelates”.”foros” | VAT liability, [0,1,2] if client is VAT obligated (normal, reduced, none) | smallint |
| “pelates” | “pelates”.”accountingnumber” | Accounting number | varchar(30) |
| “pelates” | “pelates”.”accountingcode” | Accounting code | smallint |
| “pelates” | “pelates”.”companynumber” | Company number | varchar(10) |
| “pelates” | “pelates”.”Orio” | Credit limit | float |
| “pelates” | “pelates”.”agores” | Purchases value | float |
| “pelates” | “pelates”.”pvlhseis” | Sales value | float |
| “pelates” | “pelates”.”troposplhrvmhs” | Payment method (Line ID), connected with “diakanonismos”.”Aa” | smallint |
| “pelates” | “pelates”.”modified” | Modification date | timestamp |
| “pelates” | “pelates”.”lastmove” | Last document | date |
| “pelates” | “pelates”.”taxob” | Tax obliged, [1,0] if client is obligated for the aggregated documents list | smallint |
| “pelates” | “pelates”.”active” | Status, [1,0] if the customer is active or not | smallint |
| “pelates” | “pelates”.”no_loyalties” | Reward Exemption, [1,0] | smallint |
| “pelates” | “pelates”.”latitude” | latitude | float |
| “pelates” | “pelates”.”longitude” | longitude | float |
| “pelates” | “pelates”.”At” | Branch number | varchar(20) |
| “pelates” | “pelates”.”Tmhma” | Police department | varchar(30) |
| “pelates” | “pelates”.”Ekdosh” | Issuance date | date |
| “doy” | Contains tax offices | ||
| “doy” | “doy”.”Aa” | Line ID | integer – Primary key |
| “doy” | “doy”.”kvdikos” | Tax office code | integer |
| “doy” | “doy”.”Titlos” | Tax Office title | varchar(85) |
| “doy” | “doy”.”modified” | Modification | timestamp |
| “apouhkh” | Contains products and services | ||
| “apouhkh” | “apouhkh”.”Kvdikos” | ID/Barcode | varchar(50) |
| “apouhkh” | “apouhkh”.”Perigrafh” | Description | varchar(100) |
| “apouhkh” | “apouhkh”.”fpaT” | VAT rate | float |
| “apouhkh” | “apouhkh”.”Lianikh” | Net price | float |
| “apouhkh” | “apouhkh”.”Hmeromhnia” | Price change | date |
| “apouhkh” | “apouhkh”.”Monada” | Measurement unit (Line ID), connected with “monades”.”Aa” | smallint |
| “apouhkh” | “apouhkh”.”Url” | URL | varchar(200) |
| “apouhkh” | “apouhkh”.”Shmeivseis” | Detailed description | memo |
| “apouhkh” | “apouhkh”.”Eggrafh” | Signup Date | date |
| “apouhkh” | “apouhkh”.”Fvtografia” | Photo | varchar(200) |
| “apouhkh” | “apouhkh”.”Omada” | Subcategory (Line ID), linked to “omades”.”Aa” | integer |
| “apouhkh” | “apouhkh”.”Aa” | Line ID | integer – Primary key |
| “apouhkh” | “apouhkh”.”Kvdikos_s” | Purchase ID | varchar(30) |
| “apouhkh” | “apouhkh”.”Diauesimothta” | Availibility | float |
| “apouhkh” | “apouhkh”.”Pvlhseis” | Sales | float |
| “apouhkh” | “apouhkh”.”Timh_s” | Net price | float |
| “apouhkh” | “apouhkh”.”Esoda” | Revenues | float |
| “apouhkh” | “apouhkh”.”Ejoda” | Expenses | float |
| “apouhkh” | “apouhkh”.”Y” | Height | float |
| “apouhkh” | “apouhkh”.”P” | Width | float |
| “apouhkh” | “apouhkh”.”B” | Depth | float |
| “apouhkh” | “apouhkh”.”Embado” | Area | float |
| “apouhkh” | “apouhkh”.”Ogkos” | Volume | float |
| “apouhkh” | “apouhkh”.”Baros” | Weight | float |
| “apouhkh” | “apouhkh”.”Xrhsths” | User (Line ID), connected with “xrhstes”.”Aa” | smallint |
| “apouhkh” | “apouhkh”.”posostokerdoys” | Profit rate | float |
| “apouhkh” | “apouhkh”.”posokerdoys” | Profit | float |
| “apouhkh” | “apouhkh”.”minquantity” | Minimum availability | float |
| “apouhkh” | “apouhkh”.”modified” | Modification | timestamp |
| “apouhkh” | “apouhkh”.”measureunit1″ | Measurement unit 2 (Line ID), connected with “monades”.”Aa” | smallint |
| “apouhkh” | “apouhkh”.”measureunit2″ | Measurement unit 3 (Line ID), connected with “monades”.”Aa” | smallint |
| “apouhkh” | “apouhkh”.”quantity1″ | Quantity of 2nd measurement unit | float |
| “apouhkh” | “apouhkh”.”quantity2″ | Quantity of 3rd measurement unit | float |
| “apouhkh” | “apouhkh”.”active” | Status, [1,0] if it is active or not | smallint |
| “apouhkh” | “apouhkh”.”scale” | Scale, [1,0] if there is a scale | smallint |
| “apouhkh” | “apouhkh”.”internet” | E-shop, [1,0] to connect to the eshop or not | smallint |
| “apouhkh” | “apouhkh”.”color” | Color | integer |
| “apouhkh” | “apouhkh”.”order” | Order | integer |
| “apouhkh” | “apouhkh”.”custom1″ | Custom field 1 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom2″ | Custom field 2 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom3″ | Custom field 3 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom4″ | Custom field 4 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom5″ | Custom field 5 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom6″ | Custom field 6 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom7″ | Custom field 7 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom8″ | Custom field 8 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom9″ | Custom field 9 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom10″ | Custom field 10 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom11″ | Custom field 11 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom12″ | Custom field 12 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom13″ | Custom field 13 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom14″ | Custom field 14 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom15″ | Custom field 15 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom16″ | Custom field 16 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom17″ | Custom field 17 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom18″ | Custom field 18 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom19″ | Custom field 19 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom20″ | Custom field 20 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom21″ | Custom field 21 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom22″ | Custom field 22 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom23″ | Custom field 23 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom24″ | Custom field 24 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom25″ | Custom field 25 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom26″ | Custom field 26 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom27″ | Custom field 27 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom28″ | Custom field 28 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom29″ | Custom field 29 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom30″ | Custom field 30 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom31″ | Custom field 31 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom32″ | Custom field 32 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom33″ | Custom field 33 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom34″ | Custom field 34 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom35″ | Custom field 35 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom36″ | Custom field 36 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom37″ | Custom field 37 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom38″ | Custom field 38 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom39″ | Custom field 39 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom40″ | Custom field 40 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom41″ | Custom field 41 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom42″ | Custom field 42 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom43″ | Custom field 43 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom44″ | Custom field 44 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom45″ | Custom field 45 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom46″ | Custom field 46 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom47″ | Custom field 47 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom48″ | Custom field 48 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom49″ | Custom field 49 | varchar(30) |
| “apouhkh” | “apouhkh”.”custom50″ | Custom field 50 | varchar(30) |
| “apouhkh” | “apouhkh”.”supplier” | Supplier (Line ID), linked to “pelates”.”Aa” | integer |
| “apouhkh” | “apouhkh”.”sync” | Sync, [0,1] | smallint |
| “apouhkh” | “apouhkh”.”taric” | Taric | varchar(10) |
| “fpa” | Contains taxes, VAT | ||
| “fpa” | “fpa”.”Aa” | Line ID | integer – Primary key |
| “fpa” | “fpa”.”title” | Description | varchar(50) |
| “fpa” | “fpa”.”Fpa” | VAT rate | float |
| “fpa” | “fpa”.”meivmeno” | Secondary VAT (Line ID), linked to “fpa”.”Aa” | integer |
| “fpa” | “fpa”.”tameio” | Cashier (Line ID), connected with “tameia”.”Aa” | integer |
| “fpa” | “fpa”.”accountingnumberin” | Sales accounting number | char(30) |
| “fpa” | “fpa”.”accountingnumberout” | Purchases accounting number | char(30) |
| “fpa” | “fpa”.”accountingnumberdocin” | Document sales accounting account | varchar(30) |
| “fpa” | “fpa”.”accountingnumberdocout” | Document purchases accounting account | varchar(30) |
| “fpa” | “fpa”.”modified” | Modification | timestamp |
| “fpa” | “fpa”.”tax_id” | Signing VAT Category | smallint |
| “fpa” | “fpa”.”tax_vat” | VAT category myDATA | smallint |
| “fpa” | “fpa”.”tax_type_revenues” | Revenue type myDATA | varchar(40) |
| “fpa” | “fpa”.”tax_type_expenses” | Expenses type myDATA | varchar(40) |
| “fpa” | “fpa”.”order” | Order | integer |
| “monades” | Contains the units of measurement of goods and services | ||
| “monades” | “monades”.”Aa” | Line ID | integer – Primary key |
| “monades” | “monades”.”Monades” | Measurement unit | varchar(15) |
| “monades” | “monades”.”quantity” | Quantity | float |
| “monades” | “monades”.”modified” | Modification | timestamp |
| “monades” | “monades”.”tax_unit” | myDATA unit of measurement | smallint |
| “pvlhseis” | Contains documents, sales and purchases. A complete sale consists of 1 row of table “pvlhseis” combined with 1 or more rows of the “grammes” table | ||
| “pvlhseis” | “pvlhseis”.”Seira” | Order | varchar(10) |
| “pvlhseis” | “pvlhseis”.”Ariumospar” | Doc.Num. | integer |
| “pvlhseis” | “pvlhseis”.”Hmeromhnia” | Date | timestamp |
| “pvlhseis” | “pvlhseis”.”Parastatiko” | Document type (Line ID), connected with “eidhpar”.”Aa” | smallint |
| “pvlhseis” | “pvlhseis”.”Kvdikospelath” | Customer Line ID, connected with “pelates”.”Aa” | integer |
| “pvlhseis” | “pvlhseis”.”Plhrvmh” | Payment (Line ID), connected with “diakanonismos”.”Aa” | smallint |
| “pvlhseis” | “pvlhseis”.”synolo_” | Total including VAT | float |
| “pvlhseis” | “pvlhseis”.”Sxetika” | Related Docs | varchar(100) |
| “pvlhseis” | “pvlhseis”.”Vra” | Time from | time |
| “pvlhseis” | “pvlhseis”.”Vrato” | Time to | time |
| “pvlhseis” | “pvlhseis”.”synolofpa_” | Total VAT excluded | float |
| “pvlhseis” | “pvlhseis”.”synoloposothtas_” | Total quantity | float |
| “pvlhseis” | “pvlhseis”.”Aa” | Document line ID | integer – Primary key |
| “pvlhseis” | “pvlhseis”.”Pinakida” | License plate | varchar(30) |
| “pvlhseis” | “pvlhseis”.”Paradosh” | Delivery Customer (Line ID), connected with “pelates”.”Aa” | integer |
| “pvlhseis” | “pvlhseis”.”Tropos” | Shipping method (Line ID), connected with “tropos”.”Aa” | smallint |
| “pvlhseis” | “pvlhseis”.”Skopos” | Handling purpose (Line ID), connected with “skopos”.”Aa” | smallint |
| “pvlhseis” | “pvlhseis”.”Sxolio” | Notes | varchar(400) |
| “pvlhseis” | “pvlhseis”.”Apostolh” | Shipping address | varchar(100) |
| “pvlhseis” | “pvlhseis”.”Fortvsh” | Loading place | varchar(100) |
| “pvlhseis” | “pvlhseis”.”Xrhsths” | User (Line ID), connected with “xrhstes”.”Aa” | smallint |
| “pvlhseis” | “pvlhseis”.”ogkos_syn” | Total volume of special fields, from “kinhseis”. “Ogkos” | float |
| “pvlhseis” | “pvlhseis”.”embado_syn” | Total area of special fields, from “kinhseis”. “Embado” | float |
| “pvlhseis” | “pvlhseis”.”baros_syn” | Total weight of special fields, from “kinhseis”. “Baros” | float |
| “pvlhseis” | “pvlhseis”.”ajia_syn” | Total value of special fields, from “kinhseis”. “Ajia” | float |
| “pvlhseis” | “pvlhseis”.”Sxetiko” | Related Doc. (Line ID), connected with “pvlhseis”.”Aa” | integer |
| “pvlhseis” | “pvlhseis”.”synolonpe_” | Total before discount | float |
| “pvlhseis” | “pvlhseis”.”ypografh” | Sign | varchar(400) |
| “pvlhseis” | “pvlhseis”.”synolikopososto” | Total percentage pro rata and not cumulative | float |
| “pvlhseis” | “pvlhseis”.”loipes_” | Total other fees | float |
| “pvlhseis” | “pvlhseis”.”modified” | Modification | timestamp |
| “pvlhseis” | “pvlhseis”.”scheduleid” | Appointment (Line ID), connected with “rantevou”.”Aa” | integer |
| “pvlhseis” | “pvlhseis”.”custom” | Custom field | varchar(100) |
| “pvlhseis” | “pvlhseis”.”deliverday” | Shipping date | date |
| “pvlhseis” | “pvlhseis”.”Payment” | Cash value. The first payment method connected with “pvlhseis”.”Plhrvmh”, and the title “diakanonismos”.”Perigrafh” | float |
| “pvlhseis” | “pvlhseis”.”Payment2″ | Amount paid with another method, e.g. card. The second payment method is linked to “pvlhseis”.”Plhrvmh2” and the title “diakanonismos”.”other_payment_title”. | float |
| “pvlhseis” | “pvlhseis”.”Plhrvmh2″ | Payment 2 (Line ID), linked to “diakanonismos”.”Aa” | smallint |
| “pvlhseis” | “pvlhseis”.”voucher” | Voucher | varchar(30) |
| “pvlhseis” | “pvlhseis”.”assignor” | Assignor (Line ID), connected with “pelates”.”Aa” | integer |
| “pvlhseis” | “pvlhseis”.”invoiceMark” | invoiceMark received after sending the document to myDATA | bigint |
| “pvlhseis” | “pvlhseis”.”custom1″ | Custom field 1 | varchar(30) |
| “pvlhseis” | “pvlhseis”.”custom2″ | Custom field 2 | varchar(30) |
| “pvlhseis” | “pvlhseis”.”custom3″ | Custom field 3 | varchar(30) |
| “pvlhseis” | “pvlhseis”.”custom4″ | Custom field 4 | varchar(30) |
| “pvlhseis” | “pvlhseis”.”custom5″ | Custom field 5 | varchar(30) |
| “pvlhseis” | “pvlhseis”.”b2g” | If blank, simple document. Contains the fields related to the issuance to the Government separated by “;” buyer Identifier;contract Reference;project Reference;Item Classification Identifier The Item Classification Identifier field if it contains more than 1 attributes is separated by a comma. | varchar(100) |
| “pvlhseis” | “pvlhseis”.”devicessentlist” | List of devices the documents were sent to | varchar(60) |
| “epaggelmata” | Contains occupations | ||
| “epaggelmata” | “epaggelmata”.”Aa” | Line ID | integer – Primary key |
| “epaggelmata” | “epaggelmata”.”Epaggelmata” | Occupation title | varchar(50) |
| “epaggelmata” | “epaggelmata”.”modified” | Modification | timestamp |
| “sxeseis” | Contains customer relationships/types | ||
| “sxeseis” | “sxeseis”.”Aa” | Line ID | integer – Primary key |
| “sxeseis” | “sxeseis”.”Perigrafh” | Relationship title | varchar(30) |
| “sxeseis” | “sxeseis”.”accountingcode” | Accounting code | smallint |
| “sxeseis” | “sxeseis”.”accountingnumber” | Accounting number | char(30) |
| “sxeseis” | “sxeseis”.”modified” | Modification | timestamp |
| “sxeseis” | “sxeseis”.”readonly” | Read-only, [0,1] refers to customers belonging to this relationship | smallint |
| “eidhpar” | It contains document types that exist. They can be found in Settings-> Documents | ||
| “eidhpar” | “eidhpar”.”Aa” | Line ID | integer – Primary key |
| “eidhpar” | “eidhpar”.”Koino” | Parent (Line ID) | integer |
| “eidhpar” | “eidhpar”.”parallhlo” | Related Doc. (Line ID) | integer |
| “eidhpar” | “eidhpar”.”Parastatiko” | Title | varchar(50) |
| “eidhpar” | “eidhpar”.”Seira” | Prefix | varchar(5) |
| “eidhpar” | “eidhpar”.”Ariumos” | Latest document | integer |
| “eidhpar” | “eidhpar”.”Tameio” | Cash register (Line ID), linked to “tameia”.”Aa” | smallint |
| “eidhpar” | “eidhpar”.”Xrevstiko” | Action (Line ID), [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 | smallint |
| “eidhpar” | “eidhpar”.”Emf_timvn” | Price view (Line ID), connected with “naioxi”.”apanthsh_ep” 0 No 1 Yes 2 Yes/Return 3 Only Tax | smallint |
| “eidhpar” | “eidhpar”.”Eisagvgh” | Change the day (Line ID), connected with “naioxi”.”apanthsh_m” | smallint |
| “eidhpar” | “eidhpar”.”Ektypwsh” | Print (Line ID), connected with “naioxi”.”apanthsh_ek” | smallint |
| “eidhpar” | “eidhpar”.”Kvdikosparastatikou” | Item ID/Barcode automatically set in a new document. For many we separate by comma, link with “apouhkh”.”Kvdikos” | char(50) |
| “eidhpar” | “eidhpar”.”recipienttitles” | Recipients titles | varchar(35) |
| “eidhpar” | “eidhpar”.”Mefpa” | Focus on lines (Line ID), connected with “naioxi”.”apanthsh_m” | smallint |
| “eidhpar” | “eidhpar”.”Paradosh” | Recipients (Line ID), connected with “naioxi”.”apanthsh_p” | smallint |
| “eidhpar” | “eidhpar”.”Antigrafa” | Copies | smallint |
| “eidhpar” | “eidhpar”.”doccopytitles” | Titles of copies | varchar(40) |
| “eidhpar” | “eidhpar”.”Ektypvths” | Printer | varchar(100) |
| “eidhpar” | “eidhpar”.”Arxeio” | Form | varchar(100) |
| “eidhpar” | “eidhpar”.”troposplhrvmhs” | Payment method (Line ID), linked to “diakanonismos”.”Aa” | integer |
| “eidhpar” | “eidhpar”.”shmansh” | Digital signage (Line ID), connected with “naioxi”.”apanthsh_m” | smallint |
| “eidhpar” | “eidhpar”.”tax_id” | Signage document number | smallint |
| “eidhpar” | “eidhpar”.”foros” | Amount deductible (Line ID), connected with “naioxi”.”apanthsh_e” | smallint |
| “eidhpar” | “eidhpar”.”seiriakoi” | Serial numbers (Line ID), connected with “naioxi”.”apanthsh_m” | smallint |
| “eidhpar” | “eidhpar”.”lhjeis” | Special fields (binary) ,check_bit_at_position(“eidhpar”. “lhjeis”,1) “Measurement unit 3” ,check_bit_at_position(“eidhpar”. “lhjeis”,2) “Measurement unit 2” ,check_bit_at_position(“eidhpar”. “lhjeis”,3) “Quantities total” ,check_bit_at_position(“eidhpar”. “lhjeis”,4) “Weight” ,check_bit_at_position(“eidhpar”. “lhjeis”,5) “Area” ,check_bit_at_position(“eidhpar”. “lhjeis”,6) “Volume” ,check_bit_at_position(“eidhpar”. “lhjeis”,7) “Value” ,check_bit_at_position(“eidhpar”. “lhjeis”,8) “Move” ,check_bit_at_position(“eidhpar”. “lhjeis”,9) “Portion” ,check_bit_at_position(“eidhpar”. “lhjeis”,10) “Position” ,check_bit_at_position(“eidhpar”. “lhjeis”,11) “Expiration” ,check_bit_at_position(“eidhpar”. “lhjeis”,12) “Start” | smallint |
| “eidhpar” | “eidhpar”.”specialfieldstitles” | Special fields titles | varchar(100) |
| “eidhpar” | “eidhpar”.”accountingcode” | Accounting code | char(3) |
| “eidhpar” | “eidhpar”.”accountingnumber” | Accounting number | char(30) |
| “eidhpar” | “eidhpar”.”sygkentrvtikes” | Aggregated (Line ID), connected with “naioxi”.”apanthsh_t” | smallint |
| “eidhpar” | “eidhpar”.”timokatalogos” | Price list | varchar(15) |
| “eidhpar” | “eidhpar”.”related_products” | Combinations of products/services (Line ID), connected with “naioxi”.”apanthsh_rp” | smallint |
| “eidhpar” | “eidhpar”.”emptyexpirationtext” | If expiration <2001 | varchar(30) |
| “eidhpar” | “eidhpar”.”customsql” | run SQL | memo |
| “eidhpar” | “eidhpar”.”custom_fields_included” | Custom fields included | varchar(50) |
| “eidhpar” | “eidhpar”.”order” | Order | integer |
| “eidhpar” | “eidhpar”.”einvoicing” | Other (binary) ,check_bit_at_position(“eidhpar”.”einvoicing”,1) “e-invoicing” ,check_bit_at_position(“eidhpar”.”einvoicing”,2) “Delivery note” ,check_bit_at_position(“eidhpar”.”einvoicing”,3) “VAT Suspension” | smallint |
| “eidhpar” | “eidhpar”.”tax_docs” | Document myDATA | varchar(12) |
| “eidhpar” | “eidhpar”.”tax_category” | Category myDATA | varchar(12) |
| “eidhpar” | “eidhpar”.”tax_type” | Type myDATA | varchar(10) |
| “eidhpar” | “eidhpar”.”shipping” | Purpose of shipping/handling | integer |
| “eidhpar” | “eidhpar”.”handling” | Method of shipping/handling | integer |
| “diakanonismos” | Contains the payment methods | ||
| “diakanonismos” | “diakanonismos”.”Aa” | Line ID | integer – Primary key |
| “diakanonismos” | “diakanonismos”.”Perigrafh” | Title | varchar(30) |
| “diakanonismos” | “diakanonismos”.”other_payment_title” | Title of additional payment method, connected with “diakanonismos”. “Perigrafh” | varchar(30) |
| “diakanonismos” | “diakanonismos”.”Ejoflhuh” | Paid, [0,1] refers to the documents and whether or not their value is due | smallint |
| “diakanonismos” | “diakanonismos”.”order” | Order | smallint |
| “diakanonismos” | “diakanonismos”.”accountingcode” | Accounting code | varchar(3) |
| “diakanonismos” | “diakanonismos”.”accountingnumber” | Accounting number | varchar(30) |
| “diakanonismos” | “diakanonismos”.”days_notify” | Waiting days | smallint |
| “diakanonismos” | “diakanonismos”.”tax_payment” | Payment myDATA | smallint |
| “diakanonismos” | “diakanonismos”.”tameio” | Cash register code | integer |
| “tameia” | Contains the cashiers/positions. Each cashier/position includes document types from table “eidhpar” | ||
| “tameia” | “tameia”.”Aa” | Line ID | integer – Primary key |
| “tameia” | “tameia”.”Tameio” | Cashier title | varchar(30) |
| “tameia” | “tameia”.”sxetiko” | Related cashier/position (Line ID), connected with “tameia”.”Aa” | integer |
| “tameia” | “tameia”.”ekdosh” | Issuance [0,1] | smallint |
| “tameia” | “tameia”.”order” | Order | smallint |
| “grammes” | It contains the lines of the documents like sales, purchases etc | ||
| “grammes” | “grammes”.”Posothta” | Quantity | float |
| “grammes” | “grammes”.”Timh” | Net unit price | float |
| “grammes” | “grammes”.”fpa_” | VAT rate | float |
| “grammes” | “grammes”.”Ekptvsh” | Discount rate | float |
| “grammes” | “grammes”.”Eidos” | Item (Line ID), connected with “apouhkh”.”Aa” | integer |
| “grammes” | “grammes”.”Aapar” | Document (Line ID), connected with “pvlhseis”.”Aa” | integer |
| “grammes” | “grammes”.”Monada” | Measurement unit (Line ID), linked to “monades”.”Aa” | smallint |
| “grammes” | “grammes”.”monada_” | Measurement unit (stored name) | varchar(15) |
| “grammes” | “grammes”.”PerigrafhEidoys” | Description | varchar(100) |
| “grammes” | “grammes”.”KvdikosEidoys” | ID/Barcode | varchar(50) |
| “grammes” | “grammes”.”Aa” | (Line ID) | integer – Primary key |
| “grammes” | “grammes”.”order” | Order | integer |
| “grammes” | “grammes”.”action” | Action, [0,1,2] Shows the status of the item line in a document. It is used for delivery orders. 1 The order has already been printed. 0 When double click in order to reprint | smallint |
| “grammes” | “grammes”.”type” | Type, [1,2] 1 Parent 2 Combined (Child) | smallint |
| “grammes” | “grammes”.”related” | Related line | integer |
| “seiriakoi” | Contains the serial numbers of the products | ||
| “seiriakoi” | “seiriakoi”.”Eidos” | Item (Line ID) | integer |
| “seiriakoi” | “seiriakoi”.”Grammh” | Document line (Line ID), connected with “grammes”.”Aa” | integer |
| “seiriakoi” | “seiriakoi”.”Serial” | Serial | varchar(20) |
| “seiriakoi” | “seiriakoi”.”Kinhsh” | Action (Line ID), [0,1] 0 Purchase 1 Sale, connected with “eidhpar”.”Xrevstiko” | smallint |
| “seiriakoi” | “seiriakoi”.”Aa” | Line ID | integer – Primary key |
| “rantevou” | Contains reminders and appointments | ||
| “rantevou” | “rantevou”.”Hmeromhnia” | Date | timestamp |
| “rantevou” | “rantevou”.”Ews” | to | timestamp |
| “rantevou” | “rantevou”.”Sxolio” | Notes | memo |
| “rantevou” | “rantevou”.”Pelaths” | Customer (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”Aa” | Line ID | integer – Primary key |
| “rantevou” | “rantevou”.”Alarm” | Reminder | timestamp |
| “rantevou” | “rantevou”.”Ok” | Appointment type (Line ID), connected with “typosrantevou”.”Aa” | smallint |
| “rantevou” | “rantevou”.”Xrhsths” | User (Line ID), connected with “Xrhstes”.”Aa” | integer |
| “rantevou” | “rantevou”.”Pros” | To user (Line ID), connected with “Xrhstes”.”Aa” | integer |
| “rantevou” | “rantevou”.”Eggrafh” | Saved | timestamp |
| “rantevou” | “rantevou”.”Repeat” | Repeat | varchar(100) |
| “rantevou” | “rantevou”.”mintime” | Start | timestamp |
| “rantevou” | “rantevou”.”maxtime” | Expiration | timestamp |
| “rantevou” | “rantevou”.”modified” | Modification | timestamp |
| “rantevou” | “rantevou”.”contact1″ | Contact 1 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact2″ | Contact 2 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact3″ | Contact 3 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact4″ | Contact 4 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact5″ | Contact 5 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact6″ | Contact 6 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact7″ | Contact 7 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact8″ | Contact 8 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact9″ | Contact 9 (Line ID), connected with “pelates”.”Aa” | integer |
| “rantevou” | “rantevou”.”contact10″ | Contact 10 (Line ID), connected with “pelates”.”Aa” | integer |
| “biblio” | Temporary of the main statement of revenue and expenses | ||
| “biblio” | “biblio”.”Aa” | Line ID | integer – Primary key |
| “biblio” | “biblio”.”Esoda1″ | Net revenues | float |
| “biblio” | “biblio”.”Esoda2″ | Gross revenue | float |
| “biblio” | “biblio”.”Ejoda1″ | Net expenses | float |
| “biblio” | “biblio”.”Ejoda2″ | Gross expenses | float |
| “biblio” | “biblio”.”Hmeromhnia” | Date | date |
| “kinhseis” | Each line of the “grammes” can optionally be linked to 1 line of the “kinhseis” containing the specific fields found in the Settings->Purchases/sales->Documents | ||
| “kinhseis” | “kinhseis”.”Grammh” | Document line (Line ID), connected with “grammes”.”Aa” | integer |
| “kinhseis” | “kinhseis”.”Uesh” | Position | varchar(10) |
| “kinhseis” | “kinhseis”.”Sxetiko” | Not used | integer |
| “kinhseis” | “kinhseis”.”Baros” | Weight | float |
| “kinhseis” | “kinhseis”.”Embado” | Area | float |
| “kinhseis” | “kinhseis”.”Ogkos” | Volume | float |
| “kinhseis” | “kinhseis”.”Merida” | Portion | varchar(30) |
| “kinhseis” | “kinhseis”.”Stixos” | Move | varchar(30) |
| “kinhseis” | “kinhseis”.”custom1″ | Custom field 1 | varchar(20) |
| “kinhseis” | “kinhseis”.”Ajia” | Price | float |
| “kinhseis” | “kinhseis”.”Y” | Height | float |
| “kinhseis” | “kinhseis”.”P” | Width | float |
| “kinhseis” | “kinhseis”.”B” | Depth | float |
| “kinhseis” | “kinhseis”.”aapar” | Document (Line ID), connected with “pvlhseis”.”Aa” | integer |
| “kinhseis” | “kinhseis”.”Enarjh” | Start date | timestamp |
| “kinhseis” | “kinhseis”.”Lhjh” | Expiry date | timestamp |
| “kinhseis” | “kinhseis”.”monada” | Measurement unit 2 (Line ID), connected with “monades”.”Aa” | smallint |
| “kinhseis” | “kinhseis”.”posothta” | Quantity of 2nd measurement unit | float |
| “kinhseis” | “kinhseis”.”measureunit” | Measurement unit 3 (Line ID), connected with “monades”.”Aa” | smallint |
| “kinhseis” | “kinhseis”.”quantity” | Quantity of 3rd measurement unit | float |
| “tropos” | Contains the shipping/handling methods | ||
| “tropos” | “tropos”.”Aa” | Line ID | integer – Primary key |
| “tropos” | “tropos”.”Titlos” | Title | varchar(50) |
| “tropos” | “tropos”.”courier” | Courier | varchar(10) |
| “tropos” | “tropos”.”senderid” | Sender ID | varchar(50) |
| “tropos” | “tropos”.”courieruser” | Connection user | varchar(50) |
| “tropos” | “tropos”.”courierpass” | Connection password | varchar(50) |
| “tropos” | “tropos”.”cpuser” | User | varchar(50) |
| “tropos” | “tropos”.”cppass” | Code/ID | varchar(50) |
| “tropos” | “tropos”.”order” | Order | integer |
| “skopos” | Contains the shipping/handling purposes | ||
| “skopos” | “skopos”.”Aa” | Line ID | integer – Primary key |
| “skopos” | “skopos”.”Titlos” | Title | varchar(40) |
| “skopos” | “skopos”.”order” | Order | integer |
| “skopos” | “skopos”.”tax_movement” | myDATA purpose of movement | smallint |
| “xrhstes” | Contains users used for logging in, shifts, etc | ||
| “xrhstes” | “xrhstes”.”Aa” | Line ID | integer – Primary key |
| “xrhstes” | “xrhstes”.”Onoma” | Username | varchar(10) |
| “xrhstes” | “xrhstes”.”Kvdikos” | Password | varchar(10) |
| “xrhstes” | “xrhstes”.”Email” | varchar(40) | |
| “xrhstes” | “xrhstes”.”Dikaivmata” | Rights (Line ID), connected with “dikaivmata”.”Aa” | smallint |
| “xrhstes” | “xrhstes”.”Pelaths” | Customer (Line ID), connected with “pelates”.”Aa” | integer |
| “xrhstes” | “xrhstes”.”pososto” | Commision rate | float |
| “xrhstes” | “xrhstes”.”Ekptvseis” | Commision rates (Line ID), connected with “ekptvseis”.”Aa” | smallint |
| “xrhstes” | “xrhstes”.”initext” | Value (user settings) | memo |
| “dikaivmata” | Contains the rights of users | ||
| “dikaivmata” | “dikaivmata”.”Aa” | Line ID | integer – Primary key |
| “dikaivmata” | “dikaivmata”.”Titlos” | Title | varchar(20) |
| “dikaivmata” | “dikaivmata”.”Pelates” | Customers, [0,1,2,3,4,5,6,7] none, read, read/write, read/write/edit, full rights, user except delete, user full, user read only | smallint |
| “dikaivmata” | “dikaivmata”.”Apouhkh” | Products, [0,1,2,3,4,5,6,7] none, read, read/write, read/write/edit, full rights, user except delete, user full, user read only | smallint |
| “dikaivmata” | “dikaivmata”.”Pvlhseis” | Sales, [0,1,2,3,4,5,6,7] none, read, read/write, read/write/edit, full rights, user except delete, user full, user read only | smallint |
| “dikaivmata” | “dikaivmata”.”Esodaejoda” | Revenues/Expenses, [0,1,2,3,4,5,6,7] none, read, read/write, read/write/edit, full rights, user except delete, user full, user read only | smallint |
| “dikaivmata” | “dikaivmata”.”Rantevou” | Appointments, [0,1,2,3,4,5,6,7] none, read, read/write, read/write/edit, full rights, user except delete, user full, user read only | smallint |
| “dikaivmata” | “dikaivmata”.”Hotel” | Hotel, [0,1,2,3,4,5,6,7] none, read, read/write, read/write/edit, full rights, user except delete, user full, user read only | smallint |
| “dikaivmata” | “dikaivmata”.”Ryumiseis” | Settings, [0,1,2,3,4,5,6,7] none, read, read/write, read/write/edit, full rights, user except delete, user full, user read only | smallint |
| “dikaivmata” | “dikaivmata”.”hide_cust_relations” | Hide customers with relation | varchar(15) |
| “dikaivmata” | “dikaivmata”.”modifyview” | Modify view, [0,1] | smallint |
| “dikaivmata” | “dikaivmata”.”hidetotals” | Hide totals, [0,1] | smallint |
| “dikaivmata” | “dikaivmata”.”noprint” | Disable print import export, [0,1] | smallint |
| “dikaivmata” | “dikaivmata”.”hidedoctotals” | Hide documents lists totals, [0,1] | smallint |
| “dikaivmata” | “dikaivmata”.”oneday” | 1 day list of documents, [0,1] | smallint |
| “dikaivmata” | “dikaivmata”.”hidepurchases” | Hide purchases, [0,1] | smallint |
| “dikaivmata” | “dikaivmata”.”hideshifttotals” | Hide shift totals, [0,1] | smallint |
| “dikaivmata” | “dikaivmata”.”doc_line” | Sales lock (binary), check_bit_at_position(“dikaivmata”.”doc_line”,1) “Cash drawer”, check_bit_at_position(“dikaivmata”.”doc_line”,2) “VAT”, check_bit_at_position(“dikaivmata”.”doc_line”,3) “Value”, check_bit_at_position(“dikaivmata”.”doc_line”,4) “Description” | smallint |
| “dikaivmata” | “dikaivmata”.”limit_docs” | Documents the user is allowed to view (Line ID), comma-separated “eidhpar”.”Aa” | varchar(100) |
| “ekptvseis” | Contains the price lists/discount groups | ||
| “ekptvseis” | “ekptvseis”.”Aa” | Line ID | integer – Primary key |
| “ekptvseis” | “ekptvseis”.”Titlos” | Title | varchar(20) |
| “ekptvseis” | “ekptvseis”.”Pososto” | Percent | float |
| “ekptvseis” | “ekptvseis”.”Poso” | Amount | float |
| “ekptvseis” | “ekptvseis”.”calc” | Display rate, [0,1] | smallint |
| “ekptvseis” | “ekptvseis”.”modified” | Modification | timestamp |
| “ekptvseis” | “ekptvseis”.”from_time” | From time | time |
| “ekptvseis” | “ekptvseis”.”to_time” | To time | time |
| “ekptvseis” | “ekptvseis”.”from_date” | From date | date |
| “ekptvseis” | “ekptvseis”.”to_date” | To date | date |
| “ekptvseisgrammes” | Contains the discounts of the price list/discount group | ||
| “ekptvseisgrammes” | “ekptvseisgrammes”.”Aa” | Line ID | integer – Primary key |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”Ekptvseis” | Price list (Line ID), connected with “ekptvseis”.”Aa” | smallint |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”Pososto” | Percent | float |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”fixed” | Based on price, [0,1,2,3,4,5,6] sale, none, purchase, last purchase by customer/supplier, last sale by customer/supplier, last purchase price, last sale price | smallint |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”fixedprice” | Net price | float |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”Poso” | Amount | float |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”Omada” | Subcategory (Line ID), linked to “omades”.”Aa” | smallint |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”Kathgoria” | Category (Line ID), connected with “kathgories”.”Aa” | smallint |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”Eidos” | Item (Line ID), connected with “apouhkh”.”Aa” | integer |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”calc” | Display rate, [0,1] | smallint |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”modified” | Modification | timestamp |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”from_time” | From time | time |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”to_time” | To time | time |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”from_date” | From date | date |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”to_date” | To date | date |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”quantityfrom” | Quantity from | float |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”quantityto” | Quantity to | float |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”customfield” | Custom field (Line ID), connected with “apouhkh_pedia”.”Aa” | smallint |
| “ekptvseisgrammes” | “ekptvseisgrammes”.”customfieldvalue” | Custom field value | varchar(100) |
| “dromologhsh” | Contains the routes of the places | ||
| “dromologhsh” | “dromologhsh”.”Aa” | Line ID | integer – Primary key |
| “dromologhsh” | “dromologhsh”.”Kathgoria” | Category (Line ID), connected with “kathgories”.”Aa” | integer |
| “dromologhsh” | “dromologhsh”.”Omada” | Subcategory (Line ID), connected with “omades”.”Aa” | integer |
| “dromologhsh” | “dromologhsh”.”Xvros” | Place (Line ID), connected with “xvroi”.”Aa” | smallint |
| “dromologhsh” | “dromologhsh”.”eidos” | ID/Barcode, for multiple separate by comma, connected with “apouhkh”.”Kvdikos” | varchar(100) |
| “dromologhshxvroi” | Contains the places where orders are received | ||
| “dromologhshxvroi” | “dromologhshxvroi”.”Aa” | Line ID | integer – Primary key |
| “dromologhshxvroi” | “dromologhshxvroi”.”Titlos” | Title | varchar(30) |
| “dromologhshxvroi” | “dromologhshxvroi”.”Arxeio” | File | varchar(100) |
| “dromologhshxvroi” | “dromologhshxvroi”.”Ektypvths” | Printer | varchar(100) |
| “dromologhshxvroi” | “dromologhshxvroi”.”Antigrafa” | Copies | integer |
| “dromologhshxvroi” | “dromologhshxvroi”.”barcode” | Print barcode, [0,1] | smallint |
| “apouhkh_times” | Contains the values of the custom fields found in the “apouhkh_pedia” table | ||
| “apouhkh_times” | “apouhkh_times”.”Aa” | Line ID | integer – Primary key |
| “apouhkh_times” | “apouhkh_times”.”Titlos” | Prices | varchar(100) |
| “apouhkh_times” | “apouhkh_times”.”Pedio” | Fields (Line ID), connected with “apouhkh_pedia”.”Aa” | integer |
| “apouhkh_pedia” | Contains custom fields for customers, suppliers, items and services | ||
| “apouhkh_pedia” | “apouhkh_pedia”.”Aa” | Line ID | integer – Primary key |
| “apouhkh_pedia” | “apouhkh_pedia”.”Titlos” | Title | varchar(100) |
| “apouhkh_pedia” | “apouhkh_pedia”.”indexkey” | Type, [0,1,2,3] no, product id, filter, date | smallint |
| “xvroi” | Contains the tables/seats on place | ||
| “xvroi” | “xvroi”.”Aa” | Line ID | integer – Primary key |
| “xvroi” | “xvroi”.”Titlos” | Place | varchar(20) |
| “xvroi” | “xvroi”.”Vres” | Hours | memo |
| “xvroi” | “xvroi”.”Ueseis” | Positions | memo |
| “xvroi” | “xvroi”.”Aapar” | Document (Line ID), connected with “pvlhseis”.”Aa” | smallint |
| “xvroi” | “xvroi”.”Aapara” | Document (Line ID) | smallint |
| “xvroi” | “xvroi”.”RefundID” | Refund document (Line ID), connected with “pvlhseis”.”Aa” | smallint |
| “xvroi” | “xvroi”.”order” | Order | smallint |
| “poleis” | Contains the cities in connection with the countries | ||
| “poleis” | “poleis”.”Aa” | Line ID | integer – Primary key |
| “poleis” | “poleis”.”Onomasia” | City | varchar(30) |
| “poleis” | “poleis”.”modified” | Modification | timestamp |
| “poleis” | “poleis”.”country” | Abbreviation | varchar(4) |
| “omades” | Contains the subcategories | ||
| “omades” | “omades”.”Aa” | Line ID | integer – Primary key |
| “omades” | “omades”.”Kathgoria” | Category (Line ID), connected with “kathgories”.”Aa” | smallint |
| “omades” | “omades”.”Omada” | Subcategory title | varchar(200) |
| “omades” | “omades”.”order” | Order | integer |
| “omades” | “omades”.”accountingcode” | Accounting code | varchar(3) |
| “omades” | “omades”.”accountingnumber” | Accounting number | varchar(30) |
| “omades” | “omades”.”modified” | Modification | timestamp |
| “omades” | “omades”.”color” | Color | integer |
| “omades” | “omades”.”scalecat” | Scale category | integer |
| “omades” | “omades”.”buttonwidth” | Items buttons width | integer |
| “omades” | “omades”.”per_item” | Select subcategories | smallint |
| “timhapokvdiko” | Contains item code recognition settings, for use in scales, customer and connection to room reservations | ||
| “timhapokvdiko” | “timhapokvdiko”.”Aa” | Line ID | integer – Primary key |
| “timhapokvdiko” | “timhapokvdiko”.”ProuemaKvdikou” | ID/barcode prefix | varchar(20) |
| “timhapokvdiko” | “timhapokvdiko”.”XarakthresKvdikou” | ID/barcode digits | smallint |
| “timhapokvdiko” | “timhapokvdiko”.”AjiaApo” | Price position | smallint |
| “timhapokvdiko” | “timhapokvdiko”.”XarakthresAjias” | Price digits | smallint |
| “timhapokvdiko” | “timhapokvdiko”.”DekadikaAjias” | Price decimals | smallint |
| “timhapokvdiko” | “timhapokvdiko”.”PosothtaApoKvdiko” | Quantity by type, [0,1] | smallint |
| “timhapokvdiko” | “timhapokvdiko”.”Seposothta” | In quantity, [0,1] | smallint |
| “timhapokvdiko” | “timhapokvdiko”.”Zygaria” | Action, [0,1,2] no, yes, from barcode | smallint |
| “typosrantevou” | Contains types of appointments | ||
| “typosrantevou” | “typosrantevou”.”Aa” | Line ID | integer – Primary key |
| “typosrantevou” | “typosrantevou”.”Titlos” | Title | varchar(40) |
| “typosrantevou” | “typosrantevou”.”Color” | Color | integer |
| “kathgories” | It contains the categories of goods, services | ||
| “kathgories” | “kathgories”.”Aa” | Line ID | integer – Primary key |
| “kathgories” | “kathgories”.”Kathgoria” | Category | varchar(50) |
| “kathgories” | “kathgories”.”modified” | Modification | timestamp |
| “kathgories” | “kathgories”.”order” | Order | integer |
| “kathgories” | “kathgories”.”color” | Button color | integer |
| “settings” | Contains the settings if local settings are not selected | ||
| “settings” | “settings”.”pc” | File | varchar(50) |
| “settings” | “settings”.”root” | Section | varchar(30) |
| “settings” | “settings”.”key” | Key | varchar(200) |
| “settings” | “settings”.”initext” | Value | memo |
| “settings” | “settings”.”user” | User (Line ID), connected with “xrhstes”.”Aa” | integer |
| “usage” | Contains the data concerning the shifts | ||
| “usage” | “usage”.”Aa” | Line ID | integer – Primary key |
| “usage” | “usage”.”Amount” | Drawer. The cash that is in the workstation. Recorded only at the start and end of the shift | float |
| “usage” | “usage”.”UserID” | User (Line ID), connected with “xrhstes”.”Aa” | smallint |
| “usage” | “usage”.”Action” | Action (Line ID) [null,0,1] We set the value “0” for shift start and “1” for shift end. Null for the remaining entries | smallint |
| “usage” | “usage”.”modified” | Modification | timestamp |
| “usage” | “usage”.”pass” | Status [null,0,1] Value “1” on all completed shift movements, “2” on all pending shift movements. Null is the shift start movement which becomes 1 when completed | smallint |
| “usage” | “usage”.”pcuser” | Windows user | varchar(50) |
| “relatedproducts” | Contains products/services combinations | ||
| “relatedproducts” | “relatedproducts”.”BaseAa” | Item (Line ID), connected with “apouhkh”.”Aa” | integer |
| “relatedproducts” | “relatedproducts”.”RelatedAa” | Related item (Line ID), connected with “apouhkh”.”Aa” | integer |
| “relatedproducts” | “relatedproducts”.”Quantity” | Quantity | float |
| “relatedproducts” | “relatedproducts”.”show” | Appearance | smallint |
| “relatedproducts” | “relatedproducts”.”totalsaleprice” | Retail price | float |
| “relatedproducts” | “relatedproducts”.”totalpurchaseprice” | Net price | float |
| “relatedproducts” | “relatedproducts”.”modified” | Modification | timestamp |
| “oxhmata” | Contains customer and documents vehicles | ||
| “oxhmata” | “oxhmata”.”Aa” | Line ID | integer – Primary key |
| “oxhmata” | “oxhmata”.”Idiokthths” | Customer/supplier, connected with “pelates”.”Aa” | integer |
| “oxhmata” | “oxhmata”.”Pinakida” | License plate | varchar(30) |
| “oxhmata” | “oxhmata”.”Marka” | Make | varchar(15) |
| “oxhmata” | “oxhmata”.”Y” | Height | float |
| “oxhmata” | “oxhmata”.”P” | Width | float |
| “oxhmata” | “oxhmata”.”B” | Depth | float |
| “oxhmata” | “oxhmata”.”Ogkos” | Volume | float |
| “oxhmata” | “oxhmata”.”Embado” | Area | float |
| “oxhmata” | “oxhmata”.”Baros” | Weight | float |
| “oxhmata” | “oxhmata”.”engineid” | Engine ID | varchar(30) |
| “oxhmata” | “oxhmata”.”frameid” | Frame ID | varchar(30) |
| “oxhmata” | “oxhmata”.”color” | Color | varchar(30) |
| “oxhmata” | “oxhmata”.”vehicledate” | Date | date |
| “oxhmata” | “oxhmata”.”power” | Power | varchar(30) |
| “oxhmata” | “oxhmata”.”fuel” | Fuel | varchar(30) |
| “oxhmata” | “oxhmata”.”type” | Type | varchar(30) |
| “oxhmata” | “oxhmata”.”model” | Model | varchar(30) |
| “oxhmata” | “oxhmata”.”modified” | Modification | timestamp |
| “subcategories_relations” | Contains associations in order to define multiple subcategories per category | ||
| “subcategories_relations” | “subcategories_relations”.”Aa” | Line ID | integer – Primary key |
| “subcategories_relations” | “subcategories_relations”.”product_id” | Item (Line ID), connected with “apouhkh”.”Aa” | integer |
| “subcategories_relations” | “subcategories_relations”.”parent_subcat” | Subcategory of parent (Line ID), connected with “omades”.”Aa” | integer |
| “subcategories_relations” | “subcategories_relations”.”order” | Order | integer |
| “subcategories_relations” | “subcategories_relations”.”subcat” | Subcategory (Line ID), connected with “omades”.”Aa” | integer |
| “subcategories_relations” | “subcategories_relations”.”modified” | Modification | timestamp |
| “barcodes” | Contains the barcodes of the products | ||
| “barcodes” | “barcodes”.”product_id” | Item (Line ID), connected with “apouhkh”.”Aa” | integer |
| “barcodes” | “barcodes”.”barcode” | Barcode | varchar(30) |
| “barcodes” | “barcodes”.”quantity” | Quantity | float |
| “barcodes” | “barcodes”.”modified” | Modification | timestamp |
| “history” | Contains usage history, such as customer data, items, voucher number, email, card number | ||
| “history” | “history”.”id” | Corresponding table and field (Line ID) When the type is -2 “pvlhseis”.”Aa” -1 “pvlhseis”.”Aa” 1 “pelates”.”Aa” 2 “apouhkh”.”Aa” 5 “pelates”.”Aa” 6 “pelates”.”Aa” 7 “pelates”.”Aa” 8 “pelates”.”Aa” 9 “pelates”.”Aa” 10 “apouhkh”.”Aa” | integer |
| “history” | “history”.”type” | Type, [-1,1,2,5,6,7,8,9] -2 Elements for linking myDATA digital customer list with documents -1 Payment terminal transaction data 1 Customer data 2 Products data 5 Email 6 SMS 7 Customer grouping 8 Issue of voucher 9 Cancellation of voucher 10 Products grouping When deleting history, only the one that has a value greater than -1 is deleted. | smallint |
| “history” | “history”.”modified” | Date | timestamp |
| “history” | “history”.”text” | Analysis – Free text If “history”.”type”=-1 Payment terminal transaction data then it is text separated by ASCII 13 with columns: 1 TID – Terminal ID 2 Transaction ID 3 Related ID 4 Action 8 Source | memo |
| “history” | “history”.”user” | User who makes the transaction (Line ID), connected with “xrhstes”.”Aa” | smallint |
| “history” | “history”.”Aa” | Line ID | integer – Primary key |
| “custom_buttons” | Contains customized options/keys for customers/suppliers, items/services and sales | ||
| “custom_buttons” | “custom_buttons”.”Aa” | Line ID | integer – Primary key |
| “custom_buttons” | “custom_buttons”.”type” | customers, products, sales | smallint |
| “custom_buttons” | “custom_buttons”.”description” | Description | varchar(30) |
| “custom_buttons” | “custom_buttons”.”link” | Link | varchar(300) |
| “custom_buttons” | “custom_buttons”.”icon” | Icon | varchar(200) |
| “custom_buttons” | “custom_buttons”.”order” | Order | integer |
| “stockperdocline” | Holds stock-lot quantities per document line. | ||
| “stockperdocline” | “stockperdocline”.”ProductID” | Item (Line ID), linked to “apouhkh”.”Aa” | integer |
| “stockperdocline” | “stockperdocline”.”LineID” | Document line (Line ID), linked to “grammes”.”Aa” | integer |
| “stockperdocline” | “stockperdocline”.”Quantity” | Quantity | float |
| “stockperdocline” | “stockperdocline”.”RelID” | Related line (Line ID), linked to “grammes”.”Aa” | integer |
| “xrevseis” | Holds extra charges, for example hotel charges. | ||
| “xrevseis” | “xrevseis”.”Aa” | Line ID | integer – Primary key |
| “xrevseis” | “xrevseis”.”Onomasia” | Title | varchar(20) |
| “xrevseis” | “xrevseis”.”Ogkos” | Volume | float |
| “xrevseis” | “xrevseis”.”Embado” | Area | float |
| “xrevseis” | “xrevseis”.”Baros” | Weight | float |
| “xrevseis” | “xrevseis”.”Enapouesh” | Grace record | smallint |
| “xrevseis” | “xrevseis”.”Arxikh” | Charge | float |
| “xrevseis” | “xrevseis”.”Hmeres” | Days | smallint |
| “xrevseis” | “xrevseis”.”Enoikio” | Cost for specific period | float |
| “xrevseis” | “xrevseis”.”Ajia” | Value | float |
| “tmp_prices” | Temporary table of average prices. | ||
| “tmp_prices” | “tmp_prices”.”Eidos” | Item (Line ID), linked to “apouhkh”.”Aa” | bigint |
| “tmp_prices” | “tmp_prices”.”mesh_a” | Average purchase price | float |
| “tmp_prices” | “tmp_prices”.”mesh_p” | Average sale price | float |
| Function analysis – functions | |||
| Function | Fields | Answer | |
| apouhkh_Aa (in_kvdikos VARCHAR(50)) | In the in_kvdikos variable you set “apouhkh”.”Kvdikos” | Returns “apouhkh”.”Aa” from the table “apouhkh” | |
| apouhkh_Kvdikos (in_aa INTEGER) | In the in_aa variable you set “apouhkh”.”Aa” | Returns “apouhkh”.”Kvdikos” from the table “apouhkh” | |
| CALC_LINE_PRE_VAT (EMF_TIMVN SMALLINT,POSOTHTA NUMERIC(18,4),TIMH NUMERIC(18,4),EKPTVSH NUMERIC(18,4),MONADA INTEGER,FPA NUMERIC(18,4),ROUND_DIGITS SMALLINT,TAX_DOCS VARCHAR(12)) |
In the variables you set: EMF_TIMVN=price display type, POSOTHTA=quantity, TIMH=price, EKPTVSH=discount, MONADA=unit, FPA=VAT, ROUND_DIGITS=rounding decimals, TAX_DOCS=document type | Returns the line amount before VAT, calculated based on the above fields | |
| CREATE OR ALTER FUNCTION CALC_LINE_WITH_VAT (EMF_TIMVN SMALLINT,POSOTHTA NUMERIC(18,4),TIMH NUMERIC(18,4),EKPTVSH NUMERIC(18,4),MONADA INTEGER,FPA NUMERIC(18,4),ROUND_DIGITS SMALLINT,TAX_DOCS VARCHAR(12)) |
In the variables you set: EMF_TIMVN=price display type, POSOTHTA=quantity, TIMH=price, EKPTVSH=discount, MONADA=unit, FPA=VAT, ROUND_DIGITS=rounding decimals, TAX_DOCS=document type | Returns the line amount including VAT, calculated based on the above fields | |
| CREATE OR ALTER FUNCTION CALC_LINE_VAT (EMF_TIMVN SMALLINT,POSOTHTA NUMERIC(18,4),TIMH NUMERIC(18,4),EKPTVSH NUMERIC(18,4),MONADA INTEGER,FPA NUMERIC(18,4),ROUND_DIGITS SMALLINT,TAX_DOCS VARCHAR(12)) |
In the variables you set: EMF_TIMVN=price display type, POSOTHTA=quantity, TIMH=price, EKPTVSH=discount, MONADA=unit, FPA=VAT, ROUND_DIGITS=rounding decimals, TAX_DOCS=document type | Returns the VAT amount for the line, as the difference with/without VAT | |
| SPLIT_STRING (AINPUT varchar(1000), DELIMITER varchar(10), NUM integer) | In the variables you set: AINPUT=input text, DELIMITER=delimiter, NUM=position | Returns the NUM-th part of the string, split by DELIMITER | |
| string_to_float (ch varCHAR(1000)) | In the ch variable you set the input text | Returns ch as float (decimal number) | |
| string_to_integer (ch varCHAR(1000)) | In the ch variable you set the input text | Returns ch as integer | |
| doc_abbreviation (DOCTITLE varchar(1000),DOCNUMBER varchar(1000)) | In the variables you set: DOCTITLE=title, DOCNUMBER=number | Returns abbreviation of title and number | |
| FUNCTION GET_LATEST_PURCHASE_PRICE (product_id INTEGER,after_discount boolean,customer_id integer) | In the variables you set: product_id=product, after_discount=after discount, customer_id=customer | Returns latest purchase price for product/customer | |
| GET_LATEST_SALE_PRICE (product_id INTEGER,after_discount boolean,customer_id integer) | In the variables you set: product_id=product, after_discount=after discount, customer_id=customer | Returns latest sale price for product/customer | |
| CHECK_BIT_AT_POSITION (InputValue INTEGER,BitPos INTEGER) | In the variables you set: InputValue=integer, BitPos=bit position | Returns if the bit at BitPos is 1 (true/false) | |
| get_company_name (epvnymia VARCHAR(70),onoma VARCHAR(30),epiueto VARCHAR(40)) | In the variables you set: epvnymia=company name, onoma=first name, epiueto=last name | Returns the company name, using epvnymia or onoma+epiueto | |
| FLOAT_RESTRICT_DECIMALS (REAL_ DOUBLE PRECISION, DECIMALS_ INTEGER) | In the variables you set: REAL_=number, DECIMALS_=decimals | Returns the number restricted to DECIMALS_ decimal places |