<?php $GLOBALS["dictionary"]["SF_Subscriptions"]=array ( 'table' => 'sf_subscriptions', 'audited' => true, 'activity_enabled' => false, 'duplicate_merge' => true, '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_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => array ( 'enabled' => true, 'searchable' => true, 'boost' => 1.55, ), 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', 'duplicate_on_record_copy' => 'always', ), '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', 'full_text_search' => array ( 'enabled' => true, 'searchable' => true, 'boost' => 0.5, ), 'rows' => 6, 'cols' => 80, 'duplicate_on_record_copy' => 'always', ), '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' => 'sf_subscriptions_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' => 'sf_subscriptions_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' => 'sf_subscriptions_activities', 'vname' => 'LBL_ACTIVITY_STREAM', 'link_type' => 'many', 'module' => 'Activities', 'bean_name' => 'Activity', 'source' => 'non-db', ), 'title' => array ( 'required' => false, 'readonly' => false, 'name' => 'title', 'vname' => 'LBL_TITLE', 'type' => 'varchar', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => '', 'full_text_search' => array ( 'enabled' => '0', 'boost' => '1', 'searchable' => false, ), 'calculated' => false, 'len' => '255', 'size' => '20', ), 'auto_renew' => array ( 'required' => false, 'readonly' => false, 'name' => 'auto_renew', 'vname' => 'LBL_AUTO_RENEW', 'type' => 'bool', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => false, 'calculated' => false, 'size' => '20', ), 'term_start_date' => array ( 'required' => false, 'readonly' => false, 'name' => 'term_start_date', 'vname' => 'LBL_TERM_START_DATE', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'trigger_date' => array ( 'required' => false, 'readonly' => false, 'name' => 'trigger_date', 'vname' => 'LBL_TRIGGER_DATE', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'separate_invoice' => array ( 'required' => false, 'readonly' => false, 'name' => 'separate_invoice', 'vname' => 'LBL_SEPARATE_INVOICE', 'type' => 'bool', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => false, 'calculated' => false, 'size' => '20', ), 'payment_status' => array ( 'required' => false, 'readonly' => false, 'name' => 'payment_status', 'vname' => 'LBL_PAYMENT_STATUS', 'type' => 'enum', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'len' => 100, 'size' => '20', 'options' => 'sf_payment_status_list', 'default' => '', 'dependency' => false, 'visibility_grid' => array ( ), ), 'status' => array ( 'required' => false, 'readonly' => false, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'len' => 100, 'size' => '20', 'options' => 'sf_status_list', 'default' => '', 'dependency' => false, 'visibility_grid' => array ( ), ), 'order_date' => array ( 'required' => false, 'readonly' => false, 'name' => 'order_date', 'vname' => 'LBL_ORDER_DATE', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'subscription_type' => array ( 'required' => false, 'readonly' => false, 'name' => 'subscription_type', 'vname' => 'LBL_SUBSCRIPTION_TYPE', 'type' => 'enum', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'len' => 100, 'size' => '20', 'options' => 'sf_type_list', 'default' => '', 'dependency' => false, 'visibility_grid' => array ( ), ), 'sf_subscription_id' => array ( 'required' => false, 'readonly' => false, 'name' => 'sf_subscription_id', 'vname' => 'LBL_SF_SUBSCRIPTION_ID', 'type' => 'varchar', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => '', 'full_text_search' => array ( 'enabled' => '0', 'boost' => '1', 'searchable' => false, ), 'calculated' => false, 'len' => '255', 'size' => '20', ), 'term_initial_period' => array ( 'required' => false, 'readonly' => false, 'name' => 'term_initial_period', 'vname' => 'LBL_TERM_INITIAL_PERIOD', 'type' => 'int', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => '', 'full_text_search' => array ( 'enabled' => '0', 'boost' => '1', 'searchable' => false, ), 'calculated' => false, 'len' => '11', 'size' => '20', 'enable_range_search' => false, 'disable_num_format' => '', 'min' => false, 'max' => false, ), 'term_initial_period_type' => array ( 'required' => false, 'readonly' => false, 'name' => 'term_initial_period_type', 'vname' => 'LBL_TERM_INITIAL_PERIOD_TYPE', 'type' => 'enum', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'len' => 100, 'size' => '20', 'options' => 'sf_term_initial_period_type_list', 'default' => '', 'dependency' => false, 'visibility_grid' => array ( ), ), 'renewal_is_different' => array ( 'required' => false, 'readonly' => false, 'name' => 'renewal_is_different', 'vname' => 'LBL_RENEWAL_IS_DIFFERENT', 'type' => 'bool', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => false, 'calculated' => false, 'size' => '20', ), 'enable_trial' => array ( 'required' => false, 'readonly' => false, 'name' => 'enable_trial', 'vname' => 'LBL_ENABLE_TRIAL', 'type' => 'bool', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => false, 'calculated' => false, 'size' => '20', ), 'trial_period' => array ( 'required' => false, 'readonly' => false, 'name' => 'trial_period', 'vname' => 'LBL_TRIAL_PERIOD', 'type' => 'int', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => '', 'full_text_search' => array ( 'enabled' => '0', 'boost' => '1', 'searchable' => false, ), 'calculated' => false, 'len' => '11', 'size' => '20', 'enable_range_search' => false, 'disable_num_format' => '', 'min' => false, 'max' => false, ), 'trial_period_unit' => array ( 'required' => false, 'readonly' => false, 'name' => 'trial_period_unit', 'vname' => 'LBL_TRIAL_PERIOD_UNIT', 'type' => 'enum', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'len' => 100, 'size' => '20', 'options' => 'sf_trial_period_unit_list', 'default' => '', 'dependency' => false, 'visibility_grid' => array ( ), ), 'next_bill_date' => array ( 'required' => false, 'readonly' => false, 'name' => 'next_bill_date', 'vname' => 'LBL_NEXT_BILL_DATE', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'billing_end_date' => array ( 'required' => false, 'readonly' => false, 'name' => 'billing_end_date', 'vname' => 'LBL_BILLING_END_DATE', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'suspended_at' => array ( 'required' => false, 'readonly' => false, 'name' => 'suspended_at', 'vname' => 'LBL_SUSPENDED_AT', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'cancelled_at' => array ( 'required' => false, 'readonly' => false, 'name' => 'cancelled_at', 'vname' => 'LBL_CANCELLED_AT', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'resume_suspended_at' => array ( 'required' => false, 'readonly' => false, 'name' => 'resume_suspended_at', 'vname' => 'LBL_RESUME_SUSPENDED_AT', 'type' => 'date', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'size' => '20', 'enable_range_search' => false, ), 'extend_term_on_resume' => array ( 'required' => false, 'readonly' => false, 'name' => 'extend_term_on_resume', 'vname' => 'LBL_EXTEND_TERM_ON_RESUME', 'type' => 'bool', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => false, 'calculated' => false, 'size' => '20', ), 'enable_gift' => array ( 'required' => false, 'readonly' => false, 'name' => 'enable_gift', 'vname' => 'LBL_ENABLE_GIFT', 'type' => 'bool', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'default' => false, 'calculated' => false, 'size' => '20', ), 'contact_id_c' => array ( 'required' => false, 'readonly' => false, 'name' => 'contact_id_c', 'vname' => 'LBL_GIFT_RECIPIENT_CONTACT_ID', 'type' => 'id', 'massupdate' => false, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => 1, 'audited' => false, 'reportable' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'len' => 36, 'size' => '20', ), 'gift_recipient' => array ( 'required' => false, 'readonly' => false, 'source' => 'non-db', 'name' => 'gift_recipient', 'vname' => 'LBL_GIFT_RECIPIENT', 'type' => 'relate', 'massupdate' => true, 'hidemassupdate' => false, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'enabled', 'duplicate_merge_dom_value' => '1', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'pii' => false, 'calculated' => false, 'len' => 255, 'size' => '20', 'id_name' => 'contact_id_c', 'ext2' => 'Contacts', 'module' => 'Contacts', 'rname' => 'name', 'quicksearch' => 'enabled', 'studio' => 'visible', ), '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' => 'sf_subscriptions_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' => 'sf_subscriptions_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' => 'sf_subscriptions_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, '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' => 'sf_subscriptions_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' => 'sf_subscriptions_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, ), ), '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' => 'sf_subscriptions_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' => 'sf_subscriptions_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' => 'sf_subscriptions_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', ), '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' => 'sf_subscriptions_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', ), 'sf_invoices_sf_subscriptions' => array ( 'name' => 'sf_invoices_sf_subscriptions', 'type' => 'link', 'relationship' => 'sf_invoices_sf_subscriptions', 'source' => 'non-db', 'module' => 'SF_Invoices', 'bean_name' => 'SF_Invoices', 'vname' => 'LBL_SF_INVOICES_SF_SUBSCRIPTIONS_FROM_SF_SUBSCRIPTIONS_TITLE', 'id_name' => 'sf_invoices_sf_subscriptionssf_subscriptions_ida', 'link-type' => 'many', 'side' => 'left', ), 'sf_subscriptions_opportunities' => array ( 'name' => 'sf_subscriptions_opportunities', 'type' => 'link', 'relationship' => 'sf_subscriptions_opportunities', 'source' => 'non-db', 'module' => 'Opportunities', 'bean_name' => 'Opportunity', 'side' => 'right', 'vname' => 'LBL_SF_SUBSCRIPTIONS_OPPORTUNITIES_FROM_SF_SUBSCRIPTIONS_TITLE', 'id_name' => 'sf_subscriptions_opportunitiesopportunities_ida', 'link-type' => 'one', ), 'sf_subscriptions_opportunities_name' => array ( 'name' => 'sf_subscriptions_opportunities_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_SF_SUBSCRIPTIONS_OPPORTUNITIES_FROM_OPPORTUNITIES_TITLE', 'save' => true, 'id_name' => 'sf_subscriptions_opportunitiesopportunities_ida', 'link' => 'sf_subscriptions_opportunities', 'table' => 'opportunities', 'module' => 'Opportunities', 'rname' => 'name', ), 'sf_subscriptions_opportunitiesopportunities_ida' => array ( 'name' => 'sf_subscriptions_opportunitiesopportunities_ida', 'type' => 'id', 'source' => 'non-db', 'vname' => 'LBL_SF_SUBSCRIPTIONS_OPPORTUNITIES_FROM_SF_SUBSCRIPTIONS_TITLE_ID', 'id_name' => 'sf_subscriptions_opportunitiesopportunities_ida', 'link' => 'sf_subscriptions_opportunities', 'table' => 'opportunities', 'module' => 'Opportunities', 'rname' => 'id', 'reportable' => false, 'side' => 'right', 'massupdate' => false, 'duplicate_merge' => 'disabled', 'hideacl' => true, ), 'sf_subscriptions_accounts' => array ( 'name' => 'sf_subscriptions_accounts', 'type' => 'link', 'relationship' => 'sf_subscriptions_accounts', 'source' => 'non-db', 'module' => 'Accounts', 'bean_name' => 'Account', 'side' => 'right', 'vname' => 'LBL_SF_SUBSCRIPTIONS_ACCOUNTS_FROM_SF_SUBSCRIPTIONS_TITLE', 'id_name' => 'sf_subscriptions_accountsaccounts_ida', 'link-type' => 'one', ), 'sf_subscriptions_accounts_name' => array ( 'name' => 'sf_subscriptions_accounts_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_SF_SUBSCRIPTIONS_ACCOUNTS_FROM_ACCOUNTS_TITLE', 'save' => true, 'id_name' => 'sf_subscriptions_accountsaccounts_ida', 'link' => 'sf_subscriptions_accounts', 'table' => 'accounts', 'module' => 'Accounts', 'rname' => 'name', ), 'sf_subscriptions_accountsaccounts_ida' => array ( 'name' => 'sf_subscriptions_accountsaccounts_ida', 'type' => 'id', 'source' => 'non-db', 'vname' => 'LBL_SF_SUBSCRIPTIONS_ACCOUNTS_FROM_SF_SUBSCRIPTIONS_TITLE_ID', 'id_name' => 'sf_subscriptions_accountsaccounts_ida', 'link' => 'sf_subscriptions_accounts', 'table' => 'accounts', 'module' => 'Accounts', 'rname' => 'id', 'reportable' => false, 'side' => 'right', 'massupdate' => false, 'duplicate_merge' => 'disabled', 'hideacl' => true, ), 'sf_subscriptions_purchasedlineitems' => array ( 'name' => 'sf_subscriptions_purchasedlineitems', 'type' => 'link', 'relationship' => 'sf_subscriptions_purchasedlineitems', 'source' => 'non-db', 'module' => 'PurchasedLineItems', 'bean_name' => 'PurchasedLineItem', 'vname' => 'LBL_SF_SUBSCRIPTIONS_PURCHASEDLINEITEMS_FROM_SF_SUBSCRIPTIONS_TITLE', 'id_name' => 'sf_subscriptions_purchasedlineitemssf_subscriptions_ida', 'link-type' => 'many', 'side' => 'left', ), ), 'relationships' => array ( 'sf_subscriptions_modified_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'SF_Subscriptions', 'rhs_table' => 'sf_subscriptions', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many', ), 'sf_subscriptions_created_by' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'SF_Subscriptions', 'rhs_table' => 'sf_subscriptions', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many', ), 'sf_subscriptions_activities' => array ( 'lhs_module' => 'SF_Subscriptions', 'lhs_table' => 'sf_subscriptions', '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' => 'SF_Subscriptions', ), 'sf_subscriptions_following' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'SF_Subscriptions', 'rhs_table' => 'sf_subscriptions', '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' => 'SF_Subscriptions', 'user_field' => 'created_by', ), 'sf_subscriptions_favorite' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'SF_Subscriptions', 'rhs_table' => 'sf_subscriptions', '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' => 'SF_Subscriptions', 'user_field' => 'created_by', ), 'sf_subscriptions_tags' => array ( 'lhs_module' => 'SF_Subscriptions', 'lhs_table' => 'sf_subscriptions', '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' => 'SF_Subscriptions', 'dynamic_subpanel' => true, ), 'sf_subscriptions_commentlog' => array ( 'lhs_module' => 'SF_Subscriptions', 'lhs_table' => 'sf_subscriptions', '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' => 'SF_Subscriptions', ), 'sf_subscriptions_locked_fields' => array ( 'lhs_module' => 'SF_Subscriptions', 'lhs_table' => 'sf_subscriptions', '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' => 'SF_Subscriptions', ), 'sf_subscriptions_team_count_relationship' => array ( 'lhs_module' => 'Teams', 'lhs_table' => 'team_sets', 'lhs_key' => 'id', 'rhs_module' => 'SF_Subscriptions', 'rhs_table' => 'sf_subscriptions', 'rhs_key' => 'team_set_id', 'relationship_type' => 'one-to-many', ), 'sf_subscriptions_teams' => array ( 'lhs_module' => 'SF_Subscriptions', 'lhs_table' => 'sf_subscriptions', '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', ), 'sf_subscriptions_team' => array ( 'lhs_module' => 'Teams', 'lhs_table' => 'teams', 'lhs_key' => 'id', 'rhs_module' => 'SF_Subscriptions', 'rhs_table' => 'sf_subscriptions', 'rhs_key' => 'team_id', 'relationship_type' => 'one-to-many', ), 'sf_subscriptions_assigned_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'SF_Subscriptions', 'rhs_table' => 'sf_subscriptions', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many', ), ), 'optimistic_locking' => true, 'unified_search' => true, 'full_text_search' => true, 'indices' => array ( 'id' => array ( 'name' => 'idx_sf_subscriptions_pk', 'type' => 'primary', 'fields' => array ( 0 => 'id', ), ), 'date_modified' => array ( 'name' => 'idx_sf_subscriptions_del_d_m', 'type' => 'index', 'fields' => array ( 0 => 'deleted', 1 => 'date_modified', 2 => 'id', ), ), 'deleted' => array ( 'name' => 'idx_sf_subscriptions_id_del', 'type' => 'index', 'fields' => array ( 0 => 'id', 1 => 'deleted', ), ), 'date_entered' => array ( 'name' => 'idx_sf_subscriptions_del_d_e', 'type' => 'index', 'fields' => array ( 0 => 'deleted', 1 => 'date_entered', 2 => 'id', ), ), 'name_del' => array ( 'name' => 'idx_sf_subscriptions_name_del', 'type' => 'index', 'fields' => array ( 0 => 'name', 1 => 'deleted', ), ), 'sync_key' => array ( 'name' => 'idx_sf_subscriptions_skey', 'type' => 'unique', 'fields' => array ( 0 => 'sync_key', ), ), 'team_set_sf_subscriptions' => array ( 'name' => 'idx_sf_subscriptions_tmst_id', 'type' => 'index', 'fields' => array ( 0 => 'team_set_id', 1 => 'deleted', ), ), 'acl_team_set_sf_subscriptions' => array ( 'name' => 'idx_sf_subscriptions_acl_tmst_id', 'type' => 'index', 'fields' => array ( 0 => 'acl_team_set_id', 1 => 'deleted', ), ), 'assigned_user_id' => array ( 'name' => 'idx_sf_subscriptions_assigned_del', 'type' => 'index', 'fields' => array ( 0 => 'assigned_user_id', 1 => 'deleted', ), ), ), 'name_format_map' => array ( ), 'visibility' => array ( 'TeamSecurity' => true, ), 'acls' => array ( 'SugarACLLockedFields' => true, 'SugarACLStatic' => true, ), 'duplicate_check' => array ( 'enabled' => true, 'FilterDuplicateCheck' => array ( 'filter_template' => array ( 0 => array ( 'name' => array ( '$starts' => '$name', ), ), ), 'ranking_fields' => array ( 0 => array ( 'in_field_name' => 'name', 'dupe_field_name' => 'name', ), ), ), ), 'favorites' => true, 'templates' => array ( 'basic' => 'basic', 'following' => 'following', 'favorite' => 'favorite', 'taggable' => 'taggable', 'commentlog' => 'commentlog', 'lockable_fields' => 'lockable_fields', 'integrate_fields' => 'integrate_fields', 'team_security' => 'team_security', 'assignable' => 'assignable', ), 'custom_fields' => false, 'has_pii_fields' => false, 'related_calc_fields' => array ( ), );