'ecmstockoperations', 'audited'=>true, 'comment'=>'EcmStockOperations', 'duplicate_merge'=>true , 'unified_search'=>true, 'fields'=>array( 'stock_name' => array( 'name'=> 'stock_name', 'id_name'=>'stock_id', 'vname'=>'LBL_STOCK_NAME', 'type'=>'relate', 'group'=>'stock_name', 'dbtype' => 'varchar', 'len' => '255', 'module' => 'EcmStocks', 'table'=>'ecmstocks', 'options'=>'ecmstocks_list_dom', 'massupdate'=>false, ), 'stock_id' => array ( 'name' => 'stock_id', 'type' => 'enum', 'module' => 'EcmStocks', 'table'=>'ecmstocks', 'vname' => 'LBL_STOCK_NAME', 'group'=>'stock_name', 'required' => true, 'options'=>'ecmstocks_list_dom', 'massupdate'=>false, ), /* 'stock_id' => array ( 'name' => 'stock_id', 'vname' => 'LBL_STOCK_NAME', 'type' => 'enum', 'size' => '3', 'options' => 'ecmstocks_list_dom', 'massupdate' => false, ), */ 'product_code' => array( 'name'=> 'product_code', 'vname'=>'LBL_PRODUCT_CODE', 'type'=>'varchar', 'len' => '255', 'massupdate'=>false, ), 'product_name' => array( 'name'=> 'product_name', 'id_name'=>'product_id', 'vname'=>'LBL_PRODUCT_NAME', 'type'=>'relate', 'group'=>'product_name', 'dbtype' => 'varchar', 'len' => '255', 'module' => 'EcmProducts', 'table'=>'ecmproducts', 'massupdate'=>false, ), 'product_id' => array ( 'name' => 'product_id', 'type' => 'id', 'module' => 'EcmProducts', 'table'=>'ecmproducts', 'vname' => 'LBL_PRODUCT_ID', 'group'=>'product_name', 'required' => true, 'massupdate'=>false, ), 'quantity' => array ( 'name' => 'quantity', 'vname' => 'LBL_QUANTITY', 'type' => 'decimal', 'len' => '15,4', 'required' => true, 'massupdate'=>false, ), // serial numbers 'part_no' => array ( 'name' => 'part_no', 'vname' => 'Numer partii', 'type' => 'varchar', 'len' => '50', 'massupdate' => false ), 'part_no2' => array ( 'name' => 'part_no2', 'vname' => 'LBL_PART_NO', 'type' => 'varchar', 'len' => '50', 'massupdate' => false ), 'part_no3' => array ( 'name' => 'part_no3', 'vname' => 'LBL_PART_NO', 'type' => 'varchar', 'len' => '50', 'massupdate' => false ), 'part_no4' => array ( 'name' => 'part_no4', 'vname' => 'LBL_PART_NO', 'type' => 'varchar', 'len' => '50', 'massupdate' => false ), 'part_no5' => array ( 'name' => 'part_no5', 'vname' => 'LBL_PART_NO', 'type' => 'varchar', 'len' => '50', 'massupdate' => false ), 'counter' => array ( 'name' => 'counter', 'vname' => 'counter', 'type' => 'varchar', 'len' => '50', 'massupdate' => false ), 'date' => array ( 'name' => 'date', 'vname' => 'LBL_DATE', 'type' => 'datetime', 'required' => true, 'massupdate'=>false, ), 'price' => array ( 'name' => 'price', 'vname' => 'LBL_PRICE', 'type' => 'decimal', 'len' => '15,2', 'required' => true, 'massupdate'=>false, ), 'parent_type'=>array( 'name'=>'parent_type', 'vname'=>'LBL_PARENT_TYPE', 'type'=>'varchar', 'group'=>'parent_name', 'len'=>25, 'massupdate'=>false, ), 'parent_name'=>array( 'name'=> 'parent_name', 'parent_type'=>'record_type_display' , 'type_name'=>'parent_type', 'id_name'=>'parent_id', 'vname'=>'LBL_PARENT_NAME', 'type'=>'parent', 'group'=>'parent_name', 'options'=> 'ecmstockoperations_document_dom', 'massupdate'=>false, ), 'parent_id'=>array( 'name'=>'parent_id', 'vname'=>'LBL_PARENT_ID', 'type'=>'id', 'group'=>'parent_name', 'massupdate'=>false, ), 'in_id' => array ( 'name' => 'in_id', 'type' => 'id', 'vname' => 'LBL_IN_ID', 'massupdate'=>false, ), 'documentitem_id' => array ( 'name' => 'documentitem_id', 'type' => 'id', 'vname' => 'LBL_DOCUMENTITEM_ID', 'massupdate'=>false, ), 'type' => array ( 'name' => 'type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'size' => '3', 'options' => 'ecmstockoperations_type_dom', 'massupdate'=>false, ), ), 'indices'=>array( array('name'=>'idx_ecmstockoperation_id_del','type'=>'index','fields'=>array('id','deleted')), array('name'=>'idx_ecmstockoperation_assigned_del','type'=>'index','fields'=>array( 'deleted', 'assigned_user_id')), ), 'relationships'=>array( 'ecmstockoperations_assigned_user'=>array( 'lhs_module'=>'Users', 'lhs_table'=>'users', 'lhs_key'=>'id', 'rhs_module'=>'EcmStockOperations', 'rhs_table'=>'ecmstockoperations', 'rhs_key'=>'assigned_user_id', 'relationship_type'=>'one-to-many' ), 'ecmstockoperations_modified_user'=>array( 'lhs_module'=>'Users', 'lhs_table'=>'users', 'lhs_key'=>'id', 'rhs_module'=>'EcmStockOperations', 'rhs_table'=>'ecmstockoperations', 'rhs_key'=>'modified_user_id', 'relationship_type'=>'one-to-many' ), 'ecmstockoperations_created_by'=>array( 'lhs_module'=>'Users', 'lhs_table'=>'users', 'lhs_key'=>'id', 'rhs_module'=>'EcmStockOperations', 'rhs_table'=>'ecmstockoperations', 'rhs_key'=>'created_by', 'relationship_type'=>'one-to-many' ) ), 'optimistic_locking'=>true, ); require_once('include/SugarObjects/VardefManager.php'); VardefManager::createVardef('EcmStockOperations','EcmStockOperation', array('default','assignable')); ?>