TAB_ACHAT Class

Purchase.

Show:

ACHAT_CATEGORIE

Int(11)

Category.

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

Text

Information comments.

ACHAT_CONDREGLEMENT

Int(11)

Terms of payment.

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


Default: 0

ACHAT_CREATEDAT

Datetime

Creation date

ACHAT_DATE

Date

Date.

ACHAT_DEBUT

Date

Start date.

ACHAT_DEVISE

Int(11)

Currency.

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


Default: 0

ACHAT_DEVISEAGENCE

Int(11)

Agency's currency.

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


Default: 0

ACHAT_ETAT

Int(11)

State.

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


Default: 0

ACHAT_FIN

Date

End date.

ACHAT_LISTETAUXTVA

Tinytext

Tax rates.

cf. JSON response data.setting.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.setting.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

Int(11)

Subscription's type.

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


Default: 0

ACHAT_TYPEPAYMENT

Int(11)

Method of payment.

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


Default: -1

ID_ACHAT

Int(11)

Unique identifier.

ID_COORDONNEES

Int(11)

TAB_USER.ID_USER.

Company's billing details.


Default: 0

ID_CREATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Creator.


Default: 0

ID_CRMCONTACT

Int(11)

TAB_CRMCONTACT.ID_CRMCONTACT.

Provider contact.


Default: 0

ID_CRMSOCIETE

Int(11)

TAB_CRMSOCIETE.ID_CRMSOCIETE.

Provider company.


Default: 0

ID_POLE

Int(11)

TAB_POLE.ID_POLE.

Pole.


Default: 0

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

ID_PROJET

Int(11)

TAB_PROJECT.ID_PROJET.

Project.


Default: 0

ID_SOCIETE

Int(11)

TAB_SOCIETE.ID_SOCIETE.

Agency.


Default: 0