1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Financial
</base>
5 <class>OfficialReceipt
</class>
6 <name>civicrm_official_receipt
</name>
11 <type>int unsigned
</type>
12 <required>true
</required>
13 <comment>Receipt ID
</comment>
18 <autoincrement>true
</autoincrement>
21 <name>contact_id
</name>
22 <uniqueName>receipt_contact_id
</uniqueName>
23 <title>Contact ID
</title>
24 <type>int unsigned
</type>
25 <required>true
</required>
27 <headerPattern>/contact(.?id)?/i
</headerPattern>
28 <dataPattern>/^\d+$/
</dataPattern>
29 <comment>FK to Contact ID
</comment>
33 <name>contact_id
</name>
34 <table>civicrm_contact
</table>
39 <name>contact_snapshot
</name>
41 <htmlType>textarea
</htmlType>
44 <comment>Serialized array of contact info of payor at time receipt is created
</comment>
46 <writeOnce>true
</writeOnce>
49 <name>issued_date
</name>
51 <required>true
</required>
55 <name>UI_issued_date
</name>
56 <fieldName>issued_date
</fieldName>
60 <name>start_date
</name>
62 <required>true
</required>
66 <name>UI_start_date
</name>
67 <fieldName>start_date
</fieldName>
73 <required>true
</required>
77 <name>UI_end_date
</name>
78 <fieldName>end_date
</fieldName>
82 <name>receipt_status_id
</name>
83 <type>int unsigned
</type>
84 <required>true
</required>
86 <comment>pseudo FK to civicrm_option_value
</comment>
89 <name>UI_receipt_status_id
</name>
90 <fieldName>receipt_status_id
</fieldName>
94 <name>receipt_type_id
</name>
95 <type>int unsigned
</type>
96 <required>true
</required>
98 <comment>pseudo FK to civicrm_option_value
</comment>
101 <name>UI_receipt_type_id
</name>
102 <fieldName>receipt_type_id
</fieldName>
106 <name>total_amount
</name>
108 <required>true
</required>
109 <comment>Total amount for this receipt.
</comment>
113 <name>non_deductible_amount
</name>
115 <comment>Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types.
</comment>
119 <name>currency
</name>
122 <default>NULL
</default>
123 <import>true
</import>
124 <headerPattern>/cur(rency)?/i
</headerPattern>
125 <dataPattern>/^[A-Z]{
3}$/
</dataPattern>
126 <comment>3 character string, value from config setting or input via user.
</comment>
129 <table>civicrm_currency
</table>
130 <keyColumn>name
</keyColumn>
131 <labelColumn>symbol
</labelColumn>
135 <name>msg_template_id
</name>
136 <type>int unsigned
</type>
137 <comment>template used to generate receipt
</comment>
141 <name>msg_template_id
</name>
142 <table>civicrm_msg_template
</table>
145 <onDelete>Set Null
</onDelete>