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