Table llx prelevement lignes: Difference between revisions

← Older edit

Table llx prelevement lignes (view source)

Revision as of 19:25, 14 April 2025

1,705 bytes added , 1 year ago

m

→‎Content/Contenu/Contenido

VisualWikitext

Eldy

Bureaucrats, Interface administrators, Administrators

31,026

edits

@@ Line 1: / Line 1: @@
-[[Catégorie:Prélèvements bancaires]][[Catégorie:Table SQL]]
+[[Category:Prélèvements bancaires]]
-== Présentation ==
+[[Category:Standing Orders]]
+[[Category:Domiciliaciones]]
+[[Category:Table SQL]]
+{{ListOfTables}}
-Liste des lignes de prélèvement.
+= Content/Contenu/Contenido =
-== Modules ==
+{{flag en}} Contains the lines of standing orders. This table is linked to [[Table llx_prelevement_bons]]
-# [[Module Prélèvements bancaires]]
+{{flag fr}} Contient les lignes des bons de prelevement. Cette table est liée avec la [[Table llx_prelevement_bons]]
-== Tables liées ==
+{{flag sp}} Contiene las líneas de las domiciliaciones. Esta tabla está vinculada con la [[Table llx_prelevement_bons]]
-# [[Table llx_prelevement_bons]]
+= Structure =
+== Table ==
-== Structure ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-; rowid : identifiant
+ |style="background-color: #e9e9ef"| <b>Field</b>
-; ref : référence permettant d'identifier le prélèvement
+ |style="background-color: #e9e9ef"| <b>Type</b>
-; datec :
+ |style="background-color: #e9e9ef"| <b>Null</b>
-; amount : montant total du prélèvement
+ |style="background-color: #e9e9ef"| <b>Key</b>
-; note : champ de commentaire
+ |style="background-color: #e9e9ef"| <b>Default</b>
-== Code SQL ==
+ |style="background-color: #e9e9ef"| <b>Extra</b>
+ |style="background-color: #e9e9ef"| <b>Description</b>
+|-
+| rowid
+| int(11)
+| NO
+| PRI
+|
+| auto_increment
+| technical index
+|-
+| fk_prelevement_bons
+| int(11)
+| YES
+| MUL
+| NULL
+|
+| ID of standig order ([[Table llx_prelevement_bons|llx_prelevement_bons]]->rowid)
+|-
+| fk_soc
+| int(11)
+| NO
+|
+|
+|
+| ID society ([[Table llx_societe|llx_societe]]->rowid)
+|-
+| statut
+| smallint(6)
+| YES
+|
+| 0
+|
+| status
+|-
+| client_nom
+| varchar(255)
+| YES
+|
+| NULL
+|
+| client name
+|-
+| amount
+| real
+| YES
+|
+| 0
+|
+| amount
+|-
+| code_banque
+| varchar(7)
+| YES
+|
+| NULL
+|
+| bank code
+|-
+| code_guichet
+| varchar(6)
+| YES
+|
+| NULL
+|
+| bank office code
+|-
+| number
+| varchar(255)
+| YES
+|
+| NULL
+|
+| bank account number
+|-
+| cle_rib
+| varchar(5)
+| YES
+|
+| NULL
+|
+| RIB key
+|-
+| note
+| text
+| YES
+|
+| NULL
+|
+| comentary
+|}&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
+|-
+| idx_prelevement_lignes_fk_prelevement_bons
+| MULTIPLE
+| fk_prelevement_bons
+|}&nbsp;