'ecmtransactions', 'audited'=>false, 'comment'=>'EcmTransactions', 'duplicate_merge'=>true , 'unified_search'=>true, 'fields'=>array( 'name'=>array( 'name'=>'name', 'vname'=>'LBL_NAME_DO', 'type'=>'varchar', 'len'=>'255', 'required' => true, ), 'description'=>array( 'name'=>'description', 'vname'=>'LBL_DESCRIPTION', 'type'=>'text', ), 'value'=>array( 'name'=>'value', 'vname'=>'LBL_VALUE', 'type'=>'varchar', 'required' => true, ), 'record_id'=>array( 'name'=>'record_id', 'vname'=>'LBL_ID', 'type'=>'text', ), 'documents' => array ( 'name' => 'documents', 'type' => 'link', 'relationship' => 'transactions_documents', 'source' => 'non-db', 'vname' => 'LBL_NOTES' ), 'parent_name' => array( 'name'=> 'parent_name', 'id_name'=>'parent_id', 'vname'=>'LBL_PARENT_NAME', 'type'=>'relate', 'group'=>'parent_name', 'dbtype' => 'varchar', 'size' => '30', 'width'=>'30', 'len' => '255', 'module' => 'Accounts', 'massupdate' => false, 'required' => true, ), 'currency_id' => array ( 'name' => 'currency_id', 'type' => 'enum', 'options' => 'currency_dom', 'label' => 'LBL_CURRENCY' ), 'currency_value' => array ( 'name' => 'currency_value', 'type'=>'decimal', 'len'=>'15,2', 'vname' => 'LBL_CURRENCY_VALUE', 'reportable' => false, 'required' => false ), 'parent_index' => array( 'name'=> 'parent_index', 'id_name'=>'parent_id', 'vname'=>'LBL_PARENT_NAME', 'type'=>'relate', 'group'=>'parent_index', 'dbtype' => 'varchar', 'size' => '30', 'width'=>'30', 'len' => '255', 'module' => 'Accounts', 'massupdate' => false, 'required' => false, ), 'type' => array ( 'name' => 'type', 'vname' => 'Strona', 'type' => 'enum', 'options' => 'transaction_type_dom', 'size' => '3', ), 'type2' => array ( 'name' => 'type2', 'vname' => 'Typ', 'type' => 'enum', 'options' => 'transaction_type2_dom', 'size' => '3', ), 'record_type' => array ( 'name' => 'record_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'record_t_type_dom', 'size' => '3', ), 'parent_id' => array ( 'name' => 'parent_id', 'type' => 'id', 'module' => 'Accounts', 'vname' => 'LBL_PARENT_ID', 'group'=>'parent_name', 'massupdate' => false, 'reportable'=>false, 'required' => true, ), 'payment_date' => array ( 'name' => 'payment_date', 'vname' => 'LBL_PAYMENT_DATE', 'type' => 'date', 'reportable' => false, 'showFormats' => true, 'massupdate' => false, 'required' => true, ), 'register_date' => array ( 'name' => 'register_date', 'vname' => 'LBL_REGISTER_DATE', 'type' => 'date', 'reportable' => false, 'showFormats' => true, 'massupdate' => false, 'required' => true, ), 'notes' => array ( 'name' => 'notes', 'type' => 'link', 'relationship' => 'ecmtransactions_notes', 'source'=>'non-db', 'vname'=>'LBL_NOTES' ), ), 'indices'=>array( array('name'=>'idx_ecmtransaction_id_del','type'=>'index','fields'=>array('id','deleted')), array('name'=>'idx_ecmtransaction_assigned_del','type'=>'index','fields'=>array( 'deleted', 'assigned_user_id')), ), 'relationships'=>array( 'ecmtransactions_assigned_user'=>array( 'lhs_module'=>'Users', 'lhs_table'=>'users', 'lhs_key'=>'id', 'rhs_module'=>'EcmTransactions', 'rhs_table'=>'ecmtransactions', 'rhs_key'=>'assigned_user_id', 'relationship_type'=>'one-to-many' ), 'ecmtransactions_notes' => array ( 'lhs_module' => 'EcmTransactions', 'lhs_table' => 'ecmtransactions', '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' => 'EcmTransactions' ), 'ecmtransactions_modified_user'=>array( 'lhs_module'=>'Users', 'lhs_table'=>'users', 'lhs_key'=>'id', 'rhs_module'=>'EcmTransactions', 'rhs_table'=>'ecmtransactions', 'rhs_key'=>'modified_user_id', 'relationship_type'=>'one-to-many' ), 'transactions_documents' => array ( 'lhs_module' => 'EcmTransactions', 'lhs_table' => 'ecmtransactions', 'lhs_key' => 'id', 'rhs_module' => 'Documents', 'rhs_table' => 'documents', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'EcmTransactions' ), 'ecmtransactions_created_by'=>array( 'lhs_module'=>'Users', 'lhs_table'=>'users', 'lhs_key'=>'id', 'rhs_module'=>'EcmTransactions', 'rhs_table'=>'ecmtransactions', 'rhs_key'=>'created_by', 'relationship_type'=>'one-to-many' ), ), 'optimistic_locking'=>true, ); require_once('include/SugarObjects/VardefManager.php'); VardefManager::createVardef('EcmTransactions','EcmTransaction', array('default','assignable')); ?>