TAB_ACHAT Class

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

Purchase.

Show:

ACHAT_CATEGORIE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:53

Category.

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


Default: 0

ACHAT_CHANGE

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:174

Exchange rate.


Default: 1

ACHAT_CHANGEAGENCE

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:190

Agency's exchange rate.


Default: 1

ACHAT_CONDREGLEMENT

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:147

Terms of payment.

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


Default: 0

ACHAT_DEVISE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:165

Currency.

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


Default: 0

ACHAT_DEVISEAGENCE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:181

Agency's currency.

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


Default: 0

ACHAT_ETAT

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:44

State.

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


Default: 0

ACHAT_LISTETAUXTVA

Tinytext

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:136

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)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:92

Amount excluding tax.


Default: 0

ACHAT_MONTANTTTC

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:99

Amount including tax.


Default: 0

ACHAT_QUANTITE

Decimal(15,5)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:120

Quantity.


Default: 0

ACHAT_REF

Varchar(250)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:21

Reference.


Default: ''

ACHAT_REFACTURE

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:197

Enable/disable to rebill this purchase :

  • 1 : Enable
  • 0 : Disable


Default: 0

ACHAT_REFFOURNISSEUR

Varchar(250)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:28

Number.


Default: ''

ACHAT_SHOWCOMMENTAIRE

Tinyint(1)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:219

Enable/disable to show comments on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

ACHAT_TARIFFACTURE

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:212

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


Default: 0

ACHAT_TAUXREFACTURATION

Float(4)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:206

Rebilling rate.

ACHAT_TAUXTVA

Decimal(15,5)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:127

Tax rate.

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


Default: 0

ACHAT_TITLE

Varchar(150)

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

Title.


Default: ''

ACHAT_TOTALHT

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:106

Total excluding tax.


Default: 0

ACHAT_TOTALTTC

Decimal(30,10)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:113

Total including tax.


Default: 0

ACHAT_TYPE

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:35

Subscription's type.

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


Default: 0

ACHAT_TYPEPAYMENT

Tinyint(2)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:156

Method of payment.

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


Default: 0

ID_COORDONNEES

Int(11)

Defined in /home/wishrepair/Projets/BoondManager/Back_End/docs/SQL/BoondManager/achat.txt:228

TAB_USER.ID_USER.

Company's billing details.


Default: 0