Table llx prelevement bons
Jump to navigation
Jump to search
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
List of standing orders sent to bank. The standing order details are in Table llx prelevement lignes
Liste des bons de prélèvement envoyé à la banque. les détails des prélèvement sont dans la Table llx prelevement lignes
Lista de domiciliaciones enviadas al banco. Los detalles de las domiciliaciones se encuentran en la Table llx prelevement lignes
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| ref | varchar(12) | YES | UNI | NULL | reference | |
| entity | int(11) | NO | UNI | 1 | multi company id | |
| datec | datetime | YES | NULL | creation date | ||
| amount | real | YES | 0 | amount | ||
| statut | smallint(6) | NO | 0 | status | ||
| credite | smallint(6) | NO | 0 | is the standing order credit? | ||
| note | text | YES | NULL | comentary | ||
| datetrans | datetime | YES | NULL | date of transmission to the bank | ||
| method_trans | smallint(6) | YES | NULL | transmission metode | ||
| fk_user_trans | int(11) | YES | NULL | ID of user made the transmission (llx_user->rowid) | ||
| datecredit | datetime | YES | NULL | date of credit to the account bank | ||
| fk_user_credit | int(11) | YES | NULL | ID of user made the info up credit (llx_user->rowid) |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| uk_prelevement_bons_ref | UNIQUE | ref,entity |