General
Overview - Views
| View | Description |
|---|---|
WRVersionInfoView |
Contains information on project versions and the current status of work. |
Overview - Tables
| Table | Description |
|---|---|
|
General project information incl. project lifetime. |
|
|
Contains project-related sub-projects including their order. |
|
|
Validity-bound properties at a project. Note: Properties with validities are provided in customer-specific extensions (plugins); they are currently not supported in the Standard. |
|
|
Contains the cost elements aggregated on project level over lifetime. |
|
|
Information on cost elements, such as label and short label. |
|
|
Contains project-specific overhead cost and surcharges over project lifetime. |
|
|
Contains information on production planning, such as quantities and basic data type over project lifetime. |
|
|
Monthly quantity processes for project and project versions. |
|
|
Monthly sales prices for project and project versions incl. delta. |
|
|
Customs tariffs used in the project over lifetime. |
|
|
Country group for customs over lifetime defined at the part. |
|
|
Valid until version 6.4 |
Exchange rates for project and project versions. The table was replaced by WRCurrencyRates and WRProjectCurrencyRate. |
|
Table with all exchange rates incl. project-specific ones. |
|
|
Contains the exchange rates used in the project as reference to the table: WRCurrencyRates. |
|
|
Information on investments, such as label and cost rate, used at the project and project versions. |
|
|
Investment key figures, such as cash value and internal interest rate, for projects and project versions. |
|
|
Pay in and pay out dates of investments in the project. |
|
|
Information on parts in projects and project versions. |
|
|
Part costs over project lifetime. |
|
|
Validity-related part properties over project lifetime. |
|
|
Information on manufacturing processes in projects and project versions. |
|
|
Costs of manufacturing processes over project lifetime. |
|
|
Cost rates of manufacturing processes over project lifetime |
|
|
Validity-related properties at manufacturing processes over project lifetime. |
|
|
|
|
|
|
|
|
|
|
|
Information on units, such as label, short label, and base unit. |
|
|
Information on FACTON-internal constants. |
|
WRLogBatchExport |
|
WRLogProjectExport |
|
Configured Attributes
Configured attributes can be defined in the system settings at almost all calculations objects (e.g. projects, purchased parts, versions). For Web Reporting, these attributes are provided as additional fields in the corresponding tables and views. The label of the fields correlates with the internal attribute labels. The data type of the field is determined by the attribute's data type. Data types in FACTON are converted into database data types as follows.
| FACTON Data Type | Database Data Type |
|---|---|
|
String |
Nvarchar(255), null |
|
Link/Document |
Nvarchar(255), null |
|
Integer |
Int, null |
|
Floating-point number |
Float, null |
|
Yes/No-Value |
Bit, null |
|
Date |
Datetime, null |
Customer-specific Attributes
Customer-specific attributes can be defined by the user at almost all calculation objects. If the view or table provides customer-specific attributes, an own data row is created for each attribute.
| Field | Description |
|---|---|
AttributeName |
nvarchar(255), null Label of the customer-specific attribute. |
AttributeStringValue |
varchar(max), null Value of the version attribute for the FACTON data types String and Link/Document. |
AttributeLongValue |
bigint, null Value of the version attribute for the FACTON data type Integer. |
AttributeDoubleValue |
float, null Value of the version attribute for the FACTON data type Floating-point number. |
AttributeDateValue |
datetime, null Value of the version attribute for the FACTON data type Date. |
AttributeBoolValue |
bit, null Value of the version attribute for the FACTON data type Yes/No-Value.
|
AttributeVisibilityValue |
int, null |
AttributeType |
varchar(21), null The FACTON data type of the customer-specific attribute. The field can assume the values String, Integer, Floating-point number, Link/Document, Date, Yes/No-Value and null. |
Multilingual Properties
Properties like labels can be defined in multiple languages in FACTON. These properties are always exported in the company language, German and English.
Other language values are currently not provided in Web Reporting.
The company language is used in FACTON for displaying missing language values. For example, if a project label was entered in German and English, but not in French, the English label is displayed as French content language when English is set as company language.
The company language is defined in the FACTON language settings according to their order. Hence, the company language equals the first language below the neutral language. If only one language is defined besides the neutral language, the entry of multilingual texts is impossible and the neutral language automatically becomes the company language.
