<add>3.3</add>
<field>
<name>id</name>
+ <title>Batch ID</title>
<type>int unsigned</type>
<required>true</required>
<comment>Unique Address ID</comment>
</primaryKey>
<field>
<name>name</name>
+ <title>Batch Name</title>
<type>varchar</type>
<length>64</length>
<comment>Variable name/programmatic handle for this batch.</comment>
</field>
<field>
<name>title</name>
+ <title>Batch Title</title>
<type>varchar</type>
<length>64</length>
<localizable>true</localizable>
</field>
<field>
<name>description</name>
+ <title>Batch Description</title>
<type>text</type>
<comment>Description of this batch set.</comment>
<localizable>true</localizable>
</field>
<field>
<name>created_id</name>
+ <title>Batch Created By</title>
<type>int unsigned</type>
<comment>FK to Contact ID</comment>
<add>3.3</add>
</foreignKey>
<field>
<name>created_date</name>
+ <title>Batch Created Date</title>
<type>datetime</type>
<comment>When was this item created</comment>
<add>3.3</add>
</field>
<field>
<name>modified_id</name>
+ <title>Batch Modified By</title>
<type>int unsigned</type>
<comment>FK to Contact ID</comment>
<add>3.3</add>
</field>
<field>
<name>modified_date</name>
+ <title>Batch Modified Date</title>
<type>datetime</type>
<comment>When was this item created</comment>
<add>3.3</add>
</foreignKey>
<field>
<name>saved_search_id</name>
+ <title>Batch Smart Group</title>
<type>int unsigned</type>
<comment>FK to Saved Search ID</comment>
<add>4.1</add>
</foreignKey>
<field>
<name>status_id</name>
+ <title>Batch Status</title>
<type>int unsigned</type>
<required>true</required>
<comment>fk to Batch Status options in civicrm_option_values</comment>
<optionGroupName>batch_status</optionGroupName>
</pseudoconstant>
<html>
- <type>Select></type>
+ <type>Select</type>
</html>
</field>
<field>
<name>type_id</name>
+ <title>Batch Type</title>
<type>int unsigned</type>
<comment>fk to Batch Type options in civicrm_option_values</comment>
<add>4.2</add>
<optionGroupName>batch_type</optionGroupName>
</pseudoconstant>
<html>
- <type>Select></type>
+ <type>Select</type>
</html>
</field>
<field>
<name>mode_id</name>
+ <title>Batch Mode</title>
<type>int unsigned</type>
<comment>fk to Batch mode options in civicrm_option_values</comment>
<add>4.2</add>
<optionGroupName>batch_mode</optionGroupName>
</pseudoconstant>
<html>
- <type>Select></type>
+ <type>Select</type>
</html>
</field>
<field>
<name>total</name>
+ <title>Batch Total</title>
<type>decimal</type>
<comment>Total amount for this batch.</comment>
<add>4.2</add>
</field>
<field>
<name>item_count</name>
+ <title>Batch Number of Items</title>
<type>int unsigned</type>
<comment>Number of items in a batch.</comment>
<add>4.2</add>
</field>
<field>
<name>payment_instrument_id</name>
+ <title>Batch Payment Instrument</title>
<type>int unsigned</type>
<comment>fk to Payment Instrument options in civicrm_option_values</comment>
<pseudoconstant>
<optionGroupName>payment_instrument</optionGroupName>
</pseudoconstant>
<html>
- <type>Select></type>
+ <type>Select</type>
</html>
<add>4.3</add>
</field>
<field>
<name>exported_date</name>
+ <title>Batch Exported Date</title>
<type>datetime</type>
<add>4.3</add>
</field>
<field>
<name>data</name>
+ <title>Batch Data</title>
<type>longtext</type>
<comment>cache entered data</comment>
<add>4.4</add>