Product.

Show:

PRODUIT_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

PRODUIT_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

PRODUIT_DEVISE

Tinyint(2)

Currency.

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


Default: 0

PRODUIT_DEVISEAGENCE

Tinyint(2)

Agency's currency.

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


Default: 0

PRODUIT_ETAT

Tinyint(2)

State.

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


Default: 1

PRODUIT_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

PRODUIT_NOM

Varchar(150)

Name.


Default: ''

PRODUIT_REF

Varchar(250)

Reference.


Default: ''

PRODUIT_TARIFHT

Decimal(30,10)

Price excluding tax.


Default: 0

PRODUIT_TARIFTTC

Decimal(30,10)

Price including tax


Default: 0

PRODUIT_TAUXTVA

Decimal(15,5)

Tax rate.

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


Default: 0

PRODUIT_TYPE

Tinyint(1)

Subscription's type.

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


Default: 0