TAB_MISSIONPROJET Class
Delivery/Groupment.
Properties
- ID_ACHAT
- ID_CONTRAT
- ID_CREATOR
- ID_ITEM
- ID_MASTER
- ID_MISSIONPROJET
- ID_PARENT
- ID_PROJET
- ITEM_TYPE
- MP_AVANTAGES
- MP_CJM
- MP_COMMENTAIRES
- MP_CONDITIONS
- MP_CREATEDAT
- MP_DEBUT
- MP_DUREEHEBDOMADAIRE
- MP_FIN
- MP_FORCETARIF
- MP_FORCETARIFHEURE
- MP_FRSJOUR
- MP_FRSMENSUEL
- MP_INVESTISSEMENT
- MP_NBJRSFACTURE
- MP_NBJRSGRATUIT
- MP_NBJRSOUVRE
- MP_NOM
- MP_PRJM
- MP_REGLESTEMPSEXCEPTION
- MP_TARIF
- MP_TARIFADDITIONNEL
- MP_TARIFHEURE
- MP_TYPE
- MP_TYPE_PRESTATION
- MP_UPDATEDAT
ID_ITEM
Int(11)Entity's identifier :
- Delivery with a resource : if TAB_MISSIONPROJET.ITEM_TYPE is
0, cf. TAB_PROFIL.ID_PROFIL - Delivery with a product : if TAB_MISSIONPROJET.ITEM_TYPE is
1, cf. TAB_PRODUIT.ID_PRODUIT
Default: 0
ITEM_TYPE
Tinyint(1)Entity's type :
0: Delivery with a resource1: Delivery with a product5: Groupment with proportional distribution6: Groupment with weighted distribution7: Groupment with manual distribution
Default: 0
MP_AVANTAGES
TextList of advantages.
Each advantage is described by :
- Reference : cf. TAB_TYPEAVANTAGE.TYPEA_REF
- Frequency : cf. TAB_TYPEAVANTAGE.TYPEA_TYPE
- Category : cf. TAB_TYPEAVANTAGE.TYPEA_CATEGORIE
- Participation amount : cf. TAB_TYPEAVANTAGE.TYPEA_QUOTAPARTICIPATION
- Employee amount : cf. TAB_TYPEAVANTAGE.TYPEA_QUOTARESSOURCE
- Agency amount : cf. TAB_TYPEAVANTAGE.TYPEA_QUOTASOCIETE
- Agency's identifier : cf. TAB_TYPEAVANTAGE.ID_SOCIETE
- Reference, frequency, category, participation amount, employee amount, agency amount and agency's identifier are listed in this order and separated by
|character
Advantages are separated by # character.
MP_CONDITIONS
Text- if TAB_MISSIONPROJET.ITEM_TYPE ∈ {0,1} : Special conditions
- if TAB_MISSIONPROJET.ITEM_TYPE ∈ {5,6,7} : List of deliveries included in this groupment
Each delivery, in this groupment, is described by :
- Unique identifier : cf. TAB_MISSIONPROJET.ID_MISSIONPROJET
- Distribution value : This value can be proportional, weighted or manual following ITEM_TYPE
- Number of invoiced days : cf. TAB_MISSIONPROJET.MP_NBJRSFACTURE
- Unique identifier, distribution value & number of invoiced days are listed in this order and separated by
|character
Deliveries are separated by # character.
MP_FORCETARIF
Tinyint(1)Enable/disable to manually define MP_TARIF, available only if delivery belongs to a groupment :
1: Enable0: Disable_
Default: 1
MP_FORCETARIFHEURE
Tinyint(1)Enable/disable to manually define MP_TARIFHEURE :
1: Enable0: Disable
Default: 0
MP_INVESTISSEMENT
Decimal(30,10)Additional investment.
Only available if TAB_PROJET.PRJ_TYPE > 0.
Default: 0
MP_REGLESTEMPSEXCEPTION
TextList of exceptional scales.
Each scale is described by :
- Scale information :
- Unique identifier : cf. if entity's type =
0then TAB_GROUPECONFIG.GRPCONF_BAREMESEXCEPTION else TAB_CRMSOCIETE.CSOC_BAREMESEXCEPTION - Entity's type : ∈ {0, 1}
- Entity's identifier : cf. if entity's type =
0then TAB_GROUPECONFIG.ID_SOCIETE else TAB_CRMSOCIETE.ID_CRMSOCIETE - Unique identifier, entity's type & entity's identifier are listed in this order and separated by
_character
- Unique identifier : cf. if entity's type =
- List of rules :
- Each rule is described by :
- Reference : TAB_REGLEEXCEPTION.REGLE_REF, with TAB_REGLEEXCEPTION.REGLE_BAREMEREF =
Scale's unique identifier& TAB_REGLEEXCEPTION.PARENT_TYPE =Entity's type& TAB_REGLEEXCEPTION.ID_PARENT =Entity's identifier - Price excluding tax or price rate : If
not emptythen replace TAB_REGLEEXCEPTION.REGLE_TARIF
- Reference : TAB_REGLEEXCEPTION.REGLE_REF, with TAB_REGLEEXCEPTION.REGLE_BAREMEREF =
- Gross cost or salary rate : If
not emptythen replace TAB_REGLEEXCEPTION.REGLE_COUT- Reference, Price excluding tax or price rate & Gross cost or salary rate are listed in this order and separated by
_character
- Reference, Price excluding tax or price rate & Gross cost or salary rate are listed in this order and separated by
- Rules are separated by
|character
- Each rule is described by :
- Scale information & Liste of rules are listed in this order and separated by
|character
Scales are separated by # character.
Example:
"1_0_1|1||#2_0_1|2|100|"
MP_TARIFADDITIONNEL
Decimal(30,10)Additional turnover.
Only available if TAB_PROJET.PRJ_TYPE > 0.
Default: 0
MP_TYPE
Int(11)State.
Only available if TAB_PROJET.PRJ_TYPE > 0.
cf. key id for JSON response data.setting.state.delivery of API /application/dictionary
Default: 0
MP_TYPE_PRESTATION
Int(11)TypeOf.
Only available if TAB_PROJET.PRJ_TYPE > 0.
cf. key id for JSON response data.setting.typeOf.delivery of API /application/dictionary
Default: 0