Dolibarr Inital Data Constants

Dolibarr
  • 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
      • availability duration
    • llx_c_barcode_type
    • llx_c_chargesociales
      • tax related
    • llx_c_civility
      • titles prefixing a person’s name such as Mr and Madame
    • llx_c_country
      • country name and code
    • llx_c_currencies
    • llx_c_departements
      • seems like example data
    • llx_c_ecotaxe
      • seems like example data
    • llx_c_effectif
    • llx_c_email_templates
      • seems like example data
    • llx_c_exp_tax_cat
    • llx_c_exp_tax_range
    • llx_c_format_cards
    • llx_c_forme_juridique
    • llx_c_holiday_types
      • absence type
    • 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
      • high, low, medium…etc
    • llx_c_regions
      • example  data
    • 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
      • VAT related
    • 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
      • log of cron jobs ran
    • 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