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