* rowid entity datec tms fk_pcg_version pcg_type account_number account_parent label labelshort fk_accounting_category fk_user_author fk_user_modif active centralized reconcilable import_key extraparams

* rowid label code description fk_axis active entity date_start date_end datec tms fk_user_author fk_user_modif import_key

* rowid label code active entity datec tms fk_user_author fk_user_modif import_key

* rowid fk_source_line sourcetype fk_analytic_account percentage amount entity datec tms fk_user_author fk_user_modif import_key

* rowid entity ref piece_num doc_date doc_type doc_ref fk_doc fk_docdet thirdparty_code subledger_account subledger_label numero_compte label_compte label_operation debit credit montant sens multicurrency_amount multicurrency_code matching_general lettering_code date_lettering date_lim_reglement fk_user_author fk_user_modif date_creation tms fk_user code_journal journal_label date_validated date_export import_key extraparams

* rowid entity ref tms datec datep statut note_private note_public fk_user_author fk_user_modif fk_user_valid fk_user_closing import_key extraparams

* rowid ref entity doc_date doc_type doc_ref fk_doc fk_docdet thirdparty_code subledger_account subledger_label numero_compte label_compte label_operation debit credit montant sens multicurrency_amount multicurrency_code matching_general lettering_code date_lettering date_lim_reglement fk_user_author fk_user_modif date_creation tms fk_user code_journal journal_label piece_num date_validated import_key extraparams

* rowid fk_accounting_category fk_accounting_account

* rowid label date_start date_end statut entity datec tms fk_user_author fk_user_modif

* rowid fk_accounting_account fk_c_accounting_category

* rowid entity code label nature active

* rowid fk_country pcg_version label active date_creation fk_user_author

* id ref ref_ext entity datep datep2 fk_action code datec tms fk_user_author fk_user_mod fk_project fk_task fk_soc fk_contact fk_parent fk_user_action transparency priority visibility fulldayevent percent location durationp label note calling_duration email_subject email_msgid email_from email_sender email_to email_tocc email_tobcc errors_to reply_to recurid recurrule recurdateend num_vote event_paid status fk_element elementtype ip fk_bookcal_calendar import_key extraparams

* rowid tms fk_object import_key

* rowid dateremind typeremind fk_user offsetvalue offsetunit status datedone lasterror entity fk_actioncomm fk_email_template

* rowid fk_actioncomm element_type fk_element answer_status mandatory transparency

* rowid ref entity ref_ext gender civility lastname firstname login pass pass_crypted fk_adherent_type morphy societe fk_soc address zip town state_id country email url socialnetworks phone phone_perso phone_mobile birth birth_place photo statut public datefin default_lang note_private note_public model_pdf datevalid datec tms fk_user_author fk_user_mod fk_user_valid canvas ip import_key

* rowid tms fk_object import_key

* rowid entity tms statut libelle morphy duration subscription amount caneditamount vote note mail_valid

* rowid tms fk_object import_key

* rowid fk_type lang label description email import_key

* rowid datec tms datev dateo amount amount_main_currency label fk_account fk_user_author fk_user_rappro fk_type num_releve num_chq numero_compte rappro note fk_bordereau position banque emetteur author origin_id origin_type import_key

* rowid datec tms ref label entity fk_user_author fk_user_modif bank code_banque code_guichet number cle_rib bic bic_intermediate iban_prefix country_iban cle_iban domiciliation pti_in_ctti state_id fk_pays proprio owner_address owner_zip owner_town owner_country_id courant clos rappro url account_number fk_accountancy_journal currency_code min_allowed min_desired comment note_public model_pdf import_key extraparams ics ics_transfer

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid fk_bank url_id url label type

* rowid module_source action entity date_creation amounts amounts_taxexcl ref_object date_object user_fullname linktoref linktype object_data signature element fk_user fk_object object_version object_format certified actionrefisunique tms debuginfo

* rowid entity ref bomtype label fk_product description note_public note_private fk_warehouse qty efficiency duration date_creation date_valid tms fk_user_creat fk_user_modif fk_user_valid import_key model_pdf last_main_doc status

* rowid fk_bom fk_product fk_bom_child tms description import_key qty qty_frozen disable_stock_change efficiency fk_unit position fk_default_workstation

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid fk_user dateb url target title favicon position entity

* rowid ref label ref_ext type datec date_bordereau amount nbcheque fk_bank_account fk_user_author statut tms note entity

* rowid entity box_id position box_order fk_user maxline params

* rowid file entity fk_user tms note

* rowid entity fk_parent label ref_ext type description color fk_soc extraparams date_creation fk_user_creat fk_user_modif tms visible position import_key

* rowid tms fk_object import_key

* fk_categorie fk_account import_key

* fk_categorie fk_actioncomm import_key

* fk_categorie fk_socpeople import_key

* fk_categorie fk_soc import_key

* fk_categorie fk_invoice import_key

* fk_categorie fk_knowledgemanagement import_key

* rowid fk_category lang label description

* fk_categorie fk_member import_key

* fk_categorie fk_order import_key

* fk_categorie fk_product import_key

* fk_categorie fk_project import_key

* fk_categorie fk_propal

* fk_categorie fk_soc import_key

* fk_categorie fk_supplier_invoice import_key

* fk_categorie fk_supplier_order import_key

* fk_categorie fk_ticket import_key

* fk_categorie fk_user import_key

* fk_categorie fk_warehouse import_key

* lineid fk_categ import_key

* rowid ref date_ech libelle entity tms date_creation date_valid fk_user fk_user_author fk_user_modif fk_user_valid fk_type fk_account fk_mode_reglement amount paye periode fk_projet note_private note_public import_key

* rowid ref entity ref_ext ref_client fk_soc fk_projet tms date_creation date_valid date_cloture date_commande fk_user_author fk_user_modif fk_user_valid fk_user_cloture source fk_statut amount_ht remise_percent remise_absolue remise total_tva localtax1 localtax2 revenuestamp total_ht total_ttc signed_status note_private note_public model_pdf last_main_doc module_source pos_source facture fk_account fk_currency fk_cond_reglement deposit_percent fk_mode_reglement date_livraison fk_shipping_method fk_warehouse fk_availability fk_input_reason fk_delivery_address fk_incoterms location_incoterms import_key extraparams fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc ip user_agent

* rowid fk_commande fk_parent_line fk_product label description vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent remise fk_remise_except price subprice subprice_ttc total_ht total_tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits buy_price_ht fk_product_fournisseur_price special_code rang fk_unit import_key ref_ext fk_commandefourndet fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid ref entity ref_ext ref_supplier fk_soc fk_projet tms date_creation date_valid date_approve date_approve2 date_commande fk_user_author fk_user_modif fk_user_valid fk_user_approve fk_user_approve2 source fk_statut billed amount_ht remise_percent remise total_tva localtax1 localtax2 total_ht total_ttc note_private note_public model_pdf last_main_doc date_livraison date_reception fk_account fk_cond_reglement deposit_percent fk_mode_reglement fk_input_method fk_incoterms location_incoterms import_key extraparams fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc

* rowid fk_commande fk_parent_line fk_product ref label description vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent remise subprice subprice_ttc total_ht total_tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits special_code rang import_key fk_unit fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid tms datelog fk_commande fk_statut fk_user comment

* rowid datec tms description fk_user_author fk_user_modif fk_element element_type entity import_key

* rowid name entity value type visible note tms

* rowid ref ref_customer ref_supplier ref_ext entity tms datec date_contrat statut fin_validite date_cloture fk_soc fk_projet fk_commercial_signature fk_commercial_suivi fk_user_author fk_user_modif fk_user_cloture total_tva localtax1 localtax2 revenuestamp total_ht total_ttc denormalized_lower_planned_end_date signed_status online_sign_ip online_sign_name note_private note_public model_pdf last_main_doc import_key extraparams

