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

Show:

FILE_NAME

Varchar(150)

Name.


Default: ''

FILE_SIZE

Int(11)

Size.


Default: 0

ID_JUSTIFICATIF

Int(11)

Unique identifier.

ID_OTHER

Int(11)

Entity related to the document:


Default: 0

ID_PARENT

Int(11)


Default: 0

ID_SIGNATURE

Int(11)

Signature related to the document:


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
  • 4 : Invoice


Default: 0

PARENT_FILE_ID

Int(11)

file parent id when proof is a copy of another proof (ex: when creating invoice).


Default: 0

PARENT_FILE_TYPE - `0` : Expenses - `1` : Timesheet - `2` : Request of absences - `3` : Payment - `4` : Invoice

Tinyint(1)

file parent type when proof is a copy of another proof (ex: when creating invoice).


Default: -1