Origins

Support

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

Origins

WRDA_Origins

The WRDA_Origins view provides information on the origins defined in the Data Administration.

Relations

Field (WRDA_Origins)	Field	Table / View
InterstUnitID	UnitID	WRDA_Units
CountryGroupID	CountryGroupID	WRDA_CountryGroup
CurrencyID	UnitID	WRDA_Units
InterestUnitID	UnitID	WRDA_Units
EnergyCostRefUnitID*	UnitID	WRDA_Units
PlaceCostRefUnitID*	UnitID	WRDA_Units
GasCostRefUnitID*	UnitID	WRDA_Units
WaterCostRefUnitID*	UnitID	WRDA_Units
CreatorID	DAUserID	WRDA_Users
ModifierID	DAUserID	WRDA_Users
* Valid until version 13.0 Querying the values with validities must be done via the table value function dbo.val_WRDA_Origins.

Field description

Field	Description
DAOriginID	int, not null FACTON-internal ID of the origin or origin folder
DAOriginParentID	int, null FACTON-internal ID of the parent folder
IsGroup	bit, null Returns the value 0 if the current data row is an origin, otherwise the value 1 is returned for a folder.
OriginName	nvarchar(max), null Name of the origin in the Company language
OriginName _[Country identifier]	nvarchar(max), null Name of the origin in the language according to the country code. Example: OriginName_EN for the English name.
OriginIdentifier	nvarchar(50), null Semantic key of the origin
OriginDescription	nvarchar(max), null Description of the origin in the Company language
OriginDescription _[Country identifier]	nvarchar(max), null Description of the origin in the language according to the country code. Example: OriginDescription_EN for the English description.
Company	nvarchar(255), null Company
Contact	nvarchar(255), null Contact
Street	nvarchar(255), null Street
City	nvarchar(255), null City
ZipCode	nvarchar(255), null Zip code
Country	nvarchar(255), null Country identifier
As of version 10.1 CountryGroupID	int, null ID of the country group (see WRDA_CountryGroup)
OriginType	varchar(13), null The origin type: System Supplier Facility Customer StockExchange
CurrencyID	int, null ID for the currency of location tariffs (e.g. energy cost) All locational tariffs have the same currency The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
Interest	float, null Imputed interest for the origin type location For all other origin types the value 0 is returned; for folders the value null is returned. Note: The value 1 equals 100%.
InterestUnitID	int, null ID for the unit of the imputed interest rate. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
Valid until version 13.0 EnergyCost	float, null Value of the energy costs. Unit is [CurrencyID] / [EnergyCostRefUnitID]
Valid until version 13.0 EnergyCostRefUnitID	int, null Denominator ID for the unit of the energy costs. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
Valid until version 13.0 PlaceCost	float, null Value of the footprint costs. Unit is [CurrencyID] / [PlaceCostRefUnitID]
Valid until version 13.0 PlaceCostRefUnitID	int, null ID for the denominator for the unit of the footprint costs. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
Valid until version 13.0 GasCost	float, null Value of the gas costs. Unit is [CurrencyID] / [GasCostRefUnitID]
Valid until version 13.0 GasCostRefUnitID	int, null ID for the denominator for the unit of the gas costs. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
Valid until version 13.0 WaterCost	float, null Value of the water costs. Unit is [CurrencyID] / [WaterCostRefUnitID]
Valid until version 13.0 WaterCostRefUnitID	int, null ID for the denominator for the unit of the water costs. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Users table.
CreatorID	int, null Internal ID of the user who created the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
CreationDateTime	datetime, null Creation date of the data record
ModifierID	int, null Internal ID of the user who last updated the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
LastUpdateDateTime	datetime, null Modification date
Configured Attributes

Field

Description

DAOriginID

int, not null

FACTON-internal ID of the origin or origin folder

DAOriginParentID

int, null

FACTON-internal ID of the parent folder

IsGroup

bit, null

Returns the value 0 if the current data row is an origin, otherwise the value 1 is returned for a folder.

OriginName

nvarchar(max), null

Name of the origin in the Company language

OriginName
_[Country identifier]

nvarchar(max), null

Name of the origin in the language according to the country code.

Example: OriginName_EN for the English name.

OriginIdentifier

nvarchar(50), null

Semantic key of the origin

OriginDescription

nvarchar(max), null

Description of the origin in the Company language

OriginDescription
_[Country identifier]

nvarchar(max), null

Description of the origin in the language according to the country code.

Example: OriginDescription_EN for the English description.

Company

nvarchar(255), null

Company

Contact

nvarchar(255), null

Contact

Street

nvarchar(255), null

Street

City

nvarchar(255), null

City

ZipCode

nvarchar(255), null

Zip code

Country

nvarchar(255), null

Country identifier

As of version 10.1

CountryGroupID

int, null

ID of the country group (see WRDA_CountryGroup)

OriginType

varchar(13), null

The origin type:

System

Supplier

Facility

Customer

StockExchange

CurrencyID

int, null

ID for the currency of location tariffs (e.g. energy cost) All locational tariffs have the same currency

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

Interest

float, null

Imputed interest for the origin type location

For all other origin types the value 0 is returned; for folders the value null is returned.

Note: The value 1 equals 100%.

InterestUnitID

int, null

ID for the unit of the imputed interest rate.

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

Valid until version 13.0

EnergyCost

float, null

Value of the energy costs.

Unit is [CurrencyID] / [EnergyCostRefUnitID]

Valid until version 13.0

EnergyCostRefUnitID

int, null

Denominator ID for the unit of the energy costs.

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

Valid until version 13.0

PlaceCost

float, null

Value of the footprint costs.

Unit is [CurrencyID] / [PlaceCostRefUnitID]

Valid until version 13.0

PlaceCostRefUnitID

int, null

ID for the denominator for the unit of the footprint costs.

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

Valid until version 13.0

GasCost

float, null

Value of the gas costs.

Unit is [CurrencyID] / [GasCostRefUnitID]

Valid until version 13.0

GasCostRefUnitID

int, null

ID for the denominator for the unit of the gas costs.

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

Valid until version 13.0

WaterCost

float, null

Value of the water costs.

Unit is [CurrencyID] / [WaterCostRefUnitID]

Valid until version 13.0

WaterCostRefUnitID

int, null

ID for the denominator for the unit of the water costs.

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

CreatorID

int, null

Internal ID of the user who created the data record.

The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.

CreationDateTime

datetime, null

Creation date of the data record

ModifierID

int, null

Internal ID of the user who last updated the data record.

The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.

LastUpdateDateTime

datetime, null

Modification date

Configured Attributes