Project data

Support

support@facton.com
+49 1805-FACTON
Customer Portal

Project data

WRProject

Relations

Field (WRProject)	Field	Table / View
CurrencyID	UnitID	WRUnits
ProjectType	EnumID	Constants
QuantityModusType	EnumID	Constants
ExportState	EnumID	Constants
MPB_LOC_ID	DAOriginID	WRDA_Origins

Field description

Field	Description
ProjectID	primary key, int, not null Internal ID of the project
ProjectNumber	nvarchar(255), null Project Number
CaptionDefault	nvarchar(255), null Label of the project in the Company language.
CaptionDE	nvarchar(255), null German label of the project.
CaptionEN	nvarchar(255), null English label of the project.
ProjectType	int, null Project type (e.g. single or multi project) The label of the project type can be determined via the foreign key (EnumID) in the Constants table.
Number_of_Years	int, null Number of production years Production years during the year are counted as full year.
Quantity	bigint, null Total quantity over project lifetime (net value).
Obsolete as of version 9.1 QuantityModusType	int, null The settings made by the user for the quantity calculation (adding up, distributing) The label of the mode can be determined via the foreign key (EnumID) in the Constants table. With version 9.1 the input of the quantity in the Project Cockpit has been revised. For backward compatibility reasons, the value EnumID is returned for Adding up.
OrderNumber	nvarchar(255), null Order number
DES_OF	nvarchar(255), null Label of the cost center filter set at the project.
CurrencyID	int, null ID of the project currency The label of the currency can be determined via the foreign key (UnitID) in the WRUnits table.
SOP	datetime, null Start date of production
EOP	datetime, null End date of production
SOI	datetime, null Start date of investment
EOI	datetime, null End date of investment
MPB_CalculationBase	nvarchar(255), null Defined calculation base for the material surcharge Stock: MSRIsStockExchangeCalcBase Customer: MSRIsCustomerCalcBase
MPB_LOC_ID	int, null Internal customer ID selected as price base for calculating the material surcharge defined at the project. The label of the customer can be determined via the foreign key (DAOriginID) in the WRDA_Origins view.
Is_Version	bit, null Returns the value 0 if it is the current status of work, otherwise the value 1.
Creator	nvarchar(255), null Name of the creator
Modifier	nvarchar(255), null Name of the user who last modified the project.
CreaDate	datetime, null Creation date
LastUpdate	datetime, null Modification date
ProjektExportDate	datetime, null Date and time the project was exported for Web Reporting on.
ExportState	int, null Internal ID of the Web Reporting export status The label of the export status can be determined via the foreign key (EnumID) in the Constants table.
Configured Attributes

Field

Description

ProjectID

primary key, int, not null

Internal ID of the project

ProjectNumber

nvarchar(255), null

Project Number

CaptionDefault

nvarchar(255), null

Label of the project in the Company language.

CaptionDE

nvarchar(255), null

German label of the project.

CaptionEN

nvarchar(255), null

English label of the project.

ProjectType

int, null

Project type (e.g. single or multi project)

The label of the project type can be determined via the foreign key (EnumID) in the Constants table.

Number_of_Years

int, null

Number of production years

Production years during the year are counted as full year.

Quantity

bigint, null

Total quantity over project lifetime (net value).

Obsolete as of version 9.1

QuantityModusType

int, null

The settings made by the user for the quantity calculation (adding up, distributing)

The label of the mode can be determined via the foreign key (EnumID) in the Constants table.

With version 9.1 the input of the quantity in the Project Cockpit has been revised. For backward compatibility reasons, the value EnumID is returned for Adding up.

OrderNumber

nvarchar(255), null

Order number

DES_OF

nvarchar(255), null

Label of the cost center filter set at the project.

CurrencyID

int, null

ID of the project currency

The label of the currency can be determined via the foreign key (UnitID) in the WRUnits table.

SOP

datetime, null

