TAB_JUSTIFICATIF - BoondManager

Entity's document (timesheet, expenses, request of absences, payment).

Index
Properties

Properties

FILE_NAME
ID_JUSTIFICATIF
ID_OTHER
ID_PARENT
ID_SIGNATURE
JUSTIF_OTHER
JUSTIF_TYPE

FILE_NAME

Varchar(150)

Name.

Default: ''

ID_JUSTIFICATIF

Int(11)

Unique identifier.

ID_OTHER

Int(11)

Entity related to the document:

Project: TAB_PROJET.ID_PROJET.

Default: 0

ID_PARENT

Int(11)

Entity's identifier :

Expenses : if TAB_JUSTIFICATIF.JUSTIF_TYPE is 0, cf. TAB_LISTEFRAIS.ID_LISTEFRAIS
Timesheet : if TAB_JUSTIFICATIF.JUSTIF_TYPE is 1, cf. TAB_LISTETEMPS.ID_LISTETEMPS
Request of absences : if TAB_JUSTIFICATIF.JUSTIF_TYPE is 2, cf. TAB_LISTEABSENCES.ID_LISTEABSENCES
Payment : if TAB_JUSTIFICATIF.JUSTIF_TYPE is 3, cf. TAB_PAIEMENT.ID_PAIEMENT

Default: 0

ID_SIGNATURE

Int(11)

Signature related to the document:

Signature: TAB_SIGNATURE.ID_SIGNATURE.

Default: 0

JUSTIF_OTHER

Tinyint(1)

Type of proof:

0 : other
1 : signed proof

Default: 0

JUSTIF_TYPE

Tinyint(1)

Entity's type :

0 : Expenses
1 : Timesheet
2 : Request of absences
3 : Payment

Default: 0