4,395
edits
Changes
→Structure
Line 31:
Line 31:
| auto_increment
| auto_increment
| technical index
| technical index
+|-
+| entity
+| int(11)
+|
+|
+| 1
+|
+| multi company id
|-
|-
| facnumber
| facnumber
Line 38:
Line 46:
|
|
|
|
−|
+| invoice number
|-
|-
| type
| type
Line 46:
Line 54:
| 0
| 0
|
|
−|
+| type of invoice
|-
|-
| fk_soc
| fk_soc
Line 54:
Line 62:
|
|
|
|
−|
+| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| datec
| datec
Line 62:
Line 70:
| NULL
| NULL
|
|
−|
+| creation date
|-
|-
| datef
| datef
Line 70:
Line 78:
| NULL
| NULL
|
|
+| date of invoice
+|-
+| tms
+| timestamp
+| NO
+|
+| CURRENT_TIMESTAMP
|
|
+| last update date
|-
|-
| libelle
| libelle
Line 78:
Line 94:
| NULL
| NULL
|
|
−|
+| label
|-
|-
| paye
| paye
Line 86:
Line 102:
| 0
| 0
|
|
−| 1 si la facture a été payée, 0 sinon
+| 1 if the invoice is payed, 0 otherwise
|-
|-
| amount
| amount
Line 94:
Line 110:
| 0.00000000
| 0.00000000
|
|
−|
+| amount
|-
|-
| remise
| remise
Line 118:
Line 134:
| 0.00000000
| 0.00000000
|
|
−|
+| total amount
|-
|-
| total_ht
| total_ht
Line 126:
Line 142:
| 0.00000000
| 0.00000000
|
|
−|
+| total amount excluding VAT
|-
|-
| total_tva
| total_tva
Line 134:
Line 150:
| 0.00000000
| 0.00000000
|
|
−|
+| total amount of VAT
|-
|-
| total_ttc
| total_ttc
Line 142:
Line 158:
| 0.00000000
| 0.00000000
|
|
−|
+| total amount with VAT
|-
|-
| fk_statut
| fk_statut
Line 158:
Line 174:
| NULL
| NULL
|
|
−|
+| ID of user author of invoice ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_valid
| fk_user_valid
Line 166:
Line 182:
| NULL
| NULL
|
|
−|
+| ID of user validator of invoice ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_projet
| fk_projet
Line 174:
Line 190:
| NULL
| NULL
|
|
−|
+| ID of related proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
|-
| fk_cond_reglement
| fk_cond_reglement
Line 182:
Line 198:
| 1
| 1
|
|
−|
+| Id of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
|-
|-
| date_lim_reglement
| date_lim_reglement
Line 190:
Line 206:
| NULL
| NULL
|
|
−|
+| date limit for payment
|-
|-
| note
| note
Line 198:
Line 214:
| NULL
| NULL
|
|
−|
+| comentary
|-
|-
| note_public
| note_public
Line 206:
Line 222:
| NULL
| NULL
|
|
+| public comentary
+|-
+| import_key
+| varchar(14)
+| YES
+|
+| NULL
|
|
+| import key
|}
|}