* rowid tms fk_contrat fk_product statut label description fk_remise_except date_commande date_ouverture_prevue date_ouverture date_fin_validite date_cloture vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent subprice subprice_ttc total_ht total_tva total_localtax1 total_localtax2 total_ttc product_type info_bits rang buy_price_ht fk_product_fournisseur_price fk_user_author fk_user_ouverture fk_user_cloture commentaire fk_unit fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid tms datec jobtype label command classesname objectname methodename params md5params module_name priority datelastrun datenextrun datestart dateend datelastresult lastresult lastoutput unitfrequency frequency maxrun nbrun autodelete status processing pid test fk_user_author fk_user_mod fk_mailing note libname email_alert entity

* rowid entity fk_report code label range_account sens category_type formula position fk_country active

* rowid entity code label fk_country active

* id code type libelle module active todo color picto position

* rowid elementtype code contexts label description rang

* rowid code label type_duration qty active position

* rowid code entity libelle coder example

* id libelle deductible active code accountancy_code fk_pays module

* rowid code label active module

* rowid code code_iso numeric_code label eec sepa active favorite

* code_iso label unicode active max_decimal_unit max_decimal_tot

* rowid code_departement fk_region cheflieu tncc ncc nom active

* rowid code label price organization fk_pays active

* id code libelle active module

* rowid entity private date_creation tms label email signature position active

* rowid entity module type_template lang private fk_user datec tms label position defaultfortype enabled active email_from email_to email_tocc email_tobcc topic joinfiles content content_lines

* rowid label entity active

* rowid fk_c_exp_tax_cat range_ik entity active

* rowid tms element entity name alias title align sort search visible enabled rang

* rowid code name paper_size orientation metric leftmargin topmargin nx ny spacex spacey width height font_size custom_x custom_y active

* rowid code fk_pays libelle isvatexempted active module position

* rowid entity code label affect delay newbymonth fk_country block_if_negative sortorder active

* rowid pos code label active

* rowid pos code label c_level active

* id entity fk_country fk_departement code dayrule day month year active import_key

* rowid code label libelle active

* rowid code libelle active module

* rowid code label active module

* rowid entity fk_country code label active

* rowid code label position percent active

* id entity code libelle type active accountancy_code module position

* rowid code label width height unit active module

* rowid entity code label keyword active

* rowid entity code sortorder active libelle libelle_facture type_cdr nbjour decalage deposit_percent module position

* rowid code label active

* rowid code label active

* id code label sortorder active

* code label sortorder active module

* code label sortorder active module

* rowid code label active

* rowid code_region fk_pays cheflieu tncc nom active

* rowid fk_pays taux revenuestamp_type note active accountancy_code_sell accountancy_code_buy

* rowid entity tms code libelle description tracking active module

* rowid label description active entity

* rowid entity code label url icon active

* id code libelle picto sortorder active

* id code libelle picto active

* rowid entity code label public use_default fk_parent force_severity description pos active

* rowid entity code pos label active use_default description

* rowid entity code pos label color active use_default description

* rowid entity code pos label active use_default description

* rowid entity code label active

* rowid entity fk_pays fk_department_buyer code type_vat taux localtax1 localtax1_type localtax2 localtax2_type use_default recuperableonly note active accountancy_code_sell accountancy_code_buy

* id code libelle fk_country active module position

* rowid element source code libelle active module position

* id code label type accountancy_code active module position

* rowid code label active

* rowid code sortorder scale label short_label unit_type active

* rowid code fk_county fk_pays zip town town_up active

* rowid entity type user_id page param value

* rowid tms ref entity fk_soc ref_ext ref_customer date_creation fk_user_author date_valid fk_user_valid date_delivery fk_address fk_statut total_ht note_private note_public model_pdf last_main_doc fk_incoterms location_incoterms import_key extraparams

* rowid fk_delivery fk_origin_line fk_product description qty subprice subprice_ttc total_ht rang extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid nom entity type libelle tms description

* rowid ref entity tms fk_statut datedon amount fk_payment paid fk_soc firstname lastname societe address zip town country fk_country email phone phone_mobile public fk_projet datec fk_user_author fk_user_modif date_valid fk_user_valid note_private note_public model_pdf import_key extraparams ip

* rowid tms fk_object import_key

* rowid label entity fk_parent description cachenbofdoc fullpath extraparams date_c tms fk_user_c fk_user_m note_private note_public acl

* rowid tms fk_object import_key

* rowid ref label share share_pass entity filepath filename src_object_type src_object_id agenda_id fullpath_orig description keywords content cover position gen_or_uploaded extraparams date_c tms fk_user_c fk_user_m note_private note_public acl geolat geolong geopoint georesultcode

* rowid tms fk_object import_key

* rowid fk_categorie fk_element import_key

* rowid datecreate statut element_id mandatory_signature fk_c_type_contact fk_socpeople

* rowid fk_source sourcetype fk_target targettype relationtype

* rowid element_id element_type resource_id resource_type busy mandatory duree fk_user_create tms

* rowid ref_ext fk_element elementtype element_date element_datehour element_date_withhour element_duration fk_product fk_user thm invoice_id invoice_line_id intervention_id intervention_line_id import_key datec tms note

* rowid entity ref label description host port hostcharset imap_encryption norsh login acces_type oauth_service password source_directory target_directory maxemailpercollect datelastresult codelastresult lastresult datelastok note_public note_private date_creation tms fk_user_creat fk_user_modif position import_key status

* rowid fk_emailcollector type actionparam date_creation tms fk_user_creat fk_user_modif position import_key status

* rowid fk_emailcollector type rulevalue date_creation tms fk_user_creat fk_user_modif import_key status

* rowid ref datec tms entity fk_project description lieu address zip town fk_departement fk_pays phone fax barcode fk_barcode_type warehouse_usage statut fk_user_author model_pdf import_key fk_parent

* rowid tms fk_object import_key

* rowid entity ref label name address zip town fk_state fk_country profid1 profid2 profid3 phone fk_user_author fk_user_mod datec tms status

* rowid ref fk_soc fk_actioncomm fk_project fk_invoice email email_company firstname lastname date_subscription amount note_public note_private date_creation tms fk_user_creat fk_user_modif last_main_doc ip import_key model_pdf status

* rowid tms fk_object import_key

* rowid tms type entity prefix_session dateevent fk_user description ip user_agent fk_object authentication_method fk_oauth_token

* rowid tms ref entity fk_soc fk_projet ref_ext ref_customer date_creation fk_user_author fk_user_modif date_valid fk_user_valid date_delivery date_expedition fk_address fk_shipping_method tracking_number fk_statut billed height width size_units size weight_units weight signed_status online_sign_ip online_sign_name note_private note_public model_pdf last_main_doc fk_incoterms location_incoterms import_key extraparams

* rowid fk_expedition fk_element fk_elementdet element_type fk_product fk_parent qty fk_unit fk_entrepot description rang extraparams

* rowid fk_expeditiondet eatby sellby batch qty fk_origin_stock fk_warehouse

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid fk_expedition description value fk_package_type height width size size_units weight weight_units dangerous_goods tail_lift rang

* rowid ref entity ref_number_int ref_ext total_ht total_tva localtax1 localtax2 total_ttc date_debut date_fin date_create date_valid date_approve date_refuse date_cancel tms fk_user_author fk_user_creat fk_user_modif fk_user_valid fk_user_validator fk_user_approve fk_user_refuse fk_user_cancel fk_statut fk_c_paiement paid note_public note_private detail_refuse detail_cancel integration_compta fk_bank_account model_pdf last_main_doc fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc import_key extraparams

* rowid fk_expensereport docnumber fk_c_type_fees fk_c_exp_tax_cat fk_projet comments product_type qty subprice subprice_ttc value_unit remise_percent vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type total_ht total_tva total_localtax1 total_localtax2 total_ttc date info_bits special_code fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc fk_facture fk_ecm_files fk_code_ventilation rang import_key rule_warning_message

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid datec tms fk_c_exp_tax_cat fk_range coef ikoffset active

