Table llx propal: Difference between revisions

Jump to navigation Jump to search

Table llx propal (view source)

Revision as of 06:08, 3 September 2009

1,954 bytes added ,  17 years ago
→‎Structure
VisualWikitext
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/Special:MobileDiff/15633"

Navigation menu