TAB_FRAISREEL Class

Actual expense.

Show:

FRAISREEL_CHANGE

Decimal(30,10)

Change rate.


Default: 1

FRAISREEL_DATE

Date

Start date.

FRAISREEL_DEVISE

Int(11)

Currency.

cf. key id for JSON response data.setting.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_TVA

Decimal(15,5)

Tax rate.

cf. TAB_TYPEFRAIS.TYPEFRS_TVA.


Default: 0

FRAISREEL_TYPEFRSREF

Int(11)

Reference :


Default: 0

ID_FRAISREEL

Int(11)

Unique identifier.

ID_LISTEFRAIS

Int(11)

TAB_LISTEFRAIS.ID_LISTEFRAIS.

Expenses.


Default: 0

ID_LOT

Int(11)

TAB_LOT.ID_LOT.

Batch.


Default: 0

ID_MISSIONPROJET

Int(11)

TAB_MISSIONPROJET.ID_MISSIONPROJET.

Delivery.


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