[ 'layout' => [ 'basic' => [ 'name', [ 'name' => 'current_user_only', 'label' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool', ], [ 'name' => 'favorites_only', 'label' => 'LBL_FAVORITES_FILTER', 'type' => 'bool', ], 'id' => [ 'name' => 'id', 'width' => '', 'label' => 'LBL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => 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', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'created_by_name' => [ 'name' => 'created_by_name', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, 'required' => false, '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', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'width' => '', 'label' => 'LBL_MODIFIED_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'width' => '', 'label' => 'LBL_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'created_by' => [ 'name' => 'created_by', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'description' => [ 'name' => 'description', 'width' => '', 'label' => 'LBL_DESCRIPTION', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'text', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, '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', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', 'required' => false, 'readonly' => false, ], ], 'created_by_link' => [ 'name' => 'created_by_link', 'width' => '', 'label' => 'LBL_CREATED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'aos_contracts_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'modified_user_link' => [ 'name' => 'modified_user_link', 'width' => '', 'label' => 'LBL_MODIFIED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'aos_contracts_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], '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', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', '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' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', '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' => 'aos_contracts_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', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'SecurityGroups' => [ 'name' => 'SecurityGroups', 'width' => '', 'label' => 'LBL_SECURITYGROUPS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_aos_contracts', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'securitygroup_id', 'type' => 'many-to-many', 'parent_id' => 'record_id', ], 'readonly' => false, ], ], 'reference_code' => [ 'name' => 'reference_code', 'width' => '', 'label' => 'LBL_REFERENCE_CODE ', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'reference_code', 'vname' => 'LBL_REFERENCE_CODE ', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20', 'readonly' => false, ], ], 'start_date' => [ 'name' => 'start_date', 'width' => '', 'label' => 'LBL_START_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'end_date' => [ 'name' => 'end_date', 'width' => '', 'label' => 'LBL_END_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'total_contract_value' => [ 'name' => 'total_contract_value', 'width' => '', 'label' => 'LBL_TOTAL_CONTRACT_VALUE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'width' => '', 'label' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'amount' => [ 'name' => 'amount', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'grouped-field', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'type' => 'grouped-field', 'name' => 'amount', 'legacyGroup' => true, 'groupFields' => [ 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'currency_id' => [ 'name' => 'currency_id', 'width' => '', 'label' => 'LBL_CURRENCY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], ], 'readonly' => false, ], ], 'status' => [ 'name' => 'status', 'width' => '', 'label' => 'LBL_STATUS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'customer_signed_date' => [ 'name' => 'customer_signed_date', 'width' => '', 'label' => 'LBL_CUSTOMER_SIGNED_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'customer_signed_date', 'vname' => 'LBL_CUSTOMER_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, 'readonly' => false, ], ], 'company_signed_date' => [ 'name' => 'company_signed_date', 'width' => '', 'label' => 'LBL_COMPANY_SIGNED_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'company_signed_date', 'vname' => 'LBL_COMPANY_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, 'readonly' => false, ], ], 'renewal_reminder_date' => [ 'name' => 'renewal_reminder_date', 'width' => '', 'label' => 'LBL_RENEWAL_REMINDER_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'renewal_reminder_date', 'vname' => 'LBL_RENEWAL_REMINDER_DATE', 'dbType' => 'datetime', 'type' => 'datetime', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'contract_type' => [ 'name' => 'contract_type', 'width' => '', 'label' => 'LBL_CONTRACT_TYPE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'contract_type', 'vname' => 'LBL_CONTRACT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Type', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_type_list', 'studio' => 'visible', 'dependency' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'contract_account_id' => [ 'name' => 'contract_account_id', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'contract_account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'contract_account' => [ 'name' => 'contract_account', 'width' => '', 'label' => 'LBL_CONTRACT_ACCOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', 'readonly' => false, ], ], 'opportunity_id' => [ 'name' => 'opportunity_id', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'opportunity_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'opportunity' => [ 'name' => 'opportunity', 'width' => '', 'label' => 'LBL_OPPORTUNITY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'opportunity', 'vname' => 'LBL_OPPORTUNITY', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'opportunity_id', 'ext2' => 'Opportunities', 'module' => 'Opportunities', 'quicksearch' => 'enabled', 'studio' => 'visible', 'readonly' => false, ], ], 'contact_id' => [ 'name' => 'contact_id', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'contact' => [ 'name' => 'contact', 'width' => '', 'label' => 'LBL_CONTACT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'contact', 'vname' => 'LBL_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible', 'readonly' => false, ], ], 'call_id' => [ 'name' => 'call_id', 'width' => '', 'label' => 'LBL_CALL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'call_id', 'vname' => 'LBL_CALL_ID', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'line_items' => [ 'name' => 'line_items', 'width' => '', 'label' => 'LBL_LINE_ITEMS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'function', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => [ 'name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'readonly' => false, ], ], 'total_amt' => [ 'name' => 'total_amt', 'width' => '', 'label' => 'LBL_TOTAL_AMT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'width' => '', 'label' => 'LBL_TOTAL_AMT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'subtotal_amount' => [ 'name' => 'subtotal_amount', 'width' => '', 'label' => 'LBL_SUBTOTAL_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'width' => '', 'label' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'discount_amount' => [ 'name' => 'discount_amount', 'width' => '', 'label' => 'LBL_DISCOUNT_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'width' => '', 'label' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'tax_amount' => [ 'name' => 'tax_amount', 'width' => '', 'label' => 'LBL_TAX_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'width' => '', 'label' => 'LBL_TAX_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'shipping_amount' => [ 'name' => 'shipping_amount', 'width' => '', 'label' => 'LBL_SHIPPING_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'width' => '', 'label' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'shipping_tax' => [ 'name' => 'shipping_tax', 'width' => '', 'label' => 'LBL_SHIPPING_TAX', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_tax', 'vname' => 'LBL_SHIPPING_TAX', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'vat_list', 'studio' => 'visible', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'shipping_tax_amt' => [ 'name' => 'shipping_tax_amt', 'width' => '', 'label' => 'LBL_SHIPPING_TAX_AMT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => [ 'name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'legacyGroup' => true, 'groupFields' => [ 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'width' => '', 'label' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'total_amount' => [ 'name' => 'total_amount', 'width' => '', 'label' => 'LBL_GRAND_TOTAL', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'legacyGroup' => true, 'groupFields' => [ 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'width' => '', 'label' => 'LBL_GRAND_TOTAL_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'accounts' => [ 'name' => 'accounts', 'width' => '', 'label' => 'LBL_ACCOUNTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'accounts', 'vname' => 'LBL_ACCOUNTS', 'type' => 'link', 'relationship' => 'account_aos_contracts', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'contacts' => [ 'name' => 'contacts', 'width' => '', 'label' => 'LBL_CONTACTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'contacts', 'vname' => 'LBL_CONTACTS', 'type' => 'link', 'relationship' => 'contact_aos_contracts', 'module' => 'Contacts', 'bean_name' => 'Contact', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'tasks' => [ 'name' => 'tasks', 'width' => '', 'label' => 'LBL_TASKS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'tasks', 'vname' => 'LBL_TASKS', 'type' => 'link', 'relationship' => 'aos_contracts_tasks', 'module' => 'Tasks', 'bean_name' => 'Task', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'notes' => [ 'name' => 'notes', 'width' => '', 'label' => 'LBL_NOTES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'notes', 'vname' => 'LBL_NOTES', 'type' => 'link', 'relationship' => 'aos_contracts_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'meetings' => [ 'name' => 'meetings', 'width' => '', 'label' => 'LBL_MEETINGS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'meetings', 'vname' => 'LBL_MEETINGS', 'type' => 'link', 'relationship' => 'aos_contracts_meetings', 'module' => 'Meetings', 'bean_name' => 'Meeting', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'calls' => [ 'name' => 'calls', 'width' => '', 'label' => 'LBL_CALLS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'calls', 'vname' => 'LBL_CALLS', 'type' => 'link', 'relationship' => 'aos_contracts_calls', 'module' => 'Calls', 'bean_name' => 'Call', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'emails' => [ 'name' => 'emails', 'width' => '', 'label' => 'LBL_EMAILS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'emails', 'vname' => 'LBL_EMAILS', 'type' => 'link', 'relationship' => 'emails_aos_contracts_rel', 'source' => 'non-db', 'required' => false, 'module' => 'Emails', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'email_id', 'type' => 'many-to-many', 'parent_id' => 'bean_id', ], 'readonly' => false, ], ], 'aos_quotes_aos_contracts' => [ 'name' => 'aos_quotes_aos_contracts', 'width' => '', 'label' => 'LBL_AOS_QUOTES_AOS_CONTRACTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_quotes_aos_contracts', 'vname' => 'LBL_AOS_QUOTES_AOS_CONTRACTS', 'type' => 'link', 'relationship' => 'aos_quotes_aos_contracts', 'source' => 'non-db', 'module' => 'AOS_Quotes', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'aos_quotese81e_quotes_ida', 'type' => 'many-to-many', 'parent_id' => 'aos_quotes4dc0ntracts_idb', ], 'readonly' => false, ], ], 'documents' => [ 'name' => 'documents', 'width' => '', 'label' => 'LBL_DOCUMENTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'documents', 'vname' => 'LBL_DOCUMENTS', 'type' => 'link', 'relationship' => 'aos_contracts_documents', 'source' => 'non-db', 'module' => 'Documents', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'documents_id', 'type' => 'many-to-many', 'parent_id' => 'aos_contracts_id', ], 'readonly' => false, ], ], 'aos_products_quotes' => [ 'name' => 'aos_products_quotes', 'width' => '', 'label' => 'LBL_AOS_PRODUCT_QUOTES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_products_quotes', 'vname' => 'LBL_AOS_PRODUCT_QUOTES', 'type' => 'link', 'relationship' => 'aos_contracts_aos_products_quotes', 'module' => 'AOS_Products_Quotes', 'bean_name' => 'AOS_Products_Quotes', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'aos_line_item_groups' => [ 'name' => 'aos_line_item_groups', 'width' => '', 'label' => 'LBL_AOS_LINE_ITEM_GROUPS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_line_item_groups', 'vname' => 'LBL_AOS_LINE_ITEM_GROUPS', 'type' => 'link', 'relationship' => 'aos_contracts_aos_line_item_groups', 'module' => 'AOS_Line_Item_Groups', 'bean_name' => 'AOS_Line_Item_Groups', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], ], 'advanced' => [ 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'contract_account' => [ 'name' => 'contract_account', 'width' => '', 'label' => 'LBL_CONTRACT_ACCOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'fieldDefinition' => [ 'required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'opportunity' => [ 'name' => 'opportunity', 'width' => '', 'label' => 'LBL_OPPORTUNITY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'opportunity', 'vname' => 'LBL_OPPORTUNITY', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'opportunity_id', 'ext2' => 'Opportunities', 'module' => 'Opportunities', 'quicksearch' => 'enabled', 'studio' => 'visible', 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'start_date' => [ 'name' => 'start_date', 'width' => '', 'label' => 'LBL_START_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'composite', 'fieldDefinition' => [ 'required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'layout' => [ 'operator', 'target', 'start', 'end', ], 'display' => 'inline', 'attributeFields' => [ 'operator' => [ 'name' => 'operator', 'type' => 'enum', 'vname' => 'LBL_OPERATOR', 'options' => 'date_range_search_dom', 'default' => '=', 'defaultValueModes' => [ 'filter', 'edit', ], ], 'target' => [ 'name' => 'target', 'type' => 'date', 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'start_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'start_date' => [ 'operator' => [ '=', 'not_equal', 'greater_than', 'less_than', ], ], ], ], ], ], ], 'start' => [ 'name' => 'start', 'type' => 'date', 'vname' => 'LBL_START', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'start_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'start_date' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], 'end' => [ 'name' => 'end', 'type' => 'date', 'vname' => 'LBL_END', 'labelKey' => 'LBL_END', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'start_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'start_date' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'end_date' => [ 'name' => 'end_date', 'width' => '', 'label' => 'LBL_END_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'composite', 'fieldDefinition' => [ 'required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'layout' => [ 'operator', 'target', 'start', 'end', ], 'display' => 'inline', 'attributeFields' => [ 'operator' => [ 'name' => 'operator', 'type' => 'enum', 'vname' => 'LBL_OPERATOR', 'options' => 'date_range_search_dom', 'default' => '=', 'defaultValueModes' => [ 'filter', 'edit', ], ], 'target' => [ 'name' => 'target', 'type' => 'date', 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'end_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'end_date' => [ 'operator' => [ '=', 'not_equal', 'greater_than', 'less_than', ], ], ], ], ], ], ], 'start' => [ 'name' => 'start', 'type' => 'date', 'vname' => 'LBL_START', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'end_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'end_date' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], 'end' => [ 'name' => 'end', 'type' => 'date', 'vname' => 'LBL_END', 'labelKey' => 'LBL_END', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'end_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'end_date' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'total_contract_value' => [ 'name' => 'total_contract_value', 'width' => '', 'label' => 'LBL_TOTAL_CONTRACT_VALUE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'fieldDefinition' => [ 'required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'status' => [ 'name' => 'status', 'width' => '', 'label' => 'LBL_STATUS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'fieldDefinition' => [ 'required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'contract_type' => [ 'name' => 'contract_type', 'width' => '', 'label' => 'LBL_CONTRACT_TYPE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'fieldDefinition' => [ 'required' => false, 'name' => 'contract_type', 'vname' => 'LBL_CONTRACT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Type', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_type_list', 'studio' => 'visible', 'dependency' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'assigned_user_id-group' => [ 'name' => 'assigned_user_id-group', 'label' => 'LBL_ASSIGNED_TO_NAME', 'type' => 'grouped-field', 'function' => [ 'name' => 'get_user_array', 'params' => [ false, ], ], 'fieldDefinition' => [ 'layout' => [ 'assigned_user_name', ], 'display' => 'inline', 'type' => 'grouped-field', 'groupKey' => 'assigned_user', 'groupFields' => [ 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user', 'type' => 'id', 'table' => 'users', 'module' => 'Users', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'required' => false, 'showLabel' => [], 'display' => 'none', ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, 'showLabel' => [ '*', ], 'display' => 'inline', 'group' => 'assigned_user', ], ], 'readonly' => false, ], ], 'id' => [ 'name' => 'id', 'width' => '', 'label' => 'LBL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, 'readonly' => false, ], ], 'date_entered' => [ 'name' => 'date_entered', 'width' => '', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'composite', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'layout' => [ 'operator', 'target', 'start', 'end', ], 'display' => 'inline', 'attributeFields' => [ 'operator' => [ 'name' => 'operator', 'type' => 'enum', 'vname' => 'LBL_OPERATOR', 'options' => 'date_range_search_dom', 'default' => '=', 'defaultValueModes' => [ 'filter', 'edit', ], ], 'target' => [ 'name' => 'target', 'type' => 'datetime', 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'date_entered', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'date_entered' => [ 'operator' => [ '=', 'not_equal', 'greater_than', 'less_than', ], ], ], ], ], ], ], 'start' => [ 'name' => 'start', 'type' => 'datetime', 'vname' => 'LBL_START', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'date_entered', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'date_entered' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], 'end' => [ 'name' => 'end', 'type' => 'datetime', 'vname' => 'LBL_END', 'labelKey' => 'LBL_END', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'date_entered', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'date_entered' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], ], 'readonly' => false, ], ], 'created_by_name' => [ 'name' => 'created_by_name', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'date_modified' => [ 'name' => 'date_modified', 'width' => '', 'label' => 'LBL_DATE_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'composite', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'layout' => [ 'operator', 'target', 'start', 'end', ], 'display' => 'inline', 'attributeFields' => [ 'operator' => [ 'name' => 'operator', 'type' => 'enum', 'vname' => 'LBL_OPERATOR', 'options' => 'date_range_search_dom', 'default' => '=', 'defaultValueModes' => [ 'filter', 'edit', ], ], 'target' => [ 'name' => 'target', 'type' => 'datetime', 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'date_modified', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'date_modified' => [ 'operator' => [ '=', 'not_equal', 'greater_than', 'less_than', ], ], ], ], ], ], ], 'start' => [ 'name' => 'start', 'type' => 'datetime', 'vname' => 'LBL_START', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'date_modified', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'date_modified' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], 'end' => [ 'name' => 'end', 'type' => 'datetime', 'vname' => 'LBL_END', 'labelKey' => 'LBL_END', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'date_modified', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'date_modified' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], ], 'readonly' => false, ], ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'width' => '', 'label' => 'LBL_MODIFIED_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'width' => '', 'label' => 'LBL_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'created_by' => [ 'name' => 'created_by', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'description' => [ 'name' => 'description', 'width' => '', 'label' => 'LBL_DESCRIPTION', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'text', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, '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', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', 'required' => false, 'readonly' => false, ], ], 'created_by_link' => [ 'name' => 'created_by_link', 'width' => '', 'label' => 'LBL_CREATED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'aos_contracts_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'modified_user_link' => [ 'name' => 'modified_user_link', 'width' => '', 'label' => 'LBL_MODIFIED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'aos_contracts_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], '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', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', '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' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', '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' => 'aos_contracts_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', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'SecurityGroups' => [ 'name' => 'SecurityGroups', 'width' => '', 'label' => 'LBL_SECURITYGROUPS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_aos_contracts', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'securitygroup_id', 'type' => 'many-to-many', 'parent_id' => 'record_id', ], 'readonly' => false, ], ], 'reference_code' => [ 'name' => 'reference_code', 'width' => '', 'label' => 'LBL_REFERENCE_CODE ', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'reference_code', 'vname' => 'LBL_REFERENCE_CODE ', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20', 'readonly' => false, ], ], 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'width' => '', 'label' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'amount' => [ 'name' => 'amount', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'grouped-field', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'type' => 'grouped-field', 'name' => 'amount', 'legacyGroup' => true, 'groupFields' => [ 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'currency_id' => [ 'name' => 'currency_id', 'width' => '', 'label' => 'LBL_CURRENCY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], ], 'readonly' => false, ], ], 'customer_signed_date' => [ 'name' => 'customer_signed_date', 'width' => '', 'label' => 'LBL_CUSTOMER_SIGNED_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'customer_signed_date', 'vname' => 'LBL_CUSTOMER_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, 'readonly' => false, ], ], 'company_signed_date' => [ 'name' => 'company_signed_date', 'width' => '', 'label' => 'LBL_COMPANY_SIGNED_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'company_signed_date', 'vname' => 'LBL_COMPANY_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, 'readonly' => false, ], ], 'renewal_reminder_date' => [ 'name' => 'renewal_reminder_date', 'width' => '', 'label' => 'LBL_RENEWAL_REMINDER_DATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'composite', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'renewal_reminder_date', 'vname' => 'LBL_RENEWAL_REMINDER_DATE', 'dbType' => 'datetime', 'type' => 'datetime', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'layout' => [ 'operator', 'target', 'start', 'end', ], 'display' => 'inline', 'attributeFields' => [ 'operator' => [ 'name' => 'operator', 'type' => 'enum', 'vname' => 'LBL_OPERATOR', 'options' => 'date_range_search_dom', 'default' => '=', 'defaultValueModes' => [ 'filter', 'edit', ], ], 'target' => [ 'name' => 'target', 'type' => 'datetime', 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'renewal_reminder_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'renewal_reminder_date' => [ 'operator' => [ '=', 'not_equal', 'greater_than', 'less_than', ], ], ], ], ], ], ], 'start' => [ 'name' => 'start', 'type' => 'datetime', 'vname' => 'LBL_START', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'renewal_reminder_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'renewal_reminder_date' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], 'end' => [ 'name' => 'end', 'type' => 'datetime', 'vname' => 'LBL_END', 'labelKey' => 'LBL_END', 'showLabel' => [ '*', ], 'display' => 'none', 'logic' => [ 'display' => [ 'key' => 'displayType', 'modes' => [ 'edit', 'detail', 'create', 'filter', ], 'params' => [ 'attributeDependencies' => [ [ 'field' => 'renewal_reminder_date', 'attribute' => 'operator', ], ], 'targetDisplayType' => 'default', 'activeOnAttributes' => [ 'renewal_reminder_date' => [ 'operator' => [ 'between', ], ], ], ], ], ], ], ], 'readonly' => false, ], ], 'contract_account_id' => [ 'name' => 'contract_account_id', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'contract_account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'opportunity_id' => [ 'name' => 'opportunity_id', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'opportunity_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'contact_id' => [ 'name' => 'contact_id', 'width' => '', 'label' => '', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'contact' => [ 'name' => 'contact', 'width' => '', 'label' => 'LBL_CONTACT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'contact', 'vname' => 'LBL_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible', 'readonly' => false, ], ], 'call_id' => [ 'name' => 'call_id', 'width' => '', 'label' => 'LBL_CALL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'call_id', 'vname' => 'LBL_CALL_ID', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'readonly' => false, ], ], 'line_items' => [ 'name' => 'line_items', 'width' => '', 'label' => 'LBL_LINE_ITEMS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'function', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => [ 'name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'readonly' => false, ], ], 'total_amt' => [ 'name' => 'total_amt', 'width' => '', 'label' => 'LBL_TOTAL_AMT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'width' => '', 'label' => 'LBL_TOTAL_AMT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'subtotal_amount' => [ 'name' => 'subtotal_amount', 'width' => '', 'label' => 'LBL_SUBTOTAL_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'width' => '', 'label' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'discount_amount' => [ 'name' => 'discount_amount', 'width' => '', 'label' => 'LBL_DISCOUNT_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'width' => '', 'label' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'tax_amount' => [ 'name' => 'tax_amount', 'width' => '', 'label' => 'LBL_TAX_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'width' => '', 'label' => 'LBL_TAX_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'shipping_amount' => [ 'name' => 'shipping_amount', 'width' => '', 'label' => 'LBL_SHIPPING_AMOUNT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'width' => '', 'label' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'shipping_tax' => [ 'name' => 'shipping_tax', 'width' => '', 'label' => 'LBL_SHIPPING_TAX', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_tax', 'vname' => 'LBL_SHIPPING_TAX', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'vat_list', 'studio' => 'visible', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'shipping_tax_amt' => [ 'name' => 'shipping_tax_amt', 'width' => '', 'label' => 'LBL_SHIPPING_TAX_AMT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => [ 'name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'legacyGroup' => true, 'groupFields' => [ 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'readonly' => false, ], ], 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'width' => '', 'label' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'total_amount' => [ 'name' => 'total_amount', 'width' => '', 'label' => 'LBL_GRAND_TOTAL', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'legacyGroup' => true, 'groupFields' => [ 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'width' => '', 'label' => 'LBL_GRAND_TOTAL_USDOLLAR', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'readonly' => false, ], ], 'accounts' => [ 'name' => 'accounts', 'width' => '', 'label' => 'LBL_ACCOUNTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'accounts', 'vname' => 'LBL_ACCOUNTS', 'type' => 'link', 'relationship' => 'account_aos_contracts', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'contacts' => [ 'name' => 'contacts', 'width' => '', 'label' => 'LBL_CONTACTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'contacts', 'vname' => 'LBL_CONTACTS', 'type' => 'link', 'relationship' => 'contact_aos_contracts', 'module' => 'Contacts', 'bean_name' => 'Contact', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'tasks' => [ 'name' => 'tasks', 'width' => '', 'label' => 'LBL_TASKS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'tasks', 'vname' => 'LBL_TASKS', 'type' => 'link', 'relationship' => 'aos_contracts_tasks', 'module' => 'Tasks', 'bean_name' => 'Task', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'notes' => [ 'name' => 'notes', 'width' => '', 'label' => 'LBL_NOTES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'notes', 'vname' => 'LBL_NOTES', 'type' => 'link', 'relationship' => 'aos_contracts_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'meetings' => [ 'name' => 'meetings', 'width' => '', 'label' => 'LBL_MEETINGS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'meetings', 'vname' => 'LBL_MEETINGS', 'type' => 'link', 'relationship' => 'aos_contracts_meetings', 'module' => 'Meetings', 'bean_name' => 'Meeting', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'calls' => [ 'name' => 'calls', 'width' => '', 'label' => 'LBL_CALLS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'calls', 'vname' => 'LBL_CALLS', 'type' => 'link', 'relationship' => 'aos_contracts_calls', 'module' => 'Calls', 'bean_name' => 'Call', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'emails' => [ 'name' => 'emails', 'width' => '', 'label' => 'LBL_EMAILS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'emails', 'vname' => 'LBL_EMAILS', 'type' => 'link', 'relationship' => 'emails_aos_contracts_rel', 'source' => 'non-db', 'required' => false, 'module' => 'Emails', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'email_id', 'type' => 'many-to-many', 'parent_id' => 'bean_id', ], 'readonly' => false, ], ], 'aos_quotes_aos_contracts' => [ 'name' => 'aos_quotes_aos_contracts', 'width' => '', 'label' => 'LBL_AOS_QUOTES_AOS_CONTRACTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_quotes_aos_contracts', 'vname' => 'LBL_AOS_QUOTES_AOS_CONTRACTS', 'type' => 'link', 'relationship' => 'aos_quotes_aos_contracts', 'source' => 'non-db', 'module' => 'AOS_Quotes', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'aos_quotese81e_quotes_ida', 'type' => 'many-to-many', 'parent_id' => 'aos_quotes4dc0ntracts_idb', ], 'readonly' => false, ], ], 'documents' => [ 'name' => 'documents', 'width' => '', 'label' => 'LBL_DOCUMENTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'documents', 'vname' => 'LBL_DOCUMENTS', 'type' => 'link', 'relationship' => 'aos_contracts_documents', 'source' => 'non-db', 'module' => 'Documents', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'documents_id', 'type' => 'many-to-many', 'parent_id' => 'aos_contracts_id', ], 'readonly' => false, ], ], 'aos_products_quotes' => [ 'name' => 'aos_products_quotes', 'width' => '', 'label' => 'LBL_AOS_PRODUCT_QUOTES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_products_quotes', 'vname' => 'LBL_AOS_PRODUCT_QUOTES', 'type' => 'link', 'relationship' => 'aos_contracts_aos_products_quotes', 'module' => 'AOS_Products_Quotes', 'bean_name' => 'AOS_Products_Quotes', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'aos_line_item_groups' => [ 'name' => 'aos_line_item_groups', 'width' => '', 'label' => 'LBL_AOS_LINE_ITEM_GROUPS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_line_item_groups', 'vname' => 'LBL_AOS_LINE_ITEM_GROUPS', 'type' => 'link', 'relationship' => 'aos_contracts_aos_line_item_groups', 'module' => 'AOS_Line_Item_Groups', 'bean_name' => 'AOS_Line_Item_Groups', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'current_user_only' => [ 'name' => 'current_user_only', 'label' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool', 'fieldDefinition' => [ 'displayType' => 'checkbox', 'readonly' => false, ], ], 'favorites_only' => [ 'name' => 'favorites_only', 'label' => 'LBL_FAVORITES_FILTER', 'type' => 'bool', 'fieldDefinition' => [ 'displayType' => 'checkbox', 'readonly' => false, ], ], ], ], ], 'mass_update' => [ 'fields' => [ [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_TO_NAME', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], 'listview' => [ 'columns' => [ [ 'name' => 'name', 'width' => '15%', 'label' => 'LBL_NAME', 'link' => true, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', ], ], [ 'name' => 'status', 'width' => '10%', 'label' => 'LBL_STATUS', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => false, 'type' => 'enum', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false, ], ], [ 'name' => 'assigned_user_name', 'width' => '10%', 'label' => 'LBL_ASSIGNED_TO_NAME', 'link' => true, 'default' => true, 'module' => 'Users', 'id' => 'ASSIGNED_USER_ID', 'sortable' => true, 'type' => 'relate', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], ], [ 'name' => 'contract_account', 'width' => '15%', 'label' => 'LBL_CONTRACT_ACCOUNT', 'link' => true, 'default' => true, 'module' => 'Accounts', 'id' => 'CONTRACT_ACCOUNT_ID', 'sortable' => true, 'type' => 'relate', 'related_fields' => [ 'contract_account_id', ], 'fieldDefinition' => [ 'required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], ], [ 'name' => 'total_contract_value', 'width' => '10%', 'label' => 'LBL_TOTAL_CONTRACT_VALUE', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'currency', 'currency_format' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', ], ], [ 'name' => 'start_date', 'width' => '10%', 'label' => 'LBL_START_DATE', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'fieldDefinition' => [ 'required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now', ], ], [ 'name' => 'end_date', 'width' => '10%', 'label' => 'LBL_END_DATE', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'date', 'fieldDefinition' => [ 'required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year', ], ], [ 'name' => 'date_entered', 'width' => '5%', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => 0, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, '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', ], ], 'merge' => [ 'key' => 'merge', 'labelKey' => 'LBL_MERGE_DUPLICATES', 'params' => [ 'min' => 2, 'max' => 5, ], 'acl' => [ 'edit', 'delete', ], ], 'massupdate' => [ 'key' => 'massupdate', 'labelKey' => 'LBL_MASS_UPDATE', 'params' => [ 'allowAll' => false, 'min' => 2, 'max' => 200, 'recordPanel' => [ 'title' => 'LBL_MASS_UPDATE', 'mode' => 'massupdate', 'actions' => [ [ 'key' => 'cancel', 'labelKey' => 'LBL_CANCEL', 'modes' => [ 'massupdate', ], ], [ 'key' => 'bulk-action', 'labelKey' => 'LBL_SUBMIT_BUTTON_LABEL', 'modes' => [ 'massupdate', ], 'klass' => [ 'btn', 'btn-danger', 'btn-sm', ], 'params' => [ 'allowAll' => false, 'min' => 2, 'max' => 200, 'bulkAction' => 'massupdate', 'displayConfirmation' => true, 'confirmationMessages' => [ 'LBL_BULK_ACTION_MASS_UPDATE_CONFIRMATION', ], ], ], ], 'fields' => [ [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_TO_NAME', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], ], 'acl' => [ 'massupdate', ], 'availability' => [ 'acls', 'massupdate', ], ], ], 'lineActions' => [ [ 'key' => 'create', 'acl' => [ 'edit', ], 'name' => 'create-calls', 'module' => 'calls', 'icon' => 'phone', 'labelKey' => 'LBL_SCHEDULE_CALL', 'params' => [ 'create' => [ 'module' => 'calls', 'returnAction' => 'DetailView', 'mapping' => [ 'moduleName' => 'parent_type', 'name' => 'parent_name', 'id' => 'parent_id', ], 'legacyModuleName' => 'AOS_Contracts', 'action' => 'edit', ], ], 'mapping' => [ 'moduleName' => 'parent_type', 'name' => 'parent_name', 'id' => 'parent_id', ], 'legacyModuleName' => 'AOS_Contracts', 'action' => 'edit', 'modes' => [ 'list', ], ], [ 'key' => 'create', 'acl' => [ 'edit', ], 'name' => 'create-meetings', 'module' => 'meetings', 'icon' => 'calendar', 'labelKey' => 'LBL_SCHEDULE_MEETING', 'params' => [ 'create' => [ 'module' => 'meetings', 'returnAction' => 'DetailView', 'mapping' => [ 'moduleName' => 'parent_type', 'name' => 'parent_name', 'id' => 'parent_id', ], 'legacyModuleName' => 'AOS_Contracts', 'action' => 'edit', ], ], 'mapping' => [ 'moduleName' => 'parent_type', 'name' => 'parent_name', 'id' => 'parent_id', ], 'legacyModuleName' => 'AOS_Contracts', 'action' => 'edit', 'modes' => [ 'list', ], ], [ 'key' => 'create', 'acl' => [ 'edit', ], 'name' => 'create-tasks', 'module' => 'tasks', 'icon' => 'list', 'labelKey' => 'LBL_CREATE_TASK', 'params' => [ 'create' => [ 'module' => 'tasks', 'returnAction' => 'DetailView', 'mapping' => [ 'moduleName' => 'parent_type', 'name' => 'parent_name', 'id' => 'parent_id', ], 'legacyModuleName' => 'AOS_Contracts', 'action' => 'edit', ], ], 'mapping' => [ 'moduleName' => 'parent_type', 'name' => 'parent_name', 'id' => 'parent_id', ], 'legacyModuleName' => 'AOS_Contracts', 'action' => 'edit', 'modes' => [ 'list', ], ], [ 'key' => 'modal-create', 'acl' => [ 'edit', ], 'name' => 'create-emails', 'module' => 'emails', 'icon' => 'email', 'labelKey' => 'LBL_COMPOSE_EMAIL_BUTTON_LABEL', 'modes' => [ 'list', ], 'metadataView' => 'modalComposeView', 'params' => [ 'closeConfirmationModal' => true, 'closeConfirmationLabel' => 'LBL_CLOSE_EMAIL_MODAL', 'detached' => true, 'headerClass' => 'left-aligned-title', 'dynamicTitleKey' => 'LBL_EMAIL_MODAL_DYNAMIC_TITLE', 'modalOptions' => [ 'size' => 'lg', 'scrollable' => false, ], 'mapFields' => [ 'default' => [ 'parent_id' => 'id', 'parent_name' => 'fields.name', 'parent_type' => 'attributes.module_name', 'to_addrs_names' => [ [ 'id' => 'id', 'name' => 'fields.name', 'email1' => 'attributes.email1', 'module_name' => 'attributes.module_name', ], ], ], ], ], 'mapping' => [], 'legacyModuleName' => 'AOS_Contracts', 'action' => 'modal-create', ], ], 'tableActions' => [ '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' => [ 'aos_contracts_documents' => [ 'order' => 100, 'module' => 'documents', 'subpanel_name' => 'default', 'sort_order' => 'asc', 'sort_by' => 'id', 'title_key' => 'Documents', 'get_subpanel_data' => 'documents', 'top_buttons' => [ [ 'key' => 'create', 'labelKey' => 'LBL_QUICK_CREATE', 'action' => 'create', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [ 'aos_contracts_id' => 'id', 'aos_contracts_name' => 'name', 'return_name' => 'name', 'aos_contracts_documents_name' => 'name', 'return_id' => 'id', 'parent_name' => 'name', 'parent_id' => 'id', ], 'extraParams' => [ 'target_module' => 'documents', 'return_module' => 'AOS_Contracts', 'return_relationship' => 'aos_contracts_documents', 'parent_type' => 'AOS_Contracts', ], 'widget_class' => 'SubPanelTopButtonQuickCreate', 'relateFields' => [], ], [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'icon' => 'Documents', 'name' => 'aos_contracts_documents', 'legacyModule' => 'Documents', 'headerModule' => 'documents', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'Documents', ], [ 'labelKey' => 'Documents', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT_RECORD', 'action' => 'edit', 'icon' => 'edit', 'asyncProcess' => true, 'routing' => true, 'params' => null, 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'documents', ], [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'documents', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'document_name', 'label' => 'LBL_LIST_DOCUMENT_NAME', 'sortable' => true, 'vname' => 'LBL_LIST_DOCUMENT_NAME', 'widget_class' => 'SubPanelDetailViewLink', 'width' => '20%', 'link' => true, 'fieldDefinition' => [ 'name' => 'document_name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'required' => true, 'importable' => 'required', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], ], 'type' => 'varchar', ], [ 'name' => 'filename', 'label' => 'LBL_LIST_FILENAME', 'sortable' => false, 'vname' => 'LBL_LIST_FILENAME', 'width' => '20%', 'module' => 'Documents', 'displayParams' => [ 'module' => 'Documents', ], 'fieldDefinition' => [ 'name' => 'filename', 'vname' => 'LBL_FILENAME', 'type' => 'file', 'source' => 'non-db', 'comment' => 'The filename of the document attachment', 'required' => true, 'noChange' => true, 'allowEapm' => true, 'fileId' => 'document_revision_id', 'docType' => 'doc_type', 'docUrl' => 'doc_url', 'docId' => 'doc_id', 'metadata' => [ 'allow_duplicate' => false, ], ], 'type' => 'file', ], [ 'name' => 'category_id', 'label' => 'LBL_LIST_CATEGORY', 'sortable' => true, 'vname' => 'LBL_LIST_CATEGORY', 'width' => '20%', 'fieldDefinition' => [ 'name' => 'category_id', 'vname' => 'LBL_SF_CATEGORY', 'type' => 'enum', 'len' => 100, 'options' => 'document_category_dom', 'reportable' => true, 'required' => false, ], 'type' => 'enum', ], [ 'name' => 'status_id', 'label' => 'LBL_LIST_STATUS', 'sortable' => true, 'vname' => 'LBL_LIST_STATUS', 'width' => '10%', 'fieldDefinition' => [ 'name' => 'status_id', 'vname' => 'LBL_DOC_STATUS', 'type' => 'enum', 'len' => 100, 'options' => 'document_status_dom', 'reportable' => false, 'required' => false, ], 'type' => 'enum', ], [ 'name' => 'active_date', 'label' => 'LBL_LIST_ACTIVE_DATE', 'sortable' => true, 'vname' => 'LBL_LIST_ACTIVE_DATE', 'width' => '10%', 'fieldDefinition' => [ 'name' => 'active_date', 'vname' => 'LBL_DOC_ACTIVE_DATE', 'type' => 'date', 'importable' => 'required', 'required' => true, 'display_default' => 'now', ], 'type' => 'date', ], ], ], 'aos_quotes_aos_contracts' => [ 'order' => 100, 'module' => 'quotes', 'subpanel_name' => 'default', 'sort_order' => 'asc', 'sort_by' => 'id', 'title_key' => 'AOS_Quotes', 'get_subpanel_data' => 'aos_quotes_aos_contracts', 'top_buttons' => [ [ 'key' => 'create', 'labelKey' => 'LBL_QUICK_CREATE', 'action' => 'create', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [ 'aos_contracts_id' => 'id', 'aos_contracts_name' => 'name', 'return_name' => 'name', 'aos_quotes_aos_contracts_name' => 'name', 'return_id' => 'id', 'parent_name' => 'name', 'parent_id' => 'id', ], 'extraParams' => [ 'target_module' => 'quotes', 'return_module' => 'AOS_Contracts', 'return_relationship' => 'aos_quotes_aos_contracts', 'parent_type' => 'AOS_Contracts', ], 'widget_class' => 'SubPanelTopCreateButton', 'relateFields' => [], ], [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'icon' => 'AOS_Quotes', 'name' => 'aos_quotes_aos_contracts', 'legacyModule' => 'AOS_Quotes', 'headerModule' => 'quotes', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'AOS_Quotes', ], [ 'labelKey' => 'AOS_Quotes', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT_RECORD', 'action' => 'edit', 'icon' => 'edit', 'asyncProcess' => true, 'routing' => true, 'params' => null, 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'quotes', ], [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'quotes', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'number', 'label' => 'LBL_LIST_NUM', 'sortable' => true, 'width' => '5%', 'vname' => 'LBL_LIST_NUM', 'default' => true, 'fieldDefinition' => [ 'name' => 'number', 'vname' => 'LBL_QUOTE_NUMBER', 'type' => 'int', 'len' => 11, 'isnull' => 'false', 'unified_search' => true, 'comments' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'reportable' => true, 'disable_num_format' => true, 'required' => false, 'metadata' => [ 'format' => false, ], ], 'type' => 'int', ], [ 'name' => 'name', 'label' => 'LBL_NAME', 'sortable' => true, 'vname' => 'LBL_NAME', 'widget_class' => 'SubPanelDetailViewLink', 'width' => '25%', 'default' => true, 'link' => true, 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', ], 'type' => 'name', ], [ 'name' => 'billing_account', 'label' => 'LBL_BILLING_ACCOUNT', 'sortable' => true, 'width' => '20%', 'vname' => 'LBL_BILLING_ACCOUNT', 'default' => true, 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'billing_account', 'vname' => 'LBL_BILLING_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'billing_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'type' => 'relate', ], [ 'name' => 'total_amount', 'label' => 'LBL_GRAND_TOTAL', 'sortable' => true, 'type' => 'currency', 'width' => '15%', 'currency_format' => true, 'vname' => 'LBL_GRAND_TOTAL', 'default' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'legacyGroup' => true, 'groupFields' => [ 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], ], [ 'name' => 'expiration', 'label' => 'LBL_EXPIRATION', 'sortable' => true, 'width' => '15%', 'vname' => 'LBL_EXPIRATION', 'default' => true, 'fieldDefinition' => [ 'required' => '1', 'name' => 'expiration', 'vname' => 'LBL_EXPIRATION', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'display_default' => '+ 1 month', 'enable_range_search' => true, 'options' => 'date_range_search_dom', ], 'type' => 'date', ], [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_USER', 'sortable' => true, 'link' => 'assigned_user_link', 'type' => 'relate', 'vname' => 'LBL_ASSIGNED_USER', 'width' => '15%', 'default' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], ], ], ], ], 'recordview' => [ 'header' => [ 'backButton' => [ 'display' => true, ], ], 'templateMeta' => [ 'maxColumns' => '2', 'useTabs' => true, 'tabDefs' => [ 'DEFAULT' => [ 'newTab' => true, 'panelDefault' => 'expanded', ], 'LBL_LINE_ITEMS' => [ 'newTab' => true, 'panelDefault' => 'expanded', ], 'LBL_PANEL_ASSIGNMENT' => [ 'newTab' => true, 'panelDefault' => 'expanded', ], ], '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' => 'audit', 'labelKey' => 'LNK_VIEW_CHANGE_LOG', 'priority' => 1800, 'asyncProcess' => true, 'params' => null, 'modes' => [ 'detail', 'edit', ], 'availability' => [ 'audited', 'acls', ], ], [ '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' => [ [ 'key' => 'default', 'rows' => [ [ 'cols' => [ [ 'name' => 'name', 'label' => 'LBL_NAME', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', ], 'type' => 'name', ], [ 'name' => 'status', 'label' => 'LBL_STATUS', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false, ], 'type' => 'enum', ], ], ], [ 'cols' => [ [ 'name' => 'total_contract_value-group', 'type' => 'grouped-field', 'label' => 'LBL_TOTAL_CONTRACT_VALUE', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'total_contract_value', 'total_contract_value_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'total_contract_value' => [ 'required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'total_contract_value_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'total_contract_value', ], 'currencyField' => 'total_contract_value', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_TO_NAME', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'start_date', 'label' => 'LBL_START_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now', ], 'type' => 'date', ], [ 'name' => 'contract_account', 'label' => 'LBL_CONTRACT_ACCOUNT', 'fieldDefinition' => [ 'required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'end_date', 'label' => 'LBL_END_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year', ], 'type' => 'date', ], [ 'name' => 'contact', 'label' => 'LBL_CONTACT', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'contact', 'vname' => 'LBL_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'renewal_reminder_date', 'label' => 'LBL_RENEWAL_REMINDER_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'renewal_reminder_date', 'vname' => 'LBL_RENEWAL_REMINDER_DATE', 'dbType' => 'datetime', 'type' => 'datetime', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', ], 'type' => 'datetime', ], [ 'name' => 'opportunity', 'label' => 'LBL_OPPORTUNITY', 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'opportunity', 'vname' => 'LBL_OPPORTUNITY', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'opportunity_id', 'ext2' => 'Opportunities', 'module' => 'Opportunities', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'customer_signed_date', 'label' => 'LBL_CUSTOMER_SIGNED_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'customer_signed_date', 'vname' => 'LBL_CUSTOMER_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'type' => 'date', ], [ 'name' => 'contract_type', 'label' => 'LBL_CONTRACT_TYPE', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => false, 'name' => 'contract_type', 'vname' => 'LBL_CONTRACT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Type', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_type_list', 'studio' => 'visible', 'dependency' => false, ], 'type' => 'enum', ], ], ], [ 'cols' => [ [ 'name' => 'company_signed_date', 'label' => 'LBL_COMPANY_SIGNED_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'company_signed_date', 'vname' => 'LBL_COMPANY_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'type' => 'date', ], [ 'name' => '', 'fieldDefinition' => [], ], ], ], [ 'cols' => [ [ 'name' => 'description', 'label' => 'LBL_DESCRIPTION', 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], 'type' => 'text', ], ], ], ], ], [ 'key' => 'lbl_line_items', 'rows' => [ [ 'cols' => [ [ 'name' => 'currency_id', 'label' => 'LBL_CURRENCY', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], ], ], 'type' => 'id', ], ], ], [ 'cols' => [ [ 'name' => 'line_items', 'label' => 'LBL_LINE_ITEMS', 'fieldDefinition' => [ 'required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => [ 'name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], ], 'type' => 'function', ], ], ], [ 'cols' => [ [ 'name' => '', 'fieldDefinition' => [], ], [ 'name' => '', 'fieldDefinition' => [], ], ], ], [ 'cols' => [ [ 'name' => 'total_amt-group', 'type' => 'grouped-field', 'label' => 'LBL_TOTAL_AMT', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'total_amt', 'total_amt_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'total_amt' => [ 'required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'total_amt_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'total_amt', ], 'currencyField' => 'total_amt', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], ], ], [ 'cols' => [ [ 'name' => 'discount_amount-group', 'type' => 'grouped-field', 'label' => 'LBL_DISCOUNT_AMOUNT', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'discount_amount', 'discount_amount_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'discount_amount' => [ 'required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'discount_amount_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'discount_amount', ], 'currencyField' => 'discount_amount', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], ], ], [ 'cols' => [ [ 'name' => 'subtotal_amount-group', 'type' => 'grouped-field', 'label' => 'LBL_SUBTOTAL_AMOUNT', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'subtotal_amount', 'subtotal_amount_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'subtotal_amount' => [ 'required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'subtotal_amount_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'subtotal_amount', ], 'currencyField' => 'subtotal_amount', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], ], ], [ 'cols' => [ [ 'name' => 'shipping_amount-group', 'type' => 'grouped-field', 'label' => 'LBL_SHIPPING_AMOUNT', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'shipping_amount', 'shipping_amount_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'shipping_amount' => [ 'required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'shipping_amount_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'shipping_amount', ], 'currencyField' => 'shipping_amount', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], ], ], [ 'cols' => [ [ 'name' => 'shipping_tax_amt-group', 'type' => 'grouped-field', 'label' => 'LBL_SHIPPING_TAX_AMT', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'shipping_tax_amt', 'shipping_tax_amt_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'shipping_tax_amt' => [ 'required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => [ 'name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'legacyGroup' => true, 'groupFields' => [ 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'shipping_tax_amt_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'shipping_tax_amt', ], 'currencyField' => 'shipping_tax_amt', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], ], ], [ 'cols' => [ [ 'name' => 'tax_amount-group', 'type' => 'grouped-field', 'label' => 'LBL_TAX_AMOUNT', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'tax_amount', 'tax_amount_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'tax_amount' => [ 'required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'tax_amount_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'tax_amount', ], 'currencyField' => 'tax_amount', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], ], ], [ 'cols' => [ [ 'name' => 'total_amount-group', 'type' => 'grouped-field', 'label' => 'LBL_GRAND_TOTAL', 'vname' => '', 'fieldDefinition' => [ 'type' => 'grouped-field', 'layout' => [ 'currency_id', 'total_amount', 'total_amount_usdollar', ], 'display' => 'inline', 'groupFields' => [ 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], 'widthAuto' => true, 'widthFull' => false, ], 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'options' => '__no_options__', 'logic' => null, ], 'total_amount' => [ 'required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'legacyGroup' => true, 'groupFields' => [ 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], 'logic' => [ 'currency' => [ 'key' => 'update-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'currency_id', ], 'currencyIdField' => 'currency_id', 'baseCurrencyField' => 'total_amount_usdollar', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], 'metadata' => [], ], 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], 'display' => 'none', 'logic' => [ 'currency' => [ 'key' => 'update-base-currency', 'modes' => [ 'edit', 'create', 'massupdate', 'filter', ], 'params' => [ 'fieldDependencies' => [ 'total_amount', ], 'currencyField' => 'total_amount', 'currencyIdField' => 'currency_id', ], 'triggeringStatus' => [ 'onAnyLogic', ], ], ], ], ], ], ], ], ], ], ], [ 'key' => 'LBL_PANEL_ASSIGNMENT', 'rows' => [ [ 'cols' => [ [ 'name' => 'date_entered', 'label' => 'LBL_DATE_ENTERED', 'customCode' => '{$fields.date_entered.value} {$APP.LBL_BY} {$fields.created_by_name.value}', 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'type' => 'datetime', 'readonly' => true, ], [ 'name' => 'date_modified', 'label' => 'LBL_DATE_MODIFIED', 'customCode' => '{$fields.date_modified.value} {$APP.LBL_BY} {$fields.modified_by_name.value}', 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'type' => 'datetime', 'readonly' => true, ], ], ], ], ], ], 'summaryTemplates' => [ 'create' => 'LBL_CREATE', 'edit' => 'LBL_SUMMARY_DEFAULT', 'detail' => 'LBL_SUMMARY_DEFAULT', ], 'vardefs' => [ 'id' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, ], 'name' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'created_by_name' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'created_by' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'description' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', 'required' => false, ], 'created_by_link' => [ 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'aos_contracts_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'modified_user_link' => [ 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'aos_contracts_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], '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', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'required' => false, ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'aos_contracts_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', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'SecurityGroups' => [ 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_aos_contracts', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'securitygroup_id', 'type' => 'many-to-many', 'parent_id' => 'record_id', ], ], 'reference_code' => [ 'required' => false, 'name' => 'reference_code', 'vname' => 'LBL_REFERENCE_CODE ', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20', ], 'start_date' => [ 'required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now', ], 'end_date' => [ 'required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year', ], 'total_contract_value' => [ 'required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', ], 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'amount' => [ 'type' => 'grouped-field', 'name' => 'amount', 'legacyGroup' => true, 'groupFields' => [ 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], ], ], 'status' => [ 'required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false, ], 'customer_signed_date' => [ 'required' => false, 'name' => 'customer_signed_date', 'vname' => 'LBL_CUSTOMER_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'company_signed_date' => [ 'required' => false, 'name' => 'company_signed_date', 'vname' => 'LBL_COMPANY_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'renewal_reminder_date' => [ 'required' => false, 'name' => 'renewal_reminder_date', 'vname' => 'LBL_RENEWAL_REMINDER_DATE', 'dbType' => 'datetime', 'type' => 'datetime', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', ], 'contract_type' => [ 'required' => false, 'name' => 'contract_type', 'vname' => 'LBL_CONTRACT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Type', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_type_list', 'studio' => 'visible', 'dependency' => false, ], 'contract_account_id' => [ 'required' => false, 'name' => 'contract_account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'contract_account' => [ 'required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'opportunity_id' => [ 'required' => false, 'name' => 'opportunity_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'opportunity' => [ 'required' => false, 'source' => 'non-db', 'name' => 'opportunity', 'vname' => 'LBL_OPPORTUNITY', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'opportunity_id', 'ext2' => 'Opportunities', 'module' => 'Opportunities', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'contact_id' => [ 'required' => false, 'name' => 'contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'contact' => [ 'required' => false, 'source' => 'non-db', 'name' => 'contact', 'vname' => 'LBL_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'call_id' => [ 'required' => false, 'name' => 'call_id', 'vname' => 'LBL_CALL_ID', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'line_items' => [ 'required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => [ 'name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], ], 'total_amt' => [ 'required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'subtotal_amount' => [ 'required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'discount_amount' => [ 'required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'tax_amount' => [ 'required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'shipping_amount' => [ 'required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'shipping_tax' => [ 'required' => false, 'name' => 'shipping_tax', 'vname' => 'LBL_SHIPPING_TAX', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'vat_list', 'studio' => 'visible', ], 'shipping_tax_amt' => [ 'required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => [ 'name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'legacyGroup' => true, 'groupFields' => [ 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'total_amount' => [ 'required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'legacyGroup' => true, 'groupFields' => [ 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'accounts' => [ 'name' => 'accounts', 'vname' => 'LBL_ACCOUNTS', 'type' => 'link', 'relationship' => 'account_aos_contracts', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'contacts' => [ 'name' => 'contacts', 'vname' => 'LBL_CONTACTS', 'type' => 'link', 'relationship' => 'contact_aos_contracts', 'module' => 'Contacts', 'bean_name' => 'Contact', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'tasks' => [ 'name' => 'tasks', 'vname' => 'LBL_TASKS', 'type' => 'link', 'relationship' => 'aos_contracts_tasks', 'module' => 'Tasks', 'bean_name' => 'Task', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'notes' => [ 'name' => 'notes', 'vname' => 'LBL_NOTES', 'type' => 'link', 'relationship' => 'aos_contracts_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'meetings' => [ 'name' => 'meetings', 'vname' => 'LBL_MEETINGS', 'type' => 'link', 'relationship' => 'aos_contracts_meetings', 'module' => 'Meetings', 'bean_name' => 'Meeting', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'calls' => [ 'name' => 'calls', 'vname' => 'LBL_CALLS', 'type' => 'link', 'relationship' => 'aos_contracts_calls', 'module' => 'Calls', 'bean_name' => 'Call', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'emails' => [ 'name' => 'emails', 'vname' => 'LBL_EMAILS', 'type' => 'link', 'relationship' => 'emails_aos_contracts_rel', 'source' => 'non-db', 'required' => false, 'module' => 'Emails', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'email_id', 'type' => 'many-to-many', 'parent_id' => 'bean_id', ], ], 'aos_quotes_aos_contracts' => [ 'name' => 'aos_quotes_aos_contracts', 'vname' => 'LBL_AOS_QUOTES_AOS_CONTRACTS', 'type' => 'link', 'relationship' => 'aos_quotes_aos_contracts', 'source' => 'non-db', 'module' => 'AOS_Quotes', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'aos_quotese81e_quotes_ida', 'type' => 'many-to-many', 'parent_id' => 'aos_quotes4dc0ntracts_idb', ], ], 'documents' => [ 'name' => 'documents', 'vname' => 'LBL_DOCUMENTS', 'type' => 'link', 'relationship' => 'aos_contracts_documents', 'source' => 'non-db', 'module' => 'Documents', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'documents_id', 'type' => 'many-to-many', 'parent_id' => 'aos_contracts_id', ], ], 'aos_products_quotes' => [ 'name' => 'aos_products_quotes', 'vname' => 'LBL_AOS_PRODUCT_QUOTES', 'type' => 'link', 'relationship' => 'aos_contracts_aos_products_quotes', 'module' => 'AOS_Products_Quotes', 'bean_name' => 'AOS_Products_Quotes', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'aos_line_item_groups' => [ 'name' => 'aos_line_item_groups', 'vname' => 'LBL_AOS_LINE_ITEM_GROUPS', 'type' => 'link', 'relationship' => 'aos_contracts_aos_line_item_groups', 'module' => 'AOS_Line_Item_Groups', 'bean_name' => 'AOS_Line_Item_Groups', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], ], 'metadata' => [], 'sections' => [], ], 'recordmodal' => [ 'templateMeta' => [ 'maxColumns' => '2', 'useTabs' => true, 'tabDefs' => [ 'DEFAULT' => [ 'newTab' => true, 'panelDefault' => 'expanded', ], 'LBL_LINE_ITEMS' => [ 'newTab' => true, 'panelDefault' => 'expanded', ], 'LBL_PANEL_ASSIGNMENT' => [ 'newTab' => true, 'panelDefault' => 'expanded', ], ], ], 'actions' => [ [ 'key' => 'save', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', 'create', ], 'acl' => [ 'edit', 'create', ], ], [ 'key' => 'cancel', 'labelKey' => 'LBL_CANCEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', 'create', ], 'acl' => [ 'edit', 'create', ], ], ], 'panels' => [ [ 'key' => 'default', 'rows' => [ [ 'cols' => [ [ 'name' => 'name', 'label' => 'LBL_NAME', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', ], 'type' => 'name', ], [ 'name' => 'status', 'label' => 'LBL_STATUS', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false, ], 'type' => 'enum', ], ], ], [ 'cols' => [ [ 'name' => 'total_contract_value', 'label' => 'LBL_TOTAL_CONTRACT_VALUE', 'fieldDefinition' => [ 'required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', ], 'type' => 'currency', ], [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_TO_NAME', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'start_date', 'label' => 'LBL_START_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now', ], 'type' => 'date', ], [ 'name' => 'contract_account', 'label' => 'LBL_CONTRACT_ACCOUNT', 'fieldDefinition' => [ 'required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'end_date', 'label' => 'LBL_END_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year', ], 'type' => 'date', ], [ 'name' => 'contact', 'label' => 'LBL_CONTACT', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'contact', 'vname' => 'LBL_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'renewal_reminder_date', 'label' => 'LBL_RENEWAL_REMINDER_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'renewal_reminder_date', 'vname' => 'LBL_RENEWAL_REMINDER_DATE', 'dbType' => 'datetime', 'type' => 'datetime', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', ], 'type' => 'datetime', ], [ 'name' => 'opportunity', 'label' => 'LBL_OPPORTUNITY', 'fieldDefinition' => [ 'required' => false, 'source' => 'non-db', 'name' => 'opportunity', 'vname' => 'LBL_OPPORTUNITY', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'opportunity_id', 'ext2' => 'Opportunities', 'module' => 'Opportunities', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ 'name' => 'customer_signed_date', 'label' => 'LBL_CUSTOMER_SIGNED_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'customer_signed_date', 'vname' => 'LBL_CUSTOMER_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'type' => 'date', ], [ 'name' => 'contract_type', 'label' => 'LBL_CONTRACT_TYPE', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => false, 'name' => 'contract_type', 'vname' => 'LBL_CONTRACT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Type', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_type_list', 'studio' => 'visible', 'dependency' => false, ], 'type' => 'enum', ], ], ], [ 'cols' => [ [ 'name' => 'company_signed_date', 'label' => 'LBL_COMPANY_SIGNED_DATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'company_signed_date', 'vname' => 'LBL_COMPANY_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'type' => 'date', ], ], ], [ 'cols' => [ [ 'name' => 'description', 'label' => 'LBL_DESCRIPTION', 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], 'type' => 'text', ], ], ], ], ], [ 'key' => 'lbl_line_items', 'rows' => [ [ 'cols' => [ [ 'name' => 'currency_id', 'label' => 'LBL_CURRENCY', 'studio' => 'visible', 'fieldDefinition' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], ], ], 'type' => 'id', ], ], ], [ 'cols' => [ [ 'name' => 'line_items', 'label' => 'LBL_LINE_ITEMS', 'fieldDefinition' => [ 'required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => [ 'name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], ], 'type' => 'function', ], ], ], [ 'cols' => [], ], [ 'cols' => [ [ 'name' => 'total_amt', 'label' => 'LBL_TOTAL_AMT', 'fieldDefinition' => [ 'required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'type' => 'currency', ], ], ], [ 'cols' => [ [ 'name' => 'discount_amount', 'label' => 'LBL_DISCOUNT_AMOUNT', 'fieldDefinition' => [ 'required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'type' => 'currency', ], ], ], [ 'cols' => [ [ 'name' => 'subtotal_amount', 'label' => 'LBL_SUBTOTAL_AMOUNT', 'fieldDefinition' => [ 'required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'type' => 'currency', ], ], ], [ 'cols' => [ [ 'name' => 'shipping_amount', 'label' => 'LBL_SHIPPING_AMOUNT', 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'type' => 'currency', ], ], ], [ 'cols' => [ [ 'name' => 'shipping_tax_amt', 'label' => 'LBL_SHIPPING_TAX_AMT', 'fieldDefinition' => [ 'required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => [ 'name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'legacyGroup' => true, 'groupFields' => [ 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'type' => 'currency', ], ], ], [ 'cols' => [ [ 'name' => 'tax_amount', 'label' => 'LBL_TAX_AMOUNT', 'fieldDefinition' => [ 'required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'type' => 'currency', ], ], ], [ 'cols' => [ [ 'name' => 'total_amount', 'label' => 'LBL_GRAND_TOTAL', 'fieldDefinition' => [ 'required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'legacyGroup' => true, 'groupFields' => [ 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'type' => 'currency', ], ], ], ], ], [ 'key' => 'LBL_PANEL_ASSIGNMENT', 'rows' => [ [ 'cols' => [ [ 'name' => 'date_entered', 'label' => 'LBL_DATE_ENTERED', 'customCode' => '{$fields.date_entered.value} {$APP.LBL_BY} {$fields.created_by_name.value}', 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'type' => 'datetime', ], [ 'name' => 'date_modified', 'label' => 'LBL_DATE_MODIFIED', 'customCode' => '{$fields.date_modified.value} {$APP.LBL_BY} {$fields.modified_by_name.value}', 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'type' => 'datetime', ], ], ], ], ], ], 'vardefs' => [ 'id' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, ], 'name' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'created_by_name' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'created_by' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'description' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', 'required' => false, ], 'created_by_link' => [ 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'aos_contracts_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'modified_user_link' => [ 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'aos_contracts_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], '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', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'required' => false, ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'aos_contracts_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', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'SecurityGroups' => [ 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_aos_contracts', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'securitygroup_id', 'type' => 'many-to-many', 'parent_id' => 'record_id', ], ], 'reference_code' => [ 'required' => false, 'name' => 'reference_code', 'vname' => 'LBL_REFERENCE_CODE ', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20', ], 'start_date' => [ 'required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now', ], 'end_date' => [ 'required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year', ], 'total_contract_value' => [ 'required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', ], 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'amount' => [ 'type' => 'grouped-field', 'name' => 'amount', 'legacyGroup' => true, 'groupFields' => [ 'total_contract_value_usdollar' => [ 'name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'currency_id' => [ 'required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => [ 'name' => 'getCurrencyDropDown', 'returns' => 'html', 'onListView' => true, ], 'metadata' => [ 'extraOptions' => [ [ 'value' => '-99', 'label' => '£ (GBP)', ], [ 'value' => '22dd8795-2ddf-da77-7059-5f9027fcbe44', 'label' => '€ (EUR)', ], [ 'value' => 'defc629a-ecd2-e1a6-414b-5f9027186093', 'label' => '$ (USD)', ], ], ], ], 'status' => [ 'required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false, ], 'customer_signed_date' => [ 'required' => false, 'name' => 'customer_signed_date', 'vname' => 'LBL_CUSTOMER_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'company_signed_date' => [ 'required' => false, 'name' => 'company_signed_date', 'vname' => 'LBL_COMPANY_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false, ], 'renewal_reminder_date' => [ 'required' => false, 'name' => 'renewal_reminder_date', 'vname' => 'LBL_RENEWAL_REMINDER_DATE', 'dbType' => 'datetime', 'type' => 'datetime', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', ], 'contract_type' => [ 'required' => false, 'name' => 'contract_type', 'vname' => 'LBL_CONTRACT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Type', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_type_list', 'studio' => 'visible', 'dependency' => false, ], 'contract_account_id' => [ 'required' => false, 'name' => 'contract_account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'contract_account' => [ 'required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'opportunity_id' => [ 'required' => false, 'name' => 'opportunity_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'opportunity' => [ 'required' => false, 'source' => 'non-db', 'name' => 'opportunity', 'vname' => 'LBL_OPPORTUNITY', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'opportunity_id', 'ext2' => 'Opportunities', 'module' => 'Opportunities', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'contact_id' => [ 'required' => false, 'name' => 'contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'contact' => [ 'required' => false, 'source' => 'non-db', 'name' => 'contact', 'vname' => 'LBL_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible', ], 'call_id' => [ 'required' => false, 'name' => 'call_id', 'vname' => 'LBL_CALL_ID', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, ], 'line_items' => [ 'required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => [ 'name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], ], 'total_amt' => [ 'required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'total_amt_usdollar' => [ 'name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'subtotal_amount' => [ 'required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'subtotal_amount_usdollar' => [ 'name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'discount_amount' => [ 'required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'discount_amount_usdollar' => [ 'name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'tax_amount' => [ 'required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'tax_amount_usdollar' => [ 'name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'shipping_amount' => [ 'required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'legacyGroup' => true, 'groupFields' => [ 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'shipping_amount_usdollar' => [ 'name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'shipping_tax' => [ 'required' => false, 'name' => 'shipping_tax', 'vname' => 'LBL_SHIPPING_TAX', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'vat_list', 'studio' => 'visible', ], 'shipping_tax_amt' => [ 'required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => [ 'name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php', ], 'legacyGroup' => true, 'groupFields' => [ 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'shipping_tax_amt_usdollar' => [ 'name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'total_amount' => [ 'required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom', 'legacyGroup' => true, 'groupFields' => [ 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], ], ], 'total_amount_usdollar' => [ 'name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => [ 'editview' => false, 'detailview' => false, 'quickcreate' => false, ], 'len' => '26,6', 'required' => false, 'metadata' => [ 'isBaseCurrency' => true, 'format' => false, ], ], 'accounts' => [ 'name' => 'accounts', 'vname' => 'LBL_ACCOUNTS', 'type' => 'link', 'relationship' => 'account_aos_contracts', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'contacts' => [ 'name' => 'contacts', 'vname' => 'LBL_CONTACTS', 'type' => 'link', 'relationship' => 'contact_aos_contracts', 'module' => 'Contacts', 'bean_name' => 'Contact', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'tasks' => [ 'name' => 'tasks', 'vname' => 'LBL_TASKS', 'type' => 'link', 'relationship' => 'aos_contracts_tasks', 'module' => 'Tasks', 'bean_name' => 'Task', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'notes' => [ 'name' => 'notes', 'vname' => 'LBL_NOTES', 'type' => 'link', 'relationship' => 'aos_contracts_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'meetings' => [ 'name' => 'meetings', 'vname' => 'LBL_MEETINGS', 'type' => 'link', 'relationship' => 'aos_contracts_meetings', 'module' => 'Meetings', 'bean_name' => 'Meeting', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'calls' => [ 'name' => 'calls', 'vname' => 'LBL_CALLS', 'type' => 'link', 'relationship' => 'aos_contracts_calls', 'module' => 'Calls', 'bean_name' => 'Call', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'emails' => [ 'name' => 'emails', 'vname' => 'LBL_EMAILS', 'type' => 'link', 'relationship' => 'emails_aos_contracts_rel', 'source' => 'non-db', 'required' => false, 'module' => 'Emails', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'email_id', 'type' => 'many-to-many', 'parent_id' => 'bean_id', ], ], 'aos_quotes_aos_contracts' => [ 'name' => 'aos_quotes_aos_contracts', 'vname' => 'LBL_AOS_QUOTES_AOS_CONTRACTS', 'type' => 'link', 'relationship' => 'aos_quotes_aos_contracts', 'source' => 'non-db', 'module' => 'AOS_Quotes', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'aos_quotese81e_quotes_ida', 'type' => 'many-to-many', 'parent_id' => 'aos_quotes4dc0ntracts_idb', ], ], 'documents' => [ 'name' => 'documents', 'vname' => 'LBL_DOCUMENTS', 'type' => 'link', 'relationship' => 'aos_contracts_documents', 'source' => 'non-db', 'module' => 'Documents', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'documents_id', 'type' => 'many-to-many', 'parent_id' => 'aos_contracts_id', ], ], 'aos_products_quotes' => [ 'name' => 'aos_products_quotes', 'vname' => 'LBL_AOS_PRODUCT_QUOTES', 'type' => 'link', 'relationship' => 'aos_contracts_aos_products_quotes', 'module' => 'AOS_Products_Quotes', 'bean_name' => 'AOS_Products_Quotes', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'aos_line_item_groups' => [ 'name' => 'aos_line_item_groups', 'vname' => 'LBL_AOS_LINE_ITEM_GROUPS', 'type' => 'link', 'relationship' => 'aos_contracts_aos_line_item_groups', 'module' => 'AOS_Line_Item_Groups', 'bean_name' => 'AOS_Line_Item_Groups', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], ], 'metadata' => [], ], 'extra' => [], ]];