Parts
WRPart
The table provides the parts of a project.
Relations
| Field (WRPart) | Field | Table / View |
|---|---|---|
ProjectID |
ProjectID |
|
SubprojectID |
ProjectID |
|
PartType_FACTON |
EnumID |
|
CurrencyID |
UnitID |
|
QuantityUnitId |
UnitID |
|
DA_ID |
DAPartID |
Field description
| Field | Description |
|---|---|
PartID |
primary key, int, not null Internal ID of the part |
PartID_FACTON |
int, not null Reference to the FACTON-internal ID of the part |
ProjectID |
int, not null Internal ID of the project The ProjectID field can be used as foreign key in the WRProject table. |
PartType_FACTON |
int, not null ID of the part type (e.g. purchased part, assembly) The PartType_FACTON field can be used as foreign key in the Constants table. |
PartNumber |
nvarchar(255), null Part number |
CaptionDefault |
nvarchar(255), null Label of the part in the Company language. |
CaptionDE |
nvarchar(255), null German label of the part. |
CaptionEN |
nvarchar(255), null English label of the part. |
ParentID |
int, null ID of the parent part For the top-level assembly, the value null is returned. |
CurrencyID |
int, null ID of the currency the part is calculated in. The currency can be determined via the foreign key (CurrencyID) in the WRUnits table. Note: The original currency can only be determined if it has not been changed over the project lifetime. |
RelativeQuantity |
decimal(28,9), null Position-specific quantity of the part |
AbsoluteQuantity |
decimal(28,9), null Absolute quantity of the part over the whole project structure |
QuantityUnitId |
int, null ID of the quantity unit The QuantityUnitId field can be used as foreign key in the WRUnits table. |
SubprojectID |
int, null ID of the project if the part was inserted as sub-project If the part was not inserted as sub-project, the value -1 is returned. The SubprojectID field can be used as foreign key in the WRProject table. |
Path |
nvarchar(255), null Path of the part in the project structure The path is generated from the naming of the parent parts in the Company language (incl. the project name) and the separator \. Example: \Servomotor\Assembly |
Level |
int, null BOM level BOM level 1 equals the top-level assembly. |
LiningLevel |
nvarchar(255), null Structural level of the part Example for 1.1.2: The part is located at the second position of the third level. |
Sort |
int, null Position of the part within the structural level Example for 2: The part is located at the second position of the structural level. |
CalcMode |
int, null Calculation Mode The CalcMode field can assume the following values: -1: Standard mode 0: Estimation mode 6: Offer mode 1: Forecast mode 7: Scaling mode |
IsParentPathModusBase |
bit, null Returns the value 1 if the parent part is calculated in "Standard" mode. |
DA_ID |
int, null ID of the part in the Data Administration Returns the value null if no master data reference is available (e.g. at assemblies). The DA_ID field can be used as foreign key in the WRDA_Parts table. |
|
Available as of version 10.1 CustomsTariffNumberID |
int, null The ID of the customs tariffs number of the part The CustomsTariffNumberID field can be used as foreign key in the WRDA_CustomsTariffNumber table. |
Characteristic2 |
nvarchar(255), null Value for Characteristic2. Characteristics can be administered in the system settings: "Settings | System | Characteristics". |
Characteristic3 |
nvarchar(255), null Value for Characteristic3. Characteristics can be administered in the system settings: "Settings | System | Characteristics". |
Characteristic4 |
nvarchar(255), null Value for Characteristic4. Characteristics can be administered in the system settings: "Settings | System | Characteristics". |
Characteristic5 |
nvarchar(255), null Value for Characteristic5. Characteristics can be administered in the system settings: "Settings | System | Characteristics". |
|
Special Project Attributes |
Values of the special project attributes at embedded projects (sub-projects). The field label equals the internal attribute label. The data type equals the configured attribute type. |
WRPartCost
The table provides the cost information for parts.
Relations
| Field (WRPartCost) | Field | Table / View |
|---|---|---|
PartID |
PartID |
|
SurchargeID |
SurchargeID |
Field description
| Field | Description |
|---|---|
PartID
|
primary key, int, not null Internal ID of the part Information on the part can be determined via the foreign key (PartID) in the WRPart table. |
Year
|
primary key, int, not null The calculation year If the fiscal year does not start in January, the calendar year of the fiscal year start is returned. Example: For the fiscal year from June 2020 until May 2021, the value 2020 is returned. |
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 Fix unit cost in project currency. |
ValueVar
|
decimal(28,9), null Variable unit cost in project currency. |
ValueTotal
|
decimal(28,9), null Total unit cost (fix and variable) in project currency. |
ValueTotalVar
|
decimal(28,9), null Variable unit cost in project currency. |
|
As of version 6.4.6 Rate |
decimal(28,9), null Value of the surcharge rate at cost elements defined as percentage surcharge. Example: Material overhead cost of 4% are returned as 4. |
WRPartValidities
The table provides the attribute values with validities configured at the part. 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 (WRPartValidities) | Field | Table / View |
|---|---|---|
UnitID |
UnitID |
|
RefUnitID |
UnitID |
Field description
| Field | Description |
|---|---|
PartID |
primary key, int not null Internal ID of the part |
ColumnName |
primary key, nvarchar(255) not null Internal label of the attribute at the part with validities. |
Year
|
primary key, int not null The year for which the value is valid |
Value
|
float, null The value of the attribute Currently, only numeric values are provided by the export. |
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 Internal ID of the denominator unit The label of the unit can be determined via the foreign key (UnitID) in the WRUnits table. |
WRPartCountryGroup
Available as of version 10.1
The table provides the country group defined at the part. Country groups are used for the calculation of customs duties.
Relations
| Field (WRPartCountryGroup) | Field | Table / View |
|---|---|---|
CountryGroupID |
CountryGroupID |
Field description
| Field | Description |
|---|---|
PartID |
primary key, int not null Internal ID of the part |
Year
|
primary key, int not null The fiscal year |
CountryGroupID
|
int, null ID of the country group valid for the fiscal year. Information on the country group can be determined via the foreign key (CountryGroupID) in the WRDA_CountryGroup view. |