* rowid datec tms dates datee amount restrictive fk_user fk_usergroup fk_c_type_fees code_expense_rules_type is_for_all entity

* rowid entity fk_user label type field filter

* rowid name entity elementtype label type size fieldcomputed fielddefault fieldunique fieldrequired perms enabled module pos alwayseditable emptyonclone param list printable totalizable langs help aiprompt css cssview csslist fk_user_author fk_user_modif datec tms

* rowid ref entity ref_ext ref_client type subtype fk_soc datec datef date_pointoftax date_valid tms date_closing paye remise_percent remise_absolue remise close_code close_missing_amount close_note total_tva localtax1 localtax2 revenuestamp total_ht total_ttc fk_statut fk_user_author fk_user_modif fk_user_valid fk_user_closing module_source pos_source pos_print_counter email_sent_counter fk_fac_rec_source fk_facture_source fk_projet increment fk_account fk_currency fk_cond_reglement fk_mode_reglement date_lim_reglement payment_reference dispute_status note_private note_public model_pdf last_main_doc fk_input_reason fk_incoterms location_incoterms fk_transport_mode prorata_discount situation_cycle_ref situation_counter situation_final retained_warranty retained_warranty_date_limit retained_warranty_fk_cond_reglement import_key extraparams is_also_delivery_note fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc ip

* rowid fk_facture fk_parent_line fk_product label description vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent remise fk_remise_except subprice subprice_ttc price total_ht total_tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits buy_price_ht fk_product_fournisseur_price batch fk_warehouse special_code rang fk_contract_line fk_unit import_key fk_code_ventilation situation_percent fk_prev_id fk_user_author fk_user_modif fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc ref_ext extraparams

* rowid tms fk_object import_key

* rowid fk_facture fk_parent_line fk_product product_type label description vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent remise subprice subprice_ttc price total_ht total_tva total_localtax1 total_localtax2 total_ttc date_start_fill date_end_fill info_bits buy_price_ht fk_product_fournisseur_price special_code rang fk_contract_line fk_unit import_key fk_user_author fk_user_modif fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid ref ref_supplier entity ref_ext type subtype fk_soc datec datef date_pointoftax date_valid tms date_closing libelle paye amount remise close_code close_missing_amount close_note vat_reverse_charge tva total_tva localtax1 localtax2 revenuestamp total_ht total_ttc fk_statut fk_user_author fk_user_modif fk_user_valid fk_user_closing fk_fac_rec_source fk_facture_source fk_projet fk_account fk_cond_reglement fk_mode_reglement date_lim_reglement note_private note_public fk_incoterms location_incoterms fk_transport_mode model_pdf last_main_doc import_key extraparams fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc

* rowid fk_facture_fourn fk_parent_line fk_product ref label description pu_ht pu_ttc qty remise_percent fk_remise_except vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type total_ht tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits fk_code_ventilation special_code rang import_key fk_unit fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc extraparams

* rowid tms fk_object import_key

* rowid fk_facture_fourn fk_parent_line fk_product ref label description pu_ht pu_ttc qty remise_percent fk_remise_except vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type total_ht total_tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits special_code rang fk_unit import_key fk_user_author fk_user_modif fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid titre ref_supplier entity subtype fk_soc datec tms suspended libelle amount remise vat_src_code localtax1 localtax2 total_ht total_tva total_ttc fk_user_author fk_user_modif fk_projet fk_account fk_cond_reglement fk_mode_reglement date_lim_reglement note_private note_public modelpdf fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc usenewprice usenewcurrencyrate frequency unit_frequency date_when date_last_gen nb_gen_done nb_gen_max auto_validate generate_pdf

* rowid tms fk_object import_key

* rowid titre entity subtype fk_soc datec tms suspended amount remise remise_percent remise_absolue vat_src_code total_tva localtax1 localtax2 revenuestamp total_ht total_ttc fk_user_author fk_user_modif fk_projet fk_cond_reglement fk_mode_reglement date_lim_reglement fk_account fk_societe_rib note_private note_public modelpdf fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc usenewprice usenewcurrencyrate frequency unit_frequency rule_for_lines_dates date_when date_last_gen nb_gen_done nb_gen_max auto_validate generate_pdf

* rowid tms fk_object import_key

* rowid fk_soc fk_projet fk_contrat ref ref_ext ref_client entity tms datec date_valid datei fk_user_author fk_user_modif fk_user_valid fk_statut dateo datee datet duree description signed_status online_sign_ip online_sign_name note_private note_public model_pdf last_main_doc import_key extraparams

* rowid fk_fichinter fk_parent_line special_code product_type date description duree rang extraparams

* rowid tms fk_object import_key

* rowid fk_fichinter date description duree rang total_ht subprice subprice_ttc fk_parent_line fk_product label tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent fk_remise_except price total_tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits buy_price_ht fk_product_fournisseur_price fk_code_ventilation special_code fk_unit import_key extraparams

* rowid tms fk_object import_key

* rowid title entity fk_soc datec fk_contrat fk_user_author fk_projet duree description modelpdf note_private note_public frequency unit_frequency date_when date_last_gen nb_gen_done nb_gen_max auto_validate status

* rowid ref ref_ext entity fk_user fk_user_create fk_user_modif fk_type date_create description date_debut date_fin halfday nb_open_day statut fk_validator date_valid fk_user_valid date_approval fk_user_approve date_refuse fk_user_refuse date_cancel fk_user_cancel detail_refuse note_private note_public tms import_key extraparams

* rowid entity name value

* rowid tms fk_object import_key

* rowid date_action fk_user_action fk_user_update fk_type type_action prev_solde new_solde

* fk_user fk_type nb_holiday

* rowid entity ref label description note_public note_private model_pdf last_main_doc date_creation tms fk_user_creat fk_user_modif import_key status date_eval fk_user fk_job

* rowid date_creation tms fk_user_creat fk_user_modif fk_skill fk_evaluation rankorder required_rank comment import_key

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid label description date_creation tms deplacement note_public note_private fk_user_creat fk_user_modif

* rowid tms fk_object import_key

* rowid description date_creation tms fk_contrat fk_user fk_job date_start date_end abort_comment note_public note_private fk_user_creat fk_user_modif

* rowid label description date_creation tms fk_user_creat fk_user_modif required_level date_validite temps_theorique skill_type note_public note_private

* rowid fk_skill rankorder description fk_user_creat fk_user_modif

* rowid fk_skill rankorder fk_object date_creation tms fk_user_creat fk_user_modif objecttype

* rowid tms fk_object import_key

* rowid entity fk_user label type field

* rowid entity ref date_creation tms fk_user_creat fk_user_modif fk_user_valid fk_warehouse fk_product categories_product status title date_inventory date_validation import_key

* rowid datec tms fk_inventory fk_warehouse fk_product batch qty_stock qty_view qty_regulated pmp_real pmp_expected fk_movement

* rowid tms fk_object import_key

* rowid entity ref date_creation tms last_main_doc lang fk_user_creat fk_user_modif fk_user_valid import_key model_pdf question answer url fk_ticket fk_c_ticket_category status

* rowid tms fk_object import_key

* rowid entity datea url label objecttype objectid share share_pass

* rowid entity datec tms label fk_bank capital insurance_amount datestart dateend nbterm rate note_private note_public capital_position date_position paid accountancy_account_capital accountancy_account_insurance accountancy_account_interest fk_projet fk_user_author fk_user_modif active

* rowid fk_loan datec tms datep amount_capital amount_insurance amount_interest fk_typepayment num_payment note_private note_public fk_bank fk_payment_loan fk_user_creat fk_user_modif

* rowid entity localtaxtype tms datep datev amount label note fk_bank fk_user_creat fk_user_modif

