Skip to content
Dolibarr loaded the following default data after installation. These data values can be referenced by other tables as foreign keys. Additional values can be added via dictionary.
These values can also be found in home->setup->dictionary
llx_accounting_journal
“ACCOUNTING_SELL_JOURNAL”, “ACCOUNTING_PURCHASE_JOURNAL”, “FinanceJournal”, “ACCOUNTING_MISCELLANEOUS_JOURNAL”, “ACCOUNTING_HAS_NEW_JOURNAL”, “ExpenseReportsJournal”, “InventoryJournal”
llx_accounting_system
Values to indicate accounting plan by country
llx_blockedlog
llx_boxes
llx_boxes_def
llx_c_accounting_category
“Income of products/services”, “Expenses of products/services”, “Balance”
llx_c_action_trigger
Describes action type such as Company_Create, Proposal_SENTBYMAIL…etc
llx_c_actioncomm
Communication action type such as phone call, send fax, send email…etc
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
titles prefixing a person’s name such as Mr and Madame
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
human resource related departments
llx_c_hrm_function
llx_c_incoterms
International Commercial Terms
Data included: EXW, FCA, FAS, FOB, CFR, CIF, CRT, CIP, DAT, DAP, DDP
llx_c_input_method
order type, such as OrderByMail, OrderByFAX…etc
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
payment types such as tips, transfer, cash…etc
llx_c_paper_format
llx_c_payment_term
such as Due upon receipt, 30 days…etc
This should get printed on invoices.
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
At-Store Reclamation, Generic transporter…etc
llx_c_stcomm
contact status such as do not contact, contact, never contact….etc
llx_c_ticket_category
llx_c_ticket_severity
llx_c_ticket_type
looks like labels for problems or requests such Commercial question, Change or enhancement request…etc
llx_c_tva
llx_c_type_contact
contact type such as billing, service, sales…etc
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_typent
llx_c_units
measurement such as piece, meter…etc
llx_const
all global constants are stored in this table. Values from HOME->SET UP are stored here.
llx_cronjob
llx_document_model
Contains the list of documents generated by a module setup page.
llx_expensereport_ik
llx_holiday_config
llx_menu
contains values form HOME->MENU
llx_rights_def
Contains the various permissions available
llx_user
Contains the users, together with their login and password. This is a mandatory table.
llx_user_rights