Dolibarr ERP CRM Wiki

Changes

Table llx propal (view source)

Revision as of 12:50, 10 August 2012

3,082 bytes added ,  12 years ago
→‎Table
Line 1: Line 1:  
[[Category:Table SQL]]
 
[[Category:Table SQL]]
−
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
+
[[Category:Propal]]
−
  The documentation related to other tables is available on the tables list page: [[Liste des tables]]
+
[[Category:Proposal]]
 +
[[Category:Presupuestos]]
   −
= Contenu =
+
{{ListOfTables}}
    +
= Content/Contenu/Contenido =
 +
{{flag en}} Contains customer proposals. The details are in [[Table llx_propaldet]]
 +
 +
{{flag fr}} Contient des propositions commerciales , les détails sont dans la [[Table llx_propaldet]]
 +
 +
{{flag sp}} Contiene los presupuestos, los detalles están en  la [[Table llx_propaldet]]
    
= Structure =
 
= Structure =
 +
== Table ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Field</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Null</b>
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Default</b>
 +
|style="background-color: #e9e9ef"| <b>Extra</b>
 +
|style="background-color: #e9e9ef"| <b>Description</b>
 +
|-
 +
| rowid
 +
| int(11)
 +
| NO
 +
| PRI
 +
|
 +
| auto_increment
 +
| technical index
 +
|-
 +
| ref
 +
| varchar(30)
 +
| NO
 +
| UNI
 +
|
 +
|
 +
| propal number
 +
{{FieldEntity}}
 +
{{FieldRefExt}}
 +
|-
 +
| ref_client
 +
| varchar(30)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| costumer proposal number
 +
|-
 +
| fk_soc
 +
| int(11)
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| ID society ([[Table llx_societe|llx_societe]]->rowid)
 +
|-
 +
| fk_projet
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| ID of project ([[Table llx_projet|llx_projet]]->rowid)
 +
{{FieldTms}}
 +
|-
 +
| datec
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| creation date
 +
|-
 +
| datep
 +
| date
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| proposal date
 +
|-
 +
| fin_validite
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| end valid date
 +
|-
 +
| date_valid
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| validation date
 +
|-
 +
| date_cloture
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| closed date
 +
|-
 +
| fk_user_author
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID creator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_valid
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID validator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_cloture
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID closer user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_statut
 +
| smallint(6)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| statut
 +
|-
 +
| price
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise_percent
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise_absolute
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| total_ht
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00000000
 +
|
 +
| Total without VAT
 +
|-
 +
| tva
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00000000
 +
|
 +
| total VAT
 +
{{FieldLocalTaxX}}
 +
|-
 +
| total
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00000000
 +
|
 +
| Total TTC
 +
|-
 +
| fk_cond_reglement
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
 +
|-
 +
| fk_mode_reglement
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of payment mode
 +
|-
 +
| note
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| comentary
 +
|-
 +
| note_public
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| public comentary
 +
|-
 +
| model_pdf
 +
| varchar(50)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| Model PDF to print
 +
|-
 +
| date_livraison
 +
| date
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| delivery date
 +
|-
 +
| fk_livraison
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of delivery address
 +
|}&nbsp;
 +
 +
== Keys ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Fields</b>
 +
|-
 +
| PRIMARY
 +
| PRIMARY
 +
| rowid
 +
|-
 +
| uk_propal_ref
 +
| UNIQUE
 +
| ref,entity
 +
|-
 +
| idx_propal_fk_soc
 +
| MULTIPLE
 +
| fk_soc
 +
|}&nbsp;
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/8145...26739"