Data Definition

  • The data definition allows creation of arbitrary data structures and the relationship of those structures. The data definition can be performed by persons with no particular IT-Expertise. It is possible to change the Data Definition at any time without initiating a high effort change project.
    • Rapid Produtyping Prozess

    Object Types

    • Selection of the name and the icon of the object type (e.g. Customer)
    • The optional historization of the objects allows full tracking of changes
    Data Admin

    Data Elements

    Each object type can have any number of Data Elements. Data elements can be simple attributes like text and number but also more complex data structures like fully flexible tables and grids. Historization may be enabled individually for each data element for full tracking of changes. The Data Classification allows administrators to define a classification that may be used to set user group authorizations (read-only, read/write or no access) to each individual data element. The check box "Required" defines the data element as required.

    The following types of Data Elements are supported:

    Text

    • Number of rows, max length and access (read-only or read/write) can be configured
    • Validation of the text entry over a regular expression
    • Default values can be a fixed value or dynamically generated over a report
    • The text can be set to represent a clickable hyperlink (URL and E-Mail)

    Numbers

    • Configurable maximum and minimum value
    • The number of decimals can be freely configurable
    • An optional prefix and/or suffix can be defined. Allows for example the unit (km, $) of the number to be shown
    • Default values may be fixed or dynamically generated over a report

    Date/Time

    • This Data Element can represent a Date and/or a Time
    • A maximum and a minimum Date and/or Time can be defined
    • Default values can be a fix Date/Time, relative to the current date or generated from a report

    Structure Relation

    • Defines a link between two Object Types
    • The link may be a simple 1 to 1 relation (e.g. an order to a customer) or a multiple 1 to N relation (e.g. several products to one order)
    • The link may optionally contain related data (Text, date/time, number or simple object links). That way the relation between a product and an order may contain the number of ordered products

    Action

    • Allows the execution of a custom action. An action may transform data in the BeeCore database, transfer data from another database to BeeCore or transfer data from the BeeCore database to another database

    Report

    • Provides a flexible mechanism for defining arbitrary data evaluations and reports
    • Table style reports with optional color formatting
    • Document style PDF reports

    Grid

    • A highly configurable Table-Style Data Element for data capture, calculation and/or data display
    • The table may contain 2 to 5 dimensions
    • Rows and columns can be dynamically generated from a report
    • Default data can be sourced from another grid or from a different data source
    Administration der Ansichten

    Screen Definition

    The Data Elements of an Object Type can be presented to the user on a number of screens.
    Every Data Element can be placed on any of up to 9 different tabs of the object detail. The access to the tabs can be controlled over authorizations. That way one tab of a project can contain information that only should be visible to the project manager. Other users can not access that tab.

     

    Data Entry Datenerfassung