Table llx accountingtransaction: Difference between revisions

Jump to navigation Jump to search
(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...')
 
 
Line 63: Line 63:
| last update date
| last update date
|-  
|-  
| fk_facture
| fk_source
| int(11)  
| int(11)  
| YES
| YES
Line 69: Line 69:
| NULL
| NULL
|  
|  
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
| 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)
|-
|-
| fk_facture_fourn
| sourcetype
| int(11)  
| varchar(16)  
| YES
| NO
|  
|  
| NULL
|  
|  
| ID of provider invoice ([[Table llx_facture_fourn|llx_facture_fourn]]->rowid)
|-
| fk_payment
| int(11)
| YES
|
| NULL
|  
|  
| ID of payment ([[Table llx_paiement|llx_paiement]]->rowid)
| type of source
|-
|-
| fk_payment_fourn
| url
| int(11)
| varchar(255)  
| YES
| YES
|  
|  
| NULL
| NULL
|  
|  
| ID of payment to supplier ([[Table llx_paiementfourn|llx_paiementfourn]]->rowid)
| Url of transaction
|} 
|} 


==Keys==
==Keys==
 
 

Navigation menu