Start date of production

EOP

datetime, null

End date of production

SOI

datetime, null

Start date of investment

EOI

datetime, null

End date of investment

MPB_CalculationBase

nvarchar(255), null

Defined calculation base for the material surcharge

Stock: MSRIsStockExchangeCalcBase
Customer: MSRIsCustomerCalcBase

MPB_LOC_ID

int, null

Internal customer ID selected as price base for calculating the material surcharge defined at the project.

The label of the customer can be determined via the foreign key (DAOriginID) in the WRDA_Origins view.

Is_Version

bit, null

Returns the value 0 if it is the current status of work, otherwise the value 1.

Creator

nvarchar(255), null

Name of the creator

Modifier

nvarchar(255), null

Name of the user who last modified the project.

CreaDate

datetime, null

Creation date

LastUpdate

datetime, null

Modification date

ProjektExportDate

datetime, null

Date and time the project was exported for Web Reporting on.

ExportState

int, null

Internal ID of the Web Reporting export status

The label of the export status can be determined via the foreign key (EnumID) in the Constants table.

Configured Attributes

WRProductionPlanning

The table provides properties of the production planning over the project lifetime.

Relations

Field (WRProductionPlanning)	Field	Table / View
CountryGroupID	CountryGroupID	WRDA_CountryGroup

Field description

Field	Description
ProjectID	primary key, int not null Returns the internal ID of the project.
Year	primary key, int not null Returns the calculation year.
Quantity	bigint, null Net quantity in the calculation year: Year
Valid as of version 11.3 GrossQuantity	bigint, null Gross quantity in the calculation year: Year
Valid as of version 11.3 Deduction	real, null Quantity deduction between gross and net quantity in the calculation year: Year
BasicDataType	nvarchar(255), null Returns the label of the basic data type for the calculation year (Year) in the Company language valid at the time of the project export.
Lots	int, null Returns the lot size for the calculation year (Year).
As of version 10.1 CountryGroupID	int, null Returns the country group of the receiving country for the calculation year (Year). The label of the country group can be determined via the foreign key (CountryGroupID) in the WRDA_CountryGroup view.
As of version 10.1 CountryGroupIsOverwritten	Bit, null Returns the value 1 if the country group was overwritten for the calculation year (Year), otherwise the value 0.

Field

Description

ProjectID

primary key, int not null

Returns the internal ID of the project.

Year

primary key, int not null

Returns the calculation year.

Quantity

bigint, null

Net quantity in the calculation year: Year

Valid as of version 11.3

GrossQuantity

bigint, null

Gross quantity in the calculation year: Year

Valid as of version 11.3

Deduction

real, null

Quantity deduction between gross and net quantity in the calculation year: Year

BasicDataType

nvarchar(255), null

Returns the label of the basic data type for the calculation year (Year) in the Company language valid at the time of the project export.

Lots

int, null

Returns the lot size for the calculation year (Year).

As of version 10.1

CountryGroupID

int, null

Returns the country group of the receiving country for the calculation year (Year).

The label of the country group can be determined via the foreign key (CountryGroupID) in the WRDA_CountryGroup view.

As of version 10.1

CountryGroupIsOverwritten

Bit, null

Returns the value 1 if the country group was overwritten for the calculation year (Year), otherwise the value 0.

WRProjectMonthQuantities

Available as of version 9.1

The table provides the monthly quantities in the project.

The ExportMonthlyQuantities exporter must be active in the Settings.

Field description

Field	Description
ProjectID	primary key, int not null Internal ID of the project
Year	primary key, int not null Fiscal Year
Month	primary key, int not null Month as integer
Quantity	bigint, null Monthly quantity (net value)
CalendarYear	int, null Calendar year

WRProjectMonthSalesprices

Available as of version 10.1

The table provides the monthly quantities in the project.

It requires activating the ExportMonthlySalesPrice exporter in the Settings.

