Table llx livraison: Difference between revisions

 
(5 intermediate revisions by 2 users not shown)
Line 11: Line 11:
= Structure =
= Structure =
== Table ==
== 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>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 28: Line 27:
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
{{FieldTms}}
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|
| last update date
|-
|-
| ref
| ref
Line 53: Line 45:
| multi company id
| multi company id
|-
|-
| ref_client
| ref_costumer
| varchar(30)
| varchar(30)
| YES
| YES
Line 68: Line 60:
|  
|  
| ID of society affected ([[Table llx_societe|llx_societe]]->rowid)
| ID of society affected ([[Table llx_societe|llx_societe]]->rowid)
|-
| fk_expedition
| int(11)
| YES
|
| NULL
|
| ID of related expedition([[Table llx_expedition|llx_expedition]]->rowid)
|-
|-
| date_creation
| date_creation
Line 101: Line 85:
| ID of validator user of delivery ([[Table llx_user|llx_user]]->rowid)
| ID of validator user of delivery ([[Table llx_user|llx_user]]->rowid)
|-
|-
| date_livraison
| date_delivery
| date
| date
| YES
| YES
Line 157: Line 141:
| Model PDF to print
| Model PDF to print
|}&nbsp;
|}&nbsp;
== Keys ==
== 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>Key</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>