Merge pull request #12534 from civicrm/5.4

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

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

<table>
  <base>CRM/Financial</base>
  <class>FinancialType</class>
  <name>civicrm_financial_type</name>
  <add>1.3</add>
  <comment>Formerly civicrm_contribution_type merged into this table in 4.3</comment>
  <log>true</log>
  <field>
    <name>id</name>
    <title>Financial Type ID</title>
    <type>int unsigned</type>
    <length>10</length>
    <required>true</required>
    <comment>ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp</comment>
    <add>1.3</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <uniqueName>financial_type</uniqueName>
    <title>Financial Type</title>
    <type>varchar</type>
    <length>64</length>
    <required>true</required>
    <import>true</import>
    <headerPattern>/(finan(cial)?)?type/i</headerPattern>
    <dataPattern>/donation|member|campaign/i</dataPattern>
    <comment>Financial Type Name.</comment>
    <add>1.3</add>
    <pseudoconstant>
      <table>civicrm_financial_type</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
  </field>
  <field>
    <name>accounting_code</name>
    <title>Accounting Code</title>
    <type>varchar</type>
    <length>64</length>
    <export>true</export>
    <comment>Optional value for mapping contributions to accounting system codes for each type/category of contribution.</comment>
    <add>1.3</add>
    <drop>4.3</drop>
  </field>
  <field>
    <name>description</name>
    <type>varchar</type>
    <length>255</length>
    <comment>Financial Type Description.</comment>
    <add>1.3</add>
  </field>
  <field>
    <name>is_deductible</name>
    <title>Is Tax Deductible?</title>
    <type>boolean</type>
    <length>4</length>
    <default>1</default>
    <comment>Is this financial type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record.</comment>
    <add>1.3</add>
  </field>
  <field>
    <name>is_reserved</name>
    <title>Financial Type is Reserved?</title>
    <type>boolean</type>
    <length>4</length>
    <comment>Is this a predefined system object?</comment>
    <add>1.3</add>
  </field>
  <field>
    <name>is_active</name>
    <type>boolean</type>
    <title>Financial Type Is Active?</title>
    <length>4</length>
    <comment>Is this property active?</comment>
    <add>1.3</add>
  </field>
  <index>
    <name>UI_id</name>
    <fieldName>id</fieldName>
    <unique>true</unique>
    <add>4.3</add>
  </index>
</table>