<?php $GLOBALS["dictionary"]["Note"]=array ( 'studio_enabled' => array ( 'portal' => false, ), 'audited' => true, 'favorites' => true, 'table' => 'notes', 'color' => 'green', 'icon' => 'sicon-note-lg', 'activity_enabled' => true, 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => true, 'comment' => 'Notes & Attachments', 'optimistic_locking' => true, 'duplicate_check' => array ( 'enabled' => false, ), 'fields' => array ( 'id' => array ( 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'duplicate_on_record_copy' => 'no', 'comment' => 'Unique identifier', 'mandatory_fetch' => true, ), 'name' => array ( 'name' => 'name', 'vname' => 'LBL_NOTE_SUBJECT', 'dbType' => 'varchar', 'type' => 'name', 'len' => '255', 'unified_search' => true, 'full_text_search' => array ( 'enabled' => true, 'searchable' => true, 'boost' => 0.83, ), 'comment' => 'Name of the note', 'importable' => 'required', 'required' => true, ), 'date_entered' => array ( 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'studio' => array ( 'portaleditview' => false, ), 'duplicate_on_record_copy' => 'no', 'readonly' => true, 'massupdate' => false, 'full_text_search' => array ( 'enabled' => true, 'searchable' => false, ), ), 'date_modified' => array ( 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'full_text_search' => array ( 'enabled' => true, 'searchable' => false, 'sortable' => true, ), 'studio' => array ( 'portaleditview' => false, ), 'options' => 'date_range_search_dom', 'duplicate_on_record_copy' => 'no', 'readonly' => true, 'massupdate' => false, ), 'modified_user_id' => array ( 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'duplicate_on_record_copy' => 'no', 'readonly' => true, 'full_text_search' => array ( 'enabled' => true, 'searchable' => false, 'type' => 'id', 'aggregations' => array ( 'modified_user_id' => array ( 'type' => 'MyItems', 'label' => 'LBL_AGG_MODIFIED_BY_ME', ), ), ), 'processes' => array ( 'types' => array ( 'RR' => false, 'ALL' => true, ), ), ), 'modified_by_name' => array ( 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'full_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'duplicate_on_record_copy' => 'no', 'readonly' => true, 'sort_on' => array ( 0 => 'last_name', ), 'exportable' => true, ), 'created_by' => array ( 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'duplicate_on_record_copy' => 'no', 'readonly' => true, 'full_text_search' => array ( 'enabled' => true, 'searchable' => false, 'type' => 'id', 'aggregations' => array ( 'created_by' => array ( 'type' => 'MyItems', 'label' => 'LBL_AGG_CREATED_BY_ME', ), ), ), 'processes' => array ( 'types' => array ( 'RR' => false, 'ALL' => true, ), ), ), 'created_by_name' => array ( 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'full_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'duplicate_on_record_copy' => 'no', 'readonly' => true, 'sort_on' => array ( 0 => 'last_name', ), 'exportable' => true, ), 'description' => array ( 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 30, 'cols' => 90, 'full_text_search' => array ( 'enabled' => true, 'searchable' => true, 'boost' => 0.44, ), ), 'deleted' => array ( 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'duplicate_on_record_copy' => 'no', 'comment' => 'Record deletion indicator', ), 'created_by_link' => array ( 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'notes_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'side' => 'right', ), 'modified_user_link' => array ( 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'notes_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'side' => 'right', ), 'activities' => array ( 'name' => 'activities', 'type' => 'link', 'relationship' => 'note_activities', 'vname' => 'LBL_ACTIVITY_STREAM', 'link_type' => 'many', 'module' => 'Activities', 'bean_name' => 'Activity', 'source' => 'non-db', ), 'file_mime_type' => array ( 'name' => 'file_mime_type', 'vname' => 'LBL_FILE_MIME_TYPE', 'type' => 'varchar', 'len' => '100', 'comment' => 'Attachment MIME type', 'importable' => false, 'duplicate_on_record_copy' => 'always', ), 'file_ext' => array ( 'name' => 'file_ext', 'vname' => 'LBL_FILE_EXTENSION', 'type' => 'varchar', 'len' => 100, 'duplicate_on_record_copy' => 'always', 'massupdate' => false, ), 'file_source' => array ( 'name' => 'file_source', 'vname' => 'LBL_FILE_SOURCE', 'type' => 'varchar', 'len' => '32', 'comment' => 'The name of the module where the attachment originated', 'importable' => false, 'duplicate_on_record_copy' => 'always', 'massupdate' => false, ), 'file_size' => array ( 'name' => 'file_size', 'vname' => 'LBL_FILE_SIZE', 'type' => 'int', 'comment' => 'Attachment File Size', 'importable' => false, 'default' => 0, 'duplicate_on_record_copy' => 'always', 'massupdate' => false, ), 'file_url' => array ( 'name' => 'file_url', 'vname' => 'LBL_FILE_URL', 'type' => 'varchar', 'source' => 'non-db', 'reportable' => false, 'comment' => 'Path to file (can be URL)', 'importable' => false, ), 'filename' => array ( 'name' => 'filename', 'vname' => 'LBL_FILENAME', 'type' => 'file', 'dbType' => 'varchar', 'len' => '255', 'reportable' => true, 'comment' => 'File name associated with the note (attachment)', 'importable' => false, 'duplicate_on_record_copy' => 'always', 'studio' => false, ), 'upload_id' => array ( 'name' => 'upload_id', 'type' => 'id', 'required' => false, 'reportable' => false, 'comment' => 'File id under uploads/ dir. Set only for email attachments', 'duplicate_on_record_copy' => 'always', ), 'email_type' => array ( 'comment' => 'The module of the record to which this note\'s file is attached (Emails or EmailTemplates)', 'name' => 'email_type', 'reportable' => false, 'required' => false, 'studio' => false, 'massupdate' => false, 'duplicate_on_record_copy' => 'always', 'type' => 'varchar', 'vname' => 'LBL_EMAIL_TYPE', ), 'email_id' => array ( 'comment' => 'Email or EmailTemplate ID to which this note is attached', 'name' => 'email_id', 'reportable' => false, 'required' => false, 'studio' => false, 'massupdate' => false, 'duplicate_on_record_copy' => 'always', 'type' => 'id', 'vname' => 'LBL_EMAIL_ID', ), 'note_parent_id' => array ( 'name' => 'note_parent_id', 'vname' => 'LBL_NOTE_PARENT_ID', 'type' => 'id', 'required' => false, 'reportable' => true, 'comment' => 'The parent Note ID', ), 'parent_type' => array ( 'name' => 'parent_type', 'vname' => 'LBL_PARENT_TYPE', 'type' => 'parent_type', 'dbType' => 'varchar', 'group' => 'parent_name', 'options' => 'parent_type_display', 'len' => '255', 'studio' => array ( 'wirelesslistview' => false, ), 'comment' => 'Sugar module the Note is associated with', ), 'parent_id' => array ( 'name' => 'parent_id', 'vname' => 'LBL_PARENT_ID', 'type' => 'id', 'required' => false, 'reportable' => true, 'comment' => 'The ID of the Sugar item specified in parent_type', ), 'contact_id' => array ( 'name' => 'contact_id', 'vname' => 'LBL_CONTACT_ID', 'type' => 'id', 'required' => false, 'reportable' => false, 'comment' => 'Contact ID note is associated with', ), 'portal_flag' => array ( 'name' => 'portal_flag', 'vname' => 'LBL_PORTAL_FLAG', 'type' => 'bool', 'default' => '1', 'comment' => 'Portal flag indicator determines if note created via portal', ), 'embed_flag' => array ( 'name' => 'embed_flag', 'vname' => 'LBL_EMBED_FLAG', 'type' => 'bool', 'default' => 0, 'comment' => 'Embed flag indicator determines if note embedded in email', ), 'parent_name' => array ( 'name' => 'parent_name', 'parent_type' => 'record_type_display', 'type_name' => 'parent_type', 'id_name' => 'parent_id', 'vname' => 'LBL_RELATED_TO', 'type' => 'parent', 'source' => 'non-db', 'options' => 'record_type_display_notes', 'studio' => true, ), 'contact_name' => array ( 'name' => 'contact_name', 'rname' => 'name', 'id_name' => 'contact_id', 'vname' => 'LBL_CONTACT_NAME', 'table' => 'contacts', 'type' => 'relate', 'link' => 'contact', 'join_name' => 'contacts', 'db_concat_fields' => array ( 0 => 'first_name', 1 => 'last_name', ), 'isnull' => 'true', 'module' => 'Contacts', 'source' => 'non-db', ), 'contact_phone' => array ( 'name' => 'contact_phone', 'vname' => 'LBL_PHONE', 'type' => 'relate', 'source' => 'non-db', 'link' => 'contact', 'module' => 'Contacts', 'table' => 'contacts', 'id_name' => 'contact_id', 'rname' => 'phone_work', ), 'contact_email' => array ( 'name' => 'contact_email', 'type' => 'varchar', 'vname' => 'LBL_EMAIL_ADDRESS', 'source' => 'non-db', 'studio' => false, ), 'account_id' => array ( 'name' => 'account_id', 'vname' => 'LBL_ACCOUNT_ID', 'type' => 'id', 'reportable' => false, 'source' => 'non-db', ), 'opportunity_id' => array ( 'name' => 'opportunity_id', 'vname' => 'LBL_OPPORTUNITY_ID', 'type' => 'id', 'reportable' => false, 'source' => 'non-db', ), 'acase_id' => array ( 'name' => 'acase_id', 'vname' => 'LBL_CASE_ID', 'type' => 'id', 'reportable' => false, 'source' => 'non-db', ), 'lead_id' => array ( 'name' => 'lead_id', 'vname' => 'LBL_LEAD_ID', 'type' => 'id', 'reportable' => false, 'source' => 'non-db', ), 'product_id' => array ( 'name' => 'product_id', 'vname' => 'LBL_PRODUCT_ID', 'type' => 'id', 'reportable' => false, 'source' => 'non-db', ), 'quote_id' => array ( 'name' => 'quote_id', 'vname' => 'LBL_QUOTE_ID', 'type' => 'id', 'reportable' => false, 'source' => 'non-db', ), 'contact' => array ( 'name' => 'contact', 'type' => 'link', 'relationship' => 'contact_notes', 'vname' => 'LBL_LIST_CONTACT_NAME', 'source' => 'non-db', ), 'cases' => array ( 'name' => 'cases', 'type' => 'link', 'relationship' => 'case_notes', 'vname' => 'LBL_CASES', 'source' => 'non-db', ), 'accounts' => array ( 'name' => 'accounts', 'type' => 'link', 'relationship' => 'account_notes', 'source' => 'non-db', 'vname' => 'LBL_ACCOUNTS', ), 'opportunities' => array ( 'name' => 'opportunities', 'type' => 'link', 'relationship' => 'opportunity_notes', 'source' => 'non-db', 'vname' => 'LBL_OPPORTUNITIES', ), 'leads' => array ( 'name' => 'leads', 'type' => 'link', 'relationship' => 'lead_notes', 'source' => 'non-db', 'vname' => 'LBL_LEADS', ), 'products' => array ( 'name' => 'products', 'type' => 'link', 'relationship' => 'product_notes', 'source' => 'non-db', 'vname' => 'LBL_PRODUCTS', ), 'revenuelineitems' => array ( 'name' => 'revenuelineitems', 'type' => 'link', 'relationship' => 'revenuelineitem_notes', 'source' => 'non-db', 'vname' => 'LBL_REVENUELINEITEMS', 'workflow' => true, ), 'quotes' => array ( 'name' => 'quotes', 'type' => 'link', 'relationship' => 'quote_notes', 'vname' => 'LBL_QUOTES', 'source' => 'non-db', ), 'contracts' => array ( 'name' => 'contracts', 'type' => 'link', 'relationship' => 'contract_notes', 'source' => 'non-db', 'vname' => 'LBL_CONTRACTS', ), 'prospects' => array ( 'name' => 'prospects', 'type' => 'link', 'relationship' => 'prospect_notes', 'source' => 'non-db', 'vname' => 'LBL_PROSPECTS', ), 'bugs' => array ( 'name' => 'bugs', 'type' => 'link', 'relationship' => 'bug_notes', 'source' => 'non-db', 'vname' => 'LBL_BUGS', ), 'kbcontents' => array ( 'name' => 'kbcontents', 'type' => 'link', 'relationship' => 'kbcontent_notes', 'source' => 'non-db', 'vname' => 'LBL_KBDOCUMENTS', ), 'emails' => array ( 'name' => 'emails', 'vname' => 'LBL_EMAILS', 'type' => 'link', 'relationship' => 'emails_notes_rel', 'source' => 'non-db', ), 'email_attachment_for' => array ( 'bean_name' => 'Email', 'module' => 'Emails', 'name' => 'email_attachment_for', 'relationship' => 'emails_attachments', 'source' => 'non-db', 'type' => 'link', 'vname' => 'LBL_EMAIL_ATTACHMENT_FOR', ), 'emailtemplates_attachment_for' => array ( 'bean_name' => 'EmailTemplate', 'module' => 'EmailTemplates', 'name' => 'emailtemplates_attachment_for', 'relationship' => 'emailtemplates_attachments', 'source' => 'non-db', 'type' => 'link', 'vname' => 'LBL_EMAILTEMPLATES_ATTACHMENT_FOR', ), 'projects' => array ( 'name' => 'projects', 'type' => 'link', 'relationship' => 'projects_notes', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS', ), 'project_tasks' => array ( 'name' => 'project_tasks', 'type' => 'link', 'relationship' => 'project_tasks_notes', 'source' => 'non-db', 'vname' => 'LBL_PROJECT_TASKS', ), 'meetings' => array ( 'name' => 'meetings', 'type' => 'link', 'relationship' => 'meetings_notes', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS', ), 'calls' => array ( 'name' => 'calls', 'type' => 'link', 'relationship' => 'calls_notes', 'source' => 'non-db', 'vname' => 'LBL_CALLS', ), 'tasks' => array ( 'name' => 'tasks', 'type' => 'link', 'relationship' => 'tasks_notes', 'source' => 'non-db', 'vname' => 'LBL_TASKS', ), 'escalations' => array ( 'name' => 'escalations', 'type' => 'link', 'relationship' => 'escalation_notes', 'source' => 'non-db', 'vname' => 'LBL_ESCALATIONS', ), 'external_user' => array ( 'name' => 'external_user', 'type' => 'link', 'relationship' => 'external_user_notes', 'vname' => 'LBL_EXTERNAL_USER', 'source' => 'non-db', ), 'user_name' => array ( 'name' => 'user_name', 'rname' => 'name', 'id_name' => 'external_id', 'vname' => 'LBL_EXTERNAL_USER_NAME', 'table' => 'external_users', 'type' => 'relate', 'link' => 'external_user', 'join_name' => 'external_users', 'isnull' => 'true', 'module' => 'ExternalUsers', 'source' => 'non-db', 'readonly' => true, ), 'external_id' => array ( 'name' => 'external_id', 'type' => 'id', 'vname' => 'LBL_EXTERNAL_ID', 'comment' => 'External id of the external user', ), 'schedulersjobs' => array ( 'name' => 'schedulersjobs', 'type' => 'link', 'relationship' => 'schedulersjob_notes', 'source' => 'non-db', 'vname' => 'LBL_SCHEDULERS_JOBS', ), 'contact_parent' => array ( 'name' => 'contact_parent', 'type' => 'link', 'relationship' => 'contact_notes_parent', 'source' => 'non-db', 'reportable' => false, ), 'entry_source' => array ( 'name' => 'entry_source', 'vname' => 'LBL_ENTRY_SOURCE', 'type' => 'enum', 'function' => 'getSourceTypes', 'function_bean' => 'Notes', 'len' => '255', 'default' => 'internal', 'comment' => 'Determines if a record was created internal to the system or external to the system', 'readonly' => true, 'studio' => false, 'processes' => true, ), 'attachment_flag' => array ( 'name' => 'attachment_flag', 'vname' => 'LBL_ATTACHMENT_FLAG', 'type' => 'bool', 'comment' => 'Identify this note as an attachment to another record', 'default' => false, 'readonly' => true, 'processes' => true, 'studio' => false, ), 'attachment_list' => array ( 'name' => 'attachment_list', 'links' => array ( 0 => 'attachments', ), 'order_by' => 'name:asc', 'source' => 'non-db', 'type' => 'collection', 'vname' => 'LBL_ATTACHMENTS', 'reportable' => false, 'hideacl' => true, 'displayParams' => array ( 'type' => 'multi-attachments', 'fields' => array ( 0 => 'name', 1 => 'filename', 2 => 'file_mime_type', ), 'related_fields' => array ( 0 => 'filename', 1 => 'file_mime_type', ), 'link' => 'attachments', 'module' => 'Notes', 'modulefield' => 'filename', ), ), 'attachments' => array ( 'name' => 'attachments', 'vname' => 'LBL_ATTACHMENTS', 'type' => 'link', 'relationship' => 'notes_attachments', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', ), 'note_attachment' => array ( 'name' => 'note_attachment', 'type' => 'link', 'relationship' => 'notes_attachments', 'link_type' => 'one', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_NOTE_ATTACHMENT', ), 'kb_attachment' => array ( 'name' => 'kb_attachment', 'type' => 'link', 'relationship' => 'kbcontent_attachments', 'link_type' => 'one', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_KB_ATTACHMENT', ), 'case_attachment' => array ( 'name' => 'case_attachment', 'type' => 'link', 'relationship' => 'case_attachments', 'link_type' => 'one', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_CASE_ATTACHMENT', ), 'following' => array ( 'massupdate' => false, 'name' => 'following', 'vname' => 'LBL_FOLLOWING', 'type' => 'bool', 'source' => 'non-db', 'comment' => 'Is user following this record', 'studio' => 'false', 'link' => 'following_link', 'rname' => 'id', 'rname_exists' => true, ), 'following_link' => array ( 'name' => 'following_link', 'type' => 'link', 'relationship' => 'notes_following', 'source' => 'non-db', 'vname' => 'LBL_FOLLOWING', 'reportable' => false, ), 'my_favorite' => array ( 'massupdate' => false, 'name' => 'my_favorite', 'vname' => 'LBL_FAVORITE', 'type' => 'bool', 'source' => 'non-db', 'comment' => 'Favorite for the user', 'studio' => array ( 'list' => false, 'recordview' => false, 'basic_search' => false, 'advanced_search' => false, ), 'link' => 'favorite_link', 'rname' => 'id', 'rname_exists' => true, ), 'favorite_link' => array ( 'name' => 'favorite_link', 'type' => 'link', 'relationship' => 'notes_favorite', 'source' => 'non-db', 'vname' => 'LBL_FAVORITE', 'reportable' => false, 'workflow' => false, 'full_text_search' => array ( 'type' => 'favorites', 'enabled' => true, 'searchable' => false, 'aggregations' => array ( 'favorite_link' => array ( 'type' => 'MyItems', 'options' => array ( 'field' => 'user_favorites', ), ), ), ), ), 'tag' => array ( 'name' => 'tag', 'vname' => 'LBL_TAGS', 'type' => 'tag', 'link' => 'tag_link', 'source' => 'non-db', 'module' => 'Tags', 'relate_collection' => true, 'studio' => array ( 'portal' => false, 'base' => array ( 'popuplist' => false, 'popupsearch' => false, ), 'mobile' => array ( 'wirelesseditview' => true, 'wirelessdetailview' => true, ), ), 'massupdate' => true, 'exportable' => true, 'sortable' => false, 'rname' => 'name', 'full_text_search' => array ( 'enabled' => true, 'searchable' => false, ), ), 'tag_link' => array ( 'name' => 'tag_link', 'type' => 'link', 'vname' => 'LBL_TAGS_LINK', 'relationship' => 'notes_tags', 'source' => 'non-db', 'exportable' => false, 'duplicate_merge' => 'disabled', ), 'commentlog' => array ( 'name' => 'commentlog', 'vname' => 'LBL_COMMENTLOG', 'type' => 'collection', 'displayParams' => array ( 'type' => 'commentlog', 'fields' => array ( 0 => 'entry', 1 => 'date_entered', 2 => 'created_by_name', ), 'max_num' => 100, ), 'links' => array ( 0 => 'commentlog_link', ), 'order_by' => 'date_entered:asc', 'source' => 'non-db', 'module' => 'CommentLog', 'studio' => array ( 'listview' => false, 'recordview' => true, 'previewview' => true, 'wirelesseditview' => false, 'wirelessdetailview' => true, 'wirelesslistview' => false, 'wireless_basic_search' => false, 'wireless_advanced_search' => false, ), 'full_text_search' => array ( 'enabled' => true, 'searchable' => true, ), ), 'commentlog_link' => array ( 'name' => 'commentlog_link', 'type' => 'link', 'vname' => 'LBL_COMMENTLOG_LINK', 'relationship' => 'notes_commentlog', 'source' => 'non-db', 'exportable' => false, 'duplicate_merge' => 'disabled', ), 'locked_fields' => array ( 'name' => 'locked_fields', 'vname' => 'LBL_LOCKED_FIELDS', 'type' => 'locked_fields', 'link' => 'locked_fields_link', 'source' => 'non-db', 'module' => 'pmse_BpmProcessDefinition', 'relate_collection' => true, 'studio' => false, 'massupdate' => false, 'exportable' => false, 'sortable' => false, 'rname' => 'pro_locked_variables', 'collection_fields' => array ( 0 => 'pro_locked_variables', ), 'full_text_search' => array ( 'enabled' => false, 'searchable' => false, ), 'hideacl' => true, ), 'locked_fields_link' => array ( 'name' => 'locked_fields_link', 'type' => 'link', 'vname' => 'LBL_LOCKED_FIELDS_LINK', 'relationship' => 'notes_locked_fields', 'source' => 'non-db', 'exportable' => false, 'duplicate_merge' => 'disabled', ), 'sync_key' => array ( 'is_sync_key' => true, 'name' => 'sync_key', 'vname' => 'LBL_SYNC_KEY', 'type' => 'varchar', 'enforced' => '', 'required' => false, 'massupdate' => false, 'readonly' => true, 'default' => NULL, 'isnull' => true, 'no_default' => false, 'comments' => 'External default id of the remote integration record', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'merge_filter' => 'disabled', 'duplicate_on_record_copy' => 'no', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'calculated' => false, 'len' => '100', 'size' => '20', 'studio' => array ( 'recordview' => true, 'wirelessdetailview' => true, 'listview' => false, 'wirelesseditview' => false, 'wirelesslistview' => false, 'wireless_basic_search' => false, 'wireless_advanced_search' => false, 'portallistview' => false, 'portalrecordview' => false, 'portaleditview' => false, ), ), 'assigned_user_id' => array ( 'name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'id', 'reportable' => false, 'isnull' => 'false', 'audited' => true, 'duplicate_on_record_copy' => 'always', 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'mandatory_fetch' => true, 'massupdate' => false, 'full_text_search' => array ( 'enabled' => true, 'searchable' => false, 'aggregations' => array ( 'assigned_user_id' => array ( 'type' => 'MyItems', 'label' => 'LBL_AGG_ASSIGNED_TO_ME', ), ), ), ), 'assigned_user_name' => array ( 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'duplicate_on_record_copy' => 'always', 'sort_on' => array ( 0 => 'last_name', ), 'exportable' => true, 'related_fields' => array ( 0 => 'assigned_user_id', ), ), 'assigned_user_link' => array ( 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'notes_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'duplicate_merge' => 'enabled', 'id_name' => 'assigned_user_id', 'table' => 'users', 'side' => 'right', ), 'team_id' => array ( 'name' => 'team_id', 'vname' => 'LBL_TEAM_ID', 'group' => 'team_name', 'reportable' => false, 'dbType' => 'id', 'type' => 'team_list', 'audited' => true, 'duplicate_on_record_copy' => 'always', 'comment' => 'Team ID for the account', ), 'team_set_id' => array ( 'name' => 'team_set_id', 'rname' => 'id', 'id_name' => 'team_set_id', 'vname' => 'LBL_TEAM_SET_ID', 'type' => 'id', 'audited' => true, 'studio' => 'false', 'dbType' => 'id', 'duplicate_on_record_copy' => 'always', ), 'acl_team_set_id' => array ( 'name' => 'acl_team_set_id', 'vname' => 'LBL_TEAM_SET_SELECTED_ID', 'type' => 'id', 'audited' => true, 'studio' => false, 'isnull' => true, 'duplicate_on_record_copy' => 'always', 'reportable' => false, ), 'team_count' => array ( 'name' => 'team_count', 'rname' => 'team_count', 'id_name' => 'team_id', 'vname' => 'LBL_TEAMS', 'join_name' => 'ts1', 'table' => 'teams', 'type' => 'relate', 'required' => 'true', 'isnull' => 'true', 'module' => 'Teams', 'link' => 'team_count_link', 'massupdate' => false, 'dbType' => 'int', 'source' => 'non-db', 'importable' => 'false', 'reportable' => false, 'duplicate_merge' => 'disabled', 'duplicate_on_record_copy' => 'always', 'studio' => 'false', 'hideacl' => true, ), 'team_name' => array ( 'name' => 'team_name', 'db_concat_fields' => array ( 0 => 'name', 1 => 'name_2', ), 'sort_on' => 'tj.name', 'join_name' => 'tj', 'rname' => 'name', 'id_name' => 'team_id', 'vname' => 'LBL_TEAMS', 'type' => 'relate', 'required' => 'true', 'table' => 'teams', 'isnull' => 'true', 'module' => 'Teams', 'link' => 'team_link', 'massupdate' => true, 'dbType' => 'varchar', 'source' => 'non-db', 'custom_type' => 'teamset', 'studio' => array ( 'portallistview' => false, 'portalrecordview' => false, ), 'duplicate_on_record_copy' => 'always', 'exportable' => true, 'fields' => array ( 0 => 'acl_team_set_id', ), ), 'acl_team_names' => array ( 'name' => 'acl_team_names', 'table' => 'teams', 'module' => 'Teams', 'vname' => 'LBL_TEAM_SET_SELECTED_TEAMS', 'rname' => 'name', 'id_name' => 'acl_team_set_id', 'source' => 'non-db', 'link' => 'team_link', 'type' => 'relate', 'custom_type' => 'teamset', 'exportable' => true, 'studio' => false, 'massupdate' => false, 'hideacl' => true, ), 'team_link' => array ( 'name' => 'team_link', 'type' => 'link', 'relationship' => 'notes_team', 'vname' => 'LBL_TEAMS_LINK', 'link_type' => 'one', 'module' => 'Teams', 'bean_name' => 'Team', 'source' => 'non-db', 'duplicate_merge' => 'disabled', 'studio' => 'false', 'side' => 'right', ), 'team_count_link' => array ( 'name' => 'team_count_link', 'type' => 'link', 'relationship' => 'notes_team_count_relationship', 'link_type' => 'one', 'module' => 'Teams', 'bean_name' => 'TeamSet', 'source' => 'non-db', 'duplicate_merge' => 'disabled', 'reportable' => false, 'studio' => 'false', 'side' => 'right', ), 'teams' => array ( 'name' => 'teams', 'type' => 'link', 'relationship' => 'notes_teams', 'bean_filter_field' => 'team_set_id', 'rhs_key_override' => true, 'source' => 'non-db', 'vname' => 'LBL_TEAMS', 'link_class' => 'TeamSetLink', 'studio' => 'false', 'reportable' => false, 'side' => 'left', ), 'source_id' => array ( 'name' => 'source_id', 'vname' => 'LBL_SOURCE_ID', 'type' => 'varchar', 'comment' => '', ), 'source_type' => array ( 'name' => 'source_type', 'vname' => 'LBL_SOURCE_TYPE', 'type' => 'varchar', 'comment' => '', ), 'source_meta' => array ( 'name' => 'source_meta', 'vname' => 'LBL_SOURCE_META', 'type' => 'text', 'comment' => '', ), ), 'relationships' => array ( 'notes_modified_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many', ), 'notes_created_by' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many', ), 'note_activities' => array ( 'lhs_module' => 'Notes', 'lhs_table' => 'notes', 'lhs_key' => 'id', 'rhs_module' => 'Activities', 'rhs_table' => 'activities', 'rhs_key' => 'id', 'rhs_vname' => 'LBL_ACTIVITY_STREAM', 'relationship_type' => 'many-to-many', 'join_table' => 'activities_users', 'join_key_lhs' => 'parent_id', 'join_key_rhs' => 'activity_id', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Notes', ), 'notes_attachments' => array ( 'lhs_module' => 'Notes', 'lhs_table' => 'notes', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'note_parent_id', 'relationship_type' => 'one-to-many', 'relationship_class' => 'AttachmentRelationship', 'relationship_file' => 'data/Relationships/AttachmentRelationship.php', ), 'notes_following' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'id', 'relationship_type' => 'user-based', 'join_table' => 'subscriptions', 'join_key_lhs' => 'created_by', 'join_key_rhs' => 'parent_id', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Notes', 'user_field' => 'created_by', ), 'notes_favorite' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'id', 'relationship_type' => 'user-based', 'join_table' => 'sugarfavorites', 'join_key_lhs' => 'modified_user_id', 'join_key_rhs' => 'record_id', 'relationship_role_column' => 'module', 'relationship_role_column_value' => 'Notes', 'user_field' => 'created_by', ), 'notes_tags' => array ( 'lhs_module' => 'Notes', 'lhs_table' => 'notes', 'lhs_key' => 'id', 'rhs_module' => 'Tags', 'rhs_table' => 'tags', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'tag_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'tag_id', 'relationship_role_column' => 'bean_module', 'relationship_role_column_value' => 'Notes', 'dynamic_subpanel' => true, ), 'notes_commentlog' => array ( 'lhs_module' => 'Notes', 'lhs_table' => 'notes', 'lhs_key' => 'id', 'rhs_module' => 'CommentLog', 'rhs_table' => 'commentlog', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'commentlog_rel', 'join_key_lhs' => 'record_id', 'join_key_rhs' => 'commentlog_id', 'relationship_role_column' => 'module', 'relationship_role_column_value' => 'Notes', ), 'notes_locked_fields' => array ( 'lhs_module' => 'Notes', 'lhs_table' => 'notes', 'lhs_key' => 'id', 'rhs_module' => 'pmse_BpmProcessDefinition', 'rhs_table' => 'pmse_bpm_process_definition', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'locked_field_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'pd_id', 'relationship_role_column' => 'bean_module', 'relationship_role_column_value' => 'Notes', ), 'notes_audit' => array ( 'lhs_module' => 'Notes', 'lhs_table' => 'notes', 'lhs_key' => 'id', 'rhs_module' => 'Audit', 'rhs_table' => 'notes_audit', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', ), 'notes_assigned_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many', ), 'notes_team_count_relationship' => array ( 'lhs_module' => 'Teams', 'lhs_table' => 'team_sets', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'team_set_id', 'relationship_type' => 'one-to-many', ), 'notes_teams' => array ( 'lhs_module' => 'Notes', 'lhs_table' => 'notes', 'lhs_key' => 'team_set_id', 'rhs_module' => 'Teams', 'rhs_table' => 'teams', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'team_sets_teams', 'join_key_lhs' => 'team_set_id', 'join_key_rhs' => 'team_id', ), 'notes_team' => array ( 'lhs_module' => 'Teams', 'lhs_table' => 'teams', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'team_id', 'relationship_type' => 'one-to-many', ), ), 'indices' => array ( 'id' => array ( 'name' => 'idx_notes_pk', 'type' => 'primary', 'fields' => array ( 0 => 'id', ), ), 'date_modified' => array ( 'name' => 'idx_notes_del_d_m', 'type' => 'index', 'fields' => array ( 0 => 'deleted', 1 => 'date_modified', 2 => 'id', ), ), 'deleted' => array ( 'name' => 'idx_notes_id_del', 'type' => 'index', 'fields' => array ( 0 => 'id', 1 => 'deleted', ), ), 'date_entered' => array ( 'name' => 'idx_notes_del_d_e', 'type' => 'index', 'fields' => array ( 0 => 'deleted', 1 => 'date_entered', 2 => 'id', ), ), 'name_del' => array ( 'name' => 'idx_notes_name_del', 'type' => 'index', 'fields' => array ( 0 => 'name', 1 => 'deleted', ), ), 0 => array ( 'name' => 'idx_note_name', 'type' => 'index', 'fields' => array ( 0 => 'deleted', 1 => 'name', 2 => 'date_modified', ), ), 1 => array ( 'name' => 'idx_note_parent_id', 'type' => 'index', 'fields' => array ( 0 => 'note_parent_id', ), ), 2 => array ( 'name' => 'idx_notes_parent', 'type' => 'index', 'fields' => array ( 0 => 'parent_id', 1 => 'parent_type', ), ), 3 => array ( 'name' => 'idx_note_contact', 'type' => 'index', 'fields' => array ( 0 => 'contact_id', ), ), 4 => array ( 'name' => 'idx_note_email_type', 'type' => 'index', 'fields' => array ( 0 => 'email_type', ), ), 5 => array ( 'name' => 'idx_note_email', 'type' => 'index', 'fields' => array ( 0 => 'email_id', 1 => 'email_type', ), ), 6 => array ( 'name' => 'idx_note_upload_id', 'type' => 'index', 'fields' => array ( 0 => 'upload_id', ), ), 7 => array ( 'name' => 'idx_note_external_user', 'type' => 'index', 'fields' => array ( 0 => 'external_id', ), ), 'sync_key' => array ( 'name' => 'idx_notes_skey', 'type' => 'unique', 'fields' => array ( 0 => 'sync_key', ), ), 'assigned_user_id' => array ( 'name' => 'idx_notes_assigned_del', 'type' => 'index', 'fields' => array ( 0 => 'assigned_user_id', 1 => 'deleted', ), ), 'team_set_notes' => array ( 'name' => 'idx_notes_tmst_id', 'type' => 'index', 'fields' => array ( 0 => 'team_set_id', 1 => 'deleted', ), ), 'acl_team_set_notes' => array ( 'name' => 'idx_notes_acl_tmst_id', 'type' => 'index', 'fields' => array ( 0 => 'acl_team_set_id', 1 => 'deleted', ), ), ), 'portal_visibility' => array ( 'class' => 'Notes', ), 'name_format_map' => array ( ), 'visibility' => array ( 'TeamSecurity' => true, ), 'acls' => array ( 'SugarACLLockedFields' => true, 'SugarACLStatic' => true, ), 'templates' => array ( 'basic' => 'basic', 'following' => 'following', 'favorite' => 'favorite', 'taggable' => 'taggable', 'commentlog' => 'commentlog', 'lockable_fields' => 'lockable_fields', 'integrate_fields' => 'integrate_fields', 'audit' => 'audit', 'assignable' => 'assignable', 'team_security' => 'team_security', 'external_source' => 'external_source', ), 'custom_fields' => false, 'has_pii_fields' => false, 'related_calc_fields' => array ( 0 => 'email_attachment_for', ), );