* rowid entity email unsubscribegroup ip date_creat tms

* rowid menu_handler entity module type mainmenu leftmenu fk_menu fk_mainmenu fk_leftmenu position url showtopmenuinframe target titre prefix langs level perms enabled usertype tms

* rowid entity ref mrptype label qty fk_warehouse fk_soc note_public note_private date_creation date_valid tms fk_user_creat fk_user_modif fk_user_valid import_key model_pdf status fk_product date_start_planned date_end_planned fk_bom fk_project last_main_doc fk_parent_line extraparams

* rowid tms fk_object import_key

* rowid fk_mo origin_id origin_type position fk_product fk_warehouse qty qty_frozen disable_stock_change batch role fk_mrp_production fk_stock_movement date_creation tms fk_user_creat fk_user_modif import_key fk_default_workstation fk_unit

* rowid tms fk_object import_key

* rowid date_create code name entity fk_user tms

* rowid date_sync rate rate_indirect fk_multicurrency entity tms

* rowid tms daten fk_action fk_soc fk_contact fk_user type type_target objet_type objet_id email

* rowid entity tms datec fk_action fk_soc fk_contact fk_user email threshold context type

* id entity objet_type objet_id type_notif date_notif user_id moreparam

* rowid service state fk_user fk_adherent entity

* rowid service token tokenstring tokenstring_refresh expire_at state fk_soc fk_user fk_adherent restricted_ips datec tms entity lastaccess apicount_previous_month apicount_month apicount_total

* rowid fk_object type_object property lang value import_key

* rowid entity object_type object_id datec tms name ip pathoffile

* id_comment id_sondage comment tms usercomment date_creation ip

* rowid id_sondage question available_answers

* id_sondage entity commentaires mail_admin nom_admin fk_user_creat titre date_fin status format mailsonde allow_comments allow_spy tms sujet

* fk_user_survey fk_question reponses

* id_users nom id_sondage reponses tms date_creation ip

* rowid entity lang transkey transvalue

* rowid ref ref_ext entity datec tms datep amount multicurrency_amount fk_paiement num_paiement note ext_payment_id ext_payment_site fk_bank fk_user_creat fk_user_modif statut fk_export_compta pos_change

* rowid fk_charge datec tms datep amount fk_typepaiement num_paiement note fk_bank fk_user_creat fk_user_modif

* rowid ref entity tms datec datep amount multicurrency_amount fk_user_author fk_user_modif fk_paiement num_paiement note fk_bank statut model_pdf

* rowid fk_paiementfourn fk_facturefourn amount multicurrency_code multicurrency_tx multicurrency_amount

* rowid tms fk_object import_key

* rowid fk_paiement fk_facture amount multicurrency_code multicurrency_tx multicurrency_amount

* rowid entity ref status fk_type fk_soc fk_member email_partnership date_partnership_start date_partnership_end reason_decline_or_cancel date_creation fk_user_creat tms fk_user_modif note_private note_public last_main_doc url_to_check count_last_url_check_error last_check_backlink ip import_key model_pdf

* rowid tms fk_object import_key

* rowid fk_payment fk_expensereport amount multicurrency_code multicurrency_tx multicurrency_amount

* rowid fk_donation datec tms datep amount fk_typepayment num_payment note ext_payment_id ext_payment_site fk_bank fk_user_creat fk_user_modif

* rowid fk_expensereport datec tms datep amount fk_typepayment num_payment note fk_bank fk_user_creat fk_user_modif

* rowid fk_loan datec tms datep amount_capital amount_insurance amount_interest fk_typepayment num_payment note_private note_public fk_bank fk_user_creat fk_user_modif

* rowid ref tms datec fk_user datep datev salary amount fk_projet fk_typepayment num_payment label datesp dateep entity note fk_bank fk_user_author fk_user_modif fk_salary

* rowid ref num_payment label tms datec datep datev sens amount fk_typepayment accountancy_code subledger_account fk_projet entity note fk_bank fk_user_author fk_user_modif

* rowid fk_tva datec tms datep amount fk_typepaiement num_paiement note fk_bank fk_user_creat fk_user_modif

* rowid entity ref label opening cash card cheque cash_declared card_declared cheque_declared cash_lifetime card_lifetime cheque_lifetime lifetime_start status date_creation date_valid day_close month_close year_close hour_close min_close sec_close posmodule posnumber fk_user_creat fk_user_valid tms import_key

* rowid tms fk_object import_key

* rowid fk_facture fk_facture_fourn fk_salary fk_prelevement_lignes

* rowid type ref entity datec amount statut credite note date_trans method_trans fk_user_trans date_credit fk_user_credit fk_bank_account

* rowid entity fk_facture fk_facture_fourn fk_salary sourcetype amount date_demande traite date_traite fk_prelevement_bons fk_user_demande fk_societe_rib code_banque code_guichet number cle_rib type ext_payment_id ext_payment_site

* rowid fk_prelevement_bons fk_soc fk_user statut client_nom amount code_banque code_guichet number cle_rib bic iban rum note tms

* rowid fk_prelevement_lignes date_rejet motif date_creation fk_user_creation note afacturer fk_facture

* rowid tms datec printer_name printer_location printer_id copy module driver userid

* rowid ref entity ref_ext datec tms fk_parent label description note_public note customcode fk_country fk_state price price_ttc price_min price_min_ttc price_base_type price_label cost_price default_vat_code tva_tx recuperableonly localtax1_tx localtax1_type localtax2_tx localtax2_type fk_user_author fk_user_modif tosell tobuy tobatch sell_or_eat_by_mandatory batch_mask fk_product_type duration seuil_stock_alerte url barcode fk_barcode_type accountancy_code_sell accountancy_code_sell_intra accountancy_code_sell_export accountancy_code_buy accountancy_code_buy_intra accountancy_code_buy_export partnumber net_measure net_measure_units weight weight_units length length_units width width_units height height_units surface surface_units volume volume_units stockable_product stock pmp fifo lifo fk_default_warehouse fk_default_bom fk_default_workstation canvas finished lifetime qc_frequency hidden import_key model_pdf fk_price_expression desiredstock fk_unit price_autogen fk_project mandatory_period last_main_doc packaging

* rowid fk_product_pere fk_product_fils qty incdec rang import_key

* rowid ref ref_ext label position entity

* rowid fk_product_parent fk_product_child variation_price variation_price_percentage variation_weight variation_ref_ext entity

* rowid fk_prod_combination fk_prod_attr fk_prod_attr_val

* rowid fk_product_attribute_combination fk_price_level variation_price variation_price_percentage

* rowid tms fk_object import_key

* rowid fk_product_attribute ref value entity position

* rowid tms fk_object import_key

* rowid tms fk_product_stock eatby sellby batch qty import_key

* rowid entity datec tms fk_product fk_soc ref_customer date_begin date_end price price_ttc price_min price_min_ttc price_base_type default_vat_code tva_tx recuperableonly localtax1_tx localtax1_type localtax2_tx localtax2_type discount_percent fk_user price_label import_key

* rowid tms fk_object import_key

* rowid entity datec fk_product fk_soc ref_customer date_begin date_end price price_ttc price_min price_min_ttc price_base_type default_vat_code tva_tx recuperableonly localtax1_tx localtax1_type localtax2_tx localtax2_type discount_percent fk_user price_label import_key

* rowid tms fk_object import_key

* rowid entity datec tms fk_product fk_soc ref_fourn desc_fourn fk_availability price quantity remise_percent remise unitprice charges default_vat_code barcode fk_barcode_type tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type info_bits fk_user fk_supplier_price_expression delivery_time_days supplier_reputation packaging fk_multicurrency multicurrency_code multicurrency_tx multicurrency_unitprice multicurrency_price import_key status

* rowid tms fk_object import_key

* rowid datec fk_product_fournisseur price quantity fk_user fk_multicurrency multicurrency_code multicurrency_tx multicurrency_unitprice multicurrency_price

