1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>LineItem
</class>
6 <name>civicrm_line_item
</name>
11 <title>Line Item ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Line Item
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>entity_table
</name>
23 <title>Line Item Entity Type
</title>
26 <required>true
</required>
27 <comment>table which has the transaction
</comment>
31 <name>entity_id
</name>
32 <title>Line Item Entity
</title>
33 <type>int unsigned
</type>
34 <required>true
</required>
35 <comment>entry in table
</comment>
39 <idColumn>entity_id
</idColumn>
40 <typeColumn>entity_table
</typeColumn>
44 <name>contribution_id
</name>
45 <title>Line Item Contribution
</title>
46 <type>int unsigned
</type>
47 <comment>FK to civicrm_contribution
</comment>
51 <name>contribution_id
</name>
52 <table>civicrm_contribution
</table>
54 <onDelete>SET NULL
</onDelete>
57 <name>price_field_id
</name>
58 <title>Line Item Price Field
</title>
59 <type>int unsigned
</type>
60 <comment>FK to civicrm_price_field
</comment>
61 <!-- changed to not required in 4.3 in order to change ON DELETE CASCADE FK constraint to SET NULL -->
65 <name>price_field_id
</name>
66 <table>civicrm_price_field
</table>
68 <onDelete>SET NULL
</onDelete>
72 <title>Line Item Label
</title>
75 <default>NULL
</default>
76 <!-- changed to not required in 4.2.3 -->
77 <comment>descriptive label for item - from price_field_value.label
</comment>
85 <title>Line Item Quantity
</title>
87 <required>true
</required>
88 <comment>How many items ordered
</comment>
95 <name>unit_price
</name>
97 <required>true
</required>
98 <comment>price of each item
</comment>
105 <name>line_total
</name>
106 <title>Line Item Total
</title>
108 <required>true
</required>
109 <comment>qty * unit_price
</comment>
113 <name>participant_count
</name>
114 <title>Line Item Participant Count
</title>
115 <type>int unsigned
</type>
116 <default>NULL
</default>
117 <comment>Participant count for field
</comment>
125 <name>index_entity
</name>
126 <fieldName>entity_table
</fieldName>
127 <fieldName>entity_id
</fieldName>
131 <name>UI_line_item_value
</name>
132 <fieldName>entity_table
</fieldName>
133 <fieldName>entity_id
</fieldName>
134 <fieldName>contribution_id
</fieldName>
135 <fieldName>price_field_value_id
</fieldName>
136 <fieldName>price_field_id
</fieldName>
137 <unique>true
</unique>
140 <!-- Add contribution_id to unique index in 4.5 -->
143 <name>price_field_value_id
</name>
144 <title>Line Item Option
</title>
145 <type>int unsigned
</type>
146 <default>NULL
</default>
147 <comment>FK to civicrm_price_field_value
</comment>
151 <name>price_field_value_id
</name>
152 <table>civicrm_price_field_value
</table>
154 <onDelete>SET NULL
</onDelete>
157 <name>financial_type_id
</name>
158 <title>Financial Type
</title>
159 <type>int unsigned
</type>
160 <default>NULL
</default>
162 <table>civicrm_financial_type
</table>
163 <keyColumn>id
</keyColumn>
164 <labelColumn>name
</labelColumn>
166 <comment>FK to Financial Type.
</comment>
173 <name>financial_type_id
</name>
174 <table>civicrm_financial_type
</table>
176 <onDelete>SET NULL
</onDelete>
180 <name>non_deductible_amount
</name>
181 <title>Non-deductible Amount
</title>
183 <default>0.0</default>
184 <headerPattern>/non?.?deduct/i
</headerPattern>
185 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
186 <required>true
</required>
187 <comment>Portion of total amount which is NOT tax deductible.
</comment>
194 <name>tax_amount
</name>
195 <title>Tax Amount
</title>
197 <import>true
</import>
198 <headerPattern>/tax(.?am(ou)?nt)?/i
</headerPattern>
199 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
200 <comment>tax of each item
</comment>