Difference between revisions of "Table llx paiement"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
 
(11 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
== Structure ==
+
[[Category:Table SQL]]
−
<pre>
+
[[Category:Invoices]]
−
-- ===================================================================
+
[[Category:Facture]]
−
-- Copyright (C) 2001-2002,2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
+
[[Category:Facturas]]
−
-- Copyright (C) 2004      Laurent Destailleur  <eldy@users.sourceforge.net>
+
{{ListOfTables}}
−
--
 
−
-- This program is free software; you can redistribute it and/or modify
 
−
-- it under the terms of the GNU General Public License as published by
 
−
-- the Free Software Foundation; either version 2 of the License, or
 
−
-- (at your option) any later version.
 
−
--
 
−
-- This program is distributed in the hope that it will be useful,
 
−
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
 
−
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 
−
-- GNU General Public License for more details.
 
−
--
 
−
-- You should have received a copy of the GNU General Public License
 
−
-- along with this program; if not, write to the Free Software
 
−
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 
−
--
 
−
-- $Id: llx_paiement.sql,v 1.11 2004/12/16 10:45:58 rodolphe Exp $
 
−
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_paiement.sql,v $
 
−
-- ===================================================================
 
−
--
 
−
--
 
−
-- Satut, 0 ou 1, 1 n'est plus supprimable
 
−
-- fk_export_compta 0 pas export
 
  
−
create table llx_paiement
+
= Content/Contenu/Contenido =
−
(
+
{{flag en}} Contains the payments made for client invoices. The relation between a client invoice and the corresponding payment is in [[Table llx_paiement_facture]]
−
  rowid            integer AUTO_INCREMENT PRIMARY KEY,
 
−
  fk_facture      integer,
 
−
  datec            datetime,          -- date de creation
 
−
  tms              timestamp,
 
−
  datep            datetime,          -- payment date
 
−
  amount          real DEFAULT 0,
 
−
  author          varchar(50),
 
−
  fk_paiement      integer NOT NULL,  -- payment type (cheque, cash, ...) - see llx_c_paiement
 
−
  num_paiement    varchar(50),
 
−
  note            text,
 
−
  fk_bank          integer NOT NULL,  -- bank account id - see llx_bank
 
−
  fk_user_creat    integer,            -- utilisateur qui a cr l'info
 
−
  fk_user_modif    integer,            -- utilisateur qui a modifi l'info
 
−
  statut          smallint DEFAULT 0 NOT NULL,
 
−
  fk_export_compta integer DEFAULT 0 NOT NULL
 
  
−
)type=innodb;
+
{{flag fr}} Contient les paiements relatifs aux factures clients. La relation entre une facture client et le paiement correspondant se trouve dans la [[Table llx_paiement_facture]]
−
</pre>
+
 
 +
{{flag sp}} Contiene los pagos relativos a las facturas a clientes. La relación entre una factura a cliente y el pago correspondiente se en cuentra en [[Table llx_paiement_facture]]
 +
 
 +
= Structure =
 +
== 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>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Null</b>
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Default</b>
 +
|style="background-color: #e9e9ef"| <b>Extra</b>
 +
|style="background-color: #e9e9ef"| <b>Description</b>
 +
|-
 +
| rowid
 +
| int(11)  
 +
| NO
 +
| PRI
 +
|
 +
| auto_increment
 +
| technical index
 +
|-
 +
| datec
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| creation date
 +
{{FieldTms}}
 +
|-
 +
| datep
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| payment date
 +
|-
 +
| amount
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| amount of payment
 +
|-
 +
| fk_payment
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| ID type of payment ([[Table llx_c_paiement|llx_c_paiement]]->id)
 +
|-
 +
| num_payment
 +
| varchar(50)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| number of payment
 +
|-
 +
| note
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| comentary
 +
|-
 +
| fk_bank
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| ID of bank to pay ([[Table llx_bank_account|llx_bank_account]]->rowid)
 +
|-
 +
| fk_user_creat
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_modif
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of last modifier user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| statut
 +
| smallint(6)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| status of payment (0 or 1: 1=not deletable)
 +
|-
 +
| fk_export_compta
 +
| int(11)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| ID of accountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid, 0 not exported)
 +
|}&nbsp;
 +
 
 +
== 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
 +
|}&nbsp;

Latest revision as of 12:45, 10 August 2012


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains the payments made for client invoices. The relation between a client invoice and the corresponding payment is in Table llx_paiement_facture

Fr verysmall.png Contient les paiements relatifs aux factures clients. La relation entre une facture client et le paiement correspondant se trouve dans la Table llx_paiement_facture

Es verysmall.png Contiene los pagos relativos a las facturas a clientes. La relación entre una factura a cliente y el pago correspondiente se en cuentra en Table llx_paiement_facture

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
datec datetime YES NULL creation date
tms timestamp NO Current date Date of last modification. See page Field Tms.
datep datetime YES NULL payment date
amount real YES 0 amount of payment
fk_payment int(11) NO ID type of payment (llx_c_paiement->id)
num_payment varchar(50) YES NULL number of payment
note text YES NULL comentary
fk_bank int(11) YES 0 ID of bank to pay (llx_bank_account->rowid)
fk_user_creat int(11) YES NULL ID of creator user (llx_user->rowid)
fk_user_modif int(11) YES NULL ID of last modifier user (llx_user->rowid)
statut smallint(6) NO 0 status of payment (0 or 1: 1=not deletable)
fk_export_compta int(11) NO 0 ID of accountacy export (llx_export_compta->rowid, 0 not exported)

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_paiement&oldid=26730"