1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
3 <base>CRM/Pledge
</base>
5 <name>civicrm_pledge
</name>
10 <uniqueName>pledge_id
</uniqueName>
11 <title>Pledge ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Pledge ID
</comment>
20 <autoincrement>true
</autoincrement>
23 <name>contact_id
</name>
24 <uniqueName>pledge_contact_id
</uniqueName>
25 <title>Contact ID
</title>
27 <type>int unsigned
</type>
28 <required>true
</required>
29 <comment>Foreign key to civicrm_contact.id .
</comment>
32 <type>EntityRef
</type>
36 <name>contact_id
</name>
37 <table>civicrm_contact
</table>
40 <onDelete>CASCADE
</onDelete>
43 <name>contribution_type_id
</name>
44 <uniqueName>pledge_contribution_type_id
</uniqueName>
45 <export>false
</export>
46 <type>int unsigned
</type>
47 <comment>FK to Contribution Type. This is propagated to contribution record when pledge payments are made.
</comment>
52 <name>contribution_type_id
</name>
53 <table>civicrm_contribution_type
</table>
57 <onDelete>SET NULL
</onDelete>
60 <name>financial_type_id
</name>
62 <uniqueName>pledge_financial_type_id
</uniqueName>
63 <type>int unsigned
</type>
64 <comment>FK to Financial Type
</comment>
66 <table>civicrm_financial_type
</table>
67 <keyColumn>id
</keyColumn>
68 <labelColumn>name
</labelColumn>
76 <name>financial_type_id
</name>
77 <table>civicrm_financial_type
</table>
82 <name>contribution_page_id
</name>
83 <uniqueName>pledge_contribution_page_id
</uniqueName>
84 <title>Pledge Contribution Page
</title>
85 <type>int unsigned
</type>
86 <comment>The Contribution Page which triggered this contribution
</comment>
90 <name>contribution_page_id
</name>
91 <table>civicrm_contribution_page
</table>
93 <onDelete>SET NULL
</onDelete>
97 <uniqueName>pledge_amount
</uniqueName>
98 <title>Total Pledged
</title>
100 <required>true
</required>
101 <import>true
</import>
102 <comment>Total pledged amount.
</comment>
109 <name>original_installment_amount
</name>
110 <uniqueName>pledge_original_installment_amount
</uniqueName>
111 <title>Original Installment Amount
</title>
113 <required>true
</required>
114 <comment>Original amount for each of the installments.
</comment>
119 <export>true
</export>
122 <name>currency
</name>
124 <title>Pledge Currency
</title>
126 <default>NULL
</default>
127 <comment>3 character string, value from config setting or input via user.
</comment>
130 <table>civicrm_currency
</table>
131 <keyColumn>name
</keyColumn>
132 <labelColumn>full_name
</labelColumn>
133 <nameColumn>name
</nameColumn>
134 <abbrColumn>symbol
</abbrColumn>
141 <name>frequency_unit
</name>
142 <uniqueName>pledge_frequency_unit
</uniqueName>
143 <title>Pledge Frequency Unit
</title>
146 <default>'month'
</default>
147 <comment>Time units for recurrence of pledge payments.
</comment>
149 <optionGroupName>recur_frequency_units
</optionGroupName>
150 <keyColumn>name
</keyColumn>
158 <name>frequency_interval
</name>
159 <uniqueName>pledge_frequency_interval
</uniqueName>
160 <title>Pledge Frequency Interval
</title>
161 <type>int unsigned
</type>
162 <required>true
</required>
164 <comment>Number of time units for recurrence of pledge payments.
</comment>
171 <name>frequency_day
</name>
172 <type>int unsigned
</type>
173 <title>Pledge day
</title>
175 <required>true
</required>
176 <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>
183 <name>installments
</name>
184 <type>int unsigned
</type>
185 <title>Pledge Number of Installments
</title>
187 <comment>Total number of payments to be made.
</comment>
192 <export>true
</export>
195 <name>start_date
</name>
196 <type>datetime
</type>
197 <title>Pledge Start Date
</title>
198 <required>true
</required>
199 <export>true
</export>
200 <comment>The date the first scheduled pledge occurs.
</comment>
203 <type>Select Date
</type>
205 <uniqueName>pledge_start_date
</uniqueName>
206 <uniqueTitle>Payments Start Date
</uniqueTitle>
209 <name>create_date
</name>
210 <type>datetime
</type>
211 <uniqueName>pledge_create_date
</uniqueName>
212 <title>Pledge Made
</title>
213 <required>true
</required>
214 <import>true
</import>
215 <export>true
</export>
216 <comment>When this pledge record was created.
</comment>
219 <type>Select Date
</type>
223 <name>acknowledge_date
</name>
224 <type>datetime
</type>
225 <title>Pledge Acknowledged
</title>
226 <comment>When a pledge acknowledgement message was sent to the contributor.
</comment>
229 <type>Select Date
</type>
233 <name>modified_date
</name>
234 <type>datetime
</type>
235 <title>Pledge Modified Date
</title>
236 <comment>Last updated date for this pledge record.
</comment>
240 <name>cancel_date
</name>
241 <type>datetime
</type>
242 <title>Pledge Cancelled Date
</title>
243 <comment>Date this pledge was cancelled by contributor.
</comment>
246 <type>Select Date
</type>
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>
259 <uniqueName>pledge_end_date
</uniqueName>
260 <uniqueTitle>Payments Ended Date
</uniqueTitle>
263 <name>max_reminders
</name>
264 <title>Maximum Number of Reminders
</title>
265 <type>int unsigned
</type>
267 <comment>The maximum number of payment reminders to send for any given payment.
</comment>
274 <name>initial_reminder_day
</name>
275 <title>Initial Reminder Day
</title>
276 <type>int unsigned
</type>
278 <comment>Send initial reminder this many days prior to the payment due date.
</comment>
285 <name>additional_reminder_day
</name>
286 <title>Additional Reminder Days
</title>
287 <type>int unsigned
</type>
289 <comment>Send additional reminder this many days after last one sent, up to maximum number of reminders.
</comment>
296 <name>status_id
</name>
297 <title>Pledge Status Id
</title>
298 <uniqueName>pledge_status_id
</uniqueName>
299 <import>true
</import>
300 <export>false
</export>
301 <type>int unsigned
</type>
306 <optionGroupName>pledge_status
</optionGroupName>
308 <comment>Implicit foreign key to civicrm_option_values in the pledge_status option group.
</comment>
312 <name>index_status
</name>
313 <fieldName>status_id
</fieldName>
318 <uniqueName>pledge_is_test
</uniqueName>
319 <import>true
</import>
324 <type>CheckBox
</type>
328 <name>campaign_id
</name>
329 <uniqueName>pledge_campaign_id
</uniqueName>
330 <type>int unsigned
</type>
331 <title>Campaign
</title>
332 <import>true
</import>
333 <comment>The campaign for which this pledge has been initiated.
</comment>
335 <table>civicrm_campaign
</table>
336 <keyColumn>id
</keyColumn>
337 <labelColumn>title
</labelColumn>
345 <name>campaign_id
</name>
346 <table>civicrm_campaign
</table>
348 <onDelete>SET NULL
</onDelete>