[ 'layout' => [ 'basic' => [ 'campaign_name' => [ 'name' => 'campaign_name', 'width' => '', 'label' => 'LBL_LIST_CAMPAIGN', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'fieldDefinition' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'campaign_name' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, ], 'campaign_id' => [ 'name' => 'campaign_id', 'vname' => 'LBL_CAMPAIGN_ID', 'group' => 'campaign_name', 'type' => 'id', 'reportable' => false, 'comment' => 'ID of related campaign', 'required' => false, ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'recipient_name' => [ 'name' => 'recipient_name', 'width' => '', 'label' => 'LBL_LIST_RECIPIENT_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'name' => 'recipient_name', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'recipient_email' => [ 'name' => 'recipient_email', 'width' => '', 'label' => 'LBL_LIST_RECIPIENT_EMAIL', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'name' => 'recipient_email', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'message_name' => [ 'name' => 'message_name', 'width' => '', 'label' => 'LBL_LIST_MESSAGE_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'fieldDefinition' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'message_name' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, ], 'marketing_id' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'group' => 'message_name', 'type' => 'id', 'reportable' => false, 'comment' => '', 'required' => false, ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'send_date_time' => [ 'name' => 'send_date_time', 'width' => '', 'label' => 'LBL_SEND_ON', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'enable_range_search' => true, 'fieldDefinition' => [ 'name' => 'send_date_time', 'vname' => 'LBL_SEND_DATE_TIME', 'type' => 'datetime', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'send_attempts' => [ 'name' => 'send_attempts', 'width' => '', 'label' => 'LBL_SEND_ATTEMPTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'int', 'fieldDefinition' => [ 'name' => 'send_attempts', 'vname' => 'LBL_SEND_ATTEMPTS', 'type' => 'int', 'default' => '0', 'comment' => 'Number of attempts made to send this item', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'in_queue' => [ 'name' => 'in_queue', 'width' => '', 'label' => 'LBL_IN_QUEUE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'fieldDefinition' => [ 'name' => 'in_queue', 'vname' => 'LBL_IN_QUEUE', 'type' => 'bool', 'default' => '0', 'displayType' => 'checkbox', 'comment' => 'Flag indicating if item still in queue', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'date_entered' => [ 'name' => 'date_entered', 'width' => '', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'date_modified' => [ 'name' => 'date_modified', 'width' => '', 'label' => 'LBL_DATE_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'user_id' => [ 'name' => 'user_id', 'width' => '', 'label' => 'LBL_USER_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'user_id', 'vname' => 'LBL_USER_ID', 'type' => 'id', 'len' => '36', 'reportable' => false, 'comment' => 'User ID representing assigned-to user', 'required' => false, 'readonly' => false, ], ], 'id' => [ 'name' => 'id', 'width' => '', 'label' => 'LBL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'int', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'int', 'len' => '11', 'auto_increment' => true, 'comment' => 'Unique identifier', 'required' => false, 'readonly' => false, ], ], 'list_id' => [ 'name' => 'list_id', 'width' => '', 'label' => 'LBL_LIST_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'list_id', 'vname' => 'LBL_LIST_ID', 'type' => 'id', 'reportable' => false, 'len' => '36', 'comment' => 'Associated list', 'required' => false, 'readonly' => false, ], ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'width' => '', 'label' => 'LBL_MODIFIED_USER_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'id', 'reportable' => false, 'len' => '36', 'comment' => 'User ID who last modified record', 'required' => false, 'readonly' => false, ], ], 'more_information' => [ 'name' => 'more_information', 'width' => '', 'label' => 'LBL_MORE_INFO', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'more_information', 'vname' => 'LBL_MORE_INFO', 'type' => 'varchar', 'len' => '100', 'required' => false, 'readonly' => false, ], ], 'in_queue_date' => [ 'name' => 'in_queue_date', 'width' => '', 'label' => 'LBL_IN_QUEUE_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'in_queue_date', 'vname' => 'LBL_IN_QUEUE_DATE', 'type' => 'datetime', 'comment' => 'Datetime in which item entered queue', 'required' => false, 'readonly' => false, ], ], 'deleted' => [ 'name' => 'deleted', 'width' => '', 'label' => 'LBL_DELETED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'reportable' => false, 'comment' => 'Record deletion indicator', 'default' => '0', 'required' => false, 'readonly' => false, ], ], 'related_type' => [ 'name' => 'related_type', 'width' => '', 'label' => 'LBL_RELATED_TYPE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'related_type', 'vname' => 'LBL_RELATED_TYPE', 'type' => 'varchar', 'len' => '100', 'required' => false, 'readonly' => false, ], ], 'related_id' => [ 'name' => 'related_id', 'width' => '', 'label' => 'LBL_RELATED_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'related_id', 'vname' => 'LBL_RELATED_ID', 'type' => 'id', 'reportable' => false, 'required' => false, 'readonly' => false, ], ], 'related_confirm_opt_in' => [ 'name' => 'related_confirm_opt_in', 'width' => '', 'label' => 'LBL_RELATED_CONFIRM_OPT_IN', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'related_confirm_opt_in', 'vname' => 'LBL_RELATED_CONFIRM_OPT_IN', 'type' => 'bool', 'default' => 0, 'reportable' => false, 'comment' => '', 'required' => false, 'readonly' => false, ], ], 'marketing_id' => [ 'name' => 'marketing_id', 'width' => '', 'label' => 'LBL_MARKETING_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'group' => 'message_name', 'type' => 'id', 'reportable' => false, 'comment' => '', 'required' => false, 'readonly' => false, ], ], 'campaign_id' => [ 'name' => 'campaign_id', 'width' => '', 'label' => 'LBL_CAMPAIGN_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'campaign_id', 'vname' => 'LBL_CAMPAIGN_ID', 'group' => 'campaign_name', 'type' => 'id', 'reportable' => false, 'comment' => 'ID of related campaign', 'required' => false, 'readonly' => false, ], ], 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_SUBJECT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_SUBJECT', 'type' => 'varchar', 'metadata' => [ 'linkRoute' => '../../../email-marketing/record/{{attributes.marketing_id}}', ], 'source' => 'non-db', 'len' => '255', 'required' => false, 'readonly' => false, ], ], 'status' => [ 'name' => 'status', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'status', 'type' => 'enum', 'source' => 'non-db', 'len' => 100, 'options' => 'email_marketing_status_dom', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'source' => 'non-db', 'isnull' => 'false', 'dbType' => 'id', 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, 'readonly' => false, ], ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'user_name', 'type' => 'relate', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, 'readonly' => false, ], ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'emailman_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', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, 'readonly' => false, ], ], ], 'advanced' => [ 'campaign_name' => [ 'name' => 'campaign_name', 'width' => '', 'label' => 'LBL_LIST_CAMPAIGN', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'campaign_name' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, ], 'campaign_id' => [ 'name' => 'campaign_id', 'vname' => 'LBL_CAMPAIGN_ID', 'group' => 'campaign_name', 'type' => 'id', 'reportable' => false, 'comment' => 'ID of related campaign', 'required' => false, ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'recipient_name' => [ 'name' => 'recipient_name', 'width' => '', 'label' => 'LBL_LIST_RECIPIENT_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'recipient_name', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'recipient_email' => [ 'name' => 'recipient_email', 'width' => '', 'label' => 'LBL_LIST_RECIPIENT_EMAIL', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'recipient_email', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'message_name' => [ 'name' => 'message_name', 'width' => '', 'label' => 'LBL_LIST_MESSAGE_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'message_name' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, ], 'marketing_id' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'group' => 'message_name', 'type' => 'id', 'reportable' => false, 'comment' => '', 'required' => false, ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'in_queue' => [ 'name' => 'in_queue', 'width' => '', 'label' => 'LBL_IN_QUEUE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'fieldDefinition' => [ 'name' => 'in_queue', 'vname' => 'LBL_IN_QUEUE', 'type' => 'bool', 'default' => '0', 'displayType' => 'checkbox', 'comment' => 'Flag indicating if item still in queue', 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'current_user_only' => [ 'name' => 'current_user_only', 'label' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool', 'default' => true, 'width' => '10%', 'fieldDefinition' => [ 'displayType' => 'checkbox', 'readonly' => false, ], ], 'date_entered' => [ 'name' => 'date_entered', 'width' => '', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'date_modified' => [ 'name' => 'date_modified', 'width' => '', 'label' => 'LBL_DATE_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'user_id' => [ 'name' => 'user_id', 'width' => '', 'label' => 'LBL_USER_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'user_id', 'vname' => 'LBL_USER_ID', 'type' => 'id', 'len' => '36', 'reportable' => false, 'comment' => 'User ID representing assigned-to user', 'required' => false, 'readonly' => false, ], ], 'id' => [ 'name' => 'id', 'width' => '', 'label' => 'LBL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'int', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'int', 'len' => '11', 'auto_increment' => true, 'comment' => 'Unique identifier', 'required' => false, 'readonly' => false, ], ], 'list_id' => [ 'name' => 'list_id', 'width' => '', 'label' => 'LBL_LIST_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'list_id', 'vname' => 'LBL_LIST_ID', 'type' => 'id', 'reportable' => false, 'len' => '36', 'comment' => 'Associated list', 'required' => false, 'readonly' => false, ], ], 'send_date_time' => [ 'name' => 'send_date_time', 'width' => '', 'label' => 'LBL_SEND_DATE_TIME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'send_date_time', 'vname' => 'LBL_SEND_DATE_TIME', 'type' => 'datetime', 'required' => false, 'readonly' => false, ], ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'width' => '', 'label' => 'LBL_MODIFIED_USER_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'id', 'reportable' => false, 'len' => '36', 'comment' => 'User ID who last modified record', 'required' => false, 'readonly' => false, ], ], 'more_information' => [ 'name' => 'more_information', 'width' => '', 'label' => 'LBL_MORE_INFO', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'more_information', 'vname' => 'LBL_MORE_INFO', 'type' => 'varchar', 'len' => '100', 'required' => false, 'readonly' => false, ], ], 'in_queue_date' => [ 'name' => 'in_queue_date', 'width' => '', 'label' => 'LBL_IN_QUEUE_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'in_queue_date', 'vname' => 'LBL_IN_QUEUE_DATE', 'type' => 'datetime', 'comment' => 'Datetime in which item entered queue', 'required' => false, 'readonly' => false, ], ], 'send_attempts' => [ 'name' => 'send_attempts', 'width' => '', 'label' => 'LBL_SEND_ATTEMPTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'int', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'send_attempts', 'vname' => 'LBL_SEND_ATTEMPTS', 'type' => 'int', 'default' => '0', 'comment' => 'Number of attempts made to send this item', 'required' => false, 'readonly' => false, ], ], 'deleted' => [ 'name' => 'deleted', 'width' => '', 'label' => 'LBL_DELETED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'reportable' => false, 'comment' => 'Record deletion indicator', 'default' => '0', 'required' => false, 'readonly' => false, ], ], 'related_type' => [ 'name' => 'related_type', 'width' => '', 'label' => 'LBL_RELATED_TYPE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'related_type', 'vname' => 'LBL_RELATED_TYPE', 'type' => 'varchar', 'len' => '100', 'required' => false, 'readonly' => false, ], ], 'related_id' => [ 'name' => 'related_id', 'width' => '', 'label' => 'LBL_RELATED_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'related_id', 'vname' => 'LBL_RELATED_ID', 'type' => 'id', 'reportable' => false, 'required' => false, 'readonly' => false, ], ], 'related_confirm_opt_in' => [ 'name' => 'related_confirm_opt_in', 'width' => '', 'label' => 'LBL_RELATED_CONFIRM_OPT_IN', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'related_confirm_opt_in', 'vname' => 'LBL_RELATED_CONFIRM_OPT_IN', 'type' => 'bool', 'default' => 0, 'reportable' => false, 'comment' => '', 'required' => false, 'readonly' => false, ], ], 'marketing_id' => [ 'name' => 'marketing_id', 'width' => '', 'label' => 'LBL_MARKETING_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'group' => 'message_name', 'type' => 'id', 'reportable' => false, 'comment' => '', 'required' => false, 'readonly' => false, ], ], 'campaign_id' => [ 'name' => 'campaign_id', 'width' => '', 'label' => 'LBL_CAMPAIGN_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'campaign_id', 'vname' => 'LBL_CAMPAIGN_ID', 'group' => 'campaign_name', 'type' => 'id', 'reportable' => false, 'comment' => 'ID of related campaign', 'required' => false, 'readonly' => false, ], ], 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_SUBJECT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_SUBJECT', 'type' => 'varchar', 'metadata' => [ 'linkRoute' => '../../../email-marketing/record/{{attributes.marketing_id}}', ], 'source' => 'non-db', 'len' => '255', 'required' => false, 'readonly' => false, ], ], 'status' => [ 'name' => 'status', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'status', 'type' => 'enum', 'source' => 'non-db', 'len' => 100, 'options' => 'email_marketing_status_dom', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'source' => 'non-db', 'isnull' => 'false', 'dbType' => 'id', 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, 'readonly' => false, ], ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'user_name', 'type' => 'relate', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, 'readonly' => false, ], ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'emailman_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', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, 'readonly' => false, ], ], ], ], ], 'mass_update' => [ 'fields' => [ [ 'name' => 'send_date_time', 'label' => 'LBL_SEND_DATE_TIME', 'fieldDefinition' => [ 'name' => 'send_date_time', 'vname' => 'LBL_SEND_DATE_TIME', 'type' => 'datetime', 'required' => false, ], 'type' => 'datetime', ], [ 'name' => 'in_queue', 'label' => 'LBL_IN_QUEUE', 'fieldDefinition' => [ 'name' => 'in_queue', 'vname' => 'LBL_IN_QUEUE', 'type' => 'enum', 'default' => '0', 'displayType' => 'checkbox', 'comment' => 'Flag indicating if item still in queue', 'required' => false, 'options' => 'dom_int_bool', ], 'type' => 'enum', ], [ 'name' => 'in_queue_date', 'label' => 'LBL_IN_QUEUE_DATE', 'fieldDefinition' => [ 'name' => 'in_queue_date', 'vname' => 'LBL_IN_QUEUE_DATE', 'type' => 'datetime', 'comment' => 'Datetime in which item entered queue', 'required' => false, ], 'type' => 'datetime', ], [ 'name' => 'related_confirm_opt_in', 'label' => 'LBL_RELATED_CONFIRM_OPT_IN', 'fieldDefinition' => [ 'name' => 'related_confirm_opt_in', 'vname' => 'LBL_RELATED_CONFIRM_OPT_IN', 'type' => 'enum', 'default' => 0, 'reportable' => false, 'comment' => '', 'required' => false, 'options' => 'dom_int_bool', ], 'type' => 'enum', ], [ 'name' => 'status', 'label' => '', 'fieldDefinition' => [ 'name' => 'status', 'type' => 'enum', 'source' => 'non-db', 'len' => 100, 'options' => 'email_marketing_status_dom', 'required' => false, ], 'type' => 'enum', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SugarMassUpdateClearField__', 'labelKey' => 'LBL_EMPTY', ], ], ], ], ], ], 'listview' => [ 'columns' => [ [ 'name' => 'campaign_name', 'width' => '10', 'label' => 'LBL_LIST_CAMPAIGN', 'link' => true, 'default' => true, 'module' => 'Campaigns', 'id' => 'campaign_id', 'sortable' => true, 'type' => 'relate', 'ACLTag' => 'CAMPAIGNS', 'related_fields' => [ 'campaign_id', ], 'fieldDefinition' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'campaign_name' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, ], 'campaign_id' => [ 'name' => 'campaign_id', 'vname' => 'LBL_CAMPAIGN_ID', 'group' => 'campaign_name', 'type' => 'id', 'reportable' => false, 'comment' => 'ID of related campaign', 'required' => false, ], ], ], ], [ 'name' => 'recipient_name', 'width' => '10', 'label' => 'LBL_LIST_RECIPIENT_NAME', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => false, 'type' => 'varchar', 'fieldDefinition' => [ 'name' => 'recipient_name', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, ], ], [ 'name' => 'recipient_email', 'width' => '10', 'label' => 'LBL_LIST_RECIPIENT_EMAIL', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => false, 'type' => 'varchar', 'fieldDefinition' => [ 'name' => 'recipient_email', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, ], ], [ 'name' => 'message_name', 'width' => '10', 'label' => 'LBL_LIST_MESSAGE_NAME', 'link' => false, 'default' => true, 'module' => 'EmailMarketing', 'id' => 'marketing_id', 'sortable' => false, 'type' => 'relate', 'ACLTag' => 'EMAILMARKETING', 'related_fields' => [ 'marketing_id', ], 'fieldDefinition' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'message_name' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, ], 'marketing_id' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'group' => 'message_name', 'type' => 'id', 'reportable' => false, 'comment' => '', 'required' => false, ], ], ], ], [ 'name' => 'send_date_time', 'width' => '10', 'label' => 'LBL_LIST_SEND_DATE_TIME', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'fieldDefinition' => [ 'name' => 'send_date_time', 'vname' => 'LBL_SEND_DATE_TIME', 'type' => 'datetime', 'required' => false, ], ], [ 'name' => 'send_attempts', 'width' => '10', 'label' => 'LBL_LIST_SEND_ATTEMPTS', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'int', 'fieldDefinition' => [ 'name' => 'send_attempts', 'vname' => 'LBL_SEND_ATTEMPTS', 'type' => 'int', 'default' => '0', 'comment' => 'Number of attempts made to send this item', 'required' => false, ], ], [ 'name' => 'in_queue', 'width' => '10', 'label' => 'LBL_LIST_IN_QUEUE', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'fieldDefinition' => [ 'name' => 'in_queue', 'vname' => 'LBL_IN_QUEUE', 'type' => 'bool', 'default' => '0', 'displayType' => 'checkbox', 'comment' => 'Flag indicating if item still in queue', 'required' => false, ], ], [ 'name' => 'date_entered', 'width' => '10', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, ], ], [ 'name' => 'date_modified', 'width' => '10', 'label' => 'LBL_DATE_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, ], ], [ 'name' => 'modified_user_id', 'width' => '10', 'label' => 'LBL_MODIFIED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'fieldDefinition' => [ 'name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'id', 'reportable' => false, 'len' => '36', 'comment' => 'User ID who last modified record', 'required' => false, ], ], ], 'bulkActions' => [ 'delete' => [ 'key' => 'delete', 'labelKey' => 'LBL_DELETE', 'params' => [ 'min' => 1, 'displayConfirmation' => true, 'confirmationLabel' => 'NTC_DELETE_CONFIRMATION_MULTIPLE', ], 'acl' => [ 'delete', ], ], 'export' => [ 'key' => 'export', 'labelKey' => 'LBL_EXPORT', 'params' => [ 'min' => 1, ], 'acl' => [ 'export', ], ], ], 'lineActions' => [], 'tableActions' => [ 'send-batched-campaign-emails' => [ 'key' => 'send-batched-campaign-emails', 'labelKey' => 'LBL_CAMPAIGNS_SEND_NEXT_BATCH', 'modes' => [ 'list', ], 'acl' => [ 'list', ], 'asyncProcess' => true, 'params' => [ 'expanded' => true, 'displayConfirmation' => true, 'confirmationLabel' => 'NTC_SEND_QUEUED_CAMPAIGN_EMAILS', ], ], 'select-columns' => [ 'key' => 'select-columns', 'icon' => 'column_chooser', 'titleKey' => 'LBL_COLUMNS', 'params' => [ 'expanded' => true, ], 'modes' => [ 'list', ], 'klass' => [ 'column-chooser-button', ], ], ], 'availableFilters' => [], 'sidebarWidgets' => [], 'paginationType' => null, 'maxHeight' => null, ], 'subpanel' => [], 'recordview' => [ 'header' => [ 'backButton' => [ 'display' => true, ], ], 'templateMeta' => [ 'maxColumns' => 2, 'useTabs' => true, 'tabDefs' => [], 'colClasses' => [], ], 'topWidget' => [ 'refreshOn' => 'data-update', ], 'sidebarWidgets' => [], 'bottomWidgets' => [], 'headerWidgets' => [], 'actions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT', 'priority' => 100, 'params' => [ 'expanded' => true, ], 'modes' => [ 'detail', ], 'acl' => [ 'edit', ], ], [ 'key' => 'save', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'priority' => 100, 'params' => [ 'expanded' => true, 'disableOnRun' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'saveNew', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'priority' => 100, 'params' => [ 'expanded' => true, 'disableOnRun' => true, ], 'modes' => [ 'create', ], 'acl' => [ 'edit', ], ], [ 'key' => 'saveContinue', 'labelKey' => 'LBL_SAVE_CONTINUE_LABEL', 'priority' => 150, 'params' => [ 'expanded' => true, 'collapsedMobile' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'cancel', 'priority' => 200, 'labelKey' => 'LBL_CANCEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', ], ], [ 'key' => 'cancelCreate', 'labelKey' => 'LBL_CANCEL', 'priority' => 200, 'params' => [ 'expanded' => true, ], 'modes' => [ 'create', ], ], [ 'key' => 'duplicate', 'labelKey' => 'LBL_DUPLICATE_BUTTON', 'priority' => 1900, 'asyncProcess' => true, 'params' => null, 'modes' => [ 'detail', ], 'acl' => [ 'export', 'edit', ], ], [ 'key' => 'delete', 'labelKey' => 'LBL_DELETE', 'priority' => 2000, 'asyncProcess' => true, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'NTC_DELETE_CONFIRMATION', ], 'modes' => [ 'detail', ], 'acl' => [ 'delete', ], ], [ 'key' => 'toggle-widgets', 'labelKey' => 'LBL_INSIGHTS', 'priority' => 5000, 'params' => [ 'expanded' => true, ], 'modes' => [ 'detail', 'edit', ], 'acl' => [], ], ], 'panels' => [], 'summaryTemplates' => [ 'create' => 'LBL_CREATE', 'edit' => 'LBL_SUMMARY_DEFAULT', 'detail' => 'LBL_SUMMARY_DEFAULT', ], 'vardefs' => [ 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'required' => false, ], 'user_id' => [ 'name' => 'user_id', 'vname' => 'LBL_USER_ID', 'type' => 'id', 'len' => '36', 'reportable' => false, 'comment' => 'User ID representing assigned-to user', 'required' => false, ], 'id' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'int', 'len' => '11', 'auto_increment' => true, 'comment' => 'Unique identifier', 'required' => false, ], 'list_id' => [ 'name' => 'list_id', 'vname' => 'LBL_LIST_ID', 'type' => 'id', 'reportable' => false, 'len' => '36', 'comment' => 'Associated list', 'required' => false, ], 'send_date_time' => [ 'name' => 'send_date_time', 'vname' => 'LBL_SEND_DATE_TIME', 'type' => 'datetime', 'required' => false, ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'id', 'reportable' => false, 'len' => '36', 'comment' => 'User ID who last modified record', 'required' => false, ], 'more_information' => [ 'name' => 'more_information', 'vname' => 'LBL_MORE_INFO', 'type' => 'varchar', 'len' => '100', 'required' => false, ], 'in_queue' => [ 'name' => 'in_queue', 'vname' => 'LBL_IN_QUEUE', 'type' => 'bool', 'default' => '0', 'displayType' => 'checkbox', 'comment' => 'Flag indicating if item still in queue', 'required' => false, ], 'in_queue_date' => [ 'name' => 'in_queue_date', 'vname' => 'LBL_IN_QUEUE_DATE', 'type' => 'datetime', 'comment' => 'Datetime in which item entered queue', 'required' => false, ], 'send_attempts' => [ 'name' => 'send_attempts', 'vname' => 'LBL_SEND_ATTEMPTS', 'type' => 'int', 'default' => '0', 'comment' => 'Number of attempts made to send this item', 'required' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'reportable' => false, 'comment' => 'Record deletion indicator', 'default' => '0', 'required' => false, ], 'related_type' => [ 'name' => 'related_type', 'vname' => 'LBL_RELATED_TYPE', 'type' => 'varchar', 'len' => '100', 'required' => false, ], 'related_id' => [ 'name' => 'related_id', 'vname' => 'LBL_RELATED_ID', 'type' => 'id', 'reportable' => false, 'required' => false, ], 'related_confirm_opt_in' => [ 'name' => 'related_confirm_opt_in', 'vname' => 'LBL_RELATED_CONFIRM_OPT_IN', 'type' => 'bool', 'default' => 0, 'reportable' => false, 'comment' => '', 'required' => false, ], 'recipient_name' => [ 'name' => 'recipient_name', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, ], 'recipient_email' => [ 'name' => 'recipient_email', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, ], 'message_name' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'message_name' => [ 'name' => 'message_name', 'id_name' => 'marketing_id', 'group' => 'message_name', 'len' => '255', 'source' => 'non-db', 'rname' => 'name', 'type' => 'relate', 'module' => 'EmailMarketing', 'link' => 'email_marketing', 'table' => 'email_marketing', 'required' => false, ], 'marketing_id' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'group' => 'message_name', 'type' => 'id', 'reportable' => false, 'comment' => '', 'required' => false, ], ], ], 'marketing_id' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'group' => 'message_name', 'type' => 'id', 'reportable' => false, 'comment' => '', 'required' => false, ], 'campaign_name' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'campaign_name' => [ 'name' => 'campaign_name', 'rname' => 'name', 'source' => 'non-db', 'id_name' => 'campaign_id', 'vname' => 'LBL_LIST_CAMPAIGN', 'group' => 'campaign_name', 'type' => 'relate', 'len' => '50', 'module' => 'Campaigns', 'link' => 'campaigns', 'table' => 'campaigns', 'required' => false, ], 'campaign_id' => [ 'name' => 'campaign_id', 'vname' => 'LBL_CAMPAIGN_ID', 'group' => 'campaign_name', 'type' => 'id', 'reportable' => false, 'comment' => 'ID of related campaign', 'required' => false, ], ], ], 'campaign_id' => [ 'name' => 'campaign_id', 'vname' => 'LBL_CAMPAIGN_ID', 'group' => 'campaign_name', 'type' => 'id', 'reportable' => false, 'comment' => 'ID of related campaign', 'required' => false, ], 'name' => [ 'name' => 'name', 'vname' => 'LBL_SUBJECT', 'type' => 'varchar', 'metadata' => [ 'linkRoute' => '../../../email-marketing/record/{{attributes.marketing_id}}', ], 'source' => 'non-db', 'len' => '255', 'required' => false, ], 'status' => [ 'name' => 'status', 'type' => 'enum', 'source' => 'non-db', 'len' => 100, 'options' => 'email_marketing_status_dom', 'required' => false, ], 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'source' => 'non-db', 'isnull' => 'false', 'dbType' => 'id', 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'user_name', 'type' => 'relate', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'emailman_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', 'reportable' => false, 'massupdate' => false, 'inline_edit' => false, 'importable' => false, 'exportable' => false, 'unified_search' => false, 'required' => false, ], ], 'metadata' => [], 'sections' => [], ], 'recordmodal' => [], 'extra' => [], ]];