Opportunity.

Show:

AO_APPLICATIONS

Text

List of activity areas.

Each activity area is described by key option.id for JSON response data.settings.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_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_DEVISE

Tinyint(2)

Currency.

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


Default: 0

AO_DEVISEAGENCE

Tinyint(2)

Agency's currency.

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


Default: 0

AO_DUREE

Int(11)

Duration.

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


Default: 0

AO_ETAT

Tinyint(2)

State.

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


Default: 0

AO_INTERVENTION

Text

Expertise area.

cf. key option.id for JSON response data.settings.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.settings.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_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

Tinyint(2)

Mode.

cf. key mode for JSON response data.settings.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.settings.typeOf.project of API /application/dictionary


Default: 0

AO_TYPESOURCE

Tinyint(2)

Origin.

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


Default: -1

AO_VISIBILITE

Tinyint(1)

Enable/disable opportunity's visibility :

  • 1 : Enable
  • 0 : Disable


Default: 1