* rowid fk_product lang label description note import_key

* rowid entity fk_product batch note_public note_private eatby sellby eol_date manufacturing_date scrapping_date qc_frequency lifetime barcode fk_barcode_type model_pdf last_main_doc datec tms fk_user_creat fk_user_modif import_key

* rowid tms fk_object import_key

* rowid entity tms fk_product date_price price_level price price_ttc price_min price_min_ttc price_base_type default_vat_code tva_tx recuperableonly localtax1_tx localtax1_type localtax2_tx localtax2_type fk_user_author price_label tosell price_by_qty fk_price_expression import_key fk_multicurrency multicurrency_code multicurrency_tx multicurrency_price multicurrency_price_ttc

* rowid level fk_level var_percent var_min_percent

* rowid fk_product_price price price_base_type quantity remise_percent remise unitprice fk_user_creat fk_user_modif fk_multicurrency multicurrency_code multicurrency_tx multicurrency_price multicurrency_price_ttc tms import_key

* rowid tms fk_object import_key

* rowid tms fk_product fk_entrepot reel import_key

* rowid fk_product fk_soc fk_product_thirdparty_relation_type date_start date_end fk_project description note_public note_private date_creation tms fk_user_creat fk_user_modif last_main_doc import_key model_pdf status

* rowid tms fk_product fk_entrepot seuil_stock_alerte desiredstock import_key

* rowid fk_project fk_soc datec tms dateo datee ref ref_ext entity title description fk_user_creat fk_user_modif public fk_statut fk_opp_status opp_percent fk_opp_status_end date_close fk_user_close note_private note_public email_msgid email_date opp_amount budget_amount usage_opportunity usage_task usage_bill_time usage_organize_event date_start_event date_end_event location accept_conference_suggestions accept_booth_suggestions max_attendees price_registration price_booth model_pdf ip last_main_doc import_key extraparams

* rowid tms fk_object import_key

* rowid ref entity fk_projet fk_task_parent datec tms dateo datee datev label description duration_effective planned_workload progress priority budget_amount fk_user_creat fk_user_modif fk_user_valid fk_statut note_private note_public rang model_pdf import_key billable

* rowid tms fk_object import_key

* rowid ref entity ref_ext ref_client fk_soc fk_projet tms datec datep fin_validite date_valid date_signature date_cloture fk_user_author fk_user_modif fk_user_valid fk_user_signature fk_user_cloture fk_statut price remise_percent remise_absolue remise total_ht total_tva localtax1 localtax2 total_ttc fk_account fk_currency fk_cond_reglement deposit_percent fk_mode_reglement online_sign_ip online_sign_name note_private note_public model_pdf model_pdf_pos_sign last_main_doc date_livraison fk_shipping_method fk_warehouse fk_availability fk_input_reason fk_incoterms location_incoterms import_key extraparams fk_delivery_address fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc

* rowid fk_propal fk_parent_line fk_product label description fk_remise_except vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent remise price subprice subprice_ttc total_ht total_tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits buy_price_ht fk_product_fournisseur_price special_code rang fk_unit fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc import_key extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid fk_product file_name lang fk_user_author fk_user_mod datec tms import_key

* rowid tms ref entity fk_soc fk_projet ref_ext ref_supplier date_creation fk_user_author fk_user_modif date_valid fk_user_valid date_delivery date_reception fk_shipping_method tracking_number fk_statut billed height width size_units size weight_units weight note_private note_public model_pdf fk_incoterms location_incoterms import_key extraparams

* rowid fk_reception fk_element fk_elementdet element_type fk_product description qty fk_unit fk_entrepot fk_projet comment batch eatby sellby status fk_user datec tms cost_price rang extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid entity ref fk_recruitmentjobposition description note_public note_private date_creation tms fk_user_creat fk_user_modif fk_user import_key model_pdf status firstname lastname email phone date_birth remuneration_requested remuneration_proposed email_msgid email_date fk_recruitment_origin ip

* rowid tms fk_object import_key

* rowid ref entity label qty fk_soc fk_project fk_user_recruiter email_recruiter fk_user_supervisor fk_establishment date_planned remuneration_suggested description note_public note_private date_creation tms fk_user_creat fk_user_modif last_main_doc import_key model_pdf status

* rowid tms fk_object import_key

* rowid entity ref asset_number description fk_code_type_resource address zip town photo_filename max_users phone email url datec date_valid fk_user_author fk_user_modif fk_user_valid fk_statut note_public note_private import_key extraparams fk_country fk_state tms

* rowid tms fk_object import_key

* id entity libelle module module_origin module_position family family_position perms subperms type bydefault enabled

* rowid ref ref_ext tms datec fk_user datep datev salary amount fk_projet fk_typepayment num_payment label datesp dateep entity note note_public fk_bank paye fk_account fk_user_author fk_user_modif

* rowid tms fk_object import_key

* rowid nom name_alias entity ref_ext statut parent status code_client code_fournisseur tp_payment_reference accountancy_code_customer_general code_compta accountancy_code_supplier_general code_compta_fournisseur address zip town fk_departement fk_pays geolat geolong geopoint georesultcode phone phone_mobile fax url email fk_account socialnetworks fk_effectif fk_typent fk_forme_juridique birth fk_currency siren siret ape idprof4 idprof5 idprof6 tva_intra capital fk_stcomm note_private note_public model_pdf last_main_doc prefix_comm client fournisseur supplier_account fk_prospectlevel fk_incoterms location_incoterms customer_bad customer_rate supplier_rate remise_client remise_supplier mode_reglement cond_reglement deposit_percent transport_mode mode_reglement_supplier cond_reglement_supplier transport_mode_supplier fk_shipping_method tva_assuj vatexemptcode vat_reverse_charge localtax1_assuj localtax1_value localtax2_assuj localtax2_value barcode fk_barcode_type price_level outstanding_limit order_min_amount supplier_order_min_amount default_lang logo logo_squarred canvas fk_warehouse webservices_url webservices_key accountancy_code_sell accountancy_code_buy datec tms fk_user_creat fk_user_modif fk_multicurrency multicurrency_code ip import_key

* rowid entity login pass_encoding pass_crypted pass_temp fk_soc fk_website site site_account key_account note_private date_last_login date_previous_login date_last_reset_password date_creation tms fk_user_creat fk_user_modif ip import_key status

* rowid fk_soc fk_user fk_c_type_contact_code import_key

* rowid entity date_creation fk_soc fk_c_type_contact fk_socpeople tms import_key

* rowid tms fk_object import_key

* rowid fk_soc tms datec fk_user_author price_level

* rowid entity fk_soc tms datec fk_user_author remise_client note

* rowid entity fk_soc discount_type datec amount_ht amount_tva amount_ttc tva_tx vat_src_code fk_user fk_facture_line fk_facture fk_facture_source fk_invoice_supplier_line fk_invoice_supplier fk_invoice_supplier_source description multicurrency_code multicurrency_tx multicurrency_amount_ht multicurrency_amount_tva multicurrency_amount_ttc

* rowid entity fk_soc tms datec fk_user_author remise_supplier note

* rowid entity type label fk_soc datec tms bank code_banque code_guichet number cle_rib bic bic_intermediate iban_prefix cci domiciliation proprio owner_address default_rib state_id fk_country currency_code model_pdf last_main_doc rum date_rum frstrecur last_four card_type cvn exp_date_month exp_date_year country_code approved email ending_date max_total_amount_of_all_payments preapproval_key starting_date total_amount_of_all_payments stripe_card_ref stripe_account ext_payment_site extraparams date_signature online_sign_ip online_sign_name comment ipaddress status import_key

