Table llx deplacement

Revision as of 07:03, 10 June 2009 by Simnandez (talk | contribs)


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

  Contains the expenses and trips notes

  Contient les notes de frais et déplacements

  Contiene las notas de gastos y desplazamientos

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
tms timestamp CURRENT_TIMESTAMP last update date
date_c datetime YES NULL date of creation
fk_user int(11) 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) type of trip note
km double YES NULL amount or km
fk_soc int(11) YES NULL ID society affected (llx_societe->rowid)
note text YES NULL notes