1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Pledge
</base>
5 <class>PledgePayment
</class>
6 <name>civicrm_pledge_payment
</name>
7 <comment>Pledge Payment
</comment>
10 <component>CiviPledge
</component>
13 <uniqueName>pledge_payment_id
</uniqueName>
14 <title>Payment ID
</title>
15 <type>int unsigned
</type>
16 <required>true
</required>
25 <autoincrement>true
</autoincrement>
28 <name>pledge_id
</name>
29 <title>Pledge ID
</title>
30 <type>int unsigned
</type>
31 <required>true
</required>
32 <comment>FK to Pledge table
</comment>
39 <name>pledge_id
</name>
40 <table>civicrm_pledge
</table>
43 <onDelete>CASCADE
</onDelete>
46 <name>contribution_id
</name>
47 <title>Contribution ID
</title>
48 <type>int unsigned
</type>
49 <comment>FK to contribution table.
</comment>
51 <label>Contribution
</label>
56 <name>contribution_id
</name>
57 <table>civicrm_contribution
</table>
60 <onDelete>CASCADE
</onDelete>
63 <name>index_contribution_pledge
</name>
64 <fieldName>contribution_id
</fieldName>
65 <fieldName>pledge_id
</fieldName>
69 <name>scheduled_amount
</name>
70 <uniqueName>pledge_payment_scheduled_amount
</uniqueName>
71 <title>Scheduled Amount
</title>
75 <required>true
</required>
76 <comment>Pledged amount for this payment (the actual contribution amount might be different).
</comment>
80 <name>actual_amount
</name>
81 <uniqueName>pledge_payment_actual_amount
</uniqueName>
82 <title>Actual Amount
</title>
85 <comment>Actual amount that is paid as the Pledged installment amount.
</comment>
90 <title>Currency
</title>
93 <default>NULL
</default>
94 <comment>3 character string, value from config setting or input via user.
</comment>
97 <table>civicrm_currency
</table>
98 <keyColumn>name
</keyColumn>
99 <labelColumn>full_name
</labelColumn>
100 <nameColumn>name
</nameColumn>
101 <abbrColumn>symbol
</abbrColumn>
108 <name>scheduled_date
</name>
109 <uniqueName>pledge_payment_scheduled_date
</uniqueName>
110 <title>Scheduled Date
</title>
111 <import>true
</import>
112 <export>true
</export>
113 <type>datetime
</type>
114 <required>true
</required>
115 <comment>The date the pledge payment is supposed to happen.
</comment>
118 <type>Select Date
</type>
119 <formatType>activityDate
</formatType>
121 <uniqueTitle>Payment Scheduled
</uniqueTitle>
124 <name>reminder_date
</name>
125 <uniqueName>pledge_payment_reminder_date
</uniqueName>
126 <title>Last Reminder
</title>
127 <import>true
</import>
128 <type>datetime
</type>
129 <comment>The date that the most recent payment reminder was sent.
</comment>
133 <name>reminder_count
</name>
134 <uniqueName>pledge_payment_reminder_count
</uniqueName>
135 <title>Reminders Sent
</title>
136 <import>true
</import>
137 <type>int unsigned
</type>
139 <comment>The number of payment reminders sent.
</comment>
143 <name>status_id
</name>
144 <title>Payment Status
</title>
145 <uniqueName>pledge_payment_status_id
</uniqueName>
146 <import>true
</import>
147 <export>false
</export>
148 <type>int unsigned
</type>
151 <optionGroupName>contribution_status
</optionGroupName>
155 <name>index_status
</name>
156 <fieldName>status_id
</fieldName>