[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>
    <html>
      <type>Text</type>
      <label>Name</label>
    </html>
    <add>1.3</add>
  </field>
  <field>
    <name>description</name>
    <type>varchar</type>
    <html>
      <type>TextArea</type>
      <rows>6</rows>
      <cols>50</cols>
      <label>Description</label>
    </html>
    <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>
    <html>
      <type>CheckBox</type>
      <label>Tax-Deductible?</label>
    </html>
  </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>
    <html>
      <type>CheckBox</type>
      <label>Reserved?</label>
    </html>
  </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>
    <html>
      <type>CheckBox</type>
      <label>Enabled?</label>
    </html>
  </field>
  <index>
    <name>UI_id</name>
    <fieldName>id</fieldName>
    <unique>true</unique>
    <add>4.3</add>
  </index>
</table>
Commit	Line	Data
3c7d2158	1	<?xml version="1.0" encoding="iso-8859-1" ?>
6a488035	2
3c7d2158	3	<table>
	4	<base>CRM/Financial</base>
	5	<class>FinancialType</class>
	6	<name>civicrm_financial_type</name>
	7	<add>1.3</add>
6a488035	8	<comment>Formerly civicrm_contribution_type merged into this table in 4.3</comment>
3c7d2158	9	<log>true</log>
	10	<field>
	11	<name>id</name>
0d94665e	12	<title>Financial Type ID</title>
6a488035 TO	13	<type>int unsigned</type>
6a488035 TO	14	<length>10</length>
3c7d2158	15	<required>true</required>
3c7d2158	16	<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>
6a488035 TO	17	<add>1.3</add>
6a488035 TO	18	</field>
3c7d2158	19	<primaryKey>
	20	<name>id</name>
	21	<autoincrement>true</autoincrement>
	22	</primaryKey>
6a488035 TO	23	<field>
6a488035 TO	24	<name>name</name>
3c7d2158	25	<uniqueName>financial_type</uniqueName>
6a488035 TO	26	<title>Financial Type</title>
	27	<type>varchar</type>
	28	<length>64</length>
3c7d2158	29	<required>true</required>
6a488035 TO	30	<import>true</import>
	31	<headerPattern>/(finan(cial)?)?type/i</headerPattern>
	32	<dataPattern>/donation\|member\|campaign/i</dataPattern>
	33	<comment>Financial Type Name.</comment>
251808cb PN	34	<html>
	35	<type>Text</type>
	36	<label>Name</label>
	37	</html>
6a488035 TO	38	<add>1.3</add>
6a488035 TO	39	</field>
6a488035 TO	40	<field>
	41	<name>description</name>
	42	<type>varchar</type>
251808cb PN	43	<html>
	44	<type>TextArea</type>
	45	<rows>6</rows>
	46	<cols>50</cols>
	47	<label>Description</label>
	48	</html>
6a488035 TO	49	<length>255</length>
	50	<comment>Financial Type Description.</comment>
	51	<add>1.3</add>
	52	</field>
	53	<field>
	54	<name>is_deductible</name>
32ac94e8	55	<title>Is Tax Deductible?</title>
6a488035	56	<type>boolean</type>
3c7d2158	57	<length>4</length>
6a488035 TO	58	<default>1</default>
	59	<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>
	60	<add>1.3</add>
251808cb PN	61	<html>
	62	<type>CheckBox</type>
	63	<label>Tax-Deductible?</label>
	64	</html>
6a488035 TO	65	</field>
	66	<field>
	67	<name>is_reserved</name>
32ac94e8	68	<title>Financial Type is Reserved?</title>
6a488035	69	<type>boolean</type>
3c7d2158	70	<length>4</length>
6a488035 TO	71	<comment>Is this a predefined system object?</comment>
6a488035 TO	72	<add>1.3</add>
251808cb PN	73	<html>
	74	<type>CheckBox</type>
	75	<label>Reserved?</label>
	76	</html>
6a488035 TO	77	</field>
	78	<field>
	79	<name>is_active</name>
	80	<type>boolean</type>
56b7523d	81	<title>Financial Type Is Active?</title>
3c7d2158	82	<length>4</length>
6a488035 TO	83	<comment>Is this property active?</comment>
6a488035 TO	84	<add>1.3</add>
251808cb PN	85	<html>
	86	<type>CheckBox</type>
	87	<label>Enabled?</label>
	88	</html>
6a488035 TO	89	</field>
	90	<index>
	91	<name>UI_id</name>
	92	<fieldName>id</fieldName>
	93	<unique>true</unique>
	94	<add>4.3</add>
	95	</index>
	96	</table>