Refactored out of CRM_Core_PseudoConstant: ufGroup(), currencySymbols(). CRM-12464

[civicrm-core.git] / xml / schema / Financial / FinancialTrxn.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>  
  <base>CRM/Financial</base>  
  <class>FinancialTrxn</class>  
  <name>civicrm_financial_trxn</name>  
  <add>1.3</add>  
  <log>true</log>
  <field>  
    <name>id</name>  
    <type>int unsigned</type>  
    <required>true</required> 
    <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>   
    <comment>FK to financial_account table.</comment>   
    <add>4.3</add>
  </field> 
  <foreignKey> 
    <name>from_financial_account_id</name> 
    <table>civicrm_financial_account</table> 
    <key>id</key> 
    <add>4.3</add>
  </foreignKey>
  <field>  
    <name>to_financial_account_id</name>  
    <type>int unsigned</type>  
    <comment>FK to financial_financial_account table.</comment>   
    <add>4.3</add>
  </field> 
  <foreignKey> 
    <name>to_financial_account_id</name> 
    <table>civicrm_financial_account</table> 
    <key>id</key> 
    <add>4.3</add>
  </foreignKey>
  <field>  
    <name>trxn_date</name>  
    <type>datetime</type> 
    <default>NULL</default> 
    <comment>date transaction occurred</comment> 
    <add>1.3</add>  
  </field>  
  <field>   
    <name>trxn_type</name>   
    <type>enum</type>   
    <values>Debit,Credit</values>
    <required>true</required>   
    <add>1.3</add>   
    <drop>4.3</drop>
  </field>   
  <field>    
    <name>total_amount</name>    
    <type>decimal</type>    
    <required>true</required>
    <comment>amount of transaction</comment>
    <add>1.3</add>    
  </field> 
  <field>    
    <name>fee_amount</name>    
    <type>decimal</type>    
    <comment>actual processor fee if known - may be 0.</comment>
    <add>1.3</add>    
  </field> 
  <field>    
    <name>net_amount</name>    
    <type>decimal</type>    
    <comment>actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount.</comment>
    <add>1.3</add>    
  </field>
  <field>
    <name>currency</name>
    <type>varchar</type>
    <length>3</length>
    <default>NULL</default> 
    <import>true</import>
    <headerPattern>/cur(rency)?/i</headerPattern>
    <dataPattern>/^[A-Z]{3}$/</dataPattern>
    <comment>3 character string, value from config setting or input via user.</comment>
    <add>1.3</add>
    <pseudoconstant>
      <table>civicrm_currency</table>
      <keyColumn>name</keyColumn>
      <labelColumn>symbol</labelColumn>
    </pseudoconstant>
  </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>     
    <type>varchar</type>     
    <length>255</length>
    <comment>user-specified unique processor transaction id, bank id + trans id,... depending on payment_method</comment>     
    <add>1.3</add>     
  </field>   
  <field>         
    <name>trxn_result_code</name>      
    <type>varchar</type>      
    <length>255</length>   
    <comment>processor result code</comment>      
    <add>1.3</add>      
  </field> 
  <field>
    <name>status_id</name>
    <title>Financial Transaction Status Id</title>
    <type>int unsigned</type>
    <import>true</import>
    <export>true</export>                 
    <comment>pseudo FK to civicrm_option_value of financial_item status option_group</comment> 
    <headerPattern>/status/i</headerPattern>
    <add>4.3</add>
  </field>
  <field> 
    <name>payment_processor_id</name> 
    <type>int unsigned</type>                 
    <comment>Payment Processor for this financial transaction</comment> 
    <add>4.3</add> 
  </field> 
  <foreignKey> 
    <name>payment_processor_id</name> 
    <table>civicrm_payment_processor</table> 
    <key>id</key> 
    <onDelete>SET NULL</onDelete>
    <add>4.3</add> 
  </foreignKey>
  <field>
    <name>payment_instrument_id</name>
    <uniqueName>financial_trxn_payment_instrument_id</uniqueName>
    <title>Payment Instrument</title>
    <type>int unsigned</type>
    <comment>FK to payment_instrument option group values</comment>
    <pseudoconstant>
      <name>paymentInstrument</name>
      <optionGroupName>paymentInstrument</optionGroupName>
      <class>CRM_Contribute_PseudoConstant</class>
    </pseudoconstant>
    <add>4.3</add>
  </field>
  <index>
    <name>UI_ftrxn_payment_instrument_id</name>
    <fieldName>payment_instrument_id</fieldName>
    <add>4.3</add>
  </index>
  <field>
    <name>check_number</name>
    <uniqueName>financial_trxn_check_number</uniqueName>
    <title>Check Number</title>
    <comment>Check number</comment>
    <type>varchar</type>
    <length>255</length>
    <size>SIX</size>
    <add>4.3</add>
  </field>
  <index>
    <name>UI_ftrxn_check_number</name>
    <fieldName>check_number</fieldName>
    <add>4.3</add>
  </index>
</table>