TAB_TYPEAVANTAGE Class

Advantage's type.

Show:

ID_SOCIETE

Int(11)

TAB_SOCIETE.ID_SOCIETE.

Agency.


Default: 0

ID_TYPEAVANTAGE

Int(11)

Unique identifier.

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_NAME

Varchar(100)

Name.


Default: ''

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_REF

Int(11)

Reference.


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