Dolibarr ERP CRM Wiki

Changes

Table llx propal (view source)

Revision as of 06:08, 3 September 2009

1,954 bytes added ,  15 years ago
→‎Structure
Line 30: Line 30:  
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| fk_soc
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| ID society ([[Table llx_societe|llx_societe]]->rowid)
 +
|-
 +
| fk_projet
 +
| int(11)
 +
|
 +
|
 +
| 0
 +
|
 +
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
 +
|-
 +
| ref
 +
| varchar(30)
 +
| NO
 +
|
 +
|
 +
|
 +
| propal number
 +
|-
 +
| entity
 +
| int(11)
 +
|  
 +
|
 +
| 1
 +
|
 +
| multi company id
 +
|-
 +
| ref_client
 +
| varchar(30)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| costumer order number
 +
|-
 +
| 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)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| statut
 +
|-
 +
| price
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise_percent
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise_absolute
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| total_ht
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| Total without VAT
 +
|-
 +
| tva
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| total VAT
 +
|-
 +
| total
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| 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
 
|}
 
|}
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/15633"