TAB_AO Class

Defined In: /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:1

Opportunity.

Show:

AO_APPLICATIONS

Text

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:30

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)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:103

Estimates.


Default: 0

AO_CA

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:177

Estimated turnover.


Default: 0

AO_CHANGE

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:200

Exchange rate.


Default: 1

AO_CHANGEAGENCE

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:216

Agency's exchange rate.


Default: 1

AO_CORRELATIONPOS

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:239

Enable/disable to validate simulation :

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


Default: 0

AO_DATECLOSING

Date

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:143

Closing's date.

This property can be null.

AO_DATELASTACTIVITY

Datetime

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:137

Last activity date.

AO_DATELIMITE

Date

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:151

Due's date.

This property can be null.

AO_DEVISE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:191

Currency.

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


Default: 0

AO_DEVISEAGENCE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:207

Agency's currency.

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


Default: 0

AO_DUREE

Int(11)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:159

Duration.

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


Default: 0

AO_ETAT

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:168

State.

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


Default: 0

AO_INTERVENTION

Text

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:41

Expertise area.

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


Default: ''

AO_INVESTISSEMENT

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:255

Total additional costs.


Default: 0

AO_LIEU

Text

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:94

Place.

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


Default: ''

AO_OUTILS

Text

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:262

List of tools.

Each tool is described by :

Tools are separated by # character.

Example:

"tool1|2#tool2|4"

AO_PROBA

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:184

Weighting.


Default: 0

AO_REF

Varchar(250)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:50

Reference.


Default: ''

AO_SOURCE

Varchar(100)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:232

Origin's detail.


Default: ''

AO_TARIFADDITIONNEL

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:248

Total additional turnover.


Default: 0

AO_TAUXHORAIRE

Decimal(15,5)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:23

Work unit rate.


Default: 1

AO_TITLE

Varchar(150)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:57

Title.


Default: ''

AO_TYPE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:64

Mode.

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


Default: 0

AO_TYPEDEBUT

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:110

Start's type:

  • 1: Start immediately
  • 2: Start after AO_DEBUT


Default: 1

AO_TYPEREF

Int(11)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:73

Type.

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


Default: 0

AO_TYPESOURCE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:223

Origin.

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


Default: -1

AO_VISIBILITE

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/ao.txt:14

Enable/disable opportunity's visibility :

  • 1 : Enable
  • 0 : Disable


Default: 1