Delivery/Groupment.

Show:

ID_ITEM

Int(11)

Entity's identifier :


Default: 0

ITEM_TYPE

Tinyint(1)

Entity's type :

  • 0 : Delivery with a resource
  • 1 : Delivery with a product
  • 5 : Groupment with proportional distribution
  • 6 : Groupment with weighted distribution
  • 7 : Groupment with manual distribution


Default: 0

MP_AVANTAGES

Text

List of advantages.

Each advantage is described by :

Advantages are separated by # character.

MP_CJM

Decimal(30,10)

Average daily cost.


Default: 0

MP_CONDITIONS

Text

Each delivery, in this groupment, is described by :

Deliveries are separated by # character.

MP_DUREEHEBDOMADAIRE

Decimal(15,5)

Weekly duration of work.


Default: 0

MP_FORCETARIF

Tinyint(1)

Enable/disable to manually define MP_TARIF, available only if delivery belongs to a groupment :

  • 1 : Enable
  • 0 : Disable_


Default: 1

MP_FORCETARIFHEURE

Tinyint(1)

Enable/disable to manually define MP_TARIFHEURE :

  • 1 : Enable
  • 0 : Disable


Default: 0

MP_FRSJOUR

Decimal(30,10)

Daily net expenses.


Default: 0

MP_FRSMENSUEL

Decimal(30,10)

Monthly net expenses.


Default: 0

MP_INVESTISSEMENT

Decimal(30,10)

Additional investment.

Only available if TAB_PROJET.PRJ_TYPE > 0.


Default: 0

MP_NBJRSFACTURE

Decimal(30,10)

Number of invoiced days.


Default: 0

MP_NBJRSGRATUIT

Decimal(30,10)

Number of free days.


Default: 0

MP_NBJRSOUVRE

Decimal(15,5)

Number of working days.


Default: 0

MP_PRJM

Decimal(30,10)

Average daily cost without advantages & expenses details.


Default: 0

MP_REGLESTEMPSEXCEPTION

Text

List of exceptional scales.

Each scale is described by :

Scales are separated by # character.

Example:

"1_0_1|1||#2_0_1|2|100|"

MP_TARIF

Decimal(30,10)

Daily price excluding tax.


Default: 0

MP_TARIFADDITIONNEL

Decimal(30,10)

Additional turnover.

Only available if TAB_PROJET.PRJ_TYPE > 0.


Default: 0

MP_TARIFHEURE

Decimal(30,10)

Hourly price excluding tax.


Default: 0

MP_TYPE

Tinyint(1)

State.

Only available if TAB_PROJET.PRJ_TYPE > 0.

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


Default: 0