Input tables of AppOne

A unique internal identifier of the case.

A numeric value (Liters, Euro’s, Weight, etc.).

Group to which the amounts belong (High, Med, Low).

The department of a case.

The owner of a case (User name, ID, department).

Categorization of a case (Simple case, Complex Case, Case department).

Descriptive field about a case customer (Customer, Brand, Relationship nr, company).

Group of customers.

Descriptive field about a supplier (Company, Brand, Relation).

Group of suppliers.

Group of variants.

The events in a case (Open, Close, Screen X, Document created, etc.)

Format: YYYY-M-D h:mm[:ss[[.zzz]]] the end time of an activity / timestamp of an activity.

If activities take place on the same time (in parallel), you can define their order here.

Grouping of activities (Finance steps, Payments, etc.).

Order of activity type in the legend.

Country where the event(activity) took place.

Cost involved in the execution of the event. For example, employee wages.

Time that is actually worked on the event without taking into account any waiting time.

Information related to the event.

Unique identifier of the event.

Format: YYYY-M-D h:mm[:ss[[.zzz]]]. If an activity has a start and end time defined you can map the start time of the activity here.

URL where more info about each event can be found.

Define if the event is automated or not.

Define if this is an (expected) end/close activity to define the end of a process.

Define if this is an (expected) start/open activity to define the start of a process.

Team which executed the activity.

Description of the tag.

Name of the tag.

A tag score.

Format: YYYY-M-D h:mm[:ss[[.zzz]]] the end time of the activity / timestamp of the activity, related to the Due date.

Name of the Due date.

Reference to the unique Event ID in Events_base.

Format: YYYY-M-D h:mm[:ss[[.zzz]]] the date on which the activity should have been finished.

Amount related to the Due date, often this will be a penalty or a discount.

The events of a case.

Name of the Reference model.

Default period for the period filter. If not set, the default will be All.

The History and/or Distribution charts are collapsed by default.