'documents', 'fields' => array ( 'without_history' => array( 'name' => 'without_history', 'label' => 'LBL_WITHOUT_HISTORY', 'type' => 'bool', 'source' => 'non-db', ), // add mz 'value' => array ( 'name' => 'value', 'vname' => 'LBL_VALUE', 'type' => 'varchar', ), 'left_paid' => array ( 'name' => 'left_paid', 'vname' => 'LBL_VALUE_PAID', 'type' => 'decimal', 'len' => '15,2', ), 'parent_type' => array ( 'name' => 'parent_type', 'vname' => 'LBL_PARENT_NAME', 'type' => 'varchar', 'source' => 'non-db', 'required' => false, 'reportable' => false, 'len' => '25', 'comment' => 'The Sugar object to which the call is related' ), 'currency_id' => array ( 'name' => 'currency_id', 'type' => 'enum', 'options' => 'currency_dom', 'label' => 'LBL_CURRENCY', 'len' => 36 ), 'currency_value' => array ( 'name' => 'currency_value', 'type' => 'decimal', 'len' => '5,4', 'vname' => 'LBL_CURRENCY_VALUE', 'reportable' => false, 'required' => false ), 'parent_name' => array ( 'name' => 'parent_name', 'type_name' => 'parent_type', 'id_name' => 'parent_id', 'vname' => 'LBL_LIST_RELATED_TO', 'type' => 'parent', 'source' => 'non-db', 'options' => 'parent_type_display2' ), 'parent_id' => array ( 'name' => 'parent_id', 'type' => 'id', 'group' => 'parent_name', 'reportable' => false, 'source' => 'non-db', 'vname' => 'LBL_PARENT_ID' ), 'document_name' => array ( 'name' => 'document_name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'required' => true, 'importable' => 'required' ), 'name' => array ( 'name' => 'name', 'vname' => 'LBL_NAME', 'source' => 'non-db', 'type' => 'varchar' ), 'transaction_type' => array ( 'name' => 'transaction_type', 'vname' => 'Typ transakcji', 'source' => 'non-db', 'options' => 'transaction_type3_dom', 'type' => 'enum', 'noeditable'=>true ), 'uploadfile' => array ( 'name' => 'uploadfile', 'required' => true, 'vname' => 'LBL_FILENAME', 'type' => 'file', ), 'active_date' => array ( 'name' => 'active_date', 'vname' => 'LBL_DOC_ACTIVE_DATE', 'type' => 'date', 'importable' => 'required', 'required' => true ), 'exp_date' => array ( 'name' => 'exp_date', 'vname' => 'LBL_DOC_EXP_DATE', 'type' => 'date' ), 'category_id' => array ( 'name' => 'category_id', 'vname' => 'LBL_SF_CATEGORY', 'type' => 'enum', 'len' => '45', 'options' => 'document_category_dom', 'reportable' => false ), 'subcategory_id' => array ( 'name' => 'subcategory_id', 'vname' => 'LBL_SF_SUBCATEGORY', 'type' => 'enum', 'len' => '25', 'options' => 'document_subcategory_dom', 'reportable' => false ), 'payment_date' => array ( 'name' => 'payment_date', 'vname' => 'LBL_PAYMENT_DATE', 'type' => 'date', 'reportable' => false, 'showFormats' => true, 'massupdate' => false, 'required' => false ), 'status_id' => array ( 'name' => 'status_id', 'vname' => 'LBL_DOC_STATUS', 'type' => 'enum', 'len' => '25', 'options' => 'document_status_dom', 'reportable' => false ), 'status' => array ( 'name' => 'status', 'vname' => 'LBL_DOC_STATUS', 'type' => 'varchar', 'source' => 'non-db', 'comment' => 'Document status for Meta-Data framework' ), 'document_revision_id' => array ( 'name' => 'document_revision_id', 'vname' => 'LBL_LATEST_REVISION', 'type' => 'varchar', 'len' => '36', 'reportable' => false ), 'revisions' => array ( 'name' => 'revisions', 'type' => 'link', 'relationship' => 'document_revisions', 'source' => 'non-db', 'vname' => 'LBL_REVISIONS' ), 'revision' => array ( 'name' => 'revision', 'vname' => 'LBL_DOC_VERSION', 'type' => 'varchar', 'reportable' => false, 'required' => true, 'source' => 'non-db', 'importable' => 'required', 'required' => true ), 'last_rev_created_name' => array ( 'name' => 'last_rev_created_name', 'vname' => 'LBL_LAST_REV_CREATOR', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'last_rev_mime_type' => array ( 'name' => 'last_rev_mime_type', 'vname' => 'LBL_LAST_REV_MIME_TYPE', 'type' => 'varchar', 'reportable' => false, 'studio' => 'false', 'source' => 'non-db' ), 'latest_revision' => array ( 'name' => 'latest_revision', 'vname' => 'LBL_LATEST_REVISION', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'last_rev_create_date' => array ( 'name' => 'last_rev_create_date', 'type' => 'date', 'table' => 'document_revisions', 'link' => 'revisions', 'join_name' => 'document_revisions', 'vname' => 'LBL_LAST_REV_CREATE_DATE', 'rname' => 'date_entered', 'reportable' => false, 'source' => 'non-db' ), 'contracts' => array ( 'name' => 'contracts', 'type' => 'link', 'relationship' => 'contracts_documents', 'source' => 'non-db', 'vname' => 'LBL_CONTRACTS' ), // todo remove 'leads' => array ( 'name' => 'leads', 'type' => 'link', 'relationship' => 'leads_documents', 'source' => 'non-db', 'vname' => 'LBL_LEADS' ), 'related_doc_id' => array ( 'name' => 'related_doc_id', 'vname' => 'LBL_RELATED_DOCUMENT_ID', 'reportable' => false, 'dbType' => 'id', 'type' => 'varchar', 'len' => '36' ), 'related_doc_name' => array ( 'name' => 'related_doc_name', 'vname' => 'LBL_DET_RELATED_DOCUMENT', 'type' => 'relate', 'table' => 'documents', 'id_name' => 'related_doc_id', 'module' => 'Documents', 'source' => 'non-db', 'comment' => 'The related document name for Meta-Data framework' ), 'related_doc_rev_id' => array ( 'name' => 'related_doc_rev_id', 'vname' => 'LBL_RELATED_DOCUMENT_REVISION_ID', 'reportable' => false, 'dbType' => 'id', 'type' => 'varchar', 'len' => '36' ), 'related_doc_rev_number' => array ( 'name' => 'related_doc_rev_number', 'vname' => 'LBL_DET_RELATED_DOCUMENT_VERSION', 'type' => 'varchar', 'source' => 'non-db', 'comment' => 'The related document version number for Meta-Data framework' ), 'is_template' => array ( 'name' => 'is_template', 'vname' => 'LBL_IS_TEMPLATE', 'type' => 'bool', 'default' => 0, 'reportable' => false ), 'accepted' => array ( 'name' => 'accepted', 'vname' => 'LBL_TO_ACCEPT', 'type' => 'enum', 'source' => 'non-db', 'default' => 0, 'options' => 'document_user_status_dom', 'reportable' => false ), 'date_start' => array ( 'name' => 'date_start', 'vname' => 'LBL_DATE_START', 'type' => 'date', 'source' => 'non-db', 'default' => 0, 'reportable' => false ), 'date_end' => array ( 'name' => 'date_end', 'vname' => 'LBL_DATE_END', 'type' => 'date', 'source' => 'non-db', 'default' => 0, 'reportable' => false ), 'template_type' => array ( 'name' => 'template_type', 'vname' => 'LBL_TEMPLATE_TYPE', 'type' => 'enum', 'len' => '25', 'options' => 'document_template_type_dom', 'reportable' => false ), // BEGIN field used for contract document subpanel. 'latest_revision_name' => array ( 'name' => 'latest_revision_name', 'vname' => 'LBL_LASTEST_REVISION_NAME', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'selected_revision_name' => array ( 'name' => 'selected_revision_name', 'vname' => 'LBL_SELECTED_REVISION_NAME', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'contract_status' => array ( 'name' => 'contract_status', 'vname' => 'LBL_CONTRACT_STATUS', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'contract_name' => array ( 'name' => 'contract_name', 'vname' => 'LBL_CONTRACT_NAME', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'linked_id' => array ( 'name' => 'linked_id', 'vname' => 'LBL_LINKED_ID', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'selected_revision_id' => array ( 'name' => 'selected_revision_id', 'vname' => 'LBL_SELECTED_REVISION_ID', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'latest_revision_id' => array ( 'name' => 'latest_revision_id', 'vname' => 'LBL_LATEST_REVISION_ID', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'selected_revision_filename' => array ( 'name' => 'selected_revision_filename', 'vname' => 'LBL_SELECTED_REVISION_FILENAME', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db' ), 'document_date' => array ( 'name' => 'document_date', 'vname' => 'LBL_DOCUMENT_DATE', 'type' => 'date', 'reportable' => false, 'showFormats' => true, 'massupdate' => false, 'required' => false ), 'register_date' => array ( 'name' => 'register_date', 'vname' => 'LBL_REGISTER_DATE', 'type' => 'date', 'reportable' => false, 'showFormats' => true, 'massupdate' => false, 'required' => false ), 'category' => array ( 'name' => 'category', 'vname' => 'LBL_CATEGORY', 'type' => 'enum', 'size' => '3', 'options' => 'ecminvoiceouts_category_dom', 'massupdate' => false ), 'document_number' => array( 'name' => 'document_number', 'vname' => 'LBL_DOCUMENT_NUMBER', 'type' => 'varchar', 'len' => '255', 'required' => false, 'importable' => 'required' ), // END fields used for contract documents subpanel. ), 'indices' => array ( array ( 'name' => 'idx_doc_cat', 'type' => 'index', 'fields' => array ( 'category_id', 'subcategory_id' ) ) ), 'relationships' => array ( 'document_revisions' => array ( 'lhs_module' => 'Documents', 'lhs_table' => 'documents', 'lhs_key' => 'id', 'rhs_module' => 'Documents', 'rhs_table' => 'document_revisions', 'rhs_key' => 'document_id', 'relationship_type' => 'one-to-many' ), 'documents_modified_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Documents', 'rhs_table' => 'documents', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many' ), 'documents_created_by' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Documents', 'rhs_table' => 'documents', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many' ) ) ); VardefManager::createVardef ( 'Documents', 'Document', array ( 'default' ) ); ?>