Table llx commande fournisseur: Difference between revisions

Jump to navigation Jump to search

Table llx commande fournisseur (view source)

Revision as of 16:14, 2 June 2009

400 bytes added ,  17 years ago
→‎Structure
VisualWikitext
Line 14: Line 14:


= Structure =
= Structure =
{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0"  style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0"  style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Field</b>
Line 33: Line 32:
|-
|-
| tms  
| tms  
| timestamp  
| timestamp
| NO  
| NO
|
| CURRENT_TIMESTAMP
|
|  
|  
| CURRENT_TIMESTAMP
|
| last update date
|-
|-
| fk_soc  
| fk_soc  
| int(11)  
| int(11)
| NO  
| NO
| MUL
|  
|
|  
|
|  
| ID of society
| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| fk_projet  
| fk_projet
| int(11)
| int(11)
| YES
|  
|
|  
| 0
| 0
|
|  
| ID of proyect
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
|-
| ref  
| ref
| varchar(30)
| varchar(30)
| NO
| YES
| UNI
|  
|
|
| order number
|-
| entity
| int(11)
| &nbsp;
|  
|  
|
| 1
|  
|  
| multi company id
|-
|-
| date_creation
| ref_supplier
| datetime
| varchar(30)
| YES  
| YES
|
| NULL
|
|  
|  
| NULL
|
| supplier order number
|-
|-
| date_valid
| date_creation
| datetime  
| datetime
| YES  
| YES
|
|  
| NULL  
| NULL
|
|  
|  
| creation date
|-
|-
| date_cloture
| date_valid
| datetime  
| datetime
| YES  
| YES
|
| NULL
|  
|  
| NULL
| validation date
|-
| date_cloture
| datetime
| YES
|  
|  
| NULL
|  
|  
| closed date
|-
|-
| date_commande
| date_comande
| date  
| date
| YES  
| YES
|  
|  
| NULL  
| NULL
| 
|  
|  
| order date
|-
|-
| fk_user_author  
| fk_user_author
| int(11)  
| int(11)
| YES  
| YES
|  
|  
| NULL  
| 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_valid
| fk_user_cloture
| int(11)  
| int(11)
| YES  
| YES
|
|  
| NULL  
| NULL
|
|  
|  
| ID closer user ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_cloture
| source
| int(11)  
| smallint(6)
| YES  
| YES
|
| NULL
|  
|  
| NULL
|  
|  
| order source
|-
|-
| source
| fk_statut
| smallint(6)  
| smallint(6)
| NO
| YES
|
|  
|
| 0
|
|  
|  
|  
|-
|-
| fk_statut
| amount_ht
| smallint(6)
| double
| YES  
| YES
|
|  
| 0  
| 0
|
|  
| 0 pour brouillon, 1 pour validée, 2 pour "approuvée", 5 pour "reçu complètement"
|  
|-
|-
| amount_ht
| remise_percent
| double  
| double
| YES  
| YES
|
|  
| 0  
| 0
|  
|  
|  
|  
|-
|-
| remise_percent
| remise
| double  
| double
| YES  
| YES
|
|  
| 0  
| 0
|
|  
|  
|  
|-
|-
| remise
| tva
| double  
| double(24,8)
| YES  
| YES
|
| 0.00
|  
|  
| 0
|
|  
|  
|-
|-
| tva
| total_ht
| double  
| double(24,8)
| YES  
| YES
|
| 0.00
|  
|  
| 0
|
|  
|  
|-
|-
| total_ht
| total_ttc
| double  
| double(24,8)
| YES  
| YES
|
|  
| 0
| 0.00
|  
|  
|  
|  
|-
|-
| total_ttc
| note
| double
| text
| YES  
| YES
|  
|  
| 0 
| NULL
|
|  
|  
| comentary
|-
|-
| note
| note_public
| text  
| text
| YES  
| YES
|
| NULL
|
|  
|  
|-
| NULL
| note_public
| text
| YES
|
| NULL  
|
|  
|  
| public comentary
|-
|-
| model_pdf  
| model_pdf
| varchar(50)
| varchar(50)
| YES  
| YES
|  
|  
| NULL  
| NULL
|
|  
|  
| Model PDF to print
|-
|-
| fk_methode_commande  
| fk_methode_commande
| int(11)  
| int(11)
| YES  
| YES
|
| 0
|  
|  
| 0
|  
|  
| order method
|}
|}
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/12436"

Navigation menu