Advantage's type.

Show:

TYPEA_CATEGORIE

Tinyint(1)

Category :

  • 0 : Fixed amount
  • 1 : Variable - Salary base_, only if TYPEA_TYPE &isnot; 0_
  • 2 : Package_, only if TYPEA_TYPE &isnot; 0_
  • 3 : Lending_, only if TYPEA_TYPE = 0_


Default: 0

TYPEA_DEFAUT

Tinyint(1)

Enable/disable to automatically add this advantage to each new contract.

Only available if TAB_TYPEAVANTAGE.TYPEA_TYPE &isnot; 0.


Default: 0

TYPEA_ETAT

Tinyint(1)

State :

  • 0 : Archived
  • 1 : Current.


Default: 1

TYPEA_QUOTAPARTICIPATION

Decimal(30,10)

Participation amount.

The meaning of this value depends on TYPEA_CATEGORIE.


Default: 0

TYPEA_QUOTARESSOURCE

Decimal(30,10)

Employee amount.

The meaning of this value depends on TYPEA_CATEGORIE.


Default: 0

TYPEA_QUOTASOCIETE

Decimal(30,10)

Agency amount.

The meaning of this value depends on TYPEA_CATEGORIE.


Default: 0

TYPEA_TYPE

Tinyint(1)

Frequency :

  • 0 : Non-Contractual & Punctual
  • 1 : Contractual & Daily
  • 2 : Contractual & Monthly
  • 3 : Contractual & Quaterly
  • 4 : Contractual & Bi-annual
  • 5 : Contractual & Yearly


Default: 0