4,395
edits
Changes
→Structure
Line 14:
Line 14:
+|-
−| entity
−| int(11)
−|
−|
−| 1
−|
−| multi company id
+ +
= Structure =
= Structure =
−== Table ==
+'''Version 1.1 2009/10/07'''
{| 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"
{| 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>
Line 26:
Line 27:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
−|-
|-
| facnumber
| facnumber
| varchar(50)
| varchar(50)
| NO
| NO
−| MUL
+| UNI
|
|
|
|
| invoice number
| invoice number
+|-
+| entity
+| int(11)
+| NO
+| UNI
+| 1
+|
+| multi company id
|-
|-
| type
| type
Line 59:
Line 60:
| int(11)
| int(11)
| NO
| NO
−| MUL
+| UNI
|
|
|
|
Line 102:
Line 103:
| 0
| 0
|
|
−| 1 if the invoice is payed, 0 otherwise
+| Is te invoice payed (1=yes, 0=otherwise)?
|-
|-
| amount
| amount
Line 118:
Line 119:
| 0.00000000
| 0.00000000
|
|
−|
+| discount
|-
|-
| tva
| tva
Line 126:
Line 127:
| 0.00000000
| 0.00000000
|
|
−|
+| VAT
|-
|-
| total
| total
Line 166:
Line 167:
| 0
| 0
|
|
−| 0= brouillon, 1=impayée, 2=payée, 3=abandonnée
+| Status of invoice (0=draft, 1=unpayed, 2=payed, 3=abandoned)
|-
|-
| fk_user_author
| fk_user_author
Line 231:
Line 232:
|
|
| import key
| import key
−|}
+|}
−== Keys ==
−'''Version 1.1 2009/10/07'''
+{| 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>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| uk_facture_fourn_ref
+| UNIQUE
+| facnumber,fk_soc,entity
+|-
+| idx_facture_fourn_date_lim_reglement
+| MULTIPLE
+| date_lim_reglement
+|-
+| idx_facture_fourn_fk_soc
+| MULTIPLE
+| fk_soc
+|-
+| idx_facture_fourn_fk_user_author
+| MULTIPLE
+| fk_user_author
+|-
+| idx_facture_fourn_fk_user_valid
+| MULTIPLE
+| fk_user_valid
+|-
+| idx_facture_fourn_fk_projet
+| MULTIPLE
+| fk_projet
+|}
+= Notes =
{{flag en}} Attention, if the status is 1 (unpayed) but the field "paye" is also 1 (payed), which should never happen under normal use, the invoice is specified payed.
{{flag en}} Attention, if the status is 1 (unpayed) but the field "paye" is also 1 (payed), which should never happen under normal use, the invoice is specified payed.