Exceptional time.

Show:

ID_ACHAT

Int(11)

TAB_ACHAT.ID_ACHAT.

Purchase.


Default: 0

ID_LISTETEMPS

Int(11)


Default: 0

ID_LOT

Int(11)

TAB_LOT.ID_LOT.

Batch.


Default: 0

ID_MISSIONPROJET

Int(11)


Default: 0

ID_PROJET

Int(11)


Default: 0

ID_TEMPSEXCEPTION

Int(11)

Unique identifier.

TEMPSEXP_ACHAT

Decimal(30,10)

Purchase amount excluding tax by the purchaser delivery, so price excluding tax of transferor delivery.

Only available if this activity is attached to a transfer


Default: 0

TEMPSEXP_COUT

Decimal(30,10)

Advantage amount to paid.


Default: 0

TEMPSEXP_DEBUT

Datetime

Start date & time.

TEMPSEXP_DESCRIPTION

Text

Description.

TEMPSEXP_FIN

Datetime

End date & time.

TEMPSEXP_MANAGE

Tinyint(1)

Is financial data has been managed (Payment of advantages & creation of purchases) ? :

  • 1 : Yes
  • 0 : No


Default: 0

TEMPSEXP_MODECALCUL

Tinyint(1)

Enable/disable to fill manually TEMPSEXP_TARIF, TEMPSEXP_COUT, TEMPSEXP_ACHAT :

  • 1 : Enable
  • 0: Disable_, they are automatically calculated following the rules, TEMPSEXP_REGLES, defined_


Default: 0

TEMPSEXP_RECUPERATION

Tinyint(1)

Enable/disable to recover this time or to paid the employee :

  • 1 : Enable
  • 0 : Disable


Default: 0

TEMPSEXP_REGLES

Text

List of exceptional rules used.

Each rule is described by :

Rules are separated by # character.

TEMPSEXP_TARIF

Decimal(30,10)

Price excluding tax.


Default: 0

TEMPSEXP_TYPEHREF

Int(11)

Reference.

cf. TAB_TYPETEMPS.TYPEH_REF.


Default: 0