Table llx commande fournisseur: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
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
|}
|}

Revision as of 16:14, 2 June 2009


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains the provider orders (orders made to the providers). These orders may be later extended as (provider-) invoices, in which case is used the Table llx_facture_fourn.

Fr verysmall.png La table llx_commande_fournisseur contient les commandes fournisseurs (les commandes effectuées auprès des fournisseurs). Ces commandes peuvent plus tard être étendues sous forme de factures fournisseurs, auquel cas c'est la table Table llx_facture_fourn qui est utilisée.

Es verysmall.png Contiene los pedidos a proveedores (pedidos realizados a los proveedores). Estos pedidos pueden extenderse a facturas de proveedores, en este caso se usa la Table llx_facture_fourn.

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
tms timestamp NO CURRENT_TIMESTAMP last update date
fk_soc int(11) NO ID society (llx_societe->rowid)
fk_projet int(11) 0 ID of proyect (llx_projet->rowid)
ref varchar(30) YES order number
entity int(11)   1 multi company id
ref_supplier varchar(30) YES NULL supplier order number
date_creation datetime YES NULL creation date
date_valid datetime YES NULL validation date
date_cloture datetime YES NULL closed date
date_comande date YES NULL order date
fk_user_author int(11) YES NULL ID creator user (llx_user->rowid)
fk_user_valid int(11) YES NULL ID validator user (llx_user->rowid)
fk_user_cloture int(11) YES NULL ID closer user (llx_user->rowid)
source smallint(6) YES NULL order source
fk_statut smallint(6) YES 0
amount_ht double YES 0
remise_percent double YES 0
remise double YES 0
tva double(24,8) YES 0.00
total_ht double(24,8) YES 0.00
total_ttc double(24,8) YES 0.00
note text YES NULL comentary
note_public text YES NULL public comentary
model_pdf varchar(50) YES NULL Model PDF to print
fk_methode_commande int(11) YES 0 order method
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_commande_fournisseur&oldid=12436"