Project.

Show:

ID_AO

Int(11)

TAB_AO.ID_AO.

Opportunity.


Default: 0

ID_CREATOR

Int(11)


Default: 0

ID_CRMCONTACT

Int(11)


Default: 0

ID_CRMSOCIETE

Int(11)


Default: 0

ID_CRMTECHNIQUE

Int(11)

TAB_CRMCONTACT.ID_CRMCONTACT.

Technical contact.


Default: 0

ID_INTERMEDIAIRE_CRMCONTACT

Int(11)

TAB_CRMCONTACT.ID_CRMCONTACT.

Contact's billing intermediary.


Default: 0

ID_INTERMEDIAIRE_CRMSOCIETE

Int(11)

TAB_CRMSOCIETE.ID_CRMSOCIETE.

Company's billing intermediary.


Default: 0

ID_POLE

Int(11)


Default: 0

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

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.

ID_PROJET

Int(11)

Unique identifier.

ID_SOCIETE

Int(11)


Default: 0

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_COMMENTAIRES

Text

Information comments.

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_CRITERE_POSITIONNEMENT

Text

Delivery suggest settings (json) : All settings for delivery suggest. All allowed attributes are mapped in PositioningSuggest model


Default: ''

Example:

{"defaultPositioningSuggestCandidatesPerimeter" : 1, "defaultPositioningSuggestResourcesPerimeter" : 1, "defaultPositioningSuggestExcludedCandidatesTypes" : [1], "defaultPositioningSuggestExcludedResourcesTypes" : [1], "defaultPositioningSuggestExcludedCandidatesStates" : [3], "defaultPositioningSuggestExcludedResourcesStates" : [0], "defaultPositioningSuggestKeywordsFromOpportunity" : ["title", "tools"], "defaultPositioningSuggestFiltersFromOpportunity" : ["tools", "domains"]}

PRJ_DATE

Datetime

Creation date.

PRJ_DATELASTACTIVITY

Datetime

Last activity date.

PRJ_DATELOTUPDATE

Datetime

Batches/Markers update date.

This property can be null.

PRJ_DATEUPDATE

Datetime

Update date.

PRJ_DEBUT

Date

Start date.

PRJ_DEVISE

Int(11)

Currency.

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


Default: 0

PRJ_DEVISEAGENCE

Int(11)

Agency's currency.

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


Default: 0

PRJ_ETAT

Int(11)

State.

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


Default: 1

PRJ_FIN

Date

End date.

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_MIXTE

Tinyint(1)

Not used.


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_STATE_REASON

Tinyint(1)

End of process.


Default: 0

PRJ_STATE_REASON_COMMENT

Text

Reason end of process.


Default: ''

PRJ_SUBDIVISION

Varchar(6)

Sub division (ISO-3166-2).


Default: ''

PRJ_TARIFADDITIONNEL

Decimal(30,10)


Default: 0

PRJ_TAUXHORAIRE

Decimal(15,5)

Work unit rate.


Default: 1

PRJ_TYPE

Int(11)

Mode :

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


Default: 0

PRJ_TYPEREF

Int(11)

Type.

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


Default: 0

PRJ_VILLE

Varchar(100)

Delivery's town.


Default: ''