Field description

Field	Description
ProjectID	primary key, int not null Internal ID of the project
Year	primary key, int not null Calendar years
Month	primary key, int not null Month as integer The price valid for the fiscal year has the value 2147483647 for the field Month.
Price	decimal(28,9), null Sales Price.
DeltaAbs	decimal(28,9), null Absolutes Delta The value is null if no delta was defined.
DeltaPercent	decimal(28,9), null Percentage delta The delta value 4% is returned as 4. The value is null if no delta was defined.
Configured Attributes

WRProjectBasicData

The table returns the percentage and absolute surcharge rates defined at the project.

Relations

Field (WRProjectBasicData)	Field	Table / View
SurchargeID	SurchargeID	WRSurcharge
UnitID	UnitID	WRUnits

Field description

Field	Description
ProjectID	primary key, int not null Internal ID of the project
Year	primary key, int not null Fiscal Year
SurchargeID	primary key, int not null Internal ID of the surcharge rate The label of the surcharge can be determined via the foreign key (SurchargeID) in the WRSurcharge table.
Value	decimal(28,9), not null Value of the surcharge (SurchargeID) for the calculation year (Year) A percentage surcharge of 4% is returned as 4.
VariablePortion	decimal(28,9), not null Variable share for absolute surcharges. A variable share of 50% is returned as 50. Percentage surcharges are returned as 0.
UnitID	int, null Internal ID of the surcharge rate unit. The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.
IsPercent	bit, not null Returns the value 1 if the surcharge was defined as percentage, otherwise the value 0 is returned.
IsOverridden	bit, not null Returns the value 1 if the surcharge was overwritten in the project, otherwise the value 0 is returned.

WRProjectCost

The table provides the costs on project level. The export also includes cost elements that are not shown in the application (hidden cost information).

Relations

Field (WRProjectCost)	Field	Table / View
SurchargeID	SurchargeID	WRSurcharge

Field description

Field	Description
ProjectID	primary key, int not null Internal ID of the project.
Year	primary key, int not null Fiscal Year
SurchargeID	primary key, int not null Internal ID of the cost element. The label of the cost element can be determined via the foreign key (SurchargeID) in the WRSurcharge table.
Value	decimal(28,9), null Unit costs of the cost element (SurchargeID) in project currency (see CurrencyID in the WRProject table). The unit costs contain the variable and fix shares.
ValueVar	decimal(28,9), null Variable unit costs of the cost element (SurchargeID) in project currency (see CurrencyID in the WRProject table).
ValueTotal	decimal(28,9), null Total cost value (fix + variable)
ValueTotalVar	decimal(28,9), null Variable unit cost in project currency.
Rate	real, null Value of the surcharge rate at cost elements defined as percentage surcharge, otherwise the value null is returned. A surcharge of 4% is returned as 4.

WRProjectSubProjects

The table provides the sub-projects of a project or project version. The first-level sub-projects (direct children) are provided for projects.

Field description

Field

Description

ProjectID

primary key, int not null

Internal ID of the project

SubProjectID

primary key, in, not null

Internal ID of the directly embedded sub-projects

OrderID

primary key, int not null

Ascending order of the directly embedded sub-projects

WRProjectCustomsTariffRates

Valid as of version 10.1

The table returns the customs tariffs valid at the project.

Relations

Field (WRProjectCustomsTariffRates)	Field	Table / View
CustomsTariffRateId	DACustomsTariffID	WRDA_CustomsTariffs

Field description

Field

Description

ProjectID

primary key, int not null

Internal ID of the project or a project version.

CustomsTariffRateId

primary key, int not null

Internal ID of the customs tariff

Tariff information are provided by the WRDA_CustomsTariffs view. This ID can also be used as a foreign key (DACustomsTariffID).

WRProjectValidities

The table provides the attribute values with validities configured at the project. Attribute values with validities are currently only used in customer-specific extensions (plugins); they are currently only defined for the Floating-point number data type.