* rowid datec tms fk_soc entity ref_ext name_alias fk_parent civility lastname firstname address zip town fk_departement fk_pays geolat geolong geopoint georesultcode birthday poste phone phone_perso phone_mobile fax url email socialnetworks photo no_email priv fk_prospectlevel fk_stcommcontact fk_user_creat fk_user_modif note_private note_public default_lang canvas import_key statut ip

* rowid tms fk_object import_key

* rowid tms datem fk_product batch eatby sellby fk_entrepot value price type_mouvement fk_user_author label inventorycode fk_project fk_origin origintype model_pdf fk_projet

* rowid tms fk_object import_key

* rowid tms datec fk_adherent fk_type dateadh datef subscription fk_bank fk_user_creat fk_user_valid ref_ext note note_private import_key

* rowid ref entity ref_ext fk_soc fk_projet tms datec date_valid date_cloture fk_user_author fk_user_modif fk_user_valid fk_user_cloture fk_statut price remise_percent remise_absolue remise total_ht total_tva localtax1 localtax2 total_ttc fk_account fk_currency fk_cond_reglement deposit_percent fk_mode_reglement note_private note_public model_pdf last_main_doc date_livraison fk_shipping_method import_key extraparams fk_multicurrency multicurrency_code multicurrency_tx multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc

* rowid fk_supplier_proposal fk_parent_line fk_product label description fk_remise_except vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type qty remise_percent remise price subprice subprice_ttc total_ht total_tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits buy_price_ht fk_product_fournisseur_price special_code rang ref_fourn fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc fk_unit extraparams

* rowid tms fk_object import_key

* rowid tms fk_object import_key

* rowid entity label leftpos toppos floor

* rowid entity ref track_id fk_soc fk_project fk_contract origin_email origin_replyto origin_references fk_user_create fk_user_assign subject message fk_statut note_public note_private fk_user_modif resolution progress timing type_code category_code severity_code datec date_read date_last_msg_sent date_close notify_tiers_at_create email_msgid email_date ip tms model_pdf last_main_doc extraparams barcode fk_barcode_type import_key

* rowid tms fk_object import_key

* rowid tms datec datep datev amount fk_typepayment num_payment label entity note paye fk_account fk_user_creat fk_user_modif import_key

* rowid entity ref_employee ref_ext admin employee fk_establishment datec tms fk_user_creat fk_user_modif login pass_encoding pass pass_crypted pass_temp api_key gender civility lastname firstname address zip town fk_state fk_country birth birth_place job office_phone office_fax user_mobile personal_mobile email personal_email email_oauth2 signature socialnetworks fk_soc fk_socpeople fk_member fk_user fk_user_expense_validator fk_user_holiday_validator national_registration_number idpers1 idpers2 idpers3 note_public note_private model_pdf last_main_doc datelastlogin datepreviouslogin datelastpassvalidation datestartvalidity dateendvalidity flagdelsessionsbefore iplastlogin ippreviouslogin ldap_sid openid statut photo lang color barcode fk_barcode_type accountancy_code_user_general accountancy_code nb_holiday thm tjm access_hours salary salaryextra dateemployment dateemploymentend weeklyhours import_key default_range default_c_exp_tax_cat fk_warehouse

* rowid nom entity datec tms color note model_pdf

* rowid tms fk_object import_key

* rowid entity fk_usergroup fk_id

* rowid entity fk_user fk_usergroup

* rowid type fk_contact fk_user

* fk_user url login pass poste

* rowid entity ref ref_ext fk_user datec tms fk_user_creat fk_user_modif job status salary salaryextra weeklyhours dateemployment dateemploymentend

* rowid tms fk_object import_key

* fk_user entity param value

* rowid fk_user entity datec tms label bank code_banque code_guichet number cle_rib bic bic_intermediate iban_prefix domiciliation proprio owner_address state_id fk_country currency_code default_rib

* rowid entity fk_user fk_id

* rowid ref label type note_public entity note_private date_creation tms fk_user_creat fk_user_modif import_key status nb_operators_required thm_operator_estimated thm_machine_estimated

* rowid tms fk_object import_key

* rowid tms fk_resource fk_workstation

* rowid tms fk_usergroup fk_workstation

