Table llx facture fourn - Revision history

Yves.brungard at 14:49, 2 July 2018

2018-07-02T14:49:51Z

A.schild: Corrected typos

2015-07-07T14:31:37Z

Corrected typos

← Older revision		Revision as of 14:31, 7 July 2015
Line 7:		Line 7:

	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =
	{{flag en}} Contains invoices sent by ~~providers~~. A ~~provider~~ invoice can be linked to a ~~provider~~ order ([[Table llx_commande_fournisseur]]) by the [[Table llx_element_element]].		{{flag en}} Contains invoices sent by suppliers. A supplier invoice can be linked to a supplier order ([[Table llx_commande_fournisseur]]) by the [[Table llx_element_element]].

	{{flag fr}} Cette table contient la liste des factures émises par les fournisseurs. Une facture fournisseur peut être liée à une commande fournisseur ([[Table llx_commande_fournisseur]]) au travers de la [[Table llx_element_element]]		{{flag fr}} Cette table contient la liste des factures émises par les fournisseurs. Une facture fournisseur peut être liée à une commande fournisseur ([[Table llx_commande_fournisseur]]) au travers de la [[Table llx_element_element]]
Line 89:		Line 89:
	\| 0		\| 0
	\|		\|
	\| Is te invoice payed (1=yes, 0=otherwise)?		\| Is the invoice payed (1=yes, 0=otherwise)?
	\|-		\|-
	\| amount		\| amount

Simnandez: /* Structure */

2011-07-19T15:22:26Z

Structure

← Older revision		Revision as of 15:22, 19 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	{\| 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" 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 216:		Line 216:

	== 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>
Line 250:		Line 249:
	\| fk_projet		\| fk_projet
	\|}		\|}

	= Notes =		= 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.

Eldy: /* Table */

2011-07-13T15:36:40Z

Table

← Older revision		Revision as of 15:36, 13 July 2011
Line 114:		Line 114:
	\|		\|
	\| VAT		\| VAT
			{{FieldLocalTaxX}}
	\|-		\|-
	~~{{FieldLocalTaxX}}~~
	\| total		\| total
	\| double(16,8)		\| double(16,8)

Eldy: /* Table */

2011-07-13T15:36:23Z

Table

← Older revision		Revision as of 15:36, 13 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== 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 116:		Line 115:
	\| VAT		\| VAT
	\|-		\|-
			{{FieldLocalTaxX}}
	\| total		\| total
	\| double(16,8)		\| double(16,8)

Eldy: /* Table */

2011-05-31T14:14:49Z

Table

← Older revision		Revision as of 14:14, 31 May 2011
Line 74:		Line 74:
	\|		\|
	\| date of invoice		\| date of invoice
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| libelle		\| libelle
Line 209:		Line 202:
	\| NULL		\| NULL
	\|		\|
	\| ~~comentary~~		\| commentary
	\|-		\|-
	\| note_public		\| note_public
Line 217:		Line 210:
	\| NULL		\| NULL
	\|		\|
	\| public ~~comentary~~		\| public commentary
	\|-		\|-
	~~\| import_key~~		{{FieldImportKey}}
	~~\| varchar(14)~~
	~~\| YES~~
	\|
	~~\| NULL~~
	\|
	~~\| import key~~
	\|}		\|}

Eldy: /* Table */

2011-05-30T07:56:16Z

Table

← Older revision		Revision as of 07:56, 30 May 2011
Line 40:		Line 40:
	\|		\|
	\| invoice number		\| invoice number
	\|-		{{FieldEntity}}
	~~\| entity~~		{{FieldRefExt}}
	~~\| int(11)~~
	~~\| NO~~
	~~\| UNI~~
	~~\| 1~~
	\|
	~~\| multi company id~~
	\|-		\|-
	\| type		\| type
Line 233:		Line 227:
	\| import key		\| import key
	\|}		\|}

	== Keys ==		== Keys ==
	'''Version 1.1 2009/10/07'''		'''Version 1.1 2009/10/07'''

Simnandez: /* Structure */

2009-10-21T07:39:21Z

Structure

← Older revision		Revision as of 07:39, 21 October 2009
Line 14:		Line 14:

	= 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
	\|-
	~~\| entity~~
	~~\| int(11)~~
	~~\|  ~~
	\|
	~~\| 1~~
	\|
	~~\| multi company id~~
	\|-		\|-
	\| 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.

Eldy: /* Structure */

2009-10-19T23:20:34Z

Structure

← Older revision		Revision as of 23:20, 19 October 2009
Line 54:		Line 54:
	\| 0		\| 0
	\|		\|
	\| type of invoice		\| type of invoice (0=Standard invoice, 1=Replacement invoice, 2=Credit note invoice). For the moment only 0 is supported.
	\|-		\|-
	\| fk_soc		\| fk_soc

Simnandez: /* Structure */

2009-07-04T14:40:29Z

Structure

← Older revision		Revision as of 14:40, 4 July 2009
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
	\|}		\|}