menu
Oro Inc. OroCommerce
    Contact Us
    close
    • ← Oro Inc. Home
    • OroCommerce
    • Solutions
      Explore solutions according to your need
      By Need
      • Digital TransformationWe’ll help you use technology to build a better business
      • Customer Experience ImprovementStay ahead of buyer expectations across multiple touchpoints
      • Sales AccelerationTrack, analyze, and keep the pulse on your sales activities
      • Operational Efficiency ImprovementMaintain flexibility and innovate with the resources you have
      By Industry
      • Manufacturers
      • Distributors
      • FMCG Industry
      • Medical Supplies
      • Automotive
      • Electronics
      • Industrial Supplies
      • Chemical Industry
      Dunlop Protective Footwear
      Leading global manufacturer of protective footwear opens up new horizons with B2B eCommerce
      • Read the Story
    • Resources
      • Documentation
      • OroAcademy
    • Partners
      • All partners
      • Solution partners
      • Technology partners
      • Consulting Partners
      Want to be a partner?
      At Oro, we are commited to a truly open source ecosystem
      • Become a partner
    • Customers
    • About Us
      About Oro Inc.
      • Company
      • Vision & Mission
      • Leadership Team
      News & Actualities
      • Guides & Reports
      • B2B UnCut Podcast
      • Blog
      • Events
      • Press
      Join our next podcast episode LIVE!
      B2B Commerce UnCut: hear what really matters in B2B
      • Sign Up
    • Contact Us
    Join us on Slack
    • Back to Oro Inc
    • Users
      Concept Guides
      Concept Guides
      • Concept Guides
      • Back-Office
      • Commerce Storefront
      • Glossary
      • Integrations
    • Developers
      • Backend Developer Guide
      • Frontend Developer Guide
      • Bundles & Components
      • Web Services API Guide
      • Community Guide
    • Cloud Administrators
      Cloud Administrators
      Cloud Administrators
      • Architecture
      • Environment Types
      • Security
      • Monitoring
      • Onboarding
      • VPN Connection
      • Maintenance
      • Support
    • Blog
    • Academy
    Join us on Slack
    • Home >
    • User Documentation >
    • Back-Office >
    • Manage System Settings in the Back-Office >
    • Configure Entities in the Back-Office >
    • Create Entity Fields >
    • Type-Related Entity Field Properties
    • User Documentation
      • Concept Guides
        • OroMarketplace
        • Master Catalog Management
        • Content Management
          • Web Catalog
          • Landing Page
          • Content Blocks
          • Content Widgets
          • WYSIWYG Editor
        • Data Import
        • Product Management
        • Customer Management
        • Customer Permissions
        • Guest Functions
        • Price Management
        • Payment Configuration
        • Shipping Configuration
        • RFQ and Quote Management
        • Order Management
        • Multi-Website Configuration
        • B2C Websites in OroCommerce
        • Tax Management
        • Inventory and Warehouse Management
        • Storefront and Back-Office Menu Management
        • Localization and Translation
          • Translate Content
          • Translate Product Attribute Options
          • Translate Labels, Options, and Messages
        • Marketing Automation
        • Promotion Management
        • Consent Management
          • Add a Consent Landing Page to a Web Catalog
          • Localize Consents
          • Reports with Accepted Consents
        • Checkout Configuration
        • Search Functions
        • Accessibility
      • Back-Office
        • Getting Started
          • Community vs Enterprise Edition
          • Application Authentication
            • Log In/Out
            • Restore Password
            • Troubleshoot Login Issues
          • User Menu
            • My User
              • Add OAuth Applications
            • My Configuration
            • My Emails
            • My Calendar
          • Navigation
            • Navigation Basics
            • Record Tables (Grids)
            • Shortcuts
            • Company Structure and Organization Selector
            • Pinbar
            • User Menu
            • Extended Menu
            • Sidebar Panel
            • Flash Notifications
            • Dialog Windows
          • Information Management
            • Create a Record
            • Manage Records
              • View Records
              • Edit Records
              • Delete Records
            • Import Records
            • Export Records
            • Add Notes
            • How to Create and View Comments
            • Add Attachments
        • Dashboard
          • Dashboards
          • Widgets
            • Leads Statistics
            • Opportunity Statistics
            • Average Lifetime Sales
            • Campaign Leads
            • Campaigns by Close Revenue
            • Forecast
            • Leads List
            • Opportunities by Lead Source
            • Opportunities by Status
            • Opportunities List
            • Opportunity Generating Campaigns
            • Purchase Funnel
            • Quick Launchpad
            • Recent Calls
            • Recent Emails
            • Recently Accessed Account
            • Recently Accessed Contacts
            • Today’s Calendar
            • Sales Orders Volume
            • Sales Orders Number
        • Customers
          • Accounts
            • Create an Account
            • Manage Accounts
            • Merge Accounts
            • Import Accounts
            • Export Accounts
          • Contacts
            • Export Contacts
            • Import Contacts
          • Customers
            • Create a Customer
            • Create an Address
            • Export Customers
            • Import Customers
            • Configure Price List per Customer
            • Add All Products Page to Frontend Menus per Customer
            • Customize Frontend Menus per Customer
            • Configure Settings per Customer
              • Configure Product Data Export per Customer
              • Configure Search History Settings per Customer
              • Configure Routing Settings per Customer
          • Customer Groups
            • Configure Price List per Customer Group
            • Add All Products Page to Frontend Menus per Customer Group
            • Customize Frontend Menus per Customer Group
            • Configure Settings per Customer Group
              • Configure Product Data Export per Customer Group
              • Configure Search History Settings per Customer Group
              • Configure Routing Settings per Customer Group
          • Customer Users
            • Export Customer User Details
            • Import Customer User Details
          • Customer User Roles
          • Business Customers
            • Export Business Customers
            • Import Business Customers
          • Customer User Login Attempts
          • Customer User OAuth Applications
        • Sales
          • Leads
            • Create a Lead
            • Manage Leads
            • Qualify a Lead
            • Import Leads
            • Export Leads
          • Opportunities
            • Create an Opportunity
            • Manage Opportunities
            • Import an Opportunity
            • Export an Opportunity
            • Manage Opportunity Workflow
            • Multi-Currency Opportunities
          • Shopping Lists
          • Request for Quote (RFQ)
            • View a Request for Quote Details
            • View Requests for Quote Summary
            • Manage RFQs
            • Use RFQ Workflows
          • Quotes
            • Create a Quote
              • Create a Quote From Scratch
              • Create a Quote on the Customer Request
            • Manage Quotes
            • Send a Guest Quote
            • Use Quotes Workflows
              • Simple Quote Management: Steps and Transitions
              • Quote Management with Approvals: Steps and Transitions
              • Basic Quote Lifecycle Management (When Workflows Are Disabled)
            • Assign a Shipping Method to a Quote
          • Orders
            • Create an Order
            • View Order Details
            • Manage Orders
            • Move an Order Through Its Lifecycle
            • Add a Shipping Tracking Number to the Order
            • View Order Internal Statuses
          • Price Lists
            • Create a Price List
            • Duplicate a Price List
            • Export Prices from the Price List
            • Import Prices Into the Price List
            • Add a Product Price Manually
            • Generate a Product Price Automatically
            • Use Autocomplete
            • Schedule Price Adjustments
            • Manage Prices in Multiple Currencies
          • Payment Terms
          • Sales Territories
          • Seller Registration Requests
        • Products
          • Master Catalog
            • Import Master Catalog Categories Information
            • Export Master Catalog Categories Information
          • Products
            • Create a Simple Product
            • Create a Configurable Product
            • Manage Product Visibility
            • Manage Product Grids
              • View Product Details
              • Edit a Product
              • Manage Product Pricing
              • Manage Inventory
            • Manage Product Units
            • Offer Product Recommendations
            • Import Product Information
            • Export Product Information
          • Product Families
            • Create a New Product Family
            • Manage Product Attributes in Product Families
          • Product Attributes
            • Import Product Attributes
          • Product Brands
          • Price Attributes
        • Marketing
          • Marketing Lists
          • Email Campaigns
            • Send an Email Campaign via Mailchimp
            • Send Email Campaign via Dotdigital
            • Manage Dotdigital Data Fields and Mappings
          • Marketing Campaigns
          • Promotions
            • Promotions
              • Create Promotions
              • Add Conditions to Promotions
              • Add Expressions to Promotions
              • Manage Discounts in Orders
              • Calculate Order Total in Promotions
              • Review the FAQs
            • Coupons
              • Manage Coupons in Orders
              • Create a Sample Coupon
              • Export Coupons
              • Import Coupons
          • Tracking Websites
          • Web Catalogs
            • Create a Web Catalog
            • Edit a Web Catalog Content Tree
              • Set Up the Homepage, First Level Menu, and Sub Menus
              • Configure Content Variants for the Content Node
              • Customize Web Catalog Contents for Localization, Customer, Customer Group, or Website
              • Preview Web Catalog
            • Build a Custom Web Catalog From Scratch (Example)
            • Use Web Catalog Nodes as Root Nodes (Example)
          • Landing Pages
          • Content Templates
          • Content Blocks
          • Customer Login Pages
          • Content Widgets
          • Digital Assets
          • Search Synonyms
          • Search Terms
        • Taxes
          • Product Tax Codes
            • Create a Product Tax Code
            • View Product Tax Code Details
            • Link a Tax Code to a Product
          • Customer Tax Codes
            • Create a Customer Tax Code
            • View Customer Tax Code Details
            • Link a Tax Code to a Customer or Customer Group
          • Taxes (Tax Rates)
            • Create a Tax Rate
            • View and Filter Tax Rates
            • Export Tax Rates
            • Import Taxes Rates
          • Tax Rules
            • Create a Tax Rule
            • View and Filter Tax Rules
            • Export Tax Rules
            • Import Tax Rules
          • Tax Jurisdictions
            • Create a Tax Jurisdiction
            • View and Filter Tax Jurisdictions
        • Inventory
          • Warehouses
          • Manage Inventory Levels
          • Export Inventory Levels and Statuses
          • Import Inventory Levels and Statuses
        • Activities
          • Emails
            • OroConnector Add-on for Google Workspace
            • OroConnector Add-in for Microsoft 365
          • Tasks
            • Create a Task
            • Manage Tasks
          • Calls
          • Contact Requests
          • Cases
          • Calendar Events
            • Add a Calendar Event
            • Manage Calendar Events
        • Reports and Segments
          • Reports
            • Use System Reports
              • Accounts Reports
              • Leads Reports
              • Opportunities Reports
              • Best Selling Products Report
              • Search (Terms) Report
            • Use Custom Reports
            • Reports in Use
          • Segments
          • Filters
        • System
          • Configuration
            • System Configuration
              • General Setup
              • Integrations
              • Websites
            • CRM Configuration
              • Sales Pipeline
            • Commerce Configuration
              • Customer
              • Guests
              • Catalog
              • Design
              • Product
              • Inventory
              • Sales
              • Taxation
              • Payment
              • Search
              • Orders
              • Shipping
              • Marketplace
            • Marketing Configuration
              • General Setup
            • Configuration Quick Search
          • User Management
            • Users
              • Create a User
              • Manage Users
              • Configure User System Settings
            • Roles and Permissions
              • Entity and System Capabilities
              • Configure User Roles
              • Field Level Permissions
              • Configure End-to-End Access in Context
            • User Groups
            • Business Units
            • Organizations
              • Create an Organization
              • Manage Organizations
              • Add All Products Page to Frontend Menus per Organization
              • Customize Menus per Organization
              • Configure Organization System Settings
              • Organization Types
            • Login Attempts
            • OAuth Applications
          • Contact Reasons
          • Contact Groups
          • Emails
            • Templates
            • Notification Rules
          • Integrations
            • Manage Integrations: Payment Method Integration
              • Check/Money Order Service
              • Payment Terms
              • PayPal Payment Services
              • Apruve Payment Service
              • Authorize.Net Payments Services
              • InfinitePay Payment Service
              • Ingenico Payment Service
              • Stripe
              • Payments at Checkout
            • Manage Integrations: Shipping Method Integration
              • Flat Rate Shipping Integration
              • Fixed Product Shipping Cost Integration
              • UPS Shipping Integration
              • FedEx Shipping Integration
              • DPD Shipping Integration
            • Google Tag Manager Integration
            • Dotdigital Integration
              • Configure Dotdigital Integration
              • Configure Single Sign-on
            • Mailchimp Integration
            • Zendesk Integration
            • LDAP Integration
            • Embedded Forms
          • Channels
          • Jobs
          • Data Audit
          • Scheduled Tasks
          • Entities
            • Create Entities
            • Manage Entities
            • Create Entity Fields
              • Basic Entity Field Properties
              • Advanced Entity Field Properties
              • Type-Related Entity Field Properties
              • Examples of Creating Custom Entity Fields
            • Manage Entity Fields
          • Tags Management
            • Tags
            • Taxonomies
          • Menus
          • Frontend Menus
            • Change a Storefront Menu
            • Add All Products Page to Storefront Menus Globally
          • System Calendars
          • Shipping Rules
            • Expression Language for Shipping and Payment Rules
          • Payment Rules
          • Workflows
            • System Workflows
              • Checkout Workflow
              • Alternative Checkout Workflow
              • Single Page Checkout Workflow
              • Quote Workflows
              • RFQ Management Flow Workflow
              • RFQ Submission Flow Workflow
              • Task Flow
              • Unqualified Sales Lead Workflow
              • Contact Request Workflow
              • Seller Registration Request Workflow
            • Custom Workflows
            • Workflow Steps, Transitions, and Attributes
          • Processes
          • System Information
          • Consent Management
          • Websites
            • Configure Website System Settings
              • System Configuration
              • Commerce Configuration
            • Create a Website
            • Manage a Website
            • Configure Price Lists per Website
            • Add All Products Page to Frontend Menus per Website
            • Customize Frontend Menus per Website
          • Localization
            • Languages
            • Translations
            • Localizations
          • Alerts
      • Commerce Storefront
        • Navigation and UI
          • General Layout
          • Common Controls
        • Register and Sign In
          • Create Account
          • Sign In
          • Forgot Password
        • My Account
          • My Profile
          • Address Book
          • Users
          • Roles
          • Shopping Lists
            • Shopping Lists for Registered Users
            • Shopping Lists for Guest Users
          • Requests for Quote
            • Create an RFQ
            • Create a Guest RFQ
          • Order History
          • Previously Purchased Products
          • Quotes
          • Saved Search
          • Manage Payment Profiles (Authorize.Net Customer Profiles)
        • Orders
          • Create an Order
          • Order via Matrix Form
          • Re-Order Products
        • Quotes
          • Accept a Quote
          • Send Guest Quotes
        • Quick Order Form
        • Checkout
          • Multi Page Checkout
          • Single Page Checkout
          • Guest Checkout
          • Promotions at Checkout
        • Cookie Consent Banner
      • Integrations
        • Payment Integrations
          • Stripe
          • Paypal
          • Authorize
          • Apruve
          • CyberSource
          • InfinitePay
        • Shipping Integrations
          • DPD
          • UPS
          • Fedex
        • ERP
          • SAP Integration
        • Marketing
          • HubSpot
        • PIM
          • Akeneo
        • CRM
          • Integration with OroCRM
          • Integration with Salesforce
        • GS1
      • Glossary
    Version:
    5.1 (latest)
    • 3.1
    • 4.1
    • 4.2
    • 5.0
    • 1.6
    • 6.0

    Type-Related Entity Field Properties

    Depending on the entity type selected when defining the basic properties for the entity field you are creating, additional options appear in the General Information section once you click Continue. The following is the list of field types and the options that appear once the types are selected.

    For the Decimal type:

    Additional Option Option Description
    Precision Maximum number of digits. E.g., 15.252 has precision 5. And 1.12 has precision 3.
    Scale Maximum number of decimal places. E.g., 15,252 has scale 3. And 1.12 has scale 2.

    For the String type:

    Additional Option Option Description
    Length The number of characters in the string. It is a number from 1 to 255.

    For the File type:

    Additional Option Option Description
    Stored Externally Indicates whether the file referenced by this field is stored externally on a third party service. If enabled, the external URL text input is displayed instead of the file upload input. The URLs of the external files should be publicly available. The URLs provided by the users should match the Allowed URLs RegExp specified in the system settings. The system will not process, resize or modify the files that are stored externally.
    File Size The maximum file size allowed for an upload (in MB).
    Allowed MIME Types The list of allowed MIME types. If the field is left empty, it means that all listed extension types are allowed. To define the MIME types allowed for upload, refer to the system settings.
    Use DAM

    Setting to Yes enables the usage of Digital Asset Manager that changes the usual uploading behavior of the File type field for the selected entity. Now, your entity attachments are first uploaded to the DA database that organizes and stores all assets in one place, and then you can select the required asset from the list of available DA records. All attachments that are saved to the Digital Assets pool can be further re-used by any other entity with the enabled Use DAM field for the File type. If set to No, the usual uploading behavior is applied enabling you to select the asset from your local directory and do not save it to the DA pool. Such attachments cannot be shared and used by other entities.

    The difference in the image uploading behavior when **Use DAM** is set to yes and no
    ACL Protected Enable or disable the ACL check for attachments by selecting Yes or No respectively.
    File Applications The list of applications where a file or an image loaded to this field should be accessible. Possible applications are default and commerce, where default means back-office and commerce means storefront. If the files or images that you want to upload through this field are going to be accessed only from back-office, then select default; if from both back-office and storefront, then select both default and commerce. Please be aware that this setting is not used when ACL Protected is set to No.

    Important

    • Fields of the File type can be only of the Column table storage type.
    • These fields cannot be defined as identity fields for export/import operations.
    • Fields of the File type are not displayed on a grid, so Show on Grid and Show Grid Filter properties cannot be defined for them.

    Warning

    Auditing is not available for actions with the entity fields of the File type.

    For the Image type:

    Additional Option Option Description
    Stored Externally Indicates whether the file referenced by this field is stored externally on a third party service. If enabled, the external URL text input is displayed instead of the file upload input. The URLs of the external files should be publicly available. The URLs provided by the users should match the Allowed URLs RegExp specified in the system settings. The system will not process, resize or modify the files that are stored externally.
    File Size The maximum file size allowed for an upload (in MB).
    Thumbnail Width The image thumbnail width in pixels.
    Thumbnail Height The image thumbnail height in pixels.
    Allowed MIME Types The list of allowed MIME types. If the field is left empty, it means that all listed extension types are allowed. To define the MIME types allowed for upload, refer to the system settings.
    Use DAM

    Setting to Yes enables the usage of Digital Asset Manager that changes the usual uploading behavior of the Image type field for the selected entity. Now, your entity attachments are first uploaded to the DA database that organizes and stores all assets in one place, and then you can select the required asset from the list of available DA records. All attachments that are saved to the Digital Assets pool can be further re-used by any other entity with the enabled Use DAM field for the Image type. If set to No, the usual uploading behavior is applied enabling you to select the asset from your local directory and do not save it to the DA pool. Such attachments cannot be shared and used by other entities.

    The difference in the image uploading behavior when **Use DAM** is set to yes and no
    ACL Protected Enable or disable the ACL check for attachments by selecting Yes or No respectively.
    File Applications The list of applications where a file or an image loaded to this field should be accessible. Possible applications are default and commerce, where default means back-office and commerce means storefront. If the files or images that you want to upload through this field are going to be accessed only from back-office, then select default; if from both back-office and storefront, then select both default and commerce. Please be aware that this setting is not used when ACL Protected is set to No.

    Important

    • Fields of the Image type can be only of the Column table storage type.
    • These fields cannot be defined as identity fields for export/import operations.
    • Fields of the Image type are not displayed on a grid, so Show on Grid and Show Grid Filter properties cannot be defined for them.

    Warning

    Auditing is not available for actions with the entity fields of the File type.

    For the Select and Multi-select types:

    Additional Option Option Description
    Options

    Define values that will be included in the select list.

    • To add an option, click the +Add.
    • To set the default option, select the checkbox next to the option.
    • Click the Do not set as Default link to clear the Default checkboxes.
    • To move an option up or down on the list, drag the Move icon next to the option.
    • To delete an option, click x next to the option. When you delete an option, it is removed from all the entity records in the system where it is currently present.

    Important

    • The fields of the Select and Multi-Select types can be only of the Column table storage type.
    • These fields cannot be defined as identity fields for export/import operations.

    Warning

    When editing system select fields, note that some options could be defined as system and cannot be deleted.

    For relations (many to many, one to many, and many to one):

    Additional Option Option Description
    Target Entity Select the entity which record(s)to be tied with the records of the current entity.
    Related Entity Data Fields Select those fields of the entity selected in Target Entity which contain information that you want to see on the master entity record edit page. These could be a couple of important details in edition to the title which give you the most important information about the related entity record. Hold the Ctrl key to choose several fields.
    Related Entity Info Title Select the fields of the entity selected in the Target Entity field by which the users can identify the related entity record. These fields serve as a title to the related entity record on the master entity pages. Choose these fields carefully. It would be a good idea to select a related entity name or similar information. On the view page of the master entity record, these fields will appear as links to the corresponding related entity record. On the edit page of the master entity record, you will see these fields as titles of the section that contains information selected in Related Entity Data Fields . Hold the Ctrl key to choose several fields.
    Related Entity Detailed Select those fields of the entity selected in the Target Entity field which contain additional information that you want to see on the master entity record edit page. The values of the fields selected will be available in the dialog box that appears when you click the title of the related entity on the master page edit page. Hold the Ctrl key to choose several fields.

    Important

    • Relation fields can be only of the Column table storage type.
    • Relation fields cannot be defined as identity fields for export/import operations.
    • Relation fields type are not displayed on a grid, so Show on Grid and Show Grid Filter properties cannot be defined for them.

    Note

    Fields of the Text type are not displayed on a grid, so Show on Grid and Show Grid Filter properties cannot be defined for them.

    Oro Documentation
    • Oro inc
    • OroCommerce
    • OroMarketplace
    • OroCRM
    • OroPlatform
    • Partners
    • Services
    • Events
    • Twitter
    • Terms & conditions
    • Privacy policy
    • Contributor license agreement

    @2021 Oro, Inc. All Rights Reserved.

    Back to top