[ 'layout' => [ 'basic' => [ [ 'name' => 'name', 'default' => true, 'width' => '10%', ], [ 'type' => 'varchar', 'default' => true, 'label' => 'LBL_BUILDER', 'width' => '10%', 'name' => 'builder_c', ], '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, ], ], 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'vardefBased' => true, 'display' => 'none', 'readonly' => 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', '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_product_categories_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_product_categories_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_product_categories_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_product_categories', '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, ], ], 'is_parent' => [ 'name' => 'is_parent', 'width' => '', 'label' => 'LBL_IS_PARENT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'is_parent', 'vname' => 'LBL_IS_PARENT', 'type' => 'bool', 'massupdate' => '0', 'default' => '0', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'id' => 'AOS_Product_Categoriesis_parent', 'readonly' => false, ], ], 'aos_products' => [ 'name' => 'aos_products', 'width' => '', 'label' => 'LBL_AOS_PRODUCT_CATEGORIES_AOS_PRODUCTS_FROM_AOS_PRODUCTS_TITLE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_products', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'product_categories', 'side' => 'right', 'vname' => 'LBL_AOS_PRODUCT_CATEGORIES_AOS_PRODUCTS_FROM_AOS_PRODUCTS_TITLE', 'required' => false, 'module' => 'AOS_Products', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'sub_categories' => [ 'name' => 'sub_categories', 'width' => '', 'label' => 'LBL_SUB_CATEGORIES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'sub_categories', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'sub_product_categories', 'vname' => 'LBL_SUB_CATEGORIES', 'id_name' => 'parent_category_id', 'required' => false, 'module' => 'AOS_Product_Categories', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'parent_category' => [ 'name' => 'parent_category', 'width' => '', 'label' => 'LBL_PARENT_CATEGORY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'parent_category', 'type' => 'link', 'relationship' => 'sub_product_categories', 'module' => 'AOS_Product_Categories', 'bean_name' => 'AOS_Product_Categories', 'link_type' => 'one', 'source' => 'non-db', 'vname' => 'LBL_PARENT_CATEGORY', 'side' => 'right', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'parent_category_name' => [ 'name' => 'parent_category_name', 'width' => '', 'label' => 'LBL_PRODUCT_CATEGORYS_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'parent_category_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_PRODUCT_CATEGORYS_NAME', 'save' => true, 'id_name' => 'parent_category_id', 'link' => 'parent_category', 'table' => 'aos_product_categories', 'module' => 'AOS_Product_Categories', 'rname' => 'name', 'required' => false, 'readonly' => false, ], ], 'parent_category_id' => [ 'name' => 'parent_category_id', 'width' => '', 'label' => 'LBL_PARENT_CATEGORY_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'parent_category_id', 'type' => 'id', 'reportable' => false, 'vname' => 'LBL_PARENT_CATEGORY_ID', 'required' => false, 'readonly' => false, ], ], 'builder_c' => [ 'name' => 'builder_c', 'width' => '', 'label' => 'LBL_BUILDER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'inline_edit' => '', 'labelValue' => 'Builder', 'required' => true, 'source' => 'custom_fields', 'name' => 'builder_c', 'vname' => 'LBL_BUILDER', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id' => 'AOS_Product_Categoriesbuilder_c', 'custom_module' => 'AOS_Product_Categories', 'readonly' => false, ], ], 'bbid_c' => [ 'name' => 'bbid_c', 'width' => '', 'label' => 'LBL_BBID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'inline_edit' => '1', 'labelValue' => 'BBID Code', 'required' => false, 'source' => 'custom_fields', 'name' => 'bbid_c', 'vname' => 'LBL_BBID', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'id' => 'AOS_Product_Categoriesbbid_c', 'custom_module' => 'AOS_Product_Categories', 'readonly' => false, ], ], ], 'advanced' => [ [ 'name' => 'name', 'default' => true, 'width' => '10%', ], [ 'type' => 'varchar', 'default' => true, 'label' => 'LBL_BUILDER', 'width' => '10%', 'name' => 'builder_c', ], [ 'type' => 'varchar', 'default' => true, 'label' => 'LBL_BBID', 'width' => '10%', 'name' => 'bbid_c', ], [ 'type' => 'text', 'label' => 'LBL_DESCRIPTION', 'sortable' => false, 'width' => '10%', 'default' => true, 'name' => 'description', ], '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, ], ], 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'vardefBased' => true, 'display' => 'none', 'readonly' => 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', '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_product_categories_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_product_categories_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_product_categories_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_product_categories', '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, ], ], 'is_parent' => [ 'name' => 'is_parent', 'width' => '', 'label' => 'LBL_IS_PARENT', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'is_parent', 'vname' => 'LBL_IS_PARENT', 'type' => 'bool', 'massupdate' => '0', 'default' => '0', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'id' => 'AOS_Product_Categoriesis_parent', 'readonly' => false, ], ], 'aos_products' => [ 'name' => 'aos_products', 'width' => '', 'label' => 'LBL_AOS_PRODUCT_CATEGORIES_AOS_PRODUCTS_FROM_AOS_PRODUCTS_TITLE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'aos_products', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'product_categories', 'side' => 'right', 'vname' => 'LBL_AOS_PRODUCT_CATEGORIES_AOS_PRODUCTS_FROM_AOS_PRODUCTS_TITLE', 'required' => false, 'module' => 'AOS_Products', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'sub_categories' => [ 'name' => 'sub_categories', 'width' => '', 'label' => 'LBL_SUB_CATEGORIES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'sub_categories', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'sub_product_categories', 'vname' => 'LBL_SUB_CATEGORIES', 'id_name' => 'parent_category_id', 'required' => false, 'module' => 'AOS_Product_Categories', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'parent_category' => [ 'name' => 'parent_category', 'width' => '', 'label' => 'LBL_PARENT_CATEGORY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'parent_category', 'type' => 'link', 'relationship' => 'sub_product_categories', 'module' => 'AOS_Product_Categories', 'bean_name' => 'AOS_Product_Categories', 'link_type' => 'one', 'source' => 'non-db', 'vname' => 'LBL_PARENT_CATEGORY', 'side' => 'right', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'parent_category_name' => [ 'name' => 'parent_category_name', 'width' => '', 'label' => 'LBL_PRODUCT_CATEGORYS_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'parent_category_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_PRODUCT_CATEGORYS_NAME', 'save' => true, 'id_name' => 'parent_category_id', 'link' => 'parent_category', 'table' => 'aos_product_categories', 'module' => 'AOS_Product_Categories', 'rname' => 'name', 'required' => false, 'readonly' => false, ], ], 'parent_category_id' => [ 'name' => 'parent_category_id', 'width' => '', 'label' => 'LBL_PARENT_CATEGORY_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'parent_category_id', 'type' => 'id', 'reportable' => false, 'vname' => 'LBL_PARENT_CATEGORY_ID', 'required' => false, 'readonly' => false, ], ], 'builder_c' => [ 'name' => 'builder_c', 'width' => '', 'label' => 'LBL_BUILDER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'inline_edit' => '', 'labelValue' => 'Builder', 'required' => true, 'source' => 'custom_fields', 'name' => 'builder_c', 'vname' => 'LBL_BUILDER', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id' => 'AOS_Product_Categoriesbuilder_c', 'custom_module' => 'AOS_Product_Categories', 'readonly' => false, ], ], 'bbid_c' => [ 'name' => 'bbid_c', 'width' => '', 'label' => 'LBL_BBID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'inline_edit' => '1', 'labelValue' => 'BBID Code', 'required' => false, 'source' => 'custom_fields', 'name' => 'bbid_c', 'vname' => 'LBL_BBID', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'id' => 'AOS_Product_Categoriesbbid_c', 'custom_module' => 'AOS_Product_Categories', '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' => '32%', 'label' => 'LBL_NAME', 'link' => true, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', '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', ], ], [ 'name' => 'builder_c', 'width' => '10%', 'label' => 'LBL_BUILDER', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'inline_edit' => '', 'labelValue' => 'Builder', 'required' => true, 'source' => 'custom_fields', 'name' => 'builder_c', 'vname' => 'LBL_BUILDER', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id' => 'AOS_Product_Categoriesbuilder_c', 'custom_module' => 'AOS_Product_Categories', ], ], [ 'name' => 'bbid_c', 'width' => '10%', 'label' => 'LBL_BBID', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'inline_edit' => '1', 'labelValue' => 'BBID Code', 'required' => false, 'source' => 'custom_fields', 'name' => 'bbid_c', 'vname' => 'LBL_BBID', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'id' => 'AOS_Product_Categoriesbbid_c', 'custom_module' => 'AOS_Product_Categories', ], ], [ 'name' => 'description', 'width' => '10%', 'label' => 'LBL_DESCRIPTION', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => false, 'type' => 'text', 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], ], [ 'name' => 'parent_category_name', 'width' => '10%', 'label' => 'LBL_PRODUCT_CATEGORYS_NAME', 'link' => true, 'default' => false, 'module' => '', 'id' => 'PARENT_CATEGORY_ID', 'sortable' => true, 'type' => 'relate', 'fieldDefinition' => [ 'name' => 'parent_category_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_PRODUCT_CATEGORYS_NAME', 'save' => true, 'id_name' => 'parent_category_id', 'link' => 'parent_category', 'table' => 'aos_product_categories', 'module' => 'AOS_Product_Categories', 'rname' => 'name', 'required' => false, ], ], [ 'name' => 'assigned_user_name', 'width' => '9%', 'label' => 'LBL_ASSIGNED_TO_NAME', 'link' => false, 'default' => false, 'module' => 'Employees', '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, ], ], ], 'bulkActions' => [], 'lineActions' => [], 'tableActions' => [ [ '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' => [], 'recordview' => [ 'templateMeta' => [ 'maxColumns' => '2', 'useTabs' => false, 'tabDefs' => [ 'DEFAULT' => [ 'newTab' => false, 'panelDefault' => 'expanded', ], ], ], 'topWidget' => [ 'refreshOn' => 'data-update', ], 'sidebarWidgets' => [], 'bottomWidgets' => [], 'actions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT', 'params' => [ 'expanded' => true, ], 'modes' => [ 'detail', ], 'acl' => [ 'edit', ], ], [ 'key' => 'save', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'saveNew', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'create', ], 'acl' => [ 'edit', ], ], [ 'key' => 'cancel', 'labelKey' => 'LBL_CANCEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', ], ], [ 'key' => 'cancelCreate', 'labelKey' => 'LBL_CANCEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'create', ], ], [ 'key' => 'saveContinue', 'labelKey' => 'LBL_SAVE_CONTINUE_LABEL', 'params' => [ 'expanded' => true, 'collapsedMobile' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'audit', 'labelKey' => 'LNK_VIEW_CHANGE_LOG', 'asyncProcess' => true, 'params' => null, 'modes' => [ 'detail', 'edit', ], 'availability' => [ 'audited', 'acls', ], ], ], 'panels' => [ [ 'key' => 'default', 'rows' => [ [ 'cols' => [ [ 'name' => 'name', 'label' => 'LBL_NAME', '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' => 'builder_c', 'label' => 'LBL_BUILDER', 'fieldDefinition' => [ 'inline_edit' => '', 'labelValue' => 'Builder', 'required' => true, 'source' => 'custom_fields', 'name' => 'builder_c', 'vname' => 'LBL_BUILDER', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id' => 'AOS_Product_Categoriesbuilder_c', 'custom_module' => 'AOS_Product_Categories', ], 'type' => 'varchar', ], ], ], [ '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', ], [ 'name' => 'bbid_c', 'label' => 'LBL_BBID', 'fieldDefinition' => [ 'inline_edit' => '1', 'labelValue' => 'BBID Code', 'required' => false, 'source' => 'custom_fields', 'name' => 'bbid_c', 'vname' => 'LBL_BBID', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'id' => 'AOS_Product_Categoriesbbid_c', 'custom_module' => 'AOS_Product_Categories', ], 'type' => 'varchar', ], ], ], [ 'cols' => [ [ 'name' => 'is_parent', 'label' => 'LBL_IS_PARENT', 'fieldDefinition' => [ 'required' => false, 'name' => 'is_parent', 'vname' => 'LBL_IS_PARENT', 'type' => 'bool', 'massupdate' => '0', 'default' => '0', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'id' => 'AOS_Product_Categoriesis_parent', ], 'type' => 'bool', ], [ 'name' => 'parent_category_name', 'label' => 'LBL_PRODUCT_CATEGORYS_NAME', 'fieldDefinition' => [ 'name' => 'parent_category_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_PRODUCT_CATEGORYS_NAME', 'save' => true, 'id_name' => 'parent_category_id', 'link' => 'parent_category', 'table' => 'aos_product_categories', 'module' => 'AOS_Product_Categories', 'rname' => 'name', 'required' => false, ], 'type' => 'relate', ], ], ], [ 'cols' => [ [ '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', ], ], ], ], ], ], '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', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', ], '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_product_categories_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_product_categories_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_product_categories_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_product_categories', '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', ], ], 'is_parent' => [ 'required' => false, 'name' => 'is_parent', 'vname' => 'LBL_IS_PARENT', 'type' => 'bool', 'massupdate' => '0', 'default' => '0', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'id' => 'AOS_Product_Categoriesis_parent', ], 'aos_products' => [ 'name' => 'aos_products', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'product_categories', 'side' => 'right', 'vname' => 'LBL_AOS_PRODUCT_CATEGORIES_AOS_PRODUCTS_FROM_AOS_PRODUCTS_TITLE', 'required' => false, 'module' => 'AOS_Products', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'sub_categories' => [ 'name' => 'sub_categories', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'sub_product_categories', 'vname' => 'LBL_SUB_CATEGORIES', 'id_name' => 'parent_category_id', 'required' => false, 'module' => 'AOS_Product_Categories', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'parent_category' => [ 'name' => 'parent_category', 'type' => 'link', 'relationship' => 'sub_product_categories', 'module' => 'AOS_Product_Categories', 'bean_name' => 'AOS_Product_Categories', 'link_type' => 'one', 'source' => 'non-db', 'vname' => 'LBL_PARENT_CATEGORY', 'side' => 'right', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'parent_category_name' => [ 'name' => 'parent_category_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_PRODUCT_CATEGORYS_NAME', 'save' => true, 'id_name' => 'parent_category_id', 'link' => 'parent_category', 'table' => 'aos_product_categories', 'module' => 'AOS_Product_Categories', 'rname' => 'name', 'required' => false, ], 'parent_category_id' => [ 'name' => 'parent_category_id', 'type' => 'id', 'reportable' => false, 'vname' => 'LBL_PARENT_CATEGORY_ID', 'required' => false, ], 'builder_c' => [ 'inline_edit' => '', 'labelValue' => 'Builder', 'required' => true, 'source' => 'custom_fields', 'name' => 'builder_c', 'vname' => 'LBL_BUILDER', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id' => 'AOS_Product_Categoriesbuilder_c', 'custom_module' => 'AOS_Product_Categories', ], 'bbid_c' => [ 'inline_edit' => '1', 'labelValue' => 'BBID Code', 'required' => false, 'source' => 'custom_fields', 'name' => 'bbid_c', 'vname' => 'LBL_BBID', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'id' => 'AOS_Product_Categoriesbbid_c', 'custom_module' => 'AOS_Product_Categories', ], ], 'metadata' => [], ], ]];