Actual expense.

Show:

FRAISREEL_CHANGE

Decimal(30,10)

Change rate.


Default: 1

FRAISREEL_DEVISE

Tinyint(2)

Currency.

cf. key id for JSON response data.settings.currency of API /application/dictionary


Default: 0

FRAISREEL_ID_JUSTIFICATIF

Int(11)

Number.


Default: 0

FRAISREEL_INTITULE

Varchar(250)

Title.


Default: ''

FRAISREEL_MONTANT

Decimal(30,10)
  • Number of kilometer if FRAISREEL_TYPEFRSREF is 0
  • Amount included tax if FRAISREEL_TYPEFRSREF is not 0


Default: 0

FRAISREEL_NUM

Smallint(3)

Number.


Default: 1

FRAISREEL_REFACTURE

Tinyint(1)

Enable/disable expensee to be reinvoiced :

  • 1 : Enable
  • 0 : Disable


Default: 0

FRAISREEL_TYPEFRSREF

Int(11)

Reference :


Default: 0

ID_PROJET

Int(11)
  • -1 : Internal Activity
  • -2 : Absence Activity
  • integer : Production Activity on a project, cf. TAB_PROJET.ID_PROJET


Default: 0