TAB_LISTEFRAIS Class

Note de frais d'un profil.

Show:

ID_CREATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Creator.


Default: 0

ID_LISTEFRAIS

Int(11)

Unique identifier.

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Resource.


Default: 0

ID_SOCIETE

Int(11)

TAB_SOCIETE.ID_SOCIETE.

Agency.


Default: 0

LISTEFRAIS_AVANCE

Decimal(30,10)

Advance.


Default: 0

LISTEFRAIS_BKMREF

Int(11)

Rate per kilometer's reference. cf. TAB_BAREMEKM.BARKM_REF.


Default: 0

LISTEFRAIS_BKMVALUE

Decimal(15,5)

Rate per kilometer's value. cf. TAB_BAREMEKM.BARKM_VALUE.


Default: 1

LISTEFRAIS_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

LISTEFRAIS_CLOTURE

Tinyint(1)

Enable/disable to close this expenses :

  • 1 : Enable
  • 0 : Disable


Default: 0

LISTEFRAIS_COMMENTAIRES

Text

Information comments.

LISTEFRAIS_CREATEDAT

Datetime

Creation date

LISTEFRAIS_DATE

Date

Term.

The value follows this RegExp [0-9]{4})-([0-9]{2})-01.

LISTEFRAIS_DEVISEAGENCE

Int(11)

Agency's currency.

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


Default: 0

LISTEFRAIS_ETAT

Tinyint(1)

State :

  • 1 : Validated
  • 2 : Waiting for validation
  • 3 : Rejected


Default: 2

LISTEFRAIS_HASH

Text

Hash on final validation.


Default: ''

LISTEFRAIS_LAST_EXTRACT_DATE

Datetime

datetime of last export, null if never exported


Default: null

LISTEFRAIS_REGLE

Tinyint(1)

Paid :

  • 1 : Yes
  • 0 : No


Default: 0

LISTEFRAIS_UPDATEDAT

Datetime

Update date.