Advantage.

Show:

AVG_CATEGORIE

Tinyint(2)


Default: 0

AVG_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

AVG_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

AVG_COMMENTAIRES

Text

Information comments.

AVG_COUT

Decimal(30,10)

Total cost.


Default: 0

AVG_CREATEDAT

Datetime

Creation date

AVG_DATE

Date

Creation date.

AVG_DEVISE

Int(11)

Currency.

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


Default: 0

AVG_DEVISEAGENCE

Int(11)

Agency's currency.

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


Default: 0

AVG_FIN

Date

Returning date.

Only available if TAB_AVANTAGE.AVG_CATEGORIE = 3.

This property can be null.

AVG_MONTANTPARTICIPATION

Decimal(30,10)

Financial amount of employee's participation.


Default: 0

AVG_MONTANTRESSOURCE

Decimal(30,10)

Financial amount paid to employee.


Default: 0

AVG_MONTANTSOCIETE

Decimal(30,10)

Financial amount of employer's charges.


Default: 0

AVG_QUANTITE

Decimal(15,5)

Quantity.


Default: 0

AVG_QUOTAPARTICIPATION

Decimal(30,10)

Participation amount.

cf. TAB_TYPEAVANTAGE.TYPEA_QUOTAPARTICIPATION.


Default: 0

AVG_QUOTARESSOURCE

Decimal(30,10)


Default: 0

AVG_QUOTASOCIETE

Decimal(30,10)


Default: 0

AVG_TYPE

Tinyint(1)

Frequency.

cf. TAB_TYPEAVANTAGE.TYPEA_TYPE.


Default: 0

AVG_TYPEAREF

Int(11)

Reference.

cf. TAB_TYPEAVANTAGE.TYPEA_REF.


Default: 0

AVG_UPDATEDAT

Datetime

Update date.

ID_AVANTAGE

Int(11)

Unique identifier.

ID_CONTRAT

Int(11)


Default: 0

ID_CREATOR

Int(11)


Default: 0

ID_MISSIONPROJET

Int(11)


Default: 0

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

ID_PROJET

Int(11)


Default: 0

ID_SOCIETE

Int(11)


Default: 0