/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Item ID'), 'required' => true), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_TIMESTAMP, 'title' => ts('Financial Item Created Date'), 'description' => 'Date and time the item was created', 'required' => true, 'default' => 'CURRENT_TIMESTAMP'), 'transaction_date' => array('name' => 'transaction_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Financial Item Transaction Date'), 'description' => 'Date and time of the source transaction', 'required' => true), 'contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Item Contact ID'), 'description' => 'FK to Contact ID of contact the item is from', 'required' => true, 'export' => true, 'where' => 'civicrm_financial_item.contact_id', 'headerPattern' => '', 'dataPattern' => '', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Financial Item Description'), 'description' => 'Human readable description of this item, to ease display without lookup of source item.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'amount' => array('name' => 'amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Amount'), 'description' => 'Total amount of this item', 'required' => true, 'precision' => array(20, 2)), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Financial Item Currency'), 'description' => 'Currency for the amount', 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'export' => true, 'where' => 'civicrm_financial_item.currency', 'headerPattern' => '', 'dataPattern' => '', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'numeric_code')), 'financial_account_id' => array('name' => 'financial_account_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Account ID'), 'description' => 'FK to civicrm_financial_account', 'FKClassName' => 'CRM_Financial_DAO_FinancialAccount', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_financial_account', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Item Status ID'), 'description' => 'Payment status: test, paid, part_paid, unpaid (if empty assume unpaid)', 'export' => true, 'where' => 'civicrm_financial_item.status_id', 'headerPattern' => '', 'dataPattern' => '', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'financial_item_status', 'optionEditPath' => 'civicrm/admin/options/financial_item_status')), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Table'), 'description' => 'The table providing the source of this item such as civicrm_line_item', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Entity ID'), 'description' => 'The specific source item that is responsible for the creation of this financial_item'));
}
return self::$_fields;
}
/**
* returns all the column names of this table
*
* @access public
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'required' => true), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_TIMESTAMP, 'title' => ts('Created Date'), 'required' => true, 'default' => 'CURRENT_TIMESTAMP'), 'transaction_date' => array('name' => 'transaction_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Transaction Date'), 'required' => true), 'contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'required' => true, 'export' => true, 'where' => 'civicrm_financial_item.contact_id', 'headerPattern' => '', 'dataPattern' => '', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Description'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'amount' => array('name' => 'amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Amount'), 'required' => true), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Currency'), 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'export' => true, 'where' => 'civicrm_financial_item.currency', 'headerPattern' => '', 'dataPattern' => '', 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'numeric_code')), 'financial_account_id' => array('name' => 'financial_account_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Financial_DAO_FinancialAccount', 'pseudoconstant' => array('table' => 'civicrm_financial_account', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'export' => true, 'where' => 'civicrm_financial_item.status_id', 'headerPattern' => '', 'dataPattern' => '', 'pseudoconstant' => array('optionGroupName' => 'financial_item_status')), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Table'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT));
}
return self::$_fields;
}
