1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
3 <base>CRM/Pledge
</base>
5 <name>civicrm_pledge
</name>
8 <icon>fa-paper-plane
</icon>
9 <component>CiviPledge
</component>
12 <uniqueName>pledge_id
</uniqueName>
13 <title>Pledge ID
</title>
14 <type>int unsigned
</type>
15 <required>true
</required>
16 <comment>Pledge ID
</comment>
25 <autoincrement>true
</autoincrement>
28 <name>contact_id
</name>
29 <uniqueName>pledge_contact_id
</uniqueName>
30 <title>Contact ID
</title>
32 <type>int unsigned
</type>
33 <required>true
</required>
34 <comment>Foreign key to civicrm_contact.id .
</comment>
37 <type>EntityRef
</type>
38 <label>Contact
</label>
42 <name>contact_id
</name>
43 <table>civicrm_contact
</table>
46 <onDelete>CASCADE
</onDelete>
49 <name>financial_type_id
</name>
50 <title>Financial Type ID
</title>
51 <uniqueName>pledge_financial_type_id
</uniqueName>
52 <type>int unsigned
</type>
53 <comment>FK to Financial Type
</comment>
55 <table>civicrm_financial_type
</table>
56 <keyColumn>id
</keyColumn>
57 <labelColumn>name
</labelColumn>
62 <label>Financial Type
</label>
66 <name>financial_type_id
</name>
67 <table>civicrm_financial_type
</table>
72 <name>contribution_page_id
</name>
73 <uniqueName>pledge_contribution_page_id
</uniqueName>
74 <title>Contribution Page ID
</title>
75 <type>int unsigned
</type>
76 <comment>The Contribution Page which triggered this contribution
</comment>
78 <label>Contribution Page
</label>
83 <name>contribution_page_id
</name>
84 <table>civicrm_contribution_page
</table>
86 <onDelete>SET NULL
</onDelete>
90 <uniqueName>pledge_amount
</uniqueName>
91 <title>Total Pledged
</title>
93 <required>true
</required>
95 <comment>Total pledged amount.
</comment>
102 <name>original_installment_amount
</name>
103 <uniqueName>pledge_original_installment_amount
</uniqueName>
104 <title>Original Installment Amount
</title>
106 <required>true
</required>
107 <comment>Original amount for each of the installments.
</comment>
112 <export>true
</export>
115 <name>currency
</name>
117 <title>Pledge Currency
</title>
119 <default>NULL
</default>
120 <comment>3 character string, value from config setting or input via user.
</comment>
123 <table>civicrm_currency
</table>
124 <keyColumn>name
</keyColumn>
125 <labelColumn>full_name
</labelColumn>
126 <nameColumn>name
</nameColumn>
127 <abbrColumn>symbol
</abbrColumn>
134 <name>frequency_unit
</name>
135 <uniqueName>pledge_frequency_unit
</uniqueName>
136 <title>Pledge Frequency Unit
</title>
138 <required>true
</required>
140 <default>'month'
</default>
141 <comment>Time units for recurrence of pledge payments.
</comment>
143 <optionGroupName>recur_frequency_units
</optionGroupName>
144 <keyColumn>name
</keyColumn>
152 <name>frequency_interval
</name>
153 <uniqueName>pledge_frequency_interval
</uniqueName>
154 <title>Pledge Frequency Interval
</title>
155 <type>int unsigned
</type>
156 <required>true
</required>
158 <comment>Number of time units for recurrence of pledge payments.
</comment>
165 <name>frequency_day
</name>
166 <type>int unsigned
</type>
167 <title>Pledge day
</title>
169 <required>true
</required>
170 <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>
177 <name>installments
</name>
178 <type>int unsigned
</type>
179 <title>Pledge Number of Installments
</title>
181 <required>true
</required>
182 <comment>Total number of payments to be made.
</comment>
187 <export>true
</export>
190 <name>start_date
</name>
191 <type>datetime
</type>
192 <title>Pledge Start Date
</title>
193 <required>true
</required>
194 <export>true
</export>
195 <comment>The date the first scheduled pledge occurs.
</comment>
198 <type>Select Date
</type>
199 <formatType>activityDate
</formatType>
201 <uniqueName>pledge_start_date
</uniqueName>
202 <uniqueTitle>Payments Start Date
</uniqueTitle>
205 <name>create_date
</name>
206 <type>datetime
</type>
207 <uniqueName>pledge_create_date
</uniqueName>
208 <title>Pledge Made
</title>
209 <required>true
</required>
210 <import>true
</import>
211 <export>true
</export>
212 <comment>When this pledge record was created.
</comment>
215 <type>Select Date
</type>
216 <formatType>activityDate
</formatType>
220 <name>acknowledge_date
</name>
221 <type>datetime
</type>
222 <title>Pledge Acknowledged
</title>
223 <comment>When a pledge acknowledgement message was sent to the contributor.
</comment>
226 <type>Select Date
</type>
227 <formatType>activityDate
</formatType>
231 <name>modified_date
</name>
232 <type>datetime
</type>
233 <title>Pledge Modified Date
</title>
234 <comment>Last updated date for this pledge record.
</comment>
235 <readonly>true
</readonly>
239 <name>cancel_date
</name>
240 <type>datetime
</type>
241 <title>Pledge Cancelled Date
</title>
242 <comment>Date this pledge was cancelled by contributor.
</comment>
245 <type>Select Date
</type>
246 <formatType>activityDate
</formatType>
250 <name>end_date
</name>
251 <type>datetime
</type>
252 <title>Pledge End Date
</title>
253 <export>true
</export>
254 <comment>Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount).
</comment>
257 <type>Select Date
</type>
258 <formatType>activityDate
</formatType>
260 <uniqueName>pledge_end_date
</uniqueName>
261 <uniqueTitle>Payments Ended Date
</uniqueTitle>
264 <name>max_reminders
</name>
265 <title>Maximum Number of Reminders
</title>
266 <type>int unsigned
</type>
268 <comment>The maximum number of payment reminders to send for any given payment.
</comment>
275 <name>initial_reminder_day
</name>
276 <title>Initial Reminder Day
</title>
277 <type>int unsigned
</type>
279 <comment>Send initial reminder this many days prior to the payment due date.
</comment>
286 <name>additional_reminder_day
</name>
287 <title>Additional Reminder Days
</title>
288 <type>int unsigned
</type>
290 <comment>Send additional reminder this many days after last one sent, up to maximum number of reminders.
</comment>
297 <name>status_id
</name>
298 <title>Pledge Status ID
</title>
299 <uniqueName>pledge_status_id
</uniqueName>
300 <required>true
</required>
301 <import>true
</import>
302 <export>false
</export>
303 <type>int unsigned
</type>
308 <optionGroupName>pledge_status
</optionGroupName>
310 <comment>Implicit foreign key to civicrm_option_values in the pledge_status option group.
</comment>
314 <name>index_status
</name>
315 <fieldName>status_id
</fieldName>
320 <uniqueName>pledge_is_test
</uniqueName>
321 <import>true
</import>
325 <required>true
</required>
327 <type>CheckBox
</type>
331 <name>campaign_id
</name>
332 <component>CiviCampaign
</component>
333 <uniqueName>pledge_campaign_id
</uniqueName>
334 <type>int unsigned
</type>
335 <title>Campaign ID
</title>
336 <import>true
</import>
337 <comment>The campaign for which this pledge has been initiated.
</comment>
340 <type>EntityRef
</type>
341 <label>Campaign
</label>
345 <name>campaign_id
</name>
346 <table>civicrm_campaign
</table>
348 <onDelete>SET NULL
</onDelete>