Relations

Field (WRProjectValidities)	Field	Table / View
UnitID	UnitID	WRUnits
RefUnitID	UnitID	WRUnits

Field description

Field	Description
ProjectID	primary key, int not null Internal ID of the project
ColumnName	primary key, nvarchar(255), not null Internal label of the attribute
Year	primary key, int not null Fiscal Year
Value	float, null Value of the attribute (ColumnName) Currently, only the Floating-point number data type is supported.
UnitID	int, null Internal ID of the numerator unit The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.
RefUnitID	int, null Returns an ID for the denominator unit The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.

WRProjectCurrencyRate

Valid as of version 8.0

The table provides the exchange rates used at the project.

Relations

Field (WRProjectCurrencyRate)	Field	Table / View
CurrencyRateID	CurrencyRateID	WRCurrencyRates

Field description

Field

Description

ProjectID

primary key, int not null

Internal ID of the project

Year

primary key, int not null

Fiscal Year

CurrencyRateID

primary key, int not null

Internal ID of the exchange rates valid in the project.

The exchange rate can be determined via the foreign key (CurrencyRateID) in the WRCurrencyRates table.

WRExchangeRate

Valid as of version 8.0 replaced by the WRProjectCurrencyRate table

Relations

Field (WRProjectCustomsTariffRates)	Field	Table / View
From_Currency	UnitID	WRUnits
To_Currency	UnitID	WRUnits

Field description

Field	Description
ProjectID	primary key, int not null Internal ID of the project or a project version.
Year	Fiscal Year
From_Currency	ID of the currency converted from. The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.
To_Currency	ID of the currency converted to. The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.
ExchangeRate	Exchange rate
FromCurrencyResolved	Label of the currency the exchange rate is converted from.
ToCurrencyResolved	Label of the currency the exchange rate is converted to.
FromCurrencyShort	All short labels of the currency the exchange rate is converted from.
ToCurrencyShort	All short labels of the currency the exchange rate is converted to.

Project-specific location

WRProjectLocation

Available as of version 11.2

Relations

Field (WRProjectLocation)	Field	Table / View
ProjectID	ProjectID	WRProject
DA_ID	DAOriginID	WRDA_Origins
CountryGroupID	CountryGroupID	WRDA_CountryGroup

Field description

Field	Description
LocationID	primary key, int not null Internal ID of the location
LocationID_FACTON	int, not null Reference to the FACTON-internal ID of the location
ProjectID	int, not null Internal Project ID the location is used at Information on the project can be determined via the foreign key (ProjectID) in the WRProject table.
DA_ID	int, null The internal ID of the location in the Data Administration. The location in the Data Administration can be determined via the foreign key (DAOriginID) in the WRDA_Origins view.
LocationIdentifier	nvarchar(255), null Semantic key of the location
CaptionDefault	nvarchar(255), null Label of the location in the Company language.
CaptionDE	nvarchar(255), null German label of the location.
CaptionEN	nvarchar(255), null English label of the location.
Street	nvarchar(255), null Company
ZipCode	nvarchar(255), null Contact
City	nvarchar(255), null Street
Company	nvarchar(255), null City
Contact	nvarchar(255), null Zip code
Country	nvarchar(255), null Country identifier
CountryGroupID	int, null ID of the country group (see WRDA_CountryGroup)
Configured Attributes

WRProjectLocationParameter

Available as of version 11.2

The WRProjectLocationParameter table provides the location parameters defined (entered) at the project. The values relevant to the calculation for a year can be determined via the table value function fn_GetProjectLocationParameters.

Relations

Field (WRProjectParameterLocation)	Field	Table / View
LocationID	LocationID	WRProjectLocation
UnitID	UnitID	WRUnits
RefUnitID	UnitID	WRUnits

Field description

