Opportunity.

Show:

AO_APPLICATIONS

Text

List of activity areas.

Each activity area is described by key option.id for JSON response data.setting.activityArea of API /application/dictionary.

Activity areas are separated by | character.

Example:

"category1domain1|category2domain1"

AO_BUDGET

Decimal(30,10)

Estimates.


Default: 0

AO_CA

Decimal(30,10)

Estimated turnover.


Default: 0

AO_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

AO_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

AO_CORRELATIONPOS

Tinyint(1)

Enable/disable to validate simulation :

  • 1 : Enable, so TAB_AO.AO_CA is unchangeable & automatically calculated
  • 0 : Disable


Default: 0

AO_CRITERE_POSITIONNEMENT

Text

Positioning suggest settings (json) : All settings for positioning 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"]}

AO_CRITERES

Text

Criterias.

AO_DATECLOSING

Date

Closing's date.

This property can be null.

AO_DATELASTACTIVITY

Datetime

Last activity date.

AO_DATELIMITE

Date

Due's date.

This property can be null.

AO_DATEUPDATE

Datetime

Update date.

AO_DEBUT

Date

Start's date.

AO_DEPOT

Datetime

Creation date.

AO_DESCRIPTION

Text

Description.

AO_DEVISE

Int(11)

Currency.

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


Default: 0

AO_DEVISEAGENCE

Int(11)

Agency's currency.

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


Default: 0

AO_DUREE

Int(11)

Duration.

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


Default: 0

AO_ETAT

Int(11)

State.

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


Default: 0

AO_INTERVENTION

Text

Expertise area.

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


Default: ''

AO_INVESTISSEMENT

Decimal(30,10)

Total additional costs.


Default: 0

AO_LIEU

Text

Place.

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


Default: ''

AO_OUTILS

Text

List of tools.

Each tool is described by :

Tools are separated by # character.

Example:

"tool1|2#tool2|4"

AO_PROBA

Tinyint(2)

Weighting.


Default: 0

AO_REF

Varchar(250)

Reference.


Default: ''

AO_SOURCE

Varchar(100)

Origin's detail.


Default: ''

AO_STATE_REASON

Int(11)

End of process.


Default: 0

AO_STATE_REASON_COMMENT

Text

Reason end of process.


Default: ''

AO_TARIFADDITIONNEL

Decimal(30,10)

Total additional turnover.


Default: 0

AO_TAUXHORAIRE

Decimal(15,5)

Work unit rate.


Default: 1

AO_TITLE

Varchar(150)

Title.


Default: ''

AO_TYPE

Int(11)

Mode.

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


Default: 0

AO_TYPEDEBUT

Tinyint(1)

Start's type:

  • 1: Start immediately
  • 2: Start after AO_DEBUT


Default: 1

AO_TYPEREF

Int(11)

Type.

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


Default: 0

AO_TYPESOURCE

Int(11)

Origin.

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


Default: -1

AO_VISIBILITE

Tinyint(1)

Enable/disable opportunity's visibility :

  • 1 : Enable
  • 0 : Disable


Default: 1

ID_AO

Int(11)

Unique identifier.

ID_CREATOR

Int(11)


Default: 0

ID_CRMCONTACT

Int(11)


Default: 0

ID_CRMSOCIETE

Int(11)


Default: 0

ID_POLE

Int(11)


Default: 0

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

ID_PROFILRH

Int(11)

TAB_PROFIL.ID_PROFIL.

RH manager.


Default: 0

ID_SOCIETE

Int(11)


Default: 0