Purchase.

Show:

ACHAT_CATEGORIE

Tinyint(2)

Category.

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


Default: 0

ACHAT_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

ACHAT_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

ACHAT_CONDREGLEMENT

Tinyint(1)

Terms of payment.

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


Default: 0

ACHAT_DEVISE

Tinyint(2)

Currency.

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


Default: 0

ACHAT_DEVISEAGENCE

Tinyint(2)

Agency's currency.

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


Default: 0

ACHAT_ETAT

Tinyint(2)

State.

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


Default: 0

ACHAT_LISTETAUXTVA

Tinytext

Tax rates.

cf. JSON response data.settings.taxRate of API /application/dictionary.

Tax rates are separated by | character.

Example:

20|10|5.5

ACHAT_MONTANTHT

Decimal(30,10)

Amount excluding tax.


Default: 0

ACHAT_MONTANTTTC

Decimal(30,10)

Amount including tax.


Default: 0

ACHAT_QUANTITE

Decimal(15,5)

Quantity.


Default: 0

ACHAT_REF

Varchar(250)

Reference.


Default: ''

ACHAT_REFACTURE

Tinyint(1)

Enable/disable to rebill this purchase :

  • 1 : Enable
  • 0 : Disable


Default: 0

ACHAT_REFFOURNISSEUR

Varchar(250)

Number.


Default: ''

ACHAT_SHOWCOMMENTAIRE

Tinyint(1)

Enable/disable to show comments on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

ACHAT_TARIFFACTURE

Decimal(30,10)

Price rebilled excluding tax if this purchase has to be rebilled.


Default: 0

ACHAT_TAUXREFACTURATION

Float(4)

Rebilling rate.

ACHAT_TAUXTVA

Decimal(15,5)

Tax rate.

cf. JSON response data.settings.taxRate of API /application/dictionary.


Default: 0

ACHAT_TITLE

Varchar(150)

Title.


Default: ''

ACHAT_TOTALHT

Decimal(30,10)

Total excluding tax.


Default: 0

ACHAT_TOTALTTC

Decimal(30,10)

Total including tax.


Default: 0

ACHAT_TYPE

Tinyint(2)

Subscription's type.

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


Default: 0

ACHAT_TYPEPAYMENT

Tinyint(2)

Method of payment.

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


Default: 0

ID_COORDONNEES

Int(11)

TAB_USER.ID_USER.

Company's billing details.


Default: 0