Tabelle auswählen dbv_accounting_account dbv_accounting_analytic_account dbv_accounting_analytic_axis dbv_accounting_analytic_distribution dbv_accounting_bookkeeping dbv_accounting_bookkeeping_piece dbv_accounting_bookkeeping_tmp dbv_accounting_category_account dbv_accounting_fiscalyear dbv_accounting_groups_account dbv_accounting_journal dbv_accounting_system dbv_actioncomm dbv_actioncomm_extrafields dbv_actioncomm_reminder dbv_actioncomm_resources dbv_adherent dbv_adherent_extrafields dbv_adherent_type dbv_adherent_type_extrafields dbv_adherent_type_lang dbv_bank dbv_bank_account dbv_bank_account_extrafields dbv_bank_extrafields dbv_bank_url dbv_blockedlog dbv_bom_bom dbv_bom_bomline dbv_bom_bomline_extrafields dbv_bom_bom_extrafields dbv_bookmark dbv_bordereau_cheque dbv_boxes dbv_boxes_def dbv_categorie dbv_categories_extrafields dbv_categorie_account dbv_categorie_actioncomm dbv_categorie_contact dbv_categorie_fournisseur dbv_categorie_invoice dbv_categorie_knowledgemanagement dbv_categorie_lang dbv_categorie_member dbv_categorie_order dbv_categorie_product dbv_categorie_project dbv_categorie_propal dbv_categorie_societe dbv_categorie_supplier_invoice dbv_categorie_supplier_order dbv_categorie_ticket dbv_categorie_user dbv_categorie_warehouse dbv_category_bankline dbv_chargesociales dbv_commande dbv_commandedet dbv_commandedet_extrafields dbv_commande_extrafields dbv_commande_fournisseur dbv_commande_fournisseurdet dbv_commande_fournisseurdet_extrafields dbv_commande_fournisseur_extrafields dbv_commande_fournisseur_log dbv_comment dbv_const dbv_contrat dbv_contratdet dbv_contratdet_extrafields dbv_contrat_extrafields dbv_cronjob dbv_c_accounting_category dbv_c_accounting_report dbv_c_actioncomm dbv_c_action_trigger dbv_c_availability dbv_c_barcode_type dbv_c_chargesociales dbv_c_civility dbv_c_country dbv_c_currencies dbv_c_departements dbv_c_ecotaxe dbv_c_effectif dbv_c_email_senderprofile dbv_c_email_templates dbv_c_exp_tax_cat dbv_c_exp_tax_range dbv_c_field_list dbv_c_format_cards dbv_c_forme_juridique dbv_c_holiday_types dbv_c_hrm_department dbv_c_hrm_function dbv_c_hrm_public_holiday dbv_c_incoterms dbv_c_input_method dbv_c_input_reason dbv_c_invoice_subtype dbv_c_lead_status dbv_c_paiement dbv_c_paper_format dbv_c_partnership_type dbv_c_payment_term dbv_c_product_nature dbv_c_product_thirdparty_relation_type dbv_c_propalst dbv_c_prospectcontactlevel dbv_c_prospectlevel dbv_c_recruitment_origin dbv_c_regions dbv_c_revenuestamp dbv_c_shipment_mode dbv_c_shipment_package_type dbv_c_socialnetworks dbv_c_stcomm dbv_c_stcommcontact dbv_c_ticket_category dbv_c_ticket_resolution dbv_c_ticket_severity dbv_c_ticket_type dbv_c_transport_mode dbv_c_tva dbv_c_typent dbv_c_type_contact dbv_c_type_fees dbv_c_type_resource dbv_c_units dbv_c_ziptown dbv_default_values dbv_delivery dbv_deliverydet dbv_deliverydet_extrafields dbv_delivery_extrafields dbv_document_model dbv_don dbv_don_extrafields dbv_ecm_directories dbv_ecm_directories_extrafields dbv_ecm_files dbv_ecm_files_extrafields dbv_element_categorie dbv_element_contact dbv_element_element dbv_element_resources dbv_element_time dbv_emailcollector_emailcollector dbv_emailcollector_emailcollectoraction dbv_emailcollector_emailcollectorfilter dbv_entrepot dbv_entrepot_extrafields dbv_establishment dbv_eventorganization_conferenceorboothattendee dbv_eventorganization_conferenceorboothattendee_extrafields dbv_events dbv_expedition dbv_expeditiondet dbv_expeditiondet_batch dbv_expeditiondet_extrafields dbv_expedition_extrafields dbv_expedition_package dbv_expensereport dbv_expensereport_det dbv_expensereport_det_extrafields dbv_expensereport_extrafields dbv_expensereport_ik dbv_expensereport_rules dbv_export_model dbv_extrafields dbv_facture dbv_facturedet dbv_facturedet_extrafields dbv_facturedet_rec dbv_facturedet_rec_extrafields dbv_facture_extrafields dbv_facture_fourn dbv_facture_fourn_det dbv_facture_fourn_det_extrafields dbv_facture_fourn_det_rec dbv_facture_fourn_det_rec_extrafields dbv_facture_fourn_extrafields dbv_facture_fourn_rec dbv_facture_fourn_rec_extrafields dbv_facture_rec dbv_facture_rec_extrafields dbv_fichinter dbv_fichinterdet dbv_fichinterdet_extrafields dbv_fichinterdet_rec dbv_fichinter_extrafields dbv_fichinter_rec dbv_holiday dbv_holiday_config dbv_holiday_extrafields dbv_holiday_logs dbv_holiday_users dbv_hrm_evaluation dbv_hrm_evaluationdet dbv_hrm_evaluationdet_extrafields dbv_hrm_evaluation_extrafields dbv_hrm_job dbv_hrm_job_extrafields dbv_hrm_job_user dbv_hrm_skill dbv_hrm_skilldet dbv_hrm_skillrank dbv_hrm_skill_extrafields dbv_import_model dbv_inventory dbv_inventorydet dbv_inventory_extrafields dbv_knowledgemanagement_knowledgerecord dbv_knowledgemanagement_knowledgerecord_extrafields dbv_links dbv_loan dbv_loan_schedule dbv_localtax dbv_mailing_unsubscribe dbv_menu dbv_mrp_mo dbv_mrp_mo_extrafields dbv_mrp_production dbv_mrp_production_extrafields dbv_multicurrency dbv_multicurrency_rate dbv_notify dbv_notify_def dbv_notify_def_object dbv_oauth_state dbv_oauth_token dbv_object_lang dbv_onlinesignature dbv_opensurvey_comments dbv_opensurvey_formquestions dbv_opensurvey_sondage dbv_opensurvey_user_formanswers dbv_opensurvey_user_studs dbv_overwrite_trans dbv_paiement dbv_paiementcharge dbv_paiementfourn dbv_paiementfourn_facturefourn dbv_paiement_extrafields dbv_paiement_facture dbv_partnership dbv_partnership_extrafields dbv_paymentexpensereport_expensereport dbv_payment_donation dbv_payment_expensereport dbv_payment_loan dbv_payment_salary dbv_payment_various dbv_payment_vat dbv_pos_cash_fence dbv_pos_cash_fence_extrafields dbv_prelevement dbv_prelevement_bons dbv_prelevement_demande dbv_prelevement_lignes dbv_prelevement_rejet dbv_printing dbv_product dbv_product_association dbv_product_attribute dbv_product_attribute_combination dbv_product_attribute_combination2val dbv_product_attribute_combination_price_level dbv_product_attribute_extrafields dbv_product_attribute_value dbv_product_attribute_value_extrafields dbv_product_batch dbv_product_customer_price dbv_product_customer_price_extrafields dbv_product_customer_price_log dbv_product_extrafields dbv_product_fournisseur_price dbv_product_fournisseur_price_extrafields dbv_product_fournisseur_price_log dbv_product_lang dbv_product_lot dbv_product_lot_extrafields dbv_product_price dbv_product_pricerules dbv_product_price_by_qty dbv_product_price_extrafields dbv_product_stock dbv_product_thirdparty dbv_product_warehouse_properties dbv_projet dbv_projet_extrafields dbv_projet_task dbv_projet_task_extrafields dbv_propal dbv_propaldet dbv_propaldet_extrafields dbv_propal_extrafields dbv_propal_merge_pdf_product dbv_reception dbv_receptiondet_batch dbv_receptiondet_batch_extrafields dbv_reception_extrafields dbv_recruitment_recruitmentcandidature dbv_recruitment_recruitmentcandidature_extrafields dbv_recruitment_recruitmentjobposition dbv_recruitment_recruitmentjobposition_extrafields dbv_resource dbv_resource_extrafields dbv_rights_def dbv_salary dbv_salary_extrafields dbv_societe dbv_societe_account dbv_societe_commerciaux dbv_societe_contacts dbv_societe_extrafields dbv_societe_prices dbv_societe_remise dbv_societe_remise_except dbv_societe_remise_supplier dbv_societe_rib dbv_socpeople dbv_socpeople_extrafields dbv_stock_mouvement dbv_stock_mouvement_extrafields dbv_subscription dbv_supplier_proposal dbv_supplier_proposaldet dbv_supplier_proposaldet_extrafields dbv_supplier_proposal_extrafields dbv_takepos_floor_tables dbv_ticket dbv_ticket_extrafields dbv_tva dbv_user dbv_usergroup dbv_usergroup_extrafields dbv_usergroup_rights dbv_usergroup_user dbv_user_alert dbv_user_clicktodial dbv_user_employment dbv_user_extrafields dbv_user_param dbv_user_rib dbv_user_rights dbv_workstation_workstation dbv_workstation_workstation_extrafields dbv_workstation_workstation_resource dbv_workstation_workstation_usergroup . Spalte auswählen
Zeige

Kriterium

