Table llx commande: Difference between revisions

Jump to navigation Jump to search

Table llx commande (view source)

Revision as of 15:00, 2 June 2009

186 bytes added ,  17 years ago
→‎Structure
VisualWikitext
Line 33: Line 33:
| tms  
| tms  
| timestamp
| timestamp
|  
| NO
|  
|  
| CURRENT_TIMESTAMP
| CURRENT_TIMESTAMP
Line 41: Line 41:
| fk_soc  
| fk_soc  
| int(11)
| int(11)
|  
| NO
|  
|  
|  
|  
Line 47: Line 47:
| ID society ([[Table llx_societe|llx_societe]]->rowid)
| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| fk_soc_contact
| int(11)
|
|
|
|
| ID contact of society ([[Table llx_socpeople|llx_socpeople]]->rowid)
|-
| fk_projet
| fk_projet
| int(11)
| int(11)
Line 66: Line 57:
| ref
| ref
| varchar(30)
| varchar(30)
| YES
|  
|  
|  
|  
|  
|  
|  
| order number
|
|-  
|-  
| entity
| entity
Line 79: Line 70:
|  
|  
| multi company id
| multi company id
|-
| ref_client
| varchar(30)
| YES
|
| NULL
|
| costumer order number
|-
|-
| date_creation
| date_creation
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| creation date
| creation date
Line 90: Line 89:
| date_valid
| date_valid
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| validation date
| validation date
Line 98: Line 97:
| date_cloture
| date_cloture
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| closed date
| closed date
|-
|-
| date_comande
| date_comande
| datetime
| date
|
| YES
|  
|  
|  
| NULL
|  
|  
| order date
| order date
Line 114: Line 113:
| fk_user_author
| fk_user_author
| int(11)
| int(11)
| YES
|  
|  
|  
| NULL
|
|  
|  
| ID creator user ([[Table llx_user|llx_user]]->rowid)
| ID creator user ([[Table llx_user|llx_user]]->rowid)
Line 122: Line 121:
| fk_user_valid
| fk_user_valid
| int(11)
| int(11)
| YES
|  
|  
|  
| NULL
|
|  
|  
| ID validator user ([[Table llx_user|llx_user]]->rowid)
| ID validator user ([[Table llx_user|llx_user]]->rowid)
Line 130: Line 129:
| fk_user_cloture
| fk_user_cloture
| int(11)
| int(11)
| YES
|  
|  
|  
| NULL
|
|  
|  
| ID closer user ([[Table llx_user|llx_user]]->rowid)
| ID closer user ([[Table llx_user|llx_user]]->rowid)
Line 138: Line 137:
| source
| source
| smallint(6)
| smallint(6)
| YES
|  
|  
| NULL
|  
|  
|  
| order source
|
|
|-
|-
| fk_statut
| fk_statut
| smallint(6)
| smallint(6)
|  
| YES
|  
|  
| 0
| 0
Line 154: Line 153:
| amount_ht
| amount_ht
| double
| double
|  
| YES
|  
|  
| 0
| 0
Line 162: Line 161:
| remise_percent
| remise_percent
| double
| double
|  
| YES
|  
|  
| 0
| 0
Line 170: Line 169:
| remise
| remise
| double
| double
|  
| YES
|  
|  
| 0
| 0
Line 178: Line 177:
| tva
| tva
| double(24,8)
| double(24,8)
| YES
|  
|  
|
| 0.00
| 0
|  
|  
|  
|  
Line 186: Line 185:
| total_ht
| total_ht
| double(24,8)
| double(24,8)
| YES
|  
|  
|
| 0.00
| 0
|  
|  
|  
|  
Line 194: Line 193:
| total_ttc
| total_ttc
| double(24,8)
| double(24,8)
| YES
|  
|  
|
| 0.00
| 0
|  
|  
|  
|  
Line 202: Line 201:
| note
| note
| text
| text
| YES
|  
|  
| NULL
|  
|  
| 0
| comentary
|-
| note_public
| text
| YES
|  
|  
| NULL
|  
|  
| public comentary
|-
|-
| model_pdf
| model_pdf
| varchar(50)
| varchar(50)
| YES
|  
|  
| NULL
|  
|  
|  
| Model PDF to print
|
|
|-
|-
| facture
| facture
| tinyint
| tinyint
|  
| YES
|  
|  
| 0
| 0
Line 226: Line 233:
| fk_cond_reglement
| fk_cond_reglement
| int(11)
| int(11)
|  
| YES
|  
|  
| NULL
| NULL
|  
|  
| ID of conditions of payment
| ID conditions of payment
|-
|-
| fk_mode_reglement
| fk_mode_reglement
| int(11)
| int(11)
|  
| YES
|  
|  
| NULL
| NULL
|  
|  
| ID of mode of payment
| ID mode of payment
|-
|-
| date_livraison
| date_livraison
| date
| date
|  
| YES
|  
|  
|  
|  
Line 250: Line 257:
| fk_livraison
| fk_livraison
| int(11)
| int(11)
|  
| YES
|  
|  
| NULL
| NULL
Line 258: Line 265:
| import_key
| import_key
| varchar(14)
| varchar(14)
|  
| YES
|  
|  
| NULL
| NULL
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/12432"

Navigation menu