EMDI web API field analysis

This page explains every JSON field of the EMDI web API (English names), in the same style as the database analysis for Firebird tables.

Auth: ?user= + ?key= (or X-API-Key header)
List: GET /apps/api/list/{type}.json
One record: GET /apps/api/{type}/{id}.json
Save: POST /apps/api/save/{type}.json — fields go under data
API guide + interactive docs: EMDI web API
Documents: documents = all pvlhseis columns; document_lines = all grammes columns inside lines. On list use ?include_lines=1.

In the table: Resource = API type, Field = JSON key, Description, Type.

Resource	Field	Description	Type
`contacts`		Contacts, customers and suppliers (`pelates`).
`contacts`	`id`	Row id (primary key)	integer
`contacts`	`code`	Code	string
`contacts`	`name`	First name	string
`contacts`	`surname`	Surname	string
`contacts`	`company`	Company name	string
`contacts`	`phone`	Phone	string
`contacts`	`mobile`	Mobile	string
`contacts`	`fax`	Fax	string
`contacts`	`email`	Email	string
`contacts`	`url`	URL	string
`contacts`	`address`	Address	string
`contacts`	`area`	Area / district	string
`contacts`	`postal_code`	Postal code	string
`contacts`	`floor`	PO box / floor	string
`contacts`	`vat_number`	VAT number. Cannot change if the contact is used on a document.	string
`contacts`	`notes`	Notes	string
`contacts`	`department`	Police department (ID issue)	string
`contacts`	`installation_number`	Installation number	string
`contacts`	`id_issue_date`	ID issue date	string (date)
`contacts`	`city_id`	City id (FK poleis)	integer
`contacts`	`city`	City label	string
`contacts`	`tax_office_id`	Tax office id	integer
`contacts`	`tax_office`	Tax office label	string
`contacts`	`occupation_id`	Occupation id	integer
`contacts`	`occupation`	Occupation label	string
`contacts`	`relation_id`	Relation id	integer
`contacts`	`relation`	Relation label	string
`contacts`	`payment_method_id`	Payment method id	integer
`contacts`	`payment_method`	Payment method label	string
`contacts`	`user_id`	Related user id	integer
`contacts`	`user`	User label	string
`contacts`	`price_list_id`	Price list id	integer
`contacts`	`price_list`	Price list label	string
`contacts`	`parent_contact_id`	Parent contact id	integer
`contacts`	`active`	Active flag [1,0]	integer
`contacts`	`vat_obligation`	VAT obligation [0,1,2]	integer
`contacts`	`tax_list`	MYF obligation [1,0]	integer
`contacts`	`no_loyalties`	Exclude from loyalty [1,0]	integer
`contacts`	`credit_limit`	Credit limit	number
`contacts`	`purchases_value`	Purchases value	number
`contacts`	`sales_value`	Sales value	number
`contacts`	`stored_balance`	Stored balance field	number
`contacts`	`balance`	Computed balance (debit − credit); optional date_from/date_to	number
`contacts`	`accounting_number`	Accounting account	string
`contacts`	`accounting_code`	Accounting code	integer
`contacts`	`company_number`	Company number	string
`contacts`	`latitude`	Latitude	number
`contacts`	`longitude`	Longitude	number
`contacts`	`last_move`	Last document date	string (date)
`contacts`	`created`	Created date	string (date)
`contacts`	`modified`	Modified	string (datetime)
`contacts`	`custom1…custom20`	Custom fields 1–20	string
`items`		Products and services (`apouhkh`).
`items`	`id`	Row id	integer
`items`	`code`	Item code / barcode	string
`items`	`secondary_code`	Purchase / secondary code	string
`items`	`description`	Description	string
`items`	`retail_price`	Net / retail price	number
`items`	`wholesale_price`	Purchase / wholesale value	number
`items`	`unit_id`	Unit id	integer
`items`	`unit`	Unit label	string
`items`	`unit2_id`	Unit 2 id	integer
`items`	`unit2`	Unit 2 label	string
`items`	`unit3_id`	Unit 3 id	integer
`items`	`unit3`	Unit 3 label	string
`items`	`quantity2`	Quantity for unit 2	number
`items`	`quantity3`	Quantity for unit 3	number
`items`	`subcategory_id`	Subcategory id	integer
`items`	`category`	Subcategory label	string
`items`	`main_category_id`	Main category id	integer
`items`	`main_category`	Main category label	string
`items`	`vat_rate`	VAT rate %	number
`items`	`supplier_id`	Supplier contact id	integer
`items`	`user_id`	User id	integer
`items`	`user`	User label	string
`items`	`length`	Width (P)	number
`items`	`height`	Height (Y)	number
`items`	`width`	Depth (B)	number
`items`	`area`	Area	number
`items`	`weight`	Weight	number
`items`	`volume`	Volume	number
`items`	`order`	Sort order	integer
`items`	`color`	Color	integer
`items`	`min_quantity`	Minimum quantity	number
`items`	`profit_percent`	Profit percent	number
`items`	`profit_amount`	Profit amount	number
`items`	`sales_qty`	Sales quantity	number
`items`	`income`	Income	number
`items`	`expense`	Expense	number
`items`	`internet`	E-shop flag [1,0]	integer
`items`	`scale`	Scale flag [1,0]	integer
`items`	`sync`	Sync flag	integer
`items`	`photo`	Photo path/URL	string
`items`	`url`	URL	string
`items`	`notes`	Detailed description	string
`items`	`taric`	Taric code	string
`items`	`active`	Active [1,0]	integer
`items`	`stock_qty`	Availability / stock	number
`items`	`price_changed`	Price changed date	string (date)
`items`	`created`	Created	string (date)
`items`	`barcodes`	Item barcodes	array of string
`items`	`modified`	Modified	string (datetime)
`items`	`custom1…custom50`	Custom fields 1–50	string
`calendar`		Reminders and appointments (`rantevou`).
`calendar`	`id`	Row id	integer
`calendar`	`contact_id`	Primary contact id	integer
`calendar`	`event_type_id`	Event type id	integer
`calendar`	`event_type`	Event type label	string
`calendar`	`user_id`	User id	integer
`calendar`	`user`	User label	string
`calendar`	`assigned_to_id`	Assigned-to user id	integer
`calendar`	`assigned_to`	Assigned-to label	string
`calendar`	`start`	Start	string (datetime)
`calendar`	`end`	End	string (datetime)
`calendar`	`alarm`	Reminder / alarm	string (datetime)
`calendar`	`created`	Registered / created	string (datetime)
`calendar`	`min_time`	Computed range start	string (datetime)
`calendar`	`max_time`	Computed range end	string (datetime)
`calendar`	`comment`	Note / comment	string
`calendar`	`repeat`	Repeat rule	string
`calendar`	`modified`	Modified	string (datetime)
`calendar`	`contact1_id…contact10_id`	Extra contacts 1–10	integer
`documents`		Documents (`pvlhseis`, all columns). Lines in `lines` (`grammes`). On list: `include_lines=1`.
`documents`	`id`	Document id	integer
`documents`	`series`	Series	string
`documents`	`number`	Document number	integer
`documents`	`date`	Date/time	string (datetime)
`documents`	`time_from`	Time from	string (time)
`documents`	`time_to`	Time to	string (time)
`documents`	`delivery_date`	Delivery date	string (date)
`documents`	`doc_type_id`	Document type id	integer
`documents`	`doc_type`	Document type label	string
`documents`	`contact_id`	Contact id	integer
`documents`	`delivery_contact_id`	Delivery contact id	integer
`documents`	`assignor_id`	Assignor contact id	integer
`documents`	`payment_method_id`	Payment method id	integer
`documents`	`payment_method`	Payment method label	string
`documents`	`payment_method2_id`	Payment method 2 id	integer
`documents`	`payment_method2`	Payment method 2 label	string
`documents`	`shipping_method_id`	Shipping method id	integer
`documents`	`shipping_method`	Shipping method label	string
`documents`	`purpose_id`	Purpose id	integer
`documents`	`purpose`	Purpose label	string
`documents`	`user_id`	User id	integer
`documents`	`user`	User label	string
`documents`	`comment`	Comment	string
`documents`	`shipping_place`	Shipping place	string
`documents`	`loading_place`	Loading place	string
`documents`	`plate`	Vehicle number / plate	string
`documents`	`related_docs`	Related documents text	string
`documents`	`related_document_id`	Related document id	integer
`documents`	`schedule_id`	Calendar / schedule id	integer
`documents`	`devices_sent`	Devices sent list	string
`documents`	`custom`	Custom field	string
`documents`	`voucher`	Voucher	string
`documents`	`b2g`	B2G fields (; separated)	string
`documents`	`net_before_discount`	Total before discount	number
`documents`	`vat_total`	VAT total	number
`documents`	`total`	Grand total with VAT	number
`documents`	`other_charges`	Other charges	number
`documents`	`qty_total`	Quantity total	number
`documents`	`volume_total`	Volume total	number
`documents`	`area_total`	Area total	number
`documents`	`weight_total`	Weight total	number
`documents`	`extra_value_total`	Extra value total	number
`documents`	`proportional_percent`	Proportional percent	number
`documents`	`payment`	Payment amount 1	number
`documents`	`payment2`	Payment amount 2	number
`documents`	`mydata_locked`	Locked (mark or signature). Cannot delete/edit.	boolean
`documents`	`invoice_mark`	myDATA invoice mark	integer
`documents`	`signature`	Provider signature	string
`documents`	`modified`	Modified	string (datetime)
`documents`	`lines`	Document lines (see document_lines)	array
`documents`	`custom1…custom5`	Custom fields 1–5	string
`document_lines`		Document lines (`grammes`) inside documents.lines.
`document_lines`	`id`	Line id	integer
`document_lines`	`document_id`	Document id	integer
`document_lines`	`product_id`	Product id	integer
`document_lines`	`unit_id`	Unit id	integer
`document_lines`	`description`	Description	string
`document_lines`	`code`	Item code	string
`document_lines`	`unit`	Unit label stored	string
`document_lines`	`qty`	Quantity	number
`document_lines`	`price`	Unit value / price	number
`document_lines`	`discount`	Discount percent	number
`document_lines`	`vat_rate`	VAT rate	number
`document_lines`	`order`	Line order	integer
`document_lines`	`action`	Movement [0,1,2] (orders)	integer
`document_lines`	`type`	Type [1,2] parent/combo	integer
`document_lines`	`related_line_id`	Related line id	integer
`doc_types`		Document types (`eidhpar`). Lookup list/doc_types.json.
`doc_types`	`id`	Row id	integer
`doc_types`	`parent_id`	Parent id	integer
`doc_types`	`related_id`	Related id	integer
`doc_types`	`name`	Title	string
`doc_types`	`series`	Default series	string
`doc_types`	`number`	Next number	integer
`doc_types`	`cashiers_position_id`	Cashier position id	integer
`doc_types`	`cashiers_position`	Cashier position label	string
`doc_types`	`movement`	Movement [0–6]: 0 purchase/in, 1 sale/out, 2 collection, 3 payment, 4 none, 5 purchase w/o stock, 6 sale w/o stock	integer
`doc_types`	`price_mode`	Price display [0–3]: 0 no, 1 yes, 2 credit/return, 3 VAT only	integer
`doc_types`	`day_change`	Day change mode	integer
`doc_types`	`print_mode`	Print mode	integer
`doc_types`	`default_item_codes`	Default item codes	string
`doc_types`	`recipient_titles`	Recipient titles	string
`doc_types`	`on_lines`	On-lines mode	integer
`doc_types`	`recipients`	Recipients mode	integer
`doc_types`	`copies`	Copies	integer
`doc_types`	`copy_titles`	Copy titles	string
`doc_types`	`printer`	Printer	string
`doc_types`	`form_file`	Form file	string
`doc_types`	`payment_method_id`	Default payment method id	integer
`doc_types`	`fiscal_signing`	Fiscal signing	integer
`doc_types`	`signing_doc_number`	Signing document number	integer
`doc_types`	`deductible_amount`	Deductible amount mode	integer
`doc_types`	`serials`	Serials mode	integer
`doc_types`	`special_fields_flags`	Special fields bitmap	integer
`doc_types`	`special_field_titles`	Special field titles	string
`doc_types`	`accounting_code`	Accounting code	string
`doc_types`	`accounting_account`	Accounting account	string
`doc_types`	`aggregates`	Aggregates mode	integer
`doc_types`	`price_list`	Price list	string
`doc_types`	`related_products`	Related products mode	integer
`doc_types`	`empty_expiration_text`	Empty expiration text	string
`doc_types`	`custom_sql`	Custom SQL	string
`doc_types`	`order`	Sort order	integer
`doc_types`	`options_flags`	Options bitmap (e-invoicing, delivery note, …)	integer
`doc_types`	`tax_docs`	myDATA tax docs code	string
`doc_types`	`tax_category`	myDATA category	string
`doc_types`	`tax_type`	myDATA type	string
`doc_types`	`shipping_purpose`	Shipping purpose	integer
`doc_types`	`shipping_method`	Shipping method	integer
`vat_rates`		VAT rates (`fpa`).
`vat_rates`	`id`	Row id	integer
`vat_rates`	`rate`	VAT rate	number
`vat_rates`	`title`	Title	string
`vat_rates`	`cashier_id`	Cashier id	integer
`vat_rates`	`accounting_number_in`	Accounting number in	string
`vat_rates`	`accounting_number_out`	Accounting number out	string
`vat_rates`	`modified`	Modified	string (datetime)
`vat_rates`	`tax_id`	tax_id	integer
`vat_rates`	`tax_vat`	tax_vat	integer
`vat_rates`	`tax_type_revenues`	Revenue tax type	string
`vat_rates`	`tax_type_expenses`	Expense tax type	string
`vat_rates`	`order`	Sort order	integer
`users`		Users (`xrhstes`) — no password.
`users`	`id`	Row id	integer
`users`	`name`	Name	string
`users`	`email`	Email	string
`users`	`rights_id`	Rights id	integer
`users`	`contact_id`	Contact id	integer
`users`	`commission_percent`	Commission percent	number
`users`	`commission_price_list_id`	Commission price list id	integer
`contacts_relations`		Contact relations (`sxeseis`).
`contacts_relations`	`id`	Row id	integer
`contacts_relations`	`name`	Name	string
`contacts_relations`	`accounting_code`	Accounting code	integer
`contacts_relations`	`accounting_number`	Accounting number	string
`contacts_relations`	`modified`	Modified	string (datetime)
`contacts_relations`	`readonly`	Readonly [1,0]	integer
`measurement_units`		Measurement units (`monades`).
`measurement_units`	`id`	Row id	integer
`measurement_units`	`name`	Name	string
`measurement_units`	`quantity`	Quantity	number
`measurement_units`	`modified`	Modified	string (datetime)
`measurement_units`	`tax_unit`	Tax unit	integer
`categories`		Main item categories (`kathgories`).
`categories`	`id`	Row id	integer
`categories`	`name`	Name	string
`categories`	`order`	Sort order	integer
`categories`	`modified`	Modified	string (datetime)
`categories`	`color`	Color	integer
`subcategories`		Item subcategories (`omades`).
`subcategories`	`id`	Row id	integer
`subcategories`	`name`	Name	string
`subcategories`	`category_id`	Main category id	integer
`subcategories`	`order`	Sort order	integer
`subcategories`	`accounting_code`	Accounting code	string
`subcategories`	`accounting_number`	Accounting number	string
`subcategories`	`modified`	Modified	string (datetime)
`subcategories`	`color`	Color	integer
`subcategories`	`scale_category`	Scale category	integer
`subcategories`	`button_width`	Button width	integer
`subcategories`	`per_item`	Per item	integer
`payment_methods`		Payment methods (`diakanonismos`).
`payment_methods`	`id`	Row id	integer
`payment_methods`	`name`	Name	string
`payment_methods`	`other_payment_title`	Other payment title	string
`payment_methods`	`settled`	Settled	integer
`payment_methods`	`order`	Sort order	integer
`payment_methods`	`accounting_code`	Accounting code	string
`payment_methods`	`accounting_number`	Accounting number	string
`payment_methods`	`days_notify`	Days notify	integer
`payment_methods`	`tax_payment`	tax_payment	integer
`payment_methods`	`cashier_id`	Cashier id	integer
`calendar_types`		Calendar event types (`typosrantevou`).
`calendar_types`	`id`	Row id	integer
`calendar_types`	`name`	Title	string
`calendar_types`	`color`	Color	integer
`cashiers_positions`		Cashier positions (`tameia`).
`cashiers_positions`	`id`	Row id	integer
`cashiers_positions`	`name`	Name	string
`cashiers_positions`	`related_id`	Related id	integer
`cashiers_positions`	`issue`	Issue	integer
`cashiers_positions`	`order`	Sort order	integer