Table llx deplacement

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档可在页面上找到:Table SQL


Content/Contenu/Contenido

En verysmall.png Contains the expenses and trips notes

Fr verysmall.png Contient les notes de frais et déplacements

Es verysmall.png Contiene las notas de gastos y desplazamientos

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
ref varchar(30) NULL reference donation (TODO change to NOT NULL)
entity int(11) NO 1 multi company id
date_c datetime NO date of creation
tms timestamp NO Current date Date of last modification. See page Field Tms.
dated datetime YES NULL date of trip
fk_user int(11) NO ID of user made the trip note (llx_user->rowid)
fk_user_author int(11) YES NULL ID of creator user of trip note (llx_user->rowid)
type varchar(12) NO type of trip note
fk_statut integer YES 1 Status of trips/expenses (0=Draft, 1=Validated)
km real YES NULL amount or km
fk_soc int(11) YES NULL ID society affected (llx_societe->rowid)
fk_projet int(11) YES NULL ID proyect affected (llx_projet->rowid)
note text YES NULL notes
note_public text YES NULL public notes

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid