4,395
edits
Table llx prelevement bons: Difference between revisions
Jump to navigation
Jump to search
→Structure
| Line 30: | Line 30: | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
|- | |||
| ref | |||
| varchar(12) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| reference | |||
|- | |||
| entity | |||
| int(11) | |||
| NO | |||
| | |||
| 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 domiciliation 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 ([[Table llx_user|llx_user]]->rowid) | |||
|- | |||
| datecredit | |||
| datetime | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| date of credit to the account bank | |||
|- | |||
| fk_user_trans | |||
| int(11) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| ID of user made the info up credit ([[Table llx_user|llx_user]]->rowid) | |||
|} | |} | ||