Absences quota.

Show:

ID_INTQUO

Int(11)

Unique identifier.

ID_PROFIL

Int(11)


Default: 0

ID_SOCIETE

Int(11)


Default: 0

INTQUO_BEINGACQUIRED

Decimal(15,5)

Amount being acquired.


Default: 0

INTQUO_COMMENTAIRE

Text

Comments.

INTQUO_CRONTABDETAIL

Text

Automatic absences account increment details.

Each detail is described by :

  • Automatic increment's hour
  • Automatic increment's time
  • Previous being acquired amount (if never defined before then - else it is a number)
  • Previous acquired amount (if never defined before then - else it is a number)
  • New being acquired amount
  • New acquired amount
  • Hour, time, previous being acquired amount, previous acquired amount, new being acquired amount and new acquired amount are listed in this order and separated by ' ' character

Details are separated by | character.

Example:

"2017-01-01 02:00:00 0 0 0 2|2017-02-01 02:00:00 0 0 2 4"

INTQUO_PERIODE

Date

Period.

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

Example:

2016-06-01

INTQUO_QUOTA

Decimal(15,5)

Amount acquired.


Default: 0

INTQUO_TYPEHREF

Int(11)

TAB_TYPEDECOMPTE.TYPED_TYPEHREF.

Reference of work unit's type.


Default: 0