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