4,395
edits
(Created page with 'Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the ledger entries. {{flag fr}} Contient les écritures comptables. {{flag sp}} Co...') |
(→Table) |
||
| Line 63: | Line 63: | ||
| last update date | | last update date | ||
|- | |- | ||
| | | fk_source | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| Line 69: | Line 69: | ||
| NULL | | NULL | ||
| | | | ||
| ID of | | ID of source ([[Table llx_facture|llx_facture]]->rowid,[[Table llx_facture_fourn|llx_facture_fourn]]->rowid,[[Table llx_paiement|llx_paiement]]->rowid,[[Table llx_paiementfourn|llx_paiementfourn]]->rowid) | ||
|- | |- | ||
| | | sourcetype | ||
| | | varchar(16) | ||
| | | NO | ||
| | | | ||
| | | | ||
| | | | ||
| | | type of source | ||
|- | |- | ||
| | | url | ||
| | | varchar(255) | ||
| YES | | YES | ||
| | | | ||
| NULL | | NULL | ||
| | | | ||
| | | Url of transaction | ||
|} | |} | ||
==Keys== | ==Keys== | ||
| | ||