Table llx commandedet: Difference between revisions

← Older edit

Table llx commandedet (view source)

Revision as of 11:18, 25 July 2024

677 bytes removed , 2 years ago

m

→‎Table

VisualWikitext

Eldy

Bureaucrats, Interface administrators, Administrators

31,026

edits

@@ Line 15: / Line 15: @@
 = Structure =
 == Table ==
-'''Version 1.1 2009/10/07'''
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-{|  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>Type</b>
@@ Line 35: / Line 34: @@
 | fk_commande
 | int(11)
-| YES
+| NO
 | MUL
-| NULL
+|
 |
 | ID of order ([[Table llx commande|llx commande]]->rowid)
 |-
+| fk_parent_line
+| int(11)
+| YES
+|
+| NULL
+|
+| Since ?
+|-
 | fk_product
 | int(11)
@@ Line 112: / Line 119: @@
 |
 | price before discount
-|-
+{{FieldTotalFields}}
-| total_ht
-| double(24,8)
-| YES
-|
-| 0.00000000
-|
-| total excluding tax
-|-
-| total_tva
-| double(24,8)
-| YES
-|
-| 0.00000000
-|
-| total tax
-|-
-| total_ttc
-| double(24,8)
-| YES
-|
-| 0.00000000
-|
-| total with tax
 |-
 | product_type
@@ Line 161: / Line 145: @@
 | end date if service
 |-
-| info_bits
+{{FieldInfoBits}}
-| int(11)
-| YES
-|
-| 0
-|
-| TVA NPR or not
-|-
 | marge_tx
 | double(6,3)
@@ Line 185: / Line 162: @@
 | mark rate (margin on selling price)
 |-
-| special_code
+{{FieldSpecialCode}}
-| tinyint(4)
-| YES
-|
-| 0
-|
-| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
 |-
 | rang
@@ Line 201: / Line 172: @@
 | order view
 |-
-| import_key
+{{FieldImportKey}}
-| varchar(14)
-| YES
-|
-| NULL
-|
-| import key
 |}&nbsp;
 == Keys ==
-'''Version 1.1 2009/10/07'''
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-{|  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>