TAB_PRODUIT Class

Product.

Show:

ID_CREATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Creator.


Default: 0

ID_POLE

Int(11)

TAB_POLE.ID_POLE.

Pole.


Default: 0

ID_PRODUIT

Int(11)

Unique identifier.

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.


Default: 0

ID_SOCIETE

Int(11)

TAB_SOCIETE.ID_SOCIETE.

Agency.


Default: 0

PRODUIT_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

PRODUIT_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

PRODUIT_CREATEDAT

Date

Creation date.

PRODUIT_DATEUPDATE

Datetime

Update date.

PRODUIT_DESCRIPTION

Text

Description.

PRODUIT_DEVISE

Int(11)

Currency.

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


Default: 0

PRODUIT_DEVISEAGENCE

Int(11)

Agency's currency.

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


Default: 0

PRODUIT_ETAT

Int(11)

State.

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


Default: 1

PRODUIT_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

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.setting.taxRate of API /application/dictionary.


Default: 0

PRODUIT_TYPE

Int(11)

Subscription's type.

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


Default: 0

PRODUIT_UPDATEDAT

Datetime

Update date.