<required>true</required>
<comment>Foreign key to civicrm_contact.id .</comment>
<add>2.1</add>
+ <html>
+ <type>Autocomplete-Select</type>
+ </html>
</field>
<foreignKey>
<name>contact_id</name>
<type>int unsigned</type>
<comment>FK to Financial Type</comment>
<add>4.3</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<foreignKey>
<name>financial_type_id</name>
<import>true</import>
<comment>Total pledged amount.</comment>
<add>2.1</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>original_installment_amount</name>
<required>true</required>
<comment>Original amount for each of the installments.</comment>
<add>3.2</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>currency</name>
<labelColumn>full_name</labelColumn>
<nameColumn>numeric_code</nameColumn>
</pseudoconstant>
+ <html>
+ <type>Select></type>
+ </html>
</field>
<field>
<name>frequency_unit</name>
<default>'month'</default>
<comment>Time units for recurrence of pledge payments.</comment>
<add>2.1</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<field>
<name>frequency_interval</name>
<default>1</default>
<comment>Number of time units for recurrence of pledge payments.</comment>
<add>2.1</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>frequency_day</name>
<required>true</required>
<comment>Day in the period when the pledge payment is due e.g. 1st of month, 15th etc. Use this to set the scheduled dates for pledge payments.</comment>
<add>2.1</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<field>
<name>installments</name>
<default>1</default>
<comment>Total number of payments to be made.</comment>
<add>2.1</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>start_date</name>
<required>true</required>
<comment>The date the first scheduled pledge occurs.</comment>
<add>2.1</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>create_date</name>
<import>true</import>
<comment>When this pledge record was created.</comment>
<add>2.1</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>acknowledge_date</name>
<title>Pledge Acknowledged</title>
<comment>When a pledge acknowledgement message was sent to the contributor.</comment>
<add>2.1</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>modified_date</name>
<title>Pledge Cancelled Date</title>
<comment>Date this pledge was cancelled by contributor.</comment>
<add>2.1</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>end_date</name>
<title>Pledge End Date</title>
<comment>Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount).</comment>
<add>2.1</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>honor_contact_id</name>
<title>Pledge Honor Contact</title>
<comment>FK to contact ID. Used when pledge is made in honor of another contact. This is propagated to contribution records when pledge payments are made.</comment>
<add>2.1</add>
+ <html>
+ <type>Autocomplete-Select</type>
+ </html>
</field>
<foreignKey>
<name>honor_contact_id</name>
<pseudoconstant>
<optionGroupName>honor_type</optionGroupName>
</pseudoconstant>
+ <html>
+ <type>Select></type>
+ </html>
</field>
<field>
<name>max_reminders</name>
<type>int unsigned</type>
<default>1</default>
<comment>The maximum number of payment reminders to send for any given payment.</comment>
+ <html>
+ <type>Text</type>
+ </html>
<add>2.1</add>
</field>
<field>
<default>5</default>
<comment>Send initial reminder this many days prior to the payment due date.</comment>
<add>2.1</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<field>
<name>additional_reminder_day</name>
<default>5</default>
<comment>Send additional reminder this many days after last one sent, up to maximum number of reminders.</comment>
<add>2.1</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>status_id</name>
<title>Test</title>
<type>boolean</type>
<default>0</default>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>campaign_id</name>
<import>true</import>
<comment>The campaign for which this pledge has been initiated.</comment>
<add>3.4</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<foreignKey>
<name>campaign_id</name>