4,395
edits
Changes
no edit summary
Line 1:
Line 1:
+ +<pre>+-- ===================================================================+-- 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
−--
−-- $Id: llx_paiement.sql,v 1.11 2004/12/16 10:45:58 rodolphe Exp $
−-- ===================================================================
−--
−-- Satut, 0 ou 1, 1 n'est plus supprimable
−-- fk_export_compta 0 pas export
−
−create table llx_paiement
−(
− rowid integer AUTO_INCREMENT PRIMARY KEY,
− fk_facture integer, -- left NULL since the creation of llx_paiement_facture
− 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;
−</pre>
[[Category:Table SQL]]
[[Category:Table SQL]]
+[[Category:Invoices]]
[[Category:Facture]]
[[Category:Facture]]
+[[Category:Facturas]]
{{ListOfTables}}
{{ListOfTables}}
= Contenu =
= Contenu =
−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]]
+{{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]]
−Contains the payments made for client invoices. The relation between a client invoice and the corresponding payment is in [[Table llx_paiement_facture]]
+{{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]]
+{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 =
= Structure =
−{| 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>Type</b>
−-- Copyright (C) 2001-2002,2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
+ |style="background-color: #e9e9ef"| <b>Null</b>
−-- Copyright (C) 2004 Laurent Destailleur <eldy@users.sourceforge.net>
+ |style="background-color: #e9e9ef"| <b>Key</b>
−--
+ |style="background-color: #e9e9ef"| <b>Default</b>
−-- This program is free software; you can redistribute it and/or modify
+ |style="background-color: #e9e9ef"| <b>Extra</b>
−-- it under the terms of the GNU General Public License as published by
+ |style="background-color: #e9e9ef"| <b>Description</b>
−|-
−| rowid
−| int(11)
−|
−| PRI
−| NULL
−| auto_increment
−| technical index
−|}
−-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
−-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_paiement.sql,v $
−--
−