<type>Text</type>
</html>
</field>
+ <index>
+ <name>index_total_amount_receive_date</name>
+ <fieldName>total_amount</fieldName>
+ <fieldName>receive_date</fieldName>
+ <add>4.7</add>
+ </index>
<field>
<name>fee_amount</name>
<type>decimal</type>
<table>civicrm_currency</table>
<keyColumn>name</keyColumn>
<labelColumn>full_name</labelColumn>
- <nameColumn>numeric_code</nameColumn>
+ <nameColumn>name</nameColumn>
</pseudoconstant>
<html>
<type>Select</type>
</html>
</field>
<index>
- <name>creditnote_id</name>
+ <name>index_creditnote_id</name>
<fieldName>creditnote_id</fieldName>
<add>4.7</add>
</index>
<key>id</key>
<onDelete>SET NULL</onDelete>
</foreignKey>
+ <field>
+ <name>revenue_recognition_date</name>
+ <type>datetime</type>
+ <import>true</import>
+ <headerPattern>/revenue(.?date)?/i</headerPattern>
+ <dataPattern>/^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/</dataPattern>
+ <comment>Stores the date when revenue should be recognized.</comment>
+ <html>
+ <type>Select Date</type>
+ </html>
+ <add>4.7</add>
+ </field>
</table>