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>
12 <uniqueName>pledge_payment_id
</uniqueName>
13 <title>Payment ID
</title>
14 <type>int unsigned
</type>
15 <required>true
</required>
21 <autoincrement>true
</autoincrement>
24 <name>pledge_id
</name>
25 <type>int unsigned
</type>
26 <required>true
</required>
27 <comment>FK to Pledge table
</comment>
31 <name>pledge_id
</name>
32 <table>civicrm_pledge
</table>
35 <onDelete>CASCADE
</onDelete>
38 <name>contribution_id
</name>
39 <type>int unsigned
</type>
40 <comment>FK to contribution table.
</comment>
44 <name>contribution_id
</name>
45 <table>civicrm_contribution
</table>
48 <onDelete>CASCADE
</onDelete>
51 <name>index_contribution_pledge
</name>
52 <fieldName>contribution_id
</fieldName>
53 <fieldName>pledge_id
</fieldName>
57 <name>scheduled_amount
</name>
58 <uniqueName>pledge_payment_scheduled_amount
</uniqueName>
59 <title>Scheduled Amount
</title>
62 <required>true
</required>
63 <comment>Pledged amount for this payment (the actual contribution amount might be different).
</comment>
67 <name>actual_amount
</name>
68 <uniqueName>pledge_payment_actual_amount
</uniqueName>
69 <title>Actual Amount
</title>
72 <comment>Actual amount that is paid as the Pledged installment amount.
</comment>
79 <default>NULL
</default>
80 <comment>3 character string, value from config setting or input via user.
</comment>
83 <table>civicrm_currency
</table>
84 <keyColumn>name
</keyColumn>
85 <labelColumn>full_name
</labelColumn>
86 <nameColumn>numeric_code
</nameColumn>
93 <name>scheduled_date
</name>
94 <uniqueName>pledge_payment_scheduled_date
</uniqueName>
95 <title>Scheduled Date
</title>
98 <required>true
</required>
99 <comment>The date the pledge payment is supposed to happen.
</comment>
103 <name>reminder_date
</name>
104 <uniqueName>pledge_payment_reminder_date
</uniqueName>
105 <title>Last Reminder
</title>
106 <import>true
</import>
107 <type>datetime
</type>
108 <comment>The date that the most recent payment reminder was sent.
</comment>
112 <name>reminder_count
</name>
113 <uniqueName>pledge_payment_reminder_count
</uniqueName>
114 <title>Reminders Sent
</title>
115 <import>true
</import>
116 <type>int unsigned
</type>
118 <comment>The number of payment reminders sent.
</comment>
122 <name>status_id
</name>
123 <title>Payment Status
</title>
124 <uniqueName>pledge_payment_status_id
</uniqueName>
125 <import>true
</import>
126 <export>false
</export>
127 <type>int unsigned
</type>
131 <name>index_status
</name>
132 <fieldName>status_id
</fieldName>