'leads', 'audited' => true, 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => true, 'duplicate_merge' => true, 'comment' => 'Leads are organizations or entities that are the target of selling, support, and marketing activities, or have already purchased products or services', 'fields' => array ( 'parent_id' => array ( 'name' => 'parent_id', 'vname' => 'LBL_PARENT_ACCOUNT_ID', 'type' => 'id', 'required' => false, 'reportable' => false, 'audited' => true, 'comment' => 'Lead ID of the parent of this lead' ), 'sic_code' => array ( 'name' => 'sic_code', 'vname' => 'LBL_SIC_CODE', 'type' => 'varchar', 'len' => 10, 'comment' => 'SIC code of the lead' ), // add mz 'priority' => array ( 'name' => 'priority', 'vname' => 'LBL_PRIORITY', 'type' => 'enum', 'options' => 'account_priority_dom', 'len' => 3, ), // www informations // end www informations 'maps' => array ( 'name' => 'maps', 'vname' => 'LBL_MAPS', 'source' => 'non-db', 'type' => 'varchar' ), 'to_vatid' => array ( 'name' => 'to_vatid', 'vname' => 'LBL_TO_VATID', 'type' => 'varchar', 'len' => 50 ), 'to_vatid_unformated' => array ( 'name' => 'to_vatid_unformated', 'vname' => 'LBL_TO_VATID', 'type' => 'varchar', 'len' => 50 ), 'supplier_code' => array ( 'name' => 'supplier_code', 'vname' => 'LBL_SUPPLIER_CODE', 'type' => 'varchar', 'len' => 50 ), 'iln' => array ( 'name' => 'iln', 'vname' => 'LBL_ILN', 'type' => 'varchar', 'len' => 50 ), 'currency_id' => array ( 'name' => 'currency_id', 'type' => 'enum', 'options' => 'currency_dom', 'label' => 'LBL_CURRENCY', 'len' => 36 ), // end mz 'parent_name' => array ( 'name' => 'parent_name', 'rname' => 'name', 'id_name' => 'parent_id', 'vname' => 'LBL_MEMBER_OF', 'type' => 'relate', 'isnull' => 'true', 'module' => 'Leads', 'table' => 'leads', 'massupdate' => false, 'source' => 'non-db', 'len' => 36, 'link' => 'member_of', 'unified_search' => true, 'importable' => 'true' ), 'members' => array ( 'name' => 'members', 'type' => 'link', 'relationship' => 'member_leads', 'module' => 'Leads', 'bean_name' => 'Lead', 'source' => 'non-db', 'vname' => 'LBL_MEMBERS' ), 'member_of' => array ( 'name' => 'member_of', 'type' => 'link', 'relationship' => 'member_leads', 'module' => 'Leads', 'bean_name' => 'Lead', 'link_type' => 'one', 'source' => 'non-db', 'vname' => 'LBL_MEMBER_OF', 'side' => 'right' ), 'email_opt_out' => array ( 'name' => 'email_opt_out', 'vname' => 'LBL_EMAIL_OPT_OUT', 'source' => 'non-db', 'type' => 'bool', 'massupdate' => false, 'studio' => 'false' ), 'invalid_email' => array ( 'name' => 'invalid_email', 'vname' => 'LBL_INVALID_EMAIL', 'source' => 'non-db', 'type' => 'bool', 'massupdate' => false, 'studio' => 'false' ), 'cases' => array ( 'name' => 'cases', 'type' => 'link', 'relationship' => 'lead_cases', 'module' => 'Cases', 'bean_name' => 'aCase', 'source' => 'non-db', 'vname' => 'LBL_CASES' ), // bug 42902 'email' => array ( 'name' => 'email', 'type' => 'email', 'query_type' => 'default', 'source' => 'non-db', 'operator' => 'subquery', 'subquery' => 'SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE', 'db_field' => array ( 'id' ), 'vname' => 'LBL_ANY_EMAIL', 'studio' => array ( 'visible' => false, 'searchview' => true ) ), 'tasks' => array ( 'name' => 'tasks', 'type' => 'link', 'relationship' => 'lead_tasks', 'module' => 'Tasks', 'bean_name' => 'Task', 'source' => 'non-db', 'vname' => 'LBL_TASKS' ), 'notes' => array ( 'name' => 'notes', 'type' => 'link', 'relationship' => 'lead_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', 'vname' => 'LBL_NOTES' ), 'documents' => array ( 'name' => 'documents', 'type' => 'link', 'relationship' => 'lead_documents', 'module' => 'Documents', 'source' => 'non-db', 'vname' => 'LBL_DOCUMENTS' ), 'meetings' => array ( 'name' => 'meetings', 'type' => 'link', 'relationship' => 'lead_meetings', 'module' => 'Meetings', 'bean_name' => 'Meeting', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS' ), 'calls' => array ( 'name' => 'calls', 'type' => 'link', 'relationship' => 'lead_calls', 'module' => 'Calls', 'bean_name' => 'Call', 'source' => 'non-db', 'vname' => 'LBL_CALLS' ), 'emails' => array ( 'name' => 'emails', 'type' => 'link', 'relationship' => 'emails_leads_rel', /* reldef in emails */ 'module' => 'Emails', 'bean_name' => 'Email', 'source' => 'non-db', 'vname' => 'LBL_EMAILS', 'studio' => array ( "formula" => false ) ), 'bugs' => array ( 'name' => 'bugs', 'type' => 'link', 'relationship' => 'leads_bugs', 'module' => 'Bugs', 'bean_name' => 'Bug', 'source' => 'non-db', 'vname' => 'LBL_BUGS' ), 'contactleads' => array ( 'name' => 'contactleads', 'type' => 'link', 'relationship' => 'leads_contactleads', 'module' => 'ContactLeads', 'bean_name' => 'ContactLead', 'source' => 'non-db', 'vname' => 'LBL_CONTACTS' ), 'email_addresses' => array ( 'name' => 'email_addresses', 'type' => 'link', 'relationship' => 'leads_email_addresses', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESSES', 'reportable' => false, 'unified_search' => true, 'rel_fields' => array ( 'primary_address' => array ( 'type' => 'bool' ) ), 'studio' => array ( "formula" => false ) ), 'email_addresses_primary' => array ( 'name' => 'email_addresses_primary', 'type' => 'link', 'relationship' => 'leads_email_addresses_primary', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESS_PRIMARY', 'duplicate_merge' => 'disabled', 'studio' => array ( "formula" => false ) ), 'opportunities' => array ( 'name' => 'opportunities', 'type' => 'link', 'relationship' => 'leads_opportunities', 'module' => 'Opportunities', 'bean_name' => 'Opportunity', 'source' => 'non-db', 'vname' => 'LBL_OPPORTUNITY' ), 'project' => array ( 'name' => 'project', 'type' => 'link', 'relationship' => 'projects_leads', 'module' => 'Project', 'bean_name' => 'Project', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS' ), 'leads' => array ( 'name' => 'leads', 'type' => 'link', 'relationship' => 'lead_leads', 'module' => 'Leads', 'bean_name' => 'Lead', 'source' => 'non-db', 'vname' => 'LBL_LEADS' ), 'campaigns' => array ( 'name' => 'campaigns', 'type' => 'link', 'relationship' => 'lead_campaign_log', 'module' => 'CampaignLog', 'bean_name' => 'CampaignLog', 'source' => 'non-db', 'vname' => 'LBL_CAMPAIGNLOG', 'studio' => array ( "formula" => false ) ), 'campaign_leads' => array ( 'name' => 'campaign_leads', 'type' => 'link', 'vname' => 'LBL_CAMPAIGNS', 'relationship' => 'campaign_leads', 'source' => 'non-db' ), 'created_by_link' => array ( 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'leads_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' => 'leads_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' => 'leads_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'duplicate_merge' => 'enabled', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'table' => 'users' ), 'campaign_id' => array ( 'name' => 'campaign_id', 'comment' => 'Campaign that generated Lead', 'vname' => 'LBL_CAMPAIGN_ID', 'rname' => 'id', 'id_name' => 'campaign_id', 'type' => 'id', 'table' => 'campaigns', 'isnull' => 'true', 'module' => 'Campaigns', 'reportable' => false, 'massupdate' => false, 'duplicate_merge' => 'disabled' ), 'campaign_name' => array ( 'name' => 'campaign_name', 'rname' => 'name', 'vname' => 'LBL_CAMPAIGN', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'campaigns', 'id_name' => 'campaign_id', 'link' => 'campaign_leads', 'module' => 'Campaigns', 'duplicate_merge' => 'disabled', 'comment' => 'The first campaign name for Lead (Meta-data only)' ), 'prospect_lists' => array ( 'name' => 'prospect_lists', 'type' => 'link', 'relationship' => 'prospect_list_leads', 'module' => 'ProspectLists', 'source' => 'non-db', 'vname' => 'LBL_PROSPECT_LIST' ), // add mz 'ecmpaymentcondition_id' => array ( 'name' => 'ecmpaymentcondition_id', 'rname' => 'name', 'id_name' => 'ecmpaymentcondition_id', 'vname' => 'LBL_PAYMENTCONDITION_ID', 'group' => 'ecmpaymentcondition_name', 'type' => 'relate', 'table' => 'ecmpaymentconditions', 'reportable' => true, 'Importable' => false, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'duplicate_merge' => 'disabled', 'massupdate' => false ), 'ecmpaymentcondition_name' => array ( 'name' => 'ecmpaymentcondition_name', 'vname' => 'LBL_PAYMENTCONDITION_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'ecmpaymentcondition', 'id_name' => 'ecmpaymentcondition_id', 'module' => 'EcmPaymentConditions', 'duplicate_merge' => 'disabled', 'massupdate' => false ), 'ecmdeliverycondition_id' => array ( 'name' => 'ecmdeliverycondition_id', 'rname' => 'name', 'id_name' => 'ecmdeliverycondition_id', 'vname' => 'LBL_DELIVERYCONDITION_ID', 'group' => 'ecmdeliverycondition_name', 'type' => 'relate', 'table' => 'ecmdeliveryconditions', 'reportable' => true, 'Importable' => false, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'duplicate_merge' => 'disabled', 'massupdate' => false ), 'ecmdeliverycondition_name' => array ( 'name' => 'ecmdeliverycondition_name', 'vname' => 'LBL_DELIVERYCONDITION_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'ecmdeliverycondition', 'id_name' => 'ecmdeliverycondition_id', 'module' => 'EcmDeliveryConditions', 'duplicate_merge' => 'disabled', 'massupdate' => false ) ), 'indices' => array ( array ( 'name' => 'idx_accnt_id_del', 'type' => 'index', 'fields' => array ( 'id', 'deleted' ) ), array ( 'name' => 'idx_accnt_name_del', 'type' => 'index', 'fields' => array ( 'name', 'deleted' ) ), // bug #5530 array ( 'name' => 'idx_accnt_assigned_del', 'type' => 'index', 'fields' => array ( 'deleted', 'assigned_user_id' ) ), array ( 'name' => 'idx_accnt_parent_id', 'type' => 'index', 'fields' => array ( 'parent_id' ) ) ), 'relationships' => array ( 'member_leads' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'Leads', 'rhs_table' => 'leads', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many' ), 'lead_cases' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'Cases', 'rhs_table' => 'cases', 'rhs_key' => 'lead_id', 'relationship_type' => 'one-to-many' ), 'lead_tasks' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', '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' => 'Leads' ), 'lead_notes' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', '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' => 'Leads' ), 'lead_documents' => array( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'Documents', 'rhs_table' => 'documents', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'documents_accounts', 'join_key_lhs' => 'parent_id', 'join_key_rhs' => 'document_id', ), 'lead_meetings' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', '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' => 'Leads' ), 'lead_calls' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', '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' => 'Leads' ) /*,'leads_emails' => array( 'rhs_module' => 'Emails', 'rhs_table' => 'emails', 'rhs_key' => 'id', 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'emails_leads', 'join_key_rhs' => 'email_id', 'join_key_lhs' => 'lead_id' ) */ ,'lead_emails' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', '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' => 'Leads' ), 'lead_leads' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'Leads', 'rhs_table' => 'leads', 'rhs_key' => 'lead_id', 'relationship_type' => 'one-to-many' ), 'leads_assigned_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Leads', 'rhs_table' => 'leads', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many' ), 'leads_modified_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Leads', 'rhs_table' => 'leads', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many' ), 'leads_created_by' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Leads', 'rhs_table' => 'leads', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many' ), 'lead_campaign_log' => array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'CampaignLog', 'rhs_table' => 'campaign_log', 'rhs_key' => 'target_id', 'relationship_type' => 'one-to-many' ) ) , // This enables optimistic locking for Saves From EditView 'optimistic_locking' => true ); VardefManager::createVardef ( 'Leads', 'Lead', array ( 'default', 'assignable', 'company' ) ); // jc - adding for refactor for import to not use the required_fields array // defined in the field_arrays.php file $dictionary ['Lead'] ['fields'] ['name'] ['importable'] = 'required'; $dictionary ['Lead'] ['fields'] ['ecmstockdocouts'] = array ( 'name' => 'ecmstockdocouts', 'type' => 'link', 'relationship' => 'ecmstockdocouts_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['ecmstockdocouts_lead'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'EcmStockDocOuts', 'rhs_table' => 'ecmstockdocouts', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many' ); $dictionary ['Lead'] ['fields'] ['ecmquotes'] = array ( 'name' => 'ecmquotes', 'type' => 'link', 'relationship' => 'ecmquotes_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['ecmquotes_lead'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'EcmQuotes', 'rhs_table' => 'ecmquotes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many' ); $dictionary ['Lead'] ['fields'] ['ecmworkreports'] = array ( 'name' => 'ecmworkreports', 'type' => 'link', 'relationship' => 'ecmworkreports_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['fields'] ['ecmdocs'] = array ( 'name' => 'ecmdocs', 'type' => 'link', 'relationship' => 'ecmdocs_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['ecmdocs_lead'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'EcmDocs', 'rhs_table' => 'ecmdocs', 'rhs_key' => 'lead_id', 'relationship_type' => 'one-to-many' ); $dictionary ['Lead'] ['fields'] ['ecmworkitems'] = array ( 'name' => 'ecmworkitems', 'type' => 'link', 'relationship' => 'ecmworkitems_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['ecmworkitems_lead'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'EcmWorkItems', 'rhs_table' => 'ecmworkitems', 'rhs_key' => 'lead_id', 'relationship_type' => 'one-to-many' ); $dictionary ['Lead'] ['fields'] ['is_vat_free'] = array ( 'massupdate' => false, 'name' => 'is_vat_free', 'vname' => 'LBL_IS_VAT_FREE', 'type' => 'bool', 'default' => '0', 'comment' => 'Is Lead vat free?' ); $dictionary ['Lead'] ['fields'] ['ecmlanguage'] = array ( 'name' => 'ecmlanguage', 'vname' => 'LBL_ECMLANGUAGE', 'type' => 'enum', 'options' => 'ecmlanguages_dom', 'required' => true, 'len' => 35 ); $dictionary ['Lead'] ['fields'] ['vatid'] = array ( 'name' => 'vatid', 'vname' => 'LBL_VATID', 'type' => 'varchar', 'len' => 15, 'comment' => 'VAT-ID of the lead' ); $dictionary ['Lead'] ['fields'] ['ecmcalls'] = array ( 'name' => 'ecmcalls', 'type' => 'link', 'relationship' => 'ecmcalls_leads', 'source' => 'non-db' ); $dictionary ['Lead'] ['fields'] ['ecmquestionnaires'] = array ( 'name' => 'ecmquestionnaires', 'type' => 'link', 'relationship' => 'ecmquestionnaires_leads', 'source' => 'non-db' ); $dictionary ['Lead'] ['fields'] ['ecmsales'] = array ( 'name' => 'ecmsales', 'type' => 'link', 'relationship' => 'ecmsales_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['ecmsales_lead'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'EcmSales', 'rhs_table' => 'ecmsales', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many' ); $dictionary ['Lead'] ['fields'] ['ecmdeliverynotes'] = array ( 'name' => 'ecmdeliverynotes', 'type' => 'link', 'relationship' => 'ecmdeliverynotes_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['ecmdeliverynotes_lead'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'EcmDeliveryNotes', 'rhs_table' => 'ecmdeliverynotes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many' ); $dictionary ['Lead'] ['fields'] ['ecmdocuments'] = array ( 'name' => 'ecmdocuments', 'type' => 'link', 'relationship' => 'ecmdocuments_leads', 'source' => 'non-db', 'vname' => 'LBL_ECMDOCUMENTS' ); $dictionary ['Lead'] ['fields'] ['ecminvoiceouts'] = array ( 'name' => 'ecminvoiceouts', 'type' => 'link', 'relationship' => 'ecminvoiceouts_lead', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['ecminvoiceouts_lead'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'EcmInvoiceOuts', 'rhs_table' => 'ecminvoiceouts', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many' ); /* $dictionary ['Lead'] ['fields'] ['documents'] = array ( 'name' => 'documents', 'type' => 'link', 'relationship' => 'documents_leads', 'source' => 'non-db' ); $dictionary ['Lead'] ['relationships'] ['documents_leads'] = array ( 'lhs_module' => 'Leads', 'lhs_table' => 'leads', 'lhs_key' => 'id', 'rhs_module' => 'Documents', 'rhs_table' => 'documents', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many' ); */ ?>