Master Data Import Templates
This section describes the properties of the Excel templates (Version: 9.0.0.1) for importing and updating to the Should Costing Solution.
Each release provides you with new Excel templates for the import into the FACTON Should Costing Solution.
Download the Excel templates:
Selection Lists
Global Properties
|
Excel template: Company Own Overhead Rates |
|
|
Excel template: Company Own Wages |
|
|
Excel template: Company Own Location Factors |
|
|
Excel template: Company Own Exchange Rates |
Resources
If you are working with a SC / DC FACTON system, you must use the following Excel template for material:
|
|
Excel template: SC/DC Material (incl. Value Rules) |
Structure of Excel templates
Metadata of Excel Templates
The metadata of the Excel template is required for the correct allocation of the imported data and should not be edited. In the orange table, you maintain the metadata or data that applies equally to the entire data table.
The following three types of metadata and Excel templates are distinguished:
Metadata of Resources
- SheetVersion shows the version of the Excel template.
- #ObjectType shows the type of the files to be imported.
- _Signature shows which master data are imported.
Metadata of Resources including Value Rules
- SheetVersion shows the version of the Excel template.
- #ObjectType shows the type of the files to be imported.
- #Host._Signature shows for which resources the value rules are imported. A correct allocation during the import is only possible in combination with #Host.Key and #Host.DataRecordOrigin.Key, to be found in the data table.
- #ValueRuleProperty shows the leading dimension depending property. Generally, dimensions are in the fixed columns on the left in the Excel template.
- #DefiningSignature shows the name of the signature at which the value rules were defined. This is optional and, unless further defined, the host signature name is used.
- Examples for the usage in the Excel templates can be found for:
- Material
- Machine
- Examples for the usage in the Excel templates can be found for:
An example for illustration:
For further information on dimension-depending properties, see: Global Properties
Metadata of Global Properties
- SheetVersion shows the version of the Excel template.
- #ObjectType shows the type of the files to be imported.
- #Host._Signature shows to which superordinate data area the value rules are to be imported.
- #ValueRuleProperty shows the leading dimension depending property. Generally, dimensions are in the fixed columns on the left in the Excel template.
Data Table
The data table contains all data for the Excel import.
Figure: Extract from the Excel template
Excel rows
With every Excel row, you determine additional master data for the import.
Excel columns
With every Excel column, an additional property from the master data are defined. The column names can vary with every release. The version of the Excel template has to match the release version of FACTON.
New columns can be added to the Excel templates from FACTON in the scope of customizing FACTON® or by an authorized partner.
Supported Data Types
Unit-Dependent Values
Master data with unit values (e.g. duration) always consist of two columns: one for the value and one for the unit.
The unit value duration of work steps consists of the properties:
| Duration.Number: | Value of the duration, e.g. 1 |
| Duration.Unit: | Unit of the duration, e.g. TMU |
Localized Values
Localized values can be shown as dependent or independent from language.
In order to show language-independent texts, you need to use »Invariant« as suffix (e.g. column »Label.Invariant« or »Description.Invariant«). In order to show language-dependent texts, use the ISO Two Letter Language Code as suffix for the property name (e.g. column »Label.de« and »Label.en«).
In the Details view, you can fill in »Description«, »Description (de)« and »Description (en)«.
| Label.Invariant: | Text independent from language, e.g. Machine |
| Label.de: | Text dependent from language, e.g. (de) Spritzguss |
| Label.en: | Text dependent from language, e.g. (en) Injection Molding |
Boolean (Logical Values):
The boolean type has two value forms. The truth value is either »TRUE« or »FALSE« .
Integer
The number type is for integers.
Number
The number type is for floating point figures with or without decimal places. In FACTON, the values are rounded to the twelfth decimal place.
String
The text type is for character strings of variable length.
Date
The date type is for date specification.
Single-Selection List:
A single semantic key is entered into the single selection list.
Example
This entry of the Excel template in the FACTON client stands for the Material Classification "Basic Material » Metal » Steel » Basic Steel".
Multi-Selection List:
Several semantic keys are entered into the multi-selection list.
The semicolon can be masked with the escape character »\«.
Example
This entry of the Excel template in the FACTON client stands for the Manufacturing Methods "Primary Shaping » Casting" and "Primary Shaping » Extrusion".
Identify Semantic Keys in FACTON
You can identify the semantic keys to use them for Excel imports by running queries in FACTON. The place where to use the semantic key in the Excel template is shown in the column XXX.Key.
Identify Semantic Keys
- You are logged in as a Master Data Administrator.
- You are in the Master Data workspace.
- In the Explorer ► Queries, click on the ► in front of SC Solution Data.
- Click on Semantic Keys for Selection Lists.
A new tab »Query: Semantic Keys for Selection Lists« opens where you can determine specific query parameters.
- Define your query parameters.
- Click the
Run button to run the query. All matching data are shown in the Result view.