Field	Description
LocationID	primary key, int not null Internal ID of the location
Year	int not null The year the location parameter value is defined in
Name	nvarchar(255), not null Internal name of the location parameter
Value	float, null Value of the location parameter Name in year Year.
UnitID	int, null Internal ID of the numerator unit The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.
RefUnitID	int, null Returns an ID for the denominator unit. The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.
HasAnnualValidies	Bit, not null Returns the value 1 if annual validities were entered for the parameter, otherwise the value 0 is returned.

Simulated Location Parameters

Copy

GetProjectLocationParameters
SELECT simulated.*, origin.Value AS OriginValue 
FROM dbo.fn_GetProjectLocationParameters(@Test_LocationID, @YearRange, NULL) simulated
LEFT JOIN dbo.WRProjectLocationParameter origin ON simulated.LocationID = origin.LocationID AND simulated.Name = origin.Name AND simulated.[Year] = origin.[Year]
ORDER BY simulated.[Name], simulated.[Year]

Project-specific Shift Model

WRProjectShiftModel

Available as of version 11.2

The WRProjectShiftModel table provides information on shift models used at a project.

Relations

Field (WRProjectShiftModel)	Field	Table / View
ProjectID	ProjectID	WRProject
DA_ID	DAShiftModelID	WRDA_ShiftModels

Field description

Field	Description
ShiftModelID	primary key, int not null Internal ID of the shift model
ShiftModelID_FACTON	int not null Reference to the FACTON-internal ID of the shift model
ProjectID	int not null Internal project ID the shift model is used at. Information on the project can be determined via the foreign key (ProjectID) in the WRProject table.
DA_ID	Int, null The internal ID of the shift model in the Data Administration. The shift model in the Data Administration can be determined via the foreign key (DAShiftModelID) in the WRDA_ShiftModels view.
ShiftModelIdentifier	nvarchar(255), null Semantic key of the shift model
CaptionDefault	nvarchar(255), null Label of the shift model in the Company language.
CaptionDE	nvarchar(255), null German label of the shift model.
CaptionEN	nvarchar(255), null English label of the shift model.
Configured Attributes

WRProjectShiftModelParameter

Available as of version 11.2

The WRProjectShiftModelParameter table returns the values for the configured shift model parameters defined at the project.

Shift model parameters can be configured in the FACTON system settings (System | Worker).

Relations

Field (WRProjectShiftModelParameter)	Field	Table / View
ShiftModelID	ShiftModelID	WRProjectShiftModel
UnitID	UnitID	WRUnits

Field description

Field	Description
ShiftModelID	primary key, int not null Internal ID of the location
Year	int not null The year the shift model parameter value is defined in
Name	nvarchar(255), not null Internal name of the shift model parameter The following shift model parameters are defined: ShiftValueEmp (max. capacity of the worker) ShiftValueDev (max. capacity of the machine) ShiftAdditionOne (first percentage surcharge) ShiftAdditionTwo (second percentage surcharge) ShiftAdditionThree (third percentage surcharge) FreeAbsoluteAdditionOne (first absolute surcharge) FreeAbsoluteAdditionOneVar (first variable surcharge) FreeAbsoluteAdditionTwo (second absolute surcharge) FreeAbsoluteAdditionTwoVar (second variable surcharge)
Value	float, null Value of the shift model parameter Name in year Year.
UnitID	int, null Internal ID of the unit The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table.

Simulated Shift Model Parameters

Copy

GetProjectShiftModelParameters
SELECT simulated.*, origin.Value AS OriginValue 
FROM dbo.fn_GetProjectShiftModelParameters(@Test_ShiftModelID, @YearRange, NULL) simulated
LEFT JOIN dbo.WRProjectShiftModelParameter origin ON simulated.ShiftModelID = origin.ShiftModelID AND simulated.Name = origin.Name AND simulated.[Year] = origin.[Year]
ORDER BY simulated.[Name], simulated.[Year]