<name>civicrm_financial_trxn</name>
<add>1.3</add>
<log>true</log>
+ <component>CiviContribute</component>
<field>
<name>id</name>
<title>Financial Transaction ID</title>
<type>int unsigned</type>
<required>true</required>
+ <html>
+ <type>Number</type>
+ </html>
<add>1.3</add>
</field>
<primaryKey>
<name>id</name>
<autoincrement>true</autoincrement>
</primaryKey>
- <field>
- <name>from_account_id</name>
- <type>int unsigned</type>
- <comment>FK to financial_account table.</comment>
- <add>3.2</add>
- <drop>4.3</drop>
- </field>
- <foreignKey>
- <name>from_account_id</name>
- <table>civicrm_financial_account</table>
- <key>id</key>
- <add>3.2</add>
- <drop>4.3</drop>
- </foreignKey>
- <field>
- <name>to_account_id</name>
- <type>int unsigned</type>
- <comment>FK to financial_account table.</comment>
- <add>3.2</add>
- <drop>4.3</drop>
- </field>
- <foreignKey>
- <name>to_account_id</name>
- <table>civicrm_financial_account</table>
- <key>id</key>
- <add>3.2</add>
- <drop>4.3</drop>
- </foreignKey>
<field>
<name>from_financial_account_id</name>
<type>int unsigned</type>
<formatType>activityDateTime</formatType>
</html>
</field>
- <field>
- <name>trxn_type</name>
- <title>Financial Transaction Type</title>
- <type>enum</type>
- <values>Debit,Credit</values>
- <required>true</required>
- <add>1.3</add>
- <drop>4.3</drop>
- </field>
<field>
<name>total_amount</name>
<title>Financial Total Amount</title>
<comment>Is this entry either a payment or a reversal of a payment?</comment>
<add>4.7</add>
</field>
- <field>
- <name>payment_processor</name>
- <type>varchar</type>
- <length>64</length>
- <required>true</required>
- <comment>derived from Processor setting in civicrm.settings.php.</comment>
- <add>1.3</add>
- <drop>4.3</drop>
- </field>
<field>
<name>trxn_id</name>
<title>Transaction ID</title>
<title>Payment Processor</title>
<type>int unsigned</type>
<comment>Payment Processor for this financial transaction</comment>
+ <pseudoconstant>
+ <table>civicrm_payment_processor</table>
+ <keyColumn>id</keyColumn>
+ <labelColumn>name</labelColumn>
+ </pseudoconstant>
+ <html>
+ <type>Select</type>
+ </html>
<add>4.3</add>
</field>
<foreignKey>