LISTE DES CHAMPS POUR LA TABLE ACTION.
-Non utilisé
RRequis
N-ANon autorisé
OOptionnel
LÉGENDE
NOM |
TYPE |
OPÉRATIONS |
DESCRIPTION |
LISTER |
DÉTAIL |
AJOUTER |
ÉDITER |
SUPPRIMER |
idaction |
int(10) |
Lecture |
Id de l'action. |
- |
R |
N-A |
R |
R |
idutilisateur |
int(11) |
Lecture |
Id de l'utilisateur. |
- |
- |
N-A |
N-A |
- |
idcontact |
int(10) |
Lecture-Ecriture |
Id du contact. |
- |
- |
O |
O |
- |
idsociete |
int(10) |
Lecture-Ecriture |
Id de la société. |
- |
- |
O |
O |
- |
idprojet |
int(11) |
Lecture-Ecriture |
Id du projet. |
- |
- |
O |
O |
- |
date_mod |
datetime |
Lecture |
Date de dernière modification. |
- |
- |
N-A |
N-A |
- |
date_action |
datetime |
Lecture-Ecriture |
Date de l'action. |
- |
- |
N-A |
N-A |
- |
duree_heures |
int(11) |
Lecture-Ecriture |
durée heures. |
- |
- |
N-A |
N-A |
- |
duree_minutes |
int(11) |
Lecture-Ecriture |
durée minutes. |
- |
- |
N-A |
N-A |
- |
date_fin |
datetime |
Lecture-Ecriture |
Date_action + duree_heures + duree_minutes, dans le fuseau horaire du client au format YYYY-MM-DD HH:MM:00. |
- |
- |
N-A |
N-A |
- |
date_echeance |
date |
Lecture-Ecriture |
Date d'échéance. |
- |
- |
O |
O |
- |
date_stat |
date |
Lecture |
date_action au format YYYY-MM-DD, fuseau horaire du client. |
- |
- |
N-A |
N-A |
- |
color |
varchar(200) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
sujet |
varchar(255) |
Lecture-Ecriture |
|
- |
- |
R |
R |
- |
location |
varchar(255) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
idmedia |
int(11) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
idtype_action |
int(11) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
iddocument_type |
int(11) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
idsuivi_facture |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
budget |
decimal(11,2) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
budget_pondere |
decimal(11,2) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
source |
varchar(255) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
ref_document |
varchar(255) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
note |
text |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
etape_suivante |
varchar(255) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
etat |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
all_day |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
recurring_rule |
varchar(255) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
priorite |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
ss_datetime |
datetime |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
ss_status |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
idaction_parent |
int(11) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
livrable |
tinyint(1) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
droits |
text |
Lecture |
|
- |
- |
N-A |
O |
- |
type_id |
int(11) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
gross |
decimal(25,6) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
tax_amount |
decimal(25,6) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
total |
decimal(25,6) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_lock |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_idaction_from |
int(11) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_modele_id |
int(11) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_stock_genere |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_doc_genere |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_facture_genere |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_bl_genere |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_commande_fournisseur_genere |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_vente_gagnee_genere |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_biller_id |
int(11) |
Lecture-Ecriture |
text |
- |
- |
O |
O |
- |
paiement_txt |
text |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
rappel_envoye |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
e_rappel_facture_envoye |
tinyint(4) |
Lecture-Ecriture |
|
- |
- |
O |
O |
- |
cont_custx (x = 1 à 100) |
|
Lecture-Ecriture |
Champs personnalisé. Son type dépendra de la configuration du CRM. Il doit être configuré au préalable pour être utilisable. |
- |
- |
o |
o |
- |
|