Table llx contratdet: Difference between revisions

← Older edit

Table llx contratdet (view source)

Revision as of 11:20, 25 July 2024

252 bytes added , 2 years ago

m

→‎Table

VisualWikitext

Eldy

Bureaucrats, Interface administrators, Administrators

31,026

edits

@@ Line 15: / Line 15: @@
 = 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 26: / Line 27: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
-|-
+{{FieldTms}}
-| tms
-| timestamp
-| NO
-|
-| CURRENT_TIMESTAMP
-|
-| last update date
 |-
 | fk_contrat
 | int(11)
-|
+| NO
-|
+| MUL
 |
 |
@@ Line 51: / Line 45: @@
 | int(11)
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 79: / Line 73: @@
 |
 | product or service description
+|-
 | fk_remise_except
 | int(11)
-|
+| YES
 |
 | NULL
@@ Line 98: / Line 93: @@
 | datetime
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 106: / Line 101: @@
 | datetime
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 114: / Line 109: @@
 | datetime
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 131: / Line 126: @@
 | YES
 |
-| 0.00
+| 0.000
 |
 | VAT taxes
 |-
 | qty
-| double
+| real
-|
+| NO
 |
 |
@@ Line 144: / Line 139: @@
 |-
 | remise_percent
-| double
+| real
 | YES
 |
@@ Line 155: / Line 150: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | unit price
 |-
 | price_ht
-| double
+| real
 | YES
 |
@@ Line 168: / Line 163: @@
 |-
 | remise
-| double
+| real
 | YES
 |
 | 0
 |
-|
 | discount amount
-|-
+{{FieldTotalFields}}
-| total_ht
+{{FieldInfoBits}}
-| 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
-|-
-| info_bits
-| int(11)
-| YES
-|
-| 0
-|
-| TVA NPR or not
 |-
 | fk_user_author
@@ Line 232: / Line 196: @@
 | ID closer user ([[Table llx_user|llx_user]]->rowid)
 |-
-| comentaire
+| commentaire
 | text
 | YES
@@ Line 238: / Line 202: @@
 | NULL
 |
-| comentary
+| comment
-|}
+|}&nbsp;
+== Keys ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| idx_contratdet_fk_contrat
+| MULTIPLE
+| fk_contrat
+|-
+| idx_contratdet_fk_product
+| MULTIPLE
+| fk_product
+|-
+| idx_contratdet_date_ouverture_prevue
+| MULTIPLE
+| date_ouverture_prevue
+|-
+| idx_contratdet_date_ouverture
+| MULTIPLE
+| date_ouverture
+|-
+| idx_contratdet_date_fin_validite
+| MULTIPLE
+| date_fin_validite
+|}&nbsp;