---
description: >-
  With the help of the schema templates you can predefine schemas and apply or
  store them at the different schemas.
---

# Schema Templates

## Row Layout

The row layout contains the actual calculation.

![Figure 1: Row layout](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2FvDpbGTEYOeYZtbkQAUtw%2FNachkalkulation-Schema-Reihe.png?alt=media\&token=dd3342a5-034c-4319-95df-a14062ee6539)

Here you can create completely individual schemas for your needs.\
The following table provides an overview of the different totaling types.

<details>

<summary>" "</summary>

The “empty” totaling type allows to work without row no.. This allows, for example, to assign “headings” for the upcoming lines.

</details>

<details>

<summary>Formula</summary>

With a formula you can e.g. summarize, multiply etc. individual lines. The following operators are available:\
Addition ( + ), subtraction ( – ), multiplication ( \* ), division ( / ), power ( ^ ).

</details>

<details>

<summary>Value</summary>

With a value you can give a fixed value to a line. e.g. 500

</details>

<details>

<summary>Item</summary>

Summarizes all items of the calculation, taking into account the stored filters.

</details>

<details>

<summary>Work Center</summary>

Summarizes all wok centers of the calculation, taking into account the stored filters.

</details>

<details>

<summary>Machine Center</summary>

Summarizes all machine centers of the calculation, taking into account the stored filters.

</details>

<details>

<summary>Individual Surcharge</summary>

You can assign individual surcharges for items, wok centers and machine centers. To do this, you must enter the row no. of the corresponding line for which you want to assign an individual surcharge in the “Formula field”. Individual surcharges are stored in a separate table.

</details>

<details>

<summary>Sales</summary>

Summarizes all calculated sales. See [sales](../post-calculation#sales)

</details>

### Show

This can be used to decide whether the field is displayed or hidden dynamically or statically in the schema.

### Bold

Specifies whether the line will be marked bold later in the schema.

### By Piece

The field "By piece" ensures that the calculated value of the line is again divided by the produced quantity. If the line is used in another formula, the calculation will also continue with the associated unit value. An exception is the type "Sale". Here it is divided by the sold quantity in the scheme.

### Filter

For items, work centers and machine centers you can store as many filters for the line as you like.

![Figure 2: Row filter](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2FjsoAaBPCW3XiWHlnETRG%2FNachkalkulation-Schema-Reihe-Filter.png?alt=media\&token=97dc90a5-03b9-4ad3-9e76-37a40b089743)

A filter can be stored for each field. The filtering is taken into account when evaluating the schemas. You can only pass filters where data records exist in the system. This prevents you from entering the wrong filters and causing problems when evaluating the calculation.

![Figure 3: Row filter - Example](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2FnTchzneM4yjg8W8yFRq5%2F004_Schemavorlage.png?alt=media\&token=0dbb727d-d07c-4147-8e1c-1f553852a9a4)

## Column Layout

In the column layout you can define your own columns.

![Figure 4: Column layout](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2FWshKwHLbPyTkbeP9VZDW%2F002_Schemavorlage.png?alt=media\&token=4fcc56f7-26ac-4886-90b5-804054cb6a33)

The following table describes the associated fields:

<details>

<summary>Column No.</summary>

Unique no. for the column.

</details>

<details>

<summary>Description</summary>

Here you can enter a description for this column.

</details>

<details>

<summary>Column Type</summary>

Deviation: If you store a deviation in the column type, deviation columns will be created for the associated columns that are stored in the formula.\
Formula: You can create individual columns that do not have the calculation as a basis, but other columns.

</details>

<details>

<summary>Amount Type</summary>

The amount type specifies the prices/costs you want your schema to be filled with.

</details>

<details>

<summary>Formula</summary>

The formula field is used to link individual columns. A formula must not refer to deviation columns.

</details>

## Process Columns

The Process Columns are only needed when using post calculation processes.

![Figure 5: Process Columns](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2Fb390GDuuRan7XfkZRAVH%2Fimage.png?alt=media\&token=24363d6b-a90f-48b5-8cd7-d456e5e139fe)

<details>

<summary>Column No.</summary>

Specifies the column no. of the process

</details>

<details>

<summary>Description</summary>

Specifies the description of the column. This description will be displayed later in the process for the associated column. By default, it is composed of the description of the row and the column from the template.

</details>

<details>

<summary>Formula</summary>

Specifies a formula for calculating the group line for this column.

</details>

<details>

<summary>Template Column No.</summary>

Specifies the column no. of the template

</details>

<details>

<summary>Template Row No.</summary>

Specifies the row no. of the template

</details>

<details>

<summary>Totaling Type</summary>

Specifies how the columns should be calculated in case of a group line.

</details>

## Individual surcharge

The individual surcharge is a possibility to individually value single (or several) items, machine centers or work centers.\
Via the search you can find the precalculation surcharges

![Figure 6: Individual surcharge](https://2726909081-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkaM8UujMSUzWXmRYLgik%2Fuploads%2FdwGgtlwqF1c9CsN2WrhA%2F005_Schemavorlage.png?alt=media\&token=13a96257-f337-4233-9f8e-dca512ac4edc)

In principle, 3 “areas” must be distinguished. The following table lists the hierarchy for the surcharges.

{% hint style="info" %}
Hierarchy (Descending) – corresponds to the “Type” field
{% endhint %}

<details>

<summary>Item</summary>

Item, Item Category, All Items

</details>

<details>

<summary>Machine Center</summary>

Machine Center, All Machine Center, Work Center, All Work Centers, Work Center Group

</details>

<details>

<summary>Work Center</summary>

Work Center, All Work Centers, Work Center Group

</details>
