4,395
edits
Changes
Table llx commande fournisseurdet (view source)
Revision as of 07:37, 20 October 2009
, 15 years ago→Structure
Line 15:
Line 15:
| NULL
= Structure =
= Structure =
+== Tables ==
+'''Version 1.1 2009/10/07'''
{| 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 26:
Line 28:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
Line 34:
Line 36:
| fk_commande
| fk_commande
| int(11)
| int(11)
−| YES
+| NO
+|
|
|
−|
|
| ID of order ([[Table llx commande|llx commande]]->rowid)
| ID of order ([[Table llx commande|llx commande]]->rowid)
Line 76:
Line 78:
| YES
| YES
|
|
−| NULL
+| 0.000
|
|
| VAT taxes
| VAT taxes
|-
|-
| qty
| qty
−| double
+| real
| YES
| YES
|
|
Line 89:
Line 91:
|-
|-
| remise_percent
| remise_percent
−| double
+| real
| YES
| YES
|
|
Line 97:
Line 99:
|-
|-
| remise
| remise
−| double
+| real
| YES
| YES
|
|
Line 108:
Line 110:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| unit price before
| unit price before
Line 116:
Line 118:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total excluding tax
| total excluding tax
Line 124:
Line 126:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total tax
| total tax
Line 132:
Line 134:
| YES
| YES
|
|
−| 0.00
+| 0.00000000
|
|
| total with tax
| total with tax
Line 167:
Line 169:
|
|
| TVA NPR or not
| TVA NPR or not
−|}
+|}
+== Keys ==
+'''Version 1.1 2009/10/07'''
+{| 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>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|}