Recent
`wordpress`.`wp_woocommerce_shipping_zone_methods`
`performance_schema`.`replication_group_members`
`mydms`.`tbldocumentreviewlog`
`information_schema`.`STATISTICS`
`letodms`.`tbldocumentapprovers`
`azulejoscabello_com`.`wp_db7_forms`
`wordpress`.`wp_users`
`letodms experimental`.`tbldocumentlocks`
`performance_schema`.`keyring_keys`
`performance_schema`.`table_handles`
Favorites
There are no favorite tables.
X
New
aaa
aaa
aaa_fabricas_pruebas
abanq
abanq_23
abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
azulejoscabello.com
azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabecab4_abanq
cabecab4_abanq230
cabecab4_abanq240
joomla_3_9
cabecab4_joomla_3_9_11_helix
cabecab4_joomla_3_9_11_helix_exp
cabecab4_pamesa_filter
cabecab4_web
cabello-enterprises
cabello-enterprises
cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
php_producto
php_producto_prueba
sys
tutorial
wordpress
wordpress
wordpress_desarrollo
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: localhost
Database: cabello-enterprises
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
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
reconcilable
import_key
extraparams
*
rowid
entity
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
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
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
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
label
date_start
date_end
statut
entity
datec
tms
fk_user_author
fk_user_modif
*
rowid
entity
code
label
nature
active
*
rowid
fk_country
pcg_version
label
active
*
id
ref_ext
entity
datep
datep2
fk_action
code
datec
tms
fk_user_author
fk_user_mod
fk_project
fk_soc
fk_contact
fk_parent
fk_user_action
fk_user_done
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
recurid
recurrule
recurdateend
fk_element
elementtype
import_key
extraparams
*
rowid
tms
fk_object
import_key
*
rowid
dateremind
typeremind
fk_user
offsetvalue
offsetunit
status
*
rowid
fk_actioncomm
element_type
fk_element
answer_status
mandatory
transparency
*
rowid
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
socialnetworks
skype
twitter
facebook
linkedin
instagram
snapchat
googleplus
youtube
whatsapp
phone
phone_perso
phone_mobile
birth
photo
statut
public
datefin
note_private
note_public
model_pdf
datevalid
datec
tms
fk_user_author
fk_user_mod
fk_user_valid
canvas
import_key
*
rowid
tms
fk_object
import_key
*
rowid
entity
tms
statut
libelle
morphy
duration
subscription
vote
note
mail_valid
*
rowid
tms
fk_object
import_key
*
rowid
fk_type
lang
label
description
email
import_key
*
rowid
name
entity
fk_element
type_element
filtervalue
fk_user_author
datec
fk_user_mod
tms
*
rowid
ref
entity
label
amount_ht
amount_vat
fk_asset_type
description
note_public
note_private
date_creation
tms
fk_user_creat
fk_user_modif
import_key
status
*
rowid
tms
fk_object
import_key
*
rowid
entity
tms
label
accountancy_code_asset
accountancy_code_depreciation_asset
accountancy_code_depreciation_expense
note
*
rowid
tms
fk_object
import_key
*
rowid
datec
tms
datev
dateo
amount
label
fk_account
fk_user_author
fk_user_rappro
fk_type
num_releve
num_chq
numero_compte
rappro
note
fk_bordereau
banque
emetteur
author
*
rowid
datec
tms
ref
label
entity
fk_user_author
fk_user_modif
bank
code_banque
code_guichet
number
cle_rib
bic
iban_prefix
country_iban
cle_iban
domiciliation
state_id
fk_pays
proprio
owner_address
courant
clos
rappro
url
account_number
fk_accountancy_journal
currency_code
min_allowed
min_desired
comment
note_public
model_pdf
import_key
extraparams
*
rowid
tms
fk_object
import_key
*
rowid
label
entity
*
lineid
fk_categ
*
rowid
fk_bank
url_id
url
label
type
*
rowid
entity
date_creation
tms
action
amounts
element
fk_user
user_fullname
fk_object
ref_object
date_object
signature
signature_line
object_data
object_version
certified
*
rowid
blockchain
signature
tms
*
rowid
entity
ref
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
status
*
rowid
fk_bom
fk_product
fk_bom_child
description
import_key
qty
qty_frozen
disable_stock_change
efficiency
position
*
rowid
tms
fk_object
import_key
*
rowid
tms
fk_object
import_key
*
rowid
fk_user
dateb
url
target
title
favicon
position
entity
*
rowid
ref
ref_ext
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
tms
note
*
rowid
entity
label
status
note
date_start
date_end
datec
tms
fk_user_creat
fk_user_modif
import_key
*
rowid
fk_budget
fk_project_ids
amount
datec
tms
fk_user_creat
fk_user_modif
import_key
*
rowid
entity
fk_parent
label
ref_ext
type
description
color
fk_soc
visible
date_creation
tms
fk_user_creat
fk_user_modif
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
*
rowid
fk_category
lang
label
description
*
fk_categorie
fk_member
*
fk_categorie
fk_product
import_key
*
fk_categorie
fk_project
import_key
*
fk_categorie
fk_soc
import_key
*
fk_categorie
fk_user
import_key
*
fk_categorie
fk_warehouse
import_key
*
fk_categorie
fk_website_page
import_key
*
rowid
ref
date_ech
libelle
entity
tms
date_creation
date_valid
fk_user_author
fk_user_modif
fk_user_valid
fk_type
fk_account
fk_mode_reglement
amount
paye
periode
fk_projet
import_key
*
rowid
ref
entity
ref_ext
ref_int
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
tva
localtax1
localtax2
total_ht
total_ttc
note_private
note_public
model_pdf
last_main_doc
module_source
pos_source
facture
fk_account
fk_currency
fk_cond_reglement
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
*
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
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
fk_commandefourndet
fk_multicurrency
multicurrency_code
multicurrency_subprice
multicurrency_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
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
tva
localtax1
localtax2
total_ht
total_ttc
note_private
note_public
model_pdf
last_main_doc
date_livraison
fk_account
fk_cond_reglement
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
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_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
rowid
tms
fk_object
import_key
*
rowid
fk_commande
fk_product
fk_commandefourndet
fk_projet
fk_reception
qty
fk_entrepot
fk_user
comment
batch
eatby
sellby
status
datec
tms
*
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
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
price_ht
remise
total_ht
total_tva
total_localtax1
total_localtax2
total_ttc
product_type
info_bits
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_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
rowid
tms
fk_object
import_key
*
rowid
tms
fk_contratdet
date
statut
fk_user_author
commentaire
*
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
test
fk_user_author
fk_user_mod
fk_mailing
note
libname
entity
*
rowid
entity
code
label
range_account
sens
category_type
formula
position
fk_country
active
*
id
code
type
libelle
module
active
todo
color
picto
position
*
rowid
elementtype
code
label
description
rang
*
rowid
code
label
active
*
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
label
eec
active
favorite
*
code_iso
label
unicode
active
*
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
enabled
active
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
code
label
affect
delay
newByMonth
fk_country
active
*
rowid
pos
code
label
active
*
rowid
pos
code
label
c_level
active
*
id
entity
fk_country
code
dayrule
day
month
year
active
import_key
*
rowid
code
libelle
active
*
rowid
code
libelle
active
module
*
rowid
code
label
active
module
*
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
sortorder
active
libelle
libelle_facture
type_cdr
nbjour
decalage
module
position
*
rowid
title
expression
*
rowid
code
description
value
*
rowid
type
description
parameters
fk_variable
update_interval
next_update
last_status
*
id
code
label
active
*
code
label
sortorder
active
module
*
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
active
*
rowid
entity
code
pos
label
active
use_default
description
*
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
fk_pays
code
taux
localtax1
localtax1_type
localtax2
localtax2_type
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
*
rowid
code
entity
label
module
active
*
id
code
label
type
accountancy_code
active
module
position
*
rowid
code
label
active
*
rowid
code
scale
label
short_label
unit_type
active
*
rowid
code
fk_county
fk_pays
zip
town
active
*
rowid
entity
type
user_id
page
param
value
*
rowid
ref
entity
datec
tms
dated
fk_user
fk_user_author
fk_user_modif
type
fk_statut
km
fk_soc
fk_projet
note_private
note_public
extraparams
*
rowid
nom
entity
type
libelle
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
*
rowid
tms
fk_object
import_key
*
rowid
label
entity
fk_parent
description
cachenbofdoc
fullpath
extraparams
date_c
date_m
fk_user_c
fk_user_m
acl
*
rowid
ref
label
share
entity
filepath
filename
src_object_type
src_object_id
fullpath_orig
description
keywords
cover
position
gen_or_uploaded
extraparams
date_c
date_m
fk_user_c
fk_user_m
acl
*
rowid
datecreate
statut
element_id
fk_c_type_contact
fk_socpeople
*
rowid
fk_source
sourcetype
fk_target
targettype
*
rowid
element_id
element_type
resource_id
resource_type
busy
mandatory
duree
fk_user_create
tms
*
rowid
entity
ref
label
description
host
hostcharset
login
password
source_directory
target_directory
maxemailpercollect
datelastresult
codelastresult
lastresult
datelastok
note_public
note_private
date_creation
tms
fk_user_creat
fk_user_modif
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
description
lieu
address
zip
town
fk_departement
fk_pays
phone
fax
statut
fk_user_author
model_pdf
import_key
fk_parent
*
rowid
tms
fk_object
import_key
*
rowid
entity
name
address
zip
town
fk_state
fk_country
profid1
profid2
profid3
phone
fk_user_author
fk_user_mod
datec
tms
status
*
rowid
tms
type
entity
prefix_session
dateevent
fk_user
description
ip
user_agent
fk_object
*
rowid
fk_source
fk_target
targettype
*
rowid
tms
ref
entity
fk_soc
fk_projet
ref_ext
ref_int
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
note_private
note_public
model_pdf
last_main_doc
fk_incoterms
location_incoterms
import_key
extraparams
*
rowid
fk_expedition
fk_origin_line
fk_entrepot
qty
rang
*
rowid
fk_expeditiondet
eatby
sellby
batch
qty
fk_origin_stock
*
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_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
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
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_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
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
ref
date_export
fk_user
note
*
rowid
fk_user
label
type
field
filter
*
rowid
name
entity
elementtype
label
type
size
fieldcomputed
fielddefault
fieldunique
fieldrequired
perms
enabled
pos
alwayseditable
param
list
printable
totalizable
langs
help
fk_user_author
fk_user_modif
datec
tms
*
rowid
ref
entity
ref_ext
ref_int
ref_client
type
fk_soc
datec
datef
date_pointoftax
date_valid
tms
date_closing
paye
remise_percent
remise_absolue
remise
close_code
close_note
tva
localtax1
localtax2
revenuestamp
total
total_ttc
fk_statut
fk_user_author
fk_user_modif
fk_user_valid
fk_user_closing
module_source
pos_source
fk_fac_rec_source
fk_facture_source
fk_projet
increment
fk_account
fk_currency
fk_cond_reglement
fk_mode_reglement
date_lim_reglement
note_private
note_public
model_pdf
last_main_doc
fk_incoterms
location_incoterms
situation_cycle_ref
situation_counter
situation_final
retained_warranty
retained_warranty_date_limit
retained_warranty_fk_cond_reglement
import_key
extraparams
fk_multicurrency
multicurrency_code
multicurrency_tx
multicurrency_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
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
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
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_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
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
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_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
rowid
tms
fk_object
import_key
*
rowid
tms
fk_object
import_key
*
rowid
ref
ref_supplier
entity
ref_ext
type
fk_soc
datec
datef
date_pointoftax
date_valid
tms
libelle
paye
amount
remise
close_code
close_note
tva
localtax1
localtax2
total
total_ht
total_tva
total_ttc
fk_statut
fk_user_author
fk_user_modif
fk_user_valid
fk_facture_source
fk_projet
fk_account
fk_cond_reglement
fk_mode_reglement
date_lim_reglement
note_private
note_public
fk_incoterms
location_incoterms
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
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_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
rowid
tms
fk_object
import_key
*
rowid
tms
fk_object
import_key
*
rowid
titre
entity
fk_soc
datec
tms
suspended
amount
remise
remise_percent
remise_absolue
vat_src_code
tva
localtax1
localtax2
revenuestamp
total
total_ttc
fk_user_author
fk_user_modif
fk_projet
fk_cond_reglement
fk_mode_reglement
date_lim_reglement
fk_account
note_private
note_public
modelpdf
fk_multicurrency
multicurrency_code
multicurrency_tx
multicurrency_total_ht
multicurrency_total_tva
multicurrency_total_ttc
usenewprice
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
fk_soc
fk_projet
fk_contrat
ref
ref_ext
entity
tms
datec
date_valid
datei
fk_user_author
fk_user_modif
fk_user_valid
fk_statut
dateo
datee
datet
duree
description
note_private
note_public
model_pdf
last_main_doc
import_key
extraparams
*
rowid
fk_fichinter
fk_parent_line
date
description
duree
rang
*
rowid
tms
fk_object
import_key
*
rowid
fk_fichinter
date
description
duree
rang
total_ht
subprice
fk_parent_line
fk_product
label
tva_tx
localtax1_tx
localtax1_type
localtax2_tx
localtax2_type
qty
remise_percent
remise
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
fk_export_commpta
special_code
fk_unit
import_key
*
rowid
tms
fk_object
import_key
*
rowid
titre
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
*
rowid
ref
ref_ext
entity
fk_user
fk_user_create
fk_user_modif
fk_type
date_create
description
date_debut
date_fin
halfday
statut
fk_validator
date_valid
fk_user_valid
date_refuse
fk_user_refuse
date_cancel
fk_user_cancel
detail_refuse
note_private
note_public
tms
import_key
extraparams
*
rowid
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
fk_user
label
type
field
*
rowid
entity
ref
date_creation
tms
fk_user_creat
fk_user_modif
fk_user_valid
fk_warehouse
fk_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
*
rowid
entity
datea
url
label
objecttype
objectid
*
rowid
tms
ref
entity
fk_soc
ref_ext
ref_int
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_livraison
fk_origin_line
fk_product
description
qty
subprice
total_ht
rang
*
rowid
tms
fk_object
import_key
*
rowid
tms
fk_object
import_key
*
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_user_creat
fk_user_modif
*
rowid
entity
localtaxtype
tms
datep
datev
amount
label
note
fk_bank
fk_user_creat
fk_user_modif
*
rowid
statut
titre
entity
sujet
body
bgcolor
bgimage
cible
nbemail
email_from
email_replyto
email_errorsto
tag
date_creat
date_valid
date_appro
date_envoi
tms
fk_user_creat
fk_user_valid
fk_user_appro
extraparams
joined_file1
joined_file2
joined_file3
joined_file4
*
rowid
fk_mailing
fk_contact
lastname
firstname
email
other
tag
statut
source_url
source_id
source_type
date_envoi
tms
error_text
*
rowid
entity
email
unsubscribegroup
ip
date_creat
tms
*
rowid
menu_handler
entity
module
type
mainmenu
leftmenu
fk_menu
fk_mainmenu
fk_leftmenu
position
url
target
titre
langs
level
perms
enabled
usertype
tms
*
rowid
ref
entity
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
*
rowid
tms
fk_object
import_key
*
rowid
fk_mo
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
*
rowid
date_create
code
name
entity
fk_user
*
rowid
date_sync
rate
fk_multicurrency
entity
*
rowid
tms
daten
fk_action
fk_soc
fk_contact
fk_user
type
type_target
objet_type
objet_id
email
*
rowid
tms
datec
fk_action
fk_soc
fk_contact
fk_user
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
fk_soc
fk_user
fk_adherent
entity
*
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
*
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
*
rowid
entity
lang
transkey
transvalue
*
rowid
ref
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
*
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
fk_paiement
fk_facture
amount
multicurrency_code
multicurrency_tx
multicurrency_amount
*
rowid
fk_donation
datec
tms
datep
amount
fk_typepayment
num_payment
note
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
*
rowid
tms
fk_object
import_key
*
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
entity
ref
label
opening
cash
card
cheque
status
date_creation
date_valid
day_close
month_close
year_close
posmodule
posnumber
fk_user_creat
fk_user_valid
tms
import_key
*
rowid
type
ref
entity
datec
amount
statut
credite
note
date_trans
method_trans
fk_user_trans
date_credit
fk_user_credit
*
rowid
fk_facture
fk_facture_foun
fk_prelevement_lignes
*
rowid
entity
fk_facture
fk_facture_fourn
sourcetype
amount
date_demande
traite
date_traite
fk_prelevement_bons
fk_user_demande
code_banque
code_guichet
number
cle_rib
ext_payment_id
ext_payment_site
*
rowid
fk_prelevement_bons
fk_soc
statut
client_nom
amount
code_banque
code_guichet
number
cle_rib
note
*
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
price
price_ttc
price_min
price_min_ttc
price_base_type
cost_price
default_vat_code
tva_tx
recuperableonly
localtax1_tx
localtax1_type
localtax2_tx
localtax2_type
fk_user_author
fk_user_modif
tosell
tobuy
onportal
tobatch
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
stock
pmp
fifo
lifo
fk_default_warehouse
canvas
finished
hidden
import_key
model_pdf
fk_price_expression
desiredstock
fk_unit
price_autogen
fk_project
*
rowid
fk_product_pere
fk_product_fils
qty
incdec
*
rowid
ref
label
rang
entity
*
rowid
fk_product_parent
fk_product_child
variation_price
variation_price_percentage
variation_weight
entity
*
rowid
fk_prod_combination
fk_prod_attr
fk_prod_attr_val
*
rowid
fk_product_attribute
ref
value
entity
*
rowid
tms
fk_product_stock
eatby
sellby
batch
qty
import_key
*
rowid
entity
datec
tms
fk_product
fk_soc
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
import_key
*
rowid
entity
datec
fk_product
fk_soc
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
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
import_key
delivery_time_days
supplier_reputation
fk_multicurrency
multicurrency_code
multicurrency_tx
multicurrency_unitprice
multicurrency_price
*
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
eatby
sellby
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
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_product
fk_entrepot
reel
import_key
*
rowid
tms
fk_product
fk_entrepot
seuil_stock_alerte
desiredstock
import_key
*
rowid
fk_soc
datec
tms
dateo
datee
ref
entity
title
description
fk_user_creat
fk_user_modif
public
fk_statut
fk_opp_status
opp_percent
date_close
fk_user_close
note_private
note_public
opp_amount
budget_amount
usage_opportunity
usage_task
usage_bill_time
usage_organize_event
model_pdf
import_key
*
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
fk_user_creat
fk_user_modif
fk_user_valid
fk_statut
note_private
note_public
rang
model_pdf
import_key
*
rowid
tms
fk_object
import_key
*
rowid
fk_task
task_date
task_datehour
task_date_withhour
task_duration
fk_user
thm
invoice_id
invoice_line_id
import_key
datec
tms
note
*
rowid
ref
entity
ref_ext
ref_int
ref_client
fk_soc
fk_projet
tms
datec
datep
fin_validite
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
tva
localtax1
localtax2
total
fk_account
fk_currency
fk_cond_reglement
fk_mode_reglement
note_private
note_public
model_pdf
last_main_doc
date_livraison
fk_shipping_method
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
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_total_ht
multicurrency_total_tva
multicurrency_total_ttc
*
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_int
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
tms
fk_object
import_key
*
rowid
entity
ref
asset_number
description
fk_code_type_resource
datec
date_valid
fk_user_author
fk_user_modif
fk_user_valid
fk_statut
note_public
note_private
import_key
extraparams
fk_country
tms
*
rowid
tms
fk_object
import_key
*
id
libelle
module
module_position
family_position
entity
perms
subperms
type
bydefault
*
rowid
nom
name_alias
entity
ref_ext
ref_int
statut
parent
status
code_client
code_fournisseur
code_compta
code_compta_fournisseur
address
zip
town
fk_departement
fk_pays
fk_account
phone
fax
url
email
socialnetworks
skype
twitter
facebook
linkedin
instagram
snapchat
googleplus
youtube
whatsapp
fk_effectif
fk_typent
fk_forme_juridique
fk_currency
siren
siret
ape
idprof4
idprof5
idprof6
tva_intra
capital
fk_stcomm
note_private
note_public
model_pdf
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
mode_reglement_supplier
cond_reglement_supplier
fk_shipping_method
tva_assuj
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_entrepot
webservices_url
webservices_key
tms
datec
fk_user_creat
fk_user_modif
fk_multicurrency
multicurrency_code
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_creation
tms
fk_user_creat
fk_user_modif
import_key
status
*
rowid
datec
tms
label
fk_soc
name
address
zip
town
fk_pays
phone
fax
note
fk_user_creat
fk_user_modif
*
rowid
fk_soc
fk_user
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_amount_ht
multicurrency_amount_tva
multicurrency_amount_ttc
*
rowid
entity
fk_soc
tms
datec
fk_user_author
remise_supplier
note
*
rowid
type
label
fk_soc
datec
tms
bank
code_banque
code_guichet
number
cle_rib
bic
iban_prefix
domiciliation
proprio
owner_address
default_rib
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
comment
ipaddress
status
import_key
*
rowid
datec
tms
fk_soc
entity
ref_ext
civility
lastname
firstname
address
zip
town
fk_departement
fk_pays
birthday
poste
phone
phone_perso
phone_mobile
fax
email
socialnetworks
jabberid
skype
twitter
facebook
linkedin
instagram
snapchat
googleplus
youtube
whatsapp
photo
no_email
priv
fk_user_creat
fk_user_modif
note_private
note_public
default_lang
canvas
import_key
statut
*
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
datec
fk_adherent
fk_type
dateadh
datef
subscription
fk_bank
fk_user_creat
fk_user_valid
note
*
rowid
ref
entity
ref_ext
ref_int
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
tva
localtax1
localtax2
total
fk_account
fk_currency
fk_cond_reglement
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
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_total_ht
multicurrency_total_tva
multicurrency_total_ttc
fk_unit
*
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
origin_email
fk_user_create
fk_user_assign
subject
message
fk_statut
resolution
progress
timing
type_code
category_code
severity_code
datec
date_read
date_close
notify_tiers_at_create
tms
import_key
*
rowid
tms
fk_object
import_key
*
rowid
tms
datec
datep
datev
amount
fk_typepayment
num_payment
label
entity
note
fk_bank
fk_user_creat
fk_user_modif
import_key
*
rowid
entity
ref_ext
ref_int
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
job
office_phone
office_fax
user_mobile
personal_mobile
email
personal_email
socialnetworks
jabberid
skype
twitter
facebook
linkedin
instagram
snapchat
googleplus
youtube
whatsapp
signature
admin
module_comm
module_compta
fk_soc
fk_socpeople
fk_member
fk_user
fk_user_expense_validator
fk_user_holiday_validator
note_public
note
model_pdf
datelastlogin
datepreviouslogin
iplastlogin
ippreviouslogin
egroupware_id
ldap_sid
openid
statut
photo
lang
color
barcode
fk_barcode_type
accountancy_code
nb_holiday
thm
tjm
salary
salaryextra
dateemployment
dateemploymentend
weeklyhours
import_key
default_range
default_c_exp_tax_cat
fk_warehouse
*
rowid
nom
entity
datec
tms
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
iban_prefix
domiciliation
proprio
owner_address
*
rowid
entity
fk_user
fk_id
*
rowid
type_container
entity
ref
description
maincolor
maincolorbis
lang
otherlang
status
fk_default_home
use_manifest
virtualhost
fk_user_creat
fk_user_modif
date_creation
tms
import_key
*
rowid
tms
fk_object
import_key
*
rowid
fk_website
type_container
pageurl
aliasalt
title
description
image
keywords
lang
fk_page
htmlheader
content
status
grabbed_from
fk_user_creat
fk_user_modif
author_alias
date_creation
tms
import_key
*
rowid
entity
url
event
module
action
status
date_creation
fk_user
tms
import_key
*
rowid
tms
fk_object
import_key
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Column
select column
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
.
select column
