Quotation.

Show:

DEVIS_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

DEVIS_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

DEVIS_CONDREGLEMENT

Tinyint(1)

Terms of payment.

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


Default: 0

DEVIS_DATEACCORDATTENDU

Date

Expected agreement date.

DEVIS_DEBUT

Date

Start date.

This property can be null.

DEVIS_DEVISE

Tinyint(2)

Currency.

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


Default: 0

DEVIS_DEVISEAGENCE

Tinyint(2)

Agency's currency.

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

Tinyint(2)

State.

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

ID_COORDONNEES

Int(11)

TAB_COORDONNEES.ID_COORDONNEES.

Quotation's billing details.


Default: 0