TAB_LISTEFRAIS Class

Defined In: /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:1

Note de frais d'un profil.

Show:

LISTEFRAIS_AVANCE

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:32

Advance.


Default: 0

LISTEFRAIS_BKMREF

Int(11)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:39

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


Default: 0

LISTEFRAIS_BKMVALUE

Decimal(15,5)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:47

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


Default: 1

LISTEFRAIS_CHANGEAGENCE

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:77

Agency's exchange rate.


Default: 1

LISTEFRAIS_CLOTURE

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:93

Enable/disable to close this expenses :

  • 1 : Enable
  • 0 : Disable


Default: 0

LISTEFRAIS_COMMENTAIRES

Text

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:55

Information comments.

LISTEFRAIS_DATE

Date

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:24

Term.

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

LISTEFRAIS_DEVISEAGENCE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:84

Agency's currency.

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


Default: 0

LISTEFRAIS_ETAT

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:14

State :

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


Default: 2

LISTEFRAIS_HASH

Text

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:61

Hash on final validation.


Default: ''

LISTEFRAIS_REGLE

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/listefrais.txt:68

Paid :

  • 1 : Yes
  • 0 : No


Default: 0