Quotation.

Show:

DEVIS_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

DEVIS_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

DEVIS_COMMENTAIRE

Text

Information comments.

DEVIS_CONDREGLEMENT

Int(11)

Terms of payment.

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


Default: 0

DEVIS_CREATEDAT

Datetime

Creation date

DEVIS_DATE

Date

Date.

DEVIS_DATEACCORDATTENDU

Date

Expected agreement date.

DEVIS_DEBUT

Date

Start date.

This property can be null.

DEVIS_DEVISE

Int(11)

Currency.

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


Default: 0

DEVIS_DEVISEAGENCE

Int(11)

Agency's currency.

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


Default: 0

DEVIS_ECHEANCIER

Text

List of schedules.

Each schedule is described by :

  • Date
  • Description
  • Amount excluding tax
  • Rate of turnover to invoice excluding tax : This property can be empty
  • Date, Description, Amount excluding tax, Rate of turnover to invoice excluding tax are listed in this order and separated by | character

Schedules are separated by # character.

DEVIS_ETAT

Int(11)

State.

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


Default: 0

DEVIS_FIN

Date

End date.

This property can be null.

DEVIS_LANGUE

Char(3)

Language on PDF.

Allowed languages are "fr" & "en".


Default: 'fr'

DEVIS_MENTIONS

Text

Legals.

DEVIS_REF

Varchar(250)

Reference.


Default: ''

DEVIS_REFCLIENT

Varchar(250)

Number.


Default: ''

DEVIS_SHOWAOREFERENCE

Tinyint(1)

Enable/disable to show opportunity's reference on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

DEVIS_SHOWCOMMENTAIRE

Tinyint(1)

Information comments.


Default: 0

DEVIS_SHOWFOOTER

Tinyint(1)

Enable/disable to show footer on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

DEVIS_SHOWNUMBER

Tinyint(1)

Enable/disable to show quotation's number on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

DEVIS_SHOWSIRET

Tinyint(1)

Enable/disable to show registration number on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

DEVIS_SHOWTVAIC

Tinyint(1)

Enable/disable to show V.A.T number on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

DEVIS_TAUXREMISE

Decimal(15,5)

Discount rate.


Default: 0

DEVIS_UPDATEDAT

Datetime

Update date.

ID_AO

Int(11)

TAB_AO.ID_AO.

Opportunity.


Default: 0

ID_COORDONNEES

Int(11)

TAB_COORDONNEES.ID_COORDONNEES.

Quotation's billing details.


Default: 0

ID_CREATOR

Int(11)


Default: 0

ID_CRMCONTACT

Int(11)


Default: 0

ID_CRMSOCIETE

Int(11)


Default: 0

ID_DEVIS

Int(11)

Unique identifier.

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0