PHP VardefManager::createVardef方法代码示例

 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
$dictionary['sel_Selkirk_Activity'] = array('table' => 'sel_selkirk_activity', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('contact_date' => array('required' => true, 'name' => 'contact_date', 'vname' => 'LBL_CONTACT_DATE', 'type' => 'date', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'size' => '20', 'enable_range_search' => false, 'display_default' => 'now'), 'assigned_user_name' => array('name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'name', 'type' => 'relate', 'reportable' => true, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => '', 'duplicate_merge' => 'disabled', 'required' => false, 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'ext2' => '', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => '255', 'unified_search' => false, 'full_text_search' => array('boost' => 3), 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'disabled', 'merge_filter' => 'disabled', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20'), 'user_id_c' => array('required' => false, 'name' => 'user_id_c', 'vname' => 'LBL_CONTACTED_BY_USER_ID', 'type' => 'id', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 36, 'size' => '20'), 'contacted_by' => array('required' => true, 'source' => 'non-db', 'name' => 'contacted_by', 'vname' => 'LBL_CONTACTED_BY', 'type' => 'relate', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id_name' => 'user_id_c', 'ext2' => 'Users', 'module' => 'Users', 'rname' => 'name', 'quicksearch' => 'enabled', 'studio' => 'visible')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
    require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('sel_Selkirk_Activity', 'sel_Selkirk_Activity', array('basic', 'assignable'));

 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 ********************************************************************************/
$dictionary['My_Custom_File'] = array('table' => 'my_custom_file', 'audited' => true, 'inline_edit' => true, 'fields' => array(), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
    require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('My_Custom_File', 'My_Custom_File', array('basic', 'assignable', 'security_groups', 'file'));

 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 ********************************************************************************/
$dictionary['Call'] = array('table' => 'calls', 'comment' => 'A Call is an activity representing a phone call', 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => true, 'fields' => array('name' => array('name' => 'name', 'vname' => 'LBL_SUBJECT', 'dbType' => 'varchar', 'type' => 'name', 'len' => '50', 'comment' => 'Brief description of the call', 'unified_search' => true, 'full_text_search' => array('boost' => 3), 'required' => true, 'importable' => 'required'), 'duration_hours' => array('name' => 'duration_hours', 'vname' => 'LBL_DURATION_HOURS', 'type' => 'int', 'len' => '2', 'comment' => 'Call duration, hours portion', 'required' => true), 'duration_minutes' => array('name' => 'duration_minutes', 'vname' => 'LBL_DURATION_MINUTES', 'type' => 'int', 'function' => array('name' => 'getDurationMinutesOptions', 'returns' => 'html', 'include' => 'modules/Calls/CallHelper.php'), 'len' => '2', 'group' => 'duration_hours', 'importable' => 'required', 'comment' => 'Call duration, minutes portion'), 'date_start' => array('name' => 'date_start', 'vname' => 'LBL_DATE', 'type' => 'datetimecombo', 'dbType' => 'datetime', 'comment' => 'Date in which call is schedule to (or did) start', 'importable' => 'required', 'required' => true, 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'date_end' => array('name' => 'date_end', 'vname' => 'LBL_DATE_END', 'type' => 'datetimecombo', 'dbType' => 'datetime', 'massupdate' => false, 'comment' => 'Date is which call is scheduled to (or did) end', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'parent_type' => array('name' => 'parent_type', 'vname' => 'LBL_PARENT_TYPE', 'type' => 'parent_type', 'dbType' => 'varchar', 'required' => false, 'group' => 'parent_name', 'options' => 'parent_type_display', 'len' => 255, 'comment' => 'The Sugar object to which the call is related'), 'parent_name' => array('name' => 'parent_name', 'parent_type' => 'record_type_display', 'type_name' => 'parent_type', 'id_name' => 'parent_id', 'vname' => 'LBL_LIST_RELATED_TO', 'type' => 'parent', 'group' => 'parent_name', 'source' => 'non-db', 'options' => 'parent_type_display'), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'len' => 100, 'options' => 'call_status_dom', 'comment' => 'The status of the call (Held, Not Held, etc.)', 'required' => true, 'importable' => 'required', 'default' => 'Planned', 'studio' => array('detailview' => false)), 'direction' => array('name' => 'direction', 'vname' => 'LBL_DIRECTION', 'type' => 'enum', 'len' => 100, 'options' => 'call_direction_dom', 'comment' => 'Indicates whether call is inbound or outbound'), 'parent_id' => array('name' => 'parent_id', 'vname' => 'LBL_LIST_RELATED_TO_ID', 'type' => 'id', 'group' => 'parent_name', 'reportable' => false, 'comment' => 'The ID of the parent Sugar object identified by parent_type'), 'reminder_checked' => array('name' => 'reminder_checked', 'vname' => 'LBL_REMINDER', 'type' => 'bool', 'source' => 'non-db', 'comment' => 'checkbox indicating whether or not the reminder value is set (Meta-data only)', 'massupdate' => false), 'reminder_time' => array('name' => 'reminder_time', 'vname' => 'LBL_REMINDER_TIME', 'type' => 'enum', 'dbType' => 'int', 'options' => 'reminder_time_options', 'reportable' => false, 'massupdate' => false, 'default' => -1, 'comment' => 'Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start'), 'email_reminder_checked' => array('name' => 'email_reminder_checked', 'vname' => 'LBL_EMAIL_REMINDER', 'type' => 'bool', 'source' => 'non-db', 'comment' => 'checkbox indicating whether or not the email reminder value is set (Meta-data only)', 'massupdate' => false), 'email_reminder_time' => array('name' => 'email_reminder_time', 'vname' => 'LBL_EMAIL_REMINDER_TIME', 'type' => 'enum', 'dbType' => 'int', 'options' => 'reminder_time_options', 'reportable' => false, 'massupdate' => false, 'default' => -1, 'comment' => 'Specifies when a email reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start'), 'email_reminder_sent' => array('name' => 'email_reminder_sent', 'vname' => 'LBL_EMAIL_REMINDER_SENT', 'default' => 0, 'type' => 'bool', 'comment' => 'Whether email reminder is already sent', 'studio' => false, 'massupdate' => false), 'outlook_id' => array('name' => 'outlook_id', 'vname' => 'LBL_OUTLOOK_ID', 'type' => 'varchar', 'len' => '255', 'reportable' => false, 'comment' => 'When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID'), 'accept_status' => array('name' => 'accept_status', 'vname' => 'LBL_ACCEPT_STATUS', 'dbType' => 'varchar', 'type' => 'varchar', 'len' => '20', 'source' => 'non-db'), 'set_accept_links' => array('name' => 'accept_status', 'vname' => 'LBL_ACCEPT_LINK', 'dbType' => 'varchar', 'type' => 'varchar', 'len' => '20', 'source' => 'non-db'), 'contact_name' => array('name' => 'contact_name', 'rname' => 'last_name', 'db_concat_fields' => array(0 => 'first_name', 1 => 'last_name'), 'id_name' => 'contact_id', 'massupdate' => false, 'vname' => 'LBL_CONTACT_NAME', 'type' => 'relate', 'link' => 'contacts', 'table' => 'contacts', 'isnull' => 'true', 'module' => 'Contacts', 'join_name' => 'contacts', 'dbType' => 'varchar', 'source' => 'non-db', 'len' => 36, 'importable' => 'false', 'studio' => array('required' => false, 'listview' => true, 'visible' => false)), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'opportunity_calls', 'source' => 'non-db', 'link_type' => 'one', 'vname' => 'LBL_OPPORTUNITY'), 'leads' => array('name' => 'leads', 'type' => 'link', 'relationship' => 'calls_leads', 'source' => 'non-db', 'vname' => 'LBL_LEADS'), 'project' => array('name' => 'project', 'type' => 'link', 'relationship' => 'projects_calls', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS'), 'case' => array('name' => 'case', 'type' => 'link', 'relationship' => 'case_calls', 'source' => 'non-db', 'link_type' => 'one', 'vname' => 'LBL_CASE'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'account_calls', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db', 'vname' => 'LBL_ACCOUNT'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'calls_contacts', 'source' => 'non-db', 'vname' => 'LBL_CONTACTS'), 'users' => array('name' => 'users', 'type' => 'link', 'relationship' => 'calls_users', 'source' => 'non-db', 'vname' => 'LBL_USERS'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'calls_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'calls_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'calls_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'calls_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'contact_id' => array('name' => 'contact_id', 'type' => 'id', 'source' => 'non-db'), 'repeat_type' => array('name' => 'repeat_type', 'vname' => 'LBL_REPEAT_TYPE', 'type' => 'enum', 'len' => 36, 'options' => 'repeat_type_dom', 'comment' => 'Type of recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_interval' => array('name' => 'repeat_interval', 'vname' => 'LBL_REPEAT_INTERVAL', 'type' => 'int', 'len' => 3, 'default' => 1, 'comment' => 'Interval of recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_dow' => array('name' => 'repeat_dow', 'vname' => 'LBL_REPEAT_DOW', 'type' => 'varchar', 'len' => 7, 'comment' => 'Days of week in recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_until' => array('name' => 'repeat_until', 'vname' => 'LBL_REPEAT_UNTIL', 'type' => 'date', 'comment' => 'Repeat until specified date', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_count' => array('name' => 'repeat_count', 'vname' => 'LBL_REPEAT_COUNT', 'type' => 'int', 'len' => 7, 'comment' => 'Number of recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_parent_id' => array('name' => 'repeat_parent_id', 'vname' => 'LBL_REPEAT_PARENT_ID', 'type' => 'id', 'len' => 36, 'comment' => 'Id of the first element of recurring records', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'recurring_source' => array('name' => 'recurring_source', 'vname' => 'LBL_RECURRING_SOURCE', 'type' => 'varchar', 'len' => 36, 'comment' => 'Source of recurring call', 'importable' => false, 'massupdate' => false, 'reportable' => false, 'studio' => false)), 'indices' => array(array('name' => 'idx_call_name', 'type' => 'index', 'fields' => array('name')), array('name' => 'idx_status', 'type' => 'index', 'fields' => array('status')), array('name' => 'idx_calls_date_start', 'type' => 'index', 'fields' => array('date_start')), array('name' => 'idx_calls_par_del', 'type' => 'index', 'fields' => array('parent_id', 'parent_type', 'deleted')), array('name' => 'idx_calls_assigned_del', 'type' => 'index', 'fields' => array('deleted', 'assigned_user_id'))), 'relationships' => array('calls_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'calls_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'calls_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many'), 'calls_notes' => array('lhs_module' => 'Calls', 'lhs_table' => 'calls', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Calls')), 'optimistic_locking' => true);
VardefManager::createVardef('Calls', 'Call', array('default', 'assignable'));

 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 ********************************************************************************/
$dictionary['jjwg_Areas'] = array('table' => 'jjwg_areas', 'audited' => true, 'fields' => array('city' => array('required' => false, 'name' => 'city', 'vname' => 'LBL_CITY', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => 'City', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'state' => array('required' => false, 'name' => 'state', 'vname' => 'LBL_STATE', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => 'State', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'country' => array('required' => false, 'name' => 'country', 'vname' => 'LBL_COUNTRY', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => 'Country', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'coordinates' => array('required' => false, 'name' => 'coordinates', 'vname' => 'LBL_COORDINATES', 'type' => 'text', 'massupdate' => 0, 'comments' => '', 'help' => 'Coordinates Format: Lng, Lat, Elv', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'studio' => 'visible', 'rows' => '6', 'cols' => '80'), 'jjwg_maps_jjwg_areas' => array('name' => 'jjwg_maps_jjwg_areas', 'type' => 'link', 'relationship' => 'jjwg_maps_jjwg_areas', 'source' => 'non-db', 'vname' => 'LBL_JJWG_MAPS_JJWG_AREAS_FROM_JJWG_MAPS_TITLE')), 'relationships' => array(), 'optimistic_locking' => true);
if (!class_exists('VardefManager')) {
    require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('jjwg_Areas', 'jjwg_Areas', array('basic', 'assignable', 'security_groups'));

 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
$dictionary['SchedulersJob'] = array('table' => 'job_queue', 'comment' => 'Job queue keeps the list of the jobs executed by this instance', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'len' => '36', 'required' => true, 'reportable' => false), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'required' => true), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true), 'scheduler_id' => array('name' => 'scheduler_id', 'vname' => 'LBL_SCHEDULER', 'type' => 'id', 'required' => false, 'reportable' => false), 'execute_time' => array('name' => 'execute_time', 'vname' => 'LBL_EXECUTE_TIME', 'type' => 'datetime', 'required' => true), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'options' => 'schedulers_times_dom', 'len' => 20, 'required' => true, 'reportable' => true, 'readonly' => true), 'resolution' => array('name' => 'resolution', 'vname' => 'LBL_RESOLUTION', 'type' => 'enum', 'options' => 'schedulers_resolution_dom', 'len' => 20, 'required' => true, 'reportable' => true, 'readonly' => true), 'message' => array('name' => 'message', 'vname' => 'LBL_MESSAGE', 'type' => 'text', 'required' => false, 'reportable' => false), 'target' => array('name' => 'target', 'vname' => 'LBL_TARGET', 'type' => 'varchar', 'len' => 255, 'required' => true, 'reportable' => true), 'data' => array('name' => 'data', 'vname' => 'LBL_DATA', 'type' => 'text', 'required' => false, 'reportable' => true), 'requeue' => array('name' => 'requeue', 'vname' => 'LBL_REQUEUE', 'type' => 'bool', 'default' => 0, 'required' => false, 'reportable' => true), 'retry_count' => array('name' => 'retry_count', 'vname' => 'LBL_RETRY_COUNT', 'type' => 'tinyint', 'required' => false, 'reportable' => true), 'failure_count' => array('name' => 'failure_count', 'vname' => 'LBL_FAIL_COUNT', 'type' => 'tinyint', 'required' => false, 'reportable' => true, 'readonly' => true), 'job_delay' => array('name' => 'job_delay', 'vname' => 'LBL_INTERVAL', 'type' => 'int', 'required' => false, 'reportable' => false), 'client' => array('name' => 'client', 'vname' => 'LBL_CLIENT', 'type' => 'varchar', 'len' => 255, 'required' => true, 'reportable' => true), 'percent_complete' => array('name' => 'percent_complete', 'vname' => 'LBL_PERCENT', 'type' => 'int', 'required' => false), 'schedulers' => array('name' => 'schedulers', 'vname' => 'LBL_SCHEDULER_ID', 'type' => 'link', 'relationship' => 'schedulers_jobs_rel', 'source' => 'non-db', 'link_type' => 'one')), 'indices' => array(array('name' => 'job_queuepk', 'type' => 'primary', 'fields' => array('id')), array('name' => 'idx_status_scheduler', 'type' => 'index', 'fields' => array('status', 'scheduler_id')), array('name' => 'idx_status_time', 'type' => 'index', 'fields' => array('status', 'execute_time', 'date_entered')), array('name' => 'idx_status_entered', 'type' => 'index', 'fields' => array('status', 'date_entered')), array('name' => 'idx_status_modified', 'type' => 'index', 'fields' => array('status', 'date_modified'))));
VardefManager::createVardef('SchedulersJobs', 'SchedulersJob', array('assignable'));

 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
$dictionary['Project'] = array('table' => 'project', 'unified_search' => true, 'unified_search_default_enabled' => false, 'comment' => 'Project', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_ID', 'required' => true, 'type' => 'id', 'reportable' => true, 'comment' => 'Unique identifier'), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'assigned_user_id' => array('name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'type' => 'assigned_user_name', 'vname' => 'LBL_ASSIGNED_USER_ID', 'required' => false, 'len' => 36, 'dbType' => 'id', 'table' => 'users', 'isnull' => false, 'reportable' => true, 'comment' => 'User assigned to this record'), 'modified_user_id' => array('name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record'), 'modified_by_name' => array('name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled'), 'created_by' => array('name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED_BY', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'comment' => 'User who created record'), 'created_by_name' => array('name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'required' => true, 'dbType' => 'varchar', 'type' => 'name', 'len' => 50, 'unified_search' => true, 'comment' => 'Project name', 'importable' => 'required', 'required' => true), 'description' => array('name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'required' => false, 'type' => 'text', 'comment' => 'Project description'), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => false, 'reportable' => false, 'default' => '0', 'comment' => 'Record deletion indicator'), 'estimated_start_date' => array('name' => 'estimated_start_date', 'vname' => 'LBL_DATE_START', 'required' => true, 'validation' => array('type' => 'isbefore', 'compareto' => 'estimated_end_date', 'blank' => true), 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'estimated_end_date' => array('name' => 'estimated_end_date', 'vname' => 'LBL_DATE_END', 'required' => true, 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'options' => 'project_status_dom'), 'priority' => array('name' => 'priority', 'vname' => 'LBL_PRIORITY', 'type' => 'enum', 'options' => 'projects_priority_options'), 'total_estimated_effort' => array('name' => 'total_estimated_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ESTIMATED_EFFORT'), 'total_actual_effort' => array('name' => 'total_actual_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ACTUAL_EFFORT'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'projects_accounts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_ACCOUNTS'), 'quotes' => array('name' => 'quotes', 'type' => 'link', 'relationship' => 'projects_quotes', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_QUOTES'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'projects_contacts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_CONTACTS'), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'projects_opportunities', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_OPPORTUNITIES'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'projects_notes', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'tasks' => array('name' => 'tasks', 'type' => 'link', 'relationship' => 'projects_tasks', 'source' => 'non-db', 'vname' => 'LBL_TASKS'), 'meetings' => array('name' => 'meetings', 'type' => 'link', 'relationship' => 'projects_meetings', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS'), 'calls' => array('name' => 'calls', 'type' => 'link', 'relationship' => 'projects_calls', 'source' => 'non-db', 'vname' => 'LBL_CALLS'), 'emails' => array('name' => 'emails', 'type' => 'link', 'relationship' => 'emails_projects_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS'), 'projecttask' => array('name' => 'projecttask', 'type' => 'link', 'relationship' => 'projects_project_tasks', 'source' => 'non-db', 'vname' => 'LBL_PROJECT_TASKS'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'projects_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'projects_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'projects_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_name' => array('name' => 'assigned_user_name', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_USER_NAME', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'dbType' => 'varchar', 'link' => 'users', 'len' => '255', 'source' => 'non-db'), 'cases' => array('name' => 'cases', 'type' => 'link', 'relationship' => 'projects_cases', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_CASES'), 'bugs' => array('name' => 'bugs', 'type' => 'link', 'relationship' => 'projects_bugs', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_BUGS'), 'products' => array('name' => 'products', 'type' => 'link', 'relationship' => 'projects_products', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_PRODUCTS')), 'indices' => array(array('name' => 'projects_primary_key_index', 'type' => 'primary', 'fields' => array('id'))), 'relationships' => array('projects_notes' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Tasks', 'rhs_table' => 'tasks', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_meetings' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Meetings', 'rhs_table' => 'meetings', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_calls' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_emails' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Emails', 'rhs_table' => 'emails', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_project_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'ProjectTask', 'rhs_table' => 'project_task', 'rhs_key' => 'project_id', 'relationship_type' => 'one-to-many'), 'projects_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'projects_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'projects_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many')));
VardefManager::createVardef('Project', 'Project', array());

 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
$module = 'Realty';
$dictionary['Realty'] = array('table' => 'realty', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('request' => array('name' => 'request', 'vname' => 'LBL_REQUEST', 'type' => 'varchar', 'source' => 'non-db'), 'code_inc' => array('name' => 'code_inc', 'vname' => 'LBL_CODE', 'type' => 'int', 'auto_increment' => true, 'massupdate' => 0, 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'reportable' => 0), 'presentation_text' => array('name' => 'presentation_text', 'vname' => 'LBL_PRESENTATION_TEXT', 'type' => 'varchar', 'required' => false), 'presentation_checked' => array('name' => 'presentation_checked', 'vname' => 'LBL_PRESENTATION_CHECKED', 'type' => 'varchar', 'required' => false, 'source' => 'non-db'), 'reserved' => array('name' => 'reserved', 'vname' => 'LBL_RESERVED', 'type' => 'bool'), 'last_contact' => array('name' => 'last_contact', 'vname' => 'LBL_LAST_CONTACT', 'type' => 'date'), 'd_text' => array('name' => 'd_text', 'vname' => 'LBL_D_TEXT', 'type' => 'text'), 'd_name' => array('name' => 'd_name', 'vname' => 'LBL_D_NAME', 'type' => 'varchar'), 'room_layout' => array('name' => 'room_layout', 'vname' => 'LBL_ROOM_LAYOUT', 'type' => 'enum', 'options' => 'room_layout_list'), 'for_office' => array('name' => 'for_office', 'vname' => 'LBL_FOR_OFFICE', 'type' => 'bool'), 'balcon' => array('name' => 'balcon', 'vname' => 'LBL_BALCON', 'type' => 'bool'), 'phone_bool' => array('name' => 'phone_bool', 'vname' => 'LBL_PHONE_BOOL', 'type' => 'bool'), 'boiler' => array('name' => 'boiler', 'vname' => 'LBL_BOILER', 'type' => 'bool'), 'tv' => array('name' => 'tv', 'vname' => 'LBL_TV', 'type' => 'bool'), 'fridge' => array('name' => 'fridge', 'vname' => 'LBL_FRIDGE', 'type' => 'bool'), 'washing_m' => array('name' => 'washing_m', 'vname' => 'LBL_WASHING_M', 'type' => 'bool'), 'conditioning' => array('name' => 'conditioning', 'vname' => 'LBL_CONDITIONING', 'type' => 'bool'), 'internet' => array('name' => 'internet', 'vname' => 'LBL_INTERNET', 'type' => 'bool'), 'parking' => array('name' => 'parking', 'vname' => 'LBL_PARKING', 'type' => 'bool'), 'gaz' => array('name' => 'gaz', 'vname' => 'LBL_GAZ', 'type' => 'enum', 'options' => 'gaz_list'), 'gaz_add' => array('name' => 'gaz_add', 'vname' => 'LBL_GAZ_P', 'type' => 'enum', 'options' => 'gaz_add_list'), 'h2o' => array('name' => 'h2o', 'vname' => 'LBL_H2O', 'type' => 'enum', 'options' => 'h2o_list'), 'h2o_add' => array('name' => 'h2o_add', 'vname' => 'LBL_H2O_P', 'type' => 'enum', 'options' => 'h2o_add_list'), 'owner_last_name' => array('name' => 'owner_last_name', 'vname' => 'LBL_OWNER_LAST_NAME', 'type' => 'varchar', 'required' => true), 'owner_first_name' => array('name' => 'owner_first_name', 'vname' => 'LBL_OWNER_FIRST_NAME', 'type' => 'varchar'), 'owner_phone' => array('name' => 'owner_phone', 'vname' => 'LBL_OWNER_PHONE', 'type' => 'phone', 'dbType' => 'varchar', 'required' => true), 'realty_status' => array('name' => 'realty_status', 'vname' => 'LBL_REALTY_STATUS', 'type' => 'enum', 'options' => 'realty_status_list'), 'activity_status' => array('name' => 'activity_status', 'vname' => 'LBL_ACTIVITY_STATUS', 'type' => 'enum', 'options' => 'activity_status_list'), 'source_of_income_object' => array('name' => 'source_of_income_object', 'vname' => 'LBL_SOURCE_OF_INCOME_OBJECT', 'type' => 'enum', 'options' => 'source_of_income_object_list'), 'operation' => array('name' => 'operation', 'vname' => 'LBL_OPERATION', 'type' => 'enum', 'options' => 'operation_realty_list'), 'operation_status' => array('name' => 'operation_status', 'vname' => 'LBL_OPERATION_STATUS', 'type' => 'enum', 'options' => 'operation_status_realty_list'), 'type_of_realty' => array('name' => 'type_of_realty', 'vname' => 'LBL_TYPE_OF_REALTY', 'type' => 'enum', 'options' => 'type_of_realty_list'), 'kind_of_realty' => array('name' => 'kind_of_realty', 'vname' => 'LBL_KIND_OF_REALTY', 'type' => 'enum', 'options' => 'kind_of_realty_list'), 'square' => array('name' => 'square', 'vname' => 'LBL_SQUARE', 'type' => 'float', 'required' => true), 'living_square' => array('name' => 'living_square', 'vname' => 'LBL_LIVING_SQUARE', 'type' => 'float'), 'kitchen_square' => array('name' => 'kitchen_square', 'vname' => 'LBL_KITCHEN_SQUARE', 'type' => 'float'), 'square_unit' => array('name' => 'square_unit', 'vname' => 'LBL_SQUARE_UNIT', 'type' => 'enum', 'options' => 'square_unit_list'), 'rooms_quantity' => array('name' => 'rooms_quantity', 'vname' => 'LBL_ROOMS_QUANTITY', 'type' => 'int'), 'floor' => array('name' => 'floor', 'vname' => 'LBL_FLOOR', 'type' => 'int'), 'number_of_floors' => array('name' => 'number_of_floors', 'vname' => 'LBL_NUMBER_OF_FLOORS', 'type' => 'int'), 'currency' => array('name' => 'currency', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'options' => 'realty_currency_list'), 'cost' => array('name' => 'cost', 'vname' => 'LBL_COST', 'type' => 'int', 'required' => true), 'period' => array('name' => 'period', 'vname' => 'LBL_PERIOD', 'type' => 'enum', 'options' => 'realty_period_list'), 'totalcost' => array('name' => 'totalcost', 'vname' => 'LBL_TOTALCOST', 'type' => 'int'), 'currency_uah' => array('name' => 'currency_uah', 'vname' => 'LBL_TOTALCOST_UAH', 'type' => 'int'), 'video_youtube' => array('name' => 'video_youtube', 'vname' => 'LBL_VIDEO_YOUTUBE', 'type' => 'varchar'), 'state_of_object' => array('name' => 'state_of_object', 'vname' => 'LBL_STATE_OF_OBJECT', 'type' => 'enum', 'options' => 'state_of_object_list'), 'longitude' => array('name' => 'longitude', 'vname' => 'LBL_LONGITUDE', 'type' => 'varchar'), 'latitude' => array('name' => 'latitude', 'vname' => 'LBL_LATITUDE', 'type' => 'varchar'), 'map_in_editview' => array('name' => 'map_in_editview', 'type' => 'varchar', 'vname' => 'LBL_MAP_IN_EDITVIEW'), 'metro' => array('name' => 'metro', 'vname' => 'LBL_METRO', 'type' => 'varchar'), 'way_to_get' => array('name' => 'way_to_get', 'vname' => 'LBL_WAY_TO_GET', 'type' => 'enum', 'options' => 'way_to_get_list'), 'address_city' => array('name' => 'address_city', 'vname' => 'LBL_ADDRESS_CITY', 'type' => 'varchar'), 'address_country' => array('name' => 'address_country', 'vname' => 'LBL_ADDRESS_COUNTRY', 'type' => 'varchar'), 'address_street' => array('name' => 'address_street', 'vname' => 'LBL_ADDRESS_STREET', 'type' => 'varchar'), 'address_house' => array('name' => 'address_house', 'vname' => 'LBL_ADDRESS_HOUSE', 'type' => 'varchar'), 'address_apartment' => array('name' => 'address_apartment', 'vname' => 'LBL_ADDRESS_APARTMENT', 'type' => 'varchar'), 'address_region' => array('name' => 'address_region', 'vname' => 'LBL_ADDRESS_REGION', 'type' => 'varchar'), 'address_district' => array('name' => 'address_district', 'vname' => 'LBL_ADDRESS_DISTRICT', 'type' => 'varchar'), 'sections_exist' => array('name' => 'sections_exist', 'vname' => 'LBL_SECTIONS_EXIST', 'type' => 'enum', 'options' => 'sections_exist_list'), "email1" => array('name' => 'email1', 'vname' => 'LBL_EMAIL', 'type' => 'varchar', 'function' => array('name' => 'getEmailAddressWidget', 'returns' => 'html'), 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'enabled', 'studio' => 'visible'), 'email_addresses_primary' => array('name' => 'email_addresses_primary', 'type' => 'link', 'relationship' => strtolower($module) . '_email_addresses_primary', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESS_PRIMARY', 'duplicate_merge' => 'disabled'), 'email_addresses' => array('name' => 'email_addresses', 'type' => 'link', 'relationship' => strtolower($module) . '_email_addresses', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESSES', 'reportable' => false, 'unified_search' => true, 'rel_fields' => array('primary_address' => array('type' => 'bool'))), 'contact_id' => array('required' => false, 'name' => 'contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'contact_name' => array('required' => false, 'source' => 'non-db', 'name' => 'contact_name', 'vname' => 'LBL_CONTACT_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'rname' => 'name', 'studio' => 'visible'), 'account_id' => array('required' => false, 'name' => 'account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'account_name' => array('required' => false, 'source' => 'non-db', 'name' => 'account_name', 'vname' => 'LBL_ACCOUNT_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'rname' => 'name', 'studio' => 'visible'), 'building_id' => array('required' => false, 'name' => 'building_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'building_name' => array('required' => false, 'source' => 'non-db', 'name' => 'building_name', 'vname' => 'LBL_BUILDING_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'building_id', 'ext2' => 'Buildings', 'module' => 'Buildings', 'rname' => 'name', 'studio' => 'visible'), 'section_id' => array('required' => false, 'name' => 'section_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'section_name' => array('required' => false, 'source' => 'non-db', 'name' => 'section_name', 'vname' => 'LBL_SECTION_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'section_id', 'ext2' => 'Sections', 'module' => 'Sections', 'rname' => 'name', 'studio' => 'visible'), "realty_calls" => array('name' => 'realty_calls', 'type' => 'link', 'relationship' => 'realty_calls', 'module' => 'Calls', 'bean_name' => 'Calls', 'source' => 'non-db', 'vname' => 'LBL_REALTY_CALLS'), "realty_meetings" => array('name' => 'realty_meetings', 'type' => 'link', 'relationship' => 'realty_meetings', 'module' => 'Meetings', 'bean_name' => 'Meetings', 'source' => 'non-db', 'vname' => 'LBL_REALTY_MEETINGS'), "realty_tasks" => array('name' => 'realty_tasks', 'type' => 'link', 'relationship' => 'realty_tasks', 'module' => 'Tasks', 'bean_name' => 'Tasks', 'source' => 'non-db', 'vname' => 'LBL_REALTY_TASKS')), 'relationships' => array(strtolower($module) . '_email_addresses' => array('lhs_module' => $module, 'lhs_table' => strtolower($module), 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'bean_module', 'relationship_role_column_value' => $module), strtolower($module) . '_email_addresses_primary' => array('lhs_module' => $module, 'lhs_table' => strtolower($module), 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'primary_address', 'relationship_role_column_value' => '1'), 'realty_calls' => array('lhs_module' => 'Realty', 'lhs_table' => 'realty', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'realty_id', 'relationship_type' => 'one-to-many'), 'realty_meetings' => array('lhs_module' => 'Realty', 'lhs_table' => 'realty', 'lhs_key' => 'id', 'rhs_module' => 'Meetings', 'rhs_table' => 'meetings', 'rhs_key' => 'realty_id', 'relationship_type' => 'one-to-many'), 'realty_tasks' => array('lhs_module' => 'Realty', 'lhs_table' => 'realty', 'lhs_key' => 'id', 'rhs_module' => 'Tasks', 'rhs_table' => 'tasks', 'rhs_key' => 'realty_id', 'relationship_type' => 'one-to-many')), 'indices' => array(array('name' => 'code_inc', 'type' => 'unique', 'fields' => array('code_inc'))), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
    require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('Realty', 'Realty', array('basic', 'assignable'));

<?php

if (!defined('sugarEntry') || !sugarEntry) {
    die('Not A Valid Entry Point');
}
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/06_Customer_Center/10_Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */
$dictionary['pmse_BpmNotes'] = array('table' => 'pmse_bpm_notes', 'audited' => false, 'activity_enabled' => false, 'duplicate_merge' => true, 'reassignable' => false, 'fields' => array('cas_id' => array('required' => true, 'name' => 'cas_id', 'vname' => 'Unique Identifier for this Case', 'type' => 'varchar', 'massupdate' => false, 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '36', 'size' => '36'), 'cas_index' => array('required' => true, 'name' => 'cas_index', 'vname' => 'Case flow index a sequential number relative to each case', 'type' => 'int', 'massupdate' => false, 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '4', 'size' => '20', 'enable_range_search' => false, 'disable_num_format' => '', 'min' => false, 'max' => false), 'not_user_id' => array('required' => true, 'name' => 'not_user_id', 'vname' => 'User Identifier for who wrote this note', 'type' => 'varchar', 'massupdate' => false, 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '40', 'size' => '40'), 'not_user_recipient_id' => array('required' => true, 'name' => 'not_user_recipient_id', 'vname' => 'User Identifier for recipient this note', 'type' => 'varchar', 'massupdate' => false, 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '40', 'size' => '40'), 'not_type' => array('required' => true, 'name' => 'not_type', 'vname' => 'Note type', 'type' => 'varchar', 'massupdate' => false, 'default' => 'GENERAL', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '32', 'size' => '32'), 'not_date' => array('required' => false, 'name' => 'not_date', 'vname' => 'when the note was was sent', 'type' => 'datetimecombo', 'massupdate' => true, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'calculated' => false, 'size' => '20', 'enable_range_search' => false, 'dbType' => 'datetime'), 'not_status' => array('required' => true, 'name' => 'not_status', 'vname' => 'Thread status', 'type' => 'varchar', 'massupdate' => false, 'default' => 'ACTIVE', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '10', 'size' => '10'), 'not_availability' => array('required' => true, 'name' => 'not_availability', 'vname' => 'Thread status', 'type' => 'varchar', 'massupdate' => false, 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '32', 'size' => '32'), 'not_content' => array('required' => true, 'name' => 'not_content', 'vname' => 'Case flow index', 'type' => 'text', 'massupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'size' => '20', 'rows' => '4', 'cols' => '20'), 'not_recipients' => array('required' => true, 'name' => 'not_recipients', 'vname' => 'tokens evaluated in this thread', 'type' => 'text', 'massupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'size' => '20', 'rows' => '4', 'cols' => '20')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
    require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('pmse_BpmNotes', 'pmse_BpmNotes', array('basic', 'assignable'));

<?php

/**
 * Products, Quotations & Invoices modules.
 * Extensions to SugarCRM
 * @package Advanced OpenSales for SugarCRM
 * @subpackage Products
 * @copyright SalesAgility Ltd http://www.salesagility.com
 * 
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU AFFERO GENERAL PUBLIC LICENSE
 * along with this program; if not, see http://www.gnu.org/licenses
 * or write to the Free Software Foundation,Inc., 51 Franklin Street,
 * Fifth Floor, Boston, MA 02110-1301  USA
 *
 * @author Salesagility Ltd <support@salesagility.com>
 */
$dictionary['AOS_Invoices'] = array('table' => 'aos_invoices', 'audited' => true, 'fields' => array('billing_account_id' => array('required' => false, 'name' => 'billing_account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'billing_account' => array('required' => false, 'source' => 'non-db', 'name' => 'billing_account', 'vname' => 'LBL_BILLING_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => 1, 'len' => '255', 'id_name' => 'billing_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'billing_contact_id' => array('required' => false, 'name' => 'billing_contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'billing_contact' => array('required' => false, 'source' => 'non-db', 'name' => 'billing_contact', 'vname' => 'LBL_BILLING_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => 1, 'len' => '255', 'id_name' => 'billing_contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'billing_address_street' => array('name' => 'billing_address_street', 'vname' => 'LBL_BILLING_ADDRESS_STREET', 'type' => 'varchar', 'len' => '150', 'comment' => 'The street address used for billing address', 'group' => 'billing_address', 'merge_filter' => 'enabled'), 'billing_address_city' => array('name' => 'billing_address_city', 'vname' => 'LBL_BILLING_ADDRESS_CITY', 'type' => 'varchar', 'len' => '100', 'comment' => 'The city used for billing address', 'group' => 'billing_address', 'merge_filter' => 'enabled'), 'billing_address_state' => array('name' => 'billing_address_state', 'vname' => 'LBL_BILLING_ADDRESS_STATE', 'type' => 'varchar', 'len' => '100', 'group' => 'billing_address', 'comment' => 'The state used for billing address', 'merge_filter' => 'enabled'), 'billing_address_postalcode' => array('name' => 'billing_address_postalcode', 'vname' => 'LBL_BILLING_ADDRESS_POSTALCODE', 'type' => 'varchar', 'len' => '20', 'group' => 'billing_address', 'comment' => 'The postal code used for billing address', 'merge_filter' => 'enabled'), 'billing_address_country' => array('name' => 'billing_address_country', 'vname' => 'LBL_BILLING_ADDRESS_COUNTRY', 'type' => 'varchar', 'group' => 'billing_address', 'comment' => 'The country used for the billing address', 'merge_filter' => 'enabled'), 'shipping_address_street' => array('name' => 'shipping_address_street', 'vname' => 'LBL_SHIPPING_ADDRESS_STREET', 'type' => 'varchar', 'len' => 150, 'group' => 'shipping_address', 'comment' => 'The street address used for for shipping purposes', 'merge_filter' => 'enabled'), 'shipping_address_city' => array('name' => 'shipping_address_city', 'vname' => 'LBL_SHIPPING_ADDRESS_CITY', 'type' => 'varchar', 'len' => 100, 'group' => 'shipping_address', 'comment' => 'The city used for the shipping address', 'merge_filter' => 'enabled'), 'shipping_address_state' => array('name' => 'shipping_address_state', 'vname' => 'LBL_SHIPPING_ADDRESS_STATE', 'type' => 'varchar', 'len' => 100, 'group' => 'shipping_address', 'comment' => 'The state used for the shipping address', 'merge_filter' => 'enabled'), 'shipping_address_postalcode' => array('name' => 'shipping_address_postalcode', 'vname' => 'LBL_SHIPPING_ADDRESS_POSTALCODE', 'type' => 'varchar', 'len' => 20, 'group' => 'shipping_address', 'comment' => 'The zip code used for the shipping address', 'merge_filter' => 'enabled'), 'shipping_address_country' => array('name' => 'shipping_address_country', 'vname' => 'LBL_SHIPPING_ADDRESS_COUNTRY', 'type' => 'varchar', 'group' => 'shipping_address', 'comment' => 'The country used for the shipping address', 'merge_filter' => 'enabled'), 'number' => array('required' => true, 'name' => 'number', 'vname' => 'LBL_INVOICE_NUMBER', 'type' => 'int', 'len' => 11, 'isnull' => 'false', 'unified_search' => true, 'comments' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'reportable' => true, 'disable_num_format' => true), 'line_items' => array('required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => array('name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php')), 'total_amt' => array('required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'subtotal_amount' => array('required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'discount_amount' => array('required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'tax_amount' => array('required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'shipping_amount' => array('required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6'), 'shipping_tax' => array('required' => false, 'name' => 'shipping_tax', 'vname' => 'LBL_SHIPPING_TAX', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'vat_list', 'studio' => 'visible'), 'shipping_tax_amt' => array('required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => array('name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php')), 'total_amount' => array('required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom'), 'currency_id' => array('required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => array('name' => 'getCurrencyDropDown', 'returns' => 'html')), 'quote_number' => array('required' => false, 'name' => 'quote_number', 'vname' => 'LBL_QUOTE_NUMBER', 'type' => 'int', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '11', 'disable_num_format' => ''), 'quote_date' => array('required' => false, 'name' => 'quote_date', 'vname' => 'LBL_QUOTE_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'display_default' => 'now', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'invoice_date' => array('required' => false, 'name' => 'invoice_date', 'vname' => 'LBL_INVOICE_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'display_default' => 'now', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'due_date' => array('required' => false, 'name' => 'due_date', 'vname' => 'LBL_DUE_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'status' => array('required' => false, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'invoice_status_dom', 'studio' => 'visible'), 'template_ddown_c' => array('required' => '0', 'name' => 'template_ddown_c', 'vname' => 'LBL_TEMPLATE_DDOWN_C', 'type' => 'multienum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'options' => 'template_ddown_c_list', 'studio' => 'visible', 'isMultiSelect' => true), 'subtotal_tax_amount' => array('required' => false, 'name' => 'subtotal_tax_amount', 'vname' => 'LBL_SUBTOTAL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'aos_quotes_aos_invoices' => array('name' => 'aos_quotes_aos_invoices', 'type' => 'link', 'relationship' => 'aos_quotes_aos_invoices', 'source' => 'non-db', 'module' => 'AOS_Quotes'), 'aos_products_quotes' => array('name' => 'aos_products_quotes', 'type' => 'link', 'relationship' => 'aos_invoices_aos_product_quotes', 'module' => 'AOS_Products_Quotes', 'bean_name' => 'AOS_Products_Quotes', 'source' => 'non-db')), 'relationships' => array('aos_invoices_aos_product_quotes' => array('lhs_module' => 'AOS_Invoices', 'lhs_table' => 'aos_invoices', 'lhs_key' => 'id', 'rhs_module' => 'AOS_Products_Quotes', 'rhs_table' => 'aos_products_quotes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many')), 'optimistic_lock' => true);
require_once 'include/SugarObjects/VardefManager.php';
VardefManager::createVardef('AOS_Invoices', 'AOS_Invoices', array('basic', 'assignable'));

<?php

if (!defined('sugarEntry') || !sugarEntry) {
    die('Not A Valid Entry Point');
}
$dictionary['Services'] = array('audited' => true, 'comment' => '', 'table' => 'services', 'unified_search' => true, 'fields' => array('code' => array('name' => 'code', 'vname' => 'LBL_RES_CODE', 'type' => 'varchar', 'len' => 50, 'comment' => 'id of one restaurant'), 'autocode' => array('required' => '1', 'name' => 'autocode', 'vname' => '', 'type' => 'int', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => '25'), 'tel' => array('name' => 'tel', 'vname' => 'LBL_RES_TEL', 'type' => 'phone', 'dbType' => 'varchar', 'len' => 50, 'comment' => 'tel of service company', 'audited' => true), 'address' => array('name' => 'address', 'vname' => 'LBL_RES_ADDRESS', 'type' => 'text', 'len' => 250, 'comment' => 'address of restaurant'), 'service_type' => array('name' => 'service_type', 'vname' => 'LBL_SERVICE_TYPE', 'type' => 'enum', 'options' => 'service_company_dom'), 'giathamkhao' => array('name' => 'giathamkhao', 'vname' => 'LBL_GIATHAMKHAO', 'type' => 'currency', 'dbType' => 'double'), 'ngaythamkhaogia' => array('name' => 'ngaythamkhaogia', 'vname' => 'LBL_NGAYTHAMKHAOGIA', 'type' => 'date'), 'area' => array('name' => 'area', 'vname' => 'LBL_AREA', 'type' => 'enum', 'options' => 'khachsan_area'), 'email1' => array('name' => 'email1', 'vname' => 'LBL_EMAIL_ADDRESS', 'type' => 'varchar', 'function' => array('name' => 'getEmailAddressWidget', 'returns' => 'html'), 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'enabled'), 'email2' => array('name' => 'email2', 'vname' => 'LBL_OTHER_EMAIL_ADDRESS', 'type' => 'varchar', 'function' => array('name' => 'getEmailAddressWidget', 'returns' => 'html'), 'source' => 'non-db', 'group' => 'email2', 'merge_filter' => 'enabled'), 'email_addresses' => array('name' => 'email_addresses', 'type' => 'link', 'relationship' => 'service_email_addresses', 'module' => 'EmailAddress', 'bean_name' => 'EmailAddress', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESSES', 'reportable' => false, 'required' => true), 'email_addresses_primary' => array('name' => 'email_addresses_primary', 'type' => 'link', 'relationship' => 'service_email_addresses_primary', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESS_PRIMARY', 'duplicate_merge' => 'disabled', 'required' => true)), 'indices' => array(array('name' => 'idx_service_id_del', 'type' => 'index', 'fields' => array('id', 'deleted')), array('name' => 'autocode', 'type' => 'unique', 'fields' => array('autocode')), array('name' => 'code', 'type' => 'unique', 'fields' => array('code'))), 'relationship' => array('service_email_addresses' => array('lhs_module' => "Services", 'lhs_table' => 'services', 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'bean_module', 'relationship_role_column_value' => "Services"), 'service_email_addresses_primary' => array('lhs_module' => "Services", 'lhs_table' => 'services', 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'primary_address', 'relationship_role_column_value' => '1')), 'optimistic_lock' => true);
VardefManager::createVardef('Services', 'Services', array('default', 'assignable'));

 * 
 * You should have received a copy of the GNU General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
$dictionary['oqc_TextBlock'] = array('table' => 'oqc_textblock', 'audited' => true, 'fields' => array('is_default' => array('required' => false, 'name' => 'is_default', 'vname' => 'LBL_IS_DEFAULT', 'type' => 'bool', 'massupdate' => 0, 'comments' => 'Soll dieser Textbaustein für neue Verträge automatisch selektiert werden?', 'help' => 'Beim erstellen neuer Verträge können Textbausteine automatisch vorselektiert werden. Geben Sie hier bitte an ob dieser Textbaustein vorselektiert werden soll?', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 1, 'reportable' => 0), 'description' => array('required' => false, 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'massupdate' => 0, 'comments' => 'comment', 'help' => 'help', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 1, 'reportable' => 0, 'studio' => 'false'), 'oqc_textblockedit' => array('required' => false, 'name' => 'oqc_textblockedit', 'vname' => 'LBL_DESCRIPTION', 'type' => 'varchar', 'source' => 'non-db', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'function' => array('name' => 'getSingleTextblockHtml', 'returns' => 'html', 'include' => 'include/oqc/Textblocks/Textblocks.php'))), 'relationships' => array(), 'optimistic_lock' => true);
require_once 'include/SugarObjects/VardefManager.php';
VardefManager::createVardef('oqc_TextBlock', 'oqc_TextBlock', array('basic', 'issue'));
// additional issue fields beside *_number are not neccessary
unset($dictionary['oqc_TextBlock']['fields']['type']);
unset($dictionary['oqc_TextBlock']['fields']['status']);
unset($dictionary['oqc_TextBlock']['fields']['priority']);
unset($dictionary['oqc_TextBlock']['fields']['resolution']);
unset($dictionary['oqc_TextBlock']['fields']['work_log']);
// repair the name field
$dictionary['oqc_TextBlock']['fields']['name']['required'] = true;
$dictionary['oqc_TextBlock']['fields']['name']['comment'] = 'Short description';

 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 ********************************************************************************/
$dictionary['Project'] = array('table' => 'project', 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => false, 'comment' => 'Project', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_ID', 'required' => true, 'type' => 'id', 'reportable' => true, 'comment' => 'Unique identifier'), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'assigned_user_id' => array('name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'type' => 'assigned_user_name', 'vname' => 'LBL_ASSIGNED_USER_ID', 'required' => false, 'len' => 36, 'dbType' => 'id', 'table' => 'users', 'isnull' => false, 'reportable' => true, 'comment' => 'User assigned to this record'), 'modified_user_id' => array('name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record'), 'modified_by_name' => array('name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled'), 'created_by' => array('name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED_BY', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'comment' => 'User who created record'), 'created_by_name' => array('name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'required' => true, 'dbType' => 'varchar', 'type' => 'name', 'len' => 50, 'unified_search' => true, 'full_text_search' => array('boost' => 3), 'comment' => 'Project name', 'importable' => 'required', 'required' => true), 'description' => array('name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'required' => false, 'type' => 'text', 'comment' => 'Project description'), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => false, 'reportable' => false, 'default' => '0', 'comment' => 'Record deletion indicator'), 'estimated_start_date' => array('name' => 'estimated_start_date', 'vname' => 'LBL_DATE_START', 'required' => true, 'validation' => array('type' => 'isbefore', 'compareto' => 'estimated_end_date', 'blank' => true), 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'estimated_end_date' => array('name' => 'estimated_end_date', 'vname' => 'LBL_DATE_END', 'required' => true, 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'options' => 'project_status_dom'), 'priority' => array('name' => 'priority', 'vname' => 'LBL_PRIORITY', 'type' => 'enum', 'options' => 'projects_priority_options'), 'total_estimated_effort' => array('name' => 'total_estimated_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ESTIMATED_EFFORT'), 'total_actual_effort' => array('name' => 'total_actual_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ACTUAL_EFFORT'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'projects_accounts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_ACCOUNTS'), 'quotes' => array('name' => 'quotes', 'type' => 'link', 'relationship' => 'projects_quotes', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_QUOTES'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'projects_contacts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_CONTACTS'), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'projects_opportunities', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_OPPORTUNITIES'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'projects_notes', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'tasks' => array('name' => 'tasks', 'type' => 'link', 'relationship' => 'projects_tasks', 'source' => 'non-db', 'vname' => 'LBL_TASKS'), 'meetings' => array('name' => 'meetings', 'type' => 'link', 'relationship' => 'projects_meetings', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS'), 'calls' => array('name' => 'calls', 'type' => 'link', 'relationship' => 'projects_calls', 'source' => 'non-db', 'vname' => 'LBL_CALLS'), 'emails' => array('name' => 'emails', 'type' => 'link', 'relationship' => 'emails_projects_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS'), 'projecttask' => array('name' => 'projecttask', 'type' => 'link', 'relationship' => 'projects_project_tasks', 'source' => 'non-db', 'vname' => 'LBL_PROJECT_TASKS'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'projects_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'projects_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'projects_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_name' => array('name' => 'assigned_user_name', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_USER_NAME', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'dbType' => 'varchar', 'link' => 'users', 'len' => '255', 'source' => 'non-db'), 'cases' => array('name' => 'cases', 'type' => 'link', 'relationship' => 'projects_cases', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_CASES'), 'bugs' => array('name' => 'bugs', 'type' => 'link', 'relationship' => 'projects_bugs', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_BUGS'), 'products' => array('name' => 'products', 'type' => 'link', 'relationship' => 'projects_products', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_PRODUCTS'), 'project_users_1' => array('name' => 'project_users_1', 'type' => 'link', 'relationship' => 'project_users_1', 'source' => 'non-db', 'module' => 'Users', 'bean_name' => 'User', 'vname' => 'LBL_PROJECT_USERS_1_FROM_USERS_TITLE'), 'am_projecttemplates_project_1' => array('name' => 'am_projecttemplates_project_1', 'type' => 'link', 'relationship' => 'am_projecttemplates_project_1', 'source' => 'non-db', 'module' => 'AM_ProjectTemplates', 'bean_name' => 'AM_ProjectTemplates', 'vname' => 'LBL_AM_PROJECTTEMPLATES_PROJECT_1_FROM_AM_PROJECTTEMPLATES_TITLE', 'id_name' => 'am_projecttemplates_project_1am_projecttemplates_ida'), 'am_projecttemplates_project_1_name' => array('name' => 'am_projecttemplates_project_1_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_AM_PROJECTTEMPLATES_PROJECT_1_FROM_AM_PROJECTTEMPLATES_TITLE', 'save' => true, 'id_name' => 'am_projecttemplates_project_1am_projecttemplates_ida', 'link' => 'am_projecttemplates_project_1', 'table' => 'am_projecttemplates', 'module' => 'AM_ProjectTemplates', 'rname' => 'name'), 'am_projecttemplates_project_1am_projecttemplates_ida' => array('name' => 'am_projecttemplates_project_1am_projecttemplates_ida', 'type' => 'link', 'relationship' => 'am_projecttemplates_project_1', 'source' => 'non-db', 'reportable' => false, 'side' => 'right', 'vname' => 'LBL_AM_PROJECTTEMPLATES_PROJECT_1_FROM_PROJECT_TITLE'), 'project_contacts_1' => array('name' => 'project_contacts_1', 'type' => 'link', 'relationship' => 'project_contacts_1', 'source' => 'non-db', 'module' => 'Contacts', 'bean_name' => 'Contact', 'vname' => 'LBL_PROJECT_CONTACTS_1_FROM_CONTACTS_TITLE'), 'aos_quotes_project' => array('name' => 'aos_quotes_project', 'type' => 'link', 'relationship' => 'aos_quotes_project', 'source' => 'non-db')), 'indices' => array(array('name' => 'projects_primary_key_index', 'type' => 'primary', 'fields' => array('id'))), 'relationships' => array('projects_notes' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Tasks', 'rhs_table' => 'tasks', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_meetings' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Meetings', 'rhs_table' => 'meetings', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_calls' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_emails' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'Emails', 'rhs_table' => 'emails', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Project'), 'projects_project_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'ProjectTask', 'rhs_table' => 'project_task', 'rhs_key' => 'project_id', 'relationship_type' => 'one-to-many'), 'projects_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'projects_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'projects_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many')));
VardefManager::createVardef('Project', 'Project', array('security_groups'));

 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
$dictionary['opalo_cotizacion'] = array('table' => 'opalo_cotizacion', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('consecutivo' => array('required' => false, 'name' => 'consecutivo', 'vname' => 'LBL_CONSECUTIVO', 'type' => 'int', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'enable_range_search' => false, 'disable_num_format' => '1', 'min' => false, 'max' => false), 'total' => array('required' => false, 'name' => 'total', 'vname' => 'LBL_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'default' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 26, 'size' => '20', 'enable_range_search' => false, 'precision' => 6), 'currency_id' => array('required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'currency_id', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 36, 'size' => '20', 'dbType' => 'id', 'studio' => 'visible', 'function' => array('name' => 'getCurrencyDropDown', 'returns' => 'html')), 'subtotal' => array('required' => false, 'name' => 'subtotal', 'vname' => 'LBL_SUBTOTAL', 'type' => 'currency', 'massupdate' => 0, 'default' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 26, 'size' => '20', 'enable_range_search' => false, 'precision' => 6), 'impuestos' => array('required' => false, 'name' => 'impuestos', 'vname' => 'LBL_IMPUESTOS', 'type' => 'currency', 'massupdate' => 0, 'default' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 26, 'size' => '20', 'enable_range_search' => false, 'precision' => 6), 'proximo_seguimiento' => array('required' => true, 'name' => 'proximo_seguimiento', 'vname' => 'LBL_PROXIMO_SEGUIMIENTO', 'type' => 'date', 'massupdate' => '1', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'size' => '20', 'enable_range_search' => false, 'display_default' => '+1 week'), 'descuento' => array('required' => false, 'name' => 'descuento', 'vname' => 'LBL_DESCUENTO', 'type' => 'decimal', 'massupdate' => 0, 'default' => '0.00000', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '10', 'size' => '20', 'enable_range_search' => false, 'precision' => '5')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
    require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('opalo_cotizacion', 'opalo_cotizacion', array('basic', 'assignable'));

 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 *
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 *
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 ********************************************************************************/
$dictionary['InboundEmail'] = array('table' => 'inbound_email', 'comment' => 'Inbound email parameters', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'dbType' => 'varchar', 'len' => 36, 'required' => true, 'reportable' => false, 'comment' => 'Unique identifier'), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => false, 'default' => '0', 'reportable' => false, 'comment' => 'Record deltion indicator'), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, 'comment' => 'Date record created'), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, 'comment' => 'Date record last modified'), 'modified_user_id' => array('name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_BY', 'type' => 'modified_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record'), 'modified_user_id_link' => array('name' => 'modified_user_id_link', 'type' => 'link', 'relationship' => 'inbound_email_modified_user_id', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'created_by' => array('name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'comment' => 'User who created record'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'inbound_email_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'required' => false, 'reportable' => false, 'comment' => 'Name given to the inbound email mailbox'), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'varchar', 'len' => 100, 'default' => 'Active', 'required' => true, 'reportable' => false, 'comment' => 'Status of the inbound email mailbox (ex: Active or Inactive)'), 'server_url' => array('name' => 'server_url', 'vname' => 'LBL_SERVER_URL', 'type' => 'varchar', 'len' => '100', 'required' => true, 'reportable' => false, 'comment' => 'Mail server URL', 'importable' => 'required'), 'email_user' => array('name' => 'email_user', 'vname' => 'LBL_LOGIN', 'type' => 'varchar', 'len' => '100', 'required' => true, 'reportable' => false, 'comment' => 'User name allowed access to mail server'), 'email_password' => array('name' => 'email_password', 'vname' => 'LBL_PASSWORD', 'type' => 'varchar', 'len' => '100', 'required' => true, 'reportable' => false, 'comment' => 'Password of user identified by email_user'), 'port' => array('name' => 'port', 'vname' => 'LBL_SERVER_TYPE', 'type' => 'int', 'len' => '5', 'required' => true, 'reportable' => false, 'validation' => array('type' => 'range', 'min' => '110', 'max' => '65535'), 'comment' => 'Port used to access mail server'), 'service' => array('name' => 'service', 'vname' => 'LBL_SERVICE', 'type' => 'varchar', 'len' => '50', 'required' => true, 'reportable' => false, 'comment' => '', 'importable' => 'required'), 'mailbox' => array('name' => 'mailbox', 'vname' => 'LBL_MAILBOX', 'type' => 'text', 'required' => true, 'reportable' => false, 'comment' => ''), 'delete_seen' => array('name' => 'delete_seen', 'vname' => 'LBL_DELETE_SEEN', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'massupdate' => '', 'comment' => 'Delete email from server once read (seen)'), 'mailbox_type' => array('name' => 'mailbox_type', 'vname' => 'LBL_MAILBOX_TYPE', 'type' => 'varchar', 'len' => '10', 'reportable' => false, 'comment' => ''), 'template_id' => array('name' => 'template_id', 'vname' => 'LBL_AUTOREPLY', 'type' => 'id', 'len' => '36', 'reportable' => false, 'comment' => 'Template used for auto-reply'), 'stored_options' => array('name' => 'stored_options', 'vname' => 'LBL_STORED_OPTIONS', 'type' => 'text', 'reportable' => false, 'comment' => ''), 'group_id' => array('name' => 'group_id', 'vname' => 'LBL_GROUP_ID', 'type' => 'id', 'reportable' => false, 'comment' => 'Group ID (unused)'), 'is_personal' => array('name' => 'is_personal', 'vname' => 'LBL_IS_PERSONAL', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false, 'massupdate' => '', 'comment' => 'Personal account flag'), 'groupfolder_id' => array('name' => 'groupfolder_id', 'vname' => 'LBL_GROUPFOLDER_ID', 'type' => 'id', 'required' => false, 'reportable' => false, 'comment' => 'Unique identifier')), 'indices' => array(array('name' => 'inbound_emailpk', 'type' => 'primary', 'fields' => array('id'))), 'relationships' => array('inbound_email_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'InboundEmail', 'rhs_table' => 'inbound_email', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-one'), 'inbound_email_modified_user_id' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'InboundEmail', 'rhs_table' => 'inbound_email', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-one')));
VardefManager::createVardef('InboundEmail', 'InboundEmail', array());

<?php

/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/06_Customer_Center/10_Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */
$dictionary['EAPM'] = array('table' => 'eapm', 'audited' => false, 'fields' => array('password' => array('required' => true, 'name' => 'password', 'vname' => 'LBL_PASSWORD', 'type' => 'encrypt', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => false, 'len' => '255', 'size' => '20', 'write_only' => true), 'url' => array('required' => true, 'name' => 'url', 'vname' => 'LBL_URL', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'application' => array('required' => true, 'name' => 'application', 'vname' => 'LBL_APPLICATION', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'function' => 'getEAPMExternalApiDropDown', 'studio' => 'visible', 'default' => 'webex'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'full_text_search' => array('enabled' => true, 'boost' => 3), 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20'), 'api_data' => array('name' => 'api_data', 'vname' => 'LBL_API_DATA', 'type' => 'text', 'comment' => 'Any API data that the external API may wish to store on a per-user basis', 'rows' => 6, 'cols' => 80), 'consumer_key' => array('name' => 'consumer_key', 'type' => 'varchar', 'vname' => 'LBL_API_CONSKEY', 'importable' => 'required', 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'studio' => 'hidden'), 'consumer_secret' => array('name' => 'consumer_secret', 'type' => 'varchar', 'vname' => 'LBL_API_CONSSECRET', 'importable' => 'required', 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'studio' => 'hidden'), 'oauth_token' => array('name' => 'oauth_token', 'type' => 'varchar', 'vname' => 'LBL_API_OAUTHTOKEN', 'importable' => false, 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'required' => false, 'studio' => 'hidden'), 'oauth_secret' => array('name' => 'oauth_secret', 'type' => 'varchar', 'vname' => 'LBL_API_OAUTHSECRET', 'importable' => false, 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'required' => false, 'studio' => 'hidden'), 'validated' => array('required' => false, 'name' => 'validated', 'vname' => 'LBL_VALIDATED', 'type' => 'bool', 'default' => false), 'note' => array('name' => 'note', 'vname' => 'LBL_NOTE', 'required' => false, 'reportable' => false, 'importable' => false, 'massupdate' => false, 'studio' => 'hidden', 'type' => 'varchar', 'source' => 'non-db')), 'relationships' => array(), 'indices' => array(array('name' => 'idx_app_active', 'type' => 'index', 'fields' => array('assigned_user_id', 'application', 'validated')), array('name' => 'idx_eapm_name', 'type' => 'index', 'fields' => array('name'))), 'optimistic_locking' => true, 'visibility' => array('OwnerOrAdminVisibility' => true));
if (!class_exists('VardefManager')) {
    require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('EAPM', 'EAPM', array('basic', 'assignable'));