Difference between revisions of "Table llx commandedet"

Latest revision as of 11:18, 25 July 2024

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

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contient les détails des commandes clients, cette table est liée avec la Table llx_commande

Contains details of customer orders. This table is linked to Table llx_commande

Contiene los detalles de los pedidos de clientes, esta tabla esta vinculada con Table llx_commande

Structure

Table

Field

Type

Null

Key

Default

Extra

Description

rowid

int(11)

NO

PRI

auto_increment

technical index

fk_commande

int(11)

NO

MUL

ID of order (llx commande->rowid)

fk_parent_line

int(11)

YES

NULL

Since ?

fk_product

int(11)

YES

NULL

ID of product (llx_product->rowid)

description

text

YES

NULL

product or service description

tva_tx

double(6,3)

YES

NULL

VAT taxes

qty

real

YES

NULL

Quantity of product or service

remise_percent

real

YES

0

discount percentage

remise

real

YES

0

discount amount

fk_remise_except

int(11)

YES

NULL

ID of discount (llx_societe_remise_except->rowid)

price

real

YES

NULL

final price

subprice

double(24,8)

YES

0.00000000

price before discount

total_ht

double(24,8)

YES

NULL

total excluding taxes

total_tva

double(24,8)

YES

NULL

total tax

total_localtax1

double(24,8)

YES

NULL

total local tax 1

total_localtax2

double(24,8)

YES

NULL

total local tax 2

total_ttc

double(24,8)

YES

NULL

Total including discount and taxes (vat + localtax1 + localtax2)

product_type

int(11)

YES

0

type of prodcut

date_start

datetime

YES

NULL

start date if service

date_end

datetime

YES

NULL

end date if service

info_bits

integer

0

TVA NPR or NOT

marge_tx

double(6,3)

YES

0.000

margin (margin on purchase price)

marque_tx

double(6,3)

YES

0.000

mark rate (margin on selling price)

special_code

integer

YES

0

0=default, 1=seems no more used (or may be used to set line as transport/shipping fee), 2=used by WEEE module to define line as a WEEE line, 3=option line (price must not included in total), 4=Sent for cooking (POS modules for restaurant), Module ID (>= 5)=value for a custom need. Value is an additional information and has no effect, except value 3 that means "do not take into account amount, it is an option" (so price must not be included in total, qty in this case should be also 0).

rang

int(11)

YES

0

order view

import_key

varchar(14)

YES

NULL

Code used to save the import id. See page Field Import key.

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
idx_commandedet_fk_commande	MULTIPLE	fk_commande

@@ Line 14: / Line 14: @@
 = 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"
+== Table ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
   |style="background-color: #e9e9ef"| <b>Field</b>
   |style="background-color: #e9e9ef"| <b>Type</b>
@@ Line 25: / Line 26: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
 |-
 | fk_commande
+| int(11)
+| NO
+| MUL
+|
+|
+| ID of order ([[Table llx commande|llx commande]]->rowid)
+|-
+| fk_parent_line
 | int(11)
 | YES
@@ Line 37: / Line 46: @@
 | NULL
 |
-| ID of order ([[Table llx commande|llx commande]]->rowid)
+| Since ?
 |-
 | fk_product
 | int(11)
@@ Line 64: / Line 73: @@
 |-
 | qty
-| double
+| real
 | YES
 |
@@ Line 72: / Line 81: @@
 |-
 | remise_percent
-| double
+| real
 | YES
 |
@@ Line 80: / Line 89: @@
 |-
 | remise
-| double
+| real
 | YES
 |
@@ Line 89: / Line 98: @@
 | fk_remise_except
 | int(11)
-|
+| YES
 |
 | NULL
@@ Line 96: / Line 105: @@
 |-
 | price
-| double
+| real
 | YES
 |
@@ Line 107: / Line 116: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | price before discount
-|-
+{{FieldTotalFields}}
-| total_ht
-| double(24,8)
-| YES
-|
-| 0.00
-|
-| total excluding tax
-|-
-| total_tva
-| double(24,8)
-| YES
-|
-| 0.00
-|
-| total tax
-|-
-| total_ttc
-| double(24,8)
-| YES
-|
-| 0.00
-|
-| total with tax
 |-
 | product_type
@@ Line 159: / Line 145: @@
 | end date if service
 |-
-| info_bits
+{{FieldInfoBits}}
-| int(11)
-| YES
-|
-| 0
-|
-| TVA NPR or not
-|-
 | marge_tx
 | double(6,3)
 | YES
 |
-| 0.00
+| 0.000
 |
 | margin (margin on purchase price)
@@ Line 179: / Line 158: @@
 | YES
 |
-| 0.00
+| 0.000
 |
 | 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 199: / Line 172: @@
 | order view
 |-
-| import_key
+{{FieldImportKey}}
-| varchar(14)
+|}&nbsp;
-| YES
-|
+== Keys ==
-| NULL
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-|
+ |style="background-color: #e9e9ef"| <b>Key</b>
-| import key
+ |style="background-color: #e9e9ef"| <b>Type</b>
-|}
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| idx_commandedet_fk_commande
+| MULTIPLE
+| fk_commande
+|}&nbsp;

Difference between revisions of "Table llx commandedet"

Latest revision as of 11:18, 25 July 2024

Content/Contenu/Contenido

Structure

Table

Keys

Navigation menu

Search