Sortierung	Aufsteigend	Absteigend
Hinzufügen als	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Eine weitere Spalte
	Tabelle auswählen dbv_accounting_account dbv_accounting_analytic_account dbv_accounting_analytic_axis dbv_accounting_analytic_distribution dbv_accounting_bookkeeping dbv_accounting_bookkeeping_piece dbv_accounting_bookkeeping_tmp dbv_accounting_category_account dbv_accounting_fiscalyear dbv_accounting_groups_account dbv_accounting_journal dbv_accounting_system dbv_actioncomm dbv_actioncomm_extrafields dbv_actioncomm_reminder dbv_actioncomm_resources dbv_adherent dbv_adherent_extrafields dbv_adherent_type dbv_adherent_type_extrafields dbv_adherent_type_lang dbv_bank dbv_bank_account dbv_bank_account_extrafields dbv_bank_extrafields dbv_bank_url dbv_blockedlog dbv_bom_bom dbv_bom_bomline dbv_bom_bomline_extrafields dbv_bom_bom_extrafields dbv_bookmark dbv_bordereau_cheque dbv_boxes dbv_boxes_def dbv_categorie dbv_categories_extrafields dbv_categorie_account dbv_categorie_actioncomm dbv_categorie_contact dbv_categorie_fournisseur dbv_categorie_invoice dbv_categorie_knowledgemanagement dbv_categorie_lang dbv_categorie_member dbv_categorie_order dbv_categorie_product dbv_categorie_project dbv_categorie_propal dbv_categorie_societe dbv_categorie_supplier_invoice dbv_categorie_supplier_order dbv_categorie_ticket dbv_categorie_user dbv_categorie_warehouse dbv_category_bankline dbv_chargesociales dbv_commande dbv_commandedet dbv_commandedet_extrafields dbv_commande_extrafields dbv_commande_fournisseur dbv_commande_fournisseurdet dbv_commande_fournisseurdet_extrafields dbv_commande_fournisseur_extrafields dbv_commande_fournisseur_log dbv_comment dbv_const dbv_contrat dbv_contratdet dbv_contratdet_extrafields dbv_contrat_extrafields dbv_cronjob dbv_c_accounting_category dbv_c_accounting_report dbv_c_actioncomm dbv_c_action_trigger dbv_c_availability dbv_c_barcode_type dbv_c_chargesociales dbv_c_civility dbv_c_country dbv_c_currencies dbv_c_departements dbv_c_ecotaxe dbv_c_effectif dbv_c_email_senderprofile dbv_c_email_templates dbv_c_exp_tax_cat dbv_c_exp_tax_range dbv_c_field_list dbv_c_format_cards dbv_c_forme_juridique dbv_c_holiday_types dbv_c_hrm_department dbv_c_hrm_function dbv_c_hrm_public_holiday dbv_c_incoterms dbv_c_input_method dbv_c_input_reason dbv_c_invoice_subtype dbv_c_lead_status dbv_c_paiement dbv_c_paper_format dbv_c_partnership_type dbv_c_payment_term dbv_c_product_nature dbv_c_product_thirdparty_relation_type dbv_c_propalst dbv_c_prospectcontactlevel dbv_c_prospectlevel dbv_c_recruitment_origin dbv_c_regions dbv_c_revenuestamp dbv_c_shipment_mode dbv_c_shipment_package_type dbv_c_socialnetworks dbv_c_stcomm dbv_c_stcommcontact dbv_c_ticket_category dbv_c_ticket_resolution dbv_c_ticket_severity dbv_c_ticket_type dbv_c_transport_mode dbv_c_tva dbv_c_typent dbv_c_type_contact dbv_c_type_fees dbv_c_type_resource dbv_c_units dbv_c_ziptown dbv_default_values dbv_delivery dbv_deliverydet dbv_deliverydet_extrafields dbv_delivery_extrafields dbv_document_model dbv_don dbv_don_extrafields dbv_ecm_directories dbv_ecm_directories_extrafields dbv_ecm_files dbv_ecm_files_extrafields dbv_element_categorie dbv_element_contact dbv_element_element dbv_element_resources dbv_element_time dbv_emailcollector_emailcollector dbv_emailcollector_emailcollectoraction dbv_emailcollector_emailcollectorfilter dbv_entrepot dbv_entrepot_extrafields dbv_establishment dbv_eventorganization_conferenceorboothattendee dbv_eventorganization_conferenceorboothattendee_extrafields dbv_events dbv_expedition dbv_expeditiondet dbv_expeditiondet_batch dbv_expeditiondet_extrafields dbv_expedition_extrafields dbv_expedition_package dbv_expensereport dbv_expensereport_det dbv_expensereport_det_extrafields dbv_expensereport_extrafields dbv_expensereport_ik dbv_expensereport_rules dbv_export_model dbv_extrafields dbv_facture dbv_facturedet dbv_facturedet_extrafields dbv_facturedet_rec dbv_facturedet_rec_extrafields dbv_facture_extrafields dbv_facture_fourn dbv_facture_fourn_det dbv_facture_fourn_det_extrafields dbv_facture_fourn_det_rec dbv_facture_fourn_det_rec_extrafields dbv_facture_fourn_extrafields dbv_facture_fourn_rec dbv_facture_fourn_rec_extrafields dbv_facture_rec dbv_facture_rec_extrafields dbv_fichinter dbv_fichinterdet dbv_fichinterdet_extrafields dbv_fichinterdet_rec dbv_fichinter_extrafields dbv_fichinter_rec dbv_holiday dbv_holiday_config dbv_holiday_extrafields dbv_holiday_logs dbv_holiday_users dbv_hrm_evaluation dbv_hrm_evaluationdet dbv_hrm_evaluationdet_extrafields dbv_hrm_evaluation_extrafields dbv_hrm_job dbv_hrm_job_extrafields dbv_hrm_job_user dbv_hrm_skill dbv_hrm_skilldet dbv_hrm_skillrank dbv_hrm_skill_extrafields dbv_import_model dbv_inventory dbv_inventorydet dbv_inventory_extrafields dbv_knowledgemanagement_knowledgerecord dbv_knowledgemanagement_knowledgerecord_extrafields dbv_links dbv_loan dbv_loan_schedule dbv_localtax dbv_mailing_unsubscribe dbv_menu dbv_mrp_mo dbv_mrp_mo_extrafields dbv_mrp_production dbv_mrp_production_extrafields dbv_multicurrency dbv_multicurrency_rate dbv_notify dbv_notify_def dbv_notify_def_object dbv_oauth_state dbv_oauth_token dbv_object_lang dbv_onlinesignature dbv_opensurvey_comments dbv_opensurvey_formquestions dbv_opensurvey_sondage dbv_opensurvey_user_formanswers dbv_opensurvey_user_studs dbv_overwrite_trans dbv_paiement dbv_paiementcharge dbv_paiementfourn dbv_paiementfourn_facturefourn dbv_paiement_extrafields dbv_paiement_facture dbv_partnership dbv_partnership_extrafields dbv_paymentexpensereport_expensereport dbv_payment_donation dbv_payment_expensereport dbv_payment_loan dbv_payment_salary dbv_payment_various dbv_payment_vat dbv_pos_cash_fence dbv_pos_cash_fence_extrafields dbv_prelevement dbv_prelevement_bons dbv_prelevement_demande dbv_prelevement_lignes dbv_prelevement_rejet dbv_printing dbv_product dbv_product_association dbv_product_attribute dbv_product_attribute_combination dbv_product_attribute_combination2val dbv_product_attribute_combination_price_level dbv_product_attribute_extrafields dbv_product_attribute_value dbv_product_attribute_value_extrafields dbv_product_batch dbv_product_customer_price dbv_product_customer_price_extrafields dbv_product_customer_price_log dbv_product_extrafields dbv_product_fournisseur_price dbv_product_fournisseur_price_extrafields dbv_product_fournisseur_price_log dbv_product_lang dbv_product_lot dbv_product_lot_extrafields dbv_product_price dbv_product_pricerules dbv_product_price_by_qty dbv_product_price_extrafields dbv_product_stock dbv_product_thirdparty dbv_product_warehouse_properties dbv_projet dbv_projet_extrafields dbv_projet_task dbv_projet_task_extrafields dbv_propal dbv_propaldet dbv_propaldet_extrafields dbv_propal_extrafields dbv_propal_merge_pdf_product dbv_reception dbv_receptiondet_batch dbv_receptiondet_batch_extrafields dbv_reception_extrafields dbv_recruitment_recruitmentcandidature dbv_recruitment_recruitmentcandidature_extrafields dbv_recruitment_recruitmentjobposition dbv_recruitment_recruitmentjobposition_extrafields dbv_resource dbv_resource_extrafields dbv_rights_def dbv_salary dbv_salary_extrafields dbv_societe dbv_societe_account dbv_societe_commerciaux dbv_societe_contacts dbv_societe_extrafields dbv_societe_prices dbv_societe_remise dbv_societe_remise_except dbv_societe_remise_supplier dbv_societe_rib dbv_socpeople dbv_socpeople_extrafields dbv_stock_mouvement dbv_stock_mouvement_extrafields dbv_subscription dbv_supplier_proposal dbv_supplier_proposaldet dbv_supplier_proposaldet_extrafields dbv_supplier_proposal_extrafields dbv_takepos_floor_tables dbv_ticket dbv_ticket_extrafields dbv_tva dbv_user dbv_usergroup dbv_usergroup_extrafields dbv_usergroup_rights dbv_usergroup_user dbv_user_alert dbv_user_clicktodial dbv_user_employment dbv_user_extrafields dbv_user_param dbv_user_rib dbv_user_rights dbv_workstation_workstation dbv_workstation_workstation_extrafields dbv_workstation_workstation_resource dbv_workstation_workstation_usergroup .	Spalte auswählen