Project.

Show:

ID_PROFILCDP

Tinytext

List of project's managers.

Each project's manager is described by TAB_PROFIL.ID_PROFIL.

Project's managers are separated by | character.

PRJ_ADR

Varchar(250)

Delivery's address.


Default: ''

PRJ_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

PRJ_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

PRJ_CONSOMMATIONVIEW

Tinyint(1)

Type of view to display into productivity's tab :

  • 2 : Groupments view
  • 1 : Deliveries view
  • 0 : Resources view

Used only if TAB_PROJET.PRJ_TYPE ∈ {1,2}


Default: 1

PRJ_CORRELATIONJALON

Tinyint(1)

Enable/disable to synchronize TAB_PROJET.PRJ_RESTEAFAIRE with the batches/markers remains to be done :

  • 1 : Enable
  • 0 : Disable

Used only if TAB_PROJET.PRJ_TYPE = 2


Default: 0

PRJ_CP

Char(10)

Delivery's postcode.


Default: ''

PRJ_DATELASTACTIVITY

Datetime

Last activity date.

PRJ_DATELOTUPDATE

Datetime

Batches/Markers update date.

This property can be null.

PRJ_DEVISE

Tinyint(2)

Currency.

cf. key id for JSON response data.settings.currency of API /application/dictionary


Default: 0

PRJ_DEVISEAGENCE

Tinyint(2)

Agency's currency.

cf. key id for JSON response data.settings.currency of API /application/dictionary


Default: 0

PRJ_ETAT

Tinyint(2)

State.

cf. key id for JSON response data.settings.state.project of API /application/dictionary


Default: 1

PRJ_INVESTISSEMENT

Decimal(30,10)


Default: 0

PRJ_LOTSTAB

Tinyint(1)

Enable/disable to show batches/markers tab on the web interface :

  • 1 : Enable
  • 0 : Disable

Used only if TAB_PROJET.PRJ_TYPE =∈ {2,4}


Default: 0

PRJ_LOTVIEW

Tinyint(1)

Enable/disable to create markers on batches :

  • 1 : Enable
  • 0 : Disable

Used only if TAB_PROJET.PRJ_TYPE = 2


Default: 0

PRJ_PAYS

Varchar(100)

Delivery's country.


Default: 'France'

PRJ_REFERENCE

Varchar(100)

Reference.


Default: ''

PRJ_RESTEAFAIRE

Decimal(15,5)

Remains to be done.

Used only if TAB_PROJET.PRJ_TYPE = 2


Default: 0

PRJ_TARIFADDITIONNEL

Decimal(30,10)


Default: 0

PRJ_TAUXHORAIRE

Decimal(15,5)

Work unit rate.


Default: 1

PRJ_TYPE

Tinyint(2)

Mode :

  • -1 : Absence's inactivity
  • -2 : Internal's inactivity
  • or cf. key mode for JSON response data.settings.typeOf.project of API /application/dictionary


Default: 0

PRJ_TYPEREF

Int(11)

Type.

cf. key id for JSON response data.settings.typeOf.project of API /application/dictionary


Default: 0

PRJ_VILLE

Varchar(100)

Delivery's town.


Default: ''