'ecmdocumentcategories', 'audited' => true, 'comment' => 'EcmDocumentCategories', 'duplicate_merge' => true, 'unified_search' => true, 'fields' => array ( 'name' => array ( 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255' ), 'name_en' => array ( 'name' => 'name_en', 'vname' => 'LBL_NAME_EN', 'type' => 'varchar', 'len' => '255' ), 'name_de' => array ( 'name' => 'name_de', 'vname' => 'LBL_NAME_DE', 'type' => 'varchar', 'len' => '255' ), 'description' => array ( 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text' ), 'local_transportation' => array ( 'name' => 'local_transportation', 'vname' => 'LBL_LOCAL_TRANSPORTATION', 'type' => 'decimal', 'len' => '9,3' ), 'abroad_transportation' => array ( 'name' => 'abroad_transportation', 'vname' => 'LBL_ABROAD_TRANSPORTATION', 'type' => 'decimal', 'len' => '9,3' ), 'to_module' => array ( 'name' => 'to_module', 'vname' => 'LBL_TO_MODULE', 'type' => 'enum', 'options' => 'ecmdocumentcategories_to_module_dom' ), 'assigned_file' => array ( 'type' => 'varchar', 'name' => 'assigned_file', 'vname' => 'LBL_ASSIGNED_FILE', 'max_size' => '255', 'len' => '255' ), /* 'parent_name' => array ( 'name' => 'parent_name', 'id_name' => 'parent_id', 'vname' => 'LBL_PARENT_NAME', 'type' => 'relate', 'group' => 'parent_name', 'dbtype' => 'varchar', 'len' => '255', // 'source'=>'non-db', 'module' => 'EcmDocumentCategories', 'massupdate' => false, // 'options'=> 'ecmquotes_parent_dom', 'required' =>false ), 'parent_id' => array ( 'name' => 'parent_category_id', 'type' => 'id', 'module' => 'EcmDocumentCategories', 'vname' => 'LBL_PARENT_ID', 'group' => 'parent_name', 'massupdate' => false, 'reportable' => false, 'required' => false ) */ ), 'indices' => array ( array ( 'name' => 'idx_ecmdocumentcategory_id_del', 'type' => 'index', 'fields' => array ( 'id', 'deleted' ) ), array ( 'name' => 'idx_ecmdocumentcategory_assigned_del', 'type' => 'index', 'fields' => array ( 'deleted', 'assigned_user_id' ) ) ), 'relationships' => array ( 'ecmdocumentcategories_assigned_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'EcmDocumentCategories', 'rhs_table' => 'ecmdocumentcategories', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many' ), 'ecmdocumentcategories_modified_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'EcmDocumentCategories', 'rhs_table' => 'ecmdocumentcategories', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many' ), 'ecmdocumentcategories_created_by' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'EcmDocumentCategories', 'rhs_table' => 'ecmdocumentcategories', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many' ) ), 'optimistic_locking' => true ); require_once ('include/SugarObjects/VardefManager.php'); VardefManager::createVardef ( 'EcmDocumentCategories', 'EcmDocumentCategory', array ( 'default', 'assignable' ) ); ?>