Difference between revisions of "Table llx livraison"
Jump to navigation
Jump to search
(→Table) |
|||
(7 intermediate revisions by 3 users not shown) | |||
Line 5: | Line 5: | ||
{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]] | {{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]] | ||
− | {{flag fr}} Contient les bons de livraison. | + | {{flag fr}} Contient les bons de livraison. Les lignes de détails des bons de livraison sont dans la [[Table llx_livraisondet]] |
{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]] | {{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]] | ||
= Structure = | = Structure = | ||
− | {| align="left" width="100%" border="0 | + | == 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>Field</b> | ||
|style="background-color: #e9e9ef"| <b>Type</b> | |style="background-color: #e9e9ef"| <b>Type</b> | ||
Line 21: | Line 22: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
− | | | + | | NO |
| PRI | | PRI | ||
− | | | + | | |
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
− | + | {{FieldTms}} | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| ref | | ref | ||
| varchar(30) | | varchar(30) | ||
| NO | | NO | ||
− | | | + | | UNI |
| NULL | | NULL | ||
| | | | ||
Line 45: | Line 39: | ||
| entity | | entity | ||
| int(11) | | int(11) | ||
− | | | + | | NO |
− | | | + | | UNI |
| 1 | | 1 | ||
| | | | ||
| multi company id | | multi company id | ||
|- | |- | ||
− | | | + | | ref_costumer |
| varchar(30) | | varchar(30) | ||
| YES | | YES | ||
Line 62: | Line 56: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
− | | | + | | MUL |
| NULL | | NULL | ||
| | | | ||
| ID of society affected ([[Table llx_societe|llx_societe]]->rowid) | | ID of society affected ([[Table llx_societe|llx_societe]]->rowid) | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| date_creation | | date_creation | ||
Line 87: | Line 71: | ||
| fk_user_author | | fk_user_author | ||
| int(11) | | int(11) | ||
− | | | + | | YES |
− | | | + | | MUL |
− | | | + | | NULL |
| | | | ||
| ID of user made the delivery ([[Table llx_user|llx_user]]->rowid) | | ID of user made the delivery ([[Table llx_user|llx_user]]->rowid) | ||
Line 96: | Line 80: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
− | | | + | | MUL |
| NULL | | NULL | ||
| | | | ||
| 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_delivery |
| date | | date | ||
| YES | | YES | ||
Line 112: | Line 96: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
− | | | + | | MUL |
| NULL | | NULL | ||
| | | | ||
Line 129: | Line 113: | ||
| YES | | YES | ||
| | | | ||
− | | 0. | + | | 0.00000000 |
| | | | ||
| total excluding tax | | total excluding tax | ||
Line 156: | Line 140: | ||
| | | | ||
| Model PDF to print | | Model PDF to print | ||
− | |} | + | |} |
+ | |||
+ | == 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_livraison_uk_ref | ||
+ | | UNIQUE | ||
+ | | ref,entity | ||
+ | |- | ||
+ | | idx_livraison_fk_soc | ||
+ | | MULTIPLE | ||
+ | | fk_soc | ||
+ | |- | ||
+ | | idx_livraison_fk_user_author | ||
+ | | MULTIPLE | ||
+ | | fk_user_author | ||
+ | |- | ||
+ | | idx_livraison_fk_user_valid | ||
+ | | MULTIPLE | ||
+ | | fk_user_valid | ||
+ | |- | ||
+ | | idx_livraison_fk_adresse_livraison | ||
+ | | MULTIPLE | ||
+ | | fk_adresse_livraison | ||
+ | |} |
Latest revision as of 12:43, 10 August 2012
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
Content/Contenu/Contenido
Contains the delivery notes. The delivery notes details are in Table llx_livraisondet
Contient les bons de livraison. Les lignes de détails des bons de livraison sont dans la Table llx_livraisondet
Contiene las notas de entrega. Los detalles de las entregas se encuentran en la Table llx_livraisondet
Structure
Table
Field | Type | Null | Key | Default | Extra | Description |
rowid | int(11) | NO | PRI | auto_increment | technical index | |
tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
ref | varchar(30) | NO | UNI | NULL | delivery number | |
entity | int(11) | NO | UNI | 1 | multi company id | |
ref_costumer | varchar(30) | YES | NULL | customer number | ||
fk_soc | int(11) | YES | MUL | NULL | ID of society affected (llx_societe->rowid) | |
date_creation | datetime | YES | NULL | date of creation | ||
fk_user_author | int(11) | YES | MUL | NULL | ID of user made the delivery (llx_user->rowid) | |
fk_user_valid | int(11) | YES | MUL | NULL | ID of validator user of delivery (llx_user->rowid) | |
date_delivery | date | YES | NULL | date of delivery | ||
fk_adresse_livraison | int(11) | YES | MUL | NULL | ID of delivery adress (llx_societe_adresse_livraison->rowid) | |
statut | smallint(6) | YES | 0 | status of delivery | ||
total_ht | double(24,8) | YES | 0.00000000 | total excluding tax | ||
note | text | YES | NULL | comentary | ||
note_public | text | YES | NULL | public comentary | ||
model_pdf | varchar(50) | YES | NULL | Model PDF to print |
Keys
Key | Type | Fields |
PRIMARY | PRIMARY | rowid |
idx_livraison_uk_ref | UNIQUE | ref,entity |
idx_livraison_fk_soc | MULTIPLE | fk_soc |
idx_livraison_fk_user_author | MULTIPLE | fk_user_author |
idx_livraison_fk_user_valid | MULTIPLE | fk_user_valid |
idx_livraison_fk_adresse_livraison | MULTIPLE | fk